CML_RCV_CHARGE_ESTIMATES_GT

This global temporary table will be used to store the receipt estimates while the system calculates the unit amount at receipt level. Once the calculation is over these rows will be stored in CML_RCV_CHARGE_ESTIMATES_GT.

Details

• Schema: FUSION

• Object owner: CML

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_RCV_TRANSACTION_ID	NUMBER		18	Yes	Surrogate ID that identifies a PO receipt or transfer order receipt in Receipt Accounting.
TRADE_OPERATION_ID	NUMBER		18	Yes	Single column FK: Identifies the trade operation associated with this charge.
TRADE_OPERATION_CHARGE_ID	NUMBER		18	Yes	Single column FK: Identifies the trade operation charge line associated with this charge.
CHARGE_LINE_NUMBER	NUMBER		9	Yes	Trade Operation Charge line number this estimate was defined on.
REQ_BU_ID	NUMBER		18	Yes	Surrogate ID that identifies the Charge Requisitioning Business Unit for this charge.
CHARGE_ID	NUMBER		18	Yes	Single column FK: Identifies the charge name for this charge.
CMR_PO_LINE_LOCATION_ID	NUMBER		18	Yes	Single column FK: Identifies the material PO schedule or transfer order shipment line associated with this charge.
UNIT_AMOUNT	NUMBER			Yes	Per unit allocated estimate amount.
UNIT_TAX	NUMBER			Yes	Per unit allocated estimate tax.
SOURCE_DOC_UOM_CODE	VARCHAR2	3		Yes	Source document UOM code on the Receipt Transaction. Per unit amounts are stored in this UOM.
TRACKED_UOM_CODE	VARCHAR2	3			Tracked UOM code on the trade operation material PO schedule or transfer order shipment line association.
UOM_CONVERSION_FACTOR	NUMBER				UOM conversion factor from tracked UOM to source doc UOM.
CURRENCY_CODE	VARCHAR2	15		Yes	Charge Requisitioning BU currency. Amounts in this table are stored in this currency.
ESTIMATE_ENTERED_DATE	TIMESTAMP			Yes	Effective date of the estimate. Holds the date and time at which the estimate was created.
ACCRUAL_OPTION	VARCHAR2	30		Yes	Accrual option for the charge line. For charge lines associated to service Pos this will be set to NO_ACCRUAL. For other cases it is set to MATERIAL_RECEIPT.
CMR_SRV_PO_LINE_LOCATION_ID	NUMBER		18		Single column FK: Identifies the service PO schedule to which this charge is associated.
SHIP_TO_ORGANIZATION_ID	NUMBER		18	Yes	This column stores receiving organization unique identifier where the receiving transaction is created.
MAT_REQ_BU_FUNC_CURRENCY_CODE	VARCHAR2	15			Functional currency code of the business unit of receiving organization in the transfer order.
PO_LINE_LOCATION_ID	NUMBER		18		Purchase order shipment schedule identifier.