Product:

TOTVS Backoffice

Product Line

Microsiga Protheus Line

Industry:

Backoffice

Module:

SIGACOM - Purchases

Description:

The purpose of this report is to issue the Detailed list of purchases and credit notes by supplier by periods, which you can filter using the parameters found in the database in a simple, intuitive and objective way. 

Function:

Location:

Generic and localized (MEX).

Ticket:

Non-applicable.

Requisition/Story/Issue (enter the associated requisition):

DMINA-19643

Filter

Description

Initial and Final Provider

Run a filter in accordance with initial and final provider.

Initial and Final Product

Run a filter in accordance with initial and final product.

Typing Date

Run a filter in accordance with initial and final typing date.

Field

Description

Type

Size

Context

Country

F1_DOC

Document number.

C

2

Actual

All

F1_SERIE

Document Series

C

3

Actual

All

F1_FORNECE

Supplier code

C

6

Actual

All

F1_LOJA

Supplier store

C

2

Actual

All

A2_NOME

Corporate Name

C

40

Actual

All

A2_NREDUZ

Trade Name

C

20

Actual

All

F1_DTGIT

Typing Date

N

8

Actual

All

F1_TXMOEDA

Currency Rate

N

11.4

Actual

All

F1_MOEDA

Bill Currency

N

2

Actual

All

F1_ESPECIE

Document Type

C

5

Actual

All

D1_COD

Product Code

C

15

Actual

All

B1_DESC

Product Description

C

15

Actual

All

B1_UM

Product Code

C

30

Actual

All

D1_QUANT

Product Quantity.

N

11.2

Actual

All

D1_GRUPO

Product Group

C

4

Actual

All

D1_TIPO

Document Type

C

1

Actual

All

D1_TES

Invoice Type

C

3

Actual

All

D1_TP

Type of Product Sold

C

2

Actual

All

D1_CUSTO

Inflow Cost Currency 1 

N

14.2

Actual

All

D1_CUSTO2

Inflow Cost Currency 2

N

14.2

Actual

All

D1_CUSTO3

Inflow Cost Currency 3

N

14.2

Actual

All

D1_CUSTO4

Inflow Cost Currency 4

N

14.2

Actual

All

D1_CUSTO5

Inflow Cost Currency 5

N

14.2

Actual

All

D1_VALIMP

Value Added Tax

N

7.4

Actual

MEX

D1_BASIMP

Calculated Tax Base

N

7.4

Actual

MEX