Anu

• Jan 27th, 2006

 

Customer interface tables:

ra_customer_interface

ra_contant_phones_interface

ra_customer_banks_interface

ra_customer_profiles_interface

ra_cust_pay_method_interface

Invoice interface tables:

ra_interface_lines_all

ra_interface_sales_credits

ra_interface_distributions

ashish_vishwakarma

 Profile Answers by ashish_vishwakarma 

• Mar 7th, 2006

 

Following are the Validation for Autoinvoice:

 

?         AR Transaction Type Validation : Check if the Transaction type provided in data file is defined in AR transaction types(RA_CUST_TRX_TYPES_ALL)

?         Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).

?         Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES).

?         Customer Validation: Check if the Bill to Customer Number, Ship to Customer Number, Bill to Custom Location, Ship to Customer Location provided in the data file is defined in AR Customer(ra_customers).

?         Primary Sales Representative Validation: Sales representative number to be hardcode to ?-3? for ?No Sales Credit.?

?         Term Name : Check if the Term name provided in the data file is defined in Payment terms (RA_TERMS)

?         Validate Sales Credit Type : Sales Credit to hardcode to ?Quota Sales Credit?

?         Inventory Item Validation:  Check if the Item provided in data file is defined in Inventory Items (MTL_SYSTEM_ITEMS).

?         Unit of  Measurement validation: Check if the UOM provided is defined in MTL_UNITS_OF_MEASURE Table

?         Invoice Tax Code Validation : Check if the Tax Code provided in data file is defined in AR_VAT_TAX_ALL_B Table.

?         Invoice GL Date Validation : Check if the GL Data of provided invoices is in open period.Used ARP_UTIL.IS_GL_DATE_VALID API to validate.

 

Regards,

Ashish Vishwakarma

ashish_vishwakarma

 Profile Answers by ashish_vishwakarma 

• Mar 7th, 2006

 

Following are the Interface tables ra_customers_interface_all

ra_contact_phones_int_all

ra_customer_profiles_int_all Following are the base tables

hz_parties

hz_cust_accounts

hz_cust_acct_sites_all

hz_cust_sit_use_all

hz_party_sites

hz_locations

hz_party_site_uses

hz_customer_profiles

hz_organization_profiles

hz_person_profiles

Regards,
Ashish Vikshwakarma