CML_INV_ASSOC_DTLS_GT
This table would be a GT table. This would store all the association details required for the CML AP widget analytic.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_INV_ASSOC_DTLS_GT_PK |
INV_ASSOC_DTLS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INV_ESTIMATES_ID | NUMBER | 18 | Yes | FK to the surrogate key of the charge estimates. | |
| INV_ASSOC_DTLS_ID | NUMBER | 18 | Yes | sURROGATE KEY FOR THIS TABLE. | |
| ASSOCIATION_ATTRIBUTE_TYPE | VARCHAR2 | 3 | Yes | The association attrib type would specify if the particular row is pertaining to comparison based on charge id or supplier id or suppliersite id or references. | |
| INVOICE_LINE_CHARGE_ID | NUMBER | 18 | Charge Id on the Invoice Line. | ||
| CHARGE_LINE_CHARGE_ID | NUMBER | 18 | Charge Id mentioned on the Trade OPeration Charge Line. | ||
| INVOICE_LINE_SUPPLIER_ID | NUMBER | 18 | Supplier Id mentioned in the Invoice Line. | ||
| CHARGE_LINE_SUPPLIER_ID | NUMBER | 18 | Supplier Id mentioned in the Trade Operation Charge Line. | ||
| INVOICE_LINE_SUPPLIER_SITE_ID | NUMBER | 18 | Supplier Site Id mentioned in the Invoice Line. | ||
| CHARGE_LINE_SUPPLIER_SITE_ID | NUMBER | 18 | THe supplier site id mentioned in the Trade Operation Charge Line. | ||
| CHARGE_LINE_REF_VALUE_VARCHAR | VARCHAR2 | 60 | Varchar type reference value specified in the Trade Operation Charge Line. | ||
| INVOICE_LINE_REF_VALUE_VARCHAR | VARCHAR2 | 60 | The varchar type reference value specified in the Invoice Line. | ||
| CHARGE_LINE_REF_VALUE_NUMBER | NUMBER | Number type reference value specified in the Trade Operation Charge Line. | |||
| INVOICE_LINE_REF_VALUE_NUMBER | NUMBER | Number type reference value specified in the Invoice Line. | |||
| CHARGE_LINE_REF_VALUE_TSTAMP | TIMESTAMP | Timestamp type reference value specified in the Trade Operation Charge Line. | |||
| INVOICE_LINE_REF_VALUE_TSTAMP | TIMESTAMP | Timestamp based reference value specified in the Invoice Line. | |||
| REFERENCE_TYPE_ID | NUMBER | 18 | Reference Type ID for the reference based comparisons. | ||
| MATCH_STATUS | VARCHAR2 | 3 | Yes | Flag to identify the invoice match status. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CML_INV_ASSOC_DTLS_GT_U1 | Unique | INV_ASSOC_DTLS_ID |