Home > Technical > Table Definitions > PODETAIL

PODETAIL

The details for a purchase order. These are linked to header records in POHEADER.

Column Type Description

LINTPONUMBER

INT(4)

The purchase order header this record belongs to.

POHEADER.lintPONumber

LINTLINENUMBER

INT(4)

A unique number assigned by the system.

LINTITEMNUMBER

INT(4)

The item which was received.

ITEM.lintItemNumber

STRORDERCODE

VARCHAR(20)

The supplier’s order code for this item.

STRDESCRIPTION

VARCHAR(60)

Description about the item.

DBLQUANTITY

DECIMAL(9)19,4

The quantity which was ordered.

INTCARTONSIZE

DECIMAL(5)9,3

The number of items in a carton.

DBLCARTONS

DECIMAL(9)19,4

The number of cartons ordered.

CURCOST

DECIMAL(9)19,4

The expected invoice carton cost. This is obtained by checking the ysnLinexxx flags in the supplier. The cost portion from STORERNG corresponding to each ‘T’ flag is included in this cost.

CURLINECOST

DECIMAL(9)19,4

The extended cost of the record (dblCartons * curCost).

STRWHO

VARCHAR(20)

The user who entered the record.

DTMWHEN

DATETIME(8)

The date the record was added.

DBLSTOCKONHAND

DECIMAL(9)19,4

The stock on hand at the time of the order. Obtained from STORERNG.

DBLMINSTOCKQTY

DECIMAL(9)19,4

The minimum stock level at the time of the order. Obtained from STORERNG.

DBLMAXSTOCKQTY

DECIMAL(9)19,4

The maximum stock level at the time of the order. Obtained from STORERNG.

DBLBONUS

DECIMAL(9)19,4

The expected number of units of bonus stock.

INTMINORDER

DECIMAL(5)9,3

The minimum units that can be ordered. Obtained from STORERNG.

DBLRECEIVEDUNITS

DECIMAL(9)19,4

The number of units received so far. Set by the Goods Receipt or Invoice Matching programs.

DBLRECEIVEDBONUSUNITS

DECIMAL(9)19,4

The number of bonus units received so far. Set by the Goods Receipt or Invoice Matching programs.

CURNETTCOST

DECIMAL(9)19,4

The nett cost for one carton of the item.

CURSERVICEFEE

DECIMAL(9)19,4

The service fee for one carton of the item.

CURULLAGEFEE

DECIMAL(9)19,4

The ullage fee for one carton of the item.

CURSALESTAX

DECIMAL(9)19,4

The sales tax for one carton of the item.

CURLIQUORTAX

DECIMAL(9)19,4

The liquor tax for one carton of the item. Not used in GST or US Sales Tax Systems.

CURFREIGHT

DECIMAL(9)19,4

The freight for one carton of the item.

CURDEALAMT

DECIMAL(9)19,4

The deal amt for one carton of the item. Not currently used.

MEMCOMMENT

TEXT(16)

A general comment about the item being ordered.

INTSTATUS

INT(4)

The status of the item. Usually 0 while the item is on order, 1 if fully received and another value if the stock is partially received, for example out of stock. Set by the Goods Receipt or Invoice Matching programs.

DBLORDEREDQTY

DECIMAL(9)19,4

The number of units currently on order. Obtained from STORERNG.

LINTALLOCCODE

INT(4)

The code of the allocation that created this PO. 0 if not associated with an allocation.

ALLOCDETAIL.lintAllocCode

DBLINVOICEDQTY

DECIMAL(9)19,4

The number of units invoiced so far. Set by the Goods Receipt or Invoice Matching programs.

INTINVOICESTATUS

INT(4)

The status of the item. Usually 0 while the item is on order, 1 if fully received and another value if the stock is partially received, for example out of stock. Set by the Goods Receipt or Invoice Matching programs.

CURLASTPRICE

DECIMAL(9)19,4

The last price paid for the item.

DBLALLOCATEDQTY

DECIMAL(9)19,4

The number of units currently allocated to orders, laybys, and so on. Obtained from STORERNG.

CURFREIGHTINCTAX

DECIMAL(9)19,4

The expected freight to be paid. Includes GST.

CURWETAMT

DECIMAL(9)19,4

The WET (Wine Equalisation Tax) for one carton from the original purchase order.

CURDISCOUNT

DECIMAL(9)19,4

The discount for one carton of the item.

CUREXPECTEDREBATE

DECIMAL(9)19,6

 

STRTAXCODE

VARCHAR(10)

 

STRWETTAXCODE

VARCHAR(10)

 

STRMANUFACTURER

VARCHAR(10)

 

INTRETURNREASON

INT(4)

 

 

Primary Key: LINTPONUMBER + LINTLINENUMBER

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