Table UNFILWRK
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| UNFILWRK | UNF | Unfilled orders report | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| UNF0 | REQNUM+USER+RPTCOD+NUMLIG | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BKOQTY | Backorder quantity | QTY | ||||||
| BPCORD | Sold-to | BPR | [BPR]BPR0=[UNF]BPCORD | BSRA | ||||
| CHGRAT | Currency rate | DCB | 5.6 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[UNF]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[UNF]CUR | BSRA | ||||
| EXTRCPDAT | Exp. receipt date | D | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[UNF]ITMREF | BSRA | ||||
| NETPRINOT | Net price - tax | MD8 | ||||||
| NUMLIG | Line no. | L | 8 | |||||
| ORDDAT | Order date | D | ||||||
| POHFCY | Order site | FCY | [FCY]FCY0=[UNF]POHFCY | BSRA | ||||
| POHNUM | Order number | VCR | ||||||
| PRHFCY | Receiving site | FCY | [FCY]FCY0=[UNF]PRHFCY | BSRA | ||||
| REQNUM | Request no. | L | 8 | |||||
| RPTCOD | Report code | A | 10 | |||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[UNF]SALFCY | BSRA | ||||
| SAU | Sales unit | UOM | [TUN]TUN0=[UNF]SAU | BSRA | ||||
| SHIDAT | Ship date | D | ||||||
| SOHNUM | Order number | VCR | ||||||
| SOPLIN | Order line | L | 8 | |||||
| SOQSEQ | Sequence number | L | 8 | |||||
| STOFCY | Site | FCY | [FCY]FCY0=[UNF]STOFCY | BSRA | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[UNF]UPDUSR | Other | ||||
| USER | User code | AUS | [AUS]CODUSR=[UNF]USER | Other |