Important Oracle Account Payables( AP) Tables


Few Important Oracle Account Payables Tables
AP_SUPPLIERS:
·         This table replaces the old PO_VENDORS table.
·         It stores information about your supplier level attributes.
·         Each row includes the purchasing, receiving, invoice, tax, classification, and general information.
·         Oracle Purchasing uses this information to determine active suppliers.
·         The supplier name, legal identifiers of the supplier will be stored in TCA and a reference to the party created in TCA will be stored in AP_SUPPLIERS.PARTY_ID, to link the party record in TCA.

AP_SUPPLIER_SITES_ALL:
·         This table replaces the old PO_VENDOR_SITES_ALL table.
·         It stores information about your supplier site level attributes.
·         There is a row for unique combination of supplier address, operating unit and the business relationship that you have with the supplier.
·         The supplier address information is not maintained in this table and is maintained in TCA. The reference to the internal identifier of address in TCA will be stored in AP_SUPPLIER_SITES_ALL.LOCATION_ID, to link the address record in TCA.
·         Each row includes the supplier reference, purchasing, invoice, and general information.

AP_INVOICES_ALL:
·         It contains records for invoices you enter.
·         There is one row for each invoice you enter.
·         An invoice can have one or more invoice distribution lines and can have one or more scheduled payments.  

AP_INVOICE_LINES_ALL:
·         It contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.
·         An invoice can have one or more invoice lines.
·         An invoice line represents goods (direct or indirect materials), service(s), and/or associated tax/freight/miscellaneous charges invoiced from a supplier.
·         An invoice line should contain all the attributes that are present on the physical or electronic invoice presented by the supplier.

AP_INVOICE_DISTRIBUTIONS_ALL:
·         It holds the distribution information that is manually entered or system-generated.
·         There is one row for each invoice distribution and a distribution must be associated with an invoice.
·         An invoice can have multiple distributions.

AP_INVOICE_PAYMENTS_ALL:
·         It contains records of invoice payments that you made to suppliers.
·         There is one row for each payment you make for each invoice and there is one payment and one invoice for each payment in this table.
·         Oracle Payables application updates this table when you confirm an automatic payment batch, enter a manual payment, or process a Quick payment.
·         When you void a payment, your Oracle Payables inserts an additional payment line that is the negative of the original payment line.
AP_PAYMENT_SCHEDULES_ALL:

·         This table stores information about scheduled payment information on invoices.

AP_PAYMENT_HISTORY_ALL:
·         It stores the clearing/unclearing history for payments.
·         It also stores the maturity history for future dated payments.
·         The table contains a row for each future dated payment, once the future dated payment matures, i.e. becomes negotiable.
·         Any time a payment is cleared or uncleared, a row is inserted into this table for the payment.

AP_BATCHES_ALL:
·         It contains summary information about invoices you enter in batches if you enable the Batch Control Payables option.
·         There is one row for each batch of invoices you enter.
·          If you enable Batch Control, each invoice must correspond to a record in this table.
·          Your Oracle Payables application uses this information to group together invoices that one person entered in a batch.

AP_CHECKS_ALL:
·         It stores information about payments issued to suppliers or refunds received from suppliers. 
·         There is one row for each payment you issue to a supplier or refund received from a supplier.
·         Oracle Payables application uses this information to record payments you make to suppliers or refunds you receive from suppliers.
·         Oracle Payables application stores the supplier name and bank account name for auditing purposes, in case either one is changed after you create the payment. Oracle Payables application also stores address information for all payments.

AP_HOLDS_ALL:
·         It contains information about holds that you or your Oracle Payables application place on an invoice.
·         For non-matching holds, there is one row for each hold placed on an invoice. For matching holds, there is one row for each hold placed on an invoice-shipment match.
·         An invoice may have one or more corresponding rows in this table.
·         Your Oracle Payables application does not pay invoices that have one or more unreleased holds recorded in this table.

AP_BANK_ACCOUNTS_ALL:
·         It contains information about your bank accounts.
·         There is one row for each bank account you define and each bank account must be affiliated with one bank branch.

