01. OVERVIEW
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.
02. EXAMPLE OF USE
Table
Prefix | A1V |
Description | Schemata - Sales Management |
Branch Sharing | 1 - Shared |
Unit Sharing | 1 - Shared |
Company Sharing | 1 - Shared |
Fields
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 |
Indexes
Order | Key | Description |
1 | A1V_FILIAL+A1V_CODIGO | Branch + Code |
2 | A1V_FILIAL+A1V_NOME | Branch + Name |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas