Páginas filhas
  • 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