Home > Technical > Table Definitions > GRDETAIL

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.

GRHEADER.lintGRNumber

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.

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)