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.AP_PRODUCT_SETUP

Object Details

Object Name:	AP_PRODUCT_SETUP
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_PRODUCT_SETUP
Subobject Name:
Status:	VALID

AP_PRODUCT_SETUP contains the options and defaults you define for operating your Oracle Payables application system across all operating units.
This table contains information such as your default payment terms and payment method. Your Oracle Payables application uses this information to determine default values that are used for supplier creation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
RECORD_NUMBER	NUMBER		Yes	Primary key
SUPPLIER_NUMBERING_METHOD	VARCHAR2	(25)		Method used to enter supplier numbers during new supplier entry, Manual or Automatic.
SUPPLIER_NUM_TYPE	VARCHAR2	(25)		Valid character type for Manual supplier number entry, Numeric or Alphanumeric.
NEXT_AUTO_SUPPLIER_NUM	NUMBER			If supplier entry is Automatic, the system records the next automatic supplier number in this column. This value increases by 1 every time a new supplier number is assigned by the system.
INVOICE_CURRENCY_CODE	VARCHAR2	(15)		This value defaults to the Invoice Currency field for new suppliers.
SUPPLIER_PAY_GROUP_LOOKUP_CODE	VARCHAR2	(25)		This value defaults to the Pay Group field for new suppliers.
TERMS_DATE_BASIS	VARCHAR2	(25)		Date used together with payment terms and invoice amount to create invoice scheduled payment. This value defaults to the Terms Date Basis field for new suppliers.
PAY_DATE_BASIS_LOOKUP_CODE	VARCHAR2	(25)		Basis used for selecting invoices for payment, either Due or Discount. This value defaults to Pay Date Basis field for new suppliers.
TERMS_ID	NUMBER			This value defaults to the Payment Terms field for new suppliers.
PAYMENT_METHOD_LOOKUP_CODE	VARCHAR2	(25)	Yes	This value defaults to the Payment Method field for new suppliers.
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). This value defaults to the Always Take Discount field for new suppliers.
AUTO_CALCULATE_INTEREST_FLAG	VARCHAR2	(1)		Flag that indicates whether the interest invoices are automatically created for past due invoice payments(Y or N). This value defaults to the Create Interest Invoices field for new suppliers.
MATCH_OPTION	VARCHAR2	(1)		Flag to indicate whether to match invoices to Purchase Orders(P) or receipts(R). This value defaults to the Invoice Match Option field for new suppliers.
HOLD_UNMATCHED_INVOICES_FLAG	VARCHAR2	(1)		This value(Y or N) defaults to Hold Unmatched Invoices field for new suppliers.
USE_BANK_CHARGE_FLAG	VARCHAR2	(1)		If this value is Y, then the Use Bank Charges option is enabled, and therefore the Bank Charge feature is enabled. You cannot discount on invoices if this column is set to Y.
BANK_CHARGE_BEARER	VARCHAR2	(1)		This value defaults to the Bank Charge Bearer field for new suppliers.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column

Query Text

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


SELECT RECORD_NUMBER
,      SUPPLIER_NUMBERING_METHOD
,      SUPPLIER_NUM_TYPE
,      NEXT_AUTO_SUPPLIER_NUM
,      INVOICE_CURRENCY_CODE
,      SUPPLIER_PAY_GROUP_LOOKUP_CODE
,      TERMS_DATE_BASIS
,      PAY_DATE_BASIS_LOOKUP_CODE
,      TERMS_ID
,      PAYMENT_METHOD_LOOKUP_CODE
,      ALWAYS_TAKE_DISC_FLAG
,      AUTO_CALCULATE_INTEREST_FLAG
,      MATCH_OPTION
,      HOLD_UNMATCHED_INVOICES_FLAG
,      USE_BANK_CHARGE_FLAG
,      BANK_CHARGE_BEARER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM AP.AP_PRODUCT_SETUP;

Dependencies

[top of page]

AP.AP_PRODUCT_SETUP does not reference any database object

AP.AP_PRODUCT_SETUP is referenced by following:

APPS: AP_PRODUCT_SETUP