DBA Data[Home] [Help] [Dependency Information]


VIEW: AP.AP_SYSTEM_PARAMETERS_ALL#

Object Details
Object Name: AP_SYSTEM_PARAMETERS_ALL#
Object Type: VIEW
Owner: AP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
BASE_CURRENCY_CODE VARCHAR2 (15) Yes
RECALC_PAY_SCHEDULE_FLAG VARCHAR2 (1) Yes
AUTO_CALCULATE_INTEREST_FLAG VARCHAR2 (1) Yes
INVOICE_CURRENCY_CODE VARCHAR2 (15)
PAYMENT_CURRENCY_CODE VARCHAR2 (15)
INVOICE_NET_GROSS_FLAG VARCHAR2 (1)
BANK_ACCOUNT_ID NUMBER (15)
CHECK_OVERFLOW_LOOKUP_CODE VARCHAR2 (25)
BATCH_CONTROL_FLAG VARCHAR2 (1)
TERMS_ID NUMBER (15)
ALWAYS_TAKE_DISC_FLAG VARCHAR2 (1)
PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 (25)
ACCTS_PAY_CODE_COMBINATION_ID NUMBER (15)
SALES_TAX_CODE_COMBINATION_ID NUMBER (15)
DISC_LOST_CODE_COMBINATION_ID NUMBER (15)
DISC_TAKEN_CODE_COMBINATION_ID NUMBER (15)
HOLD_GAIN_CODE_COMBINATION_ID NUMBER (15)
TRANS_GAIN_CODE_COMBINATION_ID NUMBER (15)
APPLY_ADVANCES_DEFAULT VARCHAR2 (4)
ADD_DAYS_SETTLEMENT_DATE NUMBER (15)
COST_OF_MONEY NUMBER

DAYS_BETWEEN_CHECK_CYCLES NUMBER (15)
FEDERAL_IDENTIFICATION_NUM VARCHAR2 (20)
LOCATION_ID NUMBER (15)
CREATE_EMPLOYEE_VENDOR_FLAG VARCHAR2 (1)
EMPLOYEE_TERMS_ID NUMBER (15)
EMPLOYEE_PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
EMPLOYEE_PAYMENT_PRIORITY NUMBER (2)
PREPAY_CODE_COMBINATION_ID NUMBER (15)
CONFIRM_DATE_AS_INV_NUM_FLAG VARCHAR2 (1)
UPDATE_PAY_SITE_FLAG VARCHAR2 (1)
DEFAULT_EXCHANGE_RATE_TYPE VARCHAR2 (30)
GAIN_CODE_COMBINATION_ID NUMBER (15)
LOSS_CODE_COMBINATION_ID NUMBER (15)
MAKE_RATE_MANDATORY_FLAG VARCHAR2 (1)
MULTI_CURRENCY_FLAG VARCHAR2 (1)
GL_DATE_FROM_RECEIPT_FLAG VARCHAR2 (25)
DISC_IS_INV_LESS_TAX_FLAG VARCHAR2 (1)
MATCH_ON_TAX_FLAG VARCHAR2 (1)
ACCOUNTING_METHOD_OPTION VARCHAR2 (25)
EXPENSE_POST_OPTION VARCHAR2 (25)
DISCOUNT_TAKEN_POST_OPTION VARCHAR2 (25)
GAIN_LOSS_POST_OPTION VARCHAR2 (25)
CASH_POST_OPTION VARCHAR2 (25)
FUTURE_PAY_POST_OPTION VARCHAR2 (25)
DATE_FORMAT_LOOKUP_CODE VARCHAR2 (25)
REPLACE_CHECK_FLAG VARCHAR2 (1)
ONLINE_PRINT_FLAG VARCHAR2 (1)
EFT_USER_NUMBER VARCHAR2 (30)
MAX_OUTLAY NUMBER

