Important
The Sales Management Portal is available from release 12.1.33 onwards.
The Sales Management Portal uses table A1W to manage the fields used by a Schema, besides allowing the addition of custom fields.
The Sales Management Portal 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 | A1W |
Description | Schema Fields |
Branch Sharing | 1 - Shared |
Unit Sharing | 1 - Shared |
Company Sharing | 1 - Shared |
Order | Field | Description | Type | Size | Decimals | Required |
01 | A1W_FILIAL | System Branch | 1 - Character | 2 | 0 | No |
02 | A1W_SCHEMA | Schema Code | 1 - Character | 6 | 0 | No |
03 | A1W_ITEM | Schema Item | 1 - Character | 2 | 0 | Yes |
04 | A1W_CAMPO | Protheus Field | 1 - Character | 60 | 0 | Yes |
05 | A1W_PROPRI | Field Name in API | 1 - Character | 50 | 0 | Yes |
06 | A1W_LABEL | Field Title | 1 - Character | 60 | 0 | Yes |
07 | A1W_TIPO | Field Type 1=Character. 2=Numeric. 3=Date. 4=Logic. 5=Decimal. 6=Memo. | 1 - Character | 1 | 0 | Yes |
08 | A1W_CUSTOM | Custom Field | 3 - Logic | 1 | 0 | No |
09 | A1W_OBRIGA | Field Required? | 3 - Logic | 1 | 0 | No |
10 | A1W_VISIVE | Field Visible? | 3 - Logic | 1 | 0 | No |
11 | A1W_TAMMAX | Accepted characters limit | 2 - Numeric | 12 | 0 | No |
12 | A1W_GRID | Field Size | 2 - Numeric | 2 | 0 | No |
13 | A1W_AGRUP | Field Aggregator | 1 - Character | 60 | 0 | No |
14 | A1W_DECIMA | Decimal | 2 - Numeric | 2 | 0 | No |
15 | A1W_CBOX | Options Combo | 1 - Memo | 10 | 0 | No |
16 | A1W_SCBOX | API Combo | 1 - Character | 254 | 0 | No |
17 | A1W_SVALID | Validation API | 1 - Character | 254 | 0 | No |
18 | A1W_PICTUR | Format | 1 - Character | 30 | 0 | No |
Order | Key | Description |
1 | A1W_FILIAL+A1W_SCHEMA+A1W_ITEM | Branch + Schema Code + Item |
2 | A1W_FILIAL+A1W_SCHEMA+A1W_CAMPO | Branch + Schema Code + Field |
