CML_RCV_CHRG_ACTUAL_SOURCES
This table is used to store the invoice details which are used at the time of allocation of per unit actual amount to the PO receipts. This table will be used by the downstream processes to identify the invoice lines which are used to arrive at the allocation amount.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CML_RCV_CHRG_ACTUAL_SRCS_PK |
RCV_CHARGE_ACTUAL_ID, INVOICE_ID, INVOICE_LINE_NUMBER |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
RCV_CHARGE_ACTUAL_ID | NUMBER | 18 | Yes | Surrogate identifying a receipt charge actual. | |
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 | The date on which the invoice is entered. | |||
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_RCV_CHRG_ACTUAL_SRCS_PK | Unique | Default | RCV_CHARGE_ACTUAL_ID, INVOICE_ID, INVOICE_LINE_NUMBER |