AP_BANK_ACCOUNT_USES_ALL:
·         It stores information for the internal and external bank accounts you define in Oracle Payables and Oracle Receivables applications.

AP_CARDS_ALL:
·         It stores information about the corporate credit cards issued to your employees by your corporate credit card providers.

AP_TRIAL_BALANCE:
·         It contains denormalized information about invoices and payments posted to the accrual set of books.

COMMENTS

Name

Advance Table In OAF,1,AOL Concepts,18,AP Holds,1,Apps Initialization,1,Blanket Purchase Orders,1,Blanket Releases,1,Careers,9,Common Errors and Solutions,2,Concurrent Programs,10,Contract Purchase Orders,1,Corporate Culture,3,Corporate Ladder,3,Customer Interface,3,Customization,1,De-Normalization,1,EAM,1,EBS Tutorials,10,Education,16,Emterprise Asset Management,1,English,1,Enterprise Asset Management,1,Entrepreneur,1,Error Fixes,1,Executables,2,Extension,1,fnd_user,1,FNDLOAD,1,Global Agreements,1,Guest Posts,7,Handy Scripts,63,Health Tips,1,Important Apps Queries,1,Infographic,3,Interview Preparation,57,Interview Q/A,57,Inventory Org ID,1,Iproc,4,Iprocurement,4,IT,3,jDeveloper,1,Job Search,1,Key Tables In Oracle Apps,5,Learning English,1,MDS,1,Metadata Tables,2,Multi Org Architecture,2,Normalization,1,O2C,1,OAF Interview,49,OAF Personalization,1,OAF Tutorials,52,Operating Unit,1,Oracle Alerts,1,Oracle AP,11,Oracle APIs,4,Oracle Application Object Library,19,Oracle Applications,10,Oracle Apps,2,Oracle Apps Interviews,29,Oracle Apps Tips,8,Oracle Apps Tutorials,97,Oracle AR,18,Oracle Assets,2,Oracle Dabase Structure,2,Oracle Database Architecture,2,Oracle Database Key Tables,3,Oracle EAM,2,Oracle EBS,5,Oracle Financials,2,Oracle Forms And Reports,17,Oracle Forms Interview Questions,6,Oracle Forms Tutorials,6,Oracle GL,4,Oracle Holds,1,Oracle HRMS,10,Oracle Human Resources,1,Oracle Inventory,4,Oracle Payables,1,Oracle Payroll,1,Oracle POTutorials,1,Oracle Purchasing,7,Oracle Reports Interview,9,Oracle Reports Tutorials,3,Oracle System Administrator,4,Oracle Workflow,3,Order Management,2,Organization ID,3,Organizations,3,Performance Tuning,2,Personalization,1,PL/SQL Block,1,PL/SQL Interview Questions,11,PL/SQL Scripts,44,PL/SQL Tutorials,53,Planned Purchase Orders,1,PO,1,PO Action History,1,PO_ACTION_HISTORY,1,POracle Purchasing,1,PR,1,Procedures And Functions,2,Profile Options,2,Purchase Orders,1,Purchase Requisition,2,Receipts,1,Request Groups,1,Responsibility,1,Shell Script,1,SOA Tutorials,4,Social Media,1,Software Industry,2,Software Tools,1,SQL And PL/SQL Interview,38,SQL Interview,51,SQL Scripts,38,SQL Tutorials,43,Standard Purchase Orders,1,Troubleshooting,1,Unexpected error,1,Unix/Linux Commands,3,User,1,Value Sets,1,Weblogic,1,XML Publisher,3,
ltr
item
Oracle Apps Guy: Important Oracle Account Payables( AP) Tables
Important Oracle Account Payables( AP) Tables
Oracle Apps Guy
https://www.oracleappsguy.com/2011/08/important-oracle-account-payables-ap.html
https://www.oracleappsguy.com/
https://www.oracleappsguy.com/
https://www.oracleappsguy.com/2011/08/important-oracle-account-payables-ap.html
true
4186973960539901882
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy