Linha Microsiga Protheus - Inglês

Páginas filhas
  • Restructuring of table SE5 in the FKx table family
3 mais filhas
  • Criado por Usuário desconhecido (thayna.souza), última alteração em 24 jun, 2021

CONTENT


01. OVERVIEW

Table SE5 - Bank transfers has grown during the lifecycle of the Protheus versions, and it has impacted the product's evolution cycle.

To maintain a continuous evolution process for the product, a project for restructuring the bank transfers table was created, with a new table family for normalizing SE5. This new table family, with prefix FK, has 11 tables, which are:

Note

The sharing for the following tables must be the same as the table SE5.

Table

Description

Function

FK1

Posts receivable

Record the bills receivable posts

FK2

Posts payable

Record the bills payable posts

FK3

Calculated taxes


Store the calculated taxes' values for bills payable or receivable

FK4

Withheld taxes

Store the withheld taxes' values for bills payable or receivable

FK5

Bank transfers

Record the bank transfers for bills receivable, payable, and individual bills


FK6

Accessory values

Record the values for interests, fines, discounts, increases etc. for bills payable and receivable

FK7

Auxiliary table

This table stores the binding keys between tables SE1 and SE2 and tables FK1 and FK2

FK8

Accounting data

Saves complementary data from the FK5 table, exclusively with accounting data

FK9

Transfer complement

Save complementary data from table FK5, with source data from modules that integrate to Financials

FKA

Transfer tracking

Unites in a single process the information referring to the posts (FK1/FK2), bank transfers (FK5), and checks (SEF), and their reversal operations

FKB

Transfer types

Internal use

02. EXAMPLE OF USE

Here are some examples of the behavior of the new table family according to the situations below:

For information on the use of an entry point for saving complementary data on the FK tables in the MVC model, visit the following link:

  • FINM010 - Entry point for saving complementary data on the FK tables in the posts receivable routine.

For more information and explanations, visit the frequently asked questions in the link below: