The table records the header details for purchase orders including header records for fax and EDI acknowledgment.
Purchase Orders Purchase Order
Name |
Type |
Linked To/Supplied & Supplied Values |
OrderID |
Text (20) |
|
LastSavedDateTime |
Date/Time |
|
CreditorID |
Text (20) |
CR_Main1.CreditorID |
OrderNo |
Text (15) |
|
OrderedDate |
Date/Time |
|
Header1 |
Text (255) |
|
Header2 |
Text (255) |
|
Header3 |
Text (255) |
|
Header4 |
Text (255) |
|
Header5 |
Text (255) |
|
ContactType |
Number (Integer) |
1= Normal;2 = Email/EFax;3 = EDI |
Status |
Number (Integer) |
0 = Not Sent;1 = Ready to Send;2 = Sent ;3 = Acknowledged by EDI;4 = Status update by EDI |
OrderType |
Number (Integer) |
0 = Normal;1 = Back to back |
OrderTypeInvID |
Text (20) |
|
OrderTypeInvDetails |
Text (100) |
|
IN_LogicalID |
Text (20) |
IN_Logical.IN_LogicalID |
OrderSupplierType |
Number (Integer) |
|
CentralWarehouseID |
Text (20) |
|
TaxTotal |
Number (Float) |
|
CurrencyID |
Text (20) |
FX_Currency.CurrencyID |
InTransitWarehouseID |
Char 20 |
|
Reference |
VarChar 50 |
|
Copyright © 2012 Jiwa Financials. All rights reserved.