CREATE TABLE ap_period_close_excps_gt (
    INVOICE_ID                  NUMBER(18, 0),
    INVOICE_DISTRIBUTION_ID     NUMBER(18, 0),
    INVOICE_LINE_NUMBER         NUMBER(18, 0),
    ACCOUNTING_DATE             DATE         ,
    ORG_ID                      NUMBER(18, 0)    NOT NULL,
    INVOICE_NUM                 VARCHAR2(200),
    INVOICE_CURRENCY_CODE       VARCHAR2(120),
    PARTY_ID                    NUMBER(18, 0),
    DOC_SEQUENCE_VALUE          NUMBER(18, 0),
    VOUCHER_NUM                 VARCHAR2(200),
    INVOICE_DATE                DATE         ,
    INVOICE_AMOUNT              NUMBER       ,
    CANCELLED_DATE              DATE         ,
    MATCH_STATUS_FLAG           VARCHAR2(4)  ,
    PAYMENT_HISTORY_ID          NUMBER(18, 0),
    INVOICE_PAYMENT_ID          NUMBER(18, 0),
    ACCOUNTING_EVENT_ID         NUMBER(18, 0),
    CHECK_ID                    NUMBER(18, 0),
    PAYMENT_AMOUNT              NUMBER       ,
    RECON_ACCOUNTING_FLAG       VARCHAR2(4)  ,
    TRANSACTION_TYPE            VARCHAR2(120),
    LEGAL_ENTITY_ID             NUMBER(18, 0),
    PO_DISTRIBUTION_ID          NUMBER(18, 0),
    DETAIL_TAX_DIST_ID          NUMBER       ,
    AMOUNT                      NUMBER       ,
    CHECK_NUMBER                NUMBER(18, 0),
    CHECK_AMOUNT                NUMBER       ,
    CHECK_DATE                  DATE         ,
    EXCHANGE_RATE               NUMBER       ,
    VENDOR_NAME                 VARCHAR2(960),
    BANK_ACCOUNT_NAME           VARCHAR2(320),
    CURRENCY_CODE               VARCHAR2(60) ,
    STATUS_LOOKUP_CODE          VARCHAR2(100),
    SOURCE_TYPE                 VARCHAR2(120),
    SOURCE_TABLE_NAME           VARCHAR2(120),
    PROCESS_STATUS_FLAG         VARCHAR2(4)  ,
    EVENT_TYPE_CODE             VARCHAR2(120),
    ENTITY_CODE                 VARCHAR2(120),
    INVOICE_TYPE_LOOKUP_CODE    VARCHAR2(100),
    INVOICE_ID                  NUMBER(18, 0),
    INVOICE_DISTRIBUTION_ID     NUMBER(18, 0),
    INVOICE_LINE_NUMBER         NUMBER(18, 0),
    ACCOUNTING_DATE             DATE         ,
    ORG_ID                      NUMBER(18, 0)    NOT NULL,
    INVOICE_NUM                 VARCHAR2(200),
    INVOICE_CURRENCY_CODE       VARCHAR2(120),
    PARTY_ID                    NUMBER(18, 0),
    DOC_SEQUENCE_VALUE          NUMBER(18, 0),
    VOUCHER_NUM                 VARCHAR2(200),
    INVOICE_DATE                DATE         ,
    INVOICE_AMOUNT              NUMBER       ,
    CANCELLED_DATE              DATE         ,
    MATCH_STATUS_FLAG           VARCHAR2(4)  ,
    PAYMENT_HISTORY_ID          NUMBER(18, 0),
    INVOICE_PAYMENT_ID          NUMBER(18, 0),
    ACCOUNTING_EVENT_ID         NUMBER(18, 0),
    CHECK_ID                    NUMBER(18, 0),
    PAYMENT_AMOUNT              NUMBER       ,
    RECON_ACCOUNTING_FLAG       VARCHAR2(4)  ,
    TRANSACTION_TYPE            VARCHAR2(120),
    LEGAL_ENTITY_ID             NUMBER(18, 0),
    PO_DISTRIBUTION_ID          NUMBER(18, 0),
    DETAIL_TAX_DIST_ID          NUMBER       ,
    AMOUNT                      NUMBER       ,
    CHECK_NUMBER                NUMBER(18, 0),
    CHECK_AMOUNT                NUMBER       ,
    CHECK_DATE                  DATE         ,
    EXCHANGE_RATE               NUMBER       ,
    VENDOR_NAME                 VARCHAR2(960),
    BANK_ACCOUNT_NAME           VARCHAR2(320),
    CURRENCY_CODE               VARCHAR2(60) ,
    STATUS_LOOKUP_CODE          VARCHAR2(100),
    SOURCE_TYPE                 VARCHAR2(120),
    SOURCE_TABLE_NAME           VARCHAR2(120),
    PROCESS_STATUS_FLAG         VARCHAR2(4)  ,
    EVENT_TYPE_CODE             VARCHAR2(120),
    ENTITY_CODE                 VARCHAR2(120),
    INVOICE_TYPE_LOOKUP_CODE    VARCHAR2(100)
);
