INV_CST_CONSLD_SALES_ORDERS_GT

This table holds the consolidated sales order input data that will passed as input to getOrderDetails service.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
TRANSACTION_ID NUMBER 18 Yes Identifies the inventory transaction.
FULFILLMENT_LINE_ID NUMBER 18 Yes This identifies the fulfillment line.
DELIVERY_ID NUMBER 18 This column identifies the shipment.
RMA_RECEIPT_TXN_ID NUMBER 18 Identifies the receipt transaction for return material authorization.
PROCESSED VARCHAR2 1 Indicate whether this record has been processed or not