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 |