ART_LINE: AccountView Item lines
read only per partition
- Catálogo:
AccountView - Label: Item lines
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla ART_LINE. 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 |
|---|---|---|---|---|---|
ACT_ |
int64 |
Actual costs | |||
ACT_ |
int64 |
Actual revenues | |||
AG_ |
varchar2 |
Item group code | |||
AL_ |
char |
Item line processed | |||
ART_ |
int64 |
Item amount | |||
ART_BM |
char |
Composition | |||
ART_CA |
char |
Composite item | |||
ART_ |
varchar2 |
Código de artículo | |||
ART_ |
int64 |
Sales/purchase price per piece FC | |||
ART_ |
datetime |
Receipt/delivery date | |||
ART_ |
varchar2 |
Order line description | |||
ART_ |
int32 |
Composition level | |||
ART_PX |
int64 |
Sales/purchase price | |||
ART_ |
decimal |
Quantity received/delivered | |||
ART_ |
decimal |
Quantity received/delivered (price unit) | |||
ART_ |
decimal |
Quantity received/delivered (unit) | |||
ART_ |
int32 |
Receipt/delivery date (week) | |||
BM_TAG |
varchar2 |
Unique key item composition | |||
COGS_ |
int64 |
Cost of sales amount | |||
COGS_ |
decimal |
Cost price quantity | |||
COGS_ |
char |
Cost price posting deferred | |||
COST_ |
varchar2 |
Cost centre code | |||
CST_ |
int64 |
Amount posted | |||
CUR_ |
int64 |
Currency amount | |||
DECL_ |
int64 |
Chargeable amount | |||
DISC_ |
int64 |
Discount amount | |||
DISC_ |
int64 |
Discount amount FC | |||
DISC_ |
decimal |
Discount percentage | |||
EMP_NR |
varchar2 |
Employee code | |||
HDR_ID |
varchar2 |
Unique code of header record | |||
HDR_ |
decimal |
Stock movement type | |||
ICAT_ |
varchar2 |
IS goods flow category | |||
ICNT_ |
varchar2 |
IS country of origin | |||
ICNT_ |
varchar2 |
IS country of destination | |||
INV_ |
varchar2 |
Transaction invoice description | |||
INV_NR |
varchar2 |
Document/invoice number | |||
IS_ |
decimal |
IS container | |||
IS_ |
varchar2 |
IS TARIC code (customs code) | |||
IS_ |
decimal |
IS dating | |||
IS_ |
decimal |
IS weight | |||
ISHP_ |
varchar2 |
IS mode of transport | |||
ISXF_ |
varchar2 |
IS statistical factor code | |||
ISYS_ |
varchar2 |
IS regime | |||
ITEM_ |
varchar2 |
Transaction description | |||
ITEM_ |
decimal |
Quantity | |||
ITYP_ |
varchar2 |
IS transaction code | |||
LINK_ |
varchar2 |
Project journal link | |||
LOC_ |
varchar2 |
Warehouse location | |||
ORD_ |
decimal |
Quantity ordered | |||
ORD_ |
decimal |
Quantity ordered (price unit) | |||
ORD_ |
decimal |
Quantity ordered (unit) | |||
ORG_ |
varchar2 |
Original order number | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PC_ |
varchar2 |
Cost type | |||
PC_DIM |
varchar2 |
Cost type as dimension | |||
PER_ |
decimal |
Project period | |||
PIP_ |
int64 |
Expected purchase invoice amount | |||
PIP_ |
int64 |
Expected purchase invoice amount FC | |||
POL_ID |
varchar2 |
Order line identification | |||
POP_ |
int64 |
Expected receipt amount | |||
POP_ |
int64 |
Expected receipt amount FC | |||
PREF_ |
datetime |
Promised delivery date | |||
PREF_ |
int32 |
Promised delivery date (week) | |||
PROJ_ |
varchar2 |
Project code | |||
PROJ_ |
varchar2 |
Claim line identification | |||
PROJ_ |
int32 |
Project type | |||
PX_ |
int64 |
Cost price (standard / last / average) | |||
PXDIF_ |
int64 |
Purchase price difference | |||
PXDIF_ |
int64 |
Purchase price difference FC | |||
REC_ |
char |
Blocked | |||
REC_ |
varchar2 |
Blocked | |||
REC_ID |
varchar2 |
Unique code | |||
REM_ |
decimal |
Remaining lot quantity (LIFO/FIFO) | |||
RES_ID |
varchar2 |
Source identification | |||
REVA_ |
int64 |
Stock revaluation amount | |||
SELL_ |
int64 |
Amount to be invoiced | |||
SELL_ |
decimal |
Quantity to be invoiced | |||
SPL_ID |
varchar2 |
Sales/purchase line code | |||
TRN_ |
datetime |
Fecha de Transacción | |||
UNT_ |
varchar2 |
Unit | |||
UNT_ |
varchar2 |
Price unit | |||
UNT_ |
int64 |
Sales/purchase price per price unit FC | |||
UNT_PX |
int64 |
Sales/purchase price per price unit | |||
VAT_ |
int64 |
Cantidad VAT | |||
VAT_ |
varchar2 |
Código VAT | |||
VAT_ |
int64 |
VAT amount FC | |||
WHS_ |
varchar2 |
Warehouse code | |||
XML_ |
varchar2 |
Data in XML format |