CML_CHARGE_INVOICE_ASSOCS_GT
This table would be used to store the associations when the association processor is running. This woud be a temporary table and the values would be finally flushed to cml_charge_invoice_assocs table.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHARGE_INVOICE_ASSOC_ID | NUMBER | 18 | Yes | Surrogate id for the associations table | |
| USER_COMMENTS | VARCHAR2 | 2000 | Column to persist user comments. | ||
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Surrogate id in the Trade Operation Charges table | |
| INVOICE_ID | NUMBER | 18 | Yes | The invoice Id of the invoice associated to the Trade Operation. | |
| INVOICE_LINE_NUMBER | VARCHAR2 | 40 | Yes | The invoice line number associated to the Trade Operation | |
| ENTERED_DATE | TIMESTAMP | Yes | The sysdate on which the actual are established/ cancelled. Effective date for the association. | ||
| INVOICE_AMOUNT | NUMBER | The charge invoice amount in invoice currency coming from AP | |||
| INVOICE_TAX | NUMBER | The tax amount in invoice currency | |||
| FUNC_CURRENCY_AMOUNT | NUMBER | The charge invoice amount in Functional currency in AP | |||
| FUNC_CURRENCY_TAX | NUMBER | The tax amount in functional currency | |||
| FUNC_CURRENCY_CODE | VARCHAR2 | 15 | Functional currency coming from AP | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Charge invoice currency code | ||
| ASSOCIATION_MODE | NUMBER | 9 | Yes | Indicates whether the Invoice line is automatic or manual associated. | |
| ASSOCIATION_STATUS | NUMBER | 9 | Yes | Indicates the match status.(Associated/Needs Review/Deleted/Rejected/Associated) | |
| RANK | NUMBER | 9 | Would indicate the rank for good matches | ||
| TROP_DOC_CURR_CONV_RATE | NUMBER | Currency conversion rate to convert to Trade operation document currency from the invoice currency | |||
| ACTIVE_FLAG | VARCHAR2 | 1 | Y/N to indicate if the association is active or not? Would be used pre dominantly for associations that are getting updated and deleted. Rest of the rows will have null values. | ||
| EXISTING_ASSOCIATION_FLAG | VARCHAR2 | 1 | Would indicate if this was an old assoc or created newly. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | This column would be used to capture the External system ref. This would help us in cases of po_line_location id and invoice id | ||
| ERROR_CODE | VARCHAR2 | 20 | Would be used to identify warning and error messages |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CML_CHARGE_INV_ASSOCS_GT_N1 | Non Unique | INVOICE_ID, INVOICE_LINE_NUMBER, TRADE_OPERATION_CHARGE_ID, ASSOCIATION_STATUS, CHARGE_INVOICE_ASSOC_ID, ACTIVE_FLAG |