A lookup is any predefined value that was not defined in a setup window. Use the Oracle Payables Lookups window to review and maintain sets of values, or lookups, that you use in Payables.
In some fields, you must select a value from a predefined lists of values. Sometimes the values on the list are items you have defined in a setup window, such as supplier names, payment terms, or tax codes. Other predefined sets of values are lookups, which you can view, and in some cases, update, in the Oracle Payables Lookups window.
A lookup category is called a lookup type, and the allowable values for the lookup type are called lookup names. For example, names of invoice types, such as Standard, Prepayment, Debit Memo, and so on, are lookup names for the lookup type of Invoice Type.
You can add lookup names to some lookup types. For lookup types that you can modify, you can define up to 250 lookup names. For example, you can define additional values for Source, which you specify when you import invoices. You cannot change lookup name values after you save them. To remove an obsolete lookup you can disable the code, enter an end date, or change the meaning and description to match a replacement code.
You can view all Payables lookups in the Oracle Payables Lookups window. However, you can't modify most lookups. For example, the Payables application uses lookups that you do not use for data entry, such as lookups that list exceptions on the Expense Report Export Results page.
If you use Multiple Language Support (MLS), you can define lookups in each of your installed languages. Select Translations from the toolbar or menu to enter the lookup name and description in other languages. When a user selects lookups from a list of values, the lookups on the list will appear in the user's language. For more information, see: the Oracle E-Business Suite User Guide.
For detailed information on defining and updating lookups, see: Lookups.
Note that in the Oracle Purchasing Lookups window you can add values for the following lookups that Payables uses:
FOB. Supplier default for all new purchase orders. See: Entering Supplier Information.
Freight Terms. Supplier default for all new purchase orders. See: Entering Supplier Information.
Minority Group. Supplier classification for reporting purposes. See: Entering Supplier Information.
Pay Group. Groups invoices in payment batches. See: Creating Multiple Payments.
Note: When entering Pay Group, enter the value as Standard. It is case-sensitive. Therefore, use Standard instead of STANDARD.
Supplier Type. Supplier classification for reporting purposes. You enter this value in the Type field of the Classification region of the Suppliers window. This value cannot exceed 25 characters or you will not be able to see it in the Suppliers window. See: Classification Region of the Suppliers window.
You can add values for the following lookup types in this window:
AWT Certificate Types. Define withholding tax certificates. Payables predefines the Standard lookup name. See: Withholding Tax Certificates and Exceptions.
AWT Rate Types. Define Withholding Tax type tax codes. Payables predefines the following: Certificate, Exception, Penalty, and Standard lookup names. See: Tax Codes.
Attention: Oracle Payables uses only the Standard AWT Rate Type. If you want to use an AWT Rate Type other than Standard, you may want to customize Automatic Withholding Tax to perform special behavior based on the AWT Rate Type. See: Customizing Automatic Withholding Tax.
Bank Branch Type. Payables predefines the following Bank Branch values that you enter in the Banks window: ABA, CHIPS, OTHER, SWIFT.
You define the Bank Branch Type lookup code in Receivables.
Card Brand. Used in the Credit Card Programs window. Payables includes four card brands: American Express, Diner's Club, MasterCard, and Visa. See: Setting Up Credit Card Programs.
Date Mask. (This value is no longer used).
Disbursement Type. Used when you define your payment documents in the Manage Payment Documents page accessed from the Banks Accounts page.
Payables predefines three disbursement type values: Combined, Computer Generated, and Recorded.
Don't Pay Reason. Used in the Modify Payment Batch window when you remove all invoices for a supplier site from a payment batch. See: Overview of the Funds Disbursement Process Home Pages.
EDI Payment Format. Payables predefines the following lookup names: CCD, CCP, CTP, CTX, PPD, PPP.
EDI Payment Method. Payables predefines the following lookup names: ACH, BACS, BOP, FEW, FWT, SWT, ZZZ.
EDI Remittance Method. Payables predefines the following lookup names: Do not route, EDI to Third party, EDI to payee, EDI to payee's bank, EDI to payer's bank.
EDI Transaction Handling. Payables predefines the following lookup names: C, D, I, U, Z.
Source. Used when you enter the source of invoices you want to import. See: Payables Open Interface Import Program.
Tax Type. Used to define tax codes. See: Tax Codes.
Payables uses four predefined tax type values: Sales, Use, Offset, and Withholding Tax. In addition, it predefines the following tax codes for installations in Italy and Brazil. For details on these tax types, see:
Italy: Custom Bill, Exempt Vat, Non Taxable, Self Invoice
Brazil: ICMS, IPI
The following lookups are used only in certain localized versions of Payables.
JE_Custom_Bill_Tax Type. Used to define a Custom Tax type tax code. When a distribution has a Custom Tax type, the amount entered is a statistical amount and is reported in the Purchase VAT register.
JE_EEC_VAT_Doc. Not implemented.
JE_Exempt_Tax_Type. Not implemented.
JE_Nontaxable_Tax. Used to define a Non Taxable type tax code.
JE_Self_Invoice_Doc. Not implemented.
JE_Self_Inv_Tax_Type. Used to define a Self Invoice type tax code. When a distribution has a Self Invoice tax type, the amount entered is a statistical amount and is reported in the Self Invoice Purchase and Sales VAT registers.