AUTH_PRO: AccountView Approval profiles
read only
- Catalog:
AccountView - Label: Approval profiles
Can only retrieve data.
Table Columns
The columns of the table AUTH_PRO are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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 |