CREATE TABLE jg_fscl_tax_lines_int (
    INTERFACE_TAX_LINE_ID           NUMBER(18, 0) ,
    TRX_NUMBER                      NUMBER            NOT NULL,
    TRX_LINE_NUMBER                 NUMBER(18, 0)     NOT NULL,
    APP_SHORT_NAME                  VARCHAR2(120)     NOT NULL,
    ENTITY_CODE                     VARCHAR2(120)     NOT NULL,
    EVENT_CLASS_CODE                VARCHAR2(120)     NOT NULL,
    TRX_LEVEL_TYPE                  VARCHAR2(120)     NOT NULL,
    TAX                             VARCHAR2(120)     NOT NULL,
    TAXABLE_AMT                     NUMBER            NOT NULL,
    TAX_RATE_CODE                   VARCHAR2(120)     NOT NULL,
    TAX_RATE                        NUMBER        ,
    QUANTITY                        NUMBER        ,
    UOM_CODE                        VARCHAR2(120) ,
    TAX_AMT                         NUMBER            NOT NULL,
    EXEMPT_REASON_CODE              VARCHAR2(120) ,
    VALUE_ADDED_MARGIN_PERC         NUMBER        ,
    TAXABLE_BASIS_REDUCTION_PERC    NUMBER        ,
    TAXABLE_BASIS_PERC_PAYER_OPR    NUMBER        ,
    CITY_CODE                       VARCHAR2(120) ,
    SERVICE_ITEM_CODE               VARCHAR2(120) ,
    REPORTING_TYPE_CODE             VARCHAR2(120) ,
    CREATION_DATE                   TIMESTAMP(6)  ,
    CREATED_BY                      VARCHAR2(256) ,
    LAST_UPDATE_DATE                TIMESTAMP(6)  ,
    LAST_UPDATED_BY                 VARCHAR2(256) ,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    REQUEST_ID                      NUMBER(18, 0) ,
    LOAD_REQUEST_ID                 NUMBER(18, 0) ,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    ATTRIBUTE1                      VARCHAR2(600) ,
    ATTRIBUTE2                      VARCHAR2(600) ,
    ATTRIBUTE3                      VARCHAR2(600) ,
    ATTRIBUTE4                      VARCHAR2(600) ,
    ATTRIBUTE5                      VARCHAR2(600) ,
    ATTRIBUTE6                      VARCHAR2(600) ,
    ATTRIBUTE7                      VARCHAR2(600) ,
    ATTRIBUTE8                      VARCHAR2(600) ,
    ATTRIBUTE9                      VARCHAR2(600) ,
    ATTRIBUTE10                     VARCHAR2(600) ,
    ATTRIBUTE11                     VARCHAR2(600) ,
    ATTRIBUTE12                     VARCHAR2(600) ,
    ATTRIBUTE13                     VARCHAR2(600) ,
    ATTRIBUTE14                     VARCHAR2(600) ,
    ATTRIBUTE15                     VARCHAR2(600) ,
    ATTRIBUTE_CATEGORY              VARCHAR2(120) ,
    ATTRIBUTE_NUMBER1               NUMBER        ,
    ATTRIBUTE_NUMBER2               NUMBER        ,
    ATTRIBUTE_NUMBER3               NUMBER        ,
    ATTRIBUTE_NUMBER4               NUMBER        ,
    ATTRIBUTE_NUMBER5               NUMBER        ,
    ATTRIBUTE_DATE1                 DATE          ,
    ATTRIBUTE_DATE2                 DATE          ,
    ATTRIBUTE_DATE3                 DATE          ,
    ATTRIBUTE_DATE4                 DATE          ,
    ATTRIBUTE_DATE5                 DATE          ,
    TAX_LINE_NUMBER                 NUMBER            NOT NULL,
    INTERFACE_ENTITY_CODE           VARCHAR2(120)     NOT NULL,
    TAX_REGIME_CODE                 VARCHAR2(120) ,
    TAX_STATUS_CODE                 VARCHAR2(120) ,
    TAX_AMT_INCLUDED_FLAG           VARCHAR2(4)   ,
    EXEMPT_CERTIFICATE_NUMBER       VARCHAR2(320) ,
    INTERFACE_HDR_ID                NUMBER(18, 0)     NOT NULL,
    INTERFACE_LINE_ID               NUMBER(18, 0)     NOT NULL,
    GLOBAL_ATTRIBUTE1               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE2               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE3               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE4               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE5               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE6               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE7               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE8               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE9               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE10              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE11              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE12              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE13              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE14              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE15              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE16              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE17              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE18              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE19              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE20              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE_CATEGORY       VARCHAR2(120) ,
    GLOBAL_ATTRIBUTE_NUMBER1        NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER2        NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER3        NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER4        NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER5        NUMBER        ,
    GLOBAL_ATTRIBUTE_DATE1          DATE          ,
    GLOBAL_ATTRIBUTE_DATE2          DATE          ,
    GLOBAL_ATTRIBUTE_DATE3          DATE          ,
    GLOBAL_ATTRIBUTE_DATE4          DATE          ,
    GLOBAL_ATTRIBUTE_DATE5          DATE          ,
    TAXABLE_AMT_DETERM_CODE         VARCHAR2(120) ,
    TAX_SITUATION_CODE              VARCHAR2(120) ,
    INTERFACE_TAX_LINE_ID           NUMBER(18, 0) ,
    TRX_NUMBER                      NUMBER            NOT NULL,
    TRX_LINE_NUMBER                 NUMBER(18, 0)     NOT NULL,
    APP_SHORT_NAME                  VARCHAR2(120)     NOT NULL,
    ENTITY_CODE                     VARCHAR2(120)     NOT NULL,
    EVENT_CLASS_CODE                VARCHAR2(120)     NOT NULL,
    TRX_LEVEL_TYPE                  VARCHAR2(120)     NOT NULL,
    TAX                             VARCHAR2(120)     NOT NULL,
    TAXABLE_AMT                     NUMBER            NOT NULL,
    TAX_RATE_CODE                   VARCHAR2(120)     NOT NULL,
    TAX_RATE                        NUMBER        ,
    QUANTITY                        NUMBER        ,
    UOM_CODE                        VARCHAR2(120) ,
    TAX_AMT                         NUMBER            NOT NULL,
    EXEMPT_REASON_CODE              VARCHAR2(120) ,
    VALUE_ADDED_MARGIN_PERC         NUMBER        ,
    TAXABLE_BASIS_REDUCTION_PERC    NUMBER        ,
    TAXABLE_BASIS_PERC_PAYER_OPR    NUMBER        ,
    CITY_CODE                       VARCHAR2(120) ,
    SERVICE_ITEM_CODE               VARCHAR2(120) ,
    REPORTING_TYPE_CODE             VARCHAR2(120) ,
    CREATION_DATE                   TIMESTAMP(6)  ,
    CREATED_BY                      VARCHAR2(256) ,
    LAST_UPDATE_DATE                TIMESTAMP(6)  ,
    LAST_UPDATED_BY                 VARCHAR2(256) ,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    REQUEST_ID                      NUMBER(18, 0) ,
    LOAD_REQUEST_ID                 NUMBER(18, 0) ,
    JOB_DEFINITION_NAME             VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE          VARCHAR2(3600),
    ATTRIBUTE1                      VARCHAR2(600) ,
    ATTRIBUTE2                      VARCHAR2(600) ,
    ATTRIBUTE3                      VARCHAR2(600) ,
    ATTRIBUTE4                      VARCHAR2(600) ,
    ATTRIBUTE5                      VARCHAR2(600) ,
    ATTRIBUTE6                      VARCHAR2(600) ,
    ATTRIBUTE7                      VARCHAR2(600) ,
    ATTRIBUTE8                      VARCHAR2(600) ,
    ATTRIBUTE9                      VARCHAR2(600) ,
    ATTRIBUTE10                     VARCHAR2(600) ,
    ATTRIBUTE11                     VARCHAR2(600) ,
    ATTRIBUTE12                     VARCHAR2(600) ,
    ATTRIBUTE13                     VARCHAR2(600) ,
    ATTRIBUTE14                     VARCHAR2(600) ,
    ATTRIBUTE15                     VARCHAR2(600) ,
    ATTRIBUTE_CATEGORY              VARCHAR2(120) ,
    ATTRIBUTE_NUMBER1               NUMBER        ,
    ATTRIBUTE_NUMBER2               NUMBER        ,
    ATTRIBUTE_NUMBER3               NUMBER        ,
    ATTRIBUTE_NUMBER4               NUMBER        ,
    ATTRIBUTE_NUMBER5               NUMBER        ,
    ATTRIBUTE_DATE1                 DATE          ,
    ATTRIBUTE_DATE2                 DATE          ,
    ATTRIBUTE_DATE3                 DATE          ,
    ATTRIBUTE_DATE4                 DATE          ,
    ATTRIBUTE_DATE5                 DATE          ,
    TAX_LINE_NUMBER                 NUMBER            NOT NULL,
    INTERFACE_ENTITY_CODE           VARCHAR2(120)     NOT NULL,
    TAX_REGIME_CODE                 VARCHAR2(120) ,
    TAX_STATUS_CODE                 VARCHAR2(120) ,
    TAX_AMT_INCLUDED_FLAG           VARCHAR2(4)   ,
    EXEMPT_CERTIFICATE_NUMBER       VARCHAR2(320) ,
    INTERFACE_HDR_ID                NUMBER(18, 0)     NOT NULL,
    INTERFACE_LINE_ID               NUMBER(18, 0)     NOT NULL,
    GLOBAL_ATTRIBUTE1               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE2               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE3               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE4               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE5               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE6               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE7               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE8               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE9               VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE10              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE11              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE12              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE13              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE14              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE15              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE16              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE17              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE18              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE19              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE20              VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE_CATEGORY       VARCHAR2(120) ,
    GLOBAL_ATTRIBUTE_NUMBER1        NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER2        NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER3        NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER4        NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER5        NUMBER        ,
    GLOBAL_ATTRIBUTE_DATE1          DATE          ,
    GLOBAL_ATTRIBUTE_DATE2          DATE          ,
    GLOBAL_ATTRIBUTE_DATE3          DATE          ,
    GLOBAL_ATTRIBUTE_DATE4          DATE          ,
    GLOBAL_ATTRIBUTE_DATE5          DATE          ,
    TAXABLE_AMT_DETERM_CODE         VARCHAR2(120) ,
    TAX_SITUATION_CODE              VARCHAR2(120) ,
    CONSTRAINT pk_jg_fscl_tax_lines_int PRIMARY KEY (INTERFACE_TAX_LINE_ID, INTERFACE_TAX_LINE_ID)
);
