invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

PO_BUFF: AccountView Draft orders

read only per partition

  • Catálogo: AccountView
  • Label: Draft orders

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla PO_BUFF. 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
APX_LIST varchar2(5) Price list item prices
ART_AMT int64 Line total
ART_CODE varchar2(15) Código de artículo
ART_DATE datetime Original delivery date
ART_PX int64 Sales/purchase price
ART_QTY decimal Original quantity ordered
ART_WEEK int32 Original delivery date (week)
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
COST_CODE varchar2(10) Cost centre code
CPY_ORD char Copy delivery address and item description from sales order
CUR_CODE varchar2(3) Currency code
DEL_DATE datetime Expected delivery date
DEL_WEEK int32 Expected delivery date (week)
DISC_PCT decimal Discount percentage
EMP_NR varchar2(10) Employee code
GEN_TYPE decimal Type
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
LOC_CODE varchar2(5) Warehouse location
NO_COLL char Do not consolidate order
NO_OPT char Do not optimise order
ORD_DATE datetime Order date
ORD_QTY decimal Quantity to order
ORD_QTYP decimal Quantity to order (price unit)
ORD_QTYU decimal Quantity to order (unit)
ORD_WEEK int32 Order date (week)
PACK_PX decimal Sales/purchase price per unit
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PCT_LIST varchar2(5) Discount percentages price list
POL_ID varchar2(10) Unique code
REC_ID varchar2(10) Unique code
SUB_NR varchar2(10) Customer/supplier number
UNT_CODE varchar2(10) Unit
UNT_CODEP varchar2(10) Price unit
UNT_PX int64 Sales/purchase price per price unit
WHS_CODE varchar2(5) Warehouse code