AccountBalance

Field	Type	Description
qFiscalYear	Integer	Primary key. Fiscal Year (0=Budget) Defaults to 0. This field is required.
qAcctNo	Text(16)	Primary key. Account Number This field is required. Foreign reference to Accounts.qAcctNo.
qAcctSeg	Text(16)	Primary key. Account Segment This field is required.
qPeriod	Integer	Primary key. Period (0=Begin Balance) Defaults to 0. This field is required.
qBudget	Currency	Budgeted Amount Defaults to 0.
qPeriodBal	Currency	Period Balance Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

AccountDetail

Field	Type	Description
qSerNo	AutoNumber	Primary key. Unique ID This field is required.
qFiscalYear	Integer	Fiscal Year Defaults to 0.
qPeriod	Integer	Period Defaults to 0.
qAcctNo	Text(16)	Account Foreign reference to Accounts.qAcctNo.
qAcctSeg	Text(16)	Account Segment
qJobID	Text(8)	Job Number
qJobSeg	Text(16)	Job Segment
qCostType	Text(5)	Cost Type
qUnitName	Text(6)	Unit Name
qUnitQty	Double	Number of Units Defaults to 0.
qConID	Text(8)	Vendor/Customer
qDtlID	Text(16)	Asset (FA), Inventory (IC), or Equipment (EQ) ID
qSource	Text(2)	Source
qDocDate	Date/Time	Document Date
qDocument	Binary	Source Document
qEntryDate	Date/Time	Entry Date
qReference	Text(12)	Ref
qRefID	Long Integer	Ref No. Defaults to 0.
qDescription	Text(48)	Desc
qAmount	Currency	Transaction Amount Defaults to 0.
qGLRevrs	Text(1)	Auto Reverse Y=To be Reversed, R=Reversed
qBatch	Text(10)	Batch Identification
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

Accounts

Field	Type	Description
qAcctNo	Text(16)	Primary key. Account Number This field is required.
qAcctDesc	Text(50)	Account Name
qGLStat	Text(1)	Status A=Active, I=Inactive
qAcctDir	Yes/No	Is this a Direct Job Cost Account? This field is required.
qAcctCostType	Text(5)	If Direct, what Cost Type is Assigned to this Account
qSegments	Yes/No	Segments Used? This field is required.
qNormalBal	Text(6)	Debit/Credit?
qConsolAcct	Text(16)	Consolidation Account
qGLAType	Text(1)	Type of Auto Budgeting M=Manual, L=% of GLAFig, R= % of GLAcct, C= % of GLAcct but not calculated yet
qGLAFig	Integer	Auto Budget Starting Number Defaults to 0.
qGLAPer	Integer	Auto Budget Percent Defaults to 0.
qGLAAcct	Text(16)	Auto Budget Reference Account
qGLAAcctSeg	Text(16)	Auto Budget Reference Account Segment
qBankAcct	Yes/No	Bank Account ? This field is required.
qCheckNo	Integer	If Bank Account, then last check number Defaults to 0.
qLPayDate	Date/Time	If Bank Account, then last payment date
qFixedAssetAcct	Yes/No	Fixed Asset Account This field is required.
qInvAcct	Yes/No	Inventory Account This field is required.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

AccruedTime

Field	Type	Description
qEmpID	Text(8)	Primary key. Employee Identification This field is required.
qPRSBegin	Date/Time	Date to Begin Accruing Sick Time
qPRSRate	Double	Sick Time Rate Defaults to 0.
qPRSType	Text(1)	Basis of Sick Time: P=PerCheck, S=STHours, T=TotalHours
qPRSMax	Currency	Maximum Sick Time Defaults to 0.
qPRSAccru	Currency	Sick Time Accrued Defaults to 0.
qPRSTaken	Currency	Sick Time Taken Defaults to 0.
qPRVBegin	Date/Time	Date to Begin Accruing Vacation
qPRVRate	Double	Vacation Rate Defaults to 0.
qPRVType	Text(1)	Basis of Vacation Accrual: P=PerCheck, S=STHours, T=TotalHours
qPRVMax	Currency	Maximum Vacation Time Defaults to 0.
qPRVAccru	Currency	Vacation Time Accrued Defaults to 0.
qPRVTaken	Currency	Vacation Time Taken Defaults to 0.
qPRPBegin	Date/Time	Date to Begin Accruing Personal Time
qPRPRate	Double	Personal Time Rate Defaults to 0.
qPRPType	Text(1)	Basis of Personal Time Accrual: P=PerCheck, S=STHours, T=TotalHours
qPRPMax	Currency	Maximum Personal Time Defaults to 0.
qPRPAccru	Currency	Personal Time Accrued Defaults to 0.
qPRPTaken	Currency	Personal Time Taken Defaults to 0.
qUpdateBy	Text(8)	User Last Updated By
qLastUpdate	Date/Time	Date of Last Update

AcctGroup

Field	Type	Description
qGpRef	Long Integer	Primary key. Account Group Ref Defaults to 0. This field is required.
qAcctNo	Text(16)	Primary key. Account Number This field is required.

AdditionalCompensation

Field	Type	Description
qID	Text(16)	Primary key. Additional Compensation Identification This field is required.
qDesc	Text(50)	Additional Compensation Names
qAccount	Text(16)	Accounts
qAcctSeg	Text(16)	Account Segment
qCostType	Text(5)	Cost Type, if Direct
qTaxOpt	Text(12)	Tax Opt: Loc,SIT,SUI,Ins + Fed(8)
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qW2XPos	Integer
qW2Box	Integer
qW2Code	Text(1)
qTaxBasis	Text(1)

Assets

Field	Type	Description
qAssetID	Text(16)	Primary key. Asset Identification This field is required.
qAssetDesc	Text(32)	Asset Description
qAcctNo	Text(16)	Account Number Foreign reference to Accounts.qAcctNo.
qAcctSeg	Text(16)	Account Segment
qConID	Text(8)	Purchased From
qPurchaseAmt	Currency	Purchase Amount Defaults to 0.
qPurchaseDate	Date/Time	Purchase Date
qSalvageValue	Currency	Salvage Value Defaults to 0.
qLifeYrs	Integer	Life in Years Defaults to 0.
qDeprMethod	Text(3)	SL, DDB, SYD, 150
qDeprPriorFY	Currency	Depreciation - Prior Years Defaults to 0.
qDeprPriorMos	Integer	Number of months already depreciated Defaults to 0.
qDeprTotal	Currency	Depreciation - Total Defaults to 0.
qDeprPercent	Integer	Depreciation Percent Defaults to 0.
qDedAmt	Currency	Deduction Amount Defaults to 0.
qAdj	Currency	Adjustment Amount Defaults to 0.
qAdjDate	Date/Time	Adjustment Date
qEquipCode	Text(24)	Equipment
qAssetClass	Text(16)	Asset Class
qAssetGroup	Text(16)	Sub Grouping for Asset Classes
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

AssetWorksheet

Field	Type	Description
qAcctNo	Text(16)	Primary key. Account ID This field is required.
qAcctSeg	Text(16)	Primary key. Account Segment This field is required.
qAssetWorksheet	Text(16)	Primary key. Asset Worksheet This field is required.
qAssetLastYear	Integer	Last Year Defaults to 0.
qAssetLastMonth	Integer	Last Month Defaults to 0.
qAssetSpSht	Binary	Formula One Spreadsheet
qExpAcctNo	Text(16)	Expense Acct No
qExpAcctSeg	Text(16)	Expense Acct Seg
qDeprAcctNo	Text(16)	Depreciation Acct No
qDeprAcctSeg	Text(16)	Depreciation Acct Seg
qUpdateBy	Text(8)
qLastUpdate	Date/Time

AuthorizedWithholding

Field	Type	Description
qEmpID	Text(8)	Primary key. Employee Identification This field is required.
qSeq	Long Integer	Primary key. Sequence Defaults to 0. This field is required.
qDesc	Text(50)	Description
qActive	Yes/No	Active ? This field is required.
qDeplete	Yes/No	Depletion ? This field is required.
qCalc	Integer	Calc Based on: 1=Hourly, 2=Percent, 3=Fixed Amount, 4=Ask Defaults to 0.
qFreq	Integer	Frequency 1=Week 1, 2=Week 2, 3=Week 3, 4=Week 4, 5=Weeks 1&3, 6=Weeks 2&4, 7=Weekly Defaults to 0.
qTaxType	Text(1)	Tax Type: FSL
qTaxID	Text(4)	Tax Code
qGrBasis	Integer	Gross Basis 1=ST Gross, 2=Hourly Gross, 3=Hours at ST Rate, 4=Taxable Gross Defaults to 0.
qDepBal	Currency	Depletion Balance Defaults to 0.
qRate	Double	Withholding Rate Defaults to 0.
qCkMax	Currency	Maximum Deduction on Check Defaults to 0.
qYTDMax	Currency	Maximum YTD for Withholding Defaults to 0.
qTaxOpt	Text(12)	Tax Opt: Loc,SIT,SUI,Ins + Fed(8)
qAcctNo	Text(16)	Liability Account
qAcctSeg	Text(16)	Account Segment
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qMaxBasis	Text(1)
qW2XPos	Integer
qW2Box	Integer
qW2Code	Text(1)
qDepBankID	Text(8)
qDepAcctID	Text(17)

ChangeOrders

Field	Type	Description
qJobID	Text(8)	Primary key. Job Number This field is required.
qCONo	Integer	Primary key. Change Order Defaults to 0. This field is required.
qCODesc	Text(36)	Description
qCOTotal	Currency	Total Defaults to 0.
qCOHist	Memo	History
qCOInit	Date/Time	Date Initiated
qCOAppr	Date/Time	Date Approved
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

ChangeRequests

Field	Type	Description
qJobID	Text(8)	Primary key. This field is required.
qRequestNo	Text(4)	Primary key. This field is required.
qRequestSeq	Text(4)	Primary key. This field is required.
qJobSeg	Text(16)
qCONo	Integer
qCostType	Text(5)
qChangeType	Integer
qChangeDesc	Text(48)
qConID	Text(8)
qPONo	Text(10)
qSubConID	Text(16)
qStatus	Integer
qDueDate	Date/Time
qEstCost	Currency
qSTHrs	Single
qOTHrs	Single
qBillings	Currency
qUnitQty	Single
qUpdateBy	Text(8)
qLastUpdate	Date/Time
qChangeNotes	Memo
qPOItem	Integer
qSubPayItem	Text(10)
qConPayItem	Text(10)
qUnitName	Text(6)

CheckDetail

Field	Type	Description
qAcctNo	Text(16)	Primary key. This field is required.
qAcctSeg	Text(16)	Primary key. This field is required.
qCheckNo	Long Integer	Primary key. This field is required.
qCheckLine	Integer	Primary key. This field is required.
qInvFYRef	Text(10)
qConInv	Text(12)
qAmount	Currency
qDiscAmt	Currency

Checks

Field	Type	Description
qAcctNo	Text(16)	Primary key. Account No. This field is required. Foreign reference to Accounts.qAcctNo.
qAcctSeg	Text(16)	Primary key. Account Segments This field is required.
qCheckNo	Long Integer	Primary key. Check Number Defaults to 0. This field is required.
qCheckDate	Date/Time	Check Date
qCheckAmt	Currency	Check Amount Defaults to 0.
qCheckStatus	Text(1)	Status (blank, Issued, Manual, Cleared, Void)
qVoidDate	Date/Time	If voided, date
qPeriod	Integer	Accounting Period (0 = Begin Balance) Defaults to 0.
qFiscalYear	Integer	Fiscal Year Defaults to 0.
qSource	Text(2)	i.e. AP, PR
qConID	Text(8)	Vendor or Employee ID
qRefID	Text(10)	Ref for AP Inv PR Run
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qTempPayee	Memo

