AUTH_PRO: AccountView Approval profiles
read only
- Catálogo:
AccountView - Label: Approval profiles
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla AUTH_PRO. 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 |
|---|---|---|---|---|---|
APP_PI |
int64 |
Maximum approval amount purchase invoice | |||
APP_PO |
int64 |
Maximum approval amount purchase order | |||
APP_QT |
int64 |
Maximum approval amount quotation | |||
APP_SI |
int64 |
Maximum approval amount sales invoice | |||
APP_SO |
int64 |
Maximum approval amount sales order | |||
AUTH_ |
varchar2 |
Approval profile | |||
AUTH_ |
varchar2 |
Approval profile description | |||
CHK_ |
char |
Approval checks required | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
IN_ |
char |
Modify if stock page entered | |||
IN_ |
char |
Modify if stock page approved | |||
IN_ |
char |
Approve stock page | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
PO_ |
char |
Approve order confirmation | |||
PO_ |
char |
Check order confirmation | |||
PO_ |
char |
Receipt of order confirmation | |||
PO_ |
char |
Modify if purchase order entered | |||
PO_ |
char |
Modify if purchase order approved | |||
PO_ |
char |
Modify if order confirmation received | |||
PO_ |
char |
Modify if order confirmation checked | |||
PO_ |
char |
Modify if order confirmation approved | |||
PO_ |
char |
Modify if invoice received | |||
PO_ |
char |
Modify if invoice checked | |||
PO_ |
char |
Modify if purchase invoice approved | |||
PO_ |
char |
Approve purchase invoice | |||
PO_ |
char |
Check purchase invoice | |||
PO_ |
char |
Receipt of purchase invoice | |||
PO_ |
char |
Approve purchase order | |||
QT_ |
char |
Modify if quotation entered | |||
QT_ |
char |
Modify if quotation approved | |||
QT_ |
char |
Approve quotation | |||
SI_ |
char |
Modify if sales invoice entered | |||
SI_ |
char |
Modify if sales invoice approved | |||
SI_ |
char |
Approve sales invoice | |||
SO_ |
char |
Order confirmation return | |||
SO_ |
char |
Print order confirmation | |||
SO_ |
char |
Modify if entered, not approved | |||
SO_ |
char |
Modify if sales order approved | |||
SO_ |
char |
Modify if order confirmation printed | |||
SO_ |
char |
Modify if order confirmation returned | |||
SO_ |
char |
Modify if delivery approved | |||
SO_ |
char |
Modify if delivery note printed | |||
SO_ |
char |
Modify if delivery note complete | |||
SO_ |
char |
Approve sales order | |||
SO_ |
char |
Approve delivery | |||
SO_ |
char |
Complete delivery note | |||
SO_ |
char |
Print delivery note | |||
SP_ |
char |
Modify if issue order entered | |||
SP_ |
char |
Modify if issue order approved | |||
SP_ |
char |
Modify if packing list complete | |||
SP_ |
char |
Approve issue order | |||
SP_ |
char |
Report goods back |