CREATE TABLE jg_exg_rate_dif_line (
    ER_DIF_LINE_ID              NUMBER(18, 0),
    ER_DIF_ID                   NUMBER(18, 0),
    AE_LINE_NUM                 NUMBER(18, 0)    NOT NULL,
    LINE_NUM                    NUMBER(18, 0)    NOT NULL,
    LINE_TYPE_LOOKUP_CODE       VARCHAR2(100)    NOT NULL,
    ERD_AMT                     NUMBER           NOT NULL,
    TAX_AMT                     NUMBER       ,
    LINE_DIST_ID                NUMBER(18, 0),
    APPL_TO_DIST_ID             NUMBER(18, 0),
    CUST_TRX_LINE_ID            NUMBER(18, 0),
    TAX_RATE_CODE               VARCHAR2(600),
    TAX_CODE_ID                 NUMBER(18, 0),
    TAX_CLASSIFICATION_CODE     VARCHAR2(120),
    TAXES_APPLIED               VARCHAR2(600),
    TAX_RATE                    NUMBER       ,
    TAX                         VARCHAR2(120),
    TAX_CCID                    NUMBER(18, 0),
    AMOUNT_INCLUDES_TAX_FLAG    VARCHAR2(4)  ,
    SLA_CCID                    NUMBER(18, 0),
    AWT_GROUP_ID                NUMBER(18, 0),
    CUST_GAIN_CCID              NUMBER(18, 0),
    CUST_LOSS_CCID              NUMBER(18, 0),
    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),
    OBJECT_VERSION_NUMBER       NUMBER(9, 0)     NOT NULL,
    ER_DIF_LINE_ID              NUMBER(18, 0),
    ER_DIF_ID                   NUMBER(18, 0),
    AE_LINE_NUM                 NUMBER(18, 0)    NOT NULL,
    LINE_NUM                    NUMBER(18, 0)    NOT NULL,
    LINE_TYPE_LOOKUP_CODE       VARCHAR2(100)    NOT NULL,
    ERD_AMT                     NUMBER           NOT NULL,
    TAX_AMT                     NUMBER       ,
    LINE_DIST_ID                NUMBER(18, 0),
    APPL_TO_DIST_ID             NUMBER(18, 0),
    CUST_TRX_LINE_ID            NUMBER(18, 0),
    TAX_RATE_CODE               VARCHAR2(600),
    TAX_CODE_ID                 NUMBER(18, 0),
    TAX_CLASSIFICATION_CODE     VARCHAR2(120),
    TAXES_APPLIED               VARCHAR2(600),
    TAX_RATE                    NUMBER       ,
    TAX                         VARCHAR2(120),
    TAX_CCID                    NUMBER(18, 0),
    AMOUNT_INCLUDES_TAX_FLAG    VARCHAR2(4)  ,
    SLA_CCID                    NUMBER(18, 0),
    AWT_GROUP_ID                NUMBER(18, 0),
    CUST_GAIN_CCID              NUMBER(18, 0),
    CUST_LOSS_CCID              NUMBER(18, 0),
    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),
    OBJECT_VERSION_NUMBER       NUMBER(9, 0)     NOT NULL,
    CONSTRAINT pk_jg_exg_rate_dif_line PRIMARY KEY (ER_DIF_LINE_ID, ER_DIF_ID, ER_DIF_LINE_ID, ER_DIF_ID)
);
