# AUTH_PRO: Approval profiles - Name: `AUTH_PRO` - Catalog: `AccountView` - Label: Approval profiles - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `AUTH_PRO` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | 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` | `string(10)` | Approval profile | ☐ | | | `AUTH_DESC` | `string(40)` | Approval profile description | ☐ | | | `CHK_MAND` | `boolean` | Approval checks required | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `IN_EDT1` | `boolean` | Modify if stock page entered | ☐ | | | `IN_EDT2` | `boolean` | Modify if stock page approved | ☐ | | | `IN_PAGEAPR` | `boolean` | Approve stock page | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `PO_CNFAPR` | `boolean` | Approve order confirmation | ☐ | | | `PO_CNFCHK` | `boolean` | Check order confirmation | ☐ | | | `PO_CNFREC` | `boolean` | Receipt of order confirmation | ☐ | | | `PO_EDT1` | `boolean` | Modify if purchase order entered | ☐ | | | `PO_EDT2` | `boolean` | Modify if purchase order approved | ☐ | | | `PO_EDT3` | `boolean` | Modify if order confirmation received | ☐ | | | `PO_EDT4` | `boolean` | Modify if order confirmation checked | ☐ | | | `PO_EDT5` | `boolean` | Modify if order confirmation approved | ☐ | | | `PO_EDT6` | `boolean` | Modify if invoice received | ☐ | | | `PO_EDT7` | `boolean` | Modify if invoice checked | ☐ | | | `PO_EDT8` | `boolean` | Modify if purchase invoice approved | ☐ | | | `PO_INVAPR` | `boolean` | Approve purchase invoice | ☐ | | | `PO_INVCHK` | `boolean` | Check purchase invoice | ☐ | | | `PO_INVREC` | `boolean` | Receipt of purchase invoice | ☐ | | | `PO_ORDAPR` | `boolean` | Approve purchase order | ☐ | | | `QT_EDT1` | `boolean` | Modify if quotation entered | ☐ | | | `QT_EDT2` | `boolean` | Modify if quotation approved | ☐ | | | `QT_QTAPR` | `boolean` | Approve quotation | ☐ | | | `SI_EDT1` | `boolean` | Modify if sales invoice entered | ☐ | | | `SI_EDT2` | `boolean` | Modify if sales invoice approved | ☐ | | | `SI_INVAPR` | `boolean` | Approve sales invoice | ☐ | | | `SO_CNFREC` | `boolean` | Order confirmation return | ☐ | | | `SO_CNFSND` | `boolean` | Print order confirmation | ☐ | | | `SO_EDT1` | `boolean` | Modify if entered, not approved | ☐ | | | `SO_EDT2` | `boolean` | Modify if sales order approved | ☐ | | | `SO_EDT3` | `boolean` | Modify if order confirmation printed | ☐ | | | `SO_EDT4` | `boolean` | Modify if order confirmation returned | ☐ | | | `SO_EDT5` | `boolean` | Modify if delivery approved | ☐ | | | `SO_EDT6` | `boolean` | Modify if delivery note printed | ☐ | | | `SO_EDT7` | `boolean` | Modify if delivery note complete | ☐ | | | `SO_ORDAPR` | `boolean` | Approve sales order | ☐ | | | `SO_PACAPR` | `boolean` | Approve delivery | ☐ | | | `SO_PACCHK` | `boolean` | Complete delivery note | ☐ | | | `SO_PACPRN` | `boolean` | Print delivery note | ☐ | | | `SP_EDT1` | `boolean` | Modify if issue order entered | ☐ | | | `SP_EDT2` | `boolean` | Modify if issue order approved | ☐ | | | `SP_EDT3` | `boolean` | Modify if packing list complete | ☐ | | | `SP_PICAPR` | `boolean` | Approve issue order | ☐ | | | `SP_PICRET` | `boolean` | Report goods back | ☐ | |