Validations In The Customer Interface

What validations are usually performed in the customer interface?

a.       customer name : the same customer reference can’t have different customer names with in this table

HZ_PARTIES.PARTY_NAME

b.      customer number : must be null if your r using automatic customer numbering, must exit if you are not using automatic customer numbering. This value much be unique with in HZ_PARTIES

c.       customer status : must be ‘A’ for active or ‘I’ for inactive

                             HZ_PARTIES_STATUS

d.      bank account num or bank account currency code :

                         if the bank a/c already exist do not enter a value

                         if the bank a/c does not exist  you must enter a value

e.       bank a/c name : it must exist in AP_BANK_ACCOUNTS or if it does not exist values must exist for BANK_A/C_CURRENCY_CODE

                                                                        BANK_A/C_NUM

                                                                        BANK_NAME

                                                                        BANK_BRANCH_NAME

               Note : every interface table has two error msg

1)      Error code.

2)      Error msg.

Other Articles Related To Customer Interface:

1. API’s FOR CUSTOMER INTERFACE?
2. How to send additional customer and address information through customer interafce
3. Important Fields That Customer Interface Does Not Load
4. Interface Tables In customer interface
5. Staging Tables In The Customer Interface
6. Tables Which Cannot Be Updated Through Customer Interface
7. Why does customer interface error out if there is mismatch in address information?