Company

Field	Type	Description
qID	Text(8)	Primary key. Company ID/Subdirectory This field is required.
qCoName	Text(40)	Company Name (from QASYS)
qCreate	Date/Time	Date Created
qEncode	Long Integer	Encrypted ID and Date Defaults to 0.

ContractDetail

Field	Type	Description
qJobID	Text(8)	Primary key. Job Idenitification This field is required. Foreign reference to Jobs.qJobID.
qPayItemNo	Text(10)	Primary key. Pay Item Number This field is required.
qCONo	Text(8)	Primary key. Change Order Number This field is required.
qPayDesc	Text(50)	Pay Item Description
qPayRetPer	Double	Retainage Percent Defaults to 0.
qPayStatus	Text(1)	Status of Pay Item A=Active, P=Pending
qPayUnitDesc	Text(10)	Pay Item Unit Description
qPayBillUnit	Currency	Billing Dollar per Unit Defaults to 0.
qPayEstUnit	Currency	Estimated Dollar per Unit Defaults to 0.
qPayQtyJob	Double	Total Unit Quantity for Pay Item Defaults to 0.
qPayQtyPriorBill	Double	Total Unit Quantity Prior Billed Defaults to 0.
qPayDlrPriorStMtl	Currency	Prior Stored Matl Defaults to 0.
qPayDlrStMtl	Currency	Total Dollar Billing Stored Material Defaults to 0.
qPayQtyThisBill	Double	Total Unit Quantity This Billing Defaults to 0.
qPayDlrJob	Currency	Total Dollar Billing for Job Defaults to 0.
qPayDlrPriorBill	Currency	Total Dollar Billing for Prior Billings Defaults to 0.
qPayDlrThisBill	Currency	Total Dollar Billing for This Billing Defaults to 0.
qPayRetJob	Currency	Total Retainage for this Pay Item Defaults to 0.
qPayRetPriorBill	Currency	Total Retainage previously Billed Defaults to 0.
qPayRetThisBill	Currency	Total Retainage Billed This Billing Defaults to 0.
qPayBillLastMo	Currency	Billing Last Month Defaults to 0.
qPayBillPriorMo	Currency	Billing Prior Month Defaults to 0.
qPayRetReduct	Currency	Retainage Reduction Defaults to 0.
qSalesTax1	Text(10)	Sales Tax to Include Foreign reference to SalesTaxes.qSalesTax.
qSalesTax2	Text(10)	Sales Tax 2
qSalesTax3	Text(10)	Sales Tax 3
qSalesTax4	Text(10)	Sales Tax 4
qGenSalesAcct	Text(16)	General Ledger Sales Account
qGenSeg	Text(4)	Account Segment
qUpdateBy	Text(8)	User Identification
qGenSalesSeg	Text(16)
qLastUpdate	Date/Time	Date of Last Update

ContractInformation

Field	Type	Description
qConID	Text(8)	Primary key. Customer Identification This field is required. Foreign reference to CustomerInformation.qConID.
qJobID	Text(8)	Primary key. Job Identification This field is required. Foreign reference to Jobs.qJobID.
qJobName	Text(50)	Job Name
qConAddr	Memo	Job Address
qConRef	Memo	Contract Reference
qConDate	Date/Time	Contract Date
qConAmt	Currency	Contract Amount Defaults to 0.
qConRetPer	Double	Retainage Percent Defaults to 0.
qConType	Text(1)	Contract Type 0=fixed price, 1=cost plus
qConLaborPer	Double	Markup Percent on Labor for Cost Plus Billings Defaults to 0.
qConFeePer	Double	Markup Percent for Cost Plus Billing Defaults to 0.
qConInclCO	Yes/No	Include Pending Change Orders? This field is required.
qSalesTax1	Text(10)	Sales Taxes calculated on Contract Foreign reference to SalesTaxes.qSalesTax.
qSalesTax2	Text(10)	Sales Tax 2
qSalesTax3	Text(10)	Sales Tax 3
qSalesTax4	Text(10)	Sales Tax 4
qConLastBillDate	Date/Time	Contract Last Billing Date
qConDDate	Date/Time	Contract Due Date
qCORef	Text(20)	Last Change Order Number
qConARAcct	Text(16)	Accounts Receivable Account Number Charged
qConSeg	Text(4)	Account Segment
qConRetAcct	Text(16)	Retainage Receivable Account Number Charged
qRetSeg	Text(4)	Account Segment
qCustInv	Text(32)	Custom Invoice Report Path
qLastFY	Integer	Last Billed FY Defaults to 0.
qLastPer	Integer	Last Billed Period Defaults to 0.
qLastFYBilling	Currency	Billing at Last FY Defaults to 0.
qNewBillings	Yes/No	New Billings Present This field is required.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qConLastApp	Text(4)
qConBillThru	Date/Time
qConIncAcct	Text(16)
qBillGpID	Text(16)
qIncSeg	Text(16)
qArchEngr	Text(8)
qConStatus	Text(1)
qConSTMRet	Double

CostTypes

Field	Type	Description
qCostType	Text(5)	Primary key. Cost Type This field is required.
qCostDesc	Text(24)	Cost Description
qCostAcct	Text(16)	Normal Cost Account if WIP = 0
qCostSeg	Text(16)	Account Segment
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qMarkupPct	Double

Crafts

Field	Type	Description
qCraftID	Text(10)	Primary key. Craft Code This field is required.
qCraftDesc	Text(50)	Craft Description
qAppr	Yes/No	Apprentice? This field is required.
qTrainee	Yes/No	Trainee? This field is required.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

CustomerEquipment

Field	Type	Description
qConID	Text(8)	Primary key. This field is required.
qLocation	Text(10)	Primary key. This field is required.
qSeq	Integer	Primary key. This field is required.
qType	Integer
qID	Text(16)
qLastService	Date/Time
qLastWO	Text(10)
qManufacturer	Text(16)
qManfModel	Text(32)
qSerialNo	Text(24)
qUpdateBy	Text(8)
qLastUpdate	Date/Time

CustomerHistory

Field	Type	Description
qYrMonth	Text(6)	Primary key. Customer Calendar Year This field is required.
qConID	Text(8)	Primary key. Customer Identification This field is required.
qSales	Currency	Customer Sales Defaults to 0.
qDiscAvail	Currency	Discounts Available Defaults to 0.
qPayments	Currency	Customer Payments Defaults to 0.
qDiscTaken	Currency	Discounts Taken Defaults to 0.

CustomerInformation

Field	Type	Description
qConID	Text(8)	Primary key. Contact Code This field is required.
qClass	Text(10)	Customer Class
qType	Text(10)	Customer Type
qCustInt	Yes/No	Calculate Interest? This field is required.
qCustIntCalc	Text(1)	Calculate Interest how? 1=30 Days, 2=60 Days, 3=90 Days
qCustIntRate	Double	Interest Percent Defaults to 0.
qCustLoc	Yes/No	Does this Customer use Locations? This field is required.
qCustDiscGrp	Text(1)	Which Discount Group does this Customer belong? 0=None, 1,2, or 3 = Group 1,2,or 3
qCustMin	Text(1)	Is there a Minimum Charge for this Customer? 0=none, M=monthly, Q=Quarterly, S=semi-annually, A= annually
qCustMinAmt	Currency	Minimum Amount Defaults to 0.
qCustMinMo1	Integer	1st Month of Minimum Defaults to 0.
qCustPayDisc	Text(1)	Does this Customer receive a discount if they pay early? 0=No, 1= yes, based on the number of days, 2= yes based on the date
qCustPayDay	Integer	In how many days must the Customer pay to receive a discount? Defaults to 0.
qCustPayDiscPer	Double	What percent discount will the Customer receive if they pay within the specified number of days? Defaults to 0.
qCustTradeDisc	Double	Trade Discount Percent Defaults to 0.
qSalesTax1	Text(10)	Sales tax code applicable for this customer
qSalesTax2	Text(10)	Sales Tax Code 2
qSalesTax3	Text(10)	Sales Tax Code 3
qSalesTax4	Text(10)	Sales Tax Code 4
qCustCreditMax	Currency	Maximum Credit Available for this customer Defaults to 0.
qLDate	Date/Time	Last Sale Date
qLastPay	Date/Time	Last Payment Date
qEntered	Date/Time	Date Customer Entered
qOnAcctBal	Currency	On Account Balance Defaults to 0.
qOnAcctDate	Date/Time	Last On Account Date
qOnOrder	Currency	On Order Amount Defaults to 0.
qLastPmt	Currency	Amount of Last Payment Defaults to 0.
qLastSale	Currency	Amount of Last Sale Defaults to 0.
qStmntFmt	Text(1)	Statement Format B=Balance Forward, O=Open Item
qCustGLAR	Text(16)	Default AR Account
qCustGLSeg	Text(16)	Default AR Segment
qSalesPerson	Text(16)	Assigned Sales Person
qCustDiscType	Text(10)
qUpdateBy	Text(8)	User Identification
qCustPmtTerms	Text(10)
qLastUpdate	Date/Time	Date of Last Update
qCustCrCardType	Text(4)
qCustCrCardNo	Text(16)
qCustCrCardExp	Text(8)
qCreditHold	Yes/No	This field is required.
qWOBillGrp	Text(10)

CustomerPayment

Field	Type	Description
qConID	Text(8)	Primary key. This field is required.
qYear	Text(4)	Primary key. This field is required.
qSeq	Text(6)	Primary key. This field is required.
qType	Text(1)
qCheckNo	Long Integer
qCheckDate	Date/Time
qDepDate	Date/Time
qDepAmt	Currency
qBankAcct	Text(16)
qBankSeg	Text(16)
qArAmt	Currency

CustomerPaymentDetail

Field	Type	Description
qConID	Text(8)	Primary key. This field is required.
qYear	Text(4)	Primary key. This field is required.
qSeq	Text(6)	Primary key. This field is required.
qItem	Text(4)	Primary key. This field is required.
qInvPrefix	Text(8)
qInvoiceNo	Text(8)
qAmount	Currency
qPaidInFull	Yes/No	This field is required.
qAcctNo	Text(16)
qAcctSeg	Text(16)

CustomerPeriodic

Field	Type	Description
qConID	Text(8)	Primary key. Customer Identification This field is required.
qPerGrp	Text(10)	Primary key. Periodic Group This field is required.
qPerStart	Integer	Start Month Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

Employee

