VIEW: AP.FINANCIALS_SYSTEM_PARAMS_ALL#

Source

View Text - Preformatted

select LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE, USER_DEFINED_VENDOR_NUM_CODE USER_DEFINED_VENDOR_NUM_CODE, VENDOR_NUM_START_NUM VENDOR_NUM_START_NUM, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE, FOB_LOOKUP_CODE FOB_LOOKUP_CODE, TERMS_ID TERMS_ID, ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG, PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID, PREPAY_CODE_COMBINATION_ID PREPAY_CODE_COMBINATION_ID, DISC_TAKEN_CODE_COMBINATION_ID DISC_TAKEN_CODE_COMBINATION_ID, FUTURE_PERIOD_LIMIT FUTURE_PERIOD_LIMIT, RESERVE_AT_COMPLETION_FLAG RESERVE_AT_COMPLETION_FLAG, RES_ENCUMB_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID, REQ_ENCUMBRANCE_FLAG REQ_ENCUMBRANCE_FLAG, REQ_ENCUMBRANCE_TYPE_ID REQ_ENCUMBRANCE_TYPE_ID, PURCH_ENCUMBRANCE_FLAG PURCH_ENCUMBRANCE_FLAG, PURCH_ENCUMBRANCE_TYPE_ID PURCH_ENCUMBRANCE_TYPE_ID, INV_ENCUMBRANCE_TYPE_ID INV_ENCUMBRANCE_TYPE_ID, MANUAL_VENDOR_NUM_TYPE MANUAL_VENDOR_NUM_TYPE, INVENTORY_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE, RFQ_ONLY_SITE_FLAG RFQ_ONLY_SITE_FLAG, RECEIPT_ACCEPTANCE_DAYS RECEIPT_ACCEPTANCE_DAYS, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EXPENSE_CHECK_ADDRESS_FLAG EXPENSE_CHECK_ADDRESS_FLAG, TERMS_DATE_BASIS TERMS_DATE_BASIS, USE_POSITIONS_FLAG USE_POSITIONS_FLAG, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID, HOLD_UNMATCHED_INVOICES_FLAG HOLD_UNMATCHED_INVOICES_FLAG, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG, REVISION_SORT_ORDERING REVISION_SORT_ORDERING, VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM, VAT_COUNTRY_CODE VAT_COUNTRY_CODE, RATE_VAR_GAIN_CCID RATE_VAR_GAIN_CCID, RATE_VAR_LOSS_CCID RATE_VAR_LOSS_CCID, ORG_ID ORG_ID, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, VAT_CODE VAT_CODE, MATCH_OPTION MATCH_OPTION, NON_RECOVERABLE_TAX_FLAG NON_RECOVERABLE_TAX_FLAG, TAX_ROUNDING_RULE TAX_ROUNDING_RULE, PRECISION PRECISION, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT, DEFAULT_RECOVERY_RATE DEFAULT_RECOVERY_RATE, CASH_BASIS_ENC_NR_TAX CASH_BASIS_ENC_NR_TAX, FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID, EXPENSE_CLEARING_CCID EXPENSE_CLEARING_CCID, MISC_CHARGE_CCID MISC_CHARGE_CCID, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, RETAINAGE_CODE_COMBINATION_ID RETAINAGE_CODE_COMBINATION_ID from "AP"."FINANCIALS_SYSTEM_PARAMS_ALL"

View Text - HTML Formatted

SELECT LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, USER_DEFINED_VENDOR_NUM_CODE USER_DEFINED_VENDOR_NUM_CODE
, VENDOR_NUM_START_NUM VENDOR_NUM_START_NUM
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE
, FOB_LOOKUP_CODE FOB_LOOKUP_CODE
, TERMS_ID TERMS_ID
, ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG
, PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, PREPAY_CODE_COMBINATION_ID PREPAY_CODE_COMBINATION_ID
, DISC_TAKEN_CODE_COMBINATION_ID DISC_TAKEN_CODE_COMBINATION_ID
, FUTURE_PERIOD_LIMIT FUTURE_PERIOD_LIMIT
, RESERVE_AT_COMPLETION_FLAG RESERVE_AT_COMPLETION_FLAG
, RES_ENCUMB_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID
, REQ_ENCUMBRANCE_FLAG REQ_ENCUMBRANCE_FLAG
, REQ_ENCUMBRANCE_TYPE_ID REQ_ENCUMBRANCE_TYPE_ID
, PURCH_ENCUMBRANCE_FLAG PURCH_ENCUMBRANCE_FLAG
, PURCH_ENCUMBRANCE_TYPE_ID PURCH_ENCUMBRANCE_TYPE_ID
, INV_ENCUMBRANCE_TYPE_ID INV_ENCUMBRANCE_TYPE_ID
, MANUAL_VENDOR_NUM_TYPE MANUAL_VENDOR_NUM_TYPE
, INVENTORY_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE
, RFQ_ONLY_SITE_FLAG RFQ_ONLY_SITE_FLAG
, RECEIPT_ACCEPTANCE_DAYS RECEIPT_ACCEPTANCE_DAYS
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EXPENSE_CHECK_ADDRESS_FLAG EXPENSE_CHECK_ADDRESS_FLAG
, TERMS_DATE_BASIS TERMS_DATE_BASIS
, USE_POSITIONS_FLAG USE_POSITIONS_FLAG
, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID
, HOLD_UNMATCHED_INVOICES_FLAG HOLD_UNMATCHED_INVOICES_FLAG
, EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG
, REVISION_SORT_ORDERING REVISION_SORT_ORDERING
, VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM
, VAT_COUNTRY_CODE VAT_COUNTRY_CODE
, RATE_VAR_GAIN_CCID RATE_VAR_GAIN_CCID
, RATE_VAR_LOSS_CCID RATE_VAR_LOSS_CCID
, ORG_ID ORG_ID
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, VAT_CODE VAT_CODE
, MATCH_OPTION MATCH_OPTION
, NON_RECOVERABLE_TAX_FLAG NON_RECOVERABLE_TAX_FLAG
, TAX_ROUNDING_RULE TAX_ROUNDING_RULE
, PRECISION PRECISION
, MINIMUM_ACCOUNTABLE_UNIT MINIMUM_ACCOUNTABLE_UNIT
, DEFAULT_RECOVERY_RATE DEFAULT_RECOVERY_RATE
, CASH_BASIS_ENC_NR_TAX CASH_BASIS_ENC_NR_TAX
, FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID
, EXPENSE_CLEARING_CCID EXPENSE_CLEARING_CCID
, MISC_CHARGE_CCID MISC_CHARGE_CCID
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, RETAINAGE_CODE_COMBINATION_ID RETAINAGE_CODE_COMBINATION_ID
FROM "AP"."FINANCIALS_SYSTEM_PARAMS_ALL"