Important
TOTVS Sales Management is available from release 12.1.33 onwards.
TOTVS Sales Management uses table A1V to manage Schemata.
TOTVS Sales Management uses a set of tables that define the basic organization of the data, such as the structure of tables, names, the characteristics of each field, etc. The data dictionary resource offers System customization flexibility.
In some of these tables, maintenance is carried out by the Configurator environment in the Data Dictionary menu. Some data are of system internal control; therefore, no intervention is possible.
Prefix | A1V |
Description | Schemata - Sales Management |
Branch Sharing | 1 - Shared |
Unit Sharing | 1 - Shared |
Company Sharing | 1 - Shared |
Order | Field | Description | Type | Size | Decimals | Required |
01 | A1V_FILIAL | System Branch | 1 - Character | 2 | 0 | No |
02 | A1V_CODIGO | Schema Code | 1 - Character | 6 | 0 | Yes |
03 | A1V_NOME | Schema Name | 1 - Character | 30 | 0 | Yes |
04 | A1V_DESCRI | Schema Description | 1 - Character | 50 | 0 | No |
05 | A1V_ENDGET | Endpoint f/ Initial Load | 1 - Character | 60 | 0 | No |
06 | A1V_ENDDIF | Endpoint f/ Edited rec | 1 - Character | 60 | 0 | No |
07 | A1V_POST | Endpoint for Addition | 1 - Character | 60 | 0 | No |
08 | A1V_PUT | Endpoint for Editing | 1 - Character | 60 | 0 | No |
09 | A1V_DELETE | Endpoint for Deletion | 1 - Character | 60 | 0 | No |
10 | A1V_IDFLD | Schema Identifier | 1 - Character | 30 | 0 | Yes |
11 | A1V_DELFLD | Deletion Identifier | 1 - Character | 30 | 0 | Yes |
12 | A1V_MSBLQL | Blocked record
| 1 - Character | 1 | 0 | No |
Order | Key | Description |
1 | A1V_FILIAL+A1V_CODIGO | Branch + Code |
2 | A1V_FILIAL+A1V_NOME | Branch + Name |
