CML_TROP_CHARGE_INVOICES_GT

This table will hold a snapshot of the CML_CHARGE_INVOICE_ASSOCS at the time of actual processing (for the charge lines being processed). At the end of processing this table will be used to populate the invoice sources into CML_TROP_CHRG_ACTUAL_SOURCES.

Details

• Schema: FUSION

• Object owner: CML

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Precision	Not-null	Comments
TRADE_OPERATION_CHARGE_ID	NUMBER	18	Yes	Surrogate identifying a trade operation charge line.
INVOICE_ID	NUMBER	18	Yes	Identifies the invoice that is associated to this charge which contributes to the allocation amount.
INVOICE_LINE_NUMBER	NUMBER	18	Yes	Invoice line number associated to the charge line.
ENTERED_DATE	TIMESTAMP			Invoice entered date captured from CML_CHARGE_INVOICE_ASSOCS.
INVOICE_FUNC_AMOUNT	NUMBER			Invoice amount in invoices functional currency.
INVOICE_FUNC_TAX	NUMBER			Invoice tax in invoices functional currency.