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


TABLE: AP.FINANCIALS_SYSTEM_PARAMS_ALL

Object Details
Object Name: FINANCIALS_SYSTEM_PARAMS_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.FINANCIALS_SYSTEM_PARAMS_ALL
Subobject Name:
Status: VALID


FINANCIALS_SYSTEM_PARAMETERS_ALL contains options and
defaults you share between your Oracle Payables
application, and your Oracle Purchasing and Oracle Assets
applications.
You can define
these options and defaults
according to the way you run your business.
This table corresponds to the Financials Options
window.
There is only one row in this table. There is no
primary key for this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FINANCIALS_SYSTEM_PARAMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SET_OF_BOOKS_ID NUMBER (15) Yes Set of books identifier
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 (25)
Payment method default used during supplier entry
USER_DEFINED_VENDOR_NUM_CODE VARCHAR2 (25)
Method of entering supplier numbers
VENDOR_NUM_START_NUM NUMBER

Next automatic supplier number (Oracle Payables applications update as you enter suppliers)
SHIP_TO_LOCATION_ID NUMBER (15)
Ship-to location identifier, default used during supplier entry
BILL_TO_LOCATION_ID NUMBER (15)
Bill-to location identifier, default used during supplier entry
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Type of shipping method, default used during supplier entry
FOB_LOOKUP_CODE VARCHAR2 (25)
Type of free on board, default used during supplier entry
TERMS_ID NUMBER (15)
Payment terms identifier, default used during supplier entry
ALWAYS_TAKE_DISC_FLAG VARCHAR2 (1)
Flag that indicates if available discount for a supplier will be taken, regardless of when the invoice is paid (Y or N), default used during supplier entry
PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 (25)
Basis Oracle Payables applications use for selecting invoices for payment (DUE or DISCOUNT), default used during supplier entry
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Currency code for invoices, default used during supplier entry
PAYMENT_CURRENCY_CODE VARCHAR2 (15)
Currency code for payments, default used during supplier entry
ACCTS_PAY_CODE_COMBINATION_ID NUMBER (15)
Accounting Flexfield identifier for the accounts payable liability account, default used during supplier entry
PREPAY_CODE_COMBINATION_ID NUMBER (15)
Accounting Flexfield identifier for the prepayment account, default used during supplier entry
DISC_TAKEN_CODE_COMBINATION_ID NUMBER (15)
Accounting Flexfield identifier for the discount taken account
FUTURE_PERIOD_LIMIT NUMBER (3)
Maximum number of future periods allowed
RESERVE_AT_COMPLETION_FLAG VARCHAR2 (1)
Flag that indicates if Oracle Purchasing creates an encumbrance journal entry when a requisition is entered (Y) or when the requisition is approved (N)
RES_ENCUMB_CODE_COMBINATION_ID NUMBER (15)
Accounting Flexfield identifier for the reserve for encumbrance account
REQ_ENCUMBRANCE_FLAG VARCHAR2 (1)
Flag that indicates if Oracle Purchasing will create an encumbrance journal entry when a purchase requisition is created (Y or N)
REQ_ENCUMBRANCE_TYPE_ID NUMBER (15)
Requisition encumbrance type identifier
PURCH_ENCUMBRANCE_FLAG VARCHAR2 (1)
Flag that indicates if Oracle Purchasing will create an encumbrance journal entry when a purchase order is created
PURCH_ENCUMBRANCE_TYPE_ID NUMBER (15)
Purchase order encumbrance type identifier
INV_ENCUMBRANCE_TYPE_ID NUMBER (15)
Identifier for encumbrance type assigned to invoice encumbrances
MANUAL_VENDOR_NUM_TYPE VARCHAR2 (25)
Type of supplier number Oracle Payables uses for either automatic or manual supplier number entry
INVENTORY_ORGANIZATION_ID NUMBER (15)
Inventory organization identifier
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
Freight terms
RFQ_ONLY_SITE_FLAG VARCHAR2 (1)
Flag that indicates if supplier site is a RFQ only site
RECEIPT_ACCEPTANCE_DAYS NUMBER (15)
Number of days in receipt acceptance period
BUSINESS_GROUP_ID NUMBER (15)
Business group identifier associated with Oracle Purchasing
EXPENSE_CHECK_ADDRESS_FLAG VARCHAR2 (30)
Employee address for expense checks (H for home or O for office), default used during employee entry
TERMS_DATE_BASIS VARCHAR2 (25)
Date Oracle Payables uses together with payment terms and invoice amount to create an invoice scheduled payment, default used during supplier entry
USE_POSITIONS_FLAG VARCHAR2 (1)
Flag that indicates whether you use approval hierarchies that are based on the positions you define for employees
RATE_VAR_CODE_COMBINATION_ID NUMBER (15)
Not used
HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2 (1)
Default Hold Unmatched Invoices value for supplier (Y or N)
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1)
Default Pay Alone value for suppliers; defaults from supplier to invoices for supplier
REVISION_SORT_ORDERING NUMBER

