|
This data object is used to return all customer information within the Customer program in the Fusion business system.
This information is found within the Accounts Receivable Customer program within the Fusion business system.
URL
/frw/Customer
Field Details…
| Field Name | Field Type | Column Description |
|---|---|---|
| CustomerID | int | |
| BillToAddressID | int | |
| ShipToAddressID | int | |
| CustomerBaseBranchID | int | |
| BaseBranch | varchar(10) | This field displays the code associated with a customer base branch. |
| CustomerBaseBranchName | varchar(100) | This field displays the name of a customer base branch. |
| CustomerKey | varchar(10) | This field displays the key for a customer associated with AR detail. |
| CompanyName | varchar(100) | This field displays the company name of an A/P vendor. |
| ControlBranchID | int | |
| ControlBranch | varchar(10) | This field displays the code associated with a control branch. |
| Inactive | bit | This field displays whether or not a given customer is set to inactive. |
| IsProspect | bit | This field displays whether or not a particular customer is a prospect customer. |
| IndustryTypeID | int | |
| BusinessStructureID | int | |
| BusinessStructure | varchar(50) | This field displays how a business on a customer account is structured. |
| BusinessTaxID | varchar(20) | This field displays the tax number associated with a business on a customer account. |
| CurrencyCodeID | int | |
| CurrencyCode | varchar(10) | This field displays the currency code attached to a particular customer account. |
| MiscellaneousAccount | bit | This field displays whether or not a customer account is a miscellaneous account. |
| InternalAccount | bit | This field displays whether or not a customer account is an internal account. |
| WarrantyAccount | bit | This field displays whether or not a customer account is a warranty account. |
| InternalLRCustomer | bit | This field displays whether or not a customer account is for an internal lease/rental customer. |
| SubjectToFinanceCharge | bit | This field displays whether or not a customer is available to receive a finance charge. |
| PerformCreditCheck | bit | This field displays whether or not a customer is set to do a credit check procedure through the system. |
| Relationship | varchar(6) | This field displays the parent child relationship of a customer. If the customer has a parent customer, we display child. If the customer has children customers, we display Parent. |
| IsSeparateStatement | int | This field displays Y or N depending on whether a customer record is flagged for a separate statement. |
| InvoiceEmail | varchar(100) | This field displays the email address appearing on an invoice. |
| IsInvoiceEmailAllowed | bit | This field displays whether or not the customer account is allowed to have their invoices emailed. |
| StatementEmail | varchar(100) | This field displays the email address appearing on a statement. |
| IsStatementEmailAllowed | bit | This field displays whether or not the customer account is allowed to have their customer statements emailed. |
| AlertEmail | varchar(100) | This field displays the email address appearing on an alert. |
| IsAlertEmailAllowed | bit | This field displays whether or not the customer account is allowed to have alerts emailed. |
| PartsInvoiceEmail | varchar(100) | This field displays the email address to be used when parts invoices are billed to the given customer. |
| IsPartsInvoiceEmailAllowed | bit | This field displays whether the customer should be emailed when parts invoices are billed to them. |
| RepairOrderInvoiceEmail | varchar(100) | This field displays the email address to be used when repair invoices are billed to the given customer. |
| IsRepairOrderInvoiceEmailAllowed | bit | This field displays whether the customer should be emailed when repair invoices are billed to them. |
| SalesInvoiceEmail | varchar(100) | This field displays the email address to be used when unit sales invoices are billed to the given customer. |
| IsSalesInvoiceEmailAllowed | bit | This field displays whether the customer should be emailed when unit sales invoices are billed to them. |
| LeaseRentalInvoiceEmail | varchar(100) | This field displays the email address to be used when lease rental invoices are billed to the given customer. |
| IsLeaseRentalInvoiceEmailAllowed | bit | This field displays whether the customer should be emailed when lease rental invoices are billed to them. |
| FuelInvoiceEmail | varchar(100) | This field displays the email address to be used when fuel invoices are billed to the given customer. |
| IsFuelInvoiceEmailAllowed | bit | This field displays whether the customer should be emailed when fuel invoices are billed to them. |
| IsQuickCreate | bit | This field displays whether or not the customer was created via the Quick Create application. |
| LastInvoiceDate | datetime | This field displays the date on which an account was last invoiced. |
| LastPaymentDate | datetime | This field displays the last payment date for a note. |
| InvoicesYTD | int | This field displays the number of invoices for the current year to date. |
| InvoicesPYR | int | This field displays the number of invoices for the prior year. |
| HighOnAccountYTD | decimal | This field displays the current year’s high on account. |
| HighOnAccountPYR | decimal | This field displays the previous year’s high on account. |
| PaymentsYTD | int | This field displays the number of payments for a current year. |
| PaymentsPYR | int | This field displays the number of payments for the prior year. |
| AverageDaysToPayYTD | int | This field displays the customer’s average days to pay through current year to date. |
| AverageDaysToPayPYR | int | This field displays the customer’s prior year average days to pay. |
| StatementType | varchar(20) | This field displays the statement type associated with a given customer. |
| CustomerPartsServiceID | int | |
| PartsServiceCustomerContactID | int | |
| CustomerPartsServiceAccountStatusID | int | |
| AccountStatus | varchar(50) | This field displays the status of a given customer account. |
| TaxCodeID | int | |
| TaxStatus | varchar(50) | This field displays the tax status of the customer. |
| OutsidePartsSalesperson | varchar(20) | This field displays the outside parts salesperson attached to a customer account. |
| OutsideServiceSalesperson | varchar(50) | |
| ServiceSalespersonID | int | |
| ServiceSalesperson | varchar(20) | This field displays the service salesperson attached to a customer account. |
| ServiceSalespersonName | varchar(201) | This field displays the name of a corresponding service salesperson. |
| Territory | varchar(50) | This field displays the territory in which the given customer is located, with regards to outside salespeople. |
| AllowServiceUnitOwnership | bit | This field displays whether or not a customer is allowed to be assigned to an actual service unit. |
| IsLeaseRentalUnitRequired | bit | |
| QLLaborAccountingID | int | |
| LaborAccountingCode | varchar(50) | This field displays the labor accounting code for a given customer. |
| QLPartsAccountingID | int | |
| PartsAccountingCode | varchar(50) | This field displays the parts accounting code for a given customer. |
| PaymentTermID | int | |
| PaymentTerm | varchar(50) | This field displays the payment term attached to a given A/P invoice. |
| DefaultPaymentMethodID | int | |
| DefaultPaymentMethod | varchar(50) | This field displays the default payment method assigned to a customer. |
| IsCustomerPORequired | bit | This field displays whether or not a customer is required to provide a purchase order number. |
| IsEHCExempt | bit | This field displays whether or not a customer is exempt from environmental handling charges. |
| PartsServiceCreditLimit | decimal | This field displays the credit limit for a customer on parts and service. |
| SeparateCoreInvoices | bit | This field displays whether or not a customer will get a separate Invoice for their core charges. |
| AlternateCoreCustomer | varchar(10) | If Separate Core Invoice is checked and this field is populated, the separate core invoice will be created for to the alternate core customer populated here. |
| SeparateCoreStatements | bit | This field displays whether or not a customer will get a separate AR statement for their core invoices. |
| SeparateCoreTerms | varchar(50) | This field displays the payment terms of the customer for the core invoices. |
| OutputSeparateCoreStatements | bit | If the customer is set to get separate core statements, this setting determines if the separate core statement actually prints/emails. (So, the customer may be set to have separate core statements, but this setting actually determines then if they produce). |
| IsLPORequired | bit | This field displays whether or not a LPO is required to be filled in before saving a Repair order or Parts order for the customer. |
| PickupDeliveryMethod | varchar(100) | This field displays the pickup delivery method for the customer that will default when a parts order is opened to them. |
| NoUsageUpdate | bit | This field displays whether or not parts parts sold to the customer will update the usage information for the part. If this is set to yes and a part is added to an order, the action dropdown will display Sale - No Usage. This is turned off by default for a customer record. |
| PrintPartLabelsForPartsInvoices | bit | This field displays whether or not parts labels should print when generating an invoice for the customer. |
| SurchargeExempt | bit | This field displays whether or not a customer is exempt from surcharges imposed for deliveries. |
| SurchargeZone | varchar(50) | This field displays the surcharge zone assigned to the customer. Any value here overrides the surcharge zone defined at the branch level. |
| BlanketPONumber | varchar(30) | This field displays the blanket purchase order number provided by the customer. |
| IgnoreAccountingGroup | bit | This field displays whether or not accounting group accounting assigned to a part being sold to the customer will be ignored when invoicing occurs. |
| PrintExportLabels | bit | This field displays whether or not parts labels should print when generating an invoice for the customer. |
| SalesManagementAccountStatus | varchar(50) | This field displays the status of a customer within sales management. |
| SalesManagementTaxStatus | varchar(50) | This field displays the tax code attached to a customer within sales management. |
| SalesManagementUserName | varchar(20) | This field displays the Unit Inventory Salesperson associated with the customer. |
| SalesManagementSalesmanNumber | varchar(20) | This field displays the ID number for a salesman attached to a customer within sales management. |
| SalesManagementSalesman | varchar(201) | This field displays the salesman attached to a customer within sales management. |
| Established Date | datetime | This field displays the date on which a customer account was established. |
| SalesManagementCustomerCreditLimit | decimal | This field displays the credit limit for a customer within sales management. |
| CustAddUserID | int | |
| CustAddUser | varchar(20) | This field displays the user name that added the record. |
| CustAddDate | datetime | This field displays the date on which a customer record was added. |
| CustUpdateUserID | int | |
| CustUpdateUser | varchar(20) | This field displays the user who updated a customer record. |
| CustLastUpdate | datetime | This field displays when a customer record was last updated. |
| CustAddDateTimeZone | decimal | |
| CustLastUpdateTimeZone | decimal | |
| OutsidePartsSalespersonID | int | |
| TotalBalanceDue | decimal | This field displays the total balance due for a given customer. |
| GrandTotalBalanceDue | decimal | |
| LastPayment | decimal | This field displays the amount of last payment for a note. |
| IndustryType | varchar(50) | This field displays the industry type assigned to the customer record. |
| Amount Due Now | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 1-30 days past the net due date of the invoice. |
| Amount Due 30 | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 31-60 days past the net due date of the invoice. |
| Amount Due 60 | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 61-90 days past the net due date of the invoice. |
| Amount Due 90 | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 91-120 days past the net due date of the invoice. |
| Amount Due Over 120 | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are greater than or equal to 121 days past the net due date of the invoice. |
| Amount Not Due | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the net due date is less than or equal to today’s date. |
| Unapplied Cash | decimal | This field displays the total amount of unapplied cash on the customer’s account. |
| Total Balance Due | decimal | |
| ParentCustomerNumber | varchar(10) | This field displays the customer number of the parent assigned to the customer. |
| ShopPhone | varchar(30) | This field displays the Shop Phone number of the customer. |
| OfficePhone | varchar(30) | This field displays the Office Phone number of the customer record. |
| CellPhone | varchar(30) | This field displays the Cell Phone number assigned to the customer record. |
| Fax | varchar(30) | This field displays the fax number assigned to customer record. |
| BillToAddress1 | varchar(100) | This field displays the Primary Bill-To address line 1 of the customer record. |
| BillToAddress2 | varchar(100) | This field displays the Primary Bill-To Address line 2 of the customer record. |
| BillToCity | varchar(100) | This field displays the Primary Bill-To City of the customer record. |
| BillToRegion | varchar(6) | This field displays the Primary Bill-To Region of the customer record. |
| BillToTaxBody | varchar(50) | This field displays the Primary Bill-To Tax body of the customer record. |
| BillToPostalCode | varchar(15) | This field displays the Primary Bill-To Postal Code of the customer record. |
| ShipToAddress1 | varchar(100) | This field displays the Primary Ship-To Address line 1 of the customer. |
| ShipToAddress2 | varchar(100) | This field displays the Primary Ship-To Address line 2 of the customer. |
| ShipToCity | varchar(100) | This field displays the Primary Ship-To City of the customer. |
| ShipToRegion | varchar(6) | This field displays the Primary Ship-To Region of the customer. |
| ShipToTaxBody | varchar(50) | This field displays the Primary Ship-To Tax body of the customer. |
| ShipToPostalCode | varchar(15) | This field displays the Primary Ship-To Postal code of the customer. |
| CustomerPriceType | varchar(50) | This field dislays the Customer Price type assigned to the customer recod. |
| EntityTypeID | int | |
| BillToAddressTypeID | int | |
| ShipToAddressTypeID | int | |
| SubjectToDelinquency | bit | This field displays if the customer is subject to delinquency. If this is set to yes, when the delinquency job runs this customer will be included. If it is set to no, then this customer will not be included. |
| OverrideDelinquencyTerms | int | This field displays the override delinquency term in days for the customer record. This value overrides the default value defined in Delinquency setup application. |
| AllowFuelTicket | bit | This field displays whether or not fuel tickets can be created for the customer. |
| FuelOverridePaymentTerms | varchar(50) | This field displays the payment terms for fuel invoices for the customer. If no payment term is present, then the customers default payment terms will be applied to any fuel invoice. |
| SeparateInvoicePetFuelTicket | bit | This field displays whether or not a customer will receive one invoice for every fuel ticket or if all of their fuel tickets will be lumped into one fuel invoice. |
| NationaLeaseAccountNumber | varchar(30) | This field displays the customer’s NationaLease Account number. |
| LeaseContractSalesperson | varchar(20) | This field displays the salesperson assigned to the customer for lease contracts. |
| RentalContractSalesperson | varchar(20) | This field displays the salesperson assigned to the customer for rental contracts. |
| MaintenanceContractSalesperson | varchar(20) | This field displays the salesperson assigned to the customer for maintenance contracts. |
| DOT | varchar(100) | This field displays the customer’s Department of Transportation ID number. |
| CVOR | varchar(100) | This field displays the customer’s Commerical Vehicle Operators Registration number. |
| CommentTablesID | int | |
| CanadianTaxID | varchar(15) | This field displays the Canadian tax ID listed on the customer form. |
| QuebecTaxID | varchar(16) | This field displays the Quebec tax ID listed on the customer form. |
| InvoiceDateAmountNotDue | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice date is greater than today’s date. |
| InvoiceDateAmountDueNow | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 1-30 days after the invoice date. |
| InvoiceDateAmountDue30 | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 31-60 days after the invoice date. |
| InvoiceDateAmountDue60 | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 61-90 days after the invoice date. |
| InvoiceDateAmountDue90 | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 91-120 days after the invoice date. |
| InvoiceDateAmountDueOver120 | decimal | Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are greater than or equal to 121 days after the invoice date. |
| OverridePastDueDays | int | |
| IsPastDue | bit | |
| IsSubjectToPastDue | bit | |
| PastDueAmount | decimal | |
| TotalCreditReserve | decimal | |
| CoreRightToReturnDays | int | |
| AutomatedContractPricing | varchar(10) |