CREATE TABLE financials_system_params_all_ (
    LAST_UPDATE_DATE                  TIMESTAMP(6)  ,
    LAST_UPDATED_BY                   VARCHAR2(256) ,
    SET_OF_BOOKS_ID                   NUMBER(18, 0) ,
    PAYMENT_METHOD_LOOKUP_CODE        VARCHAR2(100) ,
    USER_DEFINED_VENDOR_NUM_CODE      VARCHAR2(100) ,
    VENDOR_NUM_START_NUM              NUMBER        ,
    BILL_TO_LOCATION_ID               NUMBER(18, 0) ,
    TERMS_ID                          NUMBER(18, 0) ,
    ALWAYS_TAKE_DISC_FLAG             VARCHAR2(4)   ,
    PAY_DATE_BASIS_LOOKUP_CODE        VARCHAR2(100) ,
    INVOICE_CURRENCY_CODE             VARCHAR2(60)  ,
    PAYMENT_CURRENCY_CODE             VARCHAR2(60)  ,
    ACCTS_PAY_CODE_COMBINATION_ID     NUMBER(18, 0) ,
    PREPAY_CODE_COMBINATION_ID        NUMBER(18, 0) ,
    DISC_TAKEN_CODE_COMBINATION_ID    NUMBER(18, 0) ,
    FUTURE_PERIOD_LIMIT               NUMBER(3, 0)  ,
    RES_ENCUMB_CODE_COMBINATION_ID    NUMBER(18, 0) ,
    REQ_ENCUMBRANCE_FLAG              VARCHAR2(4)   ,
    REQ_ENCUMBRANCE_TYPE_ID           NUMBER(18, 0) ,
    PURCH_ENCUMBRANCE_FLAG            VARCHAR2(4)   ,
    PURCH_ENCUMBRANCE_TYPE_ID         NUMBER(18, 0) ,
    INV_ENCUMBRANCE_TYPE_ID           NUMBER(18, 0) ,
    MANUAL_VENDOR_NUM_TYPE            VARCHAR2(100) ,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    CREATION_DATE                     TIMESTAMP(6)  ,
    CREATED_BY                        VARCHAR2(256) ,
    RECEIPT_ACCEPTANCE_DAYS           NUMBER(18, 0) ,
    TERMS_DATE_BASIS                  VARCHAR2(100) ,
    RATE_VAR_CODE_COMBINATION_ID      NUMBER(18, 0) ,
    HOLD_UNMATCHED_INVOICES_FLAG      VARCHAR2(4)   ,
    EXCLUSIVE_PAYMENT_FLAG            VARCHAR2(4)   ,
    VAT_REGISTRATION_NUM              VARCHAR2(80)  ,
    VAT_COUNTRY_CODE                  VARCHAR2(60)  ,
    RATE_VAR_GAIN_CCID                NUMBER(18, 0) ,
    RATE_VAR_LOSS_CCID                NUMBER(18, 0) ,
    ORG_ID                            NUMBER(18, 0) ,
    BANK_CHARGE_BEARER                VARCHAR2(4)   ,
    MATCH_OPTION                      VARCHAR2(100) ,
    NR_TAX_ROUNDING                   VARCHAR2(120) ,
    FUTURE_DATED_PAYMENT_CCID         NUMBER(18, 0) ,
    MISC_CHARGE_CCID                  NUMBER(18, 0) ,
    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          ,
    RETAINAGE_CODE_COMBINATION_ID     NUMBER(18, 0) ,
    BUYING_COMPANY_IDENTIFIER         VARCHAR2(40)  ,
    EXPENSE_ACCRUAL_CCID              NUMBER(18, 0) ,
    GAPLESS_INV_NUM_FLAG              VARCHAR2(4)   ,
    EXPENSE_ACCRUAL_CODE              VARCHAR2(100) ,
    DEFAULT_EXCHANGE_RATE_TYPE        VARCHAR2(120) ,
    AUTOMATIC_OFFSETS_FLAG            VARCHAR2(4)   ,
    AUTOMATIC_OFFSETS_CHANGE_FLAG     VARCHAR2(4)   ,
    LIABILITY_POST_LOOKUP_CODE        VARCHAR2(100) ,
    GAIN_CODE_COMBINATION_ID          NUMBER(18, 0) ,
    LOSS_CODE_COMBINATION_ID          NUMBER(18, 0) ,
    MAKE_RATE_MANDATORY_FLAG          VARCHAR2(4)   ,
    FREIGHT_CODE_COMBINATION_ID       NUMBER(18, 0) ,
    PREPAY_TAX_DIFF_CCID              NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)  ,
    MAKE_RATE_MANDATORY_PMT_FLAG      VARCHAR2(4)   ,
    DEFAULT_PMT_EXCHANGE_RATE_TYPE    VARCHAR2(120) ,
    AUDIT_ACTION_TYPE_                VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_             VARCHAR2(4000),
    AUDIT_IMPERSONATOR_               VARCHAR2(256) ,
    ONE_TIME_PAY_LIAB_CCID            NUMBER(18, 0) ,
    ONE_TIME_PAY_EXPENSE_CCID         NUMBER(18, 0) ,
    UNCLAIMED_FUNDS_CCID              NUMBER(18, 0) ,
    LAST_UPDATE_DATE                  TIMESTAMP(6)  ,
    LAST_UPDATED_BY                   VARCHAR2(256) ,
    SET_OF_BOOKS_ID                   NUMBER(18, 0) ,
    PAYMENT_METHOD_LOOKUP_CODE        VARCHAR2(100) ,
    USER_DEFINED_VENDOR_NUM_CODE      VARCHAR2(100) ,
    VENDOR_NUM_START_NUM              NUMBER        ,
    BILL_TO_LOCATION_ID               NUMBER(18, 0) ,
    TERMS_ID                          NUMBER(18, 0) ,
    ALWAYS_TAKE_DISC_FLAG             VARCHAR2(4)   ,
    PAY_DATE_BASIS_LOOKUP_CODE        VARCHAR2(100) ,
    INVOICE_CURRENCY_CODE             VARCHAR2(60)  ,
    PAYMENT_CURRENCY_CODE             VARCHAR2(60)  ,
    ACCTS_PAY_CODE_COMBINATION_ID     NUMBER(18, 0) ,
    PREPAY_CODE_COMBINATION_ID        NUMBER(18, 0) ,
    DISC_TAKEN_CODE_COMBINATION_ID    NUMBER(18, 0) ,
    FUTURE_PERIOD_LIMIT               NUMBER(3, 0)  ,
    RES_ENCUMB_CODE_COMBINATION_ID    NUMBER(18, 0) ,
    REQ_ENCUMBRANCE_FLAG              VARCHAR2(4)   ,
    REQ_ENCUMBRANCE_TYPE_ID           NUMBER(18, 0) ,
    PURCH_ENCUMBRANCE_FLAG            VARCHAR2(4)   ,
    PURCH_ENCUMBRANCE_TYPE_ID         NUMBER(18, 0) ,
    INV_ENCUMBRANCE_TYPE_ID           NUMBER(18, 0) ,
    MANUAL_VENDOR_NUM_TYPE            VARCHAR2(100) ,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    CREATION_DATE                     TIMESTAMP(6)  ,
    CREATED_BY                        VARCHAR2(256) ,
    RECEIPT_ACCEPTANCE_DAYS           NUMBER(18, 0) ,
    TERMS_DATE_BASIS                  VARCHAR2(100) ,
    RATE_VAR_CODE_COMBINATION_ID      NUMBER(18, 0) ,
    HOLD_UNMATCHED_INVOICES_FLAG      VARCHAR2(4)   ,
    EXCLUSIVE_PAYMENT_FLAG            VARCHAR2(4)   ,
    VAT_REGISTRATION_NUM              VARCHAR2(80)  ,
    VAT_COUNTRY_CODE                  VARCHAR2(60)  ,
    RATE_VAR_GAIN_CCID                NUMBER(18, 0) ,
    RATE_VAR_LOSS_CCID                NUMBER(18, 0) ,
    ORG_ID                            NUMBER(18, 0) ,
    BANK_CHARGE_BEARER                VARCHAR2(4)   ,
    MATCH_OPTION                      VARCHAR2(100) ,
    NR_TAX_ROUNDING                   VARCHAR2(120) ,
    FUTURE_DATED_PAYMENT_CCID         NUMBER(18, 0) ,
    MISC_CHARGE_CCID                  NUMBER(18, 0) ,
    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) ,
    RETAINAGE_CODE_COMBINATION_ID     NUMBER(18, 0) ,
    BUYING_COMPANY_IDENTIFIER         VARCHAR2(40)  ,
    EXPENSE_ACCRUAL_CCID              NUMBER(18, 0) ,
    GAPLESS_INV_NUM_FLAG              VARCHAR2(4)   ,
    EXPENSE_ACCRUAL_CODE              VARCHAR2(100) ,
    DEFAULT_EXCHANGE_RATE_TYPE        VARCHAR2(120) ,
    AUTOMATIC_OFFSETS_FLAG            VARCHAR2(4)   ,
    AUTOMATIC_OFFSETS_CHANGE_FLAG     VARCHAR2(4)   ,
    LIABILITY_POST_LOOKUP_CODE        VARCHAR2(100) ,
    GAIN_CODE_COMBINATION_ID          NUMBER(18, 0) ,
    LOSS_CODE_COMBINATION_ID          NUMBER(18, 0) ,
    MAKE_RATE_MANDATORY_FLAG          VARCHAR2(4)   ,
    FREIGHT_CODE_COMBINATION_ID       NUMBER(18, 0) ,
    PREPAY_TAX_DIFF_CCID              NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)  ,
    AUDIT_ACTION_TYPE_                VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_             VARCHAR2(4000),
    ONE_TIME_PAY_LIAB_CCID            NUMBER(18, 0) ,
    ONE_TIME_PAY_EXPENSE_CCID         NUMBER(18, 0) ,
    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          ,
    MAKE_RATE_MANDATORY_PMT_FLAG      VARCHAR2(4)   ,
    DEFAULT_PMT_EXCHANGE_RATE_TYPE    VARCHAR2(120) ,
    AUDIT_IMPERSONATOR_               VARCHAR2(256) ,
    UNCLAIMED_FUNDS_CCID              NUMBER(18, 0) ,
    CONSTRAINT pk_financials_system_params_all_ PRIMARY KEY (LAST_UPDATE_DATE, ORG_ID, LAST_UPDATE_DATE, ORG_ID)
);
