Total Pageviews

July 22, 2017

7/22/2017 10:45:00 PM
Data flow from Order Management to Receivables



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

 
Related Posts Plugin for WordPress, Blogger...