VENDOR_PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)
REQUIRE_TAX_ENTRY_FLAG VARCHAR2 (1)
APPROVALS_OPTION VARCHAR2 (25)
POST_DATED_PAYMENTS_FLAG VARCHAR2 (1)
SECONDARY_ACCOUNTING_METHOD VARCHAR2 (25)
SECONDARY_SET_OF_BOOKS_ID NUMBER (15)
TAKE_VAT_BEFORE_DISCOUNT_FLAG VARCHAR2 (1)
INTEREST_TOLERANCE_AMOUNT NUMBER

INTEREST_CODE_COMBINATION_ID NUMBER (15)
TERMS_DATE_BASIS VARCHAR2 (25)
ALLOW_FUTURE_PAY_FLAG VARCHAR2 (1)
AUTO_TAX_CALC_FLAG VARCHAR2 (1)
AUTOMATIC_OFFSETS_FLAG VARCHAR2 (1)
LIABILITY_POST_LOOKUP_CODE VARCHAR2 (25)
INTEREST_ACCTS_PAY_CCID NUMBER (15)
LIABILITY_POST_OPTION VARCHAR2 (25)
DISCOUNT_DISTRIBUTION_METHOD VARCHAR2 (25)
RATE_VAR_CODE_COMBINATION_ID NUMBER (15)
COMBINED_FILING_FLAG VARCHAR2 (1)
INCOME_TAX_REGION VARCHAR2 (10)
INCOME_TAX_REGION_FLAG VARCHAR2 (1)
HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2 (1)
ALLOW_DIST_MATCH_FLAG VARCHAR2 (1)
ALLOW_FINAL_MATCH_FLAG VARCHAR2 (1)
ALLOW_FLEX_OVERRIDE_FLAG VARCHAR2 (1)
ALLOW_PAID_INVOICE_ADJUST VARCHAR2 (1)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
INV_DOC_CATEGORY_OVERRIDE VARCHAR2 (1)
PAY_DOC_CATEGORY_OVERRIDE VARCHAR2 (1)
VENDOR_AUTO_INT_DEFAULT VARCHAR2 (1)
SUMMARY_JOURNALS_DEFAULT VARCHAR2 (1)
RATE_VAR_GAIN_CCID NUMBER (15)
RATE_VAR_LOSS_CCID NUMBER (15)
TRANSFER_DESC_FLEX_FLAG VARCHAR2 (1)
ALLOW_AWT_FLAG VARCHAR2 (1)
DEFAULT_AWT_GROUP_ID NUMBER (15)
ALLOW_AWT_OVERRIDE VARCHAR2 (1)
CREATE_AWT_DISTS_TYPE VARCHAR2 (25)
CREATE_AWT_INVOICES_TYPE VARCHAR2 (25)
AWT_INCLUDE_DISCOUNT_AMT VARCHAR2 (1)
AWT_INCLUDE_TAX_AMT VARCHAR2 (1)
ORG_ID NUMBER (15)
RECON_ACCOUNTING_FLAG VARCHAR2 (1)
AUTO_CREATE_FREIGHT_FLAG VARCHAR2 (1)
FREIGHT_CODE_COMBINATION_ID NUMBER (15)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
ALLOW_SUPPLIER_BANK_OVERRIDE VARCHAR2 (1)
USE_MULTIPLE_SUPPLIER_BANKS VARCHAR2 (1)
AUTO_TAX_CALC_OVERRIDE VARCHAR2 (1)
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
AMOUNT_INCLUDES_TAX_OVERRIDE VARCHAR2 (1)
VAT_CODE VARCHAR2 (15)
USE_BANK_CHARGE_FLAG VARCHAR2 (1)
BANK_CHARGE_BEARER VARCHAR2 (1)
ROUNDING_ERROR_CCID NUMBER (15)
ROUNDING_ERROR_POST_OPTION VARCHAR2 (25)
TAX_FROM_PO_FLAG VARCHAR2 (1)
TAX_FROM_VENDOR_SITE_FLAG VARCHAR2 (1)
TAX_FROM_VENDOR_FLAG VARCHAR2 (1)
TAX_FROM_ACCOUNT_FLAG VARCHAR2 (1)
TAX_FROM_SYSTEM_FLAG VARCHAR2 (1)
TAX_FROM_INV_HEADER_FLAG VARCHAR2 (1)
TAX_FROM_TEMPLATE_FLAG VARCHAR2 (1)
TAX_HIER_PO_SHIPMENT NUMBER

