01. OVERVIEW
TOTVS Sales Management uses table A1S to manage Sales Representative Notifications.
To link a Notification to a user, use the field User Code (A3_CODUSR) entered in the Sales Representatives register, thus you can link a Sales Representative to a Protheus user.
02. EXAMPLE OF USE
Table
Prefix | A1S |
Description | Sales Representative Notifications |
Branch Sharing | 1 - Shared |
Unit Sharing | 2 - Exclusive |
Company Sharing | 2 - Exclusive |
Fields
Order | Field | Description | Type | Size | Decimals | Required |
1 | A1S_FILIAL | System Branch | 1 - Character | 2 | 0 | No |
2 | A1S_CODIGO | Notification Code | 1 - Character | 9 | 0 | Yes |
3 | A1S_TITULO | Notification Title | 1 - Character | 50 | 0 | Yes |
4 | A1S_DESC | Notification Description | 5 - Memo | 10 | 0 | No |
5 | A1S_TIPO | Notification Type - 1 - Order Transaction
- 2 - Customer Transaction
- 3 - Price Quote Transaction
| 1 - Character | 1 | 0 | No |
6 | A1S_CODUSR | System User Code | 1 - Character | 6 | 0 | Yes |
7 | A1S_NOMUSR | User Name | 1 - Character | 50 | 0 | No |
8 | A1S_DATA | Notification Date | 4 - Date | 8 | 0 | Yes |
9 | A1S_HORA | Notification Time | 1 - Character | 5 | 0 | Yes |
10 | A1S_STATUS | Notification Status | 1 - Character | 1 | 0 | No |
11 | A1S_MOV | Transaction Status | 2 - Numeric | 2 | 0 | No |
Indexes
Order | Key | Description |
1 | A1S_FILIAL+A1S_CODIGO+A1S_CODUSR | Branch + Code + User Code |
2 | A1S_FILIAL+A1S_CODUSR | Branch + User Code |