Accolent ERP Report Writer uses SQL Views for all forms and reports. The use of SQL Views eliminates the need for end-users to: write SQL Queries or understand the Accolent ERP database schema or worry about table joins. For each editable form there is a single master view that includes all the fields available for that form. Using the master view, end-users can edit the standard forms and save as their own customized version of the form.
PO Form Master Views
- The PO Form views contain the following fields which can be used to customize the standard form.
- Please contact ADS Solutions if you need help customizing the PO form.
| SQL View Name | Field Name | Description |
| ADS[vPOFormHeader_Master] | Account No | Company’s account number with vendor |
| Acknowledgement | Request for vendor acknowledgement | |
| Company Address Line 1 | Company address line 1 | |
| Company Address Line 2 | Company address line 2 | |
| Company City | Company city | |
| Company Country | Company Country | |
| Company Logo | Company logo | |
| Company Name | Company name | |
| Company Phone No | Company phone No | |
| Company State | Company state | |
| Company Zip | Company zip | |
| Confirming | Confirming PO | |
| PO Amount | Purchase order amount | |
| PO Comments | Purchase order comments | |
| PO Contact | Purchase order contact | |
| PO Date | Purchase order date | |
| PO No | Purchase order number | |
| Shipping Method | Shipping method | |
| Ship-To Address Line 1 | Ship-to address line 1 | |
| Ship-To Address Line 2 | Ship-to address line 2 | |
| Ship-To Address Line 3 | Ship-to address line 3 | |
| Ship-To City | Ship-to city | |
| Ship-To Name | Ship-to name | |
| Ship-To State | Ship-to state | |
| Ship-To Zip | Ship-to zip | |
| Special Instructions | Special instructions | |
| Terms | Terms of sale | |
| User Choice 1 | User choice 1 from Vendor Master record | |
| User Choice 2 | User choice 2 from Vendor Master record | |
| User Choice 3 | User choice 3 from Vendor Master record | |
| Vendor Address Line 1 | Vendor address line 1 | |
| Vendor Address Line 2 | Vendor address line 2 | |
| Vendor Address Line 3 | Vendor address line 3 | |
| Vendor City | Vendor city | |
| Vendor Code | Vendor code | |
| Vendor Name | Vendor name | |
| Vendor State | Vendor state | |
| Vendor Zip | Vendor zip |
| SQL View Name | Field Name | Description |
| ADS[vPOFormDetails_Master] | Extended Price | Extended price |
| Price/UOM | Price per UOM | |
| Product Code+Description | Concatenated field showing product code and product description | |
| Qty | Quantity | |
| Require Date | Require date | |
| UOM | Unit of measure | |
| Vendor Product Code | Vendor product code |