API&INTERFACE TABLE

Receipt API

AR_RECEIPT_API_PUB.CREATE_CASH

AR_RECEIPT_API_PUB.CREATE_AND_APPLY

 

To bring in Unapplied Receipts and Conversion Receipts for Open Debit items to reduce the balance to the original amount due.

 

          Base tables:   AR_CASH_RECEIPTS

 

Validations:    check the currency and the exchange rate type to assign the exchange rate.

                   Validate bill to the customer.

                   Get bill to site use id.

                   Get the customer trx id for this particular transaction number.

                   Get payment schedule date for the customer trx id.

 

Lockbox interface

          Interface tables:      AR_PAYMENTS_INTERFACE_ALL (Import data from bank file )

 

Base tables:            AR_INTERIM_CASH_RECEIPTS_ALL   AR_INTERIM_CASH_RCPT_LINES_ALL (Validate data in interface table and place in quick cash tables)

 

Related Tables:        AR_BANK_ACCOUNTS_ALL    AR_RECEIPT_METHODS

AR_TRANSMISSIONS_ALL     HZ_CUST_ACCOUNTS          HZ_CUST_SITE_USES_ALL           AR_CASH_RECEIPTS

(POST QUICK CASH -- applies the receipts and updates customer balances)

Concurrent program: nav-> receivables->interfaces->lockbox

         

Validations:    check for valid record type, transmission record id.

                   Validate sum of the payments within the transmission.

                   Identify the lockbox number (no given by a bank to identify a lockbox).

 

AP invoice interface

Interface tables:      AP_INVOICES_INTERFACE    AP_INVOICE_LINES_INTERFACE

                            

          Base tables:            AP_INVOICES_ALL – header information

                             AP_INVOICE_DISTRIBUTIONS_ALL – lines info

 

Concurrent program: Payables Open Interface Import

 

          Validations:    check for valid vendor

                             Check for valid vendor site code.

                             Check if record already exists in payables interface table.

                  

Vendor conversion/interface

          No interface tables

 

          Base tables:   PO_VENDORS           PO_VENDOR_SITES_ALL

                            

No concurrent program as data is directly populated into base tables.

         

          Validations:    check if a vendor already exists with the same name as the TIMSS customer

mail name.

Check if the proper site code and id exists based on the site code from TIMSS.

Check for uppercase value of the vendor name existed in Oracle and in TIMSS, vendor name is mixed case, a new Oracle vendor will not be created.

         

Purchasing:

          Interface Tables                                  Base Tables

          PO_HEADERS_INTERFACE                         PO_HEADERS_ALL

          PO_LINES_INTERFACE                             PO_LINES_ALL

          PO_REQUISITIONS_INTERFACE_ALL PO_REQUISITIONS_HEADERS_ALL

                                                                   PO_REQUISITION_LINES_ALL

                                                                   PO_REQ_DISTRIBUTIONS_ALL

          PO_REQ_DIST_INTERFACE_ALL                 PO_REQ_DISTRIBUTIONS_ALL

          PO_DISTRIBUTIONS_INTERFACE                PO_DISTRIBUTIONS_ALL

          PO_RESCHEDULE_INTERFACE                   PO_REQUISITION_LINES_ALL

 

Requisition import

Interface tables:      PO_REQUISITIONS_INTERFACE_ALL                                    PO_REQ_DIST_INTERFACE_ALL 

 

Basetables:  PO_REQUISITIONS_HEADERS_ALL               

             PO_REQUISITION_LINES_ALL     

             PO_REQ_DISTRIBUTIONS_ALL

 

 Concurrent program:  REQUISITION IMPORT

 

          Validations: check for interface transaction source code, requisition destination type.

          Check for quantity ordered, authorization status type.

 

PO Receipts Interface

          Interface tables:

·         RCV_HEADERS_INTERFACE

·         RCV_TRANSACTIONS_INTERFACE        

 

          Base tables:

·         RCV_SHIPMENT_HEADERS

·         RCV_SHIPMENT_LINES

·         RCV_TRANSACTIONS

 

Concurrent program: RECEIVING OPEN INTERFACE

 

Error messages: 1. Run RECEIVING INTERFACE ERRORS REPORT

                2. Look in PO_INTERFACE_ERRORS

Query to check interface errors: PO_INTERFACE_ERRORS .inteface_transaction_id =

RCV_HEADERS_INTERFACE.header_interface_id and processing_status_code in (‘error’ ,’print’)

GL interface

          Interface tables:      GL_INTERFACE

          Base tables:           

• GL_JE_HEADERS       
• GL_JE_LINES 
• GL_JE_BACTHES

Concurrent Program: Journal Import

                             Journal Posting  --- populates GL_BALANCES

 

Validations:    check SOB, journal source name, journal category name, actual flag

                   A – actual amounts

                   B – budget amounts

                   E – encumbrance amount

If u enter E in the interface table, then enter appropriate encumbrance ID.

B – budget id.

Check if accounting date or GL date based period name is valid (i.e., not closed).

Check if accounting date falls in open or future open period status.

Check chart of accounts id based on Sob id.

Check if valid code combination.

Check if ccid is enabled.

Check if record already exists in GL interface table.

Check if already journal exists in GL application.

 

Validations for the staging table:

Check if the input data file is already uploaded into staging table.

                   Check if the record already exists in the interface table.

Check if the journal already exists in the GL application.  

 

GL budget interface

          Interface tables: GL_BUDGET_INTERFACE      

          Base tables:           

• GL_BUDGETS 
• GL_BUDGET_ASSIGNMENTS 
• GL_BUDGET_TYPES

Concurrent program: Budget Upload

 

Validations: Check Account combination is valid or not. You check this in GL_CODE_COMBINATIONS table.

 

GL daily conversion rates

          Interface tables:      GL_DAILY_RATES_INTERFACE

          Base tables:           

·         GL_DAILY_RATES               

·         GL_DAILY_CONVERSION_TYPES

         

Concurrent Program: Program - Daily Rates Import and Calculation

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/269025/viewspace-432987/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/269025/viewspace-432987/