r12 - oracle customer fields

Customer-Header/Party LevelCustomer Account

Customer Site

.

Customer-Header/Party LevelCustomer Information (Header - Party Level)

Customer Type Organization NameRegistry IDAliasName Pronuciation

ProfileOrganization Information

D-U-N-S NumberYear EstablishedMission StatementCustomer Category

Total EmployeesOrganization TotalOrganization Total TypeCorporate TotalCorporate Total Type

Industrial Classification (Not Working)TypeClassificationMeaningUpdateRemove

Tax and Financial InformationTaxpayer IDTax Registration NumFiscal Year EndFederal AgencyAnalysis YearCurrency PreferenceAnnual RevenuePotential Revenue

Credit ProfileCredit ClassificationCredit AnalystReview CycleNext Scheduled Review DateLast Scheduled Review Date

Credit LimitsCurrencyCredit LimitOrder Credit Limit

1099 Indicator1099 EligibleEligibility PeriodStart DateEnd DateDelete

CommunicationPhone Numbers

TypesPurposePreferredTypeNumberPrimaryTime ZoneUpdateRemove

Email AddressesEmailPrimaryPurposePreferredUpdateRemove

URLsURLPrimaryPurposePreferredUpdateRemove

Party RelationshipsParty TypeStatusCustomerRelationship RoleStart DateEnd DateCommentsRemove

Tax ProfileMain Information

Allow Tax ApplicabilitySet for Self Assessment / Reverse ChargeAllow Offset Taxes

Default ControlsRounding LevelRounding RuleSet Invoice Values as Tax Inclusive

Tax RegistrationsDefault Reporting Country NameDefault Reporting Registration NumberDefault Reporting Tax Registration TypeRegime CodeTaxTax Jurisdiction CodeRegistration NumberIssuing Tax AuthorityActiveUpdateRemove

Associated Fiscal ClassificationsFiscal Classification Type CodeFiscal Classification CodeFiscal Classification NameEffective FromEffective ToRemove

Customer Tax ExemptionsTax Regime CodeTaxStatus CodeRate CodeCertificate NumberReason CodeJurisdiction CodeItemActiveUpdateRemove

Customer Account and Site Business Purpose Tax ExemptionsTax Reporting Codes

Tax Reporting Type CodeData TypeReporting CodeDescriptionEffective FromEffective ToRemove

Account Tax Details

Account NumberAccount DescriptionRounding LevelRounding RuleRemove

Organization/Person

System Generates

Customer/HIGH TECH/Prospect Can be modified

Actual/Estimated

Actual/Estimated

MonthY/N

Fax/Mobile/Pager/Telephone/Voice Mail

Organization/PersonActive/inactive

There are 79 different Relationship Roles

Y/N

Y/NY/NY/N

Customer AccountCustomer Account

Account InformationAccount NumberAccount DescriptionClasssificationAccount TypeLegacy Customer X-RefTMS X-RefTDS X-RefSales ChannelReferenceStatus

Account ProfileCredit and Collection

CollectorCredit RatingCredit ClassificationReview CycleAccount StatusRisk CodeTolerance (%)Collectible (%)Credit CheckCredit HoldCredit AnalystLast Credit ReviewNext Credit Review

Balance Forward BillingBill LevelTypeEnable

TermsPayment TermsDiscount Grace DaysOverride TermsAllow Discount

ReceiptsClearing DaysMatch Receipts ByAutomatic Cash Rule SetAutomatic Receipts Incl Disputed ItemsRemainder Rule Set

Statements and DunningSend StatementStatement Cycle

Send Credit BalanceSend Dunning Letters

InvoicingTax PrintingContext ValueGrouping Rule

Profile Amounts Currency Rates and Limits (BY CURRENCY)

Min Receipt AmountCredit LimitOrder Credit LimitMin Statement AmountMin Dunning AmountMin Dunning Invoice Amount

Payment DetailsReceipt Methods

Receipt MethodPrimaryStart DateEnd DateDelete

Payment InstrumentsCredit Cards

DetailsCard BrandNumberExpiration DateExpiration StatusStart DateEnd DatePriorityIncrease PriorityDecrease PriorityUpdateAdditional Details

Bank Account Transfer - Bank AccountsDetailsNumberIBANCurrencyBank NameStart DateEnd DatePriorityIncrease PriorityDecrease PriorityEnter Debit AuthorizationUpdate

Additional DetailsBank Account Transfer Attributes

Bank Charge BearerDirect Debit Bank Instruction

Debit Notification PreferencesDelivery MethodE-MailFax

CommunicationAccount Contacts

NameContact NumberMail StopJob TitleReferenceStatuesDetailsUpdateRemove

RelationshipsRelated CustomerRelated AccountOperating UnitReciprocalBill ToShip ToUpdateRemove

