Send Customer Service

Database Script	Description
wm_install_from_customer.sql	Runs all the scripts listed below, except the uninstall script.
wm_from_customer_vw.sql	Creates the following required view components for Customer outbound transactions: WM_AR_CUSTOMERS_QRY_VW WM_AR_CUSTOMERS_VW WM_AR_ADDRESSES_VW WM_CUST_PHONES_VW WM_ADDR_PHONES_VW WM_CONT_PHONES_VW WM_AR_CONTACTS_VW WM_AR_CONTACT_ROLES_VW WM_AR_CUST_BANK_ACCOUNTS_VW WM_AR_CUST_RECEIPT_METHODS_VW WM_AR_CUSTOMER_PROFILE_VW WM_AR_CUSTOMER_PROF_AMTS_VW WM_AR_CUST_RELATIONSHIPS_VW WM_AR_SITE_USES_VW
wm_from_customer_trg.sql	Creates the following trigger components to be used for writing to the WM_TRACKCHANGES table to indicate a new or updated document: WM_HZ_PARTIES_U_TRG WM_HZ_CUST_ACCOUNTS_IU_TRG WM_AP_BANK_ACCOUNT_USES_IU_TRG WM_HZ_CONTACT_POINTS_IUD_TRG WM_HZ_CUSTOMER_PROFILES_IU_TRG WM_HZ_CUST_ACCT_RELATE_IU_TRG WM_HZ_CUST_ACCT_SITES_IU_TRG WM_HZ_CUST_PROF_AMTS_IUD_TRG WM_HZ_CUST_SITE_USES_IU_TRG WM_HZ_LOCATIONS_IU_TRG WM_HZ_CUST_ACCT_ROLES_I_TRG WM_HZ_ROLE_RESP_IUD_TRG WM_RA_CUST_RECP_METHODS_IU_TRG
wm_disable_from_customer.sql	Disables the triggers installed by wm_from_customer_trg.sql.
wm_enable_from_customer.sql	Re-enables the triggers installed by wm_from_customer_trg.sql.
wm_drop_from_customer.sql	Uninstalls all components created by wm_install_from_customer.sql.

For These Documents...	Use the Following Tables
1.1.3.2 SITE_CONTACT_PHONES 1.2 PHONES	1.1.2 SITE_PHONES
1.3 CONTACTS	1.1.3 SITE_CONTACTS (Maps to RA_CONTACTS)
1.31.CONTACT_ROLES	1.1.3.1 SITE_CONTACT_ROLES
1.3.2 CONTACT_PHONES	1.1.2 SITE_PHONES
1.4 BANK_ACCOUNTS	1.1.1.2 SITE_BANK_ACCOUNTS
1.5 PAYMENT_METHODS	1.1.1.1 SITE_PAYMENT_METHODS
1.6 CUSTOMER_PROFILES	1.1.1.3 SITE_PROFILES
1.6.1 PROFILE_AMOUNTS	1.1.1.3.1 SITE_PROFILE_AMOUNTS

