CMR_RCV_TAX_DIST_GT
Temporary table to store the distributions for which tax is called
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
RCV_TRANSACTION_ID | NUMBER | 18 | Receiving transaction identifier | |
PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase Order Line Location identifier. | |
TRANSACTION_ID | NUMBER | 18 | Foreign key reference to CMR_TRANSACTIONS | |
LATEST_CORRECT_TXN_ID | NUMBER | 18 | Stores the latest correction transaction identifier | |
PO_DISTRIBUTION_ID | NUMBER | 18 | Purchase Order Distribution identifier | |
TRX_LINE_QTY | NUMBER | Purchase Order net receipt quantity at PO line level. | ||
SOURCE_DOC_QTY | NUMBER | Receipt quantity prorated at distribution level | ||
PURCHASE_BASIS | VARCHAR2 | 30 | Identifies whether the PO line is for Goods or Services. Valid values are 'GOODS' and 'SERVICES' | |
TRANSACTION_AMT | NUMBER | Received transaction amount for service line type Purchase orders. And for Goods type purchase orders - Price and total ordered qty. | ||
DISTRIBUTION_NUMBER | VARCHAR2 | 40 | Purchase Order Distribution number | |
PO_HEADER_ID | NUMBER | 18 | Purchase order header Identifier and maps to {PO_HEADERS_ALL.PO_HEADER_ID} | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate on Purchase order and represents conversion value to ledger currency. | ||
EVENT_DATE | TIMESTAMP | Purchase Order event date and indicates the PO changes. | ||
TRX_DATE | TIMESTAMP | Transaction Date of the purchase order receipt. | ||
DIST_QTY | NUMBER | Distribution quantity on Purchase Order Document. | ||
TRANSACTION_TYPE | VARCHAR2 | 150 | Receiving Transaction Type of Purchase order receipts. | |
PARENT_TRANSACTION_ID | NUMBER | 18 | Parent Transaction Identifier of purchase order receipts. | |
PARENT_PO_LINE_LOCATION_ID | NUMBER | 18 | Parent purchase Order schedule location Identifier | |
PARENT_PO_DISTRIBUTION_ID | NUMBER | 18 | Parent purchase Order distribution Identifier | |
UNIT_PRICE | NUMBER | Purchase order unit price defined on po line. | ||
LINE_LEVEL_ACTION | VARCHAR2 | 30 | Line Level Action. Indicates the TAX API call passing source document identifier details. |