Home > Technical > Table Definitions > POHEADER

POHEADER

The header records for each of the purchase orders. The details are stored in PODETAIL.

Column Type Description

LINTPONUMBER

INT(4)

A unique number assigned by the system.

STRSUPPLIERCODE

VARCHAR(10)

The supplier from which the goods were received.

SUPPLIER.strSupplierCode

DTMDELIVERY

DATETIME(8)

The date the goods need to be delivered.

DTMREQUIREDBY

DATETIME(8)

The date the goods are required by.

STRWHO

VARCHAR(20)

The user who keyed in the receipt.

DTMWHEN

DATETIME(8)

The date the purchase order was created.

CURTOTALCOST

DECIMAL(9)19,4

The total cost of the purchase order (sum of PODETAIL.curCost).

CURTOTALUNITS

DECIMAL(9)19,4

The total units ordered (sum of PODETAIL.dblQuantity).

STRSTATUS

VARCHAR(10)

Status of purchase order.

STRTRADECODE

VARCHAR(10)

The location which received the goods.

TRADUNIT.strTradeCode

YSNNEW

VARCHAR(1)

‘T’ if a new purchase order.

YSNCHANGED

VARCHAR(1)

‘T’ if a changed purchase order.

DBLRECEIVEDUNITS

DECIMAL(9)19,4

The number of units received for this PO.

DBLRECEIVEDBONUSUNITS

DECIMAL(9)19,4

The number of bonus units received for this PO.

CURTOTALNETTCOST

DECIMAL(9)19,4

Not used.

CURTOTALSERVICEFEE

DECIMAL(9)19,4

Not used.

CURTOTALULLAGEFEE

DECIMAL(9)19,4

Not used.

CURTOTALSALESTAX

DECIMAL(9)19,4

Not used.

CURTOTALLIQUORTAX

DECIMAL(9)19,4

Not used.

CURTOTALFREIGHT

DECIMAL(9)19,4

Not used.

LINTMAINPONUM

INT(4)

Usually the same as lintPONumber. However, if several purchase orders are created together (from the allocation system for example), this number will be that of the first PO created in the set.

DTMSENT

DATETIME(8)

The date the purchase order was sent to the supplier.

DTMDELIVERYTO

DATETIME(8)

Used in conjunction with dtmDelivery to set the date range within which the goods can be received.

MEMCOMMENTS

NTEXT(16)

General comments about the purchase order.

MEMSPECINSTRUCT

TEXT(16)

Special instructions to the supplier.

STRREFERENCE

VARCHAR(30)

The customer's reference for this order.

LINTORDERCODE

INT(4)

The number of the transaction.

DAILYSALES.intSaleID

LINTCUSTOMERNUM

INT(4)

The customer for which this order is being placed.

CUSTOMER.lintCustomerNum

STRSHIPTOADDR1

VARCHAR(50)

The address the items are to be shipped to.

STRSHIPTOADDR2

VARCHAR(50)

 

STRSHIPTOCITY

VARCHAR(50)

 

STRSHIPTOSTATE

VARCHAR(20)

 

STRSHIPTOPOSTCODE

VARCHAR(15)

 

STRSHIPTOCOMMENT

VARCHAR(100)

A general comment about the ship to address, for example after 5:00pm

STRSHIPTONAME

VARCHAR(50)

 

STRSHIPTOPHONE

VARCHAR(20)

 

STRSHIPTOFAX

VARCHAR(20)

 

STRSUPPLIERQUOTE

VARCHAR(20)

The quote number given to us by the supplier for this order.

STRSUPPLIERPOREF

VARCHAR(20)

The supplier's reference for our purchase order.

STRBILLTOADDR1

VARCHAR(50)

The address the invoice is to be sent.

STRBILLTOADDR2

VARCHAR(50)

 

STRBILLTOCITY

VARCHAR(50)

 

STRBILLTOSTATE

VARCHAR(20)

 

STRBILLTOPOSTCODE

VARCHAR(15)

 

STRBILLTOCOMMENT

VARCHAR(100)

 

STRBILLTONAME

VARCHAR(50)

 

STRBILLTOPHONE

VARCHAR(20)

 

STRBILLTOFAX

VARCHAR(20)

 

DTMPAYMENTDUE

DATETIME(8)

The date we expect payment will be required for this purchase order.

STRTYPE

VARCHAR(10)

The type of purchase order. Can be 'ORDER', 'RETURN' or 'CLAIM'.

LINTRETURNINVOICENUMBER

INT(4)

The invoice number that the purchase order was returned for

INVOICEHEADER.lintInvoiceNumber

STRORIGSTATUS

VARCHAR(10)

 

STRBILLTRADECODE

VARCHAR(10)

 

STRDELIVERYTRADECODE

VARCHAR(10)

 

STRCOMMERCIALREF

VARCHAR(30)

 

DTMSTATUSCHANGED

DATETIME(8)

 

STRAUTHORISEDBY

VARCHAR(20)

 

INTCHANGEFLAG

INT(4)

 

INTNEWFLAG

INT(4)

 

INTACCEPTED

INT(4)

 

STRCURRENCYCODE

VARCHAR(5)

 

DBLEXCHANGERATE

DECIMAL(9)10,6

 

YSNCOSTINCLUDESSERVICE FEE

VARCHAR(1)

 

YSNCOSTINCLUDESULLAGEFEE

VARCHAR(1)

 

YSNCOSTINCLUDESTAX

VARCHAR(1)

 

YSNCOSTINCLUDESWET

VARCHAR(1)

 

CURTOTALWETAMT

DECIMAL(9)19,4

 

STRAGENTCODE

VARCHAR(10)

 

STRBUYERCODE

VARCHAR(10)

 

DTMAUTHORISED

DATETIME

 

DTMCREATED

DATETIME

Server date and time PO was created.

DTMAMENDED

DATETIME

Server date and time PO was last amended whilst awaiting authorisation.

STRAMENDEDBY

VARCHAR

ID of user who made the amendments.

 

Primary Key: LINTPONUMBER

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)