AddonTable

Field	Type	Description
Counter	AutoNumber	Primary key. This field is required.
CatCounts	Long Integer	Defaults to 0.
Addon	Text(10)
Description	Text(100)
QTY	Text(255)
Service	Text(30)
PartCounts	Long Integer
PartNo	Text(12)

CategoryTable

Field	Type	Description
Description	Text(100)
Addon	Text(10)
CatCounts	AutoNumber	This field is required.

CompanyInfo

Field	Type	Description
Counts	AutoNumber	Primary key. This field is required.
MyCompany	Text(50)
SalesTax	Double	Defaults to 0.
CityTax	Double	Defaults to 0.
TOS	Currency	Defaults to 0.
LaborRate	Currency	Defaults to 0.
ProfitAvg	Double	Defaults to 0.
OverHeadRate	Currency	Defaults to 0.
TechCompMaterial	Double	Defaults to 0.
TechCompLabor	Double	Defaults to 0.
BonusRate	Double	Defaults to 0.
Title1	Text(50)
Title2	Text(50)
Title3	Text(50)
Title4	Text(50)
CompanyName	Text(75)
Street	Text(50)
Address2	Text(50)
City	Text(50)
State	Text(2)
Zip	Text(12)
Phone	Text(15)
Fax	Text(15)
TaxMAt	Yes/No	Tax on Material? Defaults to 0. This field is required.
TaxLabor	Yes/No	Tax on Labor? Defaults to 0. This field is required.
MatDiscount	Yes/No	Use Material Discounts? This field is required.
MatMark	Yes/No	Use Material mark Up This field is required.
Over100	Double	These are for cost+ calculations Defaults to 0.
50to100	Double	Defaults to 0.
Under50	Double	Defaults to 0.
Cols	Integer	Number of columns in printout Defaults to 2.
Col1Title	Text(18)
Col2Title	Text(18)
Col3Title	Text(18)
TC1	Yes/No	Use trip charge for column 1 This field is required.
TC2	Yes/No	Use trip charge for column 2 This field is required.
TC3	Yes/No	Use trip charge for column 3 This field is required.
TC4	Yes/No	Use trip charge for addons This field is required.
Premium1	Double	Overall Job premium percent column 1 Defaults to 0.
Premium2	Double	Overall Job premium percent column 2 Defaults to 0.
Premium3	Double	Overall Job premium percent column 3 Defaults to 0.
Premium4	Double	Overall Job premium percent column Addons Defaults to 0.
DPremium1	Currency	$ Premium column 1 Defaults to 0.
DPremium2	Currency	$ Premium column 2 Defaults to 0.
DPremium3	Currency	$ Premium column 3 Defaults to 0.
DPremium4	Currency	$ Premium Addons Defaults to 0.
LPremium1	Double	Labor premium percent column 1 Defaults to 0.
LPremium2	Double	Labor premium percent column 2 Defaults to 0.
LPremium3	Double	Labor premium percent column 3 Defaults to 0.
LPremium4	Double	Labor premium percent Addons Defaults to 0.
SalesText	Text(200)	Sales Text for Reports
ST1	Text(50)	Bullet Point #1.
ST2	Text(50)	Bullet Point #2
ST3	Text(50)	Bullet Point #3
ST4	Text(50)	Bullet Point #4
ST5	Text(50)	Bullet Point #5
ST6	Text(50)	Bullet Point #6
SBullet	Yes/No	Print bullet in sales text This field is required.
NoLines	Yes/No	No Lines on Preprinted Reports This field is required.
RepStyle	Integer	Choose Report Style Defaults to 1.
RepLay	Integer	Choose Report Layout Defaults to 1.
Bullet	Text(1)	Report Bullet Selector
Expires	Double	Report Expiration Date Defaults to 0.
AddonAdder	Text(2)	Addon printout letter like -A
Misc1	Text(50)
Misc2	Text(50)
misc3	Text(50)
miscnum1	Double	Defaults to 0.
miscnum2	Double	Defaults to 0.
miscnum3	Double	Defaults to 0.
CovTit	Text(50)	Cover Title
CovTit1	Text(50)	Cover Title1
CovTit2	Text(50)	Cover Title2
CovTit3	Text(50)	Cover Title3
CovTit4	Text(50)	Cover Title4
CovBullP	Yes/No	Print Bullet on Cover This field is required.
CovBull	Text(1)	Cover Bullet

FormatTable

