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…

SQL Field Name Column Description
AccountStatus This field displays the status of a given customer account.
CustAddDate This field displays the date on which a customer record was added.
CustAddUser This field displays the user name that added the record.
AlertEmail This field displays the email address appearing on an alert.
IsAlertEmailAllowed This field displays whether or not the customer account is allowed to have alerts emailed.
AllowFuelTicket This field displays whether or not fuel tickets can be created for the customer.
AllowServiceUnitOwnership This field displays whether or not a customer is allowed to be assigned to an actual service unit.
AlternateCoreCustomer 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.
Amount Due 30 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 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 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 Now 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 Over 120 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 Calculated total balance due for all invoices (excluding unapplied cash), where the net due date is less than or equal to today’s date.
AverageDaysToPayPYR This field displays the customer’s prior year average days to pay.
AverageDaysToPayYTD This field displays the customer’s average days to pay through current year to date.
BaseBranch This field displays the code associated with a customer base branch.
BillToAddress1 This field displays the Primary Bill-To address line 1 of the customer record.
BillToAddress2 This field displays the Primary Bill-To Address line 2 of the customer record.
BillToCity This field displays the Primary Bill-To City of the customer record.
BillToPostalCode This field displays the Primary Bill-To Postal Code of the customer record.
BillToRegion This field displays the Primary Bill-To Region of the customer record.
BillToTaxBody This field displays the Primary Bill-To Tax body of the customer record.
BlanketPONumber This field displays the blanket purchase order number provided by the customer.
BusinessStructure This field displays how a business on a customer account is structured.
BusinessTaxID This field displays the tax number associated with a business on a customer account.
CanadianTaxID This field displays the Canadian tax ID listed on the customer form.
CellPhone This field displays the Cell Phone number assigned to the customer record.
CompanyName This field displays the company name of an A/P vendor.
ControlBranch This field displays the code associated with a control branch.
CurrencyCode This field displays the currency code attached to a particular customer account.
CustomerBaseBranchName This field displays the name of a customer base branch.
CustomerKey This field displays the key for a customer associated with AR detail.
IsCustomerPORequired This field displays whether or not a customer is required to provide a purchase order number.
CustomerPriceType This field dislays the Customer Price type assigned to the customer recod.
CVOR This field displays the customer’s Commerical Vehicle Operators Registration number.
DefaultPaymentMethod This field displays the default payment method assigned to a customer.
DOT This field displays the customer’s Department of Transportation ID number.
IsEHCExempt This field displays whether or not a customer is exempt from environmental handling charges.
Established Date This field displays the date on which a customer account was established.
Fax This field displays the fax number assigned to customer record.
FuelInvoiceEmail This field displays the email address to be used when fuel invoices are billed to the given customer.
IsFuelInvoiceEmailAllowed This field displays whether the customer should be emailed when fuel invoices are billed to them.
FuelOverridePaymentTerms 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.
HighOnAccountPYR This field displays the previous year’s high on account.
HighOnAccountYTD This field displays the current year’s high on account.
IgnoreAccountingGroup This field displays whether or not accounting group accounting assigned to a part being sold to the customer will be ignored when invoicing occurs.
Inactive This field displays whether or not a given customer is set to inactive.
IndustryType This field displays the industry type assigned to the customer record.
InternalAccount This field displays whether or not a customer account is an internal account.
InternalLRCustomer This field displays whether or not a customer account is for an internal lease/rental customer.
InvoiceDateAmountDue30 Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 31-60 days after the invoice date.
InvoiceDateAmountDue60 Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 61-90 days after the invoice date.
InvoiceDateAmountDue90 Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 91-120 days after the invoice date.
InvoiceDateAmountDueNow Calculated total balance due for all invoices (excluding unapplied cash), where the invoice’s are between 1-30 days after the invoice date.
InvoiceDateAmountDueOver120 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.
InvoiceDateAmountNotDue Calculated total balance due for all invoices (excluding unapplied cash), where the invoice date is greater than today’s date.
InvoiceEmail This field displays the email address appearing on an invoice.
IsInvoiceEmailAllowed This field displays whether or not the customer account is allowed to have their invoices emailed.
InvoicesPYR This field displays the number of invoices for the prior year.
InvoicesYTD This field displays the number of invoices for the current year to date.
LaborAccountingCode This field displays the labor accounting code for a given customer.
LastInvoiceDate This field displays the date on which an account was last invoiced.
LastPayment This field displays the amount of last payment for a note.
LastPaymentDate This field displays the last payment date for a note.
CustLastUpdate This field displays when a customer record was last updated.
CustUpdateUser This field displays the user who updated a customer record.
LeaseContractSalesperson This field displays the salesperson assigned to the customer for lease contracts.
LeaseRentalInvoiceEmail This field displays the email address to be used when lease rental invoices are billed to the given customer.
IsLeaseRentalInvoiceEmailAllowed This field displays whether the customer should be emailed when lease rental invoices are billed to them.
IsLPORequired 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.
MaintenanceContractSalesperson This field displays the salesperson assigned to the customer for maintenance contracts.
MiscellaneousAccount This field displays whether or not a customer account is a miscellaneous account.
NationaLeaseAccountNumber This field displays the customer’s NationaLease Account number.
NoUsageUpdate 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.
OfficePhone This field displays the Office Phone number of the customer record.
OutputSeparateCoreStatements 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).
OutsidePartsSalesperson This field displays the outside parts salesperson attached to a customer account.
OverrideDelinquencyTerms This field displays the override delinquency term in days for the customer record.  This value overrides the default value defined in Delinquency setup application.
ParentCustomerNumber This field displays the customer number of the parent assigned to the customer.
PartsAccountingCode This field displays the parts accounting code for a given customer.
PartsInvoiceEmail This field displays the email address to be used when parts invoices are billed to the given customer.
IsPartsInvoiceEmailAllowed This field displays whether the customer should be emailed when parts invoices are billed to them.
PartsServiceCreditLimit This field displays the credit limit for a customer on parts and service.
PaymentTerm This field displays the payment term attached to a given A/P invoice.
PaymentsPYR This field displays the number of payments for the prior year.
PaymentsYTD This field displays the number of payments for a current year.
PerformCreditCheck This field displays whether or not a customer is set to do a credit check procedure through the system.
PickupDeliveryMethod This field displays the pickup delivery method for the customer that will default when a parts order is opened to them.
PrintExportLabels This field displays whether or not parts labels should print when generating an invoice for the customer.
PrintPartLabelsForPartsInvoices This field displays whether or not parts labels should print when generating an invoice for the customer.
IsProspect This field displays whether or not a particular customer is a prospect customer.
QuebecTaxID This field displays the Quebec tax ID listed on the customer form.
IsQuickCreate This field displays whether or not the customer was created via the Quick Create application.
Relationship 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.
RentalContractSalesperson This field displays the salesperson assigned to the customer for rental contracts.
RepairOrderInvoiceEmail This field displays the email address to be used when repair invoices are billed to the given customer.
IsRepairOrderInvoiceEmailAllowed This field displays whether the customer should be emailed when repair invoices are billed to them.
SalesInvoiceEmail This field displays the email address to be used when unit sales invoices are billed to the given customer.
IsSalesInvoiceEmailAllowed This field displays whether the customer should be emailed when unit sales invoices are billed to them.
SalesManagementAccountStatus This field displays the status of a customer within sales management.
SalesManagementCustomerCreditLimit This field displays the credit limit for a customer within sales management.
SalesManagementSalesman This field displays the salesman attached to a customer within sales management.
SalesManagementSalesmanNumber This field displays the ID number for a salesman attached to a customer within sales management.
SalesManagementTaxStatus This field displays the tax code attached to a customer within sales management.
SalesManagementUserName This field displays the Unit Inventory Salesperson associated with the customer.
SeparateCoreInvoices This field displays whether or not a customer will get a separate Invoice for their core charges.
SeparateCoreStatements This field displays whether or not a customer will get a separate AR statement for their core invoices.
SeparateCoreTerms This field displays the payment terms of the customer for the core invoices.
SeparateInvoicePetFuelTicket 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.
IsSeparateStatement This field displays Y or N depending on whether a customer record is flagged for a separate statement.
ServiceSalesperson This field displays the service salesperson attached to a customer account.
ServiceSalespersonName This field displays the name of a corresponding service salesperson.
ShipToAddress1 This field displays the Primary Ship-To Address line 1 of the customer.
ShipToAddress2 This field displays the Primary Ship-To Address line 2 of the customer.
ShipToCity This field displays the Primary Ship-To City of the customer.
ShipToPostalCode This field displays the Primary Ship-To Postal code of the customer.
ShipToRegion This field displays the Primary Ship-To Region of the customer.
ShipToTaxBody This field displays the Primary Ship-To Tax body of the customer.
ShopPhone This field displays the Shop Phone number of the customer.
StatementEmail This field displays the email address appearing on a statement.
IsStatementEmailAllowed This field displays whether or not the customer account is allowed to have their customer statements emailed.
StatementType This field displays the statement type associated with a given customer.
SubjectToDelinquency 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.
SubjectToFinanceCharge This field displays whether or not a customer is available to receive a finance charge.
SurchargeExempt This field displays whether or not a customer is exempt from surcharges imposed for deliveries.
SurchargeZone This field displays the surcharge zone assigned to the customer.  Any value here overrides the surcharge zone defined at the branch level.
TaxStatus This field displays the tax status of the customer.
Territory This field displays the territory in which the given customer is located, with regards to outside salespeople.
TotalBalanceDue This field displays the total balance due for a given customer.
Unapplied Cash This field displays the total amount of unapplied cash on the customer’s account.
WarrantyAccount This field displays whether or not a customer account is a warranty account.