ARTICLE: AccountView Articles
read only per partition
- Catalogo:
AccountView - Label: Articles
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella ARTICLE. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ABC_ |
varchar2 |
ABC category | |||
AG_ |
varchar2 |
Item group code | |||
ART_ |
varchar2 |
Codice articolo | |||
ART_ |
varchar2 |
Item code (draggable) | |||
ART_ |
decimal |
Number of packages/packaging | |||
ART_ |
varchar2 |
Item description | |||
ART_ |
varchar2 |
Item description 2 | |||
ART_ |
varchar2 |
Item type | |||
ART_ |
varchar2 |
Sales unit | |||
ART_WT |
decimal |
Net weight in kilograms | |||
ART_ |
decimal |
Gross weight in kilograms | |||
ARTQ_ |
decimal |
Sales per week | |||
ASS_ |
char |
Licence item | |||
ASS_ |
char |
Main edition | |||
ASS_ |
char |
Multiple licence item | |||
ASS_ |
char |
Do not export | |||
BASE_ |
varchar2 |
Base item | |||
C_ |
varchar2 |
Item list field 1 | |||
C_ |
varchar2 |
Item list field 2 | |||
C_ |
varchar2 |
Item list field 3 | |||
C_ |
varchar2 |
Item list field 4 | |||
C_ |
varchar2 |
Item list field 5 | |||
CI_ |
decimal |
CI sales per week | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
COMMENT1 |
varchar2 |
Item note | |||
CORD_ |
decimal |
Calculated reorder level | |||
CORD_ |
decimal |
Calculated order size | |||
CUR_ |
varchar2 |
Purchase currency code | |||
CUR_ |
varchar2 |
Sales currency code | |||
CUST_ |
decimal |
Service level | |||
DECL_ |
datetime |
Decline date | |||
DEL_ |
decimal |
Lead time in days (purchase) | |||
DESC_ |
varchar2 |
Reliability weeks of stock | |||
END_ |
datetime |
Phase-out date | |||
EST_ |
decimal |
Expected demand | |||
EST_ |
int32 |
Deviation in expected demand | |||
GROW_ |
datetime |
Growth date | |||
GRP_ |
varchar2 |
Shop group code | |||
ICOM_ |
varchar2 |
IS goods code | |||
IMG_ |
varchar2 |
Binary data large image | |||
IMG_ |
varchar2 |
Large image | |||
IMG_ |
varchar2 |
Binary data normal image | |||
IMG_ |
varchar2 |
Default image | |||
IMG_ |
varchar2 |
Binary data small image | |||
IMG_ |
varchar2 |
Small image | |||
INFO_ |
varchar2 |
URL for more info | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
INTR_ |
datetime |
Introduction date | |||
INV_ |
int64 |
Stock costs per piece | |||
INV_ |
int64 |
Stock value | |||
LOC_ |
varchar2 |
Warehouse location | |||
MAT_ |
datetime |
Maturity date | |||
MAX_ |
decimal |
Maximum stock | |||
MIN_ |
decimal |
Minimum stock | |||
MIN_ |
decimal |
Minimum order size | |||
NO_ |
char |
Do not explode on sales order | |||
NO_MFG |
char |
Do not explode as component in production order | |||
ORD_ |
int64 |
Ordering costs | |||
ORD_ |
varchar2 |
Formula | |||
ORD_ |
decimal |
Reorder level | |||
ORD_ |
decimal |
Order limit | |||
ORD_ |
char |
Multiple of min. order size | |||
ORD_ |
decimal |
Order size | |||
PACK_ |
varchar2 |
Packaging | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PC_ |
varchar2 |
Cost type code | |||
PHASE |
varchar2 |
Life cycle phase | |||
PICK_ |
varchar2 |
Warehouse picking strategy | |||
PO_DAY |
int32 |
Order day | |||
PO_ |
int32 |
Order time | |||
PO_ |
int32 |
Order interval | |||
PO_ |
decimal |
Order method | |||
PU_ |
int32 |
Quantity per package purchase | |||
PU_ |
varchar2 |
Purchase unit | |||
PX_ |
int64 |
Valuation price | |||
PX_GR |
char |
Sales price including VAT | |||
PX_ |
int64 |
New standard price | |||
PX_ |
int64 |
Purchase price | |||
PX_ |
int64 |
Price for monthly service settlement | |||
PX_ |
int64 |
Prezzo di vendita | |||
PX_ |
int64 |
Amount (calculated field) | |||
QT1_ |
varchar2 |
Quotation group code | |||
QTY_ |
decimal |
Quantity processed | |||
QTY_ |
decimal |
Quantity available | |||
QTY_ |
decimal |
Quantity economic | |||
QTY_ |
decimal |
Quantity free | |||
QTY_ |
decimal |
Quantity deferred | |||
QTY_ |
decimal |
Quantity in process | |||
QTY_ |
decimal |
To be ordered | |||
QTY_PO |
decimal |
Quantity ordered (purchase) | |||
QTY_ |
decimal |
Quantity received (purchase) | |||
QTY_ |
decimal |
Quantity reserved | |||
QTY_ |
decimal |
Quantity on backorder (sales) | |||
QTY_ |
decimal |
Quantity shipped (sales) | |||
QTY_SO |
decimal |
Quantity on order (sales) | |||
QTY_ |
decimal |
Number of stock movements | |||
QTY_ |
decimal |
Quantity technical | |||
QTY_ |
decimal |
Quantity in work in progress | |||
QTYB_ |
decimal |
Quantity processed, blocked | |||
QTYB_ |
decimal |
Quantity available, blocked | |||
QTYB_ |
decimal |
Quantity economic, blocked | |||
QTYB_ |
decimal |
Quantity free, blocked | |||
QTYB_ |
decimal |
Quantity deferred, blocked | |||
QTYB_ |
decimal |
Quantity in process, blocked | |||
QTYB_ |
decimal |
Quantity ordered, blocked (purchase) | |||
QTYB_ |
decimal |
Quantity received, blocked (purchase) | |||
QTYB_ |
decimal |
Quantity reserved, blocked | |||
QTYB_ |
decimal |
Quantity on backorder, blocked (sales) | |||
QTYB_ |
decimal |
Quantity shipped, blocked (sales) | |||
QTYB_ |
decimal |
Quantity on order, blocked (sales) | |||
QTYB_ |
decimal |
Number of stock movements, blocked | |||
QTYB_ |
decimal |
Quantity technical, blocked | |||
QTYB_ |
decimal |
Quantity in work in progress, blocked | |||
QTYF_ |
decimal |
Quantity processed, not blocked | |||
QTYF_ |
decimal |
Quantity available, not blocked | |||
QTYF_ |
decimal |
Quantity economic, not blocked | |||
QTYF_ |
decimal |
Quantity free, not blocked | |||
QTYF_ |
decimal |
Quantity deferred, not blocked | |||
QTYF_ |
decimal |
Quantity in process, not blocked | |||
QTYF_ |
decimal |
Quantity ordered, not blocked (purchase) | |||
QTYF_ |
decimal |
Quantity received, not blocked (purchase) | |||
QTYF_ |
decimal |
Quantity reserved, not blocked | |||
QTYF_ |
decimal |
Quantity on backorder, not blocked (sales) | |||
QTYF_ |
decimal |
Quantity shipped, not blocked (sales) | |||
QTYF_ |
decimal |
Quantity on order, not blocked (sales) | |||
QTYF_ |
decimal |
Number of stock movements, not blocked | |||
QTYF_ |
decimal |
Quantity technical, not blocked | |||
QTYF_ |
decimal |
Quantity in work in progress, not blocked | |||
REC_ |
char |
Blocked | |||
REC_ |
char |
Stock item | |||
REC_ |
char |
Maintain stock value in general ledger | |||
RPT_ |
varchar2 |
Reporting group 1 | |||
RPT_ |
varchar2 |
Reporting group 2 | |||
RPT_ |
varchar2 |
Reporting group 3 | |||
SAF_ |
decimal |
Safety stock | |||
SBS_ |
char |
Invoice once in subscription | |||
SHIP_ |
decimal |
Lead time in days (sales) | |||
SL_ |
varchar2 |
Subledger 1 | |||
SL_ |
varchar2 |
Subledger 2 | |||
SL_ |
varchar2 |
Subledger 3 | |||
STCK_ |
decimal |
Weeks of stock based on forecast | |||
STCK_ |
decimal |
Stock turnover rate | |||
STOCK_ |
decimal |
Stock type quantity display | |||
SUP_AC |
varchar2 |
Supplier item code | |||
SUP_NR |
varchar2 |
Supplier code | |||
SVC_ |
char |
Service | |||
TGT_ |
decimal |
Target stock | |||
UNIT_ |
int32 |
Quantity per package sales | |||
UNT_ |
varchar2 |
Base unit | |||
UNT_ |
varchar2 |
Purchase unit | |||
UNT_ |
varchar2 |
Purchase price unit | |||
UNT_ |
varchar2 |
Sales unit | |||
UNT_ |
varchar2 |
Sales price unit | |||
VAT_ |
varchar2 |
VAT code purchase | |||
VAT_ |
varchar2 |
VAT code sales | |||
WHS_ |
varchar2 |
Warehouse code | |||
WK_ |
decimal |
Weeks of stock based on history |