Previous  Next          Contents  Index  Navigation  Glossary  Library

Customer Interface Table Descriptions and Validation

Below is a detailed description of the five Customer Interface tables and the validation Receivables performs on each column when you run Customer Interface.

RA_CUSTOMERS_INTERFACE

This table stores customer, address, and business purpose information. You do not have to enter values in this table if you do not want to import customers, addresses, or business purposes.

Column Name

Value

ADDRESS1 through 4

Enter the address for your customer in these four columns. You can enter up to four lines of an address.

Validation: If you enter a value in ORIG_SYSTEM_ADDRESS_REF, you must enter a value in ADDRESS1. For multiple rows with the same address reference, insert values in address 1-4.
Destination: RA_ADDRESSES.ADDRESS1, RA_ADDRESSES.ADDRESS2, RA_ADDRESSES.ADDRESS3, RA_ADDRESSES.ADDRESS4

CITY STATE PROVINCE COUNTY POSTAL_CODE COUNTRY

Enter the city, state, province, county, and postal code for this customer's address. You must enter values that have already been defined in AR_LOCATION_VALUES if Address Validation is set to 'Error' and you are calculating sales tax. You must do this for each address component on which your tax location flexfield structure is based.

If Address Validation is set to 'No Validation' and you pass a value that does not exist in AR_LOCATION_VALUES, Customer Interface inserts this value into AR_LOCATION_VALUES.

You must always enter a value for Country.

Validation: The county must exist in FND_TERRITORIES.
Destination: RA_ADDRESSES.CITY, RA_ADDRESSES.STATE, RA_ADDRESSES.PROVINCE, RA_ADDRESSES.COUNTY RA_ADDRESSES.POSTAL_CODE, RA_ADDRESSES.COUNTRY

ADDRESS_KEY

This column is not currently used by Customer Interface.

BILL_TO_ORIG_ ADDRESS_REF

Enter the Bill-To location that you want to associate with the Ship-To address on this record.

Validation: You can enter a value only if the SITE_USE_CODE column in this record is 'Ship-To'. Also, the Bill-To address must exist for this customer or any related customers.
Destination: RA_SITE_USES.BILL_TO_SITE_USE_ID

CUSTOMER_ ATTRIBUTE_ CATEGORY

Enter Descriptive Flexfield category information. These columns are optional.

ADDRESS_ ATTRIBUTE_ CATEGORY

SITE_USE_ ATTRIBUTE_ CATEGORY

Validation: None
Destination: RA_CUSTOMERS.ATTRIBUTE_CATEGORY, RA_ADDRESSES.ATTRIBUTE_CATEGORY, RA_SITE_USES.ATTRIBUTE_CATEGORY

CUSTOMER_ ATTRIBUTE_1 to 15

Enter Descriptive Flexfield information. These columns are optional.

ADDRESS_ ATTRIBUTE_1 to 15

SITE_USE_ ATTRIBUTE_1 to 25

Validation: None
Destination: RA_CUSTOMERS.ATTRIBUTE1 to 15, RA_ADDRESSES.ATTRIBUTE1 to 15, RA_SITE_USES.ATTRIBUTE1 to 25

CUSTOMER_ CATEGORY_CODE

Enter a category to categorize your customer. Use customer categories that you previously defined in the QuickCodes window. This column is required.

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CUSTOMER_CATEGORY'
Destination: RA_CUSTOMERS.CUSTOMER_CATEGORY_ CODE

CUSTOMER_ CLASS_CODE

Enter the customer class for this customer. Use customer classes that you previously defined in the QuickCodes window. This column is optional.

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CUSTOMER CLASS'
Destination: RA_CUSTOMERS.CUSTOMER_CLASS

CUSTOMER_KEY

This column is not currently used by Customer Interface.

CUSTOMER_NAME

Enter the name of your customer. This column is required.

Validation: The same customer reference cannot have different customer names within this table.
Destination: RA_CUSTOMERS.CUSTOMER_NAME

CUSTOMER_ NUMBER

Enter this customer's number.

Validation: Must be null if you are using Automatic Customer Numbering. Must exist if you are not using Automatic Customer Numbering. This value must be unique within RA_CUSTOMERS.
Destination: RA_CUSTOMERS.CUSTOMER_NUMBER

CUSTOMER_STATUS

Enter the status of this customer. This column is required.

Validation: Must equal 'A' for Active or 'I' for Inactive.
Destination: RA_CUSTOMERS.STATUS

CUSTOMER_TYPE

Enter 'Internal' or 'External' to indicate customer type for this customer. This column is optional.

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CUSTOMER_TYPE' Multiple rows with the same customer reference must have the same customer type.

CUST_TAX_CODE SITE_USE_TAX_ CODE

Enter the tax code that you want to assign to this customer or business purpose, depending on the column you choose. You must use tax codes that you previously defined in the Tax Codes and Rates window. These columns are optional.

Validation: Must exist in AR_VAT_TAX.
Destination: RA_CUSTOMERS.TAX_CODE RA_SITE_USES.TAX_CODE

CUST_TAX_ EXEMPT_NUM

This column is not currently used by Customer Interface and must be left blank.

Validation: None
Destination: None

CUST_TAX_ REFERENCE

Enter the tax registration number for this customer. This column is optional.

Validation: None
Destination: RA_CUSTOMERS.TAX_REFERENCE

CUST_SHIP_ VIA_CODE SITE_SHIP_ VIA_CODE

Enter the freight carrier you want to assign to this customer or business purpose, depending on the column you choose. Use freight carriers that you previously defined in the Freight Carriers window. This column is optional.

Validation: Must exist in ORG_FREIGHT.
Destination: RA_CUSTOMERS.SHIP_VIA, RA_SITE_USES.SHIP_VIA

CREATED_BY

Enter the user id that is creating this row. This column is required.

Validation: None
Destination: None

CREATION_DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

DEMAND_ CLASS_CODE