Not used
VAT_REGISTRATION_NUM VARCHAR2 (20)
Value-Added Tax registration number for your organization
VAT_COUNTRY_CODE VARCHAR2 (15)
European Union (EU)) member state for your organization
RATE_VAR_GAIN_CCID NUMBER (15)
Accounting Flexfield identifier for account used to record exchange rate gains for invoices matched to purchase orders
RATE_VAR_LOSS_CCID NUMBER (15)
Accounting Flexfield identifier for account used to record exchange rate losses for invoices matched to purchase orders
ORG_ID NUMBER (15)
Organization identifier
BANK_CHARGE_BEARER VARCHAR2 (1)
Bank charge bearer
VAT_CODE VARCHAR2 (15)
No longer used
MATCH_OPTION VARCHAR2 (25)
Flag to indicate whether to match invoices to purchase orders (P) or receipts (R)
NON_RECOVERABLE_TAX_FLAG VARCHAR2 (1)
No longer used
TAX_ROUNDING_RULE VARCHAR2 (30)
No longer used
PRECISION NUMBER (1)
No longer used
MINIMUM_ACCOUNTABLE_UNIT NUMBER

No longer used
DEFAULT_RECOVERY_RATE NUMBER

No longer used
CASH_BASIS_ENC_NR_TAX VARCHAR2 (30)
Not currently used
FUTURE_DATED_PAYMENT_CCID NUMBER (15)
Accounting Flexfield identifier for future dated payment account default for Suppliers and Bank accounts
EXPENSE_CLEARING_CCID NUMBER (15)
Credit card expense clearing account
MISC_CHARGE_CCID NUMBER (15)
Accounting Flexfield identifier for the accounts payable miscellaneous account, which is used for iSupplier Portal Invoices
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
RETAINAGE_CODE_COMBINATION_ID NUMBER (15)
Accounting Flexfield Identifier for the account associated with a retainage distribution.
Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SET_OF_BOOKS_ID
,      PAYMENT_METHOD_LOOKUP_CODE
,      USER_DEFINED_VENDOR_NUM_CODE
,      VENDOR_NUM_START_NUM
,      SHIP_TO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      SHIP_VIA_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      TERMS_ID
,      ALWAYS_TAKE_DISC_FLAG
,      PAY_DATE_BASIS_LOOKUP_CODE
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      ACCTS_PAY_CODE_COMBINATION_ID
,      PREPAY_CODE_COMBINATION_ID
,      DISC_TAKEN_CODE_COMBINATION_ID
,      FUTURE_PERIOD_LIMIT
,      RESERVE_AT_COMPLETION_FLAG
,      RES_ENCUMB_CODE_COMBINATION_ID
,      REQ_ENCUMBRANCE_FLAG
,      REQ_ENCUMBRANCE_TYPE_ID
,      PURCH_ENCUMBRANCE_FLAG
,      PURCH_ENCUMBRANCE_TYPE_ID
,      INV_ENCUMBRANCE_TYPE_ID
,      MANUAL_VENDOR_NUM_TYPE
,      INVENTORY_ORGANIZATION_ID
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      FREIGHT_TERMS_LOOKUP_CODE
,      RFQ_ONLY_SITE_FLAG
,      RECEIPT_ACCEPTANCE_DAYS
,      BUSINESS_GROUP_ID
,      EXPENSE_CHECK_ADDRESS_FLAG
,      TERMS_DATE_BASIS
,      USE_POSITIONS_FLAG
,      RATE_VAR_CODE_COMBINATION_ID
,      HOLD_UNMATCHED_INVOICES_FLAG
,      EXCLUSIVE_PAYMENT_FLAG
,      REVISION_SORT_ORDERING
,      VAT_REGISTRATION_NUM
,      VAT_COUNTRY_CODE
,      RATE_VAR_GAIN_CCID
,      RATE_VAR_LOSS_CCID
,      ORG_ID
,      BANK_CHARGE_BEARER
,      VAT_CODE
,      MATCH_OPTION
,      NON_RECOVERABLE_TAX_FLAG
,      TAX_ROUNDING_RULE
,      PRECISION
,      MINIMUM_ACCOUNTABLE_UNIT
,      DEFAULT_RECOVERY_RATE
,      CASH_BASIS_ENC_NR_TAX
,      FUTURE_DATED_PAYMENT_CCID
,      EXPENSE_CLEARING_CCID
,      MISC_CHARGE_CCID
,      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
,      RETAINAGE_CODE_COMBINATION_ID
FROM AP.FINANCIALS_SYSTEM_PARAMS_ALL;

Dependencies

[top of page]

AP.FINANCIALS_SYSTEM_PARAMS_ALL does not reference any database object

AP.FINANCIALS_SYSTEM_PARAMS_ALL is referenced by following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL