Download Oracle® Order Management

Transcript
Message Map
Table 7–28 ONT_3A8R_OAG72_IN.xgm
OAG
Comment/Desc
Re
qd
Y/N
Oracle OM
Table/Column
Oracle PO Table
/Column
OE_LINES_
INTERFACE.ordere
d_quantity
PO_ECX_LINE_
LOC_ARCH_
V.ordered_quantity
OE_LINES_
INTERFACE.order_
quantity_uom
(PO_LINE_
LOCATIONS_
ARCHIVE_
ALL.QUANTITY
-PO_LINE_
LOCATIONS_
ARCHIVE_
ALL.QUANTITY_
CANCELLED)
OE_LINES_
INTERFACE.custom
er_shipment_
number
PO_ECX_LINE_
LOC_ARCH_
V.shipment_um
<HOUR>00</HOUR>
<MINUTE>00</MINUTE>
<SECOND>00</SECOND>
<SUBSECOND>0000</SUBSECO
ND>
<TIMEZONE>-0600</TIMEZON
E>
</DATETIME>
<QUANTITY
qualifier="ORDERED">
Quantity of the item
ordered. This will be
the new qty.
<VALUE>a</VALUE>
<NUMOFDEC>a</NUMOFDEC
>
<SIGN>a</SIGN>
<UOM>a</UOM>
</QUANTITY>
<PSCLINENUM>a</PSCLINEN
UM>
Line number of the
delivery schedule
for the PO.
Y
7-104 Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide
PO_LINE_
LOCATIONS_
ARCHIVE_
ALL.SHIPMENT_
NUM