TAX_HIER_VENDOR NUMBER

TAX_HIER_VENDOR_SITE NUMBER

TAX_HIER_ACCOUNT NUMBER

TAX_HIER_SYSTEM NUMBER

TAX_HIER_INVOICE NUMBER

TAX_HIER_TEMPLATE NUMBER

ENFORCE_TAX_FROM_ACCOUNT VARCHAR2 (1)
MRC_BASE_CURRENCY_CODE VARCHAR2 (2000)
MRC_SECONDARY_SET_OF_BOOKS_ID VARCHAR2 (2000)
MATCH_OPTION VARCHAR2 (25)
GAIN_LOSS_CALC_LEVEL VARCHAR2 (30)
WHEN_TO_ACCOUNT_PMT VARCHAR2 (30)
WHEN_TO_ACCOUNT_GAIN_LOSS VARCHAR2 (30)
FUTURE_DATED_PMT_ACCT_SOURCE VARCHAR2 (30)
FUTURE_DATED_PMT_LIAB_RELIEF VARCHAR2 (30)
GL_TRANSFER_ALLOW_OVERRIDE VARCHAR2 (1)
GL_TRANSFER_PROCESS_DAYS NUMBER (15)
GL_TRANSFER_MODE VARCHAR2 (1)
GL_TRANSFER_SUBMIT_JOURNAL_IMP VARCHAR2 (1)
INCLUDE_REPORTING_SOB VARCHAR2 (1)
EXPENSE_REPORT_ID NUMBER (15)
PREPAYMENT_TERMS_ID NUMBER (15)
CALC_USER_XRATE VARCHAR2 (1)
SORT_BY_ALTERNATE_FIELD VARCHAR2 (1)
APPROVAL_WORKFLOW_FLAG VARCHAR2 (1) Yes
ALLOW_FORCE_APPROVAL_FLAG VARCHAR2 (1) Yes
VALIDATE_BEFORE_APPROVAL_FLAG VARCHAR2 (1) Yes
XML_PAYMENTS_AUTO_CONFIRM_FLAG VARCHAR2 (1)
PRORATE_INT_INV_ACROSS_DISTS VARCHAR2 (1)
BUILD_PREPAYMENT_ACCOUNTS_FLAG VARCHAR2 (1)
ENABLE_1099_ON_AWT_FLAG VARCHAR2 (1)
STOP_PREPAY_ACROSS_BAL_FLAG VARCHAR2 (1)
AUTOMATIC_OFFSETS_CHANGE_FLAG VARCHAR2 (1)
TOLERANCE_ID NUMBER (15)
PREPAY_TAX_DIFF_CCID NUMBER (15)
CE_BANK_ACCT_USE_ID NUMBER (15)
APPROVAL_TIMING VARCHAR2 (30)
SERVICES_TOLERANCE_ID NUMBER (15)
RECEIPT_ACCEPTANCE_DAYS NUMBER (15)
TAX_TOLERANCE NUMBER

TAX_TOL_AMT_RANGE NUMBER

ALLOW_INV_THIRD_PARTY_OVRD VARCHAR2 (1)
ALLOW_PYMT_THIRD_PARTY_OVRD VARCHAR2 (1)
WITHHOLDING_DATE_BASIS VARCHAR2 (20)
INVRATE_FOR_PREPAY_TAX VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

AP.AP_SYSTEM_PARAMETERS_ALL# references the following:

SchemaAP
TableAP_SYSTEM_PARAMETERS_ALL
AP.AP_SYSTEM_PARAMETERS_ALL# is referenced by following:

SchemaAPPS
SynonymAP_SYSTEM_PARAMETERS
SynonymAP_SYSTEM_PARAMETERS_ALL