|
|
Data dictionary llicnt - Item counters - 7.20
| 1 | adm_nr | integer | >>>>>9 | | | ? | Company | | 2 | item_code | character | X(20) | | | ? | Item | | 3 | qty_ordered | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity in sales orders | | 4 | qty_backorder | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity back order | | 5 | qty_total_ordered | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity ordered sales | | 6 | qty_available | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity available | | 7 | qty_shelf | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity shelf stock | | 8 | qty_to_invoice | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity to invoice sales | | 9 | qty_invoiced | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity invoiced sales | | 10 | qty_in_purchase_order | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity in purchase orders | | 11 | qty_purchase_order | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity ordered purchase | | 12 | qty_purchase_order_receipt | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity ordered purchase receipt | | 13 | qty_to_receive | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity to receive | | 14 | qty_received | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity received | | 15 | qty_to_invoice_purchase | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity to invoice purchase | | 16 | qty_invoiced_purchase | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity invoiced purchase | | 17 | qty_extra_1 | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Extra quantity | | 18 | qty_extra_2 | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Extra quantity | | 19 | qty_extra_3 | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Extra quantity | | 20 | qty_extra_4 | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Extra quantity | | 21 | qty_extra_5 | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Extra quantity | | 22 | euserid_cr | character | X(12) | | | | User creation | | 23 | date_cr | date | 99/99/9999 | | | | Date creation | | 24 | time_cr | integer | >>>>>9 | | | ? | Time creation | | 25 | source_cr | character | x(12) | | | | Source creation | | 26 | euserid_lc | character | X(12) | | | | User last changed | | 27 | date_lc | date | 99/99/9999 | | | | Date last changed | | 28 | time_lc | integer | >>>>>9 | | | ? | Time last changed | | 29 | source_lc | character | x(12) | | | | Source last changed | | 30 | qty_reserved_back_order | decimal | ->>>,>>>,>>9.999 | 6 | | 0 | Quantity reserved back order |
Indexesllicntix - primary - unique| 1 | adm_nr | integer | >>>>>9 | Company | | 2 | item_code | character | X(20) | Item |
Contents > llicnt
| Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
| Category: |
On-line help files |
Security level: |
All - 0 |
| Sub category: |
Details |
Document ID: |
26.936.365 |
| Assortment: |
Exact Financials
|
Date: |
27-01-2016 |
| Release: |
|
Attachment: |
|
| Disclaimer |
|
|