PO_BUFF: AccountView Draft orders
read only per partition
- Katalog:
AccountView - Label: Draft orders
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle PO_BUFF sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
APX_ |
varchar2 |
Price list item prices | |||
ART_ |
int64 |
Line total | |||
ART_ |
varchar2 |
Artikelcode | |||
ART_ |
datetime |
Original delivery date | |||
ART_PX |
int64 |
Sales/purchase price | |||
ART_ |
decimal |
Original quantity ordered | |||
ART_ |
int32 |
Original delivery date (week) | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
COST_ |
varchar2 |
Cost centre code | |||
CPY_ |
char |
Copy delivery address and item description from sales order | |||
CUR_ |
varchar2 |
Currency code | |||
DEL_ |
datetime |
Expected delivery date | |||
DEL_ |
int32 |
Expected delivery date (week) | |||
DISC_ |
decimal |
Discount percentage | |||
EMP_NR |
varchar2 |
Employee code | |||
GEN_ |
decimal |
Type | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
LOC_ |
varchar2 |
Warehouse location | |||
NO_ |
char |
Do not consolidate order | |||
NO_OPT |
char |
Do not optimise order | |||
ORD_ |
datetime |
Order date | |||
ORD_ |
decimal |
Quantity to order | |||
ORD_ |
decimal |
Quantity to order (price unit) | |||
ORD_ |
decimal |
Quantity to order (unit) | |||
ORD_ |
int32 |
Order date (week) | |||
PACK_ |
decimal |
Sales/purchase price per unit | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PCT_ |
varchar2 |
Discount percentages price list | |||
POL_ID |
varchar2 |
Unique code | |||
REC_ID |
varchar2 |
Unique code | |||
SUB_NR |
varchar2 |
Customer/supplier number | |||
UNT_ |
varchar2 |
Unit | |||
UNT_ |
varchar2 |
Price unit | |||
UNT_PX |
int64 |
Sales/purchase price per price unit | |||
WHS_ |
varchar2 |
Warehouse code |