CMR_BU_PO_DISTS_GT

This table stores all PO distributions belonging to single BU.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Comments	Status
PO_LINE_LOCATION_ID	NUMBER		18	Purchase order shipment schedule identifier.	Active
PO_HEADER_ID	NUMBER		18	Purchase order document header unique identifier (References PO_HEADERS_ALL.PO_HEADER_ID).
PO_LINE_ID	NUMBER		18	Purchase order document line unique identifier (References PO_LINES_ALL.PO_LINE_ID).
ATTRS_MODIFIED_IN_CO	VARCHAR2	80		Comma separated list of attributes that are modified in change order.
SOURCE_DOC_NUMBER	VARCHAR2	50		Source document number based on transaction. For Purchase order flows - PO number.
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Receipt accounting PO line location id.
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.
PROFIT_CENTER_BU_ID	NUMBER		18	Profit center business unit identifier of inventory organization.
TRADE_ORGANIZATION_ID	NUMBER		18	Supplier facing inventory organization identifier.
CMR_ROOT_RECEIVE_TXN_ID	NUMBER		18	Internal root/first receiving transaction identifier.
MATCH_OPTION	VARCHAR2	25		Indicates whether the invoice match should happen at the purchase order or the receipt. Valid values are P for PO, and R for Receipt.	Active
RETROACTIVE_DATE	TIMESTAMP			Price changed date on purchase order line. It is retro price event date.	Active
PO_UNIT_PRICE	NUMBER			Purchase order unit price defined on line.	Active
NONRECOVERABLE_TAX	NUMBER			Non recoverable tax (per unit) amount.	Active
INCLUSIVE_TAX_AMOUNT	NUMBER			Purchase Order distribution inclusive tax amount.
QUANTITY_ORDERED	NUMBER			Quantity of the material ordered for this distribution.	Active
SOURCE_DOC_UOM_CODE	VARCHAR2	25		Source document unit of measure and same as Purchase order UOM.
BILL_TO_BUSINESS_UNIT_ID	NUMBER		18	Business unit identifier where invoice is created.	Active
DELIVER_TO_BUSINESS_UNIT_ID	NUMBER		18	Business unit of the inventory organization.
INVENTORY_ITEM_ID	NUMBER		18	Inventory item identifier and references (EGP_SYSTEM_ITEMS_B.inventory_item_id).	Active
DELIVER_TO_INVENTORY_ORG_ID	NUMBER		18	Inventory organization where the material is scheduled to be received.	Active
DESTINATION_TYPE_CODE	VARCHAR2	25		Identifies type of destination for the material: Inventory, Expense.
CURRENCY_CODE	VARCHAR2	15		Identifies currency of the price.	Active
CURRENCY_CONVERSION_TYPE	VARCHAR2	30		Conversion type that should be used for currency conversion.	Active
CURRENCY_CONVERSION_DATE	TIMESTAMP			The date to be used to determine the exchange rates for currency conversion.	Active
CURRENCY_CONVERSION_RATE	NUMBER			Optional user specified currency conversion rate.	Active
LEDGER_ID	NUMBER		18	Ledger ID of the Business Unit.
SOURCE_ACCOUNT_ID	NUMBER		18	Source account identifier defined on transaction source document.
RECOVERABLE_INCLUSIVE_TAX	NUMBER			Recoverable tax defined on purchase distribution. This value is used liquidation amount calculation for price change.
ALLOW_PO_CHANGE	VARCHAR2	1		Allow purchase order attribute changes. Y means PO change order is allowed and N means not allowed.
PURCHASE_BASIS	VARCHAR2	30		Indicates service or goods type purchase order.