| DB | Areas | X-idx | Tables | Sequences | <- pur-grnhdr | pur-grnlot -> | HtmlDict 11 |
Goods received note line
| Area | ProdData |
|---|---|
| Dumpname | grnln |
| Label | Goods received note line |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 197 | ac-amt | X | Addn Cost Amt | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 240 | accpt-date | X | Accepted Date | date | 99/99/9999 | ? | ||
| 250 | accpt-time | X | Time Accepted | integer | >>>>9 | 0 | ||
| 150 | asset-ind | X | Asset Ind | logical | Yes/No | NO | ||
| 160 | asset-qty | X | Asset Quantity | decimal-2 | >>>>>9.99- | 0 | ||
| 130 | auth-user | X | Authrsd By | character | x(8) | |||
| 80 | bonus-recvd | X | Bonus Received | decimal-2 | >>>>>9.99- | 0 | ||
| 100 | bonus-rej-qty | X | Bonus Reject Quantity | decimal-2 | >>>>>9.99- | 0 | ||
| 194 | claim-amt | X | Claim Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 115 | claim-qty | X | Claim Quantity | decimal-2 | >>>>>9.99- | 0 | ||
| 196 | claim-reason | X | Claim Reason | character | x(40) | |||
| 195 | claim-tax-amt | X | Claim Tax Amt | decimal-2 | >>>,>>>,>>9.99 | 0 | ||
| 300 | cnt-qty | X | Cnt Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 120 | excess-qty | X | Excess Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 162 | grn-amt | X | GRN Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 20 | grn-ln | X | Line | integer | 99 | 0 | ||
| 200 | grn-ln-stat | X | Line Status | integer | 9 | 1 | ||
| 10 | grn-no | X | GRN No | character | x(10) | |||
| 166 | inv-amt | X | Inv Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 310 | inv-qty | X | Inv Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 168 | inv-tax-amt | X | Inv Tax | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 55 | item-desc | X | Item Description | character | x(30) | |||
| 50 | item-no | X | Item No | character | x(15) | |||
| 260 | ln-type | X | Line Type | integer | 99 | 0 | ||
| 210 | lot-exp-date | X | Lot Expiry Date | date | 9999/99/99 | ? | ||
| 60 | lot-no | X | Lot No | character | x(10) | |||
| 40 | ord-ln | X | Order Line | integer | 99 | 0 | ||
| 30 | ord-no | X | Order No | character | x(8) | |||
| 180 | paid-amt | X | Paid Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 182 | paid-tax-amt | X | Paid Tax Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 170 | prov-amt | X | Provisional Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 172 | prov-tax-amt | X | Prov Tax Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 90 | recvd-qty | X | Received Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 192 | rej-amt | X | Reject Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 110 | rej-qty | X | Reject Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 290 | scan-qty | X | Scan Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 164 | tax-amt | X | Tax Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 270 | tax-rate | X | Tax Rate | decimal-2 | >9.99 | 0 | ||
| 320 | tot-wgt | X | Total Weight | decimal-3 | >>>>9.999 | 0 | ||
| 280 | transp-vendor-no | X | Transp Vendor | character | x(6) | |||
| 140 | unit-prc | X | Unit Price | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 220 | vendor-dn-no | X | Delivery note No | character | x(15) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| grn-no-ln | P U | grn-no (+) | character |
| grn-ln (+) | integer | ||
| asset-ind | asset-ind (+) | logical | |
| item-no | item-no (+) | character | |
| accpt-date (-) | date | ||
| accpt-time (-) | integer | ||
| ord-no-ln | ord-no (+) | character | |
| ord-ln (+) | integer | ||
| vend-dn-ndx | grn-no (+) | character | |
| item-no (+) | character | ||
| vendor-dn-no (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| pur-claim pur-item-vend pur-ordln |
| Child tables |
|---|
| pur-claim pur-prov-ran pur-ran |
| generated 24-6-2026 08:40 |