You are here: Reference Guide > Table Structures > Landed Cost > SH_Lines

SH_Lines

Purpose    

This table records specific details about each line on a shipment

Path         

Landed Cost  Shipments, Stock Lines tab

Name

Type

Linked To/Supplied

ShipmentLineID

Text (20)

 

ShipmentID

Text (20)

SH_Main.ShipmentID

PurchaseOrdersID

Text (20)

SH_PurchaseOrders.PurchaseOrdersID

PurchaseOrderLineID

Text (20)

 

InventoryID

Text (20)

 

PartNo

Text (50)

 

SupplierPartNo

Text (50)

 

QuantityOrdered

Number (Float)

 

QuantityThisShipment

Number (Float)

 

OrderedCost

Number (Float)

 

ShipUnitCostExGST

Number (Float)

 

ShipUnitCostIncGST

Number (Float)

 

FXShipUnitCostExGST

Number (Float)

 

AdjustedUnitCost

Number (Float)

 

GSTRate

Number (Float)

 

GSTAmount

Number (Float)

 

GSTID

Text (20)

 

UseSerialNo

Yes/No

0 = No; 1 = Yes

UseExpiry

Yes/No

0 = No; 1 = Yes

DecimalPlaces

Number (Integer)

 

POClassID

Text (20)

 

InvoicesID

Text (20)

 

DeliveryDays

Number (Integer)

 

Description

Text (50)

 

OrderUnits

Number (Float)

 

ClassificationID

Text (20)

 

JobCostID

Text (20)

 

FXRate

Number (Float)

 

Weight

Number (Float)

 

Volume

Number (Float)

 

LineTotalExGST

Number (Float)

 

FXLineTotalExGST

Number (Float)

 

LineTotalIncGST

Number (Float)

 

LandedCostTotal

Number (Float)

 

CurrencyID

Text (20)

 

CreditorID

Text (20)

 

VarianceAccumulator

Number (Float)

 

UserField1 to UserField10

Text (255)

 

FXOrderedCost

Number (Float)

 

PhysicalItem

Yes/No

0 = No; 1 = Yes

Copyright © 2012 Jiwa Financials. All rights reserved.