Tuesday 11 March 2014

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             =          line_id from oe_order_lines_all
INTERFACE_LINE_ATTRIBUTE3             =          delivery_id from wsh_new_deliveries

RA_INTERFACE_LINES_ALL will have invoice lines
INTERFACE_LINE_CONTEXT                             =          ‘ORDER ENTRY’
INTERFACE_LINE_ATTRIBUTE1             =          order_number
INTERFACE_LINE_ATTRIBUTE3             =          delivery_id from wsh_new_deliveries

No comments:

Post a Comment