Each row includes the site address, supplier reference, purchasing, payment, bank, and general information. This Oracle Payables Applications Technical Reference Manual contains detailed, uptodate information about the underlying structure of Oracle Payables and Oracle Public Sector Payables. You need one row for each bank combination you define in the Bank Charges window. Possible values are Y or N Encumbrance type identifier Accounting Flexfield identifier for account against which an encumbrance line was created Debit amount encumbered Credit amount encumbered Accounting entry header identifier for accounting entry header associated with the creation of this encumbrance line. An item may be assigned to only one category within a category set, however. Your Oracle Payables application inserts summary payment and invoice information in this table when you confirm a purge process. Detailed Design This section, Chapter 3, contains a detailed description of the Payables database design, including information about each database table and view you might need for your custom reporting or other data requirements.
This trigger captures accounting events for Oracle Payables invoices. Invoice 101 may have 3 accounting events associated with it, the event number acts as a sequence for Invoice 101 Indicates the state of the accounting entries for the accounting event Table where event originating document resides. You must correct the rejection reason an try to retransfer the line. The Task Number list of values in Oracle SelfService Expenses is also based on this view. Oracle Applications Documentation Manager Oracle Corporation 500 Oracle Parkway Redwood Shores, California 94065 U.
This table corresponds to the Recurring Invoices window. Each record in this table corresponds to one card issued to an employee. Use this section to quickly learn what tables your Payables application uses, and how these tables interrelate. Holds can be placed by the system and some holds can be placed manually. The project discount is a default for the task discount The nonlabor standard bill rate schedule that defaults to new tasks created for the project The identifier of the organization that owns the nonlabor standard bill rate schedule The fixed date used to determine the effective bill rates of the standard nonlabor bill rate schedule.
This table corresponds to the header region of the Code Sets window. Valid values are Bank or payables system. Federal Finandals User's Guide B10834-01 115fvug. They also describe additional features added to Payables to meet those requirements. Oracle Purchasing uses Requisition Template lines to let you quickly create requisitions.
Begin withholding in 30 days. This table holds information referenced by the Invoice Holds window. These characteristics include whether the column is part of the tables primary key, whether Oracle8i requires a value for this column, and the data type of the column. It contains information on how to define security, customize menus and manage concurrent processing. Therefore, you should write data into only those tables we identify as interface tables. When you initiate a payment batch, record a manual payment, or create a Quick payment, you can select a payment document that you defined in this table. This table stores the budgetary control packets that need to be approved before creating journal entries.
Employee verification not required and no emp notice Verification required. This table corresponds to the header region of the Expense Reports window. Form A form is a module comprised of closely related windows that are used together to perform a task. Mgr approval not required and no mgr notification Approval Required. Payment terms will default from the supplier site.
You need one row for each line you attach to a document. It associates scheduled payments with collection documents and validates taxes. Each tax reporting entity must have at least one line that contains the balancing segment value for the organization for which you perform your 1099 reporting. After reading this manual, you should be able to convert your existing applications data, integrate your existing applications with your Oracle Payables application, and write custom reports for your Oracle Payables application, as well as read data that you need to perform other tasks. This table forms one of the sources in Inventorys DemandSupply form. This value for the project is a default for the task fixed date.
Oracle Proprietary, Confidential InformationUse Restricted by Contract26 Oracle Payables Applications Technical Reference Manual Database DiagramsThis section graphically represents most of the significant Oracle Payables applications tables and the relationships between them. By studying this view definition, you can understand exactly how a view derives its contents. In addition, it creates holds when validation fails. A value entered in the column in the foreign key must match either a value in the primary key column, or else it must be null. This table corresponds to the Bank Branch region of the Banks window. Forms and Table Views This section lists supplementary views that are not essential to the Release 11i data model, but simplify coding or improve performance for Oracle Developer. You need one row for each shipment archive.