Document Field	Oracle Applications Table/View Name	Column Name	Description
WEB_ TRANSACTION _ID
DOCUMENT_ TYPE			Value is CUSTOMER.
DOCUMENT_ STATUS			Value is UPDATE or INSERT.
CUSTOMER_ ID	HZ_CUST_ ACCOUNTS	CUSTOMER_ ID
CUSTOMER_ NAME	HZ_CUST_ ACCOUNTS	CUSTOMER_ NAME
CUSTOMER_ NUMBER	HZ_CUST_ ACCOUNTS	CUSTOMER_ NUMBER	Customer number.
PARTY_ID	HZ_CUST_ ACCOUNTS	PARTY_ID	Customer party identifier.
PARTY_NUMBER	HZ_PARTIES	PARTY_NUMBER	Party number.
PARTY_TYPE	HZ_PARTIES	PARTY_TYPE	Type of party with valid values of person, organization, group or relationship.
CUSTOMER_ KEY	HZ_PARTIES	CUSTOMER_ KEY	Derived key created by Oracle Sales and Marketing to facilitate querying.
CUSTOMER_ STATUS	HZ_CUST_ ACCOUNTS	STATUS	Customer status flag.
ORIG_SYSTEM_ REFERENCE	HZ_CUST_ ACCOUNTS	ORIG_SYSTEM_ REFERENCE	Unique customer identifier from foreign system.
CUSTOMER_ PROSPECT_ CODE	AR_CUSTOMERS_V	CUSTOMER_ PROSPECT_CODE
CUSTOMER_ CATEGORY_ CODE	HZ_PARTIES	CATEGORY_ CODE	User–definable category.
CUSTOMER_ CLASS_CODE	HZ_CUST_ ACCOUNTS	CUSTOMER_ CLASS_CODE	Customer class identifier.
CUSTOMER_ TYPE	HZ_CUST_ ACCOUNTS	CUSTOMER_ TYPE	Receivables lookup code for CUSTOMER_TYPE. Values are: I: Internal customers. R: external customers.
PRIMARY_ SALESREP_ NAME	JTF_RS_ SALESREPS	NAME	Name of Sales Representative
SIC_CODE	HZ_PARTIES	SIC_CODE	Standard Industry Classification Code.
TAX_REFERENCE	HZ_PARTIES	TAX_REFERENCE	Taxpayer identification number.
TAX_CODE	HZ_CUST_ ACCOUNTS	TAX_CODE	Tax code for this customer.
FOB_POINT	HZ_CUST_ ACCOUNTS	FOB_POINT	The point in a shipment when title to the goods transfers. An example is FOB delivered, where the title changes hands at the point of delivery.
SHIP_VIA	HZ_CUST_ ACCOUNTS	SHIP_VIA	Name of shipping firm.
GSA_INDICATOR	HZ_PARTIES	GSA_INDICATOR_ FLAG	If the organization is a public sector service agency.
SHIP_PARTIAL	HZ_CUST_ ACCOUNTS	SHIP_PARTIAL	Flag if partial shipments can be sent.
TAXPAYER_ID	HZ_PARTIES	JGZZ_FISCAL_ CODE	Fiscal code for certain European countries.
PRICE_LIST_ NAME	OE_PRICE_ LISTS_VL	NAME
FREIGHT_TERM	HZ_CUST_ ACCOUNTS	FREIGHT_TERM	Order Management lookup code for FREIGHT_TERMS.
ORDER_TYPE_ NAME	OE_TRANSACTION_ TYPES_VL	NAME
SALES_CHANNEL_ CODE	HZ_CUST_ ACCOUNTS	SALES_CHANNEL_ CODE	Order Management lookup code for SALES_CHANNEL.
WAREHOUSE_ NAME	HR_ALL_ ORGANIZATION_ UNITS	NAME
MISSION_ STATEMENT	HZ_PARTIES	MISSION_ STATEMENT	Corporate charter of organization.
NUM_OF_ EMPLOYEES	HZ_PARTIES	EMPLOYEES_ TOTAL	Total number of employees.
POTENTIAL_ REVENUE_ CURR_FY	HZ_PARTIES	CURR_FY_ POTENTIAL_ REVENUE	Potential revenue this fiscal year for organization.
POTENTIAL_ REVENUE_NEXT_ FY	HZ_PARTIES	NEXT_FY_ POTENTIAL_ REVENUE	Potential revenue next fiscal year for organization.
FISCAL_YEAREND_ MONTH	HZ_PARTIES	FISCAL_YEAREND_ MONTH	Month in which fiscal year ends for organization.
YEAR_ ESTABLISHED	HZ_PARTIES	YEAR_ ESTABLISHED	Year in which organization began doing business.
ANALYSIS_FY	HZ_PARTIES	ANALYSIS_FY	Fiscal year for financial information such as net worth, number of employees, and potential revenue.
COMPETITOR_ FLAG	HZ_PARTIES	COMPETITOR_ FLAG	Indicates whether organization is a competitor.
REFERENCE_ USE_FLAG	HZ_PARTIES	REFERENCE_ USE_FLAG	Indicates whether customer agreed to be a reference.
THIRD_PARTY_ FLAG	HZ_PARTIES	THIRD_PARTY_ FLAG	Tracks if a customer is a direct customer of the organization using receivables or a third-party supplier.
PROFILE_CLASS_ NAME	HZ_CUST_ PROFILE_ CLASSES	NAME	Name of customer profile class.
PARTY_NAME_ PHONETIC	HZ_PARTIES	ORGANIZATION_ NAME_PHONETIC	Japanese Kana, or phonetic representation of organization name.
TAX_HEADER_ LEVEL_FLAG	HZ_CUST_ ACCOUNTS	TAX_HEADER_ LEVEL_FLAG	Tax calculation level where Y indicates header and N indicates line.
TAX_ROUNDING_ RULE	HZ_CUST_ ACCOUNTS	TAX_ROUNDING_ RULE	Tax amount rounding rule.
COTERMINATE_ DAY_MONTH	HZ_CUST_ ACCOUNTS	COTERMINATE_ DAY_MONTH	Identifies date in the form DD-MMM on which services ordered by the customer will end.
WAREHOUSE_ UPDATE_DATE	HZ_CUST_ ACCOUNTS	WH_UPDATE_ DATE	Warehouse update date when record was recorded or changed.
LANGUAGE	AR_CUSTOMERS_V	LANGUAGE	Language.
TRANSLATED_ PARTY_NAME	AR_CUSTOMERS_V	TRANSLATED_ CUSTOMER_ NAME	Translated customer name.
PERSON_PRE_ NAME_ADJUNCT	HZ_PARTIES	PERSON_PRE_ NAME_ADJUNCT	Salutatory introduction such as Mr. or Herr.
PERSON_FIRST_ NAME	HZ_PARTIES	PERSON_FIRST_ NAME	First name of the person.
PERSON_MIDDLE_ NAME	HZ_PARTIES	PERSON_MIDDLE_ NAME	Middle name of the person.
PERSON_LAST_ NAME	HZ_PARTIES	PERSON_LAST_ NAME	Last name or surname of the person.
PERSON_SUFFIX	HZ_PARTIES	PERSON_NAME_ SUFFIX	Suffix after the surname such as Sr., Jr., or III.
PERSON_FIRST_ NAME_PHONETIC	HZ_PARTIES	PERSON_FIRST_ NAME_PHONETIC	Phonetic representation of the first name.
PERSON_LAST_ NAME_PHONETIC	HZ_PARTIES	PERSON_LAST_ NAME_PHONETIC	Phonetic representation of the last name.
SHIP_SETS_ INCLUDE_LINES_ FLAG	HZ_CUST_ ACCOUNTS	SHIP_SETS_ INCLUDE_LINES_ FLAG	Indicates whether lines should automatically be included in ship sets.
ARRIVALSETS_ INCLUDE_LINES_ FLAG	HZ_CUST_ ACCOUNTS	ARRIVALSETS_ INCLUDE_LINES_ FLAG	Indicates whether lines should automatically be included in arrival sets.
SCHED_DATE_ PUSH_FLAG	HZ_CUST_ ACCOUNTS	SCHED_DATE_ PUSH_FLAG	Indicates whether a group schedule date should automatically be pushed.
OVER_SHIPMENT_ TOLERANCE	HZ_CUST_ ACCOUNTS	OVER_SHIPMENT_ TOLERANCE	Percentage tolerance for over shipment.
UNDER_SHIPMENT_ TOLERANCE	HZ_CUST_ ACCOUNTS	UNDER_SHIPMENT_ TOLERANCE	Percentage tolerance for under shipment.
OVER_RETURN_ TOLERANCE	HZ_CUST_ ACCOUNTS	OVER_RETURN_ TOLERANCE	Percentage tolerance for over return.
UNDER_RETURN_ TOLERANCE	HZ_CUST_ ACCOUNTS	UNDER_RETURN_ TOLERANCE	Percentage tolerance for under return.
ITEM_CROSS_REF_ PREF
DATE_TYPE_ PREFERENCE	HZ_CUST_ ACCOUNTS	DATE_TYPE_ PREFERENCE	Preference for ship or arrival dates.
DATES_NEGATIVE_ TOLERANCE	HZ_CUST_ ACCOUNTS	DATES_NEGATIVE_ TOLERANCE	Negative tolerance for acceptable dates.
DATES_POSITIVE_ TOLERANCE	HZ_CUST_ ACCOUNTS	DATES_POSITIVE_ TOLERANCE	Positive tolerance for acceptable dates.
INVOICE_ QUANTITY_ RULE	HZ_CUST_ ACCOUNTS	INVOICE_ QUANTITY_ RULE	Indicates whether to invoice for ordered quantity or fulfilled quantity.
DUNS_NUMBER	HZ_PARTIES	DUNS_NUMBER	Unique, nine-digit identification number assigned to business entities by Dun & Bradstreet.
SIC_CODE_ TYPE	HZ_PARTIES	SIC_CODE_ TYPE	Version of Standard Industry Classification.

