Receivables Interface & Data flow from Order Management to Receivables
Tables
RA_INTERFACE_LINES_ALL and RA_INTERFACE_SALESCREDITS_ALL
LINE_TYPE For Sales Order Line ‘LINE’ For Freight Charges ‘FREIGHT’ For Tax ‘TAX’ SALES_ORDER OE_ORDER_HEADERS.ORDER_NUMBER
SALES_ORDER_LINE OE_ORDER_LINES.LINE_NUMBER
PURCHASE_ORDER OE_ORDER_HEADERS.LINES.CUST_PO_NUMBER
INTERFACE_LINE_ATTRIBUTE2 Order Type Name
INTERFACE_LINE_ATTRIBUTE6 OE_ORDER_LINES.LINE_ID
INTERFACE_LINE_ATTRIBUTE10 OE_ORDER_LINES.SHIP_FROM_ORD_ID
INTERFACE_LINE_ATTRIBUTE12 OE_ORDER_LINES.shipment_number
INTERFACE_LINE_ATTRIBUTE13 OE_ORDER_LINES.option_number
INTERFACE_LINE_ATTRIBUTE14 OE_ORDER_LINES.service_number
Service Interface & Data flow from OM to Installed Base
Internal Order:
PO_REQUISITION_HEADERS_ALL
SEGMENT1 Requisition Number
AUTHORIZATION_STATUS APPROVED, IN PROCESS, INCOMPLETE TYPE_LOOKUP_CODE INTERNAL, PURCHASE
TRANSFERRED_TO_OE_FLAG Y
PO_REQUISITION_LINES_ALL
DESTINATION_TYPE_CODE INVENTORY, EXPENSE, SHOP FLOOR
DELIVER_TO_LOCATION_ID Internal Location which is attached to Internal Customer SOURCE_TYPE_CODE INVENTORY, VENDOR
