Home > Technical > Table Definitions > PODETAIL
The details for a purchase order. These are linked to header records in POHEADER.
Column | Type | Description |
INT(4) |
The purchase order header this record belongs to. |
|
INT(4) |
A unique number assigned by the system. |
|
LINTITEMNUMBER |
INT(4) |
The item which was received. |
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. |
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) |