CMR_RETRO_PRICE_PO_DTLS

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 Line Location identifier
EVENT_DATE	TIMESTAMP			Purchase Order status change event Date
DELIVER_TO_INVENTORY_ORG_ID	NUMBER		18	Deliver To Inventory organization Identifier
INVENTORY_ITEM_ID	NUMBER		18	Inventory Item Identifier and References {EGP_SYSTEM_ITEMS_B.inventory_item_id}.
PRICE	NUMBER			Purchase order unit price defined po line.
PURCHASE_BASIS	VARCHAR2	30		Purchase Basis - goods or service type of PO.
MATCH_OPTION	VARCHAR2	25		Match Option - Receipt or Purchase Order or Consigned.
DESTINATION_TYPE_CODE	VARCHAR2	25		Destination Type - Expense or Inventory or Manufacturing
CURRENCY_CODE	VARCHAR2	15		Currency code - indicates the Purchase Order currency
DELIVER_TO_BU_FUNC_CURR_CODE	VARCHAR2	15		Functional currency code - Indicates the Purchase Order ledger currency.
CURRENCY_CONVERSION_TYPE	VARCHAR2	30		Currency conversion type - Conversion used for foreign currency PO to ledger currency
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate - Conversion used for foreign currency PO to ledger currency
CURRENCY_CONVERSION_DATE	TIMESTAMP			Currency conversion date - Conversion used for foreign currency PO to ledger currency
BILL_TO_BUSINESS_UNIT_ID	NUMBER		18	Bill To Business Unit of Purchase Order document
VENDOR_ID	NUMBER		18	Identifies the Supplier and {References PO_VENDORS.vendor_id}
VENDOR_SITE_ID	NUMBER		18	Identifies the Supplier Site and References {PO_VENDOR_SITES_ALL.vendor_site_id}
SHIP_TO_LOCATION_ID	NUMBER		18	Ship to location identifier of purchase order goods.
PO_HEADER_ID	NUMBER		18	PO Header Identifier and maps to {PO_HEADERS_ALL.PO_HEADER_ID}
CATEGORY_ID	NUMBER		18	Item category Identifier. Defined on purchase order document.
CONSIGNED_FLAG	VARCHAR2	1		Consigned Flag - indicates the Purchase order is consigned PO or not.
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	2		Country of origin code - TAX API call attribute
PO_DISTRIBUTION_ID	NUMBER		18	Purchase order distribution Identifier.
DISTRIBUTION_NUMBER	VARCHAR2	40		Purchase Order Distribution Number.
CMR_PO_DISTRIBUTION_ID	NUMBER		18	Receipt accounting PO Distribution Identifier.
QUANTITY	NUMBER			Purchase Order distribution ordered quantity
SHIPMENT_NUMBER	VARCHAR2	30		Purchase Order Shipment Number defined on PO document.