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 |