Order ManagementPrice ListRequest Date TypeFree On Board PointShip MethodLatest Schedule LimitOver Shipment ToleranceOver Return ToleranceLines InItem Type IdentifierFreight TermsWarehouseEarliest Schedule LimitOvership Invoice BaseUnder Shipment ToleranceUnder Return TolerancePush Group Schedule Date

Late ChargesEnable Late Charges

Charge Calculation

Charge calculation methodAdditional Charges and Reductions

Select other transactions that can -reduce late charge calculationsCredit ItemsDisputed Transactions

Profile SetupDefine how late charges are calculated.

Receipt Grace DaysLate Charge TypeInterest Calculation FormulaUse Multiple Interest RatesInterest Days PeriodInterest Calculation PeriodHold Charged InvoicesCharge Beginning Date

Currency Rates and ConditionsCurrencyDeleteDuplicate

AttachmentsTitle TypeDescriptionCategoryLast Updated ByLast UpdatedUsageUpdateDeletePublish to Catalog

Arrival Sets/Ship Sets

Late Payments Only/Overdue Invoices Only/both

Customer SiteCustomer Site

LocationAddress

Account Site InformationSite NameAlternate Name

Site DetailsAccount Site Address

Site NumberCountryAddress Line 1Address Line 2Address Line 3Address Line 4CityCountyStatePostal CodeAddresseeStatusIdentifying AddressGeography Code OverrideLegacy Site X-Ref

Account Site DetailsCategoryTerritoryTranslationEDI LocationContext ValueReferenceStatus

Business PurposePurposeLocationBill To LocationPrimaryRemoveDetails

AccountingAcct Class

ReceivableRevenueTax

FreightClearingUnbilled ReceivableUnearned RevenueCharges Activity

Site Use DetailsSales TerritorySalespersonSIC CodePayment TermsContact

Order ManagementOrder TypePrice ListItem Type IdentifierRequest Date TypeEarliest Schedule LimitLatest Schedule LimitOvership Invoice BaseUnder Return ToleranceFreight TermsFree On Board PointWarehouseShip MethodOver Shipment ToleranceUnder Shipment ToleranceOver Return ToleranceDemand ClassLines In

CommunicationPhone Numbers

TypesPurposePreferredTypeNumberPrimaryTime ZoneUpdateRemove

Email AddressesEmailPrimaryPurposePreferred

UpdateRemove

URLsURLPrimaryPurposePreferredUpdateRemove

Payment DetailsReceipt Methods

Receipt MethodPrimaryStart DateEnd DateDelete

Payment InstrumentsCredit Cards

DetailsCard BrandNumberExpiration DateExpiration StatusStart DateEnd DatePriorityIncrease PriorityDecrease PriorityUpdateAdditional Details

Bank Account Transfer - Bank AccountsDetailsNumberIBANCurrencyBank NameStart DateEnd DatePriorityIncrease PriorityDecrease PriorityEnter Debit AuthorizationUpdateAdditional DetailsBank Account Transfer Attributes

Debit Notification Preferences

Site ProfileCredit and Collection

CollectorCredit RatingCredit ClassificationReview CycleAccount StatusRisk CodeTolerance (%)Collectible (%)Credit CheckCredit HoldCredit AnalystLast Credit ReviewNext Credit Review

Balance Forward BillingBill LevelTypeEnable

TermsPayment TermsDiscount Grace DaysOverride TermsAllow Discount

ReceiptsClearing DaysMatch Receipts ByAutomatic Cash Rule SetAutomatic Receipts Incl Disputed ItemsRemainder Rule Set

Statements and DunningSend StatementStatement CycleSend Credit BalanceSend Dunning Letters

InvoicingTax PrintingContext ValueGrouping Rule

Profile Amounts

Currency Rates and Limits (BY CURRENCY)Min Receipt AmountCredit LimitOrder Credit LimitMin Statement AmountMin Dunning AmountMin Dunning Invoice Amount

Late ChargesEnable Late Charges

Charge CalculationCharge calculation method

Additional Charges and ReductionsSelect other transactions that can reduce late charge calculations

Credit ItemsDisputed Transactions

Profile SetupDefine how late charges are calculated.

Receipt Grace DaysLate Charge TypeInterest Calculation FormulaUse Multiple Interest RatesInterest Days PeriodInterest Calculation PeriodHold Charged InvoicesCharge Beginning Date

Currency Rates and ConditionsCurrencyDeleteDuplicate

Acct…….…….…….

…….…….…….…….…….

Arrival Sets/Ship Sets

Bank Charge BearerDirect Debit Bank Instruction

Delivery MethodE-Mail

Late Payments Only/Overdue Invoices Only/both