| DB | Areas | X-idx | Tables | Sequences | <- inv-plhdr | inv-plncde -> | HtmlDict 11 |
Pick List Line Detail
| Area | ProdData |
|---|---|
| Dumpname | plline |
| Label | Pick List Line Detail |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 100 | acct-cde | X | Account | character | x(4) | |||
| 80 | area-cde | X | Area Code | character | x(3) | |||
| 150 | auth-user | X | Authrsd By | character | x(8) | |||
| 60 | bin-loc | X | Bin Location | character | X(10) | |||
| 132 | bonus-qty | X | Bonus Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 134 | consign-qty | X | Consignment Qty | decimal-0 | >,>>>,>>9 | 0 | ||
| 135 | consign-qty-wgt | X | Consignment Qty Weight | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 90 | cost-cde | X | Cost Code | character | x(4) | |||
| 170 | doc-ln | X | Document Line | integer | >>9 | 0 | ||
| 160 | doc-no | X | Document No | character | x(12) | |||
| 40 | grn-no | X | GRN No | character | x(10) | |||
| 140 | iss-qty | X | Issue Quantity | decimal-7 | >>>>>9.99- | 0 | ||
| 30 | item-no | X | Item No | character | x(15) | |||
| 50 | lot-no | X | Batch No | character | x(10) | |||
| 20 | pl-ln | X | Picklist Line | integer | >9 | 0 | ||
| 10 | pl-no | X | Picklist Number | character | x(12) | |||
| 180 | pl-stat | X | Picklist Status | integer | 9 | 0 | ||
| 145 | rej-qty | X | Reject Qty | decimal-7 | >>>>>9.99- | 0 | ||
| 138 | sls-val | X | Sales Value | decimal-7 | >>,>>>,>>9.99- | 0 | ||
| 70 | to-bin-loc | X | To Bin Location | character | X(10) | |||
| 136 | tot-cost | X | Total Cost | decimal-7 | >>,>>>,>>9.99- | 0 | ||
| 130 | trn-qty | X | Transaction Qty | decimal-7 | >>>>>9.99- | 0 |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| pl-no-ln | P U | pl-no (+) | character |
| pl-ln (+) | integer | ||
| doc-no-ln | doc-no (+) | character | |
| doc-ln (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| coe-slipln glr-mainacct inv-itemcost inv-plhdr pur-grnhdr |
| generated 18-9-2026 09:32 |