Field	Type	Description
qEmpID	Text(8)	Primary key. Employee Identification This field is required.
qEmpActive	Yes/No	Active ? This field is required.
qEmpGp	Text(16)	Employee Group
qHourSal	Text(1)	Hourly or Salaried?
qStartDate	Date/Time	Hire Date
qTermDate	Date/Time	Termination Date
qRevDate	Date/Time	Review Date
qLastJob	Text(8)	Last Job Worked
qHeritage	Text(1)	Heritage: C=Caucasian, B=Af.Amer., H=Hispanic, A=Asian, I=Indian, O=Other
qGender	Text(1)	Gender M=Male, F=Female
qBirthDate	Date/Time	Birthday
qSalary	Currency	Salary Defaults to 0.
qPayFreq	Integer	Payment Frequency 1=Week1, 2=Week 2, 3=Week 3, 4=Week4, 5=Weeks 1&3, 6=Weeks 2&4, 9=Bi-Weekly, 7=Weekly Defaults to 0.
qDirIndir	Text(1)	(D)irect or (I)ndirect
qBankAcct	Text(16)	Bank Account Number
qBankSeg	Text(16)	Account Segment
qCostAcct	Text(16)	Cost Account Number
qCostSeg	Text(16)	Account Segment
qCraftID	Text(10)	Craft Code
qWageID	Text(16)	Wage Code
qWageRate	Currency	Fixed Rate/Hr Defaults to 0.
qInsClass	Text(10)	Insurance Class
qUnempSt	Text(4)	Unemployment State
qState	Text(4)	State
qLoc1	Text(4)	Local Tax 1
qLoc2	Text(4)	Local Tax 2
qLoc3	Text(4)	Local Tax 3
qPicture	Binary	Employee Picture
qUpdateBy	Text(8)	User Identification
qAcctMrg	Integer
qLastUpdate	Date/Time	Date of Last Update
DriverLicense	Text(30)	Driver License Number
EmpNumber	Integer	Employee Number Defaults to 0.
qDepBankID	Text(8)
qDepAcctID	Text(17)

EmployeeGroup

Field	Type	Description
qEmpGp	Text(16)	Primary key. Employee Group This field is required.

EmployeeHistory

Field	Type	Description
qEmpID	Text(8)	Primary key. Employee Identification This field is required.
qYrMoWkRun	Text(10)	Primary key. Year, Mo, Wk, Run This field is required.
qCheckNo	Long Integer	Check No Defaults to 0.
qGross	Currency	Gross Pay Defaults to 0.
qNet	Currency	Net Pay Defaults to 0.
qHrST	Single	ST Hours Defaults to 0.
qHrOT1	Single	OT1 Hours Defaults to 0.
qHrOT2	Single	OT2 Hours Defaults to 0.
qHrOT3	Single	OT3 Hours Defaults to 0.
qWages	Currency	Wages Defaults to 0.
qPaidBenefits	Currency	BenPlan/Union Earnings Defaults to 0.
qAddlCompensation	Currency	Addl Comp Defaults to 0.
qVacSickPers	Currency	Vacation, Sick, or Personal Earnings Defaults to 0.
qPayDate	Date/Time	Date of Check

EmployeeSummary

Field	Type	Description
qEmpID	Text(8)	Primary key. Employee This field is required.
qType	Text(1)	Primary key. Taxes:F/S/L, U=Union, B=Ben.Plan, W=Auth.WH This field is required.
qID	Text(10)	Primary key. For Type W, Use 'H' This field is required.
qRef	Text(4)	Primary key. For F/S/L, Use '0000' This field is required.
qYearMo	Text(6)	Primary key. Cal Year & Month This field is required.
qEarnings	Currency	Earnings for F/S/L & Co.Paid Benefits Defaults to 0.
qWithheld	Currency	Payroll Withholding Defaults to 0.
qWeeks	Integer	Weeks Worked for F/S/L Defaults to 0.
qLast	Text(10)	Last YrMoWkRun Updated

EmployeeTaxControl

Field	Type	Description
qEmpID	Text(8)	Primary key. Employee Identification This field is required.
qTaxType	Text(1)	Primary key. Tax Type: FSL This field is required.
qTaxID	Text(4)	Primary key. Tax Code This field is required.
qAllow	Currency	Allowances Defaults to 0.
qTaxExempt	Integer	Tax Exempt: 1=Payroll Tax, 2=Unemp, 4=Insurance Defaults to 0.
qMStatus	Integer	Marital Status? (1-9) Defaults to 0.
qDepend	Integer	Number of Dependents Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qPrintWages	Integer
qPrintWithholding	Integer

EmployeeUB

Field	Type	Description
qEmpID	Text(8)	Primary key. Employee Identification This field is required.
qUBID	Text(10)	Primary key. Union/Benefit Identification This field is required.
qEmpUBAuth	Integer	Emp Authorization Level (0-15) Defaults to 0.
qEmpUBPos	Integer

EquipGroup

Field	Type	Description
qEqGr	Text(16)	Primary key. Equipment Group This field is required.

EquipMaint

Field	Type	Description
qEquipID	Text(16)	Primary key. Asset Identification This field is required.
qSeqNo	Integer	Primary key. Reference Number for Asset Defaults to 0. This field is required.
qMaintDesc	Text(80)	Maintenance Description
qFrequency	Text(10)	O=Miles,H=Hours,D=Daily,W=Weekly,M=Monthly,Q=Qtrly,S=SemiAnn,A=Annual
qInterval	Long Integer	Hours/Miles Defaults to 0.
qFirstMonth	Integer	Month to Start With Defaults to 0.
qNextMaint	Date/Time	Date When Next Maintenance Should Occur
qLastReading	Long Integer	Defaults to 0.
qLastMaint	Date/Time	Date of Last Maintenance
qMaintProc	Memo	Maintenance Procedure
qCheckList	Yes/No	Use Procedure as Checklist ? This field is required.
qAssignTo	Text(8)	Employee Assigned
qStatus	Text(1)	N=Normal,S=Scheduled
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

Equipment

Field	Type	Description
qEquipID	Text(24)	Primary key. Equipment Identification This field is required.
qAssetID	Text(16)	Asset Identification
qEquipDesc	Text(50)	Equipment Description
qEquipPic	Binary	Picture of Equipment
UnitsKept	Text(50)	Number of Units Kept
qEquipLoc	Text(16)	Equipment Location
qEquipGp	Text(16)	Equipment Group
qVIN	Text(16)	Vehicle Identification Number
qPurchDate	Date/Time	Purchase Date
qPONo	Text(20)	Purchase Order Number
qLicenseDate	Date/Time	Licensed thru Date
qTagNo	Text(10)	License Tag
qSRVDate	Date/Time	Placed in Service Date
qStatus	Memo	Status and Background of Equipment
qInsComp	Text(20)	Insured By
qInsPolicyNo	Text(20)	Insurance Account Number
qSellAmt	Currency	Amount Sold For Defaults to 0.
qSellDate	Date/Time	Date Sold
qRetireDate	Date/Time	Retirement Date
qWarranty	Date/Time	Date Warranty Expires
qServCont	Date/Time	Date Service Contract Expires
qRepairHrs	Currency	Number of Hours being Repaired Defaults to 0.
qRepairLabor	Currency	Labor Cost of Repairs Defaults to 0.
qRepairOther	Currency	Other Costs of Repair Defaults to 0.
qUsagetoProj	Currency	Usage to Job Defaults to 0.
qEquipUnit	Text(6)	Units Type Equipment is Charged With
qEquipLastRead	Date/Time	Date Meter Last Read
qEquipMeter	Double	Mileage Defaults to 0.
qEquipCharge	Integer	Charge: 1=PerSale, 2=Metered Defaults to 0.
qEquipPrice	Integer	Price: 1=Fixed Prices, 2=Cummulative Table, 3=Rate Table Defaults to 0.
qEquipRetPrice	Currency	Equipment Retail Price Defaults to 0.
qEquipDisc1	Currency	Equipment Discount Group 1 Rate Defaults to 0.
qEquipDisc2	Currency	Equipment Discount Group 2 Rate Defaults to 0.
qEquipDisc3	Currency	Equipment Discount Group 3 Rate Defaults to 0.
qEquipJob	Currency	Equipment Rate Charged to Job Cost Defaults to 0.
qCostJobID	Text(8)	Job Equipment Associated With
qCostJobSeg	Text(16)	Job Cost Code Equipment Associated With
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qVehIdNo	Text(24)

EquipmentRateTable

Field	Type	Description
qEquipCode	Text(16)	Primary key. Equipment Code This field is required.
qEquipSeq	Integer	Primary key. Table Row Defaults to 0. This field is required.
qEquipQtyRT	Double	Primary key. Rate Table Quantity Defaults to 0. This field is required.
qEquipRateRT	Currency	Primary key. Rate Table Rate Defaults to 0. This field is required.

EquipmentUsage

Field	Type	Description
qEquipID	Text(16)	Primary key. This field is required.
qEqSeq	Long Integer	Primary key. Defaults to 0. This field is required.
qSource	Text(2)	PR/AR/WO
qUsedBy	Text(8)	EmpID/CustID
qUsedOn	Text(16)	Project/WO
qHrs	Double	Hours (ST) Defaults to 0.
qHrsOT	Double	OT Hours (PR) Defaults to 0.
qUpdateBy	Text(8)	Entered By
qLastUpdate	Date/Time	Date Entered

EquipService

Field	Type	Description
qEquipID	Text(16)	Primary key. This field is required.
qSequence	Long Integer	Defaults to 0.
qServiceDate	Date/Time
qServiceBy	Text(8)
qMaintSeqNo	Integer	Equip Maint Seq Defaults to 0.
qServiceNotes	Memo
qEqReading	Long Integer	Miles/Hours Defaults to 0.

FinancialDetail

Field	Type	Description
qReportID	Text(8)	Primary key. This field is required.
qFiscalYear	Text(4)	Primary key. This field is required.
qReportMonth	Text(3)	Primary key. This field is required.
qLine	Text(5)	Primary key. This field is required.
qSkipBefore	Integer
qType	Integer
qID	Text(16)
qDesc	Text(80)
qCol1	Currency
qCol2	Currency
qCol3	Currency
qCol4	Currency
qCol5	Currency
qCol6	Currency
qCol7	Currency
qCol8	Currency
qCol9	Currency
qCol10	Currency
qCol11	Currency
qCol12	Currency
qCol13	Currency
qCol14	Currency
qCol15	Currency
qCol16	Currency

FinancialHeadings

Field	Type	Description
qReportID	Text(8)	Primary key. This field is required.
qColumn	Text(2)	Primary key. This field is required.
qHeading	Text(64)

FinancialReports

Field	Type	Description
qReportID	Text(8)	Primary key. This field is required.
qFiscalYear	Text(4)	Primary key. This field is required.
qReportMonth	Text(3)	Primary key. This field is required.
qHeader	Text(120)
qFooter	Text(120)
qColumns	Integer
qUpdateBy	Text(8)
qLastUpdate	Date/Time

InsuranceClasses

Field	Type	Description
qInsID	Text(10)	Primary key. Insurance Identification This field is required.
qInsDesc	Text(32)	Insurance Description
qWCCode	Text(6)	Worker's Comp Code Worker's Comp Code
qGLCode	Text(6)	General Liability Code
qLastUpdate	Date/Time	Date of Last Update
qUpdateBy	Text(8)	User Last Updated By

InsuranceDetail

Field	Type	Description
qInsID	Text(10)	Primary key. Insurance Class Number This field is required.
qTaxID	Text(4)	Primary key. State Code This field is required.
qMaxDol	Currency	Maximum Dollar per Hour for Class Defaults to 0.
qNext	Text(10)	Next Class to go to when Maximum is hit
qInsWcRate	Currency	Worker's Compensation Rate Defaults to 0.
qInsProp	Currency	Property Damage Rate Defaults to 0.
qInsBIRate	Currency	Bodily Injury Rate Defaults to 0.
qInsGLMax	Currency
qInsWcMax	Currency	WC Max/Wk Defaults to 0.

InventoryAssembly

