invantive documentation
Invantive Support ForumsLog In / Sign Up

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_CODE varchar2(10) Approval profile
AUTH_DESC varchar2(40) Approval profile description
CHK_MAND char Approval checks required
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
IN_EDT1 char Modify if stock page entered
IN_EDT2 char Modify if stock page approved
IN_PAGEAPR char Approve stock page
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
PO_CNFAPR char Approve order confirmation
PO_CNFCHK char Check order confirmation
PO_CNFREC char Receipt of order confirmation
PO_EDT1 char Modify if purchase order entered
PO_EDT2 char Modify if purchase order approved
PO_EDT3 char Modify if order confirmation received
PO_EDT4 char Modify if order confirmation checked
PO_EDT5 char Modify if order confirmation approved
PO_EDT6 char Modify if invoice received
PO_EDT7 char Modify if invoice checked
PO_EDT8 char Modify if purchase invoice approved
PO_INVAPR char Approve purchase invoice
PO_INVCHK char Check purchase invoice
PO_INVREC char Receipt of purchase invoice
PO_ORDAPR char Approve purchase order
QT_EDT1 char Modify if quotation entered
QT_EDT2 char Modify if quotation approved
QT_QTAPR char Approve quotation
SI_EDT1 char Modify if sales invoice entered
SI_EDT2 char Modify if sales invoice approved
SI_INVAPR char Approve sales invoice
SO_CNFREC char Order confirmation return
SO_CNFSND char Print order confirmation
SO_EDT1 char Modify if entered, not approved
SO_EDT2 char Modify if sales order approved
SO_EDT3 char Modify if order confirmation printed
SO_EDT4 char Modify if order confirmation returned
SO_EDT5 char Modify if delivery approved
SO_EDT6 char Modify if delivery note printed
SO_EDT7 char Modify if delivery note complete
SO_ORDAPR char Approve sales order
SO_PACAPR char Approve delivery
SO_PACCHK char Complete delivery note
SO_PACPRN char Print delivery note
SP_EDT1 char Modify if issue order entered
SP_EDT2 char Modify if issue order approved
SP_EDT3 char Modify if packing list complete
SP_PICAPR char Approve issue order
SP_PICRET char Report goods back