|
  
|
||
|
|
||
The Jobs table contains details of the Jobs and Contracts within the Exchequer Job Costing module.
Relational Links
The Jobs can be linked to the Customer Account using the IdxAcCode field, to Job Types with the jrJobType field, and to Departments and Cost Centres with the jrDepartment and jrCostCentre fields.
Key Field : IdxJobCode
Field Name |
Description |
Type |
Length |
IdxJobCode |
Job Code |
String |
10 |
jrDesc |
Job Name |
Lstring |
31 |
jrIdxDesc |
Job Name |
String |
30 |
jrFolio |
Job Folio Number |
Integer |
4 |
IdxAcCode |
Customer Account |
String |
6 |
jrParentJob |
Job Parent |
String |
10 |
jrAltCode |
Alternate Code |
String |
10 |
jrCompleted |
|
Integer |
4 |
jrContact |
Contact |
Lstring |
26 |
jrManager |
Job Manager |
Lstring |
26 |
jrChargeType 1 = Time & Materials 2 = Fixed Price 3 = Cost+% 4 = Non Productive |
Charge Type |
Integer |
2 |
jrQuotePrice |
Price Quoted |
Float |
8 |
jrCurrPrice |
Price Currency |
Integer |
1 |
jrStartDate |
Start Date |
Date |
8 |
jrEndDate |
Completion Date |
Date |
8 |
jrRevEndDate |
Revised Completion Date |
Date |
8 |
jrSORRef |
Job SOR Reference |
String |
10 |
jrVATCode |
VAT Code |
String |
1 |
jrDepartment |
Department |
String |
3 |
jrCostCentre |
Cost Centre |
String |
3 |
jrJobType |
Job Type |
String |
3 |
jrCategory |
Category: Job / Contract |
String |
1 |
jrStatus
1 = Quote 2 = Active 3 = Suspend 4 = Comp 5 = Closed |
Job Status |
Integer |
4 |
jrUser1 |
Job User Defined Field 1 |
Lstring |
21 |
jrUser2 |
Job User Defined Field 2 |
Lstring |
21 |
jrUser3 |
Job User Defined Field 3 |
Lstring |
21 |
jrUser4 |
Job User Defined Field 4 |
Lstring |
21 |
jrDefRetCurr |
Deferred Retention Currency |
Integer |
1 |
jrJPTOurRef |
Purchase Terms Reference No |
Lstring |
11 |
jrJSTOurRef |
Sales Terms Reference No |
Lstring |
11 |
jrQSCode |
QS Code |
Lstring |
21 |
jrSpare |
Future Use |
String |
141 |
jrSpare2 |
Future Use |
String |
149 |