Enter the demand class for this address. Use demand classes that you previously defined in the Demand Classes window. This column is optional.

Validation: Must exist in FND_COMMON_LOOKUPS
Destination: RA_SITE_USES.DEMAND_CLASS_CODE

INSERT_UPDATE_ FLAG

Specify whether you are inserting a new record or updating an existing record. This column is required.

Validation: 'I' for insert or 'U' for update.
Destination: None

INTERFACE_STATUS

This column is used by Customer Interface and should be left null. The Customer Interface program updates this column with all error messages that apply to this interface record. If an interface record has several problems, the Customer Interface program updates this column with multiple error codes.

LOCATION

Enter a shorthand name for this business purpose. You use this value to quickly refer to a business purpose during data entry.

Validation: If automatic site numbering is set to No, you must enter a value in this column. If not, do not enter a value. Values for this column must be unique.
Destination: RA_SITE_USES.LOCATION

Attention: This column is not updatable.

LOCATION_CCID

This column is used by Customer Interface and should be left null. Customer Interface stores the code combination id of valid addresses in this column.

Validation: None
Destination: None

LAST_UPDATED_ BY

Enter the user id that is updating this row. This column is required.

Validation: None
Destination: None

LAST_UPDATE_ DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

LAST_UPDATE_ LOGIN

Enter the login id. This column is optional.

Validation: None
Destination: None

LANGUAGE

Enter the language used by this customer site. This column is optional.

Validation: Must exist in FND_LANGUAGES.NLS_LANGUAGE
Destination: RA_ADDRESSES.LANGUAGE

MESSAGE_ TEXT

This column is used by Customer Interface and should be left null.

Validation: None
Destination: None

ORIG_SYSTEM_ ADDRESS_REF

Enter a value you can use to uniquely identify this address in your original system.

This column forms part of the primary key for RA_CUSTOMERS_INTERFACE. The primary key is a combination of ORIG_SYSTEM_CUSTOMER_REF, ORIG_SYSTEM_ADDRESS_REF, and SITE_USE_CODE.

To enter multiple addresses for a customer, enter multiple records in RA_CUSTOMERS_INTERFACE with identical customer information, but with different address information.

This column is required if you are either inserting or updating address information.

Validation: Must not already exist in RA_ADDRESSES for insert. Must already exist in RA_ADDRESSES for update.
Destination: RA_ADDRESSES.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ CUSTOMER_REF

Enter a value that uniquely identifies this customer in your original system.

This column forms part of the primary key for RA_CUSTOMERS_INTERFACE. The primary key is a combination of ORIG_SYSTEM_CUSTOMER_REF, ORIG_SYSTEM_ADDRESS_REF, and SITE_USE_CODE.

If you are entering a new customer, you must also enter a customer level profile in RA_CUSTOMER_PROFILES_INTERFACE. This column is required.

Validation: Must not exist in RA_CUSTOMERS for insert. Must exist in RA_CUSTOMERS for update. The same customer reference cannot have different customer names within this table. Inserts for this column must be unique.
Destination: RA_CUSTOMERS.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ PARENT_REF

Enter the original system reference of the related customer, if there is one. If you enter a value in this column, the system checks RA_SYSTEM_PARAMETERS.CREATE_RECIPROCAL_FLAG to determine whether the application should automatically create the reciprocal relationship. If RA_SYSTEM_PARAMETERS.CREATE_RECIPROCAL_FLAG is set to 'Y', the system creates an additional, opposite entry in RA_CUSTOMER_RELATIONSHIPS. This column is optional.

Validation: Must exist in RA_CUSTOMERS. ORIG_SYSTEM_REFERENCE. Multiple rows with the same customer reference must have the same ORIG_SYSTEM_PARENT_REF.
Destination: Inserts into RA_CUSTOMER_RELATIONSHIPS. CUSTOMER_ID select CUSTOMER_ID from RA_CUSTOMERS where ORIG_SYSTEM_ REFERENCE = RA_CUSTOMERS_INTERFACE. ORIG_SYSTEM_PARENT_REF.

PRIMARY_SITE_ USE_FLAG

Enter 'Y' or 'N' to indicate whether this is the primary business purpose. Enter a value in this column only if the INSERT_UPDATE_FLAG is 'Y' and you enter a value in ORIG_SYSTEM_ADDRESS_REF.

Validation: Must have only one primary business purpose for each usage (Bill-To, Ship-To, etc.). Must be null, 'Y,' or 'N'. Mandatory when inserting an address and must be null when the record is for updating purposes. Not updateable.
Destination: RA_SITE_USES.PRIMARY_FLAG

REQUEST_ID

This column is used by Customer Interface and should be left null.

SITE_USE_CODE

Enter the business purpose for this customer's address. Use business purposes you previously defined in the Receivables QuickCodes window with a QuickCode type of 'Business purposes for a customer address.'

This column forms part of the primary key for RA_CUSTOMERS_INTERFACE. The primary key is a combination of ORIG_SYSTEM_CUSTOMER_REF, ORIG_SYSTEM_ADDRESS_REF, and SITE_USE_CODE.

If you enter a value in ORIG_SYSTEM_ ADDRESS_REF, you must enter a value in this column. To enter multiple business purposes for an address, enter multiple records in RA_CUSTOMERS_INTERFACE with identical customer and address information, but with different site uses. You can only assign one type of business purpose to each address.

Validation: Must equal a value in AR_LOOKUPS. LOOKUP_CODE where LOOKUP_TYPE = 'SITE_USE_CODE'. This column must be null if you are updating PRIMARY_SITE_USE_FLAG, LOCATION, SITE_SHIP_VIA_CODE, SITE_USE_TAX_CODE or SITE_USE_TAX_REFERENCE. Inserts for this column must be unique.
Destination: RA_SITE_USES.SITE_USE_CODE

SITE_USE_TAX_ EXEMPT_NUM

This column is not currently used by Customer Interface and must be left blank.

Validation: None
Destination: None