Field	Type	Description
qAssemblyID	Text(16)	Primary key. Identification This field is required.
qAssemblySEQ	Text(4)	Primary key. This field is required.
qItemID	Text(16)
qItemQty	Double	Defaults to 0.

InventoryDetail

Field	Type	Description
qItemID	Text(16)	Primary key. Item, Part, or Sales Code This field is required.
Space	Text(10)	Truck Location
qConID	Text(10)	Vendor Item Purchased From
StockNumber	Text(16)	Vendor Item Number
qItemDesc	Text(50)	Item Description
qItemUnit	Text(10)	Item Unit Description
qItemGroup	Text(24)	Item Group
qItemAverCost	Currency	Average Cost of Item Defaults to 0.
qItemRetailPrice	Currency	Retail Price for Item
qItemDisc1Price	Currency	Discount Group 1 Price Defaults to 0.
qItemDisc2Price	Currency	Discount Group 2 Price Defaults to 0.
qItemDisc3Price	Currency	Discount Group 3 Price Defaults to 0.
qItemJobCostPrice	Currency	Job Cost Price for Item Defaults to 0.
qItemLoc	Text(16)	Item Location
qItemOnOrderQty	Double	Quantity of Item on Order Defaults to 0.
qItemOrderDate	Date/Time	Date Item Ordered
qItemOnHandQty	Double	On Hand Quantity of Item Defaults to 0.
qInvCount	Double	Items on hand at last count Defaults to 0.
qInvDate	Date/Time	Inventory count date
qItemReorderQty	Double	Reorder when Item Reaches this Number Defaults to 0.
qItemOrderQty	Double	Standard Reorder Quantity Defaults to 0.
qItemLead	Integer	Lead Time in Days Defaults to 0.
qLDate	Date/Time	Date of Last Sale
qTax	Yes/No	Taxable? This field is required.
qStock	Yes/No	Stock Item? This field is required.
qHistory	Yes/No	Track History? This field is required.
qWeight	Double	Per Unit Weight Defaults to 0.
qItemHours	Double	Standard Hours per unit Defaults to 0.
qItemCostMethod	Integer	Costing Method 2=FIFO, 1=LIFO, 0=Average Defaults to 0.
qItemToJc	Integer	0=Average, 1=LIFO, 2=FIFO Defaults to 0.
qInvTag	Text(12)	What Type of Tag is used to Identify Item
qAssembly	Yes/No	Is this item part of an assembly This field is required.
qUpdateBy	Text(8)	User Identification
Model	Text(25)
qLastUpdate	Date/Time	Date of Last Update
qManufacturer	Text(16)
qManfModel	Text(32)
qOrderUnit	Text(6)
qSalesPerOrderUnit	Double
qConID2	Text(8)

InventoryGroup

Field	Type	Description
qInvGp	Text(24)	Primary key. Group Name This field is required.
InvGpNum	Text(4)	Group Number

InventoryHistory

Field	Type	Description
qItemID	Text(16)	Primary key. Item, Part, or Sales Code This field is required.
qYrMo	Text(6)	Primary key. Year/Mo This field is required.
qItemSales	Currency	Amount of Sales for Period Defaults to 0.
qItemCost	Currency
qItemQty	Double	Quantity of Item Sold for Period Defaults to 0.

InventoryLocations

Field	Type	Description
qInvLoc	Text(16)	Primary key. Location Name This field is required.

InventoryStock

Field	Type	Description
qItemID	Text(16)	Primary key. Item, Part, or Sales Code This field is required.
qItemSeq	Long Integer	Primary key. Item Sequence Defaults to 0. This field is required.
qItemPurchDate	Date/Time	Date Item Purchased
qItemPurchQty	Currency	Item Purchase Quanity Defaults to 0.
qItemPurchPrice	Currency	Item Purchase Price Defaults to 0.
qItemPurchLot	Text(16)	Manufacturers Lot ID
qItemBal	Currency	Balance On Hand Defaults to 0.
qItem1stUsed	Date/Time	Date Item 1st Used
qConID	Text(10)	Vendor Item Purchased From
qItemLastUsed	Date/Time	Date of Last Sale
qItemLoc	Text(16)	Item Location

InvoiceDetail

Field	Type	Description
qInvPrefix	Text(8)	Primary key. Invoice Prefix This field is required.
qInvoiceNo	Text(8)	Primary key. Invoice Number This field is required.
qInvoiceSeq	Integer	Primary key. Invoice Sequence Defaults to 0. This field is required.
qSalesTax1	Text(10)	Sales Tax Code 1
qSalesTax2	Text(10)	Sales Tax Code 2
qSalesTax3	Text(10)	Sales Tax Code 3
qSalesTax4	Text(10)	Sales Tax Code 4
qSrc	Text(2)	MI=MiscItem,MB=MiscBilling,E=Equip,I=Inventory,O=POItem,P=Periodic, WL=WOLabor, WE=WOEquip,WO=WOPO,WM=WOMisc,WI=WOInvSales,WS=WOSalesItems,C=Contract,S=SalesItem
qSalesDate	Date/Time	Sales Date
qItemID	Text(16)	Item Identification
qDesc	Text(80)	Description
qItemQty	Double	Item Quantity Billed Defaults to 0.
qItemQtyOrd	Double	Item Quantity Ordered Defaults to 0.
qItemQtyShip	Double	Item Quantity Shipped Defaults to 0.
qItemUnit	Text(2)	Unit Name (i.e. EA)
qItemPrice	Currency	Item Unit Price Defaults to 0.
qRetainage	Currency	Retainage Accrued Defaults to 0.
qDisc	Integer	Discount Percent Defaults to 0.
qTotalItem	Currency	Item Total Defaults to 0.
qSalesPerson	Text(16)	Salesman Code
qAcctNo	Text(16)	Sales Acct
qAcctSeg	Text(16)	Sales Acct Seg
qUpdateBy	Text(8)	User Identification
qItemCost	Currency
qLastUpdate	Date/Time	Date of Last Update
qItemQty2	Double
qRetReduct	Currency
qRefID	Text(12)
qConID	Text(8)
qJobSeg	Text(16)

InvoicePrefix

Field	Type	Description
qInvPrefix	Text(8)	Primary key. Invoice Prefix This field is required.
qInvLastNo	Long Integer	Last Invoice Number Defaults to 0.

Invoices

Field	Type	Description
qInvPrefix	Text(8)	Primary key. Invoice Prefix This field is required.
qInvoiceNo	Text(8)	Primary key. Invoice Number This field is required.
qConID	Text(8)	Customer Code
qJobID	Text(8)	Job Identification Foreign reference to Jobs.qJobID.
qLocID	Text(10)	Location Code
qTerms	Text(50)	Terms of Payment
qDateInvoice	Date/Time	Date of Invoice
qDateGL	Date/Time	Date posted to General Ledger
qInvoiceType	Text(1)	Invoice Type 0=Cust,1=Contract,2=PO,3=WO,4=Periodic,5=Stmnt,6=External
qBegin	Memo
qClose	Memo
qInvoiceAmount	Currency	Invoice Amount Defaults to 0.
qSalesTax	Currency	Sales Tax Amount Defaults to 0.
qARAccount	Text(16)	Accounts Receivable Account Number
qARSeg	Text(16)	Account Segment
qBalance	Currency	Balance from Invoice Detail Defaults to 0.
qLastPayDate	Date/Time	Last Payment Date
qLastPayAmt	Currency	Last Payment Amount Defaults to 0.
qSalesPerson	Text(16)	Salesperson
qCheckNo	Long Integer	Check Number Defaults to 0.
qDisc	Double	Discount Percent Defaults to 0.
qDiscDate	Date/Time
qInvStatus	Text(1)	V=Void,E=Edit,O=Open,P=Paid
qReport	Text(16)	Invoice Report
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qRetPct	Double
qRetAmt	Currency
qRetInvPre	Text(8)
qRetInvNo	Text(8)
qPostFY	Integer
qPostPer	Integer

InvoiceSalesTax

Field	Type	Description
qYrMonth	Text(6)	Primary key. Year (yyyy) and Month (mm) This field is required.
qSalesTax	Text(10)	Primary key. Sales Tax ID This field is required.
qInvPrefix	Text(8)	Primary key. Invoice Prefix This field is required.
qInvoiceNo	Text(8)	Primary key. Invoice Number This field is required.
qTaxBasis	Currency	Taxable Amount Defaults to 0.
qTax	Currency	Calculated Sales Tax Defaults to 0.
qDateTime	Date/Time	Invoice Date

JobCost

Field	Type	Description
qJobID	Text(8)	Primary key. Job Identification This field is required.
qJobSeg	Text(16)	Primary key. Job Segment This field is required.
qDescription	Text(24)	Description
qInsClass	Text(10)	Insurance Class
qPayItem	Text(10)	Billing Pay Item
qUnitName	Text(6)	Unit Name
qUnitEst	Single	Est Units Defaults to 0.
qUnitMonth	Single	Month Units Defaults to 0.
qUnitLastMonth	Single	Last Month Units Defaults to 0.
qUnitPriorMonth	Single	Prior Months Units Defaults to 0.
qUnitsJTD	Single	JTD Units Defaults to 0.
qPercentComplete	Integer	Percent Complete Defaults to 0.
qLastPercent	Integer	Percent @ Last Month End Defaults to 0.
qPercent2months	Integer	Percent two month's ago Defaults to 0.
qPCDate	Date/Time	Date Percent Complete Updated
qPendPR	Currency	Amount held for Pending Payroll Defaults to 0.
qCostCodeOh	Double	Overhead Rate for Cost Code Defaults to 0.
qContact	Text(8)	Contact for PO/Sub
qSub_PONo	Text(10)	Sub/PO Number
qUpdateBy	Text(8)	User Identification
qActivity	Text(16)
qLastUpdate	Date/Time	Date of Last Update

JobCostDetail

Field	Type	Description
qJobID	Text(8)	Primary key. Job Identification This field is required.
qJobSeg	Text(16)	Primary key. Job Segment This field is required.
qChangeOrder	Integer	Primary key. Change Order Defaults to 0. This field is required.
qCostType	Text(5)	Primary key. Cost Type This field is required.
qOrigEst	Currency	Original Estimate Defaults to 0.
qMonthToDate	Currency	Month to Date Defaults to 0.
qLastMonth	Currency	Last Month Defaults to 0.
qPriorMonth	Currency	Two Months Age Defaults to 0.
qJobToDate	Currency	Total Cost Defaults to 0.
qLastFiscalJTD	Currency	Total @ Last Year End Defaults to 0.
qPriorFiscalJTD	Currency	Total Two Years Ago Defaults to 0.
qPercentComplete	Integer
qAcctNo	Text(16)
qAcctSeg	Text(16)
qCostToComplete	Currency
qUpdateBy	Text(8)	User ID
qLastUpdate	Date/Time	Date of Last Update

Jobs