Document Field	Oracle Applications Table/View Name	Column Name	Description
ADDRESS_ID	HZ_CUST_ ACCT_SITES_ALL	CUST_ACCT_ SITE_ID	Customer site identifier.
STATUS	HZ_CUST_ ACCT_SITES_ALL	STATUS	Customer status flag.
ORIG_SYSTEM_ REFERENCE	HZ_CUST_ ACCT_SITES_ALL	ORIG_SYSTEM_ REFERENCE	Address identifier from foreign system.
TERRITORY_ SHORT_NAME	FND_ TERRITORIES_ TL	TERRITORY_ SHORT_NAME	Territory short name.
ADDRESS_ STYLE	HZ_LOCATIONS	ADDRESS_ STYLE	Do not use this column. Used as context value for Flexible Address Format descriptive flexfield.
ADDRESS1	HZ_LOCATIONS	ADDRESS1
ADDRESS2	HZ_LOCATIONS	ADDRESS2
ADDRESS3	HZ_LOCATIONS	ADDRESS3
ADDRESS4	HZ_LOCATIONS	ADDRESS4
CITY	HZ_LOCATIONS	CITY
COUNTY	HZ_LOCATIONS	COUNTY
STATE	HZ_LOCATIONS	STATE
PROVINCE	HZ_LOCATIONS	PROVINCE
COUNTRY	HZ_LOCATIONS	COUNTRY
POSTAL_CODE	HZ_LOCATIONS	POSTAL_CODE
SU_BILL_TO_FLAG	AR_ADDRESSES_V	SU_BILL_TO_FLAG
SU_SHIP_TO_FLAG	AR_ADDRESSES_V	SU_SHIP_TO_FLAG
SU_MARKET_FLAG	AR_ADDRESSES_V	SU_MARKET_FLAG
SU_DUN_FLAG	AR_ADDRESSES_V	SU_DUN_FLAG
SU_STMT_FLAG	AR_ADDRESSES_V	SU_STMT_FLAG
SU_LEGAL_FLAG	AR_ADDRESSES_V	SU_LEGAL_FLAG
KEY_ACCOUNT_ FLAG	AR_ADDRESSES_V	KEY_ACCOUNT_ FLAG
LANGUAGE	HZ_LOCATIONS	LANGUAGE
LANGUAGE_ DESCRIPTION	FND_ LANGUAGES_TL	DESCRIPTION	Language description.
ADDRESS_ LINES_PHONETIC	HZ_LOCATIONS	ADDRESS_ LINES_PHONETIC	Phonetic or Kana representation of the Kanji address lines, used in Japan.
EDI_LOCATION	HZ_CUST_ ACCT_SITES_ALL	ECE_TP_ LOCATION_CODE	Stores the unique EDI location code for a customer.
TERRITORY	HZ_CUST_ ACCT_SITES_ALL	TERRITORY	Territory for this customer account site.
TRANSLATED_ PARTY_NAME	HZ_CUST_ ACCT_SITES_ALL	TRANSLATED_ PARTY_NAME	Translated customer name.
SALES_TAX_ GEOCODE	HZ_LOCATIONS	SALES_TAX_ GEOCODE	US state and local tax jurisdiction code.
SALES_TAX_ INSIDE_CITY_LIMITS	HZ_LOCATIONS	SALES_TAX_ INSIDE_CITY_LIMITS	US state and local tax inside city limits flag.
SITE_NUMBER
IDENTIFYING_ ADDRESS_ FLAG
ADRESSEE
ORGANIZATION_ NAME	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAME	Organization name.

