Home > Technical > Table Definitions > GRDETAIL
A goods receipt consists of at least two records, one header (GRHEADER) and one or more details (GRDETAIL). A detail record is created for each item received.
Column |
Type |
Description |
LINTGRNUMBER |
INT(4) |
The goods receipt header this record belongs to. |
LINTLINENUMBER |
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. |
DBLQTYORDERED |
DECIMAL(9)19,4 |
The quantity which was ordered. |
DBLQTYRECEIVED |
DECIMAL(9)19,4 |
The quantity received. |
DBLBONUSEXPECTED |
DECIMAL(9)19,4 |
The quantity of bonus stock expected based on the order quantity. |
DBLBONUSRECEIVED |
DECIMAL(9)19,4 |
The actual bonus stock received. |
INTCARTONSIZE |
DECIMAL(5)9,3 |
The number of items in a carton. |
STRWHO |
VARCHAR(20) |
The user who entered the record. |
LINTPONUMBER |
INT(4) |
The PO number that this line item was originally from. 0 if not associated with a PO. |
CURLANDEDCOST |
DECIMAL(9)19,4 |
The landed cost of the item. |
DBLCARTONSORDERED |
DECIMAL(9)19,4 |
The number of cartons originally ordered. |
DBLCARTONSRECEIVED |
DECIMAL(9)19,4 |
The number of cartons received. |
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 program. |
DBLORIGRECEIVED |
DECIMAL(9)19,4 |
|
CURREBATE |
DECIMAL(9)19,4 |
|
INTMINORDER |
INT(4) |
|
CURDEALAMT |
DECIMAL(9)19,4 |
|
CURRNETTCOST |
DECIMAL(9)19,4 |
|
CURSERVICEFEE |
DECIMAL(9)19,4 |
|
CURULLAGEFEE |
DECIMAL(9)19,4 |
|
CURWETAMT |
DECIMAL(9)19,4 |
|
CURSALESTAX |
DECIMAL(9)19,4 |
|
CURLIQUORTAX |
DECIMAL(9)19,4 |
|
CURFREIGHT |
DECIMAL(9)19,4 |
|
CURLINECOST |
DECIMAL(9)19,4 |
|
STRTAXCODE |
VARCHAR(10) |
|
STRWETTAXCODE |
VARCHAR(10) |
|
STRMANUFACTURER |
VARCHAR(10) |
|
CURFREIGHTINCTAX |
DECIMAL(9)19,4 |
|
CURCOST |
DECIMAL(9)19,4 |
|
DBLTAXRATE |
DECIMAL(9)19,4 |
|
DBLDELIVQTY |
DECIMAL(9)19,4 |
Delivery unit quantity. |
DBLCARTONSDELIV |
DECIMAL(9)19,4 |
Delivery carton quantity. |
DBLCARTONSPICKED |
DECIMAL(9)19,4 |
The number of cartons picked. |
Primary Key: LINTGRNUMBER + LINTLINENUMBER
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |