This chapter describes about the customer interface.
This chapter covers the following topics:
You can use Customer Interface to import both party and account information, including accounts that are associated with parties already loaded into your database. However, customer Interface runs independently and does not regard party level information already loaded into your database using Bulk Import. If you plan to use Customer Interface to import accounts that are associated with the imported parties, you must ensure that the source ID alone is unique across all source systems. See:
Bulk Import Overview, Oracle Trading Community Architecture User Guide.
Loading Data into the Interface Tables, Oracle Trading Community Architecture User Guide.
Unique Source IDs for Importing Associated Accounts, Oracle Trading Community Architecture User Guide.
Below is a detailed description of the five Customer Interface tables and the validation performed on each column when you run Customer 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.
Enter the address for your customer in these four columns. You can enter up to four lines of an address.
Variable | Description |
---|---|
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: | HZ_LOCATIONS.ADDRESS1, HZ_LOCATIONS.ADDRESS2, HZ_LOCATIONS.ADDRESS3, and HZ_LOCATIONS.ADDRESS4 |
Enter the default automatic matching rule set defined for the customer profile class.
Enter the city, state, province, county, and postal code for your customer's address. If you are calculating tax on this address, you must enter the correct values that have already been defined in the TCA Geography repository. You must do this for each address component on which your tax validation is enabled. If there is any error, it will display a warning in the Customer Interface Transfer report.
You must always enter a value for Country.
Variable | Description |
---|---|
Validation: | The country must exist in FND_TERRITORIES. |
Destination: | HZ_LOCATIONS.CITY, HZ_LOCATIONS.STATE, HZ_LOCATIONS.PROVINCE, HZ_LOCATIONS.COUNTY, HZ_LOCATIONS.POSTAL_CODE, and HZ_LOCATIONS.COUNTRY |
This column is not currently used by Customer Interface.
The phonetic or Kana (Japanese) representation of a customer address. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_LOCATIONS.ADDRESS_LINES_PHONETIC |
Enter the Bill-To location that you want to associate with the Ship-To address on this record.
Variable | Description |
---|---|
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 your customer or any related customers. |
Destination: | HZ_CUST_SITE_USES_ALL.BILL_TO_SITE_USE_ID |
Enter Descriptive Flexfield category information for your customer. This columns is optional. The descriptive flexfields are updated according to the data provided in the Interface table. If the data provided in the Interface table is Null, then data in the corresponding flexfield is cleared as well.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_ACCOUNTS.ATTRIBUTE_CATEGORY and HZ_PARTIES.ATTRIBUTE_CATEGORY |
Enter Descriptive Flexfield category information for your customer's address. This column is optional. The descriptive flexfields are updated according to the data provided in the Interface table. If the data provided in the Interface table is Null, then data in the corresponding flexfield is cleared as well.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_LOCATIONS.ATTRIBUTE_CATEGORY, HZ_PARTY-SITES.ATTRIBUTE_CATEGORY, and HZ_CUST_ACCT_SITES_ALL.ATTRIBUTE_CATEGORY |
Enter Descriptive Flexfield category information for your customer's site use. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.ATTRIBUTE_CATEGORY |
Enter Descriptive Flexfield information for your customer. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_ACCOUNTS.ATTRIBUTE1 TO 15 and HZ_PARTIES.ATTRIBUTE1 TO 15 |
Enter Descriptive Flexfield information for your customer's address. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_LOCATIONS.ATTRIBUTE1 TO 15, HZ_PARTY_SITES.ATTRIBUTE1 TO 15, and HZ_CUST_ACCT_SITES_ALL.ATTRIBUTE1 TO 15 |
Enter Descriptive Flexfield information for you customer's site use. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.ATTRIBUTE1 TO 15, HZ_PARTIES.ATTRIBUTE1 TO 15, and HZ_CUST_ACCOUNTS.ATTRIBUTE1 TO 15 |
Enter a category to categorize your customer. Use customer categories that you previously defined in the Receivables Lookups window. This column is optional.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CUSTOMER_CATEGORY' |
Destination: | HZ_CUST_ACCOUNTS.CATEGORY_CODE |
Enter the address category code for your customer's site. Use a defined code from the Oracle Receivables Lookups window. This column is optional.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'ADDRESS_CATEGORY.' The lookup code must be enabled. |
Destination: | HZ_CUST_ACCT_SITES_ALL.CUSTOMER_CATEGORY_CODE |
Enter the customer class for your customer. Use customer classes that you previously defined in the Receivables Lookups window. This column is optional.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CUSTOMER CLASS' |
Destination: | HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE |
This column is not currently used by Customer Interface.
Enter the name of your customer. This column is required.
Variable | Description |
---|---|
Validation: | The same customer reference cannot have different customer names within this table. |
Destination: | HZ_PARTIES.PARTY_NAME |
The phonetic or Kana (Japanese) representation of your customer name. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_PARTIES.PARTY_NAME_PHONETIC |
Enter your customer's number.
Variable | Description |
---|---|
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 HZ_CUST_ACCOUNTS. |
Destination: | HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER |
Enter the status of your customer. This column is required.
Variable | Description |
---|---|
Validation: | Must equal 'A' for Active or 'I' for Inactive. If you do not enter a value in this column, the status is defaulted to 'A'. |
Destination: | HZ_CUST_ACCOUNTS.STATUS and HZ_PARTIES_STATUS |
Enter 'Internal' or 'External' to indicate customer type for your customer. This column is optional.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CUSTOMER_TYPE'. Multiple rows with the same customer reference must have the same customer type. |
Destination: | HZ_CUST_ACCOUNTS.CUSTOMER_TYPE |
Enter the tax code that you want to assign to your 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.
Variable | Description |
---|---|
Validation: | Must exist in AR_VAT_TAX. |
Destination: | HZ_CUST_ACCOUNTS.TAX_CODE and HZ_CUST_SITE_USES_ALL.TAX_CODE |
This column is not currently used by Customer Interface and must be left blank.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the tax registration number for your customer. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_PARTIES.TAX_REFERENCE |
Enter the freight carrier you want to assign to your customer or the customer's business purpose, depending on the column you choose. Use freight carriers that you previously defined in the Freight Carriers window. This column is optional.
Variable | Description |
---|---|
Validation: | Must exist in ORG_FREIGHT. |
Destination: | HZ_CUST_ACCOUNTS.SHIP_VIA and HZ_CUST_SITE_USES_ALL.SHIP_VIA |
Enter the user ID that is creating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
Enter the demand class for your customer's address. Use demand classes that you previously defined in the Demand Classes window. This column is optional.
Variable | Description |
---|---|
Validation: | Must exist in FND_COMMON_LOOKUPS |
Destination: | HZ_CUST_SITE_USES_ALL.DEMAND_CLASS_CODE |
If the business purpose for your customer's address is Bill-To, enter the code combination ID for the Receivable account. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.GL_ID_REC |
If the business purpose for your customer's address is Bill-To, enter the code combination ID for the Revenue account. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.GL_ID_REV |
If the business purpose for your customer's address is Bill-To, enter the code combination ID for the Tax account. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.GL_ID_TAX |
If the business purpose for your customer's address is Bill-To, enter the code combination ID for the Freight account. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.GL_ID_FREIGHT |
If the business purpose for your customer's address is Bill-To, enter the code combination ID for the AutoInvoice Clearing Account. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.GL_ID_CLEARING |
If the business purpose for your customer's address is Bill-To, enter the code combination ID for the Unbilled Receivable account. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.GL_ID_UNBILLED |
If the business purpose for your customer's address is Bill-To, enter the code combination ID for the Unearned Revenue account. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.GL_ID_UNEARNED |
Specify whether you are inserting a new record or updating an existing record. This column is required.
Variable | Description |
---|---|
Validation: | 'I' for insert or 'U' for update. |
Destination: | None |
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.
Enter a shorthand name for your customer's business purpose. You use this value to quickly refer to a business purpose during data entry.
Variable | Description |
---|---|
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: | HZ_CUST_SITE_USES_ALL.LOCATION Important: This column is not updatable. |
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.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the user ID that is updating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
Enter the login ID. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the language used by your customer's site. This column is optional.
Variable | Description |
---|---|
Validation: | Must exist in FND_LANGUAGES.NLS_LANGUAGE |
Destination: | HZ_CUST_ACCT_SITES_ALL.LANGUAGE |
This column is used by Customer Interface and should be left null.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the operating unit for which you want the Customer Interface program to validate and import customer information.
This column is optional. If you do not enter a value, the Customer Interface program validates and imports customer information for all the operating units on your access list.
Variable | Description |
---|---|
Validation: | Common Utility MO_GLOBAL.GET_VALID_ORG() validates that the ORG_ID is NOT NULL and is on your access list. |
Destination: | None |
Enter a value you can use to uniquely identify your customer's 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.
Variable | Description |
---|---|
Validation: | Must not exist in HZ_LOCATIONS for insert. Must exist in HZ_CUST_ACCT_SITES_ALL for update. |
Destination: | HZ_LOCATIONS.ORIG_SYSTEM_REFERENCE and HZ_CUST_ACCT_SITES_ALL.ORIG_SYSTEM_REFERENCE |
Enter a value that uniquely identifies your 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.
Variable | Description |
---|---|
Validation: | Must not exist in HZ_PARTIES for insert. Must exist in HZ_CUST_ACCOUNTS for update. The same customer reference cannot have different customer names within this table. Inserts for this column must be unique. |
Destination: | HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE and HZ_PARTIES.ORIG_SYSTEM_REFERENCE |
Enter the original system reference of the related customer, if one exists. If you enter a value in this column, the system checks the Create Reciprocal Customer Accounts parameter for the Customer Interface programs to determine whether the application should automatically create the reciprocal relationship.
If the parameter is set to Yes, the system creates an additional, opposite entry in the HZ_CUST_ACCT_RELATE_ALL table. This column is optional.
Variable | Description |
---|---|
Validation: | Must exist in HZ_PARTIES.ORIG_SYSTEM_REFERENCE and HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE. Multiple rows with the same customer reference must have the same ORIG_SYSTEM_PARENT_REF. |
Destination: | Inserts into HZ_CUST_ACCT_RELATE_ALL.CUST_ACCOUNT_ID. |
Enter a value you can use to unique identify a party in your original system. To create a new customer for an existing party, you must populate this column with the existing party's reference. This column is used for creating multiple customer accounts for one party through Customer Interface.
If you do not provide an original system reference, then the value from the ORIG_SYSTEM_CUSTOMER_REF column becomes the reference for the party as well as the customer.
Variable | Description |
---|---|
Validation: | Must exist in HZ_PARTIES for insert and update. |
Destination: | HZ_PARTIES.ORIG_SYSTEM_REFERENCE |
Enter the party number if the HZ: Generate Party Number profile option is set to No. If the profile option is set to Yes, you must leave this column blank because the party number is automatically generated.
Variable | Description |
---|---|
Validation: | Must exist in HZ_PARTIES for insert and update. |
Destination: | HZ_PARTIES.PARTY_NUMBER |
Enter the party site number if the HZ: Generate Party Site Number profile option is set to No. If the profile option is set to Yes, you must leave this column blank because the party site number is automatically generated.
Variable | Description |
---|---|
Validation: | Must exist in HZ_PARTY_SITES for insert and update. |
Destination: | HZ_PARTY_SITES.SITE_NUMBER |
Enter Y if your customer is a person.
Variable | Description |
---|---|
Validation: | Must be 'Y,' 'N,' or null. |
Destination: | None |
If your customer is a person, then enter the person's first name.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_PARTIES.PERSON_FIRST_NAME and HZ_PERSON_PROFILES.PERSON_FIRST_NAME |
If your customer is a person, then enter the person's last name, also known as the surname or family name.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_PARTIES.PERSON_LAST_NAME and HZ_PERSON_PROFILES.PERSON_LAST_NAME |
Enter 'Y' or 'N' to indicate whether a site use 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. If you do not enter a value in this column, the first active site use is made primary.
Variable | Description |
---|---|
Validation: | Must have only one primary business purpose for each usage (Bill-To, Ship-To, and so on). Must be null, 'Y,' or 'N'. Mandatory when inserting an address and must be null when the record is for updating purposes. Not updatable. |
Destination: | HZ_CUST_SITE_USES_ALL.PRIMARY_FLAG |
This column is used by Customer Interface and should be left null.
Enter the business purpose for your customer's address. Use business purposes you previously defined in the Receivables Lookups window with a lookup 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.
Variable | Description |
---|---|
Validation: | Must equal a value in AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'SITE_USE_CODE'. Inserts for this column must be unique. |
Destination: | HZ_CUST_SITE_USES_ALL.SITE_USE_CODE |
This column is not currently used by Customer Interface and must be left blank.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the tax registration number for your customer's site. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_SITE_USES_ALL.TAX_REFERENCE |
Enter the territory associated with your customer record.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_ACCT_SITES_ALL.TERRITORY |
The translated customer name.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_ACCT_SITES_ALL.TRANSLATED_CUSTOMER_NAME |
This column is used by Customer Interface and should be left null.
Variable | Description |
---|---|
Destination: | HZ_CUST_ACCOUNTS.CUSTOMER_TYPE |
This column is not currently used by Customer Interface.
The uniform resource locator (URL) for your customer's home page on the World Wide Web. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CONTACT_POINTS.URL |
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.
The HZ_CUST_PROFILE_CLASSES table contains values from the profile class that you pass, or from the seeded profile class if you do not provide a class. During import, these values populate the HZ_CUSTOMER_PROFILES table.
The data in the RA_CUSTOMERS_PROFILES_INTERFACE table also populates the HZ_CUSTOMER_PROFILES table. Because both sources can provide values for the same column in the HZ_CUSTOMER_PROFILES table, the resulting value depends on whether the value from the RA_CUSTOMER_PROFILES_INTERFACE table is null or not.
Value is not null - The value from the RA_CUSTOMER_PROFILES_INTERFACE table always overwrites any value from the HZ_CUST_PROFILE_CLASSES table.
Value is null
These fields in the HZ_CUSTOMER_PROFILES table still take the null value from the RA_CUSTOMER_PROFILES_INTERFACES table:
AUTO_REC_INCL_DISPUTED_FLAG
CREDIT_HOLD
CREDIT_RATING
PERCENT_COLLECTABLE
RISK_CODE
ATTRIBUTE_CATEGORY
ATTRIBUTE1 through ATTRIBUTE15
CLEARING_DAYS
GLOBAL_ATTRIBUTE_CATEGORY
GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE20
Note: During the update of customer profiles, the RISK_CODES and CREDIT_RATING fields in the HZ_CUSTOMER_PROFILES table retain their existing values when the values for these fields are null in the RA_CUSTOMER_PROFILES_INTERFACES table.
These fields in the HZ_CUSTOMER_PROFILES table take instead the value from the HZ_CUST_PROFILE_CLASSES table:
COLLECTOR_ID (referenced by the COLLECTOR_NAME column in the RA_CUSTOMER_PROFILES_INTERFACE table)
CREDIT_BALANCE_STATEMENTS
CREDIT_CHECKING
DISCOUNT_TERMS
DUNNING_LETTERS
INTEREST_CHARGES
STATEMENTS
TOLERANCE
TAX_PRINTING_OPTION
AUTOCASH_HIERARCHY_ID (referenced by the AUTOCASH_HIERARCHY_NAME column in the RA_CUSTOMER_PROFILES_INTERFACE table)
DISCOUNT_GRACE_DAYS
INTEREST_PERIOD_DAYS
OVERRIDE_TERMS
PAYMENT_GRACE_DAYS
STANDARD_TERMS (referenced by the STANDARD_TERM_NAME column in the RA_CUSTOMER_PROFILES_INTERFACE table)
STATEMENT_CYCLE_ID (referenced by the STATEMENT_CYCLE_NAME column in the RA_CUSTOMER_PROFILES_INTERFACE table)
CHARGE_ON_FINANCE_CHARGE_FLAG
GROUPING_RULE_ID (referenced by the GROUPING_RULE_NAME column in the RA_CUSTOMER_PROFILES_INTERFACE table)
CONS_INV_FLAG
CONS_INV_TYPE
AUTOCASH_HIERARCHY_ID_FOR_ADR (referenced by the AUTOCASH_HIERARCHY_NAME_ADR column in the RA_CUSTOMER_PROFILES_INTERFACE table)
LOCKBOX_MATCHING_OPTION
CREDIT_ANALYST_ID (not exposed in the RA_CUSTOMER_PROFILES_INTERFACE table)
REVIEW_CYCLE (not exposed in the RA_CUSTOMER_PROFILES_INTERFACE table)
Enter the status of your customer's account. Use account statuses you previously defined in the Receivables Lookups window with a lookup type of 'Account Status.' This column is optional.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'ACCOUNT_STATUS' and ENABLED_FLAG='Y' |
Destination: | HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS |
Enter Descriptive Flexfield category information. These columns are optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUSTOMER_PROFILES.ATTRIBUTE_CATEGORY and HZ_CUST_PROFILE_AMTS.ATTRIBUTE_CATEGORY |
Enter Descriptive Flexfield information. These columns are optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUSTOMER_PROFILES.ATTRIBUTE1-15 and HZ_CUST_PROFILE_AMTS.ATTRIBUTE1-15 |
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.
Variable | Description |
---|---|
Validation: | Must equal 'Y' (Yes) or 'N' (No). Mandatory when profile class is null. |
Destination: | HZ_CUSTOMER_PROFILES.AUTO_REC_INCL_DISPUTED_FLAG |
Enter the AutoCash Rule set to assign to your customer. Use AutoCash Rules sets that you previously defined in the AutoCash Rule Sets window.
Variable | Description |
---|---|
Validation: | Must exist in AR_AUTOCASH_HIERARCHIES with status 'A.' Mandatory when no profile class specified. |
Destination: | HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID |
Enter the minimum receipt amount that must be specified for your customer when you create automatic receipts in this currency. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_PROFILE_AMTS.AUTO_REC_MIN_RECEIPT_AMOUNT |
Specify whether you want to compound interest for your customer.
Variable | Description |
---|---|
Validation: | Must equal 'Y' (Yes) or 'N' (No). Required if INTEREST_CHARGES is set to 'Y.' Do not enter a value if INTEREST_CHARGES is null or set to 'N'. |
Destination: | HZ_CUSTOMER_PROFILES.CHARGE_ON_FINANCE_CHARGE_FLAG |
Enter the number of clearing days for a customer profile.
Variable | Description |
---|---|
Validation: | Must be an integer greater than or equal to zero. |
Destination: | HZ_CUSTOMER_PROFILES.CLEARING_DAYS |
Enter the collector assigned to a customer profile.
Variable | Description |
---|---|
Validation: | Must be unique in AR_COLLECTORS and STATUS = 'A' (Active). Mandatory when no profile class specified. |
Destination: | HZ_CUSTOMER_PROFILES.COLLECTOR_ID (derived from CUSTOMER_NAME) |
Enter Y if you send your customer consolidated billing invoice.
Variable | Description |
---|---|
Validation: | If you enter a value, you must enter either Y or N. |
Destination: | HZ_CUSTOMER_PROFILES.CONS_INV_FLAG |
If you send your customer consolidated bills, then enter the type of consolidated billing invoice, SUMMARY or DETAIL.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUSTOMER_PROFILES.CONS_INV_TYPE |
Enter the user ID that is creating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
Specify whether to send statements to customers with credit balances.
Variable | Description |
---|---|
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: | HZ_CUSTOMER_PROFILES.CREDIT_BALANCE_STATEMENTS |
Specify whether to put a hold on your customer's credit.
Variable | Description |
---|---|
Validation: | Must equal 'Y' (Yes) or 'N' (No)'. |
Destination: | HZ_CUSTOMER_PROFILES.CREDIT_HOLD |
Enter the credit rating for your customer. Use credit ratings you previously defined in the Receivables Lookups window using the lookup Type 'Credit rating for customers.' This column is optional.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CREDIT_RATING' and ENABLED_FLAG='A' |
Destination: | HZ_CUSTOMER_PROFILES.CREDIT_RATING |
Enter a currency code to define customer profile amounts for your 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
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
To update customer profile amounts, you provide a currency code for each row in the interface table. To update just the customer profile, you provide one row with a null CURRENCY_CODE column. To update both, you must provide a row with a null CURRENCY_CODE column to update the profile and rows with currency code to update the amounts.
Variable | Description |
---|---|
Validation: | Must exist in FND_CURRENCIES. Mandatory when a profile amount value is populated. (Profile amount columns are listed above.) |
Destination: | HZ_CUST_PROFILE_AMTS.CURRENCY_CODE |
Enter the name of the customer profile class you want to assign to a customer or bill-to, dunning, or statements address. This column is required.
If this column is null, an active profile class with a profile class ID of '0' must exist in the HZ_CUST_PROFILE_CLASSES table.
Variable | Description |
---|---|
Validation: | Must equal HZ_CUST_PROFILE_CLASSES.NAME and STATUS = 'A' (Active) |
Destination: | HZ_CUSTOMER_PROFILES.CUSTOMER_PROFILE_CLASS_ID (derived from CUSTOMER_PROFILE_CLASS_NAME) |
Specify whether to allow discounts, check credit, send dunning letters, charge interest or and send statements.
Variable | Description |
---|---|
Validation: | Must equal 'Y' (Yes) or 'N' (No). Mandatory when no profile class specified. |
Destination: | HZ_CUSTOMER_PROFILES.DISCOUNT_TERMS, HZ_CUSTOMER_PROFILES.CREDIT_CHECKING, HZ_CUSTOMER_PROFILES.DUNNING_LETTERS, HZ_CUSTOMER_PROFILES.INTEREST_CHARGES, and HZ_CUSTOMER_PROFILES.STATEMENTS |
Enter the number of days after the discount date that your customer can still take discounts.
Variable | Description |
---|---|
Validation: | Number must be non-negative (must be >=0). Must be null when DISCOUNT_TERMS is null or 'No'. |
Destination: | HZ_CUSTOMER_PROFILES.DISCOUNT_GRACE_DAYS |
Enter the grouping rule to assign to your customer. Use grouping rules you previously defined in the Grouping Rules window.
Variable | Description |
---|---|
Validation: | Must exist in RA_GROUPING_RULES. Mandatory when no profile class is specified. |
Destination: | HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID (derived from GROUPING_RULE_NAME) |
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.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
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.
Variable | Description |
---|---|
Validation: | I' for insert, 'U' for update |
Destination: | None |
Enter the number of days to which the interest rate refers.
Variable | Description |
---|---|
Validation: | Number must be positive. Mandatory when INTEREST_CHARGES is Yes. Must be null when INTEREST_CHARGES is No or null. |
Destination: | HZ_CUSTOMER_PROFILES.INTEREST_PERIOD_DAYS |
Enter the interest rate to charge your customer for this currency. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_PROFILE_AMTS.INTEREST_RATE |
Enter the user ID that is updating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
Enter the login ID. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the maximum amount of interest to charge your customer in this currency for each invoice. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_PROFILE_AMTS.MAX_INTEREST_CHARGE |
Enter the minimum amount in this currency that must be past due for your customer before you select the customer for dunning. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_PROFILE_AMTS.MIN_DUNNING_AMOUNT |
Enter the minimum invoice amount in this currency that must be past due for your customer before you select the customer for dunning. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_PROFILE_AMTS.MIN_DUNNING_INVOICE_AMOUNT |
Enter the minimum customer balance that you require before you charge your customer finance charges for past due items in this currency. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT |
Enter the minimum invoice balance that you require before you charge your customer finance charges for past due items in this currency. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT |
Enter the minimum outstanding balance in this currency that your customer must exceed in order for a statement to be generated. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CUST_PROFILE_AMTS.MIN_STATEMENT_AMOUNT |
Enter the operating unit for which you want the Customer Interface program to validate and import customer information.
This column is optional. If you do not enter a value, the Customer Interface program validates and imports customer information for all the operating units on your access list.
Variable | Description |
---|---|
Validation: | Common Utility MO_GLOBAL.GET_VALID_ORG() validates that the ORG_ID is NOT NULL and is on your access list. |
Destination: | None |
Enter the value that represents the customer or bill-to, dunning, or statements site for which you are inserting or updating customer profile information.
Variable | Description |
---|---|
Validation: | For insert, this customer reference must exist in HZ_CUST_ACCOUNTS or be successfully validated in RA_CUSTOMERS_INTERFACE. For update, this customer reference must exist in HZ_CUST_ACCOUNTS. |
Destination: | HZ_CUSTOMER_PROFILES.CUSTOMER_ID (Derived from ORIG_SYSTEM_CUSTOMER_REF) |
Enter the value that represents the customer bill-to, dunning, or statements address for which you are inserting or updating customer profile information. An active bill-to, dunning, or statements business purpose must be associated with this address.
Variable | Description |
---|---|
Validation: | For insert, this address reference must exist in HZ_CUST_ACCT_SITES or be successfully validated in RA_CUSTOMERS_INTERFACE. For update, this address reference must exist in HZ_CUST_ACCT_SITES. |
Destination: | HZ_CUSTOMER_PROFILES.SITE_USE_ID (derived from ORIG_SYSTEM_ADDRESS_REF) |
Enter the total amount of credit to give to your customer in this currency. This column is optional.
Variable | Description |
---|---|
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: | HZ_CUST_PROFILE_AMTS.OVERALL_CREDIT_LIMIT |
Specify whether you want to be able to enter payment terms that are different from the payment term you enter in STANDARD_TERM_NAME.
Variable | Description |
---|---|
Validation: | Must equal 'Y' (Yes) or 'N' (No). Mandatory when no profile class is specified. |
Destination: | HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS |
Enter the number of days you will allow your customer's receipt to be overdue before you initiate collection action.
Variable | Description |
---|---|
Validation: | Number must be non-negative (must be >=0). |
Destination: | HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS |
Enter the percentage of your customer's account balance that you expect to collect regularly. This column is optional.
Variable | Description |
---|---|
Validation: | Must be between 0 to 100. |
Destination: | HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE |
This column is used by Customer Interface, and should be left null.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the risk code for your customer. Use risk codes you previously defined in the Receivables Lookups window with a lookup type of 'Customer credit risk.' This column is optional.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'RISK_CODE' |
Destination: | HZ_CUSTOMER_PROFILES.RISK_CODE |
Enter the standard payment terms for your customer. Use payment terms that you previously defined in the Payment Terms window. This column is optional.
Variable | Description |
---|---|
Validation: | Must exist in RA_TERMS. Must have a unique value. Mandatory when no profile class is specified. |
Destination: | HZ_CUSTOMER_PROFILES.STANDARD_TERMS (derived from STANDARD_TERM_NAME) |
Enter the statement cycle to associate with your customer. Use statement cycles that you previously defined in the Statement Cycles window.
Variable | Description |
---|---|
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: | HZ_CUSTOMER_PROFILES.STATEMENT_CYCLE_ID (derived from STATEMENT_CYCLE_NAME) |
Enter a tax printing option to indicate how you want to print tax information for your customer's invoices.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'TAX_PRINTING_OPTION'. Mandatory when no profile class specified. |
Destination: | HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION |
Enter the percent over the credit limit that your customer can exceed before you will act.
Variable | Description |
---|---|
Validation: | Must be between -100 and 100. Mandatory when no profile class specified. |
Destination: | HZ_CUSTOMER_PROFILES.TOLERANCE |
Enter the amount of credit for each order that you want to give to your customer in this currency.
Variable | Description |
---|---|
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: | HZ_CUST_PROFILE_AMTS.TRX_CREDIT_LIMIT |
This column is used by Customer Interface, and should be left null.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
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.
Enter Descriptive Flexfield category information. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_ORG_CONTACTS.ATTRIBUTE_CATEGORY and HZ_CUST_ACCT_ROLES.ATTRIBUTE_CATEGORY |
Enter Descriptive Flexfield category information. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY |
Enter Descriptive Flexfield category information. These columns are optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CONTACT_POINTS.ATTRIBUTE1 TO 15 |
Enter Descriptive Flexfield information. These columns are optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_ORG_CONTACTS.ATTRIBUTE1 TO 24 and HZ_CUST_ACCT_ROLES.ATTRIBUTE1 TO 24 |
Enter the contact's first name.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_PARTIES.PERSON_FIRST_NAME and HZ_PERSON_PROFILES.PERSON_FIRST_NAME |
Enter the job title or responsibility for this contact. Use contact job titles that you previously defined in the Receivables Lookups window. This column is optional.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'RESPONSIBILITY' |
Destination: | HZ_ORG_CONTACTS.JOB_TITLE_CODE |
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.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_PARTIES.PERSON_LAST_NAME and HZ_PERSON_PROFILES.PERSON_LAST_NAME |
Enter the type of the contact point, such as phone or e-mail, that you want to update.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'COMMUNICATION_TYPE'. Mandatory when specifying contact point information. |
Destination: | HZ_CONTACT_POINTS.CONTACT_POINT_TYPE |
Enter the title for this contact. This column is optional.
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'CONTACT_TITLE' |
Destination: | HZ_ORG_CONTACTS.TITLE |
Enter the user ID that is creating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
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.
Enter a value to indicate whether you are inserting a new record or updating an existing record. This column is required.
Variable | Description |
---|---|
Validation: | 'I' for insert, 'U' for update. |
Destination: | None |
Enter the userid that is updating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
Enter the login ID. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the operating unit for which you want the Customer Interface program to validate and import customer information.
This column is optional. If you do not enter a value, the Customer Interface program validates and imports customer information for all the operating units on your access list.
Variable | Description |
---|---|
Validation: | Common Utility MO_GLOBAL.GET_VALID_ORG() validates that the ORG_ID is NOT NULL and is on your access list. |
Destination: | None |
Enter a value that you can use to uniquely identify your customer in your original system.
Variable | Description |
---|---|
Validation: | Must equal HZ_CUST_ACCOUNTS.ORIG_SYSTEM_REFERENCE for update. If you are entering either contact or telephone information, you must enter a value in this column. |
Destination: | None |
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.
Variable | Description |
---|---|
Validation: | Must equal HZ_CUST_ACCT_SITES_ALL.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: | None |
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 HZ_CUST_ACCT_ROLES and HZ_ORG_CONTACTS. 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.
Variable | Description |
---|---|
Validation: | Must equal HZ_ORG_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: | HZ_ORG_CONTACTS.ORIG_SYSTEM_REFERENCE and HZ_CUST_ACCT_ROLES.ORIG_SYSTEM_REFERENCE |
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.
Variable | Description |
---|---|
Validation: | Must equal HZ_CONTACT_POINTS.ORIG_SYSTEM_REFERENCE. Mandatory when specifying telephone information. |
Destination: | HZ_CONTACT_POINTS.ORIG_SYSTEM_REFERENCE |
This column is used by Customer Interface and should be left null.
Enter the telephone number for the customer, address, or contact.
Variable | Description |
---|---|
Validation: | Mandatory when specifying telephone information (for example, if ORIG_SYSTEM_TELEPHONE_REF is filled in). |
Destination: | HZ_CONTACT_POINTS.PHONE_NUMBER |
Enter the area code or extension for the telephone number, depending on the column you choose. These columns are optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CONTACT_POINTS.AREA_CODE and HZ_CONTACT_POINTS.EXTENSION |
Enter the type of telephone number such as General, Fax, or Telex. Use telephone types that you previously defined in the Receivables Lookups window with a lookup type of 'Types of communication used in contacting customers.'
If TELEPHONE_TYPE in RA_CONTACTS_PHONES_INT_ALL = 'TLX,' then CONTACT_POINT_TYPE = 'TLX' and PHONE_LINE_TYPE is null.
If TELEPHONE_TYPE in RA_CONTACTS_PHONES_INT_ALL is a valid lookup code of PHONE_LINE_TYPE lookup and = 'Phone,' then CONTACT_POINT_TYPE = 'PHONE' and PHONE_LINE_TYPE = 'GEN.'
If TELEPHONE_TYPE in RA_CONTACTS_PHONES_INT_ALL is a valid lookup code of PHONE_LINE_TYPE lookup and does not = 'PHONE,' then CONTACT_POINT_TYPE = 'PHONE' and PHONE_LINE_TYPE = valid lookup code 'X.'
If you want to specify that the phone line type is general, then you should populate the interface table with 'GEN.' The CONTACT_POINT_TYPE will be 'PHONE' for all telephone types except 'TLX.'
Variable | Description |
---|---|
Validation: | AR_LOOKUPS.LOOKUP_CODE where LOOKUP_TYPE = 'PHONE_LINE_TYPE' or 'TLX.' Mandatory when specifying telephone information (for example, if ORIG_SYSTEM_TELEPHONE_REF is filled in). |
Destination: | HZ_CONTACT_POINTS.CONTACT_POINT_TYPE |
This column is used by Customer Interface and should be left null.
The gender of the contact person (male or female). This column is not currently used by Customer Interface.
The electronic mail address for this contact person. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CONTACT_POINTS.EMAIL_ADDRESS |
The location used by the postal service to deliver mail to this contact person. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_ORG_CONTACTS.MAIL_STOP |
The introductory greeting to use in official documents sent to this contact person. This column is not currently used by Customer Interface.
This column is populated by an Oracle Sales and Marketing Application Programming Interface (API). This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_ORG_CONTACTS.CONTACT_KEY |
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.
Enter Descriptive Flexfield category information. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | AP_BANK_ACCOUNT_USES.ATTRIBUTE_CATEGORY |
Enter Descriptive Flexfield information. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | AP_BANK_ACCOUNT_USES.ATTRIBUTE1-15 |
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.
Variable | Description |
---|---|
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: | IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM and IBY_EXT_BANK_ACCOUNTS.CURRENCY_CODE |
Enter the date that this bank account becomes inactive. This column is optional.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | IBY_EXT_BANK_ACCOUNTS.END_DATE |
Enter a description for this bank account. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | IBY_EXT_BANK_ACCOUNTS.DESCRIPTION |
Enter the number this bank account prints on checks. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | IBY_EXT_BANK_ACCOUNTS.CHECK_DIGITS |
Enter the bank account name to assign to a 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.
Variable | Description |
---|---|
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: | IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_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.
Variable | Description |
---|---|
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: | HZ_PARTIES.PARTY_NAME. |
Enter the number of the bank associated with the bank account.
Variable | Description |
---|---|
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: | HZ_ORGANIZATION_PROFILES.BANK_OR_BRANCH_NUMBER |
Enter the number of the bank branch associated with the bank account you are inserting.
Variable | Description |
---|---|
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: | HZ_ORGANIZATION_PROFILES.BANK_OR_BRANCH_NUMBER |
Enter a description for this bank branch. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_PARTIES.MISSION_STATEMENT |
Enter the street address, city, county, state, postal code, or province for this bank branch. These columns are optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_PARTIES.ADDRESS_LINE1-4, HZ_PARTIES.CITY, HZ_LOCATIONS.BANK_BRANCH_COUNTY, HZ_PARTIES.STATE, HZ_PARTIES.ZIP, HZ_PARTIES.PROVINCE |
Enter the country for this bank branch. This column is optional.
Variable | Description |
---|---|
Validation: | Must exist in FND_TERRITORIES.TERRITORY_CODE. |
Destination: | HZ_PARTIES.COUNTRY |
Enter the telephone number or telephone area code for this bank branch. These columns are optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CONTACT_POINTS.PHONE_NUMBER and HZ_CONTACT_POINTS.PHONE_AREA_CODE |
Enter the Electronic Funds Transfer user ID. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | HZ_CONTACT_POINTS.EFT_USER_NUMBER |
Enter Descriptive Flexfield category information. These columns are optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | AP_BANK_ACCOUNTS.ATTRIBUTE_CATEGORY and AP_BANK_BRANCHES.ATTRIBUTE_CATEGORY |
Enter Descriptive Flexfield information. These columns are optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | AP_BANK_ACCOUNTS.ATTRIBUTE1-15 and AP_BANK_BRANCHES.ATTRIBUTE1-15 |
Enter the home country code for the bank. This columns is optional.
Variable | Description |
---|---|
Validation: | This column is validated against FND_TERRITORIES. Mandatory when creating a new bank. |
Destination: | HZ_ORGANIZATION_PROFILES.HOME_COUNTRY |
Enter the user ID that is creating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
Enter the date that this bank account becomes inactive. This column is optional.
Variable | Description |
---|---|
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: | IBY_PMT_INSTR_USES_ALL.END_DATE |
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.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the user ID that is updating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
Enter the login ID. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the operating unit for which you want the Customer Interface program to validate and import customer information.
This column is optional. If you do not enter a value, the Customer Interface program validates and imports customer information for all the operating units on your access list.
Variable | Description |
---|---|
Validation: | Common Utility MO_GLOBAL.GET_VALID_ORG() validates that the ORG_ID is NOT NULL and is on your access list. |
Destination: | None |
Enter the value that represents the customer for which you are inserting bank information. This column is required.
Variable | Description |
---|---|
Validation: | The customer reference must exist in HZ_CUST_ACCOUNTS or be successfully validated in RA_CUSTOMERS_INTERFACE. |
Destination: | IBY_EXTERNAL_PAYERS_ALL.CUST_ACCOUNT_ID |
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.
Variable | Description |
---|---|
Validation: | For insert, the address reference must exist in HZ_CUST_ACCT_SITES_ALL or be successfully validated in RA_CUSTOMERS_INTERFACE (derived from ORIG_SYSTEM_CUSTOMER_REF) |
Destination: | IBY_EXTERNAL_PAYERS_ALL.ACCT_SITE_USE_ID |
Indicates whether this is the primary bank account for this customer or Bill-To address. This column is required.
Variable | Description |
---|---|
Validation: | Enter 'Y' or 'N.' Only one primary bank account can exist at either the customer level or address level. |
Destination: | IBY_PMT_INSTR_USES_ALL.ORDER_OF_PREFERENCE |
This column is used by Customer Interface, and should be left null.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the starting date that this bank account becomes active. This column is required.
Variable | Description |
---|---|
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: | IBY_PMT_INSTR_USES_ALL.START_DATE |
This column is used by Customer Interface, and should be left null.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
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.
Enter Descriptive Flexfield category information. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | RA_CUST_RECEIPT_METHODS.ATTRIBUTE_CATEGORY |
Enter Descriptive Flexfield information. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | RA_CUST_RECEIPT_METHODS.ATTRIBUTE1-15 |
Enter the user ID that is creating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
Enter the date that this payment method becomes inactive. This column is optional.
Variable | Description |
---|---|
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 |
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.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the user ID that is updating this row. This column is required.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the system date. This column is required.
Variable | Description |
---|---|
Validation: | Must be a valid date format. |
Destination: | None |
Enter the login ID. This column is optional.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the operating unit for which you want the Customer Interface program to validate and import customer information.
This column is optional. If you do not enter a value, the Customer Interface program validates and imports customer information for all the operating units on your access list.
Variable | Description |
---|---|
Validation: | Common Utility MO_GLOBAL.GET_VALID_ORG() validates that the ORG_ID is NOT NULL and is on your access list. |
Destination: | None |
Enter the value that represents the customer for which you are inserting a payment method. This column is required.
Variable | Description |
---|---|
Validation: | The customer reference must exist in HZ_CUST_ACCOUNTS or be successfully validated in RA_CUSTOMERS_INTERFACE. |
Destination: | RA_CUST_RECEIPTS_METHODS.CUSTOMER_ID (derived from ORIG_SYSTEM_CUSTOMER_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.
Variable | Description |
---|---|
Validation: | This address reference must exist in HZ_PARTY_SITES or be successfully validated in RA_CUSTOMERS_INTERFACE. |
Destination: | RA_CUST_RECEIPT_METHODS.SITE_USE_ID (derived from ORIG_SYSTEM_ADDRESS_REF) |
Enter the name of the payment method that you want to assign to a customer or Bill-To address. This column is required.
Variable | Description |
---|---|
Validation: | Must exist in AR_RECEIPT_METHODS. |
Destination: | RA_CUST_RECEIPTS_METHODS.RECEIPT_METHOD_ID (derived from PAYMENT_METHOD_NAME) |
Enter 'Y' or 'N' to indicate whether this is the primary payment method for a customer or Bill-To address. This column is required.
Variable | Description |
---|---|
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 |
This column is used by Customer Interface and should be left null.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Enter the starting date that this payment method becomes active. This column is required.
Variable | Description |
---|---|
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 |
This column is used by Customer Interface and should be left null.
Variable | Description |
---|---|
Validation: | None |
Destination: | None |
Related Topics
Customer Interface, Oracle Trading Community Architecture User Guide
System Tables Updated by Customer Interface, Oracle Trading Community Architecture User Guide
Interface Data Required to Run Customer Interface, Oracle Trading Community Architecture User Guide
A Sample Customer Import, Oracle Trading Community Architecture User Guide