Field	Type	Description
qJobID	Text(8)	Primary key. Job Identification This field is required.
qJobName	Text(50)	Name
qJobDesc	Memo	Description
qStartDate	Date/Time	Date Job Started
qCompl	Date/Time	Date Job Completed
qEstDate	Date/Time	Date of Original Estimate
qJobPhone	Text(12)	Job Phone
qJobFAX	Text(12)	Job FAX
qJobMgr	Text(16)	Job Manager
qJobStatus	Text(1)	Status of Job A=Active, I=Inactive, D=Delete
qJobState	Text(4)	State
qJobLocTax1	Text(4)	Local Tax 1
qJobLocTax2	Text(4)	Local Tax 2
qJobCounty	Text(4)	County
qJobCostAcct	Text(16)	Job Cost Account (wip only)
qJobCostSeg	Text(16)	Account Segment
qJobBankAcct	Text(16)	Job Bank Account (wip only)
qJobBankSeg	Text(16)	Account Segment
qCertified	Yes/No	Certified Payroll Reports? This field is required.
qJobOHCalc	Text(1)	Calculate Overhead at (H)ourly rate or (P)ercent
qJobOHPrint	Text(1)	Print Overhead per (J)ob/(S)egment 1-4
qJobOHLabor	Integer	Job Overhead - Labor Defaults to 0.
qJobOHOther	Integer	Job Overhead - All Other Defaults to 0.
qJobLienClass	Text(16)	Lien Release Report ID
qJobSubRet	Integer	Sub Retainage % Defaults to 0.
qFirstPR	Date/Time	First Payroll
qFirstAP	Date/Time	First A/P Invoice
qFirstAR	Date/Time	First A/R Invoice
qLastPR	Date/Time	Last Payroll
qLastAP	Date/Time	Last A/P Payment
qLastAR	Date/Time	Last A/R Invoice
qMiscBillings	Currency	Non Contract Billings Defaults to 0.
qLastFY	Integer	Last Fiscal Year Updated Defaults to 0.
qLastPer	Integer	Last Fiscal Period Updated Defaults to 0.
qCurrYr	Integer	Current Year Defaults to 0.
qCurrMo	Integer	Current Month Defaults to 0.
qJobAddr1	Text(48)
qUpdateBy	Text(8)	User Identification
qJobAddr2	Text(48)
qLastUpdate	Date/Time	Date of Last Update
qJobCity	Text(32)
qJobStCd	Text(2)
qJobZip	Text(10)
qJobSelTag	Text(16)
qDevelopment	Text(8)
qOwnerID	Text(8)
ContractNumber	Text(30)
qSalesTaxPct	Double
qCompletedContract	Yes/No	This field is required.
ContractorIDNo	Text(50)

JobVariance

Field	Type	Description
qJobID	Text(8)	Primary key. This field is required.
qJobSeg	Text(16)	Primary key. This field is required.
qCostType	Text(5)	Primary key. This field is required.
qVarSeq	Long Integer	Primary key. This field is required.
qVarAmt	Currency
qIDType	Text(1)
qID	Text(16)
qDesc	Text(50)
qConID	Text(8)
qReaID	Text(8)
qAssID	Text(8)
qVarDate	Date/Time
qVarComment	Text(50)
qLastUpdate	Date/Time
qUpdateBy	Text(8)

JobWageOverride

Field	Type	Description
qJobID	Text(8)	Primary key. Job Number This field is required. Foreign reference to Jobs.qJobID.
qCraftID	Text(10)	Primary key. Craft Code This field is required.
qWageID	Text(16)	Wage Code
qUBID	Text(10)	Union/Benefit Identification
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

Locations

Field	Type	Description
qConID	Text(8)	Primary key. Customer Identification This field is required. Foreign reference to CustomerInformation.qConID.
qLocation	Text(10)	Primary key. Customer Location Identification This field is required.
qLocDesc	Text(50)	Location Description
qSalesTax1	Text(10)	Sales Tax Code 1 Foreign reference to SalesTaxes.qSalesTax.
qSalesTax2	Text(10)	Sales Tax Code 2
qSalesTax3	Text(10)	Sales Tax Code 3
qSalesTax4	Text(10)	Sales Tax Code 4
qLocSalesMo	Currency	Sales This Month Defaults to 0.
qLocSales	Currency	Sales Total Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qLocCity	Text(24)
qLocState	Text(2)
qLocZip	Text(10)
qLocAddr1	Text(32)
qLocAddr2	Text(32)
qMapCode	Text(8)
qLocType	Integer
qLocContact	Text(16)
qSalesPerson	Text(16)
qPrefTech	Text(16)
qDirections	Memo
qNormTravel	Integer

MarkupPriceRange

Field	Type	Description
Range	Text(50)
Low	Currency	Defaults to 0.
High	Currency	Defaults to 0.
MarkUp	Double	Defaults to 0.

PayableDist

Field	Type	Description
qInvFYRef	Text(10)	Primary key. Invoice Number This field is required.
qDistNo	Text(3)	Primary key. Dist Number This field is required.
qAcctNo	Text(16)	Account
qAcctSeg	Text(16)	Distribution Account Segment
qPONo	Text(10)	PO Number (0=None)
qPOItem	Integer	PO Item Defaults to 0.
qItemNo	Text(16)	Inventory Item Number
qJobID	Text(8)	Job (blank=None)
qJobSeg	Text(16)	Job Segment
qCostType	Text(5)	Cost Type
qDistQty	Currency	Unit Qty Defaults to 0.
qUnitName	Text(6)	Unit Name
qDistAmount	Currency	Dist Amount Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

PayableHistory

Field	Type	Description
qFY	Integer	Primary key. Fiscal Year Defaults to 0. This field is required.
qPeriod	Integer	Primary key. Fiscal Period Defaults to 0. This field is required.
qConID	Text(8)	Primary key. Vendor ID This field is required.
qYear	Integer	Calendar Year Defaults to 0.
qMO	Integer	Month Defaults to 0.
qPurchases	Currency	Amount of purchases for period Defaults to 0.
qDiscAvail	Currency	Discounts Available Defaults to 0.
qPayments	Currency	Payments made to Vendor Defaults to 0.
qDiscTaken	Currency	Discounts Taken Defaults to 0.
qUpdateBy	Text(8)	User Last Updated by
qInsWCWH	Currency
qLastUpdate	Date/Time	Date of Last Update
qInsGLWH	Currency

PayableRun

Field	Type	Description
qPayType	Text(1)	Primary key. 1=Void, 2=Man, 3=Print This field is required.
qConID	Text(8)	Primary key. Vendor Code This field is required.
qInvFYRef	Text(10)	Primary key. Invoice Number This field is required.
qCheckSeq	Integer	Check Sequence Defaults to 0.
qCheckNo	Long Integer	Assigned Check Number Defaults to 0.
qPayAmt	Currency	Amount to Pay Defaults to 0.
qOK	Text(1)	Printed OK (Y/N)
qRunDate	Date/Time	Date of Run
qLienRpt	Text(16)	Lien Release Report ID
qPOFinal	Yes/No	Lien Final Payment This field is required.

Payables

Field	Type	Description
qInvFYRef	Text(10)	Primary key. RefNo This field is required.
qMo	Integer	Month Defaults to 0.
qConID	Text(8)	Contact Code Foreign reference to PayablesVendor.qConID.
qConInv	Text(12)	Vendor Invoice ID
qInvPayJob	Text(8)	Payment Selection Job
qPPriority	Text(1)	Pay Priority (0-9)
qInvDate	Date/Time	Invoice Date
qInvDiscount	Currency	Discount (Neg=Amount / Percent) Defaults to 0.
qInvDiscDate	Date/Time	Discount Date
qInvDueDate	Date/Time	Due Date
qTempUsed	Integer	1 = Temp.Name, 2 = Temp.Addr, 3=Both Defaults to 0.
qTempPayee	Memo	Temporary Payee Name
qTempAddr	Memo	Temporary Address
qInvDesc	Text(50)	Invoice Description
qInvAmount	Currency	Invoice Amount Defaults to 0.
qInvBal	Currency	Invoice Balance Defaults to 0.
qInvLstPmt	Currency	Invoice Last Payment Defaults to 0.
qInvLstDate	Date/Time	Lasy Payment Date
qCheckNo	Long Integer	Payment Check Number Defaults to 0.
qInvStatus	Text(1)	Invoice Status: N=Normal, J=Job, H=Hold, D=Direct Pay, X=Paid
qInvPayAmt	Currency	Amount to Pay Defaults to 0.
qInvPayDisc	Currency	Discount Taken Defaults to 0.
qEnterDate	Date/Time	Date Entered
qInvSel	Text(1)	Blank=Not selected, M=Manual, S=Selected, X=Paid
q1099Type	Integer	0=n/a, 1-11=MiscBox, 12=Interest Defaults to 0.
q1099Amt	Currency	Amount for 1099 Defaults to 0.
qUpdateBy	Text(8)	User Identification
qInvRetCtl	Integer
qLastUpdate	Date/Time	Date of Last Update
qRetCtlID	Text(16)
qInvTax	Currency
qInvDiscTax	Yes/No	This field is required.
qInvWCAmt	Currency
qInvGLAmt	Currency
qPostFY	Integer
qPostPer	Integer
qInvRetPct	Double
qInvRetAmt	Currency
qSubConID	Text(16)
qPONo	Text(10)

PayablesRecurring

Field	Type	Description
qRefNo	AutoNumber	Primary key. Recurring Bill Number This field is required.
qConID	Text(8)	Primary key. Vendor Identification This field is required.
qPDesc	Text(50)	Description
qPPriority	Text(1)	Pay Priority (0-9, Hold)
qPAmt	Currency	Payment Amount Defaults to 0.
qPDisc	Integer	Payment Discount Percent Defaults to 0.
qPDays	Integer	Payment Discount Days Defaults to 0.
qDayDue	Integer	Day Due (1-31) Defaults to 0.
qFreq	Text(1)	Frequency: M=Monthly, Q=Quarterly, S=Semi-Ann, A=Annual
qStartMo	Integer	Starting Month: 0-12 Defaults to 0.
qMax	Integer	Number of Payments Defaults to 0.
qUsed	Integer	Payments Done Defaults to 0.
q1099Type	Integer	0=n/a, 1-11=Box, 12=Interest Defaults to 0.
q1099Dist	Integer	1=Dist1Amt, 2=Dist2Amt,3=Total Defaults to 0.
qPrinAmt	Currency	Loan Principal Amt Defaults to 0.
qPBalance	Currency	Loan Balance Defaults to 0.
qAnnInt	Currency	Simple Annual Interest Rate (0=None) Defaults to 0.
qAcctNo1	Text(16)	1st Distribution
qAcctSeg1	Text(16)
qDistAmt1	Currency	Principal, if qAnnInt Supplied Defaults to 0.
qAcctNo2	Text(16)	2nd Distribution
qAcctSeg2	Text(16)
qDistAmt2	Currency	Interest, if qAnnInt Supplied Defaults to 0.
qLastPay	Date/Time	Last Recurr Payment
qUpdateBy	Text(8)	User Last Updated By
qLastUpdate	Date/Time	Date of Last Update

PayablesVendor

Field	Type	Description
qConID	Text(8)	Primary key. Contact Code This field is required.
qPriority	Text(1)	Default Payment Priority 0-9, H=Hold
qLPayDate	Date/Time	Date of last payment
qLPayAmt	Currency	Last Amount Paid Defaults to 0.
qLimit	Currency	Credit Limit with vendor Defaults to 0.
q1099Type	Integer	0=n/a, 1-11=Box, 12=Interest Defaults to 0.
qDefaultAcct	Text(16)	Default AP Cost Account for Vendor
qDefaultSeg	Text(4)	Default Segment
qPayTerms	Text(20)	Terms Description
qPayDisc	Double	Discount Percent Defaults to 0.
qPayDays	Integer	Number of days for discount Defaults to 0.
qClass	Text(8)	Vendor Class (User Defined)
qType	Text(8)	Vendor Type (User Defined)
qExp1Name	Text(24)	1st Exp Date Name
qExp1Date	Date/Time	1st Exp Date
qExp2Name	Text(24)	2nd ExpDate Name
qExp2Date	Date/Time	2nd Exp Date
qUpdateBy	Text(8)	User ID
1099IDName	Text(36)
qLastUpdate	Date/Time	Date of Last Update
qInsWCPct	Single
qInsGLPct	Single
qInsLbrPct	Single
qInsCode	Text(6)
qRetainage	Double
qCostID	Text(16)
qCostType	Text(5)
qPayOn	Integer

