1: Customer Information
Customer # - ARCustomers.CustomerNumber
Company - ARCustomers.CustomerName
Address – ARCustomers.Adress
City - ARCustomers.City
Contact – SHAgents.PrefFullName
State - ARCustomers.State
Zip Code - ARCustomers.Zip
Phone - ARCustomers.Phone1
2: Bill Information
Bill Customer # - ARCustomers.CustomerNumber
Bill Company - ARCustomers.CustomerName
Bill Address - ARCustomers.Address
Bill City - ARCustomers.City
Bill Contract – SHAgents.PrefFullName
Bill State - ARCustomers.State
Bill Zip - ARCustomers.Zip
Bill Phone - ARCustomers.Phone1
Credit Hold - ARCustomers.Hold
3: Equipment List
Equipment # - SCEquipments.EquipmentNumber
Serial Number – SCEquipments.SerialNumber
Model – ICModels.Model
Description – ICItems.Description
Is Metered – SCEquipments.IsMetered
Has Contract – SCEquipments.Active = 1 AND SCContracts.Terminated ISNULL AND SCContracts.Active = 1 AND SCContracts.StartDate <= todays date AND SCContractDetails.StartDate <= todays date AND SCContracts.EndDate >= todays date AND SCContractDetails.EndDate >= todays date
Lease – Link to SContractLeases and check if there are any records
Warranty Meter – SCEquipmets.WarrantyMeter
Warranty Date – SCEquipments.WarrantyDate
Lease Number – SCContractLeases.LeaseNumber
Lease Customer Name – SCContractleases.CustomerName
Payment Amount – SCContractLeases.PaymentAmount
Termination Date – SCContractLeases.TerminationDate
Customer Number – ARCustomers.CustomerNumber
Location – SCEquipments.Location
1: Contract Details
Name – ARCustomers.CustomerName
Contact – SCContracts.Contact
Phone – SCContracts.Phone
Contract# - SCContracts.ContractNumber
Major – SCContracts.ContractMayor
Serial – SCEquipments.SerialNumber
Status – SCContractStatuses.ContractStatus
Make – ICModels.Model
Make – ICMakes.Make
Description – ICItems.Description
2: Service Contract Second Section
Activated – SCContracts.Activated
Start Date – SCContracts.StartDate
Expiration Date – SCContracts.ExpDate
Billing Cycle – SCBillingCycles.Description
Next Bill Date – SCContracts.BaseNextBillingDate
3: Meter
Billing Cycle – SCBillingCycles.Description
Next Bill Date – SCContracts.OverageNextBillingDate
4: Lease
Payment – SCContractLeases.PaymentAmount
Equipment Payment – SCContractLeaseDetails.PaymentAmount
Start – SCContractLeases.StartDate
End Date – SCContractLeases.TerminationDate
Financed – SCContractLeases.FinancedAmount
Equipment Financed – SCContractLeaseDetails.FinancedAmount
Leasor – ARCustomers.CustomerName
5: Bill Code
Bill Code – SCBillCodes.Description
Bill Group – SCBillingCycles.BillGroup
6: Contract Base
Contract Base Rate – SCContracts.BaseRate
Equipment Base Rate – SCContractDetails.BaseRate
7: Overage Rates
Meter Group – SSContractMeterGroups.ContractMeterGroup
Meter Desc – SCContractMeterGroups.Description
Covered Copies – SCContractMeterGroups.CoveredCopies
Rate – SCContractMeterGroupOverages.Rate
Range Ending – SCContractMeterGroupOverages.RangeEnding
8: Meter Billings
Invoice Date – ARInvoices.Date
Invoice Number – ARInvoices.InvoiceNumber
Contract Number – SCContracts.ContractNumber
Meter Group – SCBillingMeterGroups.ContractMeterGroup
Group Copies – SCBillingMeterGroups.GroupCopies
Counted Copies – SCBillingMeterGroups.CountedCopies
Copy Credits – SCBillingMeterGroups.CopyCredits
Covered Copies – SCBillingMeterGroups.CoveredCopies
Billable Copies – SCBillingMeterGroups.BillableCopies
Total Charge – SCBillingMeterGroups.TotalChargeAmount
Effective Rate – SCBillingMeterGroups.EffectiveRate
8/11/2020
Comments
0 comments
Article is closed for comments.