Oracle A75089-02 Manual de usuario descargar pdf (Pagina 123)

Interface File Data Report

Oracle e-Commerce Gateway Reports 9-3

External Value

Enter an external (transaction interface data file) value or leave blank to report on

all external values.

See Also

Submitting a Request, Oracle Applications User’s Guide

Interface File Data Report

Reports on all the data in a specified transaction interface data file.

The following table describes the interface data file definition format:

Table 9–1 Interface Data FIle Columns and Descriptions

Column Description

Field Description Data element description

Category The associated Code Conversion Category for general

code conversion.

Record Record numbers assigned by the set of data elements.

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 e-Commerce Gateway.

1 2 ... 118 119 120 121 122 123 124 125 126 127 128 ... 143 144

Sin comentarios

Oracle A75089-02 Manual de usuario Pagina 123