CREATE TABLE cml_charge_invoice_assoc_dtls (
    CHARGE_INVOICE_ASSOC_DTLS_ID      NUMBER(18, 0),
    CHARGE_INVOICE_ASSOC_ID           NUMBER(18, 0)    NOT NULL,
    ASSOCIATION_ATTRIBUTE_TYPE        VARCHAR2(12)     NOT NULL,
    INVOICE_LINE_CHARGE_ID            NUMBER(18, 0),
    CHARGE_LINE_CHARGE_ID             NUMBER(18, 0),
    INVOICE_LINE_SUPPLIER_ID          NUMBER(18, 0),
    CHARGE_LINE_SUPPLIER_ID           NUMBER(18, 0),
    INVOICE_LINE_SUPPLIER_SITE_ID     NUMBER(18, 0),
    CHARGE_LINE_SUPPLIER_SITE_ID      NUMBER(18, 0),
    CHARGE_LINE_REF_VALUE_VARCHAR     VARCHAR2(256),
    INVOICE_LINE_REF_VALUE_VARCHAR    VARCHAR2(256),
    CHARGE_LINE_REF_VALUE_NUMBER      NUMBER       ,
    INVOICE_LINE_REF_VALUE_NUMBER     NUMBER       ,
    CHARGE_LINE_REF_VALUE_TSTAMP      TIMESTAMP(6) ,
    INVOICE_LINE_REF_VALUE_TSTAMP     TIMESTAMP(6) ,
    REFERENCE_TYPE_ID                 NUMBER(18, 0),
    MATCH_STATUS                      VARCHAR2(12)     NOT NULL,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)     NOT NULL,
    CREATED_BY                        VARCHAR2(256)    NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128),
    CHARGE_INVOICE_ASSOC_DTLS_ID      NUMBER(18, 0),
    CHARGE_INVOICE_ASSOC_ID           NUMBER(18, 0)    NOT NULL,
    ASSOCIATION_ATTRIBUTE_TYPE        VARCHAR2(12)     NOT NULL,
    INVOICE_LINE_CHARGE_ID            NUMBER(18, 0),
    CHARGE_LINE_CHARGE_ID             NUMBER(18, 0),
    INVOICE_LINE_SUPPLIER_ID          NUMBER(18, 0),
    CHARGE_LINE_SUPPLIER_ID           NUMBER(18, 0),
    INVOICE_LINE_SUPPLIER_SITE_ID     NUMBER(18, 0),
    CHARGE_LINE_SUPPLIER_SITE_ID      NUMBER(18, 0),
    CHARGE_LINE_REF_VALUE_VARCHAR     VARCHAR2(256),
    INVOICE_LINE_REF_VALUE_VARCHAR    VARCHAR2(256),
    CHARGE_LINE_REF_VALUE_NUMBER      NUMBER       ,
    INVOICE_LINE_REF_VALUE_NUMBER     NUMBER       ,
    CHARGE_LINE_REF_VALUE_TSTAMP      TIMESTAMP(6) ,
    INVOICE_LINE_REF_VALUE_TSTAMP     TIMESTAMP(6) ,
    REFERENCE_TYPE_ID                 NUMBER(18, 0),
    MATCH_STATUS                      VARCHAR2(12)     NOT NULL,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)     NOT NULL,
    CREATED_BY                        VARCHAR2(256)    NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128),
    CONSTRAINT pk_cml_charge_invoice_assoc_dtls PRIMARY KEY (CHARGE_INVOICE_ASSOC_DTLS_ID, CHARGE_INVOICE_ASSOC_DTLS_ID)
);
