Records the details of order lines for purchase invoices. Line charges for freight, duty and insurance are also stored in this table together with foreign exchange details where appropriate. Table RE_Main is updated when purchase invoices based on receiving slips are activated.
Purchase Orders Purchase Invoices
Name |
Type |
Linked To/Supplied & Supplied Values |
PI_LinesID |
Text (20) |
|
PI_MainID |
Text (20) |
PI_Main.PI_MainID |
RE_MainID |
Text (20) |
RE_Main.RE_MainID |
RE_LinesID |
Text (20) |
RE_Lines.OrdersPSLinesID |
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 (200) |
|
SuppPartNo |
Text (50) |
|
LineType |
Number (Integer) |
1 = Normal;2 = Non stock |
DecimalPlaces |
Number (Integer) |
|
LastSavedDateTime |
Date/Time |
|
InvoiceLineNo |
Number (Integer) |
|
Insurance |
Number (Float) |
|
IncTax |
Number (Integer) |
|
ExPrice |
Number (Float) |
|
TaxRate |
Number (Float) |
|
TaxID |
Text (20) |
TX_Main.TaxID |
TaxAmount |
Number (Float) |
|
IncPrice |
Number (Float) |
|
HomeSuppliersCost |
Number (Float) |
|
CurrencyRateUsed |
Number (Float) |
|
POClassID |
Text (20) |
PO_Classification.POClassificationID |
UsesStdCost |
Yes/No |
|
StandardPSHomeCost |
Number (Float) |
|
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) |
|
QuantityOnHand |
Float |
|
LineTotal |
decimal(19,6) |
|
Copyright © 2012 Jiwa Financials. All rights reserved.