Home > Technical > Table Definitions > 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 |
INT(4) |
A unique number assigned by the system. |
|
STRSUPPLIERCODE |
VARCHAR(10) |
The supplier from which the goods were received. |
STRTRADECODE |
VARCHAR(20) |
The location which received the goods. |
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. |
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) |