Document Field	Oracle Applications Table/View Name	Column Name	Comments
SITE_USE_ID	HZ_CUST_ SITE_USES_ALL	SITE_USE_ID	Site-use identifier.
SITE_USE_CODE	HZ_CUST_ SITE_USES_ALL	SITE_USE_CODE	Business purpose.
PRIMARY_FLAG	HZ_CUST_ SITE_USES_ALL	PRIMARY_FLAG	Indicates site is primary.
STATUS	HZ_CUST_ SITE_USES_ALL	STATUS	Site-use status flag.
CONTACT_NAME	AR_SITE_USES_V	CONTACT_NAME	Contact name.
BILL_TO_LOCATION	HZ_CUST_ SITE_USES_ALL	LOCATION	Site-use identifier.
ORIG_SYSTEM_ REFERENCE	HZ_CUST_ SITE_USES_ALL	ORIG_SYSTEM_ REFERENCE	Site-use identifier from foreign system.
SIC_CODE	HZ_CUST_ SITE_USES_ALL	SIC_CODE	Standard Industry Classification code.
PAYMENT_ TERM_NAME	RA_TERMS_TL	NAME	Payment terms name.
GSA_INDICATOR	HZ_CUST_ SITE_USES_ALL	GSA_INDICATOR	Indicates whether this site is a public sector government service agency.
SHIP_PARTIAL	HZ_CUST_ SITE_USES_ALL	SHIP_PARTIAL	Indicates whether the customer will accept partial shipments.
SHIP_VIA	HZ_CUST_ SITE_USES_ALL	SHIP_VIA	Name of the preferred shipping company.
FOB_POINT	HZ_CUST_ SITE_USES_ALL	FOB_POINT	Free On Board (FOB) point is where title of goods is transferred to the buyer.
ORDER_TYPE_ NAME	OE_TRANSACTION_ TYPES_TL	NAME	Order type name.
PRICE_LIST_ NAME	OE_PRICE_ LISTS_VL	NAME	Price list name.
FREIGHT_TERM	HZ_CUST_ SITE_USES_ALL	FREIGHT_TERM	Order Management lookup code for FREIGHT_TERMS.
WAREHOUSE_ NAME	HR_ALL_ ORGANIZATION_ UNITS	NAME	Warehouse name.
TAX_REFERENCE	HZ_CUST_ SITE_USES_ALL	TAX_ REFERENCE	Taxpayer identification number.
TAX_CODE	HZ_CUST_ SITE_USES_ALL	TAX_CODE	Tax code associated with this site.
DEMAND_CLASS_ CODE	HZ_CUST_ SITE_USES_ALL	DEMAND_ CLASS_CODE	Demand class.
INVENTORY_ ORGANIZATION_ NAME	HR_ALL_ ORGANIZATION_ UNITS	NAME	Inventory organization name.
TAX_CLASSIFICATION	HZ_CUST_ SITE_USES_ALL	TAX_ CLASSIFICATION	Classification code for tax.
TAX_HEADER_ LEVEL_FLAG	HZ_CUST_ SITE_USES_ALL	TAX_HEADER_ LEVEL_FLAG	Used by Oracle Sales Compensation.
TAX_ROUNDING_ RULE	HZ_CUST_ SITE_USES_ALL	TAX_ROUNDING_ RULE	Tax rounding rule that overrides system and customer tax rounding rule.
PRIMARY_ SALESREP_ NAME	JTF_RS_ SALESREPS	NAME	Primary sales representative name.
FINCHRG_ RECEIVABLES_ TRX_NAME	AR_RECEIVABLES_ TRX_ALL	NAME
REV_ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the revenue account.
FREIGHT_ ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the freight account.
REC_ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the receivable account.
CLEARING_ ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the clearing account.
TAX_ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the tax account.
UNBILLED_ ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the unbilled account.
UNEARNED_ ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the unearned account.
UNPAID_REC_ ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the unpaid bills account.
REMITTANCE_ ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the remittance account.
FACTOR_ ACCOUNT	GL_CODE_ COMBINATIONS	CONCATENATED_ SEGMENTS	Account identifier for the factor account.
DATES_ NEGATIVE_ TOLERANCE	HZ_CUST_ SITE_USES_ALL	DATES_ NEGATIVE_ TOLERANCE	Negative tolerance for acceptable dates.
DATES_ POSITIVE_ TOLERANCE	HZ_CUST_ SITE_USES_ALL	DATES_ POSITIVE_ TOLERANCE	Positive tolerance for acceptable dates.
DATE_ TYPE_ PREFERENCE	HZ_CUST_ SITE_USES_ALL	DATE_ TYPE_ PREFERENCE	Preference for ship or arrival dates.
OVER_ SHIPMENT_ TOLERANCE	HZ_CUST_ SITE_USES_ALL	OVER_ SHIPMENT_ TOLERANCE	Percentage tolerance for over shipment.
UNDER_ SHIPMENT_ TOLERANCE	HZ_CUST_ SITE_USES_ALL	UNDER_ SHIPMENT_ TOLERANCE	Percentage of tolerance for under shipment.
OVER_ RETURN_ TOLERANCE	HZ_CUST_ SITE_USES_ALL	OVER_ RETURN_ TOLERANCE	Percentage of tolerance for over return.
UNDER_ RETURN_ TOLERANCE	HZ_CUST_ SITE_USES_ALL	UNDER_ RETURN_ TOLERANCE	Percentage tolerance for under return.
SHIP_SETS_ INCLUDE_LINES_ FLAG	HZ_CUST_ SITE_USES_ALL	SHIP_SETS_ INCLUDE_LINES_ FLAG	Indicates whether lines should automatically be included in ship sets.
ARRIVALSETS_ INCLUDE_LINES_ FLAG	HZ_CUST_ SITE_USES_ALL	ARRIVALSETS_ INCLUDE_LINES_ FLAG	Indicates whether lines should automatically be included in arrival sets.
SCHED_DATE_ PUSH_FLAG	HZ_CUST_ SITE_USES_ALL	SCHED_DATE_ PUSH_FLAG	Indicates whether the group schedule date should automatically be pushed.
INVOICE_ QUANTITY_ RULE	HZ_CUST_ SITE_USES_ALL	INVOICE_ QUANTITY_ RULE	Indicates whether to invoice for ordered quantity or fulfilled quantity.
PRICING_EVENT	HZ_CUST_ SITE_USES_ALL	PRICING_EVENT	Event at which to price orders. Examples are at entry, at shipping, or at invoicing.

