Tuesday, July 14, 2015

Link between OE_ORDER_HEADERS_ALL and RA_CUSTOMER_TRX_ALL

RA_CUSTOMER_TRX_ALL will have header information

INTERFACE_HEADER_CONTEXT = 'ORDER ENTRY'
INTERFACE_HEADER_ATTRIBUTE1 = ORDER_NUMBER

RA_CUSTOMER_TRX_LINES_ALL will have invoice lines

INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
INTERFACE_LINE_ATTRIBUTE1 = ORDER_NUMBER
INTERFACE_LINE_ATTRIBUTE6 = OE_ORDER_LINES_ALL.LINE_ID
INTERFACE_LINE_ATTRIBUTE3 = WSH_NEW_DELIVERIES.DELIVERY_ID