Order Integration Control Table

01. OVERVIEW

Important

The Sales Management Portal is available from release 12.1.33 onwards.

Use table A1T to control the receipt of Sales Orders, generated from the Sales Management Portal.

Records set to Status (A1T_STATUS) equal zero - Waiting for Processing, will only be processed if routine TGVA002Job is previously registered in Configurator module in Schedule routine.

Check the reference document of the routine for further information.

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	A1T
Description	Order/Price Quote Int. Ctrl.
Branch Sharing	2 - Exclusive
Unit Sharing	2 - Exclusive
Company Sharing	2 - Exclusive

Fields

Order	Field	Description	Type	Size	Decimals	Required
1	A1T_FILIAL	System Branch	1 - Character	2	0	No
2	A1T_NUM	External Number of Order	1 - Character	36	0	Yes
3	A1T_STATUS	Processing Status 0 - Received. 1 - Being Processed. 2 - Finished. 3 - Error.	1 - Character	1	0	Yes
4	A1T_DTREC	Date of Receipt	4 - Date	8	0	Yes
5	A1T_HRREC	Time of Receipt	1 - Character	5	0	Yes
6	A1T_TPOPER	Type of Operation 3 - Addition 4 - Editing 5 - Deletion	1 - Character	1	0	No
7	A1T_DTPROC	Processing Date	4 - Date	8	0	No
8	A1T_HRPROC	Processing Time	1 - Character	5	0	No
9	A1T_JRECEB	JSON object received	5 - Memo	10	0	Yes
10	A1T_ERROR	Error Message	5 - Memo	10	0	No
11	A1T_ROTINA	Routine the Job must run	1 - Character	10	0	Yes

Indexes

Order	Key	Description
1	A1T_FILIAL+A1T_NUM	Branch + Number
2	A1T_FILIAL+A1T_STATUS+DTOS(A1T_DTREC)+A1T_HRREC	Branch + Status + Receipt Date + Receipt Time

Páginas filhas