SITE_USE_TAX_ REFERENCE

Enter the tax registration number for this site. This column is optional.

Validation: None
Destination: RA_SITE_USES.TAX_REFERENCE

VALIDATED_FLAG

This column is used by Customer Interface and should be left null.

Destination: RA_CUSTOMERS.CUSTOMER_TYPE

WARNING_TEXT

This column is not currently used by Customer Interface.

RA_CUSTOMER_PROFILES_INTERFACE

This table stores customer profile information. If you are entering a new customer in RA_CUSTOMERS_INTERFACE, you must either pass a customer profile class that already exists or customer profile values. You do not have to enter values in this table if you are not entering a new customer or assigning customer profile information to customer addresses.

Column Name

Value

ACCOUNT_STATUS

Enter the status of this customer's account. Use account statuses you previously defined in the Receivables QuickCodes window with a QuickCode type of 'Account Status.' This column is optional.

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'ACCOUNT_STATUS'
Destination: AR_CUSTOMER_PROFILES.ACCOUNT_STATUS

ATTRIBUTE_ CATEGORY AMOUNT_ ATTRIBUTE_ CATEGORY

Enter Descriptive Flexfield category information. These columns are optional.

Validation: None
Destination: AR_CUSTOMER_PROFILES. ATTRIBUTE_CATEGORY AR_CUSTOMER_PROFILE_AMOUNTS. ATTRIBUTE_CATEGORY

ATRIBUTE 1 through 15 AMOUNT_ ATTRIBUTE 1 through 15

Enter Descriptive Flexfield information. These columns are optional.

Validation: None
Destination: AR_CUSTOMER_PROFILES. ATTRIBUTE1 through 15 AR_CUSTOMER_PROFILE_AMOUNTS. ATTRIBUTE1 through 15

AUTO_REC_INCL_ DISPUTED_FLAG

Specify whether to include debit items that have been placed in dispute when you create automatic receipts for your customers. Defaults to No if null.

Validation: Must equal 'Y' (Yes) or 'N' (No)'. Mandatory when profile class is null.
Destination: AR_CUSTOMER_PROFILES.AUTO_REC_ INCL_DISPUTED_FLAG

AUTOCASH_ HIERARCHY_NAME

Enter the AutoCash Rule set to assign to this customer. Use AutoCash Rules sets that you previously defined in the AutoCash Rule Sets window.

Validation: Must exist in AR_AUTOCASH_HIERARCHIES. Mandatory when no profile class specified.
Destination: AR_CUSTOMER_PROFILES. AUTOCASH_HIERARCHY_ID

AUTO_REC_MIN_ RECEIPT_AMOUNT

Enter the minimum receipt amount that must be specified for this customer when you create automatic receipts in this currency. This column is optional.

Validation: None
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. AUTO_REC_MIN_RECEIPT_AMOUNT

CHARGE_ON_ FINANCE_ CHARGE_FLAG

Specify whether you want to compound interest for this customer.

Validation: Must equal 'Y' (Yes) or 'N' (No). Required if INTEREST_CHARGES is set to 'Y' and no profile class is specified. Do not enter a value if INTEREST_CHARGES is null or set to 'N'.
Destination: AR_CUSTOMER_PROFILES.CHARGE_ON_ FINANCE_CHARGE_FLAG

CLEARING_DAYS

Enter the number of clearing days for this customer profile.

Validation: Must be an integer greater than or equal to zero.
Destination: AR_CUSTOMER_PROFILES.CLEARING_DAYS

COLLECTOR_NAME

Enter the collector assigned to this customer profile.

Validation: Must be unique in AR_COLLECTORS and STATUS = 'A' (Active). Mandatory when no profile class specified.
Destination: AR_CUSTOMER_PROFILES.COLLECTOR_ID (derived from CUSTOMER_NAME)

CREATED_BY

Enter the user id that is creating this row. This column is required.

Validation: None
Destination: None

CREATION_DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

CREDIT_BALANCE_ STATEMENTS

Specify whether to send statements to customers with credit balances.

Validation: Must equal 'Y' (Yes) or 'N' (No) Must be 'N' when STATEMENTS = 'N.' Mandatory when no profile class specified. Mandatory when STATEMENTS = Yes. Must be null when STATEMENTS is null.
Destination: AR_CUSTOMER_PROFILES.CREDIT_BALANCE_STATEMENTS

CREDIT_HOLD

Specify whether to put a hold on your customer's credit.

Validation: Must equal 'Y' (Yes) or 'N' (No)'.
Destination: AR_CUSTOMER_PROFILES.CREDIT_HOLD

CREDIT_RATING

Enter the credit rating for this customer. Use credit ratings you previously defined in the Receivables QuickCodes window using the QuickCode Type 'Credit rating for customers.' This column is optional.

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CREDIT_RATING'
Destination: AR_CUSTOMER_PROFILES.CREDIT_RATING

CURRENCY_CODE

Enter a currency code to define customer profile amounts for this customer. Use currency codes previously defined in the Currencies window. Regardless of the value stored in INSERT_UPDATE_FLAG, Customer Interface always inserts and updates customer profile amount values you pass in this table. You must enter a value if any one of the following columns have values:

INTEREST_RATE

MIN_DUNNING_AMOUNT

MIN_DUNNING_INVOICE_AMOUNT

MIN_FC_BALANCE_AMOUNT

MIN_FC_INVOICE_AMOUNT

MIN_STATEMENT_AMOUNT

OVERALL_CREDIT_LIMIT

TRX_CREDIT_LIMIT

Validation: Must exist in FND_CURRENCIES. Mandatory when a profile amount value is populated. (Profile amount columns are listed above.)
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. CURRENCY_CODE

CUSTOMER_PROFILE_CLASS_NAME

Enter the name of the customer profile class you want to assign to this customer or Bill-To address.

If you enter a value in this column, the system will use the profile values associated with this customer profile class. However, you can override these default values by passing new values in the appropriate columns. This column is optional.

