VIEW: AP.AP_SYSTEM_PARAMETERS_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, BASE_CURRENCY_CODE BASE_CURRENCY_CODE, RECALC_PAY_SCHEDULE_FLAG RECALC_PAY_SCHEDULE_FLAG, AUTO_CALCULATE_INTEREST_FLAG AUTO_CALCULATE_INTEREST_FLAG, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, INVOICE_NET_GROSS_FLAG INVOICE_NET_GROSS_FLAG, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, CHECK_OVERFLOW_LOOKUP_CODE CHECK_OVERFLOW_LOOKUP_CODE, BATCH_CONTROL_FLAG BATCH_CONTROL_FLAG, TERMS_ID TERMS_ID, ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG, PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID, SALES_TAX_CODE_COMBINATION_ID SALES_TAX_CODE_COMBINATION_ID, DISC_LOST_CODE_COMBINATION_ID DISC_LOST_CODE_COMBINATION_ID, DISC_TAKEN_CODE_COMBINATION_ID DISC_TAKEN_CODE_COMBINATION_ID, HOLD_GAIN_CODE_COMBINATION_ID HOLD_GAIN_CODE_COMBINATION_ID, TRANS_GAIN_CODE_COMBINATION_ID TRANS_GAIN_CODE_COMBINATION_ID, APPLY_ADVANCES_DEFAULT APPLY_ADVANCES_DEFAULT, ADD_DAYS_SETTLEMENT_DATE ADD_DAYS_SETTLEMENT_DATE, COST_OF_MONEY COST_OF_MONEY, DAYS_BETWEEN_CHECK_CYCLES DAYS_BETWEEN_CHECK_CYCLES, FEDERAL_IDENTIFICATION_NUM FEDERAL_IDENTIFICATION_NUM, LOCATION_ID LOCATION_ID, CREATE_EMPLOYEE_VENDOR_FLAG CREATE_EMPLOYEE_VENDOR_FLAG, EMPLOYEE_TERMS_ID EMPLOYEE_TERMS_ID, EMPLOYEE_PAY_GROUP_LOOKUP_CODE EMPLOYEE_PAY_GROUP_LOOKUP_CODE, EMPLOYEE_PAYMENT_PRIORITY EMPLOYEE_PAYMENT_PRIORITY, PREPAY_CODE_COMBINATION_ID PREPAY_CODE_COMBINATION_ID, CONFIRM_DATE_AS_INV_NUM_FLAG CONFIRM_DATE_AS_INV_NUM_FLAG, UPDATE_PAY_SITE_FLAG UPDATE_PAY_SITE_FLAG, DEFAULT_EXCHANGE_RATE_TYPE DEFAULT_EXCHANGE_RATE_TYPE, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID, MAKE_RATE_MANDATORY_FLAG MAKE_RATE_MANDATORY_FLAG, MULTI_CURRENCY_FLAG MULTI_CURRENCY_FLAG, GL_DATE_FROM_RECEIPT_FLAG GL_DATE_FROM_RECEIPT_FLAG, DISC_IS_INV_LESS_TAX_FLAG DISC_IS_INV_LESS_TAX_FLAG, MATCH_ON_TAX_FLAG MATCH_ON_TAX_FLAG, ACCOUNTING_METHOD_OPTION ACCOUNTING_METHOD_OPTION, EXPENSE_POST_OPTION EXPENSE_POST_OPTION, DISCOUNT_TAKEN_POST_OPTION DISCOUNT_TAKEN_POST_OPTION, GAIN_LOSS_POST_OPTION GAIN_LOSS_POST_OPTION, CASH_POST_OPTION CASH_POST_OPTION, FUTURE_PAY_POST_OPTION FUTURE_PAY_POST_OPTION, DATE_FORMAT_LOOKUP_CODE DATE_FORMAT_LOOKUP_CODE, REPLACE_CHECK_FLAG REPLACE_CHECK_FLAG, ONLINE_PRINT_FLAG ONLINE_PRINT_FLAG, EFT_USER_NUMBER EFT_USER_NUMBER, MAX_OUTLAY MAX_OUTLAY, VENDOR_PAY_GROUP_LOOKUP_CODE VENDOR_PAY_GROUP_LOOKUP_CODE, REQUIRE_TAX_ENTRY_FLAG REQUIRE_TAX_ENTRY_FLAG, APPROVALS_OPTION APPROVALS_OPTION, POST_DATED_PAYMENTS_FLAG POST_DATED_PAYMENTS_FLAG, SECONDARY_ACCOUNTING_METHOD SECONDARY_ACCOUNTING_METHOD, SECONDARY_SET_OF_BOOKS_ID SECONDARY_SET_OF_BOOKS_ID, TAKE_VAT_BEFORE_DISCOUNT_FLAG TAKE_VAT_BEFORE_DISCOUNT_FLAG, INTEREST_TOLERANCE_AMOUNT INTEREST_TOLERANCE_AMOUNT, INTEREST_CODE_COMBINATION_ID INTEREST_CODE_COMBINATION_ID, TERMS_DATE_BASIS TERMS_DATE_BASIS, ALLOW_FUTURE_PAY_FLAG ALLOW_FUTURE_PAY_FLAG, AUTO_TAX_CALC_FLAG AUTO_TAX_CALC_FLAG, AUTOMATIC_OFFSETS_FLAG AUTOMATIC_OFFSETS_FLAG, LIABILITY_POST_LOOKUP_CODE LIABILITY_POST_LOOKUP_CODE, INTEREST_ACCTS_PAY_CCID INTEREST_ACCTS_PAY_CCID, LIABILITY_POST_OPTION LIABILITY_POST_OPTION, DISCOUNT_DISTRIBUTION_METHOD DISCOUNT_DISTRIBUTION_METHOD, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID, COMBINED_FILING_FLAG COMBINED_FILING_FLAG, INCOME_TAX_REGION INCOME_TAX_REGION, INCOME_TAX_REGION_FLAG INCOME_TAX_REGION_FLAG, HOLD_UNMATCHED_INVOICES_FLAG HOLD_UNMATCHED_INVOICES_FLAG, ALLOW_DIST_MATCH_FLAG ALLOW_DIST_MATCH_FLAG, ALLOW_FINAL_MATCH_FLAG ALLOW_FINAL_MATCH_FLAG, ALLOW_FLEX_OVERRIDE_FLAG ALLOW_FLEX_OVERRIDE_FLAG, ALLOW_PAID_INVOICE_ADJUST ALLOW_PAID_INVOICE_ADJUST, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, USSGL_TRX_CODE_CONTEXT USSGL_TRX_CODE_CONTEXT, INV_DOC_CATEGORY_OVERRIDE INV_DOC_CATEGORY_OVERRIDE, PAY_DOC_CATEGORY_OVERRIDE PAY_DOC_CATEGORY_OVERRIDE, VENDOR_AUTO_INT_DEFAULT VENDOR_AUTO_INT_DEFAULT, SUMMARY_JOURNALS_DEFAULT SUMMARY_JOURNALS_DEFAULT, RATE_VAR_GAIN_CCID RATE_VAR_GAIN_CCID, RATE_VAR_LOSS_CCID RATE_VAR_LOSS_CCID, TRANSFER_DESC_FLEX_FLAG TRANSFER_DESC_FLEX_FLAG, ALLOW_AWT_FLAG ALLOW_AWT_FLAG, DEFAULT_AWT_GROUP_ID DEFAULT_AWT_GROUP_ID, ALLOW_AWT_OVERRIDE ALLOW_AWT_OVERRIDE, CREATE_AWT_DISTS_TYPE CREATE_AWT_DISTS_TYPE, CREATE_AWT_INVOICES_TYPE CREATE_AWT_INVOICES_TYPE, AWT_INCLUDE_DISCOUNT_AMT AWT_INCLUDE_DISCOUNT_AMT, AWT_INCLUDE_TAX_AMT AWT_INCLUDE_TAX_AMT, ORG_ID ORG_ID, RECON_ACCOUNTING_FLAG RECON_ACCOUNTING_FLAG, AUTO_CREATE_FREIGHT_FLAG AUTO_CREATE_FREIGHT_FLAG, FREIGHT_CODE_COMBINATION_ID FREIGHT_CODE_COMBINATION_ID, 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, ALLOW_SUPPLIER_BANK_OVERRIDE ALLOW_SUPPLIER_BANK_OVERRIDE, USE_MULTIPLE_SUPPLIER_BANKS USE_MULTIPLE_SUPPLIER_BANKS, AUTO_TAX_CALC_OVERRIDE AUTO_TAX_CALC_OVERRIDE, AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG, AMOUNT_INCLUDES_TAX_OVERRIDE AMOUNT_INCLUDES_TAX_OVERRIDE, VAT_CODE VAT_CODE, USE_BANK_CHARGE_FLAG USE_BANK_CHARGE_FLAG, BANK_CHARGE_BEARER BANK_CHARGE_BEARER, ROUNDING_ERROR_CCID ROUNDING_ERROR_CCID, ROUNDING_ERROR_POST_OPTION ROUNDING_ERROR_POST_OPTION, TAX_FROM_PO_FLAG TAX_FROM_PO_FLAG, TAX_FROM_VENDOR_SITE_FLAG TAX_FROM_VENDOR_SITE_FLAG, TAX_FROM_VENDOR_FLAG TAX_FROM_VENDOR_FLAG, TAX_FROM_ACCOUNT_FLAG TAX_FROM_ACCOUNT_FLAG, TAX_FROM_SYSTEM_FLAG TAX_FROM_SYSTEM_FLAG, TAX_FROM_INV_HEADER_FLAG TAX_FROM_INV_HEADER_FLAG, TAX_FROM_TEMPLATE_FLAG TAX_FROM_TEMPLATE_FLAG, TAX_HIER_PO_SHIPMENT TAX_HIER_PO_SHIPMENT, TAX_HIER_VENDOR TAX_HIER_VENDOR, TAX_HIER_VENDOR_SITE TAX_HIER_VENDOR_SITE, TAX_HIER_ACCOUNT TAX_HIER_ACCOUNT, TAX_HIER_SYSTEM TAX_HIER_SYSTEM, TAX_HIER_INVOICE TAX_HIER_INVOICE, TAX_HIER_TEMPLATE TAX_HIER_TEMPLATE, ENFORCE_TAX_FROM_ACCOUNT ENFORCE_TAX_FROM_ACCOUNT, MRC_BASE_CURRENCY_CODE MRC_BASE_CURRENCY_CODE, MRC_SECONDARY_SET_OF_BOOKS_ID MRC_SECONDARY_SET_OF_BOOKS_ID, MATCH_OPTION MATCH_OPTION, GAIN_LOSS_CALC_LEVEL GAIN_LOSS_CALC_LEVEL, WHEN_TO_ACCOUNT_PMT WHEN_TO_ACCOUNT_PMT, WHEN_TO_ACCOUNT_GAIN_LOSS WHEN_TO_ACCOUNT_GAIN_LOSS, FUTURE_DATED_PMT_ACCT_SOURCE FUTURE_DATED_PMT_ACCT_SOURCE, FUTURE_DATED_PMT_LIAB_RELIEF FUTURE_DATED_PMT_LIAB_RELIEF, GL_TRANSFER_ALLOW_OVERRIDE GL_TRANSFER_ALLOW_OVERRIDE, GL_TRANSFER_PROCESS_DAYS GL_TRANSFER_PROCESS_DAYS, GL_TRANSFER_MODE GL_TRANSFER_MODE, GL_TRANSFER_SUBMIT_JOURNAL_IMP GL_TRANSFER_SUBMIT_JOURNAL_IMP, INCLUDE_REPORTING_SOB INCLUDE_REPORTING_SOB, EXPENSE_REPORT_ID EXPENSE_REPORT_ID, PREPAYMENT_TERMS_ID PREPAYMENT_TERMS_ID, CALC_USER_XRATE CALC_USER_XRATE, SORT_BY_ALTERNATE_FIELD SORT_BY_ALTERNATE_FIELD, APPROVAL_WORKFLOW_FLAG APPROVAL_WORKFLOW_FLAG, ALLOW_FORCE_APPROVAL_FLAG ALLOW_FORCE_APPROVAL_FLAG, VALIDATE_BEFORE_APPROVAL_FLAG VALIDATE_BEFORE_APPROVAL_FLAG, XML_PAYMENTS_AUTO_CONFIRM_FLAG XML_PAYMENTS_AUTO_CONFIRM_FLAG, PRORATE_INT_INV_ACROSS_DISTS PRORATE_INT_INV_ACROSS_DISTS, BUILD_PREPAYMENT_ACCOUNTS_FLAG BUILD_PREPAYMENT_ACCOUNTS_FLAG, ENABLE_1099_ON_AWT_FLAG ENABLE_1099_ON_AWT_FLAG, STOP_PREPAY_ACROSS_BAL_FLAG STOP_PREPAY_ACROSS_BAL_FLAG, AUTOMATIC_OFFSETS_CHANGE_FLAG AUTOMATIC_OFFSETS_CHANGE_FLAG, TOLERANCE_ID TOLERANCE_ID, PREPAY_TAX_DIFF_CCID PREPAY_TAX_DIFF_CCID, CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USE_ID, APPROVAL_TIMING APPROVAL_TIMING, SERVICES_TOLERANCE_ID SERVICES_TOLERANCE_ID, RECEIPT_ACCEPTANCE_DAYS RECEIPT_ACCEPTANCE_DAYS, TAX_TOLERANCE TAX_TOLERANCE, TAX_TOL_AMT_RANGE TAX_TOL_AMT_RANGE, ALLOW_INV_THIRD_PARTY_OVRD ALLOW_INV_THIRD_PARTY_OVRD, ALLOW_PYMT_THIRD_PARTY_OVRD ALLOW_PYMT_THIRD_PARTY_OVRD, WITHHOLDING_DATE_BASIS WITHHOLDING_DATE_BASIS, INVRATE_FOR_PREPAY_TAX INVRATE_FOR_PREPAY_TAX from "AP"."AP_SYSTEM_PARAMETERS_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
, BASE_CURRENCY_CODE BASE_CURRENCY_CODE
, RECALC_PAY_SCHEDULE_FLAG RECALC_PAY_SCHEDULE_FLAG
, AUTO_CALCULATE_INTEREST_FLAG AUTO_CALCULATE_INTEREST_FLAG
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, INVOICE_NET_GROSS_FLAG INVOICE_NET_GROSS_FLAG
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, CHECK_OVERFLOW_LOOKUP_CODE CHECK_OVERFLOW_LOOKUP_CODE
, BATCH_CONTROL_FLAG BATCH_CONTROL_FLAG
, TERMS_ID TERMS_ID
, ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG
, PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE
, ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, SALES_TAX_CODE_COMBINATION_ID SALES_TAX_CODE_COMBINATION_ID
, DISC_LOST_CODE_COMBINATION_ID DISC_LOST_CODE_COMBINATION_ID
, DISC_TAKEN_CODE_COMBINATION_ID DISC_TAKEN_CODE_COMBINATION_ID
, HOLD_GAIN_CODE_COMBINATION_ID HOLD_GAIN_CODE_COMBINATION_ID
, TRANS_GAIN_CODE_COMBINATION_ID TRANS_GAIN_CODE_COMBINATION_ID
, APPLY_ADVANCES_DEFAULT APPLY_ADVANCES_DEFAULT
, ADD_DAYS_SETTLEMENT_DATE ADD_DAYS_SETTLEMENT_DATE
, COST_OF_MONEY COST_OF_MONEY
, DAYS_BETWEEN_CHECK_CYCLES DAYS_BETWEEN_CHECK_CYCLES
, FEDERAL_IDENTIFICATION_NUM FEDERAL_IDENTIFICATION_NUM
, LOCATION_ID LOCATION_ID
, CREATE_EMPLOYEE_VENDOR_FLAG CREATE_EMPLOYEE_VENDOR_FLAG
, EMPLOYEE_TERMS_ID EMPLOYEE_TERMS_ID
, EMPLOYEE_PAY_GROUP_LOOKUP_CODE EMPLOYEE_PAY_GROUP_LOOKUP_CODE
, EMPLOYEE_PAYMENT_PRIORITY EMPLOYEE_PAYMENT_PRIORITY
, PREPAY_CODE_COMBINATION_ID PREPAY_CODE_COMBINATION_ID
, CONFIRM_DATE_AS_INV_NUM_FLAG CONFIRM_DATE_AS_INV_NUM_FLAG
, UPDATE_PAY_SITE_FLAG UPDATE_PAY_SITE_FLAG
, DEFAULT_EXCHANGE_RATE_TYPE DEFAULT_EXCHANGE_RATE_TYPE
, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID
, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID
, MAKE_RATE_MANDATORY_FLAG MAKE_RATE_MANDATORY_FLAG
, MULTI_CURRENCY_FLAG MULTI_CURRENCY_FLAG
, GL_DATE_FROM_RECEIPT_FLAG GL_DATE_FROM_RECEIPT_FLAG
, DISC_IS_INV_LESS_TAX_FLAG DISC_IS_INV_LESS_TAX_FLAG
, MATCH_ON_TAX_FLAG MATCH_ON_TAX_FLAG
, ACCOUNTING_METHOD_OPTION ACCOUNTING_METHOD_OPTION
, EXPENSE_POST_OPTION EXPENSE_POST_OPTION
, DISCOUNT_TAKEN_POST_OPTION DISCOUNT_TAKEN_POST_OPTION
, GAIN_LOSS_POST_OPTION GAIN_LOSS_POST_OPTION
, CASH_POST_OPTION CASH_POST_OPTION
, FUTURE_PAY_POST_OPTION FUTURE_PAY_POST_OPTION
, DATE_FORMAT_LOOKUP_CODE DATE_FORMAT_LOOKUP_CODE
, REPLACE_CHECK_FLAG REPLACE_CHECK_FLAG
, ONLINE_PRINT_FLAG ONLINE_PRINT_FLAG
, EFT_USER_NUMBER EFT_USER_NUMBER
, MAX_OUTLAY MAX_OUTLAY
, VENDOR_PAY_GROUP_LOOKUP_CODE VENDOR_PAY_GROUP_LOOKUP_CODE
, REQUIRE_TAX_ENTRY_FLAG REQUIRE_TAX_ENTRY_FLAG
, APPROVALS_OPTION APPROVALS_OPTION
, POST_DATED_PAYMENTS_FLAG POST_DATED_PAYMENTS_FLAG
, SECONDARY_ACCOUNTING_METHOD SECONDARY_ACCOUNTING_METHOD
, SECONDARY_SET_OF_BOOKS_ID SECONDARY_SET_OF_BOOKS_ID
, TAKE_VAT_BEFORE_DISCOUNT_FLAG TAKE_VAT_BEFORE_DISCOUNT_FLAG
, INTEREST_TOLERANCE_AMOUNT INTEREST_TOLERANCE_AMOUNT
, INTEREST_CODE_COMBINATION_ID INTEREST_CODE_COMBINATION_ID
, TERMS_DATE_BASIS TERMS_DATE_BASIS
, ALLOW_FUTURE_PAY_FLAG ALLOW_FUTURE_PAY_FLAG
, AUTO_TAX_CALC_FLAG AUTO_TAX_CALC_FLAG
, AUTOMATIC_OFFSETS_FLAG AUTOMATIC_OFFSETS_FLAG
, LIABILITY_POST_LOOKUP_CODE LIABILITY_POST_LOOKUP_CODE
, INTEREST_ACCTS_PAY_CCID INTEREST_ACCTS_PAY_CCID
, LIABILITY_POST_OPTION LIABILITY_POST_OPTION
, DISCOUNT_DISTRIBUTION_METHOD DISCOUNT_DISTRIBUTION_METHOD
, RATE_VAR_CODE_COMBINATION_ID RATE_VAR_CODE_COMBINATION_ID
, COMBINED_FILING_FLAG COMBINED_FILING_FLAG
, INCOME_TAX_REGION INCOME_TAX_REGION
, INCOME_TAX_REGION_FLAG INCOME_TAX_REGION_FLAG
, HOLD_UNMATCHED_INVOICES_FLAG HOLD_UNMATCHED_INVOICES_FLAG
, ALLOW_DIST_MATCH_FLAG ALLOW_DIST_MATCH_FLAG
, ALLOW_FINAL_MATCH_FLAG ALLOW_FINAL_MATCH_FLAG
, ALLOW_FLEX_OVERRIDE_FLAG ALLOW_FLEX_OVERRIDE_FLAG
, ALLOW_PAID_INVOICE_ADJUST ALLOW_PAID_INVOICE_ADJUST
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT USSGL_TRX_CODE_CONTEXT
, INV_DOC_CATEGORY_OVERRIDE INV_DOC_CATEGORY_OVERRIDE
, PAY_DOC_CATEGORY_OVERRIDE PAY_DOC_CATEGORY_OVERRIDE
, VENDOR_AUTO_INT_DEFAULT VENDOR_AUTO_INT_DEFAULT
, SUMMARY_JOURNALS_DEFAULT SUMMARY_JOURNALS_DEFAULT
, RATE_VAR_GAIN_CCID RATE_VAR_GAIN_CCID
, RATE_VAR_LOSS_CCID RATE_VAR_LOSS_CCID
, TRANSFER_DESC_FLEX_FLAG TRANSFER_DESC_FLEX_FLAG
, ALLOW_AWT_FLAG ALLOW_AWT_FLAG
, DEFAULT_AWT_GROUP_ID DEFAULT_AWT_GROUP_ID
, ALLOW_AWT_OVERRIDE ALLOW_AWT_OVERRIDE
, CREATE_AWT_DISTS_TYPE CREATE_AWT_DISTS_TYPE
, CREATE_AWT_INVOICES_TYPE CREATE_AWT_INVOICES_TYPE
, AWT_INCLUDE_DISCOUNT_AMT AWT_INCLUDE_DISCOUNT_AMT
, AWT_INCLUDE_TAX_AMT AWT_INCLUDE_TAX_AMT
, ORG_ID ORG_ID
, RECON_ACCOUNTING_FLAG RECON_ACCOUNTING_FLAG
, AUTO_CREATE_FREIGHT_FLAG AUTO_CREATE_FREIGHT_FLAG
, FREIGHT_CODE_COMBINATION_ID FREIGHT_CODE_COMBINATION_ID
, 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
, ALLOW_SUPPLIER_BANK_OVERRIDE ALLOW_SUPPLIER_BANK_OVERRIDE
, USE_MULTIPLE_SUPPLIER_BANKS USE_MULTIPLE_SUPPLIER_BANKS
, AUTO_TAX_CALC_OVERRIDE AUTO_TAX_CALC_OVERRIDE
, AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG
, AMOUNT_INCLUDES_TAX_OVERRIDE AMOUNT_INCLUDES_TAX_OVERRIDE
, VAT_CODE VAT_CODE
, USE_BANK_CHARGE_FLAG USE_BANK_CHARGE_FLAG
, BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, ROUNDING_ERROR_CCID ROUNDING_ERROR_CCID
, ROUNDING_ERROR_POST_OPTION ROUNDING_ERROR_POST_OPTION
, TAX_FROM_PO_FLAG TAX_FROM_PO_FLAG
, TAX_FROM_VENDOR_SITE_FLAG TAX_FROM_VENDOR_SITE_FLAG
, TAX_FROM_VENDOR_FLAG TAX_FROM_VENDOR_FLAG
, TAX_FROM_ACCOUNT_FLAG TAX_FROM_ACCOUNT_FLAG
, TAX_FROM_SYSTEM_FLAG TAX_FROM_SYSTEM_FLAG
, TAX_FROM_INV_HEADER_FLAG TAX_FROM_INV_HEADER_FLAG
, TAX_FROM_TEMPLATE_FLAG TAX_FROM_TEMPLATE_FLAG
, TAX_HIER_PO_SHIPMENT TAX_HIER_PO_SHIPMENT
, TAX_HIER_VENDOR TAX_HIER_VENDOR
, TAX_HIER_VENDOR_SITE TAX_HIER_VENDOR_SITE
, TAX_HIER_ACCOUNT TAX_HIER_ACCOUNT
, TAX_HIER_SYSTEM TAX_HIER_SYSTEM
, TAX_HIER_INVOICE TAX_HIER_INVOICE
, TAX_HIER_TEMPLATE TAX_HIER_TEMPLATE
, ENFORCE_TAX_FROM_ACCOUNT ENFORCE_TAX_FROM_ACCOUNT
, MRC_BASE_CURRENCY_CODE MRC_BASE_CURRENCY_CODE
, MRC_SECONDARY_SET_OF_BOOKS_ID MRC_SECONDARY_SET_OF_BOOKS_ID
, MATCH_OPTION MATCH_OPTION
, GAIN_LOSS_CALC_LEVEL GAIN_LOSS_CALC_LEVEL
, WHEN_TO_ACCOUNT_PMT WHEN_TO_ACCOUNT_PMT
, WHEN_TO_ACCOUNT_GAIN_LOSS WHEN_TO_ACCOUNT_GAIN_LOSS
, FUTURE_DATED_PMT_ACCT_SOURCE FUTURE_DATED_PMT_ACCT_SOURCE
, FUTURE_DATED_PMT_LIAB_RELIEF FUTURE_DATED_PMT_LIAB_RELIEF
, GL_TRANSFER_ALLOW_OVERRIDE GL_TRANSFER_ALLOW_OVERRIDE
, GL_TRANSFER_PROCESS_DAYS GL_TRANSFER_PROCESS_DAYS
, GL_TRANSFER_MODE GL_TRANSFER_MODE
, GL_TRANSFER_SUBMIT_JOURNAL_IMP GL_TRANSFER_SUBMIT_JOURNAL_IMP
, INCLUDE_REPORTING_SOB INCLUDE_REPORTING_SOB
, EXPENSE_REPORT_ID EXPENSE_REPORT_ID
, PREPAYMENT_TERMS_ID PREPAYMENT_TERMS_ID
, CALC_USER_XRATE CALC_USER_XRATE
, SORT_BY_ALTERNATE_FIELD SORT_BY_ALTERNATE_FIELD
, APPROVAL_WORKFLOW_FLAG APPROVAL_WORKFLOW_FLAG
, ALLOW_FORCE_APPROVAL_FLAG ALLOW_FORCE_APPROVAL_FLAG
, VALIDATE_BEFORE_APPROVAL_FLAG VALIDATE_BEFORE_APPROVAL_FLAG
, XML_PAYMENTS_AUTO_CONFIRM_FLAG XML_PAYMENTS_AUTO_CONFIRM_FLAG
, PRORATE_INT_INV_ACROSS_DISTS PRORATE_INT_INV_ACROSS_DISTS
, BUILD_PREPAYMENT_ACCOUNTS_FLAG BUILD_PREPAYMENT_ACCOUNTS_FLAG
, ENABLE_1099_ON_AWT_FLAG ENABLE_1099_ON_AWT_FLAG
, STOP_PREPAY_ACROSS_BAL_FLAG STOP_PREPAY_ACROSS_BAL_FLAG
, AUTOMATIC_OFFSETS_CHANGE_FLAG AUTOMATIC_OFFSETS_CHANGE_FLAG
, TOLERANCE_ID TOLERANCE_ID
, PREPAY_TAX_DIFF_CCID PREPAY_TAX_DIFF_CCID
, CE_BANK_ACCT_USE_ID CE_BANK_ACCT_USE_ID
, APPROVAL_TIMING APPROVAL_TIMING
, SERVICES_TOLERANCE_ID SERVICES_TOLERANCE_ID
, RECEIPT_ACCEPTANCE_DAYS RECEIPT_ACCEPTANCE_DAYS
, TAX_TOLERANCE TAX_TOLERANCE
, TAX_TOL_AMT_RANGE TAX_TOL_AMT_RANGE
, ALLOW_INV_THIRD_PARTY_OVRD ALLOW_INV_THIRD_PARTY_OVRD
, ALLOW_PYMT_THIRD_PARTY_OVRD ALLOW_PYMT_THIRD_PARTY_OVRD
, WITHHOLDING_DATE_BASIS WITHHOLDING_DATE_BASIS
, INVRATE_FOR_PREPAY_TAX INVRATE_FOR_PREPAY_TAX
FROM "AP"."AP_SYSTEM_PARAMETERS_ALL"