J2001HST

Field	Type	Description
ID	AutoNumber	Primary key. This field is required.
JOBID	Text(255)
JOBNO	Double
JOBEXT	Double
DPNO	Double
JOBSTAT	Double
JOBTYPE	Double
CALLBACK	Yes/No	This field is required.
CANCELLED	Yes/No	This field is required.
CALLDATE	Date/Time
CALLTIME	Text(255)
REQUESTBY	Text(255)
PRIORITY	Double
JOBPHONE1	Text(255)
JOBNAME	Text(255)
JOBSTREET1	Text(255)
JOBSTREET2	Text(255)
JOBCITY	Text(255)
JOBSTATE	Text(255)
JOBZIP	Text(255)
MAPCODE	Text(255)
CROSS_ST	Text(255)
JOBDESC	Text(255)
SCHDATE	Date/Time
SCHHOURS	Double
SCHMINUTES	Double
SCHAMPM	Text(255)
TRUCKNO	Text(255)
ISSUEDATE	Date/Time
COMPDATE	Date/Time
ARRIVD_HRS	Double
ARRIVD_MIN	Double
ARRIVD_AMP	Text(255)
LEFT_HRS	Double
LEFT_MIN	Double
LEFT_AMPM	Text(255)
WORKDONE	Text(255)
MATERIAL	Text(255)
REQDATE	Date/Time
REQTIME	Text(255)
REQAMPM	Text(255)
REQPRIOR	Text(255)
PAYTYPE	Text(255)
REISSUE	Yes/No	This field is required.
TAKENBY	Text(255)
JOBNOTES	Text(255)
JOBCODES	Text(255)
BACKJOB	Text(255)
JOBCOMPANY	Text(255)
COMPBY	Text(255)
BILLNAME	Text(255)
DRIVERNO	Text(255)
ESTMH	Double
MAIL	Yes/No	This field is required.
LINKID	Text(255)
FOLLOWUP	Text(255)
SURVEY	Text(255)
MATLUSED	Text(255)
HELPERS	Text(255)
REQTECH	Text(255)
REFERRAL	Text(255)
ISSTIME	Text(255)
CONTACT	Text(255)
BILL_ADD_1	Text(255)
BILL_ADD_2	Text(255)
BILL_CITY	Text(255)
BILL_STATE	Text(255)
BILL_ZIP	Text(255)
BILL_PHONE	Text(255)
BILL_FAX	Text(255)
BILL_ATTN	Text(255)
J_UNIQUE	Text(255)
AMOUNT	Double
ESTID	Text(255)
PAYER_ID	Text(255)
SUBCONT	Yes/No	This field is required.
ARRIVED	Text(255)
LEFT	Text(255)
INVID	Text(255)

JOB

Field	Type	Description
ID	AutoNumber	Primary key. This field is required.
JOBID	Text(255)
JOBNO	Double
DPNO	Double
JOBEXT	Double
JOBSTAT	Double
JOBTYPE	Double
CALLBACK	Yes/No	This field is required.
CANCELLED	Yes/No	This field is required.
CALLDATE	Date/Time
CALLTIME	Text(255)
REQUESTBY	Text(255)
PRIORITY	Double
JOBPHONE1	Text(255)
JOBNAME	Text(255)
JOBSTREET1	Text(255)
JOBSTREET2	Text(255)
JOBCITY	Text(255)
JOBSTATE	Text(255)
JOBZIP	Text(255)
MAPCODE	Text(255)
CROSS_ST	Text(255)
JOBDESC	Text(255)
SCHDATE	Date/Time
SCHHOURS	Double
SCHMINUTES	Double
SCHAMPM	Text(255)
TRUCKNO	Text(255)
ISSUEDATE	Date/Time
REQDATE	Date/Time
REQTIME	Text(255)
REQAMPM	Text(255)
REQPRIOR	Text(255)
PAYTYPE	Text(255)
REISSUE	Yes/No	This field is required.
TAKENBY	Text(255)
JOBNOTES	Text(255)
JOBCODES	Text(255)
BACKJOB	Text(255)
JOBCOMPANY	Text(255)
BILLNAME	Text(255)
DRIVERNO	Text(255)
ESTMH	Double
MAIL	Yes/No	This field is required.
LINKID	Text(255)
BOOKTIME	Text(255)
REQTECH	Text(255)
SURVEY	Text(255)
REFERRAL	Text(255)
ISSTIME	Text(255)
CONTACT	Text(255)
BILL_ADD_1	Text(255)
BILL_ADD_2	Text(255)
BILL_CITY	Text(255)
BILL_STATE	Text(255)
BILL_ZIP	Text(255)
BILL_PHONE	Text(255)
BILL_FAX	Text(255)
BILL_ATTN	Text(255)
J_UNIQUE	Text(255)
ARRIVED	Text(255)
LEFT	Text(255)
COMP_STAT	Double
AMOUNT	Double
ESTID	Text(255)
PAYER_ID	Text(255)
HELPERS	Text(255)
SUBCONT	Yes/No	This field is required.
INVID	Text(255)