CREATE TABLE ar_trx_dist_line_balances_all (
    DIST_LINE_ID                   NUMBER(18, 0),
    DATA_SET_ID                    NUMBER(18, 0)    NOT NULL,
    LEDGER_ID                      NUMBER(18, 0)    NOT NULL,
    RECEIPT_BU_ID                  NUMBER(18, 0)    NOT NULL,
    CASH_RECEIPT_ID                NUMBER(18, 0)    NOT NULL,
    RECEIPT_TYPE_CODE              VARCHAR2(120)    NOT NULL,
    RECEIPT_NUMBER                 VARCHAR2(120),
    RECEIPT_LEGAL_ENTITY_ID        NUMBER(18, 0),
    RECEIPT_CURRENCY_CODE          VARCHAR2(60) ,
    CASH_CODE_COMBINATION_ID       NUMBER(18, 0),
    APPLICATION_REFERENCE_ID       NUMBER(18, 0)    NOT NULL,
    APPLY_DATE                     DATE         ,
    APPLIED_PAYMENT_SCHEDULE_ID    NUMBER(18, 0),
    APPLIED_CUSTOMER_TRX_ID        NUMBER(18, 0),
    CUSTOMER_TRX_LINE_ID           NUMBER(18, 0),
    CUST_TRX_LINE_GL_DIST_ID       NUMBER(18, 0),
    REVENUE_CODE_COMBINATION_ID    NUMBER(18, 0),
    BUDGET_AMOUNT                  NUMBER       ,
    FUNDS_STATUS_CODE              VARCHAR2(120),
    PURGE_FLAG                     VARCHAR2(4)  ,
    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),
    ATTRIBUTE_CATEGORY             VARCHAR2(120),
    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),
    GLOBAL_ATTRIBUTE_CATEGORY      VARCHAR2(120),
    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         ,
    ACCOUNT_CLASS                  VARCHAR2(80)     NOT NULL,
    DIST_LINE_ID                   NUMBER(18, 0),
    DATA_SET_ID                    NUMBER(18, 0)    NOT NULL,
    LEDGER_ID                      NUMBER(18, 0)    NOT NULL,
    RECEIPT_BU_ID                  NUMBER(18, 0)    NOT NULL,
    CASH_RECEIPT_ID                NUMBER(18, 0)    NOT NULL,
    RECEIPT_TYPE_CODE              VARCHAR2(120)    NOT NULL,
    RECEIPT_NUMBER                 VARCHAR2(120),
    RECEIPT_LEGAL_ENTITY_ID        NUMBER(18, 0),
    RECEIPT_CURRENCY_CODE          VARCHAR2(60) ,
    CASH_CODE_COMBINATION_ID       NUMBER(18, 0),
    APPLICATION_REFERENCE_ID       NUMBER(18, 0)    NOT NULL,
    APPLY_DATE                     DATE         ,
    APPLIED_PAYMENT_SCHEDULE_ID    NUMBER(18, 0),
    APPLIED_CUSTOMER_TRX_ID        NUMBER(18, 0),
    CUSTOMER_TRX_LINE_ID           NUMBER(18, 0),
    CUST_TRX_LINE_GL_DIST_ID       NUMBER(18, 0),
    REVENUE_CODE_COMBINATION_ID    NUMBER(18, 0),
    BUDGET_AMOUNT                  NUMBER       ,
    FUNDS_STATUS_CODE              VARCHAR2(120),
    PURGE_FLAG                     VARCHAR2(4)  ,
    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),
    ATTRIBUTE_CATEGORY             VARCHAR2(120),
    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),
    GLOBAL_ATTRIBUTE_CATEGORY      VARCHAR2(120),
    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         ,
    ACCOUNT_CLASS                  VARCHAR2(80)     NOT NULL,
    CONSTRAINT pk_ar_trx_dist_line_balances_all PRIMARY KEY (DIST_LINE_ID, DIST_LINE_ID)
);
