CST_GP_AP_INVOICE_DTLS_GT

Global temporary table used in the cost preprocessor. It holds the Global Procurement related AP invoice distribution information that came in from the AP Invoice interface and needs to be processed by the cost preprocessor.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: TEMP3

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CMR_AP_INVOICE_DISTRIBUTION_ID	NUMBER		18	Yes	Identifies Account Payables Invoice Distribution interfaced to Costing.
CMR_AP_INVOICE_LINE_ID	NUMBER		18		Identifies Account Payables Invoice Line interfaced to Costing.
INVOICE_BASE_AMOUNT	NUMBER				Invoice amount in functional currency.
INVOICE_QTY_IN_PRIMARY_UOM	NUMBER				Invoice quantity in the primary unit of measure of the item. Note that primary unit of measure here is the one in the trade inventory organization on the PO.
INVOICE_DISTRIBUTION_TYPE	VARCHAR2	25			This is the Invoice distribution type in the Accounts Payables Invoice interfaced to Costing. It Identifies the distribution type such as Accrual, Exchange Rate Variance, Freight, Invoice Price Variance, Item, Nonrecoverable tax, Miscellaneous etc.
CMR_PO_LINE_LOCATION_ID	NUMBER		18		Internal Identifier of the purchase order schedule.
INVOICING_BU_FUNC_CURR_CODE	VARCHAR2	15			Functional currency of the Invoicing business unit.
INVOICE_QTY	NUMBER				Quantity being invoiced in unit of measure code.