Schema Fields Table

01. OVERVIEW

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.

02. EXAMPLE OF USE

Table

Prefix	A1W
Description	Schema Fields
Branch Sharing	1 - Shared
Unit Sharing	1 - Shared
Company Sharing	1 - Shared

Fields

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

Indexes

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

Páginas filhas