Job Maintenance
This table stores the header details of jobs, templates and estimates.
Job Costing
Job Maintenance
|
Name |
Type |
Linked To/Supplied |
|
JobID |
Text (20) |
|
|
JobNo |
Text (20) |
|
|
Description |
Text (50) |
|
|
JobGroup |
Text (50) |
|
|
DebtorID |
Text (20) |
DB_Main1.DebtorID |
|
OrderNo |
Text (50) |
|
|
StartDate |
Date/Time |
|
|
EndDate |
Date/Time |
|
|
EstEndDate |
Date/Time |
|
|
ClosedDate |
Date/Time |
|
|
InventoryCostType |
Number (Integer) |
|
|
InventorySellType |
Number (Integer) |
|
|
LastSavedDateTime |
Date/Time |
|
|
IsTemplete |
Yes/No |
0 = No; 1 = Yes |
|
ContractAmount |
Number (Float) |
|
|
MarkUpMaterials |
Number (Float) |
|
|
MarkUpLabour |
Number (Float) |
|
|
MarkUpSubContract |
Number (Float) |
|
|
MarkUpResource |
Number (Float) |
|
|
RetentionType |
Number (Integer) |
|
|
RetentionValue |
Number (Float) |
|
|
GstApplicable |
Yes/No |
|
|
Priority |
Text (50) |
|
|
EstimateType |
Number (Integer) |
|
|
ProductID |
Text (20) |
|
|
ProductDesc |
Text (200) |
|
|
ProductQty |
Number (Float) |
|
|
EstStartDate |
Date/Time |
|
|
ClassificationID |
Text (20) |
JB_Classification.ClassificationID |
|
StaffID |
Text (20) |
HR_Staff.StaffID |
|
Status |
SmallInt |
|
Copyright © 2012 Jiwa Financials. All rights reserved.