You are here: Reference Guide > Table Structures > Purchase Order > PO_Main

PO_Main

Purpose    

The table records the header details for purchase orders including header records for fax and EDI acknowledgment.

Path         

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.