Home > Technical > Table Definitions > GRHEADER

GRHEADER

A goods receipt consists of at least two records, one header (GRHEADER) and one or more details (GRDETAIL). A header record is created for each delivery docket received. The items on this delivery docket will be stored in GRDETAIL.

Column

Type

Description

LINTGRNUMBER

INT(4)

A unique number assigned by the system.

STRSUPPLIERCODE

VARCHAR(10)

The supplier from which the goods were received.

SUPPLIER.strSupplierCode

STRTRADECODE

VARCHAR(20)

The location which received the goods.

TRADUNIT.strTradeCode

DTMRECEIVEDDATE

DATETIME(8)

The date the goods were received.

STRWHO

VARCHAR(20)

The user who keyed in the receipt.

DTMENTEREREDDATE

DATETIME(8)

The date the goods receipt was entered.

STRSTATUS

VARCHAR(10)

Status of goods receipt.

STRPONUMBERS

VARCHAR(50)

A comma-delimited list of PO numbers that are being processed.

MEMCOMMENTS

VARCHAR(2000)

A general comment about the received goods.

LINTALLOCCODE

INT(4)

If a transfer allocation was created as a result of this receipt then this is the key to the record. If no allocation then this will be zero.

ALLOCHEADER.ctrCode

STRSUPPREFERENCE

VARCHAR(50)

The supplier's reference number on the goods receipt document.

DTMSTATUS

DATETIME(8)

The date the strStatus field last changed.

STRTYPE

VARCHAR(10)

The type of goods receipt. Can be 'RECEIPT', 'RETURN' or 'CLAIM'.

DTMSTATUSCHANGED

DATETIME(8)

 

STRAUTHORISEDBY

VARCHAR(20)

 

STRFREIGHT

VARCHAR(50)

 

INCHANGEFLAG

INT(4)

 

INTNEWFLAG

INT(4)

 

INTACCEPTED

INT(4)

 

STRCURRENCYCODE

VARCHAR(5)

 

DBLEXCHANGERATE

DECIMAL(9)10,6

 

STRASNNUMBER

VARCHAR(50)

 

STRAGENTCODE

VARCHAR(10)

 

DTMDELIVERY

DATETIME(8)

 

DTMDELIVERYTIMEFROM

DATETIME(8)

 

DTMDELIVERYTIMETO

DATETIME(8)

 

CURTOTALCOST

DECIMAL(9)19,4

 

CURTOTALUNITS

DECIMAL(9)19,4

 

CURTOTALNETTCOST

DECIMAL(9)19,4

 

CURTOTALSERVICEFEE

DECIMAL(9)19,4

 

CURTOTALULLAGEFEE

DECIMAL(9)19,4

 

CURTOTALSALESTAX

DECIMAL(9)19,4

 

CURTOTALLIQUORTAX

DECIMAL(9)19,4

 

CURTOTALFREIGHT

DECIMAL(9)19,4

 

CURTOTALWETAMT

DECIMAL(9)19,4

 

YSNCOSTINCLUDESSERVICEFEE

VARCHAR(1)

 

YSNCOSTINCLUDESULLAGEFEE

VARCHAR(1)

 

YSNCOSTINCLUDESTAX

VARCHAR(1)

 

YSNCOSTINCLUDESWET

VARCHAR(1)

 

INTUPDATECODE

INTEGER

 

YSNIMPORTED

VARCHAR(1)

Indicates if the GR has been created by the B2B service.

YSNITEMSIMPORTED

VARCHAR(1)

Indicates if an item import has been performed on the GR.

DTMACCEPTED

DATETIME To record the date and time the Goods Receipt is accepted.

 

Primary Key: LINTGRNUMBER

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