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) |
