CREATE TABLE ja_cn_trx_headers_all (
    GTA_TRX_HEADER_ID             NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)      NOT NULL,
    ORG_ID                        NUMBER(18, 0)     NOT NULL,
    GTA_TRX_NUMBER                VARCHAR2(120)     NOT NULL,
    GROUP_NUMBER                  NUMBER(18, 0) ,
    VERSION                       NUMBER(18, 0)     NOT NULL,
    STATUS                        VARCHAR2(120)     NOT NULL,
    CONSOLIDATION_FLAG            VARCHAR2(4)   ,
    CONSOLI_PARENT_TRX_HDR_ID     NUMBER(18, 0) ,
    SPLIT_FLAG                    VARCHAR2(4)   ,
    GENERATOR_ID                  NUMBER(18, 0) ,
    EXPORT_REQUEST_ID             NUMBER(18, 0) ,
    VAT_BATCH_NUMBER              NUMBER        ,
    RULE_HEADER_ID                NUMBER(18, 0) ,
    INVOICE_TYPE                  VARCHAR2(120) ,
    TAX_CODE                      VARCHAR2(120) ,
    TAX_RATE                      NUMBER        ,
    SALES_LIST_FLAG               VARCHAR2(4)   ,
    DESCRIPTION                   VARCHAR2(960) ,
    GL_DATE                       DATE              NOT NULL,
    GL_PERIOD                     VARCHAR2(60)      NOT NULL,
    SET_OF_BOOKS_ID               NUMBER(18, 0)     NOT NULL,
    BILL_TO_CUSTOMER_ID           NUMBER(18, 0)     NOT NULL,
    BILL_TO_CUSTOMER_NUMBER       VARCHAR2(120)     NOT NULL,
    BILL_TO_CUSTOMER_NAME         VARCHAR2(1440)    NOT NULL,
    TRANSACTION_DATE              DATE              NOT NULL,
    RA_TRX_ID                     NUMBER(18, 0) ,
    RA_TRX_NUMBER                 VARCHAR2(80)  ,
    CUSTOMER_ADDRESS_PHONE        VARCHAR2(4000),
    LEGAL_ENTITY_ID               VARCHAR2(72)      NOT NULL,
    FP_TAX_REGISTRATION_NUMBER    VARCHAR2(200)     NOT NULL,
    TP_TAX_REGISTRATION_NUMBER    VARCHAR2(200) ,
    BANK_ACCOUNT_NAME             VARCHAR2(960) ,
    BANK_ACCOUNT_NUMBER           VARCHAR2(960) ,
    RA_CURRENCY_CODE              VARCHAR2(60)  ,
    CONVERSION_TYPE               VARCHAR2(120) ,
    CONVERSION_DATE               DATE          ,
    CONVERSION_RATE               NUMBER        ,
    ORIGINAL_AMOUNT               NUMBER        ,
    RA_DOCUMENT_ID                NUMBER(18, 0) ,
    RA_TRX_BATCH_ID               NUMBER(18, 0) ,
    RA_TRX_SOURCE_SEQ_ID          NUMBER(18, 0) ,
    RA_TRX_TYPE_SEQ_ID            NUMBER(18, 0) ,
    RA_TRX_CLASS                  VARCHAR2(40)  ,
    PRIMARY_SALESREP_ID           NUMBER(18, 0) ,
    REVIEWER_NAME                 VARCHAR2(120) ,
    PAYEE_NAME                    VARCHAR2(120) ,
    REQUEST_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME           VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE        VARCHAR2(3600),
    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) ,
    ATTRIBUTE_CATEGORY            VARCHAR2(600) ,
    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) ,
    GTA_TRX_HEADER_ID             NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)      NOT NULL,
    ORG_ID                        NUMBER(18, 0)     NOT NULL,
    GTA_TRX_NUMBER                VARCHAR2(120)     NOT NULL,
    GROUP_NUMBER                  NUMBER(18, 0) ,
    VERSION                       NUMBER(18, 0)     NOT NULL,
    STATUS                        VARCHAR2(120)     NOT NULL,
    CONSOLIDATION_FLAG            VARCHAR2(4)   ,
    CONSOLI_PARENT_TRX_HDR_ID     NUMBER(18, 0) ,
    SPLIT_FLAG                    VARCHAR2(4)   ,
    GENERATOR_ID                  NUMBER(18, 0) ,
    EXPORT_REQUEST_ID             NUMBER(18, 0) ,
    VAT_BATCH_NUMBER              NUMBER        ,
    RULE_HEADER_ID                NUMBER(18, 0) ,
    INVOICE_TYPE                  VARCHAR2(120) ,
    TAX_CODE                      VARCHAR2(120) ,
    TAX_RATE                      NUMBER        ,
    SALES_LIST_FLAG               VARCHAR2(4)   ,
    DESCRIPTION                   VARCHAR2(960) ,
    GL_DATE                       DATE              NOT NULL,
    GL_PERIOD                     VARCHAR2(60)      NOT NULL,
    SET_OF_BOOKS_ID               NUMBER(18, 0)     NOT NULL,
    BILL_TO_CUSTOMER_ID           NUMBER(18, 0)     NOT NULL,
    BILL_TO_CUSTOMER_NUMBER       VARCHAR2(120)     NOT NULL,
    BILL_TO_CUSTOMER_NAME         VARCHAR2(1440)    NOT NULL,
    TRANSACTION_DATE              DATE              NOT NULL,
    RA_TRX_ID                     NUMBER(18, 0) ,
    RA_TRX_NUMBER                 VARCHAR2(80)  ,
    CUSTOMER_ADDRESS_PHONE        VARCHAR2(4000),
    LEGAL_ENTITY_ID               VARCHAR2(72)      NOT NULL,
    FP_TAX_REGISTRATION_NUMBER    VARCHAR2(200)     NOT NULL,
    TP_TAX_REGISTRATION_NUMBER    VARCHAR2(200) ,
    BANK_ACCOUNT_NAME             VARCHAR2(960) ,
    BANK_ACCOUNT_NUMBER           VARCHAR2(960) ,
    RA_CURRENCY_CODE              VARCHAR2(60)  ,
    CONVERSION_TYPE               VARCHAR2(120) ,
    CONVERSION_DATE               DATE          ,
    CONVERSION_RATE               NUMBER        ,
    ORIGINAL_AMOUNT               NUMBER        ,
    RA_DOCUMENT_ID                NUMBER(18, 0) ,
    RA_TRX_BATCH_ID               NUMBER(18, 0) ,
    RA_TRX_SOURCE_SEQ_ID          NUMBER(18, 0) ,
    RA_TRX_TYPE_SEQ_ID            NUMBER(18, 0) ,
    RA_TRX_CLASS                  VARCHAR2(40)  ,
    PRIMARY_SALESREP_ID           NUMBER(18, 0) ,
    REVIEWER_NAME                 VARCHAR2(120) ,
    PAYEE_NAME                    VARCHAR2(120) ,
    REQUEST_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME           VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE        VARCHAR2(3600),
    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) ,
    ATTRIBUTE_CATEGORY            VARCHAR2(600) ,
    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) ,
    CONSTRAINT pk_ja_cn_trx_headers_all PRIMARY KEY (GTA_TRX_HEADER_ID, GTA_TRX_HEADER_ID)
);
