CML_NEW_TROP_CHARGES_GT
This is a GT table created to hold all the new trade operation charges that were created since the last run of this process.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Surrogate ID that identifies a Trade Operation Charge. | |
| TRADE_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID that identifies a Trade Operation | |
| CHARGE_LINE_NUMBER | NUMBER | 18 | Yes | System generated unique charge line number for the charge line entered in a trade operation. | |
| PROCUREMENT_BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Surrogate id to identify procurement_bsuiness_unit_id | |
| CHARGE_ID | NUMBER | 18 | Yes | Surrogate ID that identifies a charge | |
| VENDOR_ID | NUMBER | 18 | Yes | Supplier id | |
| VENDOR_SITE_ID | NUMBER | 18 | Yes | Supplier site id | |
| TROP_DOC_CURRENCY_CONV_RATE | NUMBER | Trop Doc Currency Conversion Rate | |||
| SERVICE_PO_FLAG | VARCHAR2 | 1 | FLAG TO INDICATE SERVICE POs | ||
| CMR_PO_LINE_LOCATION_ID | NUMBER | 18 | PO SCHED ID FOR SERVICE POs | ||
| TRADE_OPERATION_STATUS_CODE | VARCHAR2 | 30 | Code indicating the status of trade operation. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CML_NEW_TROP_CHARGES_GT_N1 | Non Unique | TRADE_OPERATION_ID, TRADE_OPERATION_CHARGE_ID, PROCUREMENT_BUSINESS_UNIT_ID, VENDOR_ID, VENDOR_SITE_ID |