This table records specific details about each line on a shipment
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.