CREATE TABLE jl_ar_ap_wht_certificates_all (
    CERTIFICATE_ID               NUMBER(18, 0) ,
    CERTIFICATE_NUMBER           NUMBER(18, 0)     NOT NULL,
    LEDGER_ID                    NUMBER(18, 0)     NOT NULL,
    ORG_ID                       NUMBER(18, 0)     NOT NULL,
    LEGAL_ENTITY_ID              NUMBER(18, 0)     NOT NULL,
    SUPPLIER_ID                  NUMBER(18, 0)     NOT NULL,
    WITHHOLDING_TYPE_CODE        VARCHAR2(120)     NOT NULL,
    WITHHOLDING_DATE             DATE              NOT NULL,
    TAX_AMT                      NUMBER            NOT NULL,
    CREDIT_AMOUNT                NUMBER        ,
    STATUS_CODE                  VARCHAR2(120)     NOT NULL,
    BANK_ACCOUNT_NUM             VARCHAR2(120) ,
    CHECK_NUMBER                 NUMBER(18, 0) ,
    PAYMENT_DOCUMENT_NAME        VARCHAR2(120) ,
    TAX_REGIME_CODE              VARCHAR2(120) ,
    TAX                          VARCHAR2(120) ,
    TAXABLE_BASE_AMOUNT          NUMBER        ,
    PAYMENT_INSTRUCTION_ID       NUMBER(18, 0) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    LOAD_REQUEST_ID              NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    CREATION_DATE                TIMESTAMP(6)      NOT NULL,
    CREATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    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) ,
    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          ,
    GLOBAL_ATTRIBUTE_CATEGORY    VARCHAR2(600) ,
    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_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          ,
    PAYMENT_ID                   NUMBER(18, 0) ,
    CHECK_ID                     NUMBER(18, 0) ,
    TAX_RATE_ID                  NUMBER(18, 0) ,
    CERTIFICATE_ID               NUMBER(18, 0) ,
    CERTIFICATE_NUMBER           NUMBER(18, 0)     NOT NULL,
    LEDGER_ID                    NUMBER(18, 0)     NOT NULL,
    ORG_ID                       NUMBER(18, 0)     NOT NULL,
    LEGAL_ENTITY_ID              NUMBER(18, 0)     NOT NULL,
    SUPPLIER_ID                  NUMBER(18, 0)     NOT NULL,
    WITHHOLDING_TYPE_CODE        VARCHAR2(120)     NOT NULL,
    WITHHOLDING_DATE             DATE              NOT NULL,
    TAX_AMT                      NUMBER            NOT NULL,
    CREDIT_AMOUNT                NUMBER        ,
    STATUS_CODE                  VARCHAR2(120)     NOT NULL,
    BANK_ACCOUNT_NUM             VARCHAR2(120) ,
    CHECK_NUMBER                 NUMBER(18, 0) ,
    PAYMENT_DOCUMENT_NAME        VARCHAR2(120) ,
    TAX_REGIME_CODE              VARCHAR2(120) ,
    TAX                          VARCHAR2(120) ,
    TAXABLE_BASE_AMOUNT          NUMBER        ,
    PAYMENT_INSTRUCTION_ID       NUMBER(18, 0) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    LOAD_REQUEST_ID              NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    CREATION_DATE                TIMESTAMP(6)      NOT NULL,
    CREATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    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) ,
    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          ,
    GLOBAL_ATTRIBUTE_CATEGORY    VARCHAR2(600) ,
    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_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          ,
    PAYMENT_ID                   NUMBER(18, 0) ,
    CHECK_ID                     NUMBER(18, 0) ,
    TAX_RATE_ID                  NUMBER(18, 0) ,
    CONSTRAINT pk_jl_ar_ap_wht_certificates_all PRIMARY KEY (CERTIFICATE_ID, CERTIFICATE_ID)
);
