Field
Name: |
Type: |
Length: |
Index: |
Description: |
X_SEQ |
sequence |
|
x |
sequence # |
X_JOB_NUM |
char |
10 |
x |
job number |
X_TASK |
char |
4 |
x |
job task |
X_DESC |
char |
2000 |
|
description (appears on estimate/invoice) |
X_ESTIMATE |
number |
2dp |
|
FINAL estimate/forecasted amount |
X_BUDGET |
number |
2dp |
|
budget amount |
X_HOURS_EST |
number |
2dp |
|
estimated hours |
X_HOURS_ACT |
number |
2dp |
|
actual hours-to-date |
X_LABOR |
number |
2dp |
|
labor dollars @ cost rate |
X_COST |
number |
2dp |
|
total cost (AP, checks, time,
exp) dollars before markup |
X_EXPENSES |
number |
2dp |
|
out-of-pocket expenses before markup |
X_PO_NET |
number |
2dp |
|
net committed before markups |
X_PO_GROSS |
number |
2dp |
|
committed + markup |
X_UNBILLED |
number |
2dp |
|
unbilled job costs |
X_BILL_RATE |
number |
2dp |
|
this task's hourly rate |
X_MARKUP |
number |
2dp |
|
this task's markup |
X_STATUS |
number |
0dp |
|
task's current status |
X_NOTE |
char |
2000 |
|
status note or description |
X_TAXABLE1 |
short int |
(0 to 255) |
|
taxable 1 flag |
X_TAXABLE2 |
short int |
(0 to 255) |
|
taxable 2 flag |
X_FINISHED |
short int |
(0 to 255) |
|
finished? (yes/no) |
X_DUE_DATE |
short date |
1980..2079 |
x |
task due date |
X_START_DATE |
short date |
1980..2079 |
x |
task start date |
X_KIND |
short int |
(0
to 255) |
|
0=est, traffic/1=traffic only
2=est only/3=costing only/10=subtask |
X_RESOURCE |
char |
10 |
x |
who's responsible for this task? |
X_LEAD_TIME |
short num |
0dp |
|
lead time in days |
X_KEY |
char |
14 |
x |
key (job number + job task) |
X_SORT |
short num |
0dp |
|
sort number |
X_GROUP |
short num |
0dp |
|
group number |
X_CGL |
number |
2dp |
|
default income G/L # |
X_DGL |
number |
2dp |
|
default job cost G/L # |
X_LAST_WORK |
short date |
1980..2079 |
|
date of last work |
X_SHOW_DESC |
short int |
(0 to 255) |
|
show description on estimates, invoices |
X_PC |
short int |
(0 to 255) |
|
profit center |
X_NAME |
char |
50 |
|
task name (appears on estimates/invoices/reports) |
X_TAX1_RATE |
number |
2dp |
|
sales tax 1 rate |
X_TAX2_RATE |
number |
2dp |
|
sales tax 2 rate |
X_EST1 |
number |
2dp |
|
estimate amount 1 |
X_EST2 |
number |
2dp |
|
estimate amount 2 |
X_EST3 |
number |
2dp |
|
estimate amount 3 |
X_BILLED |
number |
2dp |
|
billed amount |
X_ROLL_UP |
char |
4 |
|
roll-up billing task (optional) |
X_CHANGE_AMT |
number |
2dp |
|
change order amount |
X_CHAR30 |
char |
30 |
|
|
X_CHAR20 |
char |
20 |
|
|
X_MEDIA_COMM |
number |
2dp |
|
media commission |
X_CHANGE_HRS |
number |
2dp |
|
|
X_CHANGE_BUDGET |
number |
2dp |
|
|
X_AMT4 |
number |
2dp |
|
|
X_KEY_RESOURCE |
char |
24 |
x |
|
X_GROUP_PROD |
char |
10 |
|
Group - for production/traffic |
X_CHAR10_2 |
char |
10 |
|
|
X_CHAR10_3 |
char |
10 |
|
|
X_SORT_PROD |
Number |
0 dp |
|
Sort - for production/traffic |
X_RATE_KIND |
Number |
0 dp |
|
rate table (0=staff/1=client/2=j ob task) |
X_SUB_EST_HRS |
Number |
2 dp |
|
subtask's estimated hours |
X_SUB_ACT_HRS |
Number |
2 dp |
|
subtask's actual hours |
X_NUM2D_5 |
Number |
2 dp |
|
|
X_NUM2D_6 |
Number |
2 dp |
|
|
X_NUM2D_7 |
Number |
2 dp |
|
|
X_HRS_UNBILLED |
Number |
2 dp |
|
unbilled hours-to-date |
X_UNBILLABLE |
Short int |
(0 to 255) |
|
always unbillable? |
X_GROSS_COSTS |
Number |
2 dp |
|
gross cost (cost x markup) |
X_GROSS_LABOR |
Number |
2 dp |
|
gross labor cost (hours x bill rate) |
X_GROSS_EXP |
Number |
2 dp |
|
gross out-of-pocket expenses |
X_MU_AMT |
Number |
2 dp |
|
dollar amount of markup/commission |
X_SPECS |
char |
2000 |
|
this task's special instructions |
X_DATE_FINISHED |
Short date |
1980..2079 |
x |
date finished |
X_DUE_WHEN |
Short time |
|
|
time due |
X_HOURS_BILLED |
Number |
2 dp |
|
hours billed on invoices |
X_EST_HRS1 |
Short num |
2 dp |
|
estimate hours 1 |
X_EST_HRS2 |
Short num |
2 dp |
|
estimate hours 2 |
X_EST_HRS3 |
Short num |
2 dp |
|
estimate hours 3 |