Document Filed	Oracle Applications Table/View Name	Column Name	Description
PRIMARY_ FLAG	RA_CUST_ RECEIPT_ METHODS	PRIMARY_ FLAG	Indicates whether customer receipt method is primary.
RECEIPT_ METHOD_ NAME	AR_RECEIPT_ METHODS	NAME	Receipt method name.
START_DATE	RA_CUST_ RECEIPT_ METHODS	START_DATE	Start date of the customer receipt methods.
END_DATE	RA_CUST_ RECEIPT_ METHODS	END_DATE	End date of the customer receipt methods.

Document Field	Oracle Applications Table/View Name	Column Name	Description
BANK_ ACCOUNT_ID	AP_BANK_ ACCOUNT_ USES_ALL	BANK_ ACCOUNT_ID	Bank account ID.
EXTERNAL_ BANK_ ACCOUNT_ID	AP_BANK_ ACCOUNT_ USES_ALL	EXTERNAL_ BANK_ ACCOUNT_ID	External bank account ID.
START_DATE	AP_BANK_ ACCOUNT_ USES_ALL	START_DATE	Start date of the bank account.
END_DATE	AP_BANK_ ACCOUNT_ USES_ALL	END_DATE	End date of the bank account.
PRIMARY_FLAG	AP_BANK_ ACCOUNT_ USES_ALL	PRIMARY_FLAG	Indicates whether bank account use is primary.
BANK_NUMBER	AP_BANK_ BRANCHES	BANK_NUMBER
BANK_NAME	AP_BANK_ BRANCHES	BANK_NAME
BANK_BRANCH_ NAME	AP_BANK_ BRANCHES	BANK_BRANCH_ NAME
BANK_BRANCH_ NUM	AP_BANK_ BRANCHES	BANK_NUM	Branch number.
BANK_BRANCH_ DESCRIPTION	AP_BANK_ BRANCHES	DESCRIPTION
BANK_ACCOUNT_ NAME	AP_BANK_ ACCOUNTS_ ALL	BANK_ACCOUNT_ NAME
BANK_ACCOUNT_ NUM	AP_BANK_ ACCOUNTS_ ALL	BANK_ACCOUNT_ NUM	Bank account number.
BANK_ACCOUNT_ DESCRIPTION	AP_BANK_ ACCOUNTS_ ALL	DESCRIPTION
BANK_CURRENCY_ CODE	AP_BANK_ ACCOUNTS_ ALL	CURRENCY_CODE
BANK_ACCOUNT_ INACTIVE_DATE	AP_BANK_ ACCOUNTS_ ALL	INACTIVE_DATE
BANK_BRANCH_ ADDRESS1	AP_BANK_ BRANCHES	ADDRESS_LINE1
BANK_BRANCH_ ADDRESS2	AP_BANK_ BRANCHES	ADDRESS_LINE2
BANK_BRANCH_ ADDRESS3	AP_BANK_ BRANCHES	ADDRESS_LINE3
BANK_BRANCH_ ADDRESS4	AP_BANK_ BRANCHES	ADDRESS_LINE4
BANK_BRANCH_ CITY	AP_BANK_ BRANCHES	CITY
BANK_BRANCH_ STATE	AP_BANK_ BRANCHES	STATE
BANK_BRANCH_ ZIP	AP_BANK_ BRANCHES	ZIP
BANK_BRANCH_ PROVINCE	AP_BANK_ BRANCHES	PROVINCE
BANK_BRANCH_ COUNTRY	AP_BANK_ BRANCHES	COUNTRY
BANK_BRANCH_ AREA_CODE	AP_BANK_ BRANCHES	AREA_CODE
BANK_BRANCH_ PHONE	AP_BANK_ BRANCHES	PHONE
BANK_BRANCH_ COUNTY	AP_BANK_ BRANCHES	COUNTY
BANK_BRANCH_ EFTUSER_ NUMBER	AP_BANK_ BRANCHES	EFT_USER_ NUMBER	The number that identifies you as a user of electronic funds transfer services to your bank or clearing organization.
BANK_ACCOUNT_ CHECK_DIGITS	AP_BANK_ ACCOUNTS_ ALL	CHECK_DIGITS	Holds any check digits that result from bank account number validation.

