CML_INV_REF_VALUES_GT
This table would be a GT table which would hold the ref values for an invoice line . This would be used in the LCM AP widget analytic.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_INV_REF_VALUES_GT_PK |
INVOICE_ID, INVOICE_LINE_NUMBER, PRC_BU_ID, CHARGE_REF_TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INVOICE_ID | NUMBER | 18 | Yes | This would point to the invoice id of the invoice line. | |
| INVOICE_LINE_NUMBER | VARCHAR2 | 40 | Yes | This column would point to the invoice line number. | |
| PRC_BU_ID | NUMBER | 18 | Yes | This column would hold the procurement bu id. | |
| CHARGE_REF_TYPE_ID | NUMBER | 18 | Yes | This column has the Charge Reference Type | |
| CHARGE_REF_VALUE_DATA_TYPE | VARCHAR2 | 30 | Reference Value Data Type | ||
| REFERENCE_TYPE_VARCHAR | VARCHAR2 | 64 | Varchar type reference values | ||
| REFERENCE_TYPE_NUMBER | NUMBER | Number based reference values | |||
| REFERENCE_TYPE_TIMESTAMP | TIMESTAMP | Timestamp based reference values |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CML_INV_REF_VALUES_GT_U1 | Unique | INVOICE_ID, INVOICE_LINE_NUMBER, PRC_BU_ID, CHARGE_REF_TYPE_ID |