CREATE TABLE ar_aging_extract (
    AGING_EXTRACT_ID         NUMBER(18, 0) ,
    CUSTOMER_ID              NUMBER(18, 0) ,
    CUSTOMER_NUMBER          VARCHAR2(800) ,
    SHORT_CUSTOMER_NAME      VARCHAR2(960) ,
    SORT_FIELD1              VARCHAR2(2000),
    SORT_FIELD2              VARCHAR2(2000),
    INV_TID_INV              VARCHAR2(120) ,
    CONTACT_SITE_ID          NUMBER(18, 0) ,
    CUSTOMER_STATE           VARCHAR2(240) ,
    CUSTOMER_CITY            VARCHAR2(240) ,
    CUST_ACCT_SITE_ID        NUMBER(18, 0) ,
    PAYMENT_SCHEDULE_ID      NUMBER(18, 0) ,
    CLASS                    VARCHAR2(80)  ,
    DUE_DATE                 DATE          ,
    AMT_DUE_REMAINING        NUMBER        ,
    TRX_NUMBER               VARCHAR2(120) ,
    DAYS_PAST_DUE            NUMBER        ,
    AMOUNT_ADJUSTED          NUMBER        ,
    AMOUNT_APPLIED           NUMBER        ,
    AMOUNT_CREDITED          NUMBER        ,
    GL_DATE                  DATE          ,
    DATA_CONVERTED_FLAG      VARCHAR2(4)   ,
    EXCHANGE_RATE            NUMBER        ,
    BUCKET_0                 NUMBER        ,
    BUCKET_1                 NUMBER        ,
    BUCKET_2                 NUMBER        ,
    BUCKET_3                 NUMBER        ,
    BUCKET_4                 NUMBER        ,
    BUCKET_5                 NUMBER        ,
    BUCKET_6                 NUMBER        ,
    BAL_SEGMENT_VALUE        VARCHAR2(100) ,
    INVOICE_TYPE             VARCHAR2(800) ,
    CONS_BILLING_NUMBER      VARCHAR2(800) ,
    CONTACT_NAME             VARCHAR2(1440),
    CONTACT_PHONE            VARCHAR2(1440),
    CATEGORY                 VARCHAR2(120) ,
    PARENT_REQUEST_ID        NUMBER(18, 0) ,
    WORKER_ID                NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    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) ,
    AGING_EXTRACT_ID         NUMBER(18, 0) ,
    CUSTOMER_ID              NUMBER(18, 0) ,
    CUSTOMER_NUMBER          VARCHAR2(800) ,
    SHORT_CUSTOMER_NAME      VARCHAR2(960) ,
    SORT_FIELD1              VARCHAR2(2000),
    SORT_FIELD2              VARCHAR2(2000),
    INV_TID_INV              VARCHAR2(120) ,
    CONTACT_SITE_ID          NUMBER(18, 0) ,
    CUSTOMER_STATE           VARCHAR2(240) ,
    CUSTOMER_CITY            VARCHAR2(240) ,
    CUST_ACCT_SITE_ID        NUMBER(18, 0) ,
    PAYMENT_SCHEDULE_ID      NUMBER(18, 0) ,
    CLASS                    VARCHAR2(80)  ,
    DUE_DATE                 DATE          ,
    AMT_DUE_REMAINING        NUMBER        ,
    TRX_NUMBER               VARCHAR2(120) ,
    DAYS_PAST_DUE            NUMBER        ,
    AMOUNT_ADJUSTED          NUMBER        ,
    AMOUNT_APPLIED           NUMBER        ,
    AMOUNT_CREDITED          NUMBER        ,
    GL_DATE                  DATE          ,
    DATA_CONVERTED_FLAG      VARCHAR2(4)   ,
    EXCHANGE_RATE            NUMBER        ,
    BUCKET_0                 NUMBER        ,
    BUCKET_1                 NUMBER        ,
    BUCKET_2                 NUMBER        ,
    BUCKET_3                 NUMBER        ,
    BUCKET_4                 NUMBER        ,
    BUCKET_5                 NUMBER        ,
    BUCKET_6                 NUMBER        ,
    BAL_SEGMENT_VALUE        VARCHAR2(100) ,
    INVOICE_TYPE             VARCHAR2(800) ,
    CONS_BILLING_NUMBER      VARCHAR2(800) ,
    CONTACT_NAME             VARCHAR2(1440),
    CONTACT_PHONE            VARCHAR2(1440),
    CATEGORY                 VARCHAR2(120) ,
    PARENT_REQUEST_ID        NUMBER(18, 0) ,
    WORKER_ID                NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    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) ,
    CONSTRAINT pk_ar_aging_extract PRIMARY KEY (AGING_EXTRACT_ID, AGING_EXTRACT_ID)
);