Document Field	Oracle Applications Table/View Name	Column Name	Description
CUSTOMER_ PROFILE_ID	HZ_CUSTOMER_ PROFILES	CUST_ ACCOUNT_ PROFILE_ID	Unique identifier of this customer profile.
STATUS	HZ_CUSTOMER_ PROFILES	STATUS	Indicates whether the profile is active or inactive.
PROFILE_CLASS_ NAME	HZ_CUST_PROFILE_ CLASSES	NAME
PROFILE_CLASS_ DESCRIPTION	HZ_CUST_PROFILE_ CLASSES	DESCRIPTION
COLLECTOR_ID	AR_CUSTOMER_ PROFILES	COLLECTOR_ID	Collector ID.
COLLECTOR_NAME	AR_COLLECTORS	NAME
CREDIT_CHECKING	HZ_CUSTOMER_ PROFILES	CREDIT_ CHECKING	Indicates whether a credit check is to be carried out.
TOLERANCE	HZ_CUSTOMER_ PROFILES	TOLERANCE	Percentage over credit limit that this customer can exceed before action takes place.
DISCOUNT_TERMS	HZ_CUSTOMER_ PROFILES	DISCOUNT_ TERMS	Indicates whether to allow discount terms. Default value is Y (Yes).
DUNNING_LETTERS	HZ_CUSTOMER_ PROFILES	DUNNING_ LETTERS	Indicates whether to send dunning letters to this customer when invoices, debit memos, or chargebacks become past due.
INTEREST_CHARGES	HZ_CUSTOMER_ PROFILES	INTEREST_ CHARGES	Indicates whether to charge this customer interest.
STATEMENTS	HZ_CUSTOMER_ PROFILES	SEND_ STATEMENTS	Indicates whether to send this customer statements.
CREDIT_BALANCE_ STATEMENTS	HZ_CUSTOMER_ PROFILES	CREDIT_ BALANCE_ STATEMENTS	Indicates whether to send statements that have a credit balance.
CREDIT_HOLD	HZ_CUSTOMER_ PROFILES	CREDIT_HOLD	Indicates whether to put a hold on this customer’s credit.
CREDIT_RATING	HZ_CUSTOMER_ PROFILES	CREDIT_RATING	List of values choice for credit rating.
CREDIT_RATING_ MEANING	AR_LOOKUPS	MEANING	Credit rating meaning.
RISK_CODE	HZ_CUSTOMER_ PROFILES	RISK_CODE	List of values for risk code.
RISK_MEANING	HZ_CUSTOMER_ PROFILES	RISK_ MEANING	Risk meaning.
STANDARD_TERMS	HZ_CUSTOMER_ PROFILES	STANDARD_ TERMS	User–defined payment.
OVERRIDE_TERMS	HZ_CUSTOMER_ PROFILES	OVERRIDE_ TERMS	Indicates whether to allow override of standard terms.
DUNNING_ LETTER_ SET_NAME	AR_DUNNING_ LETTER_SETS	NAME	Dunning letter set name.
INTEREST_ PERIOD_DAYS	HZ_CUSTOMER_ PROFILES	INTEREST_ PERIOD_DAYS	Number of days to which the interest rate refers.
PAYMENT_ GRACE_DAYS	HZ_CUSTOMER_ PROFILES	PAYMENT_ GRACE_DAYS	Maximum number of overdue days allowed before action takes place.
DISCOUNT_ GRACE_DAYS	HZ_CUSTOMER_ PROFILES	DISCOUNT_ GRACE_DAYS	Number of days after discount term date during which this customer can take discounts.
STATEMENT_ CYCLE_NAME	AR_STATEMENT_ CYCLES	NAME
ACCOUNT_STATUS	HZ_CUSTOMER_ PROFILES	ACCOUNT_ STATUS	User defined account status.
ACCOUNT_ STATUS_ MEANING	HZ_CUSTOMER_ PROFILES	ACCOUNT_ STATUS_ MEANING	User defined account status meaning.
AUTOCASH_ HIERARCHY_ NAME	AR_AUTOCASH_ HIERARCHIES	HIERARCHY_NAME
AUTO_REC_INCL_ DISPUTED_FLAG	HZ_CUSTOMER_ PROFILES	AUTO_REC_INCL_ DISPUTED_FLAG	Indicates whether to include disputed transactions. Values include Y or N.
TAX_PRINTING_ OPTION	HZ_CUSTOMER_ PROFILES	TAX_PRINTING_ OPTION	Tax printing option.
TAX_PRINTING_ OPTION_MEANING	HZ_CUSTOMER_ PROFILES	TAX_PRINTING_ OPTION_ MEANING	Tax printing option meaning.
CHARGE_ON_ FINANCE_CHARGE_ FLAG	HZ_CUSTOMER_ PROFILES	CHARGE_ON_ FINANCE_ CHARGE_FLAG	Indicates whether to compound finance charges for this customer or site. Values include Y or N.
GROUPING_ RULE_NAME	RA_GROUPING_ RULES	NAME	Grouping rule name.
CONS_INV_ FLAG	HZ_CUSTOMER_ PROFILES	CONS_INV_ FLAG	Indicates whether customer will be sent a consolidated billing invoice.
CONS_INV_ TYPE	HZ_CUSTOMER_ PROFILES	CONS_INV_ TYPE	Type of consolidated billing invoice (summary or detail) sent to customer.
PERCENT_ COLLECTABLE	HZ_CUSTOMER_ PROFILES	PERCENT_ COLLECTABLE	Percentage of this customer’s account balance that expect to be collected on a regular basis.
CLEARING_DAYS	HZ_CUSTOMER_ PROFILES	CLEARING_DAYS	Specifies a value for the number of clearing days before receipts that belong to this customer or site can be cleared by the automatic clearing program. This overrides the value of the payment method or bank account.
AUTOCASH_ HIERARCHY_ NAME_ADR	AR_AUTOCASH_ HIERARCHIES	HIERARCHY_ NAME
LOCKBOX_ MATCHING_ OPTION	HZ_CUSTOMER_ PROFILES	LOCKBOX_ MATCHING_ OPTION	Lockbox matching option such as INVOICE, SALES_ORDER, PURCHASE_ORDER.

