Appendix A

The following screen codes, field numbers, entry locations and posted field numbers are useful when setting up macros and spreadsheets. Field numbers are used in macros with Ctrl+R. Entry Location may be used with Ctrl+G. Use the Posted Field # followed by an exclamation point (!) for importing data into a Spreadsheet.

Notice: These numbers may be changed when the program is modified or updated. You can check the field # and entry location of most fields by placing the cursor on the field and pressing Ctrl+G.

COMPANY SETUP SCREEN (#)

Field #	Field Name	Posted Field #
1	Company Name
2	Attention Line
3	Street Address
4	Zip Code
5	Zip Extension
72	EIN #
7	Phone Number
87	Automatic Deposit Posting
84	Bank Deposit Number
165	Logo File Name
168	Signature File Name
21	Ledger 3 Account #
20	Ledger 3 Account Name
24	Ledger 4 Account #
23	Ledger 4 Account Name
27	Ledger 5 Account #
26	Ledger 5 Account Name
30	Ledger 6 Account #
29	Ledger 6 Account Name
33	Ledger 7 Account #
32	Ledger 7 Account Name
8	System Date
9	Year End Month Number
157	G/L Lock Date
180	A/P Lock Date
181	A/R Lock Date
28	Company Number (0-9)
95	Department Start #
35	Department Multiplier
47	Maximum Proposal #
94	Multiple Location Parameters
141	Vendor Code Generator-Individual
142	Vendor Code Generator-Company
143	Customer Code Generator-Individual
144	Customer Code Generator-Company
145	Name Code Generator-Individual
146	Name Code Generator-Company
147	Employee Code Generator
10	A/Receivable Acct #
65	A/R Discount Acct. #
132	Prepay Account #
160	Credit Card Deposit Acct. #
11	A/Payable Acct #
34	Floor Plan Account #
136	Shipping Tickets
12	Payroll Cash Acct #
92	Payroll & A/P Ledger #
16	Retained Earnings Acct #
13	Inventory Start Acct #
14	Inventory End Acct #
15	Inventory Reversal Acct #
17	Sales Start Acct #
18	Purchase Start Acct #
19	Purchase End Acct #
158	Tax on Order
54	Stock Error Message
139	Stock Icons on Work Orders
89	Point of Sale Invoice Report Number
75	A/R Invoices Report #
135	Number of Copies of Invoice
64	Number of Customer Messages
68	Omit Company Heading
63	Accounts Receivable Invoice Message
162	Automatically Add Inventory Items
49	Low Balance Limit
50	High Balance Limit
85	Create Quote Record
62	Automatic or Optional Back Orders
41	Monthly Interest Rate
42	Minimum Charge
43	Days Till Charge
39	Free Days
44	G/L Account Number
45	Compound Interest
46	Last Finance Charge Date
40	Finance Charge Information Message
36	Customer Type
37	Inventory Markup
66	Default Sales Account Number
93	Special Deposit Account Number
57	Overtime Base
58	Overtime Factor
76	Labor Sales Account Number
77	Material Sales Account Number
78	Subcontract Sales Account Number
79	A/P Material Markup %
80	A/P Subcontract Markup %
82	Job Class for Billing
55	Price Update Code
81	List Price Multiplier
83	Price Purchase Orders
152	Omit Purchase Order Heading
162	Automatically Add Inventory Items
51	Default Ledger Number
52	Discount Account Number
53	Suspense Account Number
134	Prepayment Account Number
67	Default Purchase Account Number
56	Accounts Payable General Ledger Adder
73	Subcontract Purchase Account Number
74	Subcontract Adder
169	Check Format
163	Printer Selections

ASSEMBLIES SCREEN (A)

Field #	Field Name	Posted Field #
0	Assembly Code
1	Labor Hours # 1
2	Labor Hours # 2
3	Labor Hours # 3
4	Labor Cost
5	Subcontract
6	Material Quantity
7	Material Cost
8	Sell Price
Repeating Fields
_	Item Code/Description
_	Quantity
_	Remark

BILLS SCREEN (B)

Field #	Field Name	Posted Field #
0	Bill Entry #
1	Vendor #
11	Purchase Order #
10	Purchase Order Date
16	Ship To Code
8	Job #
13	Invoice Amount
4	Terms
9	Pay Code (Y,N,S,F)
14	Material, Direct, Subcontract
17	Time and Material Contract
18	A/R Invoice #
3	Invoice Number
2	Invoice Date
5	Due Date
7	Discount Amount
6	Discount Date
12	Receive #
19	Date Received
15	Control Date
1017	Last Payment Ledger # & Check #
1075	Last Payment Date
1055	Amount Paid
1056	Amount to Distribute
Repeating Fields
	Item #/Remark
	G/L Account #
	Job Class
	Price Update Code (UC)
	Purchase Order #
	# Per Case
	Quantity
	List Price
	Cost
	Amount
	Freight & Other Adjustments

CUSTOMERS SCREEN (C)

Field #	Field Name	Posted Field #
0	Customer Code
1	Customer Name
2	Attention Line
3	Street Address
4	Zip Code
5	Zip Extension
101	City
102	State
7	Telephone #
34	Fax #
27	Modem #
6	E-mail Address
24	Contact Person
15	Terms
9	Credit Limit
8	Print Code
11	Tax Status
31	Customer Tax Exemption #
12	Discount Level
14	Ship Via
10	Late Charge
25	Review Date
20	Message 1
21	Message 2
22	Message 3
23	Message 4
44	New Code
36	Old Code
18	Ship-To Address
33	Zone
35	Ship R or C
16	Salesperson
32	Commission %
17	Advertiser
19	Customer Type
30	Purchase Order Required
Posted Fields
	Post Date	0
	MTD Sales	1
	Prior Sales	2
	MTD Pay	3
	Prior Balance	4
	MTD Balance	5
	MTD Cost	6
	Prior Cost	7
	Non Invoice Amount	13
	Sales 1 Year Ago	14
	Sales 2 Years Ago	15
	Special Deposit Amount	20
	Order Deposit Amount	37

DEPOSIT SCREEN (D)

Field #	Field Name	Posted Field #

0	Reference #
2	Date
1	Customer Code (#)
1012	Payment Type
1013	Check #
1014	Deposit Total
5	Check Amount
8	Apply to
9	G/L Amount
Repeating Fields
_	Payment Applied
_	Discount Applied
Posted Fields
_	Invoice #	10
_	Invoice Date	11
_	Invoice Amount	12
_	(previous) Payment	13
_	Discount Amount	14
_	Amount Not Applied	6
_	Total Discount	7
_	Discount Date	15
_	(discount) Earned	18
_	Balance	19

EMPLOYEE SCREEN (E)

Field #	Field Name	Posted Field #
0	Employee Code
1	Name
2	Attention
3	Address
4	Zip Code
91	City
92	State
5	Zip Extension
6	Phone #
7	Workman Compensation #
62	Classification
8	Social Security #
9	Status M/S, P
11	Federal # of Dependents
66	Other # of Dependents
10	Pay Period
67	Time Clock #
79	Next Time Card
13	Birth Date
14	Hire Date
15	Termination Date
16	Review Date
17	(last) Raise Date
78	Pay Date
19	Federal Tax Exempt
18	Federal W/holding Extra Amount
22	State Tax Exempt
20	State Tax Code
21	State W/holding Extra Amount
25	Other State Tax Exempt
23	Other State Tax Code
24	Other State W/holding Extra Am
28	Local Tax Exempt
26	Local Tax Code
27	Local Tax W/holding Extra Am
31	Medicare Tax Exempt
29	Medicare Tax Code
30	Medicare W/holding Extra Am
34	Other Tax Exempt
32	Other Tax Code
33	Other Tax W/holding Extra Am
56	Privilege Tax Code
57	Other One Time Tax Deduction
58	FICA Tax Exempt
59	FUTA Tax Exempt
60	SUI Exempt
61	Insurance Amount
65	Pension Amount
35	16 Deduction/Advance Code
36	16 Paycheck Deduction/Advance
37	16 Total Amount Ded/Adv
38	17 Deduction/Advance Code
39	17 Paycheck Deduction/Advance
40	17 Total Amount Ded/Adv
41	18 Deduction/Advance Code
42	18 Paycheck Deduction/Advance
43	18 Total Amount Ded/Adv
44	19 Deduction/Advance Code
45	19 Paycheck Deduction/Advance
46	19 Total Amount Ded/Adv
47	20 Deduction/Advance Code
48	20 Paycheck Deduction/Advance
49	20 Total Amount Ded/Adv
50	21 Deduction/Advance Code
51	21 Paycheck Deduction/Advance
52	21 Total Amount Ded/Adv
53	22 Deduction/Advance Code
54	22 Paycheck Deduction/Advance
55	22 Total Amount Ded/Adv
Repeating Fields
_	Category Code
_	Rate/Wage/Deduction Amount
_	Labor Type
Posted Fields
	Post Date	0
	Regular Wages	1
	Overtime Wage	2
	Vacation Wage	3
	Holiday Wage	4
	# 1 Other Wage	5
	# 2 Other Wage	6
	# 3 Other Wage	7
	# 4 Other Wage	8
	Federal Withholding Tax	9
	FICA Withholding Tax	10
	State Withholding Tax	11
	Other State Withholding Tax	12
	Local Withholding Tax	13
	Medicare Withholding Tax	14
	Other Withholding Tax	15
	Deduction #1	16
	Deduction #2	17
	Deduction #3	18
	Deduction #4	19
	Deduction #5	20
	Deduction #6	21
	Deduction #7	22
	Tips	23
	Insurance	24
	Temporary Deduction	25
	Regular Hours	26
	Overtime Hours	27
	Vacation Hours	28
	Holiday Hours	29
	#1 Other Hours	30
	#2 Other Hours	31
	#3 Other Hours	32
	#4 Other Hours	33
	Federal Wage	34
	FICA Wage	35
	State Wage	36
	Other State Wage	37
	Local Wage	38
	Medicare Wage	39
	Other Withholding Wage	40
	Net Pay	41
	Prior YTDs	42
	Privilege Deduction Date	92
	Privilege Deduction Amount	93
	One Time Deduction Date	94
	One Time Deduction Amount	95
	Vacation Hours Due	96
	Sick Hours Due	97
	Holiday Hours Due	98

GENERAL LEDGER ACCOUNTS SCREEN (G)

Field #	Field Name	Posted Field #
0	Account #
1	Name
2	Statement 1
8	Statement 2
9	Statement 3
4	1099 Field
3	Remark Y/N
5	Type M/S/A
7	Note
6	Alternate G/L #
1077	Next Period End Date
597	# of Periods per Year

INVENTORY SCREEN (I)

Field #	Field Name	Posted Field #
0	Item #
1	Description
21	Additional Description
39	Buy Description
23	Purchase Order Message
22	Remark
4	Unit
10	Vendor
12	Maximum
13	Minimum
35	Comment
44	New #
20	Update Code
6	List Price
8	Cost
27	Freight and Adjustments
7	List Date Change
21	Additional Description
9	Cost Date Change
11	Print Code
5	Multiplier %
45	Weight
26	MSR (Manu. Suggested Retail)
48	Discount—Special
14	Discount A
15	Discount B
16	Discount C
17	Discount D
40	Item # and Vendor 1
41	Item # and Vendor 2
42	Item # and Vendor 3
34	Commission Code
18	Group Code
3	Tax Code
19	Location Code
38	Stock
2	Sale G/L #
49	Lead Time
30	Quantity Per Label
29	Restriction Code
31	Core/Deposit
32	Activity Location
33	Code
28	Buy Quantity/Case
24	Labor Category
25	Job Class
46	Track Serial #
Posted Fields
_	Stock Quantity	18
_	Customer Order	19
_	Shipped	28
_	Vendor Order	20
_	Stock Order	25
_	Received	31
_	On Job	11
_	Post Date	0
_	Order Date	1
_	Month-to-date Buy Amount	6
_	MTD Sell Amount	3
_	MTD Sell Cost	5
_	MTD Buy Quantity	12
_	MTD Sell Quantity	14
_	MTD Sample	21
_	1 Year Sell Quantity	16
_	1 Year Sample	23
_	Prior Buy Amount	7
_	Prior Sell Amount	4
_	Prior Buy Quantity	13
_	Prior Sell Quantity	15
_	Prior Sample (YTD)	22
_	2 Year Sell Quantity	17
_	2 Year Sample	24

CONTRACTOR'S JOB ENTRY SCREEN (J)

Field #	Field Name	Posted Field #
0	Job #
1	Job Name
2	Attention Line
3	Address
4	Zip Code
5	Zip Extension
7	Phone
6	Customer # (Code)
65	Terms
64	Purchase Orders
25	Inspection Date
24	Inspection Comments
31	Change Order #
32	Change Order Amount
33	Contract Amount
30	Estimated Hours
66	Fixture Date
38	Customer Type
40	Department
8	Salesman
35	Commission Percent
23	Bill Code
41	Overhead Code 1
42	Overhead Code 2
43	Overhead Code 3
44	Overhead Code 4
60	Labor Rate 1
61	Labor Rate 2
62	Labor Rate 3
46	Labor G/L Account #
47	Material G/L Account #
48	Subcontract G/L Account #
45	Fixed Overhead
63	Material Discount
21	Subcontractor's Discount
14	Overtime (OT)
36	Retain Percent
37	Tax Code
50	Advertiser
51	Quote #
53	Answered By
26	Building
27	Group
28	Work Class
29	Other # 1
54	Foreman
52	Date Quoted
9	Date Awarded
39	Date Started
74	Date Last Billed
10	Date Ended
55	Job Description 1
56	Job Description 2
57	Job Description 3
58	Job Description 4
59	Job Description 5
78	Date Completed 1^st Phase
79	Amount Billed 1st Phase
80	Billing Description 1^st Phase
81	Date Completed 2nd Phase
82	Amount Billed 2nd Phase
83	Billing Description 2nd Phase
84	Date Completed 3^rd Phase
85	Amount Billed 3rd Phase
86	Billing Description 3^rd Phase
87	Date Completed 4^th Phase
88	Amount Billed 4th Phase
89	Billing Description 4th Phase

TAX TABLES & WAGE CATEGORIES (K)

Field #	Field Name	Posted Field #
0	Code
1	Description
2	Stub description
3	G/L Account #
9	Non Tax/Remark
8	Labor Type
14	Burden—Percent of Wage
13	Burden—Amount Per Hour
5	Amount Tax/Deduction
4	Hours/Taxable Wage
7	Date and Amount
6	Hours Deduct
10	Calculate #
15	Dependent Deduction
12	State Tax Credit
Repeating Fields
_	Tax Rate Percent
_	Over Wage
_	Plus Amount Tax
Posted Fields
_	Hrs/Units/Wages—Current	1
_	Hrs/Units/Wages—1 Month Prior	2
_	Hrs/Units/Wages—2 Months Prior	3
_	Hrs/Units/Wages—3 Months Prior	4
_	Hrs/Units/Wages—Year-to-date	5
_	Wage/Tax Amount—Current	6
_	Wage/Tax Amount—1 Month Prior	7
_	Wage/Tax Amount—2 Months Prior	8
_	Wage/Tax Amount—3 Months Prior	9
_	Wage/Tax Amount—Year-to-date	10

LEDGERS SCREEN (L)

Field #	Field Name	Posted Field #
1012	Check #
2	Date
4	Vendor Code
5	Amount
Repeating Fields
_	Account #
_	Amount
_	Job # Remark
Posted Field
	Month Returned	0

MAKE WORKORDER SCREEN (M)

Field #	Field Name	Posted Field #
0	Workorder #
19	Delivery Date
28	Material Reference #
1	Customer Code
2	Slip #
7	Customer P/O #
23	Type
29	Operator
3	Salesman
8	Order #
5	Tax
10	Terms
6	Ship Via
21	Job #
18	Remark
17	Ship To
14	Due Date
15	Discount Date
16	Discount Amount
22	Interest Code
26	Bill Code
Repeating Fields
_	Item # and Description
_	Order Quantity
_	Ship Quantity
_	Unit
_	Cost
_	List Price
_	Sell Price
_	Tax
_	G/L #
Posted Fields
_	Pay Amount	2
_	Pay Date	0
_	Discount Earned	1

NAME SCREEN (N)

Field #	Field Name	Posted Field #
0	Code
1	Name
2	Attention Line
3	Address
4	Zip Code
5	Zip Extension
7	Telephone #
24	FAX #
8	Print Code
35	Ship R/C
6	E-mail

PURCHASE ORDER ENTRY SCREEN (O)

Field #	Field Name	Posted Field #
0	Purchase Order Entry #
10	Date
25	Stock Order
1	Vendor # (Code)
31	Customer #
36	Special Instructions
37	Special Instructions Line 2
38	Special Instructions Line 3
39	Special Instructions Line 4
32	Requester
33	Ship Via
34	FOB
22	Ship Date
1014	Ship To (Screen Entry)
1016	Ship To (Code)
8	Job # (Code)
Repeating Fields
_	Our Item #
_	Your Item #
_	Description
_	Message
_	Quantity
_	Price
_	Unit
_	Amount
_	Price Update Code
_	# of Labels
_	Ship Date
_	Class
_	# Per Case
_	G/L #
Posted Fields
_	Billed Amount	2

PAYCHECK ENTRY SCREEN (P)

Field #	Field Name	Posted Field #
0	Check #
1	Period End Date
2	Pay Date
4	Employee Code
Repeating Fields
_	Category
_	Hrs/Taxable Wage
_	Rate
_	Amount/Tax, Deductions
_	Employee Name
_	Net Amount
_	Regular Hours
_	Regular Hours Amount
_	Overtime Hours
_	Overtime Hours Amount
_	Vacation Hours
_	Vacation Hours Amount
_	Sick Pay Hours
_	Sick Pay Hours Amount
_	# 1 Other Hours
_	# 1 Other Hours Amount
_	# 2 Other Hours
_	# 2 Other Hours Amount
_	Bonus/Commission Hours
_	Bonus/Commission Hours Amount
_	Federal W/holding Wage
_	Federal W/holding Amount/Tax
_	FICA Wage
_	FICA Amount/Tax
_	Deduction 16
_	Amount Deduction 16
_	Deduction 17
_	Amount Deduction 17
_	Deduction 18
_	Amount Deduction 18
_	Deduction 19
_	Amount Deduction 19
_	Deduction 20
_	Amount Deduction 20
_	Deduction 21
_	Amount Deduction 21
_	Tip/Insurance 22
_	Amount Tip/Insurance 22
_	Other Deduction
_	Description

QUOTE SCREEN (Q)

Field #	Field Name	Posted Field #
1008	Customer Code
1006	Product (Code)
1	Starting Date
2	Ending Date
3	Quoted Quantity
7	Taxable
5	Date Discount
6	Discount Level
13	Customer Unit
8	Outside Date Discount
12	Note
Posted Fields
_	Post Date	0
_	Qty Ordered Current Month	4
_	Qty Ordered Prior Month	5
_	Qty Ordered YTD	6
_	Qty Sold Current Month	1
_	Qty Sold Prior Month	2
_	Qty Sold YTD	3
_	Amount Sold Current Month	7
_	Amount Sold Prior Month	8
_	Amount Sold YTD	9
_	Cost Current Month	10
_	Cost Prior Month	11
_	Cost Prior YTD	12
_	Total Quantity Sold	18

SALES – INVOICES SCREEN (R)

Field #	Field Name	Posted Field #
0	Invoice #
19	Delivery Date
28	Material Reference #
1	Customer Code
2	Slip #
7	Customer P/O #
23	Type
29	Operator
3	Salesman
8	Order #
5	Tax
10	Terms
6	Ship Via
21	Job #
18	Remark
17	Ship-To
14	Due Date
15	Discount Date
16	Discount Amount
22	Interest Code
26	Bill Code
Repeating Fields
_	Item # and Description
_	Order Quantity
_	Ship Quantity
_	Unit
_	Cost
_	List Price
_	Sell Price
_	Tax
_	G/L #
Posted Fields
_	Pay Amount	2
_	Pay Date	0
_	Discount Earned	1

SALES PEOPLE SCREEN (S)

Field #	Field Name	Posted Field #
0	Salesman Code
1	Salesman Name
2	Default Commission Code
5	Commission Code A
6	Commission Code B
7	Commission Code C
8	Commission Code D
9	Commission Code E
10	Commission Code F
11	Commission Code G
12	Commission Code H
13	Commission Code I
14	Commission Code J
15	Commission Code K
16	Commission Code L
Posted Fields
_	Post Date	0
_	Sales MTD	1
_	Sales Prior Month	2
_	Sales Prior YTD	3
_	Cost MTD	4
_	Cost Prior Month	5
_	Cost Prior YTD	6

TIME CARD ENTRY SCREEN (T)

Field #	Field Name	Posted Field #
0	Reference #
2	Employee Code
1	Period End Date
3	Total Hours
4	Benefit Hours
5	Overtime Hours
Repeating Fields
_	Item #
_	Job #
_	Total Hours
_	Overtime Hours
_	Rate
_	Burden
_	Class
_	Type

VENDOR SCREEN (V)

Field #	Field Name	Posted Field #
0	Code
1	Name
2	Attention Line
3	Address
4	Zip Code
5	Zip Extension
15	Purchaser Account #
33	Remit To
35	Ship To
8	Print Code
7	Phone #
29	FAX #
28	No1099,Inc,Sub
11	Federal EIN
12	FICA #
27	Delete P/O Y/N/C
19	P/O Instructions
20	P/O Instructions Line 2
30	Price P/O (Y/N)
21	P/O Addresses
32	Remark
24	Terms
25	Taxable/Exempt
23	Direct, Subcontract, Material
13	Salesperson
14	Salesperson Phone #
31	Salesperson FAX #
22	Auto Pay Y/N/P
10	G/L #s
6	E-mail
Posted Fields
_	Balance	23
_	Post Date	0
_	P/O Current	10
_	P/O Last Month	11
_	P/O Prior YTD	12
_	Shipping Tickets Current	13
_	Shipping Tickets Last Month	14
_	Shipping Tickets Prior YTD	15
_	Buy Current	1
_	Buy Last Month	2
_	Buy Prior YTD	3
_	Pay Current	4
_	Pay Last Month	5
_	Pay Prior YTD	6
_	Discount Current	7
_	Discount Last Month	8
_	Discount Prior YTD	9

WORD PROCESSOR SCREEN (W)

Field #	Field Name	Posted Field #
0	Code
_	Date Line
_	Text Lines

CUSTOMER TYPE SCREEN (Y)

Field #	Field Name	Posted Field #
0	Type
1	Description
2	Privilege Codes
3	G/L Adder
4	Sales Code
6	Default Terms
7	A/R Discount Account #
9	Prepayment Account #
10	Discount Level
11	Dealer Customer Code

ZIP CODE SCREEN (Z)

Field #	Field Name	Posted Field #
0	Zip Code
1	City
2	State
3	Country
4	Geographical Area
5	Section End