Páginas filhas
  • Sales Representative Notifications Table

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

01. OVERVIEW

Aviso
titleImportant

TOTVS Sales Management is available from release 12.1.33 onwards.

TOTVS Sales Management uses table A1S to manage Sales Representative Notifications.

To link a Notification to a user, use the field User Code (A3_CODUSR) entered in the Sales Representatives register, thus you can link a Sales Representative to a Protheus user.


Informações

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

A1S

Description

Sales Representative Notifications

Branch Sharing

1 - Shared

Unit Sharing

2 - Exclusive

Company Sharing

2 - Exclusive


Fields

 

Order

Field

Description

Type

Size

Decimals

Required

1

A1S_FILIAL

System Branch

1 - Character

2

0

No

2

A1S_CODIGO

Notification Code

1 - Character

9

0

Yes

3

A1S_TITULO

Notification Title

1 - Character

50

0

Yes

4

A1S_DESC

Notification Description

5 - Memo

10

0

No

5

A1S_TIPO

Notification Type

  • 1 - Order Transaction
  • 2 - Customer Transaction
  • 3 - Price Quote Transaction

1 - Character

1

0

No

6

A1S_CODUSR

System User Code

1 - Character

6

0

Yes

7

A1S_NOMUSR

User Name

1 - Character

50

0

No

8

A1S_DATA

Notification Date

4 - Date

8

0

Yes

9

A1S_HORA

Notification Time

1 - Character

5

0

Yes

10

A1S_STATUS

Notification Status

  • 1 - Not Viewed
  • 2 - Viewed

1 - Character

1

0

No

11

A1S_MOV

Transaction Status

2 - Numeric

2

0

No


Indexes

 

Order

Key

Description

1

A1S_FILIAL+A1S_CODIGO+A1S_CODUSR

Branch + Code + User Code

2

A1S_FILIAL+A1S_CODUSR

Branch + User Code  

HTML
<!-- esconder o menu --> 


<style>
div.theme-default .ia-splitter #main {
    margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
    display: none;
}
#main {
    padding-left: 10px;
    padding-right: 10px;
    overflow-x: hidden;
}

.aui-header-primary .aui-nav,  .aui-page-panel {
    margin-left: 0px !important;
}
.aui-header-primary .aui-nav {
    margin-left: 0px !important;
}
</style>