1. Tables and Views for SCM
  2. CML_CHARGE_INVOICE_ASSOC_DTLS

CML_CHARGE_INVOICE_ASSOC_DTLS

This table stores all the invoice association details. The basic criteria for associations are proc bu id, supplier id and supplier site id. In addition the process would look at the ref types and charge id.

Details

  • Schema: FUSION

  • Object owner: CML

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CML_CHARGE_INV_ASSOC_DTLS_PK

CHARGE_INVOICE_ASSOC_DTLS_ID

Columns

Name Datatype Length Precision Not-null Comments
CHARGE_INVOICE_ASSOC_DTLS_ID NUMBER 18 Yes Surrogate identifying the charge and invoice association details.
CHARGE_INVOICE_ASSOC_ID NUMBER 18 Yes Surrogate id for the parent table.
ASSOCIATION_ATTRIBUTE_TYPE VARCHAR2 3 Yes Basis for association. Values-Supplier,Supplier Site,,Charge Name,Reference Value
INVOICE_LINE_CHARGE_ID NUMBER 18 Charge Id on the Invoice Line ID
CHARGE_LINE_CHARGE_ID NUMBER 18 Charge Id on the charge Line ID
INVOICE_LINE_SUPPLIER_ID NUMBER 18 Supplier ID on the Invoice Line
CHARGE_LINE_SUPPLIER_ID NUMBER 18 Surrogate identifying the supplier on the charge line.
INVOICE_LINE_SUPPLIER_SITE_ID NUMBER 18 Supplier Site ID on the Invoice Line
CHARGE_LINE_SUPPLIER_SITE_ID NUMBER 18 Supplier Site ID on the Charge Line
CHARGE_LINE_REF_VALUE_VARCHAR VARCHAR2 60 Alphanumeric ref value on the charge line
INVOICE_LINE_REF_VALUE_VARCHAR VARCHAR2 60 Alphanumeric ref value on the invoice line
CHARGE_LINE_REF_VALUE_NUMBER NUMBER Numeric ref value on the charge line
INVOICE_LINE_REF_VALUE_NUMBER NUMBER Numeric ref value on the invoice line
CHARGE_LINE_REF_VALUE_TSTAMP TIMESTAMP Timestamp ref value on the charge line
INVOICE_LINE_REF_VALUE_TSTAMP TIMESTAMP Timestamp ref value on the invoice line
REFERENCE_TYPE_ID NUMBER 18 Surrogate identifying the charge reference type.
MATCH_STATUS VARCHAR2 3 Yes Flag to identify the match status
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
CML_CHARGE_INVOICE_ASSOC_DTLS cml_charge_invoice_assocs CHARGE_INVOICE_ASSOC_DTLS_ID

Indexes

Index Uniqueness Tablespace Columns
CML_CHARGE_INV_ASSOC_DTLS_N1 Non Unique Default CHARGE_INVOICE_ASSOC_ID, ASSOCIATION_ATTRIBUTE_TYPE, REFERENCE_TYPE_ID
CML_CHARGE_INV_ASSOC_DTLS_UK1 Unique Default CHARGE_INVOICE_ASSOC_DTLS_ID