CMR_RETRO_PRICE_TXNS_GT

this table stores unprocessed transactions pertaining to retro price po line location

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
PO_LINE_LOCATION_ID	NUMBER		18	Purchase order shipment schedule identifier
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Receipt accounting purchase order line location identifier
PROFIT_CENTER_BU_ID	NUMBER		18	Profit center business unit identifier of goods receiving organization.
CMR_PO_DISTRIBUTION_ID	NUMBER		18	Single column FK: Identifies entity in Receipt accounting PO Distributions. This value will exist for match to PO as well as match to Receipt cases.
CMR_RCV_TRANSACTION_ID	NUMBER		18	Single Column FK: Identifies the receiving transaction.
RCV_TRANSACTION_ID	NUMBER		18	Receipt Transaction Identifier.
CURRENCY_CODE	VARCHAR2	15		Currency code of purchase order document.
CURRENCY_CONVERSION_TYPE	VARCHAR2	30		Currency conversion Type - Purchase Order conversion type used for currency conversion
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
DESTINATION_TYPE_CODE	VARCHAR2	25		Destination Type - Expense or Inventory or Manufacturing.
MATCH_OPTION	VARCHAR2	25		Invoice match option, 'P' indicaties match to Order, 'R' indicates match to Receipt.
NET_ACCT_QTY	NUMBER			net accounted quantity at Po distribution level for all receipts.
NET_RCPT_QTY	NUMBER			Net Received Quantity at Po distribution level for all receipts.
PO_UNIT_PRICE	NUMBER			purchase order unit price defined at PO line level.
PRIOR_PO_UNIT_PRICE	NUMBER			prior po unit price - purchase order unit price at line level.
NONRECOVERABLE_TAX	NUMBER			Nonrecoverable Tax on Purchase order
PRIOR_NONRECOVERABLE_TAX	NUMBER			Processed Nonrecoverable Tax on Purchase order
TAX_PRICE	NUMBER			Tax Price - Purchase Order price without taxes on it.
PRIOR_TAX_PRICE	NUMBER			Prior Tax Price - Purchase Order price without taxes on it.
INCLUSIVE_TAX_AMOUNT	NUMBER			Purchase Order distribution inclusive tax amount.
PRIOR_INCLUSIVE_TAX_AMOUNT	NUMBER			Purchase Order distribution processed inclusive tax amount.
TRANSACTION_ID	NUMBER		18	CMR Transaction Identifier - maps CMR_TRANSACTIONS.TRANSACTION_ID
EVENT_DATE	TIMESTAMP			Purchase order event date indicates the price change date.
BUDGETARY_CONTROL_FLAG	VARCHAR2	1		Purchase Order is eligible for Budgetary Control or not.
ENCUMBRANCE_ACCOUNTING_FLAG	VARCHAR2	1		Encumbrance Accounting Flag - Encumbrance Reversal accounting for purchase order and used for encumbrance accounting only.
TRANSFER_TO_OWNED_TXN_ID	NUMBER		18	Inventory transfer to owned transaction identifier with positive quantity to indicate quantity is moved inventory from consigned
INTERCOMPANY_INVOICING_FLAG	VARCHAR2	1		Flag to indicate if intercompany invoicing is enabled or not.