CST_SHIP_BILL_REF_OUTPUT_GT
Global temporary table used in the COGS Processor. It holds ship bill reference records returned by the shipment revenue mapping api.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| FULFILL_LINE_ID | NUMBER | 18 | Fullfillment Line identifier against which sales shipment transactions have been performed. | |
| FULFILLMENT_SPLIT_REF_ID | NUMBER | 18 | Fullfillment Line identifier against which sales shipment transactions have been performed. In case of split, reference to the unique identifier of the source fulfillment line. | |
| DELIVERY_NAME | VARCHAR2 | 120 | Identifies the delivery associated with sales shipment transactions. | |
| RMA_RECEIPT_TRANSACTION_ID | NUMBER | 18 | Surrogate ID identifying the RMA receipt transaction. | |
| BILLING_FULFILL_LINE_ID | NUMBER | 18 | Fullfillment line identifier against which the billing is done. | |
| BILL_ONLY_FLAG | VARCHAR2 | 1 | Indicates that the Billing Fullfill Line has no corresponding shipment lines. | |
| STATUS | VARCHAR2 | 30 | Indicates the status returned by shipment revenue mapping api. | |
| MESSAGE_CODE | VARCHAR2 | 30 | Indicates the message code returned by shipment revenue mapping api. | |
| MESSAGE_TEXT | VARCHAR2 | 960 | Indicates the message text returned by shipment revenue mapping api. | |
| SHIPMENT_LINE_ID | NUMBER | 18 | Identifies the Shipment Details. | |
| OPEN_REMNANT_MODEL_FLAG | VARCHAR2 | 1 | Indicates whether the shipment revenue mapping api returned an error because the fullfill line was associated with a remnant model that is not closed yet. | |
| INVENTORY_INTERFACED_FLAG | VARCHAR2 | 1 | A flag that indicates if the fulfillment is for the direct sales order issue. Possible values are: N: Not a direct sales order issue fulfillment. Y: Direct sales order issue fulfillment. |