AP Base Table

AP TABLE:

1.AP_BANK_ACCOUNT_ALL

2. AP_BANK_ACCOUNT_USES_ALL

 Bank_account_Use_id, External_Bank_Account_id

3 .AP_BANK_BRANCHES

 Bank_branch_id, Branch_name, Bank_Branch_Name.

4. AP_CHECKS_ALL

 Check_ammount, Check_id, Vendor_Name, Vendor_Site_Id, vendor_id,

vendor_Site_Code.

5 . AP_Distrubation_Sites_All

 a.Distrubation_set_id, b.Distrubation_set_Name

6. AP_AE_HEADERS_ALL

 Details of account which Transafor to the GL

 It has flag value GL_Tranasfer_flag –‘Y’,N, E’

 Y-> it Transform propery

 N-> Not Transform

 E-> Transform with some error

 Peroiod_Name, AE_Category -> Reconciled_Payments,

 Purchase_Invoice

 Payments



7. AP_AE_LINES_ALL

 Holds the data both transaction in Dbeit and Credit, Thired_Party_Id-Supplier_id

 Tharid_Party_Sub_id –Supplier _Site _id.

 Entered_Dbt, Enter_Credit, Account_debt, Account_Crdt

8. AP_CHECK_STOCKS_ALL

 All Store Document for payment

 Payment_Document_name, Bank_a/c_id,

 Distrubation_Type Lookup Code->Computer_Generated, Combined.

 For manual payments it must be -> combined, Reordered,

 Doc_Category_Code -> Vauchor_Numer for Payments

9. AP_HOLDS_ALL

 All the holds details, and one row for matching Hold for Invoice, and one Non matching

Holds for Invoice.

10 .AP_PAYMENTS_HISTORY_ALL

 Store information about all the payment details

 Transaction_Type, Transaction_bank_Account,

Transaction_Type-> Payment_maturity, Payment_Clearing, Payment_Unclering

11. AP_POL_HEADERS -> Contain data for policy compliance-specific table

 Policy_name, Policy_Id ,

12. AP_MC_CHECK-> Is multiple Currency reporting Table that store reporting

currency information for payments

13.AP_CARDS_ALL

 Holds the details about credit card details

14. AP_INCOMTAX_TYPE

 Holds Details about the income tax type

15 .AP_TAX_CODES_ALL

 Details about the tax_code details , Tax_Code_Name, Tax_id,

16 . AP_TERMS_TL

 The Terms details

17 .AP_AUD_AUDITORS: holds information about the audit details.

AR TABLES

1.AR_ADJUSTMENTS_ALL

 Holds data the amount adjust in Activity, Amount, Acounting Information, Reason,

 And type of adjustments.

2.AR_AGING_BUCKETS

3. AR_TRX_SUMMARY

Detail 1.Total_Invoice_value, Total_Invoice_Count ,Total_cash_Receipt_value,

4 AR_RECEIPT_METHOD: Holds details about payment method.

 Receipt_method_name, Receipt_method_Type

5.