CMR_RCV_CHARGES_GT

This table stores unprocessed actual/estimate charges for the processed receipt transacations.

Details

• Schema: FUSION

• Object owner: CMR

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Comments
CMR_RCV_TRANSACTION_ID	NUMBER		18	Single Column FK: Identifies the receiving transaction.
TRANSACTION_ID	NUMBER		18	Transaction Identifier of eligible landed cost charges transactions
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Purchase order shipment schedule identifier.
TROP_CHARGE_LINE_ID	NUMBER		18	Identifies the trade operation charge line that has this actual/estimate defined.
CHARGE_ID	NUMBER		18	Identifies the Charge Name associated to the charge line.
FISCAL_DOC_LINE_ID	NUMBER		18	Fiscal document line identifier and maps to {CMF_FISCAL_DOC_LINES_B.DOCUMENT_LINE_ID}.
RCV_CHARGE_ALLOC_ID	NUMBER		18	Reference column to charges allocated fiscal document receipts.
RCV_CHARGE_ACTUAL_ID	NUMBER		18	Identifies the landed cost actual charge.
RCV_CHARGE_ESTIMATE_ID	NUMBER		18	Identifies the landed cost estimate charge.
EFFECTIVE_DATE	TIMESTAMP			Date and time on which actual/estimate was entered by the user/ allocation was run. Effective date of the landed cost actual/estimate charge.
UNIT_AMOUNT	NUMBER			Per unit allocated charge actual/estimate amount.
UNIT_TAX	NUMBER			Per unit allocated charge actual/estimate tax.
TOTAL_UNIT_AMOUNT	NUMBER			The sum of allocated charge actual/estimate UNIT_ AMOUNT and UNIT_TAX.
PRIOR_TOTAL_UNIT_AMOUNT	NUMBER			Unit amount of charge line. Accounted prior total unit amount.
CHARGE_BU_ID	NUMBER		18	Charge requisitioning business unit for this landed cost charge.
REQ_BU_ID	NUMBER		18	Requisition business unit on material purchase order.
CMR_SRV_PO_LINE_LOCATION_ID	NUMBER		18	Indicates the CMR_PO_LINE_LOCATION_ID of type purchase order service line.
SERVICE_PO_FLAG	VARCHAR2	1		Indicates if it is a service line type purchase order or not. Y - service line purchase order, N - not a service line purchase order.
CONSIGNED_FLAG	VARCHAR2	1		Consigned purchase Order indicator.
DESTINATION_TYPE_CODE	VARCHAR2	25		Identifies the type of destination for the material: Inventory, Expense.
TRANSACTION_TYPE	VARCHAR2	40		Identifies the transaction type.
CURRENCY_CODE	VARCHAR2	15		Identifies the currency of the price.
CURRENCY_CONVERSION_TYPE	VARCHAR2	30		Conversion type that should be used for currency conversion.
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate from the charge business unit currency to the material requisitioning business unit functional currency.
CURRENCY_CONVERSION_DATE	TIMESTAMP			Identifies the currency conversion date.
BILL_TO_BUSINESS_UNIT_ID	NUMBER		18	Bill to business unit identifier for this landed cost charge.
INTERCOMPANY_BILL_TO_BU_ID	NUMBER		18	Used in cross business unit case. For non cross business unit case it will be NULL.
SOURCE_DOC_NUMBER	VARCHAR2	50		Source document number - Purchase order number.
CMR_ROOT_RCPT_TXN_ID	NUMBER		18	Root Receipt transaction identifier for child transactions and receipt transaction identifier for receipts.
SOURCE_DOC_LINE_NUMBER	VARCHAR2	40		User specified number for the purchase order line.
SOURCE_DOC_SHIPMENT_NUMBER	VARCHAR2	40		User specified number for the purchase order shipment.
SOURCE_DOC_DISTRIB_NUMBER	VARCHAR2	40		User specified number for the purchase order distribution.
VENDOR_ID	NUMBER		18	Identifies the supplier and references to {POZ_SUPPLIERS.vendor_id}.
VENDOR_SITE_ID	NUMBER		18	Identifies the supplier site and references to {POZ_SUPPLIER_SITES_ALL_M.vendor_site_id}.
SHIP_TO_LOCATION_ID	NUMBER		18	The identifier of the specific location that the goods are being shipped.
PO_ITEM_DESCRIPTION	VARCHAR2	240		Item description specified in purchase order line. Especially needed for purchase orders involving non inventory items.
PO_LINE_LOCATION_ID	NUMBER		18	Purchase order shipment schedule identifier.

Indexes

Index	Uniqueness	Columns
CMR_RCV_CHARGES_GT_N1	Non Unique	RCV_CHARGE_ACTUAL_ID
CMR_RCV_CHARGES_GT_N2	Non Unique	RCV_CHARGE_ESTIMATE_ID