You are here: Reference Guide > Table Structures > Job Costing > JB_Budget

JB_BUDGET

Purpose

This tables stores the Budget details by job by cost centre and stage and can be used for comparison reporting.

Path

Job Costing Maintenance Budget tab

Name

Type

Linked To/Supplied By

RecID

Text

 

JobID

Text

JB_Main.JobID

CostCentreID

Text

JB_CostCentre.CostCentreID

StageID

Text

JB_Stages.StageID

PurchaseQty

Decimal

 

PurchaseCost

Decimal

 

PurchaseCharge

Decimal

 

PurchaseNote

Text

 

MaterialQty

Decimal

 

MaterialCost

Decimal

 

MaterialCharge

Decimal

 

MaterialNote

Text

 

LabourQty

Decimal

 

LabourCost

Decimal

 

LabourCharge

Decimal

 

LabourNote

Text

 

CashBookQty

Decimal

 

CashBookCost

Decimal

 

CashBookCharge

Decimal

 

CashBookNote

Text

 

ResourceQty

Decimal

 

ResourceCost

Decimal

 

ResourceCharge

Decimal

 

ResourceNote

Text

 

JournalQty

Decimal

 

JournalCost

Decimal

 

JournalCharge

Decimal

 

JournalNote

Text

 

MaterialCreditorQty

Decimal

 

MaterialCreditorCost

Decimal

 

MaterialCreditorCharge

Decimal

 

MaterialCreditorNote

Text

 

Copyright © 2012 Jiwa Financials. All rights reserved.