Stores the line details for receiving slips that detail goods and services received, including freight, duty and insurance costings.
Purchase Orders Receive Inventory
Name |
Type |
Linked To/Supplied & Supplied Values |
OrdersPSLinesID |
Text (20) |
|
PackSlipID |
Text (20) |
|
OrderID |
Text (20) |
PO_Main.OrderID |
OrderLineID |
Text (20) |
PO_Lines.OrderLineID |
Quantity |
Number (Float) |
|
HomeLandedCost |
Number (Float) |
|
SuppliersCost |
Number (Float) |
|
InventoryID |
Text (20) |
IN_Main.InventoryID |
Freight |
Number (Float) |
|
Duty |
Number (Float) |
|
PartNo |
Text (50) |
|
Description |
Text (255) |
|
SuppPartNo |
Text (50) |
|
LineType |
Number (Integer) |
1 = Normal;2 = Non stock |
DecimalPlaces |
Number (Integer) |
|
LastSavedDateTime |
Date/Time |
|
Insurance |
Number (Float) |
|
ClassificationID |
Text (20) |
IN_Classification.ClassificationID |
ClassDescription |
Text (50) |
|
TaxAmount |
Number (Float) |
|
TaxID |
Text (20) |
TX_Main.TaxID |
TaxRate |
Number (Float) |
|
TaxInc |
Number (Integer) |
|
JobCostID |
Text (20) |
|
JobConnectorID |
Text (20) |
|
HomeSuppliersCost |
Number (Float) |
|
CurrencyRateUsed |
Number (Float) |
|
POClassID |
Text (20) |
PO_Classification.POClassificationID |
UsesStdCost |
Yes/No |
|
StandardHomeCost |
Number (Float) |
|
FreightTaxID |
Text (20) |
|
FreightTaxRate |
Number (Float) |
|
FreightTaxAmount |
Number (Float) |
|
DutyTaxID |
Text (20) |
|
DutyTaxRate |
Number (Float) |
|
DutyTaxAmount |
Number (Float) |
|
InsuranceTaxID |
Text (20) |
|
InsuranceTaxRate |
Number (Float) |
|
InsuranceTaxAmount |
Number (Float) |
|
PostedtoWIP |
bit |
|
JobCharge |
decimal |
|
Copyright © 2012 Jiwa Financials. All rights reserved.