| DB | Areas | X-idx | Tables | Sequences | <- pur-grnauth | pur-grnln -> | HtmlDict 11 |
Goods receiving header
| Area | ProdData |
|---|---|
| Dumpname | grnhdr |
| Label | Goods receiving header |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 320 | accpt-date | X | Updated | date | 99/99/9999 | ? | ||
| 340 | accpt-date-end | X | Updated | date | 99/99/9999 | ? | ||
| 330 | accpt-time | X | At | integer | 99999 | 0 | ||
| 350 | accpt-time-end | X | At | integer | 99999 | 0 | ||
| 310 | accpt-user-id | X | By | character | x(12) | |||
| 135 | act-wgt | X | Actual Weight | decimal-3 | >>>>9.999 | 0 | ||
| 220 | cage-date | X | Cage Date | date | 99/99/9999 | ? | ||
| 210 | cage-no | X | Cage No | character | X(10) | |||
| 230 | cage-time | X | At | integer | 99999 | 0 | ||
| 240 | cage-user | X | Cage User | character | x(12) | |||
| 280 | capt-end-date | X | Updated | date | 99/99/9999 | ? | ||
| 300 | capt-end-time | X | At | integer | 99999 | 0 | ||
| 270 | capt-start-date | X | Updated | date | 99/99/9999 | ? | ||
| 290 | capt-start-time | X | At | integer | 99999 | 0 | ||
| 260 | capture-user | X | By | character | x(12) | |||
| 250 | claim-ind | X | Claim Ind | logical | Yes/No | NO | ||
| 120 | customs-date | X | Customs Date | date | 99/99/9999 | ? | ||
| 10 | grn-no | X | GRN No | character | x(10) | |||
| 80 | grn-stat | X | GRN Status | integer | 9 | 0 | ||
| 40 | inv-amt | X | Inv Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 35 | inv-no | X | Invoice No | character | x(12) | |||
| 45 | inv-tax-amt | X | Inv Tax | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 140 | load-type | X | Load Type | integer | 999 | 0 | ||
| 25 | ord-no | X | Order No | character | x(8) | 0 | ||
| 70 | paid-amt | X | Paid Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 75 | paid-tax-amt | X | Paid Tax | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 60 | prov-amt | X | Provisional Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 65 | prov-tax-amt | X | Prov Tax | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 150 | rate-quoted | X | Rate Quoted | integer | 999 | 0 | ||
| 55 | rec-date | X | Receive Date | date | 99/99/9999 | ? | ||
| 130 | tot-wgt | X | Weight | decimal-2 | >>>>9.99 | 0 | ||
| 190 | transp-inv-amt | X | Transp Inv Amt | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 180 | transp-inv-no | X | Transport Inv | character | x(12) | |||
| 200 | transp-tax-amt | X | Transp Tax Amt | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 170 | transp-vendor-no | X | Transport Vendor | character | x(6) | |||
| 90 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 100 | upd-time | X | At | integer | 99999 | 0 | ||
| 110 | user-id | X | By | character | x(12) | |||
| 30 | vendor-dn-no | X | Vendor Deliv Note | character | x(15) | |||
| 20 | vendor-no | X | Vendor No | character | x(6) | |||
| 160 | waybill-no | X | Waybill No | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| grn-no | P U | grn-no (+) | character |
| grn-stat | grn-stat (+) | integer | |
| vendor-no (+) | character | ||
| grn-vend-dn | U | vendor-no (+) | character |
| grn-no (+) | character | ||
| vendor-dn-no (+) | character | ||
| ord-grn | ord-no (+) | character | |
| grn-stat (+) | integer | ||
| rec-date | rec-date (+) | date | |
| vendor-ord | vendor-no (+) | character | |
| ord-no (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| prn-spoolfile pur-ordhdr pur-vendor |
| Child tables |
|---|
| pur-recvlog pur-scanhdr pur-scanranhdr |
| generated 24-6-2026 08:40 |