Document Field	Oracle Applications Table/View Name	Column Name	Description
CURRENCY_ CODE	HZ_CUST_ PROFILE_AMTS	CURRENCY_ CODE
TRX_CREDIT_ LIMIT	HZ_CUST_ PROFILE_AMTS	TRX_CREDIT_ LIMIT	Credit limit for an order.
OVERALL_ CREDIT_LIMIT	HZ_CUST_ PROFILE_AMTS	OVERALL_ CREDIT_LIMIT
MIN_DUNNING_ AMOUNT	HZ_CUST_ PROFILE_AMTS	MIN_DUNNING_ AMOUNT	Minimum total that a dunning letter should have before the letter is printed.
MIN_DUNNING_ INVOICE_AMOUNT	HZ_CUST_ PROFILE_AMTS	MIN_DUNNING_ INVOICE_ AMOUNT	The balance due on a payment schedule must be at least this value before it can be dunned.
MAX_INTEREST_ CHARGE	HZ_CUST_ PROFILE_AMTS	MAX_INTEREST_ CHARGE	Maximum interest to be charged per invoice for a currency.
MIN_STATEMENT_ AMOUNT	HZ_CUST_ PROFILE_AMTS	MIN_STATEMENT_ AMOUNT	Minimum total a statement should have before the statement is printed.
AUTO_REC_ MIN_RECEIPT_ AMOUNT	HZ_CUST_ PROFILE_AMTS	AUTO_REC_ MIN_RECEIPT_ AMOUNT	Limits the minimum receipt amount for a currency.
INTEREST_RATE	HZ_CUST_ PROFILE_AMTS	INTEREST_RATE	The interest rate to be charged to this customer account or site for invoices in this currency.
MIN_FC_ BALANCE_ AMOUNT	HZ_CUST_ PROFILE_AMTS	MIN_FC_ BALANCE_ AMOUNT	Minimum balance that a customer account or customer account site should have before any finance charges can be charged to invoices.
MIN_FC_ INVOICE_ AMOUNT	HZ_CUST_ PROFILE_AMTS	MIN_FC_ INVOICE_ AMOUNT	Minimum balance on an invoice before any finance charges can be computed.

