|
  
|
||
|
|
||
The Job Budgets table contains the budgets defined for Analysis Codes, Stock, Time-Rates and Totals for the Jobs setup within the Job Costing module of Exchequer.
Relational Links
The Job Budgets can be relationally linked to their Jobs through the IdxJobCode field, to Analysis Codes through the IdxAnalCode field, and to Stock through the IdxStockCode field.
Field Name |
Description |
Type |
Length |
jbRecType |
|
String |
1 |
jbIdxRecSub |
|
String |
2 |
jbSubType |
|
String |
1 |
jbIdxBudget |
|
String |
27 |
jbIdxCode |
|
String |
21 |
IdxAnalCode |
Analysis Code |
String |
10 |
jbHistFolio |
Job Budget Folio No |
Integer |
4 |
IdxJobCode |
Job Code |
String |
10 |
IdxStockCode |
Stock Code |
String |
20 |
jbType |
Budget Type |
Integer |
1 |
jbChargeOn |
Recharge (Y/N)? |
Logical |
1 |
jbOverCost |
|
Float |
8 |
jbUnitPrice |
Unit Price |
Float |
8 |
jbOrigQty |
Original Hours/Quantity |
Float |
8 |
jbRevQty |
Revised Hours/Quantity |
Float |
8 |
jbOrigValue |
Original Budget |
Float |
8 |
jbRevValue |
Revised Budget |
Float |
8 |
jbBudgetCur |
Budget Currency |
Integer |
1 |
jbPayRateMode |
Is Pay Rate? |
Logical |
1 |
jbPayRateCur |
Pay Rate Currency |
Integer |
1 |
jbAnalType |
Analysis Type |
Integer |
1 |
jbOriginalValuation |
Original Valuation |
Float |
8 |
jbRevisedValuation |
Revised Valuation |
Float |
8 |
jbUplift |
Uplift Percent Override |
Float |
8 |
jbApplyPercent |
Budget % to be applied for |
Float |
8 |
jbApplicationBasis |
Basis of Valuation |
Integer |
1 |
jbSpare |
Future Use |
String |
66 |
