Previous	Next		Contents	Index	Navigation	Glossary	Library

To import the customer illustrated in the above diagram, your import program should load the Customer Interface tables as follows:

RA_CUSTOMERS_INTERFACE

Customer Reference	Name	Address Reference	Address	Site Code
C1001	ACME	A2001	200 Main	BILL_TO
C1001	ACME	A2001	200 Main	SHIP_TO
C1001	ACME	A2002	550 State	SHIP_TO
Table 1 - 11. (Page 1 of 1)

Suggestion: Receivables requires that you separate your city, state, and postal codes, whereas your current system may not. To save time, separate these components in your current system before importing customers into Receivables.

RA_CUSTOMER_PROFILES_INTERFACE

Customer Reference	Address Reference	Profile Name
C1001		Good
C1001	A2001 (This address reference refers to the Bill-To site)	Excellent
Table 1 - 12. (Page 1 of 1)

RA_CONTACT_PHONES_INTERFACE

Customer Reference	Address Reference	Contact Reference	Last Name	Phone Reference	Phone Number
C1001	A2001	S4001	KWAN	S5001	555-1234
C1001	A2001	S4001	KWAN	S5002	555-7000
C1001	A2001	S4002	SMITH
C1001	A2001			S5003	474-8664
C1001	A2002	S4003	BASS
C1001		S4004	RUDIN
C1001				S5004	506-7000
Table 1 - 13. (Page 1 of 1)

RA_CUSTOMER_BANKS_INTERFACE

Customer Reference	Address Reference	Bank Account
C1001		WF-0784
C1001	A2001 (This address reference refers to the Bill-To site)	BA-5431
Table 1 - 14. (Page 1 of 1)

RA_CUST_PAY_METHOD_INTERFACE

Customer Reference	Address Reference	Payment Method
C1001		Automatic1
C1001	A2001 (This address reference refers to the Bill-To site)	Automatic2
Table 1 - 15. (Page 1 of 1)

See Also

Creating Unique Customer References

Importing Customers