Document Field	Oracle Applications Table/View Name	Column Name	Description
PHONE_NUMBER	HZ_CONTACT_ POINTS	PHONE_NUMBER	Telephone number in the local format.
STATUS	HZ_CONTACT_ POINTS	STATUS	Active or inactive status.
PHONE_TYPE	HZ_CONTACT_ POINTS	PHONE_LINE_ TYPE	Lookup code for the type of phone line; for example general, fax, inbound, or outbound.
AREA_CODE	HZ_CONTACT_ POINTS	PHONE_AREA_ CODE	Area code within a country code.
EXTENSION	HZ_CONTACT_ POINTS	PHONE_EXTENSION	Additional number used by an internal telephone system after the internal telephone system is contacted.
PRIMARY_FLAG	HZ_CONTACT_ POINTS	PRIMARY_FLAG	Indicates whether the primary contact point for this type for referenced party is site or location.
ORIG_SYSTEM_ REFERENCE	HZ_CONTACT_ POINTS	ORIG_SYSTEM_ REFERENCE	Identifier for this record from foreign system.
CONTACT_ POINT_TYPE	HZ_CONTACT_ POINTS	CONTACT_ POINT_TYPE	Lookup values are contact_point_type phone, fax, email, web, telex, or edi.
TELEPHONE_TYPE	HZ_CONTACT_ POINTS	TELEPHONE_TYPE	Indicates whether this is a fixed or mobile phone.
TIME_ZONE	HZ_CONTACT_ POINTS	TIME_ZONE	Time zone in the number of hours from Greenwich mean time.
PHONE_TOUCH_ TONE_TYPE_ FLAG	HZ_CONTACT_ POINTS	PHONE_TOUCH_ TONE_TYPE_ FLAG	Indicates whether this is a touch tone phone (Y) or a non–touch tone (N).
TELEX_NUMBER	HZ_CONTACT_ POINTS	TELEX_NUMBER	Reference number, usually a telephone number, to which you send TELEX messages.
WEB_TYPE	HZ_CONTACT_ POINTS	WEB_TYPE	Prefix class to a Web address, such as ftp or http.

Document Field	Oracle Applications Table/View Name	Column Name	Description
CONTACT_ID	HZ_CUST_ ACCOUNT_ ROLES	CUST_ACCOUNT_ ROLE_ID	Unique identifier for the role played by the party in the customer account.
CONTACT_NUMBER	HZ_ORG_ CONTACTS	CONTACT_NUMBER
TITLE	HZ_ORG_ CONTACTS	TITLE
TITLE_MEANING	AR_LOOKUPS	MEANING	Title meaning.
PERSON_FIRST_ NAME	HZ_PARTIES	PERSON_FIRST_ NAME
PERSON_LAST_ NAME	HZ_PARTIES	PERSON_LAST_ NAME
PERSON_FIRST_ NAME_ALT	AR_CONTACTS_V	HZ_CUST_ ACCT_RELATE_ ALL	Alternate first name.
PERSON_LAST_ NAME_ALT	AR_CONTACTS_V	HZ_CUST_ ACCT_RELATE_ ALL	Alternate second name.
STATUS	HZ_CUST_ ACCOUNT_ ROLES	CURRENT_ ROLE_STATE	Status of a role that the customer or party has assumed.
JOB_TITLE	HZ_ORG_ CONTACTS	JOB_TITLE
MAIL_STOP	HZ_ORG_ CONTACTS	MAIL_STOP
ORIG_SYSTEM_ REFERENCE	HZ_CUST_ ACCOUNT_ ROLES	ORIG_SYSTEM_ REFERENCE	Reference to identify foreign system.
CONTACT_KEY	HZ_PARTIES	CUSTOMER_KEY	Derived key created by Oracle Sales and Marketing to facilitate querying.
EMAIL_ADDRESS	HZ_PARTIES	EMAIL_ADDRESS

Document Field	Oracle Applications Table/View Name	Column Name	Comments
CONTACT_ ROLE_ID	HZ_ROLE_ RESPONSIBILITY	CONTACT_ ROLE_ID	Contact role ID.
USAGE_CODE	HZ_ROLE_ RESPONSIBILITY	RESPONSIBILITY_ TYPE	Lookup for responsibility type.
ORIG_SYSTEM_ REFERENCE	HZ_ROLE_ RESPONSIBILITY	ORIG_SYSTEM_ REFERENCE	Unique identifier from foreign system.
PRIMARY_FLAG	HZ_ROLE_ RESPONSIBILITY	PRIMARY_FLAG	Indicates whether the primary role played by the representative for the account is primary.

Document Field	Oracle Applications Table/View Name	Column Name	Description
RELATIONSHIP_ TYPE_CODE	HZ_CUST_ ACCT_RELATE_ ALL	RELATIONSHIP_ TYPE	Revenue accounting code for RELATIONSHIP_TYPE.
RELATED_ CUSTOMER_ NAME	HZ_PARTIES	PARTY_NAME
RELATED_ CUSTOMER_ NUMBER	HZ_CUST_ACCOUNTS	ACCOUNT_ NUMBER
STATUS	HZ_CUST_ ACCT_RELATE_ ALL	STATUS	Active or inactive status.
COMMENTS	HZ_CUST_ ACCT_RELATE_ ALL	COMMENTS	Additional comments.
CUSTOMER_ RECIPROCAL_ FLAG	HZ_CUST_ ACCT_RELATE_ ALL	CUSTOMER_ RECIPROCAL_ FLAG	Indicates whether this relationship is reciprocal.
RELATIONSHIP_ TYPE	HZ_CUST_ ACCT_RELATE_ ALL	RELATIONSHIP_ TYPE	Revenue Accounting code for RELATIONSHIP_TYPE.
BILL_TO_FLAG	HZ_CUST_ ACCT_RELATE_ ALL	BILL_TO_FLAG	Bill to identifier.
SHIP_TO_FLAG	HZ_CUST_ ACCT_RELATE_ ALL	SHIP_TO_FLAG	Ship to identifier.