Interface
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Interface as PDF for free.
More details
- Words: 288
- Pages: 2
What are the interface tables used for ar invoices...? 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 What are the interface tables used for ar invoices... -------------------------------------------------------------------------------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) � Credit�
Validate Sales Credit Type : Sales Credit to hardcode to �Quota Sales
� 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. What are the interface tables used for ar invoices... -------------------------------------------------------------------------------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
� 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) � Credit�
Validate Sales Credit Type : Sales Credit to hardcode to �Quota Sales
� 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. What are the interface tables used for ar invoices... -------------------------------------------------------------------------------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
