Purchase Order
Records the line details of purchase orders including stock already allocated for back orders. The table is updated with quantities delivered as receiving slips are saved.
Purchase Orders
Purchase Order
|
Name |
Type |
Linked To/Supplied & Supplied Values |
|
OrderLineID |
Text (20) |
|
|
OrderID |
Text (20) |
PO_Main.OrderID |
|
InventoryID |
Text (20) |
IN_Main.InventoryID |
|
Quantity |
Number (Float) |
|
|
Allocated |
Number (Float) |
|
|
HomeLandedCost |
Number (Float) |
|
|
SuppliersCost |
Number (Float) |
|
|
DeliveryDate |
Date/Time |
|
|
Delivered |
Number (Float) |
|
|
DecimalPlaces |
Number (Integer) |
|
|
OrderLineNo |
Number (Integer) |
|
|
SuppPartNo |
Text (50) |
|
|
LastSavedDateTime |
Date/Time |
|
|
HistoryText_Comment |
Text (255) |
|
|
stShipDate |
Date/Time |
|
|
stShipLocation |
Text (3) |
|
|
stQtyOrdered |
Number (Float) |
|
|
stQtyBackOrder |
Number (Float) |
|
|
stQtyDespatch |
Number (Float) |
|
|
stQtyShipped |
Number (Float) |
|
|
stQtyReleased |
Number (Float) |
|
|
stLCost |
Number (Float) |
|
|
stSCost |
Number (Float) |
|
|
OrderUnits |
Number (Float) |
|
|
LineType |
Number (Integer) |
1 = Normal ;2 = Non stock |
|
PartNo |
Text (50) |
|
|
Description |
Text (200) |
|
|
DeliveryDays |
Number (Integer) |
|
|
ClassificationID |
Text (20) |
IN_Classification.ClassificationID |
|
ClassDescription |
Text (50) |
|
|
IN_CentralWarehouseID |
Text (20) |
IN_Logical.IN_LogicalID |
|
IN_TransferID |
Text (20) |
IN_Transfer.TransferID |
|
TaxAmount |
Number (Float) |
|
|
TaxID |
Text (20) |
|
|
TaxRate |
Number (Float) |
|
|
TaxInc |
Number (Integer) |
TX_Main.TaxID |
|
JobCostID |
Text (20) |
|
|
JobConnectorID |
Text (20) |
|
|
HomeSuppliersCost |
Number (Float) |
|
|
CurrencyRateUsed |
Number (Float) |
|
|
POClassID |
Text (20) |
PO_Classification.POClassificationID |
|
IncPrice |
Number (Float) |
|
|
LineTotal |
Number (Float) |
|
|
Notes |
Memo |
|
|
FXDecimalPlaces |
Number (Integer) |
|
|
AUDDecimalPlaces |
Number (Integer) |
|
|
FXTotal |
Number (Float) |
|
|
InvSuppSourceID |
Text (20) |
|
|
SupplierID |
Text (20) |
|
|
SM_ServiceID |
Text (20) |
|
|
Unit |
Text (20) |
|
Copyright © 2012 Jiwa Financials. All rights reserved.