If you do not enter a value in this column you must enter values in the following columns:

COLLECTOR_NAME

CREDIT_BALANCE_STATEMENTS

CREDIT_CHECKING

AUTO_REC_INCL_DISPUTED_FLAG

DISCOUNT_TERMS

DUNNING_LETTERS (if 'Y', you must also enter a value in DUNNING_LETTER_SET_NAME)

INTEREST_CHARGES (if 'Y', you must also enter values in INTEREST_PERIOD_DAYS and CHARGE_ON_FINANCE_CHARGE_FLAG.)

STATEMENTS (if 'Y', you must also enter a value in STATEMENT_CYCLE_NAME.)

TOLERANCE

TAX_PRINTING_OPTION

OVERRIDE_TERMS

GROUPING_RULE_NAME

Validation: Must equal AR_CUSTOMER_PROFILE_CLASSES. NAME and STATUS = 'A' (Active)
Destination: AR_CUSTOMER_PROFILES. CUSTOMER_PROFILE_CLASS_ID (derived from CUSTOMER_PROFILE_CLASS_NAME)

DISCOUNT_TERMS CREDIT_CHECKING DUNNING_LETTERS INTEREST_CHARGES STATEMENTS

Specify whether to allow discounts, check credit, send dunning letters, charge interest or and send statements.

Validation: Must equal 'Y' (Yes) or 'N' (No). Mandatory when no profile class specified.
Destination: AR_CUSTOMER_PROFILES.DISCOUNT_TERMS AR_CUSTOMER_PROFILES.CREDIT_CHECKING AR_CUSTOMER_PROFILES. DUNNING_LETTERS AR_CUSTOMER_PROFILES. INTEREST_CHARGES AR_CUSTOMER_PROFILES.STATEMENTS

DISCOUNT_ GRACE_DAYS

Enter the number of days after the discount date that this customer can still take discounts.

Validation: Number must be non-negative (must be >=0). Must be null when DISCOUNT_TERMS is null or 'No'.
Destination: AR_CUSTOMER_PROFILES.DISCOUNT_ GRACE_DAYS

DUNNING_LETTER_ SET_NAME

Enter the dunning letter set to associate with this customer. Use dunning letters that you previously defined in the Dunning Letter Sets window.

Validation: Must exist in AR_DUNNING_LETTER_SETS. Mandatory when DUNNING_LETTERS is Yes. Must be null when DUNNING_LETTERS is No or null.
Destination: AR_CUSTOMER_PROFILES.DUNNING_ LETTER_SET_ID (derived from DUNNING_LETTER_SET_NAME)

GROUPING_ RULE_NAME

Enter the grouping rule to assign to this customer. Use grouping rules you previously defined in the Grouping Rules window.

Validation: Must exist in RA_GROUPING_RULES. Mandatory when no profile class is specified.
Destination: AR_CUSTOMER_PROFILES.GROUPING_ RULE_ID (derived from GROUPING_RULE_NAME)

INTERFACE_STATUS

This column is used by Customer Interface and should be left null. The Customer Interface program updates this column with all error messages which apply to this interface record. If an interface record has several problems, the Customer Interface program updates this column with multiple error codes which are described later in this section.

Validation: None
Destination: None

INSERT_ UPDATE_FLAG

Enter a value to indicate whether you are inserting a new record or updating an existing record.

Regardless of the value you enter in this column, you cannot insert or update profile information in the following columns: CURRENCY_CODE, AUTO_REC_MIN_RECEIPT_AMOUNT, INTEREST_RATE, MAX_INTEREST_CHARGE, MIN_DUNNING_AMOUNT, MIN_DUNNING_INVOICE_AMOUNT, MIN_FC_BALANCE_AMOUNT, MIN_FC_INVOICE_AMOUNT, MIN_STATEMENT_AMOUNT, OVERALL_CREDIT_LIMIT, TRX_CREDIT_LIMIT, AMOUNT_ATTRIBUTE_CATEGORY and AMOUNT_ATTRIBUTE1 through AMOUNT_ATTRIBUTE15.

If you are tying to insert new profile amount information, Customer Interface will automatically insert this information even if this column is set to 'U.' For example, if you want to update the tax printing option value for a record that you have already inserted and at the same time enter a new currency code for this customer profile, enter 'U' in this column. Customer Interface will automatically update the tax printing option value and automatically insert the new currency code.

This column is required.

Validation: I' for insert, 'U' for update
Destination: None

INTEREST_ PERIOD_DAYS

Enter the number of days to which the interest rate refers.

Validation: Number must be positive. Mandatory when INTEREST_CHARGES is Yes. Must be null when INTEREST_CHARGES is No or null.
Destination: AR_CUSTOMER_PROFILES.INTEREST_ PERIOD_DAYS

INTEREST_RATE

Enter the interest rate to charge this customer for this currency. This column is optional.

Validation: None
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. INTEREST_RATE

LAST_UPDATED_ BY

Enter the user id that is updating this row. This column is required.

Validation: None
Destination: None

LAST_UPDATE_ DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

LAST_UPDATE_ LOGIN

Enter the login id. This column is optional.

Validation: None
Destination: None

MAX_INTEREST_ CHARGE

Enter the maximum amount of interest to charge this customer in this currency for each invoice. This column is optional.

Validation: None
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. MAX_INTEREST_CHARGE

MIN_DUNNING_ AMOUNT

Enter the minimum amount in this currency that must be past due for this customer before you select these customers for dunning. This column is optional.

Validation: None
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. MIN_DUNNING_AMOUNT

MIN_DUNNING_ INVOICE_AMOUNT

Enter the minimum invoice amount in this currency that must be past due for this customer before you select these customers for dunning. This column is optional.

Validation: None
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. MIN_DUNNING_INVOICE_AMOUNT

MIN_FC_BALANCE_ AMOUNT

Enter the minimum customer balance that you require before you charge this customer finance charges for past due items in this currency. This column is optional.

