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: TableSQLAP.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: TablespaceAPPS_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:

SchemaAPPS
SynonymAP_PRODUCT_SETUP