Previous  Next          Contents  Index  Navigation  Glossary  Library

Data File Definition Format Legend

The data file definition format is described in the following table:

Column Description
Field Description Data element description
Category The associated Code Conversion Category for general code conversion. You may define your own code conversion category for similar data.
Record Record numbers assigned by the EDI Gateway.
Format Attribute of the Data: (Char or Varchar2) is alphanumeric characters. (Number) is numeric. (Date) for date format YYYYMMDD HHMMSS, where, for the date portion, YYYY indicates the four digit year (1997, not 97), MM is month, and DD is day. The time portion, HHMMSS, where HH indicates hours, MM indicates minutes, and SS indicates seconds. The time portion is 000000 if not needed. (Note the space between date and time.)
Position Relative position among the business data within the given record, starting in position 101.
Width Data element width. This data is likely to be shorter than data defined in the Oracle Application to align the data with the standards.
Start Starting position of the data within the given record.
Application Table For outbound transactions, application table is the source table of the Oracle data from which the data is extracted. For inbound transactions, the table is the interim interface table of the Oracle application open interface (API) to receive the data from the EDI Gateway.
Application Column For outbound transactions, application column is the source column of the Oracle data within the Application Table. For inbound transactions, the application column is the column within the interim Application Table of the Oracle application open interface (API) to receive the data.


         Previous  Next          Contents  Index  Navigation  Glossary  Library