Validation: None
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. MIN_FC_BALANCE_AMOUNT

MIN_FC_INVOICE_ AMOUNT

Enter the minimum invoice balance that you require before you charge this customer finance charges for past due items in this currency. This column is optional.

Validation: None
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. MIN_FC_INVOICE_AMOUNT

MIN_STATEMENT_ AMOUNT

Enter the minimum outstanding balance in this currency that this customer must exceed in order for the system to generate a statement. This column is optional.

Validation: None
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. MIN_STATEMENT_AMOUNT

ORIG_SYSTEM_ CUSTOMER_REF

Enter the value that represents the customer or Bill-To site for which you are inserting or updating customer profile information.

Validation: For insert, this customer reference must exist in RA_CUSTOMERS or be successfully validated in RA_CUSTOMERS_INTERFACE. For update, this customer reference must exist in RA_CUSTOMERS.
Destination: AR_CUSTOMER_PROFILES.CUSTOMER_ID (Derived from ORIG_SYSTEM_CUSTOMER_REF)

ORIG_SYSTEM_ ADDRESS_REF

Enter the value that represents the customer Bill-To address for which you are inserting or updating customer profile information. An active Bill-To business purpose must be associated with this address.

Validation: For insert, this address reference must exist in RA_ADDRESSES or be successfully validated in RA_CUSTOMERS_INTERFACE. For update, this address reference must exist in RA_ADDRESSES.
Destination: AR_CUSTOMER_PROFILES.SITE_USE_ID (derived from ORIG_SYSTEM_ADDRESS_REF)

OVERALL_ CREDIT_LIMIT

Enter the total amount of credit to give to this customer in this currency. This column is optional.

Validation: TRX_CREDIT_LIMIT and OVERALL_CREDIT_ LIMIT must both be filled in, or both be null. TRX_CREDIT_LIMIT may not be greater than the OVERALL_CREDIT_LIMIT.

OVERRIDE_TERMS

Specify whether you want to be able to enter payment terms that are different from the payment term you enter in STANDARD_TERM_NAME.

Validation: Must equal 'Y' (Yes) or 'N' (No). Mandatory when no profile class is specified.
Destination: AR_CUSTOMER_PROFILES.OVERRIDE_TERMS

PAYMENT_ GRACE_DAYS

Enter the number of days you will allow this customer's receipt to be overdue before you will initiate collection action.

Validation: Number must be non-negative (must be >=0).
Destination: AR_CUSTOMER_PROFILES.PAYMENT_ GRACE_DAYS

PERCENT_ COLLECTABLE

Enter the percentage of this customer's account balance that you expect to collect regularly. This column is optional.

Validation: Must be between 0 to 100.
Destination: AR_CUSTOMER_PROFILES.PERCENT_ COLLECTABLE

REQUEST_ID

This column is used by Customer Interface, and should be left null.

Validation: None
Destination: None

RISK_CODE

Enter the risk code for this customer. Use risk codes you previously defined in the QuickCodes window with a QuickCode type of 'Customer credit risk.' This column is optional.

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'RISK_CODE'
Destination: AR_CUSTOMER_PROFILES.RISK_CODE

STANDARD_ TERM_NAME

Enter the standard payment terms for this customer. Use payment terms that you previously defined in the Payment Terms window. This column is optional.

Validation: Must exist in RA_TERMS. Must have a unique value. Mandatory when no profile class is specified.
Destination: AR_CUSTOMER_PROFILES.STANDARD_ TERMS. (derived from STANDARD_TERM_NAME)

STATEMENT_ CYCLE_NAME

Enter the statement cycle to associate with this customer. Use statement cycles that you previously defined in the Statement Cycles window.

Validation: Must exist in AR_STATEMENT_CYCLES. Must be null when STATEMENTS is No or null. Mandatory when STATEMENTS is Yes. Must have a unique value.
Destination: AR_CUSTOMER_PROFILES.STATEMENT_ CYCLE_ID (derived from STATEMENT_CYCLE_NAME)

TAX_PRINTING_ OPTION

Enter a tax printing option to indicate how you want to print tax information for this customer's invoices.

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'TAX_PRINTING_OPTION'. Mandatory when no profile class specified.
Destination: AR_CUSTOMER_PROFILES. TAX_PRINTING_OPTION

TOLERANCE

Enter the percent over the credit limit that this customer can exceed before you will act.

Validation: Must be between -100 and 100. Mandatory when no profile class specified.
Destination: RA_CUSTOMER_PROFILES.TOLERANCE

TRX_CREDIT_ LIMIT

Enter the amount of credit for each order that you want to give to this customer in this currency.

Validation: TRX_CREDIT_LIMIT and OVERALL_CREDIT_ LIMIT must both be filled in, or both be null. TRX_CREDIT_LIMIT may not be greater than the OVERALL_CREDIT_LIMIT.
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. TRX_CREDIT_LIMIT

VALIDATED_FLAG

This column is used by Customer Interface, and should be left null.

Validation: None
Destination: None
Destination: AR_CUSTOMER_PROFILE_AMOUNTS. OVERALL_CREDIT_LIMIT

RA_CONTACT_PHONES_INTERFACE

This table stores telephone numbers for customers, addresses and contacts as well as contacts for customers and addresses. You do not have to enter values in this table if you do not want to pass telephone or contact information.

Column Name

Value

CONTACT_ ATTRIBUTE_ CATEGORY PHONE_ ATTRIBUTE_ CATEGORY

Enter Descriptive Flexfield category information. These columns are optional.

Validation: None
Destination: RA_CONTACTS.ATTRIBUTE_CATEGORY RA_PHONES.ATTRIBUTE_CATEGORY

CONTACT_ ATTRIBUTE 1 through 25 PHONE_ ATTRIBUTE 1 through 15

Enter Descriptive Flexfield information. These columns are optional.

Validation: None
Destination: RA_CONTACTS.ATTRIBUTE1 through 25

