CML_INV_ESTIMATES_GT
This would be a GT table. All the temp associations for the LCM AP analytic widget would be stored in this table.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_INV_ESTIMATES_GT_PK |
INV_ESTIMATES_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INV_ESTIMATES_ID | NUMBER | 18 | Yes | This would be the surrogate key for this table. | |
| INVOICE_ID | NUMBER | 18 | Yes | Invoice ID for the estimates | |
| TRADE_OPERATION_ID | VARCHAR2 | 20 | Yes | Fk to Trade Operation Id in the CML_TRADE_OPERATIONS table. | |
| INVOICE_LINE_NUMBER | VARCHAR2 | 40 | Yes | Uniquely identifies the line within an invoice. | |
| NAME | VARCHAR2 | 80 | Trade Operation Name | ||
| TRADE_OPERATION_NUMBER | VARCHAR2 | 40 | Yes | Unique number that identifies a trade operation within a procurement business unit. | |
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | FK to the Trade Operation Charge ID in the Cml_Trade_Operation_Charges table. | |
| CHARGE_LINE_NUMBER | NUMBER | 9 | Yes | Trade Operation Charge Line Number. | |
| CHARGE_ID | NUMBER | 18 | Yes | The Charge Id specified on the Trade Operation Charge Line. | |
| ENTERED_AMOUNT | NUMBER | Entered Estimate Amount. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency Code for the Estimate Amount. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CML_INV_ESTIMATES_GT_U1 | Unique | INV_ESTIMATES_ID |