CMR_RCV_INVOICE_QTY_GT
this table stores net received quantity and invoiced quantity for each po line location
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Precision | Comments |
---|---|---|---|
PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order shipment schedule identifier |
CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | Receipt accounting purchase order scheduler identifier. |
CMR_PO_DISTRIBUTION_ID | NUMBER | Receipt Accounting PO distribution Identifier | |
PROFIT_CENTER_BU_ID | NUMBER | 18 | Profit Center business unit of inventory organization. |
RECEIVED_QTY | NUMBER | Purchase order schedule's net received quantity. | |
INVOICED_QTY | NUMBER | Purchase order schedule's net invoiced quantity. | |
TRADE_QTY | NUMBER | Purchase order schedule's net owned quantity of consigned transfer purchase order receipts. | |
CMR_RCV_TRANSACTION_ID | NUMBER | 18 | Single Column FK: Identifies the receiving transaction. |
RCV_TRANSACTION_ID | NUMBER | 18 | Receipt Transaction Identifier. |
TRANSACTION_ID | NUMBER | 18 | Transaction Identifier |
CURRENCY_CONVERSION_RATE | NUMBER | Optional user specified currency conversion rate. | |
CURRENCY_CONVERSION_DATE | TIMESTAMP | The date to be used to determine the exchange rates for currency conversion | |
TAX_PRICE | NUMBER | Tax Price - Total tax price returned by TAX API call for this receipt transaction. |