CONTACT_ FIRST_NAME

Enter the contact's first name. This column is optional.

Validation: None
Destination: RA_CONTACTS.FIRST_NAME

CONTACT_ JOB_TITLE

Enter the job title or responsibility for this contact. Use contact job titles that you previously defined in the QuickCodes window. This column is optional.

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'JOB_TITLE'
Destination: RA_CONTACTS.JOB_TITLE.

CONTACT_ LAST_NAME

Enter the contact's last name. If ORIG_SYSTEM_CONTACT_REF is filled in, then you must enter a value in this column. Otherwise, this column is optional.

Validation: None
Destination: RA_CONTACTS.LAST_NAME

CONTACT_TITLE

Enter the title for this contact. This column is optional.

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CONTACT_TITLE'
Destination: RA_CONTACTS.TITLE

CREATED_BY

Enter the user id that is creating this row. This column is required.

Validation: None
Destination: None

CREATION_DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

INTERFACE_STATUS

This column is used by Customer Interface and should be left null. The Customer Interface program updates this column with all error messages that apply to this interface record. If an interface record has several problems, the Customer Interface program updates this column with multiple error codes.

INSERT_ UPDATE_FLAG

Enter a value to indicate whether you are inserting a new record or updating an existing record. This column is required.

Validation: 'I' for insert, 'U' for update.
Destination: None

LAST_UPDATED_ BY

Enter the user id that is updating this row. This column is required.

Validation: None
Destination: RA_PHONES.ATTRIBUTE1 through 15

LAST_UPDATE_ DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

LAST_UPDATE_ LOGIN

Enter the login id. This column is optional.

Validation: None
Destination: None

ORIG_SYSTEM_ CUSTOMER_REF

Enter a value that you can use to uniquely identify this customer in your original system.

Validation: Must equal RA_CUSTOMERS.ORIG_SYSTEM_ REFERENCE for update. If you are entering either contact or telephone information, you must enter a value in this column.
Destination: RA_CUSTOMERS.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ ADDRESS_REF

Enter a value that you can use to uniquely identify this address in your original system.

If this column is null, the phone or contact that you enter refers to the customer.

Validation: Must equal RA_ADDRESSES.ORIG_SYSTEM_ REFERENCE for update. If you are entering information that refers to an address, such as a contact or telephone, then you must enter a value in this column.
Destination: RA_ADDRESSES.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ CONTACT_REF

Enter a value that you can use to uniquely identify this contact in your original system.

This column forms part of the primary key for RA_CONTACT_PHONES_ INTERFACE. The primary key is a combination of ORIG_SYSTEM_CONTACT_REF and ORIG_SYSTEM_TELEPHONE_ REF.

To enter a contact for a customer, do not enter a value in ORIG_SYSTEM_ ADDRESS_REF.

If you are entering a contact for a specific address, then enter values in both ORIG_ SYSTEM_CUSTOMER_REF and ORIG_SYSTEM_ADDRESS_REF.

Validation: Must equal RA_CONTACTS.ORIG_SYSTEM_ REFERENCE for update. If you are entering contact information or information that refers to a contact, such as a telephone number assigned to a contact, you must enter a value in this column.
Destination: RA_CONTACTS.ORIG_SYSTEM_REFERENCE

ORIG_SYSTEM_ TELEPHONE_REF

Enter a value that you can use to uniquely identify this telephone in your original system.

This column forms part of the primary key for RA_CONTACT_PHONES_ INTERFACE. The primary key is a combination of ORIG_SYSTEM_CONTACT_REF and ORIG_SYSTEM_TELEPHONE_REF.

To enter a telephone for a customer, do not enter values in ORIG_SYSTEM_ADDRESS_REF or ORIG_SYSTEM_CONTACT_REF.

To enter a telephone for a specific address, enter values in ORIG_SYSTEM_CUSTOMER_REF and ORIG_SYSTEM_ADDRESS_ REF.

To enter telephones for a specific contact, enter values in ORIG_SYSTEM_CUSTOMER_REF, ORIG_SYSTEM_CONTACT_REF, and ORIG_SYSTEM_ADDRESS_REF, if the contact is associated with an address.

Validation: Must equal RA_PHONES.ORIG_SYSTEM_ REFERENCE. Mandatory when specifying telephone information.
Destination: RA_PHONES.ORIG_SYSTEM_REFERENCE

REQUEST_ID

This column is used by Customer Interface and should be left null.

TELEPHONE

Enter the telephone number for the customer, address, or contact.

Validation: Mandatory when specifying telephone information (for example, if ORIG_SYSTEM_TELEPHONE_REF is filled in).
Destination: RA_PHONES.PHONE_NUMBER

TELEPHONE_ AREA_CODE TELEPHONE_ EXTENSION

Enter the area code or extension for the telephone number, depending on the column you choose. These columns are optional.

Validation: None
Destination: RA_PHONES.AREA_CODE RA_PHONES.EXTENSION

TELEPHONE_TYPE

Enter the type of telephone number such as General, Fax, or Telex. Use telephone types that you previously defined in the QuickCodes window with a QuickCode type of 'Types of communication used in contacting customers.'

Validation: AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'COMMUNICATION_TYPE.' Mandatory when specifying telephone information (for example, if ORIG_SYSTEM_TELEPHONE_REF is filled in).
Destination: RA_CONTACTS.PHONE_TYPE

VALIDATED_FLAG

This column is used by Customer Interface and should be left null.

RA_CUSTOMER_BANKS_INTERFACE

This table stores bank information for a customer or for a specific Bill-To address. You do not have to enter values in this table if you do not want to insert or assign customer bank information. If you associate an automatic payment method to a customer or a customer's Bill-To business purpose, you must enter a bank account for this customer.

Column Name

Value

ATTRIBUTE_ CATEGORY

Enter Descriptive Flexfield category information. This column is optional.

Validation: None
Destination: AP_BANK_ACCOUNT_USES.ATTRIBUTE_ CATEGORY

