CREATE TABLE iex_essbase_balances (
    IEX_ESSBASE_BALANCES_ID    NUMBER(18, 0) ,
    DOCUMENT_TYPE              VARCHAR2(320)     NOT NULL,
    TRX_AMOUNT                 NUMBER        ,
    RECEIPT_AMOUNT             NUMBER        ,
    ADJ_AMOUNT                 NUMBER        ,
    PROMISE_AMOUNT             NUMBER        ,
    NSF_AMOUNT                 NUMBER        ,
    TRX_AMOUNT_GLOBAL          NUMBER        ,
    RECEIPT_AMOUNT_GLOBAL      NUMBER        ,
    ADJ_AMOUNT_GLOBAL          NUMBER        ,
    PROMISE_AMOUNT_GLOBAL      NUMBER        ,
    NSF_AMOUNT_GLOBAL          NUMBER        ,
    SCORE                      NUMBER        ,
    AVERAGE_TERMS              NUMBER        ,
    ACTIVITY_DATE              DATE              NOT NULL,
    PS_DUE_DATE                DATE              NOT NULL,
    PS_CLOSED_DATE             DATE              NOT NULL,
    CURRENCY                   VARCHAR2(60)      NOT NULL,
    BU_NAME                    VARCHAR2(960)     NOT NULL,
    PARTY_NAME                 VARCHAR2(1440)    NOT NULL,
    ACCOUNT_NUMBER             VARCHAR2(1800)    NOT NULL,
    PARTY_SITE_NAME            VARCHAR2(2800)    NOT NULL,
    COLLECTOR_NAME             VARCHAR2(120)     NOT NULL,
    SALESREP_NAME              VARCHAR2(1440),
    COUNTRY                    VARCHAR2(240) ,
    STATE                      VARCHAR2(240) ,
    COUNTY                     VARCHAR2(240) ,
    CITY                       VARCHAR2(240) ,
    POSTAL_CODE                VARCHAR2(240) ,
    LOCATION                   VARCHAR2(480) ,
    PROFILE_CLASSIFICATION     VARCHAR2(320)     NOT NULL,
    AGING_BUCKET_NAME          VARCHAR2(320)     NOT NULL,
    PAYMENT_SCHEDULE_ID        NUMBER(18, 0)     NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    CREATED_BY                 VARCHAR2(256)     NOT NULL,
    CREATION_DATE              TIMESTAMP(6)      NOT NULL,
    REQUEST_ID                 NUMBER(18, 0) ,
    JOB_DEFINITION_NAME        VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE     VARCHAR2(3600),
    IEX_ESSBASE_BALANCES_ID    NUMBER(18, 0) ,
    DOCUMENT_TYPE              VARCHAR2(320)     NOT NULL,
    TRX_AMOUNT                 NUMBER        ,
    RECEIPT_AMOUNT             NUMBER        ,
    ADJ_AMOUNT                 NUMBER        ,
    PROMISE_AMOUNT             NUMBER        ,
    NSF_AMOUNT                 NUMBER        ,
    TRX_AMOUNT_GLOBAL          NUMBER        ,
    RECEIPT_AMOUNT_GLOBAL      NUMBER        ,
    ADJ_AMOUNT_GLOBAL          NUMBER        ,
    PROMISE_AMOUNT_GLOBAL      NUMBER        ,
    NSF_AMOUNT_GLOBAL          NUMBER        ,
    SCORE                      NUMBER        ,
    AVERAGE_TERMS              NUMBER        ,
    ACTIVITY_DATE              DATE              NOT NULL,
    PS_DUE_DATE                DATE              NOT NULL,
    PS_CLOSED_DATE             DATE              NOT NULL,
    CURRENCY                   VARCHAR2(60)      NOT NULL,
    BU_NAME                    VARCHAR2(960)     NOT NULL,
    PARTY_NAME                 VARCHAR2(1440)    NOT NULL,
    ACCOUNT_NUMBER             VARCHAR2(1800)    NOT NULL,
    PARTY_SITE_NAME            VARCHAR2(2800)    NOT NULL,
    COLLECTOR_NAME             VARCHAR2(120)     NOT NULL,
    SALESREP_NAME              VARCHAR2(1440),
    COUNTRY                    VARCHAR2(240) ,
    STATE                      VARCHAR2(240) ,
    COUNTY                     VARCHAR2(240) ,
    CITY                       VARCHAR2(240) ,
    POSTAL_CODE                VARCHAR2(240) ,
    LOCATION                   VARCHAR2(480) ,
    PROFILE_CLASSIFICATION     VARCHAR2(320)     NOT NULL,
    AGING_BUCKET_NAME          VARCHAR2(320)     NOT NULL,
    PAYMENT_SCHEDULE_ID        NUMBER(18, 0)     NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    CREATED_BY                 VARCHAR2(256)     NOT NULL,
    CREATION_DATE              TIMESTAMP(6)      NOT NULL,
    REQUEST_ID                 NUMBER(18, 0) ,
    JOB_DEFINITION_NAME        VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE     VARCHAR2(3600),
    CONSTRAINT pk_iex_essbase_balances PRIMARY KEY (IEX_ESSBASE_BALANCES_ID, IEX_ESSBASE_BALANCES_ID)
);
