CMR_RCV_TAX_DIST

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.
MATCH_OPTION	VARCHAR2	25		Indicates whether the invoice match should happen at the purchase order or the receipt.