ATTRIBUTE 1 through 15

Enter Descriptive Flexfield information. This column is optional.

Validation: None
Destination: AP_BANK_ACCOUNT_USES.ATTRIBUTE 1 through 15

BANK_ ACCOUNT_NUM BANK_ACCOUNT_ CURRENCY_CODE

Enter the account number or currency code for this bank account, depending on the column you choose. This number must be unique within a bank branch.

Validation: If the bank account already exists, do not enter a value. If the bank account does not exist, you must enter a value.
Destination: AP_BANK_ACCOUNT.BANK_ACCOUNT_NUM AP_BANK_ACCOUNTS.CURRENCY_CODE

BANK_ACCOUNT_ INACTIVE_DATE

Enter the date that this bank account becomes inactive. This column is optional.

Validation: Must be a valid date format.
Destination: AP_BANK_ACCOUNTS.INACTIVE_DATE

BANK_ACCOUNT_ DESCRIPTION

Enter a description for this bank account. This column is optional.

Validation: None
Destination: AP_BANK_ACCOUNTS.DESCRIPTION

BANK_ ACCOUNT_CHECK_ DIGITS

Enter the number this bank account prints on checks. This column is optional.

Validation: None
Destination: AP_BANK_ACCOUNT.CHECK_DIGITS

BANK_ ACCOUNT_NAME

Enter the bank account name to assign to this customer or Bill-To address. Use the Banks window to define banks and bank accounts for your customers. If the bank account has not already been defined, Customer Interface will try to create it in AP_BANK_ACCOUNTS. This column is required.

Validation: Must exist in AP_BANK_ACCOUNTS or, if it does not exist, values must exist for BANK_ACCOUNT_CURRENCY_CODE, BANK_ACCOUNT_NUM, BANK_NAME, and BANK_BRANCH_NAME.
Destination: AP_BANK_ACCOUNTS.BANK_ACCOUNT_ NAME

BANK_NAME BANK_ BRANCH_NAME

Enter the name of the bank or bank branch for the account you are inserting. If the bank account does not exist, you must enter a value.

Validation: BANK_NAME together with BANK_BRANCH_NAME must be unique. If the bank account already exists, do not enter a value. Bank_Branch_Name is mandatory when the bank account is not defined.
Destination: AP_BANK_ACCOUNTS.BANK_NAME AP_BANK_BRANCHES.BANK_BRANCH_NAME

BANK_NUMBER

Enter the number of the bank associated with the bank account.

Validation: Must be unique. If the bank account already exists, do not enter a value. If the bank account does not exist, this column is optional.
Destination: AP_BANK_BRANCHES.BANK_NUMBER

BANK_NUM

Enter the number of the bank branch associated with the bank account you are inserting.

Validation: Must be unique. If the bank account already exists, do not enter a value. If the bank account does not exist, this column is optional.
Destination: AP_BANK_BRANCHES.BANK_NUM

BANK_BRANCH_ DESCRIPTION

Enter a description for this bank branch. This column is optional.

Validation: None
Destination: AP_BANK_BRANCHES.DESCRIPTION

BANK_BRANCH_ ADDRESS 1 through 4

Enter the street address, city, county, state, postal code, or province for this bank branch. These columns are optional.

BANK_ BRANCH_CITY

BANK_ BRANCH_COUNTY

BANK_ BRANCH_STATE

BANK_ BRANCH_ZIP

BANK_ BRANCH_PROVINCE

Validation: None
Destination: AP_BANK_BRANCHES.ADDRESS_LINE1-3 AP_BANK_BRANCHES.CITY AP_BANK_BRANCHES.STATE AP_BANK_BRANCHES.ZIP AP_BANK_BRANCHES.PROVINCE

Enter the country for this bank branch. This column is optional.

BANK_ BRANCH_COUNTRY

Validation: Must exist in FND_TERRITORIES.TERRITORY_CODE.
Destination: AP_BANK_BRANCHES.COUNTRY

BANK_ BRANCH_PHONE

Enter the telephone number or telephone area code for this bank branch. These columns are optional.

BANK_ BRANCH_ AREA_CODE

Validation: None
Destination: AP_BANK_BRANCHES.PHONE AP_BANK_BRANCHES.AREA_CODE

BANK_BRANCH_EFT_USER_NUMBER

Enter the Electronic Funds Transfer user id. This column is optional.

Validation: None
Destination: AP_BANK_BRANCHES.EFT_USER_NUMBER

BANK_ACCOUNT_ ATT_CATEGORY

Enter Descriptive Flexfield category information. These columns are optional.

BANK_ BRANCH_ ATT_CATEGORY

Validation: None
Destination: AP_BANK_ACCOUNTS.ATTRIBUTE_ CATEGORY AP_BANK_BRANCHES.ATTRIBUTE_CATEGORY

BANK_ACCOUNT_ ATTRIBUTE 1 through 15

Enter Descriptive Flexfield information. These columns are optional.

BANK_ BRANCH_ ATTRIBUTE 1 through 15

Validation: None
Destination: AP_BANK_ACCOUNTS.ATTRIBUTE1 through 15 AP_BANK_BRANCHES.ATTRIBUTE1 through 15

CREATED_BY

Enter the user id that is creating this row. This column is required.

Validation: None
Destination: None

CREATION_DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

END_DATE

Enter the date that this bank account becomes inactive. This column is optional.

Validation: End Date cannot be before the start date. Customers can be assigned to multiple bank accounts as long as there is no overlapping date range. Must be a valid date format.
Destination: AP_BANK_ACCOUNT_USES.END_DATE

INTERFACE_STATUS

This column is used by Customer Interface and should be left null. The Customer Interface program updates this column with all error messages that apply to this interface record. If an interface record has several problems, the Customer Interface program updates this column with multiple error codes.

Validation: None
Destination: None

LAST_UPDATED_ BY

Enter the user id that is updating this row. This column is required.

