invantive documentation
Invantive SupportforenAnmelden / Eintragen

AUTH_PRO: AccountView Approval profiles

read only

  • Katalog: AccountView
  • Label: Approval profiles

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle AUTH_PRO 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
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