PayrollCalc

Field	Type	Description
qYrMoWkRun	Text(10)	Primary key. Calendar Year This field is required.
qEmpID	Text(8)	Primary key. Employee ID This field is required.
qSource	Integer	Primary key. 0=Emp W/H, 1=Ben Plan, 2=Union, 3=Tax Defaults to 0. This field is required.
qID	Text(10)	Primary key. Deduction Identification This field is required.
qSeq	Long Integer	Primary key. Sequence Defaults to 0. This field is required.
qOnCheck	Yes/No	Print on check? This field is required.
qType	Integer	1=Ben, 2=Ded, 3=Both Defaults to 0.
qHrST	Single	ST Hours Defaults to 0.
qHrOT1	Single	OT1 Hours Defaults to 0.
qHrOT2	Single	OT2 Hours Defaults to 0.
qHrOT3	Single	OT3 Hours Defaults to 0.
qEarnBasis	Currency	Earnings Basis Defaults to 0.
qWgOT1	Currency	OT1 Wages Defaults to 0.
qWgOT2	Currency	OT2 Wages Defaults to 0.
qWgOT3	Currency	OT3 Wages Defaults to 0.
qWgThruDay	Integer	Wages Thru Day Defaults to 0.
qAmount	Currency	Ben/Deduction Amount Defaults to 0.
qWipAmt	Currency
qInDirAmt	Currency

PayrollChecks

Field	Type	Description
qKey	AutoNumber	Primary key. Sequence This field is required.
qYrMoWkRun	Text(10)	Year-Month-Week-Run
qEmpID	Text(8)	Employee
qCheckNo	Long Integer	Check Number Defaults to 0.
qWagesThru	Date/Time	Wages thru Date
qLastJob	Text(8)	Last Job Worked
qYtdTxt1	Text(16)
qYtdAmt1	Currency
qYtdTxt2	Text(16)
qYtdAmt2	Currency
qYtdTxt3	Text(16)
qYtdAmt3	Currency
qYtdTxt4	Text(16)
qYtdAmt4	Currency
qYtdTxt5	Text(16)
qYtdAmt5	Currency
qYtdTxt6	Text(16)
qYtdAmt6	Currency

PayrollEarnings

Field	Type	Description
qYrMoWkRun	Text(10)	Primary key. Calendar Year This field is required.
qEmpID	Text(8)	Primary key. Employee ID This field is required.
qSeq	Integer	Primary key. Sequence Defaults to 0. This field is required.
qType	Integer	1=Wages, 2=Vac, 3=Sick, 4=Holiday, 5=Personal, 8= Equip Defaults to 0.
qJobID	Text(8)	Job Number Foreign reference to Jobs.qJobID.
qJobSeg	Text(16)	Job Segment
qEquipID	Text(16)	Equip ID
qWorkOrderNo	Text(10)	Work Order No
qID	Text(16)	Wage Rate ID/Addl Comp ID
qCraftID	Text(16)	Craft ID
qSTRate	Single	ST Rate Defaults to 0.
qOT1	Single	OT1 Rate Defaults to 0.
qOT2	Single	OT2 Rate Defaults to 0.
qOT3	Single	OT3 Rate Defaults to 0.
qInsID	Text(10)	Insurance lD
qState	Text(4)	State Tax
qLoc1	Text(4)	Local Tax 1
qLoc2	Text(4)	Local Tax 2
qLoc3	Text(4)	Local Tax 3
qCounty	Text(4)	County
qUnSt	Text(4)	Unemployment State
qTaxCtl	Text(12)	Y/N for Loc,SIT,SUI,Ins,FUI,FIT,FICA,MEDI + Reserved(4)
qUB1	Text(10)	Un/Ben 1
qUB2	Text(10)	Un/Ben 2
qUB3	Text(10)	Un/Ben 3
qUB4	Text(10)	Un/Ben 4
qUB5	Text(10)	Un/Ben 5
qUB6	Text(10)	Un/Ben 6
qDay1ST	Single	Day1, ST Hrs Defaults to 0.
qDay1OT1	Single	Day1, OT1 Hrs Defaults to 0.
qDay1OT2	Single	Day1, OT2 Hrs Defaults to 0.
qDay1OT3	Single	Day1, OT3 Hrs Defaults to 0.
qDay2ST	Single	Day2, ST Hrs Defaults to 0.
qDay2OT1	Single	Day2, OT1 Hrs Defaults to 0.
qDay2OT2	Single	Day2, OT2 Hrs Defaults to 0.
qDay2OT3	Single	Day2, OT3 Hrs Defaults to 0.
qDay3ST	Single	Day3, ST Hrs Defaults to 0.
qDay3OT1	Single	Day3, OT1 Hrs Defaults to 0.
qDay3OT2	Single	Day3, OT2 Hrs Defaults to 0.
qDay3OT3	Single	Day3, OT3 Hrs Defaults to 0.
qDay4ST	Single	Day4, ST Hrs Defaults to 0.
qDay4OT1	Single	Day4, OT1 Hrs Defaults to 0.
qDay4OT2	Single	Day4, OT2 Hrs Defaults to 0.
qDay4OT3	Single	Day4, OT3 Hrs Defaults to 0.
qDay5ST	Single	Day5, ST Hrs Defaults to 0.
qDay5OT1	Single	Day5, OT1 Hrs Defaults to 0.
qDay5OT2	Single	Day5, OT2 Hrs Defaults to 0.
qDay5OT3	Single	Day5, OT3 Hrs Defaults to 0.
qDay6ST	Single	Day6, ST Hrs Defaults to 0.
qDay6OT1	Single	Day6, OT1 Hrs Defaults to 0.
qDay6OT2	Single	Day6, OT2 Hrs Defaults to 0.
qDay6OT3	Single	Day6, OT3 Hrs Defaults to 0.
qDay7ST	Single	Day7, ST Hrs Defaults to 0.
qDay7OT1	Single	Day7, OT1 Hrs Defaults to 0.
qDay7OT2	Single	Day7, OT2 Hrs Defaults to 0.
qDay7OT3	Single	Day7, OT3 Hrs Defaults to 0.
qStatus	Integer	0=Open, 1=Printed, 2=Field, 4=Void Defaults to 0.
qPay	Currency	Wages Defaults to 0.
qWgBn	Currency	Benefit Wages Defaults to 0.
qWgUn	Currency	Union Wages Defaults to 0.
qWgUI	Currency	Unemployment Wages Defaults to 0.
qCoPdBn	Currency	Co Paid Ben.Plan Earn Defaults to 0.
qCoPdUn	Currency	Co Paid Union Earn Defaults to 0.
qWgIns	Currency	Insurable Wages Defaults to 0.
qCoPdIns	Currency	Co Paid Ins Defaults to 0.
qCoPdUI	Currency	Co Paid FUI/SUI Defaults to 0.
qCoPdTax	Currency	Co Paid Tax Defaults to 0.
qCheckNo	Long Integer	Check Number Defaults to 0.
qCheckDate	Date/Time	Check Date
qBankAcct	Text(16)	Bank Acct
qBankSeg	Text(16)	Bank Acct Seg
qCostAcct	Text(16)	Cost Acct
qCostSeg	Text(16)	Cost Acct Seg
qJobQty	Double
qJobUnit	Text(6)
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qWagesThruDate	Date/Time
qCompletedContract	Yes/No	This field is required.

PayrollSumm

Field	Type	Description
qYrQtr	Text(5)	Primary key. This field is required.
qEmpID	Text(8)	Primary key. This field is required.
qSource	Integer	Primary key. This field is required.
qID	Text(10)	Primary key. This field is required.
qSeq	Long Integer	Primary key. This field is required.
qOnCheck	Yes/No	This field is required.
qType	Integer
qHrST	Double
qHrOT1	Double
qHrOT2	Double
qHrOT3	Double
qWgWeeks	Integer
qAmount	Currency
qEarnings	Currency
qExcess	Currency
qW2XPos	Integer
qW2Box	Integer
qW2Code	Text(1)
qWgST	Currency
qWgOT	Currency

PeriodicBillingControl

Field	Type	Description
qPerGrp	Text(10)	Primary key. Periodic Calculation Group This field is required.
qPerGrpDesc	Text(50)	Periodic Description
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

PeriodicBillingItems

Field	Type	Description
qPerGrp	Text(10)	Primary key. Periodic Calculation Group This field is required. Foreign reference to PeriodicBillingControl.qPerGrp.
qPerRef	Integer	Primary key. Periodic Group Reference Defaults to 0. This field is required.
qPerDesc	Text(80)	Periodic Group Description
qPerFreq	Text(1)	Periodic Frequency M=Monthly, Q=Quarterly, S=Semi-annually, A= Annually, 1-9=Number of Month to bill
qPerAmt	Currency	Periodic Amount Defaults to 0.
qPerTax	Yes/No	Taxable? This field is required.
qPerSalesAcct	Text(16)
qPerSalesSeg	Text(16)
qPerStatus	Text(1)	Status A=Active, I=Inactive

PurchaseDetail

Field	Type	Description
qPONo	Text(10)	Primary key. PO Identification This field is required.
qPOItem	Integer	Primary key. Item Number Defaults to 0. This field is required.
qPOID	Text(16)	Inventory ID
qPODesc	Text(72)	Item Description
qPOQtyOrd	Double	Item Quantity Defaults to 0.
qPOQtyRcvd	Double	AP Quantity Defaults to 0.
qPOUnit	Text(6)	Unit Name
qPOUnitCost	Currency	Unit Cost Defaults to 0.
qPOUnitBill	Currency	Unit Billing Defaults to 0.
qPOOrdStat	Integer	Status (0=NotOrdered, 1=Ordered, 2=Backorder, 3= OutofStock, 4=PartRecvd, 5=Received) Defaults to 0.
qPOBillStat	Integer	Billing Status (0=NotBilled, 1=Billed) Defaults to 0.
qSalesTax	Text(16)	Sales Tax
qOrderDate	Date/Time	Order Date
qRequestDate	Date/Time	Requested Arrival Date
qShipDate	Date/Time	Cust Ship Date
qBillDate	Date/Time	Cust Bill Date
qRecDate	Date/Time	Received Date
qDisc	Integer	Discount Percent Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qVarianceID	Text(8)
qAssignToID	Text(8)
qTaxPct	Double
qScope	Memo
qIDtype	Integer
qJobSeg	Text(16)
qJobID	Text(8)
qJobCO	Integer
qCostType	Text(5)

PurchaseOrders

