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:
- Bills payable posting
- Bills receivable posting
- Bank transfer
- Booking of the new saving structure for the bank transfer and posting process
- Exchange variation appropriation
- Saving pattern for PA (Advance Payment) bill type transfers.
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:
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas