Páginas filhas
  • TReports - Purchase List

Versões comparadas

Chave

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

...

Índice
excludeCONTENTS

01. OVERVIEW

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 databasein a simple, intuitive and objective way. 

Function:

Routines

Technical Name

Date

com.treports.Listadecompras.tlpp

Object of business: Purchase List (provider)

05/28/2023

com.treports.Listadecompras_mex.tlpp

Object of business: Purchase List (provider) for the country Mexico

05/28/2023

Location:

Generic and localized (MEX).

Ticket:

Non-applicable.

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

DMINA-19643

Nota
titleImportant

For this report to work, follow the documentation below to configure TReports in your environment: TReports - Configuration of the Protheus product integrated with TReports


02. EXAMPLE

When you run the Purchase List, the data are stated as follows:

Insert image here.

  • com.treports.Listadecompras.tlpp

Image Added


  • com.treports.Listadecompras_mex.tlpp


Image Added

  • Other Actions / Related Features

...

03. MAIN FIELDS AND PARAMETERS

  • treports.Listadecompras.tlpp

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


04. TABLES

  • SF1 - Incoming Invoice Header
  • SD1 - Incoming Invoice Items
  • SF2 - Incoming Invoice Header
  • SD2 - Invoice Sales Items
  • SA2 - Suppliers
  • SB1 - Generic Product Description

05. RELATED SUBJECTS