ARTICLE: AccountView Articles
read only per partition
- Catálogo:
AccountView - Label: Articles
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla ARTICLE. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ABC_ |
varchar2 |
ABC category | |||
AG_ |
varchar2 |
Item group code | |||
ART_ |
varchar2 |
Código de artículo | |||
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 |
Precio de venta | |||
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 |