Validation: None
Destination: None

LAST_UPDATE_ DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

LAST_UPDATE_ LOGIN

Enter the login id. This column is optional.

Validation: None
Destination: None

ORIG_SYSTEM_ CUSTOMER_REF

Enter the value that represents the customer for which you are inserting bank information. This column is required.

Validation: The customer reference must exist in RA_CUSTOMERS or be successfully validated in RA_CUSTOMERS_INTERFACE.
Destination: AP_BANK_ACCOUNT_USES.CUSTOMER_ID (derived from ORIG_SYSTEM_CUSTOMER_REF)

ORIG_SYSTEM_ ADDRESS_REF

Enter the value that represent the customer address for which you are inserting bank information. An active Bill-To business purpose must be associated with this address. This column is required only if you want to insert bank information for a specific Bill-To address.

Validation: For insert, the address reference must exist in RA_ADDRESSES or be successfully validated in RA_CUSTOMERS_INTERFACE (derived from ORIG_SYSTEM_CUSTOMER_REF)
Destination: AP_BANK_ACCOUNT_USES.CUSTOMER_SITE_USE_ID

PRIMARY_FLAG

Indicates whether this is the primary bank account for this customer or Bill-To address. This column is required.

Validation: Enter 'Y' or 'N.' Only one primary bank account can exist at either the customer level or address level.
Destination: AP_BANK_ACCOUNT_USES.PRIMARY_FLAG

REQUEST_ID

This column is used by Customer Interface, and should be left null.

Validation: None
Destination: None

START_DATE

Enter the starting date that this bank account becomes active. This column is required.

Validation: End Date cannot be before the start date. Customers can be assigned to multiple bank accounts as long as there is no overlapping date range. Must be a valid date format.
Destination: AP_BANK_ACCOUNT_USES.START_DATE

VALIDATED_FLAG

This column is used by Customer Interface, and should be left null.

Validation: None
Destination: None

RA_CUST_PAY_METHOD_INTERFACE

This table stores payment method information for a customer or for a specific Bill-To address. If you associate an automatic payment method to a customer or a customer's Bill-To address, a bank account must exist for this customer. You do not have to enter values in this table if you do not want to assign a payment method to a customer. You cannot insert payment methods using Customer Interface. You must use the Payment Methods window to create new payment methods.

Column Name

Value

ATTRIBUTE_ CATEGORY

Enter Descriptive Flexfield category information. This column is optional.

Validation: None
Destination: RA_CUST_RECEIPT_METHODS. ATTRIBUTE_CATEGORY

ATTRIBUTE 1 through 15

Enter Descriptive Flexfield information. This column is optional.

Validation: None
Destination: RA_CUST_RECEIPT_METHODS.ATTRIBUTE 1 through 15

CREATED_BY

Enter the user id that is creating this row. This column is required.

Validation: None
Destination: None

CREATION_DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

END_DATE

Enter the date that this payment method becomes inactive. This column is optional.

Validation: Customers can be assigned to multiple payment methods as long as there is no overlapping date range. Must be a valid date format.
Destination: RA_CUST_RECEIPT_METHODS.END_DATE

INTERFACE_STATUS

This column is used by Customer Interface and should be left null. The Customer Interface program updates this column with all error messages that apply to this interface record. If an interface record has several problems, the Customer Interface program updates this column with multiple error codes.

Validation: None
Destination: None

LAST_UPDATED_ BY

Enter the user id that is updating this row. This column is required.

Validation: None
Destination: None

LAST_UPDATE_ DATE

Enter the system date. This column is required.

Validation: Must be a valid date format.
Destination: None

LAST_UPDATE_ LOGIN

Enter the login id. This column is optional.

Validation: None
Destination: None

ORIG_SYSTEM_ CUSTOMER_REF

Enter the value that represents the customer for which you are inserting a payment method. This column is required.

Validation: The customer reference must exist in RA_CUSTOMERS or be successfully validated in RA_CUSTOMERS_INTERFACE.
Destination: RA_CUST_RECEIPTS_METHODS. CUSTOMER_ID (derived from ORIG_SYSTEM_CUSTOMER_REF)

ORIG_SYSTEM_ ADDRESS_REF

Enter the value that represents the customer address for which you are inserting a payment method. An active Bill-To business purpose must be associated with this address. This column is required only if you are inserting a payment method for a specific Bill-To address.

Validation: This address reference must exist in RA_ADDRESSES or be successfully validated in RA_CUSTOMERS_INTERFACE.
Destination: RA_CUST_RECEIPT_METHODS.SITE_USE_ID (derived from ORIG_SYSTEM_ADDRESS_REF)

PAYMENT_ METHOD_NAME

Enter the name of the payment method that you want to assign to this customer or Bill-To address. This column is required.

Validation: Must exist in AR_RECEIPT_METHODS.
Destination: RA_CUST_RECEIPTS_METHODS. RECEIPT_METHOD_ID (derived from PAYMENT_METHOD_NAME)

PRIMARY_FLAG

Enter 'Y' or 'N' to indicate whether this is the primary payment method for this customer or Bill-To address. This column is required.

Validation: Only one primary payment method can exist at either the customer level or Bill-To address level.
Destination: RA_CUST_RECEIPTS_METHODS. PRIMARY_FLAG

REQUEST_ID

This column is used by Customer Interface and should be left null.

Validation: None
Destination: None

START_DATE

Enter the starting date that this payment method becomes active. This column is required.

Validation: Customers can be assigned to multiple payment methods as long as there is no overlapping date range. Must be a valid date format.
Destination: RA_CUST_RECEIPT_METHODS.START_DATE

VALIDATED_FLAG

This column is used by Customer Interface and should be left null.

Validation: None
Destination: None

See Also

Customer Import

System Tables Updated by Customer Interface

Interface Data Required to Run Customer Interface

A Sample Customer Import

Creating Unique Customer References

         Previous  Next          Contents  Index  Navigation  Glossary  Library