Field	Type	Description
qPONo	Text(10)	Primary key. PO/Sub Ref This field is required.
qPODesc	Text(72)	PO Desc
qPOScope	Memo	Scope of Work
qConID	Text(8)	Contact Code
qShipTo	Text(8)	Customer Code to Ship To
qPODate	Date/Time	Purchase Order Date
qPOType	Integer	0=Indirect, 1=Direct, 2=FixedAsset, 3=Inventory, 4=WO Defaults to 0.
qPOStat	Integer	0=Normal, 1=Complete, 2=Void, 3=Returned Defaults to 0.
qJobID	Text(8)	Job Number Foreign reference to Jobs.qJobID.
qJobSeg	Text(16)	Job Segment
qJobCO	Integer	CO No Defaults to 0.
qCostType	Text(5)	Cost Type
qWorkOrder	Text(10)	Work Order Identification
qAcctNo	Text(16)	Reqd for Fixed Asset & Indirect
qAcctSeg	Text(16)
qFirmQuote	Yes/No	This field is required.
qTotal	Currency	Total Defaults to 0.
qDocument	Text(16)	Document
qBillings	Currency	PO Billings to Date Defaults to 0.
qBillDate	Date/Time	PO Last Bill Date
qPayments	Currency	PO Payments to Date Defaults to 0.
qPayDate	Date/Time	PO Last Pay
qSubRet	Single	Subcontract Retainage Percent Defaults to 0.
qRetInv	Text(10)	Retainage Invoice FYRef
qNetCO	Currency	Subcontract Net of Change Orders Defaults to 0.
qLastCO	Integer	Subcontract Last Change Order Number Defaults to 0.
qAuthEx	Currency	Subcontract Net Authorized Extras Defaults to 0.
qBack	Currency	Subcontract Net Backcharges Defaults to 0.
qFreight	Memo	Freight Info
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qVarianceID	Text(8)
qAssignToID	Text(8)

PurchaseSelect

Field	Type	Description
qPONo	Text(10)	Primary key. PO Selected This field is required.
qPOItem	Integer	Primary key. Item Selected (0=No Items for PO) Defaults to 0. This field is required.

SalesItem

Field	Type	Description
qItemID	Text(16)	Primary key. Sales Item ID This field is required.
qItemDesc	Text(80)
qItemUnit	Text(2)
qItemPrice	Currency	Price/Unit Defaults to 0.
qItemTax	Yes/No	Taxable ? This field is required.
qSalesAcct	Text(16)
qSalesSeg	Text(16)
qUpdateBy	Text(8)
qItemCost	Currency
qLastUpdate	Date/Time
qPrefVen	Text(8)
qEstID	Text(16)
qJobSeg	Text(16)
qCostType	Text(5)

SalesTaxes

Field	Type	Description
qSalesTax	Text(10)	Primary key. Sales Tax Name This field is required. Foreign reference to InvoiceDetail.qSalesTax1.
qSalesRate	Double	Sales Tax Percent Defaults to 0.
qAcctNo	Text(16)	Sales Tax Liability Account
qAcctSeg	Text(16)	Account Segment
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

SegmentBrowse

Field	Type	Description
qSegBrType	Text(1)	Primary key. J=Job, A=Account This field is required.
qSegBrNo	Text(1)	Primary key. Segment Number (1-4) This field is required.
qSegBrPrior	Text(16)	Primary key. Prior Conditional Segments This field is required.
qSegBrId	Text(8)	Primary key. Browse ID This field is required.
qSegBrDesc	Text(32)	Browse Description
qUpdateBy	Text(8)	User ID for Last Update
qLastUpdate	Date/Time	Last Date Updated

Segments

Field	Type	Description
qSegType	Text(1)	Primary key. J= Job, A= Account This field is required.
qSegNo	Text(1)	Primary key. Segment Number (1-4) This field is required.
qSegName	Text(12)	Segment Name
qSegLength	Text(1)	Segment Length
qSegMask	Text(8)	Segment Mask
qSegBrTbl	Yes/No	Use Segment Browse Table ? This field is required.
qSegOpt	Yes/No	Optional? This field is required.
qSegAdd	Yes/No	Add Segments on the Fly? This field is required.
qSegBrCond	Yes/No	Browse conditional on prior segment? This field is required.
qUpdateBy	Text(8)	User ID for Last Update
qLastUpdate	Date/Time	Last Date Updated

ServiceAgreement

Field	Type	Description
qConID	Text(8)	Primary key. This field is required.
qLocation	Text(10)	Primary key. This field is required.
qSeq	Text(4)	Primary key. This field is required.
qDescription	Text(50)
qFrequency	Text(1)
qFirstMonth	Integer
qNextService	Date/Time
qProcedure	Memo
qTaskID	Text(16)
qCustEqSeq	Integer
qPrefTech	Text(16)
qLastService	Date/Time
qLastWO	Text(10)
qUpdateBy	Text(8)
qLastUpdate	Date/Time
qBillAmt	Currency
qActiveWO	Text(10)
qWOBillGrp	Text(10)

ServiceTask

Field	Type	Description
qTaskID	Text(16)	Primary key. This field is required.
qTaskGroup	Text(16)
qTaskDesc	Text(48)
qTechLevel	Long Integer
qProcedure	Memo
qUpdateBy	Text(8)
qLastUpdate	Date/Time

ServiceTaskDetail

Field	Type	Description
qTaskID	Text(16)	Primary key. This field is required.
qSeq	Integer	Primary key. This field is required.
qType	Text(1)
qID	Text(16)
qDesc	Text(48)
qQty	Double
qUnit	Text(6)
qCost	Currency
qOptGp	Text(1)
qUpdateBy	Text(8)
qLastUpdate	Date/Time

ServiceTech

Field	Type	Description
qTechID	Text(16)	Primary key. This field is required.
qEmpID	Text(8)
qEquipID	Text(16)
qInvLoc	Text(16)
qStatus	Integer
qTechLevel	Long Integer
qUpdateBy	Text(8)
qLastUpdate	Date/Time

SubcontractDetail

Field	Type	Description
qSubConID	Text(16)	Primary key. This field is required.
qPayItem	Text(10)	Primary key. This field is required.
qCONo	Text(8)	Primary key. This field is required.
qPayType	Text(1)
qPayDesc	Text(50)
qPayStatus	Text(1)
qPayRetPct	Double
qPayUnitName	Text(10)
qPayQtyJob	Double
qPayQtyNow	Double
qPayQtyPrior	Double
qPayBillJob	Currency
qPayBillNow	Currency
qPayBillPrior	Currency
qPayRetJob	Currency
qPayRetNow	Currency
qPayRetPrior	Currency
qPayStMtlNow	Currency
qPayStMtlPrior	Currency
qPayBillLast	Currency
qPayBillPast	Currency
qPayRetReduct	Currency
qSalesTax1	Text(10)
qSalesTax2	Text(10)
qSalesTax3	Text(10)
qSalesTax4	Text(10)
qUpdateBy	Text(8)
qLastUpdate	Date/Time
qJobSeg	Text(16)
qJobID	Text(8)
qChangeOrder	Integer
qCostType	Text(5)

Subcontracts

Field	Type	Description
qSubConID	Text(16)	Primary key. This field is required.
qConID	Text(8)
qJobID	Text(8)
qSubName	Text(36)
qSubRef	Memo
qSubDate	Date/Time
qSubRetPct	Double
qSubType	Text(1)
qSubMarkup	Double
qSubProfit	Double
qSubInclCO	Yes/No	This field is required.
qSalesTax1	Text(10)
qSalesTax2	Text(10)
qSalesTax3	Text(10)
qSalesTax4	Text(10)
qSubLastBill	Date/Time
qSubReport	Text(16)
qSubCostAcct	Text(16)
qSubCostSeg	Text(16)
qSubPI	Text(10)
qUpdateBy	Text(8)
qLastUpdate	Date/Time
qCostPI	Text(16)
qRetInv	Text(10)
qCostID	Text(16)
qCostType	Text(5)
qBillGpID	Text(16)
qChangeOrder	Integer
qAppNo	Integer
qBillThru	Date/Time

TaxControl

Field	Type	Description
qTaxType	Text(1)	Primary key. Federal/State/Local This field is required.
qTaxID	Text(4)	Primary key. Tax Code This field is required.
qReptNo	Text(16)	Tax Identification
qCoPdEx	Currency	Company Paid Exempt Wages Defaults to 0.
qCoPdTax	Currency	Company Paid Tax Percent Defaults to 0.
qCoPdTaxCut	Currency	Company Paid Tax Cutoff Defaults to 0.
qCoPdEarnCut	Currency	Company Paid Earnings Cutoff Defaults to 0.
qCoPdAcct	Text(16)	Company Paid Accrual Account
qCoPdSeg	Text(16)	Account Segment
qEmpPdEx	Currency	Employee Paid Exempt Wages Defaults to 0.
qEmpPdTax	Currency	Employee Paid Tax Percent Defaults to 0.
qEmpPdTaxCut	Currency	Employee Paid Tax Cutoff Defaults to 0.
qEmpPdEarnCut	Currency	Employee Paid Earnings Cutoff Defaults to 0.
qEmpPdAcct	Text(16)	Employee Paid Accrual Account
qEmpPdSeg	Text(16)	Account Segment
qEmpPdRnd	Yes/No	Round W/H to Dollar ? This field is required.
qUnEx	Currency	Unemployment Exempt Wages Defaults to 0.
qUnTax	Currency	Unemployment Tax Percent Defaults to 0.
qUnTaxCut	Currency	Unemployment Tax Cutoff Defaults to 0.
qUnEarnCut	Currency	Unemployment Earnings Cutoff Defaults to 0.
qUnAcct	Text(16)	Unemployment Accrual Account
qUnSeg	Text(16)	Account Segment
qFuStCr	Currency	Federal Unemployment State Credit Percent Defaults to 0.
qInsWage	Text(1)	Insurable Wages Calculated How? 1=ST Wages, 2=Total Wages, 3=Hours at ST Rate
qCalcBene	Yes/No	Calculate Tax for Non-Taxable Employee Paid Benefits This field is required.
qMaxYTD	Currency	Maximum YTD State Wages for Worker's Compensation Defaults to 0.
qGenLiab	Yes/No	Calculate General Liability as a Rate per Hour? This field is required.
qWrkComp	Yes/No	Calculate Worker's Compensation as a Rate per Hour? This field is required.
qTable	Yes/No	Tax Table Used? This field is required.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qLocRecip	Yes/No	This field is required.

TaxDeposits

Field	Type	Description
qTaxType	Text(1)	Primary key. Tax Type (F,S,L) This field is required.
qTaxID	Text(4)	Primary key. Tax Identification This field is required.
qYear	Text(4)	Primary key. Calendar Year This field is required.
qQtr	Text(1)	Primary key. Which Quarter? (1-4) This field is required.
qSeq	Text(3)	Primary key. Sequence This field is required.
qDepAmt	Currency	Amount of Depost Defaults to 0.
qDepDate	Date/Time	Date of Deposit
qUpdateBy	Text(8)	User Last Updated By
qLastUpdate	Date/Time

TaxDetail

