invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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_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