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

JB_CostEntryLines

Purpose    

This table records the line details of costs allocated to a job.

Path         

Job Costing Job Transactions Cost Entry

Name

Type

Linked To/Supplied

RecID

Text (20)

 

JobEntryID

Text (20)

JB_CostEntry.RecID

JobCode

Text (255)

 

JobID

Text (20)

JB_Main.JobID

CostCentreID

Text (20)

JB_CostCentre.CostCentreID

StageID

Text (20)

JB_Stage.StageID

Qty

Number (Float)

 

UnitCost

Number (Float)

 

UnitCharge

Number (Float)

 

MarkUp

Number (Float)

 

ComponentID

Text (20)

 

ComponentNo

Text (20)

 

ComponentDesc

Text (255)

 

ComponentType

Number (Integer)

 

InvoiceNo

Text (255)

 

TranType

Number (Integer)

 

TaxID

Text (20)

 

Status

Number (Integer)

 

LinkID

Text (20)

 

LastSavedDateTime

Date/Time

 

TranDate

Date/Time

 

InvoicedAmount

Number (Float)

 

Unit

Text (20)

 

Remark

Text (255)

 

ServiceNo

Text (20)

 

BackOrderQty

Number (Float)

 

QtyDelivered

Number (Float)

 

QtyDecimalPlaces

Number (Integer)

 

Copyright © 2012 Jiwa Financials. All rights reserved.