Field	Type	Description
qTaxType	Text(1)	Primary key. Federal/State/Local This field is required.
qTaxID	Text(4)	Primary key. Tax Identification This field is required. Foreign reference to TaxControl.qTaxID.
qTaxStatus	Text(1)	Primary key. Marital Status 1-9 This field is required.
qCalType	Integer	Calculation on? 1=Taxable Gross, 2=Federal Income Tax, 3=Gross for FIT Defaults to 0.
qWgPct	Single	State and Local Taxable Percent Defaults to 0.
qFedPct	Single	Federal Tax Percent Defaults to 0.
qAllowDed	Yes/No	Allow Deductions This field is required.
qStdDedPct	Single	Standard Deduction Percent Defaults to 0.
qStdDedAdj	Currency	Standard Deduction Adjustment Defaults to 0.
qStdDedMin	Currency	Standard Deduction Minimum Defaults to 0.
qStdDedMax	Currency	Standard Deduction Maximum Defaults to 0.
qStdDedBrk	Integer	Standard Deduction Dependent Breakpoint Defaults to 0.
qStdDedMax2	Currency	Standard Deduction Second Maximum Defaults to 0.
qTaxB4Wh	Yes/No	Calculate the Withholding Tax before Dependents are deducted? This field is required.
qDep1	Currency	Dependent one allowance Defaults to 0.
qDepBrk1	Integer	Dependent Breakpoint 1 Defaults to 0.
qDep2	Currency	Dependent two allowance Defaults to 0.
qDepBrk2	Integer	Dependent Breakpoint 2 Defaults to 0.
qDep3	Currency	Dependent three allowance Defaults to 0.
qUpdateBy	Text(8)	User Identification
qFedMax	Currency
qLastUpdate	Date/Time	Date of Last Update

TaxStatus

Field	Type	Description
qTaxStatus	Text(1)	Primary key. 1=Single, 2=Married, 3-9=Other This field is required.
qTaxStatusDesc	Text(16)	Tax Status Desc

TaxTable

Field	Type	Description
qTaxType	Text(1)	Primary key. Federal/State/Local This field is required.
qTaxID	Text(4)	Primary key. Tax Identification This field is required.
qTaxStatus	Text(1)	Primary key. Tax Table This field is required.
qTaxLine	Integer	Primary key. Tax Line Defaults to 0. This field is required.
qTaxEarn	Currency	Tax Earnings Defaults to 0.
qTaxAmt	Currency	Tax Amount Defaults to 0.
qTaxRate	Currency	Tax Rate Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

UnionBenefitControl

Field	Type	Description
qUBID	Text(10)	Primary key. Union/Benefit Identification This field is required.
qUBDesc	Text(50)	Union/Benefit Description
qUB	Text(1)	Is this a (U)nion or a (B)enefit plan?
qUBNextID	Text(10)	Next Un/Ben Plan
qUBExpDate	Date/Time	Expiration Date
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qUBJobID1	Text(8)
qUBJobSeg1	Text(16)
qUBJobID2	Text(8)
qUBJobSeg2	Text(16)

UnionBenefitDetail

Field	Type	Description
qUBID	Text(10)	Primary key. Union/Benefit Identification This field is required.
qUBSeq	Long Integer	Primary key. Union/Benefit Record Number Defaults to 0. This field is required.
qUBDesc	Text(50)	Union/Benefit Record Description
qUBStatus	Yes/No	Active ? This field is required.
qUBPaid	Text(1)	Paid by? C=Company, E=Employee
qUBTaxOpt	Text(12)	Tax Ctl: LocSIT,SUI,Ins, + Fed(8)
qUBPrint	Yes/No	Print on Employee's Check? This field is required.
qUBWH	Yes/No	Withhold from Employee's Check? This field is required.
qUBEmpAuth	Integer	Employee Authorization Required? (0=No) Defaults to 0.
qUBFreq	Integer	Frequency? 1=Week1, 2=Week 2, 3=Week 3, 4=Week 4, 5=Biweekly, 6=Daily, 7=Weekly Defaults to 0.
qUBCalc	Integer	Calculation Type? 1=Hourly, 2=Percent, 3=Fixed Amount, 4=Prompt Operator Defaults to 0.
qUBSt	Text(4)	Which State (or All) should this record calculate on?
qUBGrB	Integer	Gross Basis for Percent Calculation? 1=ST Gross, 2=Total Wages, 3=Total Hours at ST Rate, 4=Total Taxable Earnings Defaults to 0.
qUBMax	Currency	Maximum Amount to Calc Defaults to 0.
qUBSTRate	Currency	Straight Time Rate Defaults to 0.
qUBOT1Rate	Currency	Overtime 1 Rate Defaults to 0.
qUBOT2Rate	Currency	Overtime 2 Rate Defaults to 0.
qUBOT3Rate	Currency	Overtime 3 Rate Defaults to 0.
qUBRound	Integer	0=none, 1=HalfAdj, 2=Trunc, 3=Up Defaults to 0.
qUBRndAmt	Currency	Rounding Amount Defaults to 0.
qUBExp	Text(16)	Expense Account
qUBSeg	Text(16)	Account Segment
qUBLiab	Text(16)	Liability Account
qUBLiabSeg	Text(16)	Account Segment
qUBMergeSeg	Integer	Merge the Employee Number at Segment (1-4) Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qW2XPos	Integer
qW2Box	Integer
qW2Code	Text(1)
qUBMaxBasis	Text(1)
qDepBankID	Text(8)
qDepAcctID	Text(17)
qEmpID	Text(8)

VarianceAssign

Field	Type	Description
qID	Text(8)	Primary key. This field is required.
qName	Text(24)

VarianceReason

Field	Type	Description
qID	Text(8)	Primary key. This field is required.
qDesc	Text(32)

WageTable

Field	Type	Description
qWageID	Text(16)	Primary key. Wage Identification This field is required.
qSTRate	Currency	Straight Time Rate Defaults to 0.
qOT1	Currency	Overtime Rate 1 Defaults to 0.
qOT2	Currency	Overtime Rate 2 Defaults to 0.
qOT3	Currency	Overtime Rate 3 Defaults to 0.
qWageDesc	Text(50)	Wage Description
qEffDate	Date/Time	Effective Date of Wage Rate
qExpDate	Date/Time	Expiration Date of Wage Rate
qWageNext	Text(16)	Next Wage Rate to Use
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

WorkOrderARDtl

Field	Type	Description
qWorkOrderNo	Text(10)	Primary key. This field is required.
qItemSeq	Integer	Primary key. This field is required.
qItemType	Text(1)
qItemQty	Double
qItemUnit	Text(6)
qItemID	Text(16)
qItemDesc	Text(50)
qItemPrice	Currency
qItemMarkup	Currency
qUpdateBy	Text(8)
qLastUpdate	Date/Time

WorkOrderBillingGroups

Field	Type	Description
qWOBillGrp	Text(10)	Primary key. Work Order Billing Group Number This field is required. Foreign reference to WorkOrderCraftRates.qWOBillGrp.
qBillDesc	Text(50)	Billing Group Description
qLaborMarkup	Single	Labor Markup Defaults to 0.
qEquipMarkup	Single	Equipment Markup Defaults to 0.
qPOMarkup	Single	Purchase Order Markup Defaults to 0.
qMatMarkup1	Single	Material Markup Table Item 1 Defaults to 0.
qMatBreak1	Currency	Material Markup Break 1 Defaults to 0.
qMatMarkup2	Single	Material Markup Table Item 2 Defaults to 0.
qMatBreak2	Currency	Material Markup Break 2 Defaults to 0.
qMatMarkup3	Single	Material Markup Table Item 3 Defaults to 0.
qMatBreak3	Currency	Material Markup Break 3 Defaults to 0.
qMatMarkup4	Single	Material Markup Table Item 4 Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLaborByCraft	Yes/No	This field is required.
qLastUpdate	Date/Time	Date of Last Update
qOtherMarkup	Single
qSubMarkup	Single
qOverhead	Single
qProfit	Single

WorkOrderControl

Field	Type	Description
qWorkOrderNo	Text(10)	Primary key. Work Order Number This field is required.
qConID	Text(8)	Primary key. Customer Identification This field is required.
qWOTask	Text(40)	Brief Description of Work
qWorkDate	Date/Time	Work Order Date
qWorkCompleteDate	Date/Time	Work Order Completion Date
qWOBillGrp	Text(10)	Work Order Billing Group Foreign reference to WorkOrderBillingGroups.qWOBillGrp.
qWOType	Text(1)	Transaction Type 1=Time & Material, 2=Service, 3=Warranty
qWODesc	Memo	Work Order Description
qSalesTax1	Text(10)	Sales Tax 1
qSalesTax2	Text(10)	Sales Tax 2
qSalesTax3	Text(10)	Sales Tax 3
qSalesTax4	Text(10)	Sales Tax 4
qWOARAcct	Text(16)	Accounts Receivable Account Charged
qWOARSeg	Text(16)	Account Segment
qWOSalesAcct	Text(16)	Sales Account Charged
qWOSalSeg	Text(16)	Account Segment
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update
qWOrdered	Date/Time	Date Work Order Received
qWorkDone	Memo	Description of work Done
qLocation	Text(10)	Location Description
qWOAssign	Text(8)	Technician Work Order Assigned To
qWOTaxOpt	Text(4)	Is Material Taxable
qWOStatus	Integer	Status of Work Order
qScheduled	Date/Time
qWorkEnd	Date/Time
qHelper1	Text(16)
qHelper2	Text(16)
qCardCk	Text(16)
qCardExp	Text(5)
qCardConf	Long Integer
qWODiscount	Currency
qEstHrs	Single
qServAgreeSeq	Integer
qWOAddDate	Date/Time
qWOSource	Text(24)
qRefCust	Text(8)
qTechLevel	Long Integer
qTechID	Text(16)
qRequested	Date/Time
qPayStatus	Integer

WorkOrderCraftRates

Field	Type	Description
qWOBillGrp	Text(10)	Primary key. Work Order Billing Group Number This field is required.
qCraftCode	Text(10)	Primary key. Craft Code This field is required.
qSTRate	Currency	Straight Time Rate Defaults to 0.
qOT1Rate	Currency	Overtime 1 Rate Defaults to 0.
qOT2Rate	Currency	Overtime 2 Rate Defaults to 0.
qOT3Rate	Currency	Overtime 3 Rate Defaults to 0.
qUpdateBy	Text(8)	User Identification
qLastUpdate	Date/Time	Date of Last Update

WorkOrderEQDtl

Field	Type	Description
qWorkOrderNo	Text(10)	Primary key. This field is required.
qEquipmentID	Text(16)	Primary key. This field is required.
qEquipDesc	Text(50)
qEquipUnit	Text(6)
qEquipQty	Double
qEquipPrice	Currency
qEquipMarkup	Currency
qUpdateBy	Text(8)
qLastUpdate	Date/Time

WorkOrderPODtl

Field	Type	Description
qWorkOrderNo	Text(10)	Primary key. This field is required.
qPONo	Text(10)	Primary key. This field is required.
qPODesc	Text(72)
qPOAmt	Currency
qPOMarkup	Currency
qUpdateBy	Text(8)
qLastUpdate	Date/Time

WorkOrderPRDtl

Field	Type	Description
qWorkOrderNo	Text(10)	Primary key. This field is required.
qWOPRSeq	Integer	Primary key. This field is required.
qYrMoWkRun	Text(10)
qEmpID	Text(8)
qCraftCode	Text(10)
qHrsST	Single
qHrsOT1	Single
qHrsOT2	Single
qHrsOT3	Single
qPRCost	Currency
qPRMarkup	Currency
qUpdateBy	Text(8)
qLastUpdate	Date/Time
qAddComp	Text(16)

WorkOrderTask

Field	Type	Description
qWorkOrderNo	Text(10)	Primary key. This field is required.
qItemSeq	Integer	Primary key. This field is required.
qTaskID	Text(16)
qTaskExploded	Yes/No	This field is required.
qActualHours	Double
qUpdateBy	Text(8)
qLastUpdate	Date/Time