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.
Single Pick Ticket Form Master Views
- The Pick Ticket Form views contain the following fields which can be used to customize the standard form.
- Please contact ADS Solutions for help in customizing the Pick Ticket form.
| SQL View Name | Field Name | Description |
| ADS[vPickFormHeader_Master] | Amount Due | Amount due |
| Bill-To Address Line 1 | Bill-to address line 1 | |
| Bill-To Address Line 2 | Bill-to address line 2 | |
| Bill-To Address Line 3 | Bill-to address line 3 | |
| Bill-To Address Line 4 | Bill-to address line 4 | |
| Bill-To City | Bill-to city | |
| Bill-To Code | Bill-to code | |
| Bill-To Name | Bill-to name | |
| Bill-To Name | Bill-to name | |
| Bill-To State | Bill-to state | |
| Bill-To Zip | Bill-to zip | |
| Company Address Line 1 | Company address line 1 | |
| Company Address Line 2 | Company address line 2 | |
| Company City | Company city | |
| Company Logo | Company logo | |
| Company Name | Company name | |
| Company Phone | Company phone | |
| Company State | Company state | |
| Company Zip | Company zip | |
| Customer PO No | Customer PO No | |
| Delivery Route | Delivery Route | |
| Discount | Discount | |
| Due Date | Due date | |
| Invoice Amount | Invoice amount | |
| Order Date | Order date | |
| Order No | Order number | |
| Payment | Payment | |
| Primary Contact Name | Primary contact name | |
| Primary Contact Phone No | Primary contact phone no | |
| Primary Contact Y_N | Primary contact Y_N | |
| Quote Expiry Date | Quote expiry date | |
| Request Date | Request date | |
| Salesperson Name | Salesperson name | |
| Salesperson Name | Salesperson name | |
| Shipping Instructions | Shipping instruction | |
| 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 Address Line 4 | Ship-to address line 4 | |
| 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 ID | User ID |
| SQL View Name | Field Name | Description |
| ADSvPickFormPayment_Master | Catch Weight | Catch weight of product |
| Extended Price | Extended price | |
| Loc Code | Location code | |
| Loc Qty | Location quantity | |
| Loc Tracked? | Location tracked product? | |
| Notional Weight | Notional weight of catchweight product | |
| Order No | Order number | |
| Picking Instructions | Picking instructions | |
| Picking Instructions | Picking instructions | |
| Price/UOM | Price/UOM | |
| Pricing UOM | Pricing UOM | |
| Product Code | Product code | |
| Product Description+Comment | Concatenated field showing product description and line item comment | |
| Qty on BO | Qty on BO | |
| Qty on Order | Qty on order | |
| Qty Picked from Loc | Qty picked from location | |
| Qty Shipped | Qty shipped | |
| Requested Date | Requested date | |
| Sales Tax | Sales tax | |
| Serial Number | Serial number of product | |
| Title Desc | Sub report description | |
| Title Sub | Sub report title | |
| Total Weight | Total Weight of catchweight product | |
| UOM | Unit of measure | |
| User ID | User ID | |
| Weight Description | Weight description |
| SQL View Name | Field Name | Description |
| ADSvPickFormMainQuery_Master | Amount Due | Amount due |
| Bill-To Code | Bill-to code | |
| Comments | Comments | |
| Customer PO No | Customer PO No | |
| Due Date | Due date | |
| Freight | Freight | |
| Labor | Labor | |
| Non-taxable Amount | Non-taxable amount | |
| Order Date | Order date | |
| Payment Amount | Payment Amount | |
| Sales Tax | Sales tax | |
| Salesperson Name | Salesperson name | |
| Shipping Method | Shipping method | |
| Taxable Amount | Taxable amount | |
| Terms | Terms of sale | |
| Total | Total |