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 the FK prefix has 11 tables:
NOTE: The sharing for the following tables must be the same as the table SE5, except for table FK7.
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 | Table FK7 is a FROM/TO table between the current key of the bill and the future key of the bill. This table stores the binding keys between tables SE1 and SE2, and the new tables such as FK1, FK2, FKD. |
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 |
Here are some examples of the behavior of the new table family according to the situations below:
- Bills payable posting
- Bills receivable posting
- Adding a bill receivable with accessory values
- Adding a bill payable with accessory values
- Bank transfer
- Accounting 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:
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