eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	SQLAP.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FINANCIALS_SYSTEM_PARAMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID ORG_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:

AP: FINANCIALS_SYSTEM_PARAMS_ALL#