Field	Type	Description
FieldNo	Long Integer	Defaults to 0.
Field	Text(50)
Fore	Text(50)
Back	Text(50)
Bold	Integer	Defaults to 0.
Italic	Yes/No	This field is required.
Underline	Yes/No	This field is required.
Alignment	Text(50)
Border	Text(50)
MyFont	Text(50)
Mysize	Text(50)

ImportSetupTable

Field	Type	Description
Counts	Integer	Defaults to 0.
Field	Text(20)
k	Yes/No	This field is required.
MyQueryText	Text(250)
MyImptext	Text(250)
MyQuery	Text(255)

PartCatsTable

Field	Type	Description
PartCatCounts	AutoNumber	This field is required.
Title	Text(60)

PartsOBPageTable

Field	Type	Description
Page	Integer
Code	Text(80)
CatCounts	Long Integer
PrintMe	Yes/No	This field is required.
Top	Text(50)
Bottom	Text(50)

PartsOSPageTable

Field	Type	Description
Page	Integer
Code	Text(80)
CatCounts	Long Integer
PrintMe	Yes/No	This field is required.
Top	Long Integer
Bottom	Long Integer

PartsPageTable

Field	Type	Description
Page	Integer	Defaults to 0.
Code	Text(80)
CatCounts	Long Integer	Defaults to 0.

PartsPageTableBlank

Field	Type	Description
Page	Integer	Defaults to 0.
Code	Text(80)
CatCounts	Long Integer	Defaults to 0.

PartsTBPageTable

Field	Type	Description
Page	Integer
Code	Text(80)
CatCounts	Long Integer
PrintMe	Yes/No	This field is required.
Top	Long Integer
Bottom	Long Integer

PartsTSPageTable

Field	Type	Description
Page	Integer
Code	Text(80)
CatCounts	Long Integer
PrintMe	Yes/No	This field is required.
Top	Long Integer
Bottom	Long Integer

RateTable

Field	Type	Description
Counts	AutoNumber	This field is required.
Skill	Text(50)
Rate	Currency	Defaults to 0.
Profit	Double	Defaults to 0.

RepLayTable

Field	Type	Description
CoNameB	Integer	Company Name Bold Defaults to 0.
CoNameI	Integer	Company Name Italic Defaults to 0.
CoNameU	Integer	Company Name Underline Defaults to 0.
CoNameFont	Text(50)	Company Name Font
CoNameSize	Double	Company Name Font Size Defaults to 0.
CoNameAlign	Integer	Company Name Alignment Defaults to 0.
CoNameFore	Double	Company Name Foreground Defaults to 0.
CoNameBack	Double	Company Name Background Defaults to 0.
CoNameBord	Double	Company Name Border Defaults to 0.
CoNameBS	Double	Company Name BorderStyle Defaults to 0.
TitleB	Integer	Bold Defaults to 0.
TitleI	Integer	Italic Defaults to 0.
TitleU	Integer	Underline Defaults to 0.
TitleFont	Text(50)	Font
TitleSize	Double	Font Size Defaults to 0.
TitleAlign	Integer	Alignment Defaults to 0.
TitleFore	Double	Foreground Defaults to 0.
TitleBack	Double	Background Defaults to 0.
TitleBord	Double	Border Width Defaults to 0.
TitleBS	Double	BorderStyle Defaults to 0.
Col1B	Integer	Bold Defaults to 0.
Col1I	Integer	Italic Defaults to 0.
Col1U	Integer	Underline Defaults to 0.
Col1Font	Text(50)	Font
Col1Size	Double	Font Size Defaults to 0.
Col1Align	Integer	Alignment Defaults to 0.
Col1Fore	Double	Foreground Defaults to 0.
Col1Back	Double	Background Defaults to 0.
Col1Bord	Double	Border Width Defaults to 0.
Col1BS	Double	BorderStyle Defaults to 0.
Col2B	Integer	Bold Defaults to 0.
Col2I	Integer	Italic Defaults to 0.
Col2U	Integer	Underline Defaults to 0.
Col2Font	Text(50)	Font
Col2Size	Double	Font Size Defaults to 0.
Col2Align	Integer	Alignment Defaults to 0.
Col2Fore	Double	Foreground Defaults to 0.
Col2Back	Double	Background Defaults to 0.
Col2Bord	Double	Border Width Defaults to 0.
Col2BS	Double	BorderStyle Defaults to 0.
Col3B	Integer	Bold Defaults to 0.
Col3I	Integer	Italic Defaults to 0.
Col3U	Integer	Underline Defaults to 0.
Col3Font	Text(50)	Font
Col3Size	Double	Font Size Defaults to 0.
Col3Align	Integer	Alignment Defaults to 0.
Col3Fore	Double	Foreground Defaults to 0.
Col3Back	Double	Background Defaults to 0.
Col3Bord	Double	Border Width Defaults to 0.
Col3BS	Double	BorderStyle Defaults to 0.
descB	Integer	Bold Defaults to 0.
descI	Integer	Italic Defaults to 0.
descU	Integer	Underline Defaults to 0.
descFont	Text(50)	Font
descSize	Double	Font Size Defaults to 0.
descAlign	Integer	Alignment Defaults to 0.
descFore	Double	Foreground Defaults to 0.
descBack	Double	Background Defaults to 0.
DescBord	Double	Border Width Defaults to 0.
DescBS	Double	BorderStyle Defaults to 0.
JobB	Integer	Bold Defaults to 0.
JobI	Integer	Italic Defaults to 0.
JobU	Integer	Underline Defaults to 0.
JobFont	Text(50)	Font
JobSize	Double	Font Size Defaults to 0.
JobAlign	Integer	Alignment Defaults to 0.
JobFore	Double	Foreground Defaults to 0.
JobBack	Double	Background Defaults to 0.
JobBord	Double	Border Width Defaults to 0.
JobBs	Double	BorderStyle Defaults to 0.

Storeme

Field	Type	Description
MyPart	Text(100)
ShowMe	Yes/No	Defaults to 0. This field is required.
MyTask	Text(100)

TableCnt

Field	Type	Description
Title	Text(255)
Code	Text(255)

TaskPartTable

Field	Type	Description
TaskCounts	Long Integer
PartCounts	Long Integer	Defaults to 0.
Part	Text(15)
Qty	Double
Choice	Text(15)

TaskTable

Field	Type	Description
HowTo	Memo
Counts	AutoNumber	Primary key. This field is required.
Task	Text(20)
Title	Text(50)
Description	Text(200)
Extras	Text(200)
HRS	Double	Defaults to 0. This field is required.
Skill	Text(30)	This field is required.
% Profit	Double	Defaults to 0.
Permit Cost	Currency	Defaults to 0. This field is required.
Misc	Currency	Defaults to 0. This field is required.
Commission	Currency	Defaults to 0. This field is required.
OCC	Currency	Defaults to 0. This field is required.
Category	Long Integer	Defaults to 0.
MatDisc	Yes/No	Defaults to -1. This field is required.
MyTot	Currency	Defaults to 0.
MyInstall	Currency	Defaults to 0.
MyProfit	Currency	Defaults to 0.
Addon	Yes/No	This field is required.
QB	Yes/No	This field is required.
PrintMe	Yes/No	Defaults to -1. This field is required.

Trade

Field	Type	Description
Counts	AutoNumber	Primary key. This field is required.
EDPNo	Text(15)
PartNo	Text(15)
Code	Text(12)
MFG	Text(50)
Vendor1	Double
Desc	Text(80)
List	Currency
Labor	Double
No	Text(15)
TypeCounts	Long Integer	Code identifier
CatCounts	Long Integer	Index Description identifier Defaults to 0.
VendorCounts	Long Integer	Vendor identifier Defaults to 0.
Cost	Currency	Defaults to 0.
QB	Yes/No	Defaults to -1. This field is required.
Inventory	Yes/No	This field is required.
Reorder	Long Integer	Defaults to 0.
Costcalc	Long Integer

Tradeb

Field	Type	Description
Counts	AutoNumber	Primary key. This field is required.
EDPNo	Text(15)
PartNo	Text(15)
Code	Text(12)
MFG	Text(50)
Vendor1	Double
Desc	Text(80)
List	Currency
Labor	Double
No	Text(15)
TypeCounts	Long Integer
CatCounts	Long Integer
VendorCounts	Long Integer
Cost	Currency
QB	Yes/No	This field is required.
Inventory	Yes/No	This field is required.
Reorder	Long Integer
Costcalc	Long Integer

TypeChoice

Field	Type	Description
Codes	Text(12)
Description	Text(50)
MFG	Text(50)
StandardDiscount	Double
TypeCounts	AutoNumber	Primary key. This field is required.
YourDiscount	Double	Defaults to 0.
Lists	Double	Defaults to 0.
Discount	Double	Defaults to 0.

Vendors

Field	Type	Description
VendorCounts	AutoNumber	Primary key. This field is required.
VendorName	Text(50)
Location	Text(50)
Contact	Text(50)
Phone	Text(15)