| DB | Areas | X-idx | Tables | Sequences | <- inv-store | inv-trans-claim -> | HtmlDict 11 |
Stores Requesition
| Area | ProdData |
|---|---|
| Dumpname | storereq |
| Label | Stores Requesition |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 30 | acct-cde | X | Account | character | x(4) | |||
| 130 | alloc-qty | X | Allocated Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 15 | area-cde | X | Area Code | character | x(3) | |||
| 150 | auth-user | X | Authrsd By | character | x(12) | |||
| 210 | bin-loc | X | Bin Location | character | X(10) | |||
| 240 | bo-ind | X | Back order Ind | logical | Yes/No | yes | ||
| 260 | bo-qty | X | Backorder Qty | decimal-0 | >>>>>9- | 0 | ||
| 145 | bonus-iss | X | Bonus Iss | decimal-2 | >>>>>9.99- | 0 | ||
| 120 | bonus-qty | X | Bonus Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 147 | consign-iss | X | Consign Iss | decimal-2 | >>>>>9.99- | 0 | ||
| 125 | consign-qty | X | Consign Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 20 | cost-cde | X | Cost Code | character | x(4) | |||
| 180 | doc-ln | X | Document Line | integer | >>9 | 0 | ||
| 170 | doc-no | X | Document No | character | x(12) | |||
| 220 | est-amt | X | Est Amount | decimal-2 | >,>>>,>>9.99 | 0 | ||
| 40 | from-store | X | From Store | character | x(3) | |||
| 190 | grn-no | X | GRN No | character | x(10) | |||
| 140 | iss-qty | X | Issue Quantity | decimal-2 | >>>>>9.99- | 0 | ||
| 60 | item-no | X | Item No | character | x(15) | |||
| 200 | lot-no | X | Lot No | character | x(10) | |||
| 65 | pr | X | Priority | integer | 9 | 0 | ||
| 70 | req-date | X | Request Date | date | 99/99/9999 | TODAY | ||
| 80 | req-time | X | Request Time | integer | 99999 | 0 | ||
| 160 | reqst | X | Requestor | character | x(12) | |||
| 68 | sched-date | X | Sched Date | date | 99/99/9999 | ? | ||
| 230 | sls-val | X | Sales Value | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 100 | stat-date | X | Status Date | date | 99/99/9999 | TODAY | ||
| 50 | store-cde | X | Store Code | character | x(3) | |||
| 90 | store-req-stat | X | Store Request Status | integer | 9 | 0 | ||
| 10 | store-req-type | X | Store Request Type | character | ! | |||
| 110 | trn-qty | X | Transaction Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 250 | unit-prc | X | Unit Price | decimal-2 | >,>>>,>>9.99 | 0 |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| store-item-pr | P | store-cde (+) | character |
| item-no (+) | character | ||
| pr (+) | integer | ||
| auth-user | auth-user (+) | character | |
| store-req-stat (+) | integer | ||
| from-store | from-store (+) | character | |
| item-area-cc-date | item-no (+) | character | |
| area-cde (+) | character | ||
| cost-cde (+) | character | ||
| sched-date (+) | date | ||
| store-req-type | store-req-type (+) | character | |
| area-cde (+) | character | ||
| cost-cde (+) | character | ||
| type-doc-no | U | store-req-type (+) | character |
| doc-no (+) | character | ||
| doc-ln (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acr-paytrnsfer glr-mainacct inv-itemtrig inv-store pur-grnhdr |
| generated 18-9-2026 10:02 |