Download Oracle® e-Commerce Gateway

Transcript
Oracle
Applications
Column Name
for Fields
Oracle
e-Commerce
Gateway
Column Name
Hardcoded/Deri
ved
Record Number
Position
Number
CREATED_BY
CREATED_BY
Derived from the
Requester ID for
the concurrent
manager request
that.
CREATION_DA
TE
CREATION_DA
TE
Set to SYSDATE
LAST_UPDATE
_DATE
LAST_UPDATE
_DATE
Set to SYSDATE
LAST_UPDATE
D_BY
LAST_UPDATE
D_BY
Derived from the
Requester ID for
the concurrent
manager request
that.Please check
ORDER_SOURC
E_ID
ORDER_SOURC
E_ID
Hard code: 6
meaning EDI
SOLD_TO_ORD
_ID
SOLD_TO_ORD
_ID
Derived during
the Trading
Partner lookup
given the EDI
Location code
and Translator
code on Control
Record 0010
Sample columns from the OE_LINES_INTERFACES table:
Application Transaction Detail 6-29