You are here: Reference Guide > Table Structures > Service Manager > SM_JobParts

SM_JobParts

Purpose

Record Task part lines.

Path         

Service Manager Maintenance, Parts Tab    

Name

Type

Link To/Supplied

PartID

Text

 

JobID

Text

SM_Job.JobID

InventoryID

Text

IN_Main.InventoryID

PartNo

Text

 

Description

Text

 

CommentLine

Yes/No

 

Quantity

Decimal

 

ItemPrice

Currency

 

Tax

Currency

 

SerialNo

Text

 

ProcessToJiwa

Yes/No

 

ProcessType

Byte

 

ProcessID

Text

SM_Main.InvoiceNo

LastSavedDateTime

Date/Time

 

LastSavedUser

Text

SM_Staff.StaffID

QuoteRef

Text

 

DisplayOrder

Byte

 

Discount

Decimal

 

DiscountPercentage

Decimal

 

SellPriceIsIncTax

TinyInt

 

QuantityDecimalPlaces

SmallInt

 

Discountable

Tinyint

 

DefaultPrice

Decimal

 

MinimumGP

Decimal

 

LastCost

Decimal

 

KitLineType

Tinyint

 

TaxID

char20

 

TaxRate

decimal(19,6)

 

TaxDescription

Varchar50

 

 

Copyright © 2012 Jiwa Financials. All rights reserved.