CML_TROP_CHRG_ACTUAL_SOURCES
This table is use to store the invoice details which are used at the time of allocation. Since allocation of charges to PO schedules and then application of these charges to receipts can happen at different points in time, we will capture the invoices used at the time of allocation.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_TROP_CHRG_ACTUAL_SRC_PK |
TRADE_OPERATION_CHARGE_ID, INVOICE_ID, INVOICE_LINE_NUMBER, EFFECTIVE_DATE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Surrogate ID identifying a trade operation charge line | |
| EFFECTIVE_DATE | TIMESTAMP | Yes | Effective date of the allocation. | ||
| INVOICE_ID | NUMBER | 18 | Yes | Identifies the invoice that is associated to this charge which contributes to the allocation amount. | |
| INVOICE_LINE_NUMBER | NUMBER | 18 | Yes | Invoice line number associated to the charge line. | |
| ENTERED_DATE | TIMESTAMP | Invoice entered date. Value captured from CML_CHARGE_INVOICE_ASSOCS table. | |||
| ACTIVE_FLAG | VARCHAR2 | 1 | Yes | Flag to identify if the source is associated to the latest run of actual allocation. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CML_TROP_CHRG_ACTUAL_SRC_PK | Unique | Default | TRADE_OPERATION_CHARGE_ID, INVOICE_ID, INVOICE_LINE_NUMBER, EFFECTIVE_DATE |