Assigning Column Rules
Interface Data File
5-7
See Also
Inbound Exception Processing
on page 6-2
Changing the Interface Data File Record Layout
on page 5-2
Assigning Column Rules
on page 5-7
Assigning Column Rules
Use the Assign Column Rules window to assign one to six data validation rules to
any data element. You can assign multiple column rules to any column. You can
also assign the same column rule type multiple times.
In a few transactions, required data fields may have been seeded with the required
data element rule. You can remove that requirement, but the application’s open
interface may fail its required data edit.
If needed, you can disable a column rule.
The Assign Column Rules window shows a column in the selected transaction and
all associated column rules. These fields are read-only. For each of the column rules,
select the appropriate action. Certain column rules require additional parameters
that appear in other windows.
The column rules listed below:
Table 5–2
Column Rules and Additional Parameters
Column Rule
Description
Additional Parameters Needed
Datatype Checking
Compare the
datatypes of the data
in the file to the
datatype defined in
the e-Commerce
Gateway transaction
table ECE_
INTERFACE_
COLUMNS.
None required.
Default if Null
Move a default value
to the staging table
column if the field is
null (blank) in the
interface data file.
The default can either be a literal (a constant)
or from a value in another column. Check
either Literal Value or Column Name to
indicate the source of the default value. Then
enter the value of the column name
depending on the box chosen.
Summary of Contents for e-Commerce Gateway 11i.2
Page 1: ...Oracle e Commerce Gateway User s Guide Release 11i 2 August 2000 Part No A75089 02...
Page 6: ...vi Oracle e Commerce Gateway User s Guide...
Page 18: ...xviii...
Page 42: ...Defining Trading Partner Data 3 8 Oracle e Commerce Gateway User s Guide...
Page 68: ...Assigning Column Rules 5 10 Oracle e Commerce Gateway User s Guide...
Page 78: ...Viewing Column Violations 6 10 Oracle e Commerce Gateway User s Guide...
Page 128: ...Viewing the Status of Concurrent Programs 9 8 Oracle e Commerce Gateway User s Guide...
