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. |