Histórico da Página
...
This register enables you to import the Budgetary Flow by Nature from PCO - Budget Planning and Control to Financials. Use it to list the Natures with Budget Accounts. You can later use this list to import the values registered in Budget Planning and Control for the Financial Budget.
02. EXAMPLE OF USE
Add.
In option Add, the screen below is displayed with header and Items, in which the header and a view of the Natures table (SED) of fields code and description and the items the relationship that will be registered in relationship table F73.
The Fields, Budget Account From and To have default query of table AK5, Class has default query of table AK6, Cost Center From and To have default query of table CTT, Accounting Item From and To have default query of table CTD and Value Class From and To have default query of table CTH.
Except for field Budget Account From and To, all aforementioned fields will be selected if left blank.
When you click Confirm, the routine saves the entry and no longer allows new additions for nature 001, as exemplified above. You will only be able to edit it.
You can add several lines to compose the value of the nature with the budget accounts. You cannot repeat the set of budget account plus class plus cost center plus accounting item plus value class in more than one nature.
Edit.
Option Edit displays the Natures X Budget Accounts screen, mentioned above in item Add, with the record placed in the browser for due maintenance. If the listing does not yet exist, the system notifies that you must use option Add.
View.
Option View displays the Natures X Budget Accounts screen, mentioned above in item Add, with the record placed in the browser for due viewing.
...
Imported data will always overwrite the data found in the Financial Budget register.
03. Data Structure
Table
Key | File | Name | Single key |
F73 | F73010 | Natures x Budget Accounts | F73_FILIAL+F73_NATUR+F73_ITEM |
Main Fields
Field | Description |
F73_FILIAL | System Branch Code |
F73_NATUR | Financial Nature Identification Code |
F73_DESNAT | Financial Nature Description |
F73_ITEM | Sequential Item |
F73_COINI | Initial Code of Budget Account for data import |
F73_COFIM | Final Code of Budget Account for data import |
F73_CLASSE | Nature Code for data import. When blank, all are considered. |
F73_ CCINI | Initial Code of Cost Center for data import. When blank, all are considered. |
F73_ CCFIM | Final Code of Cost Center for data import. When blank, all are considered. |
F73_ITCTBI | Initial Code of Accounting Item for data import. When blank, all are considered. |
F73_ITCTBF | Final Code of Accounting Item for data import. When blank, all are considered. |
F73_CLVRLI | Initial Code of Value Class for data import. When blank, all are considered. |
F73_CLVRLF | Final Code of Value Class for data import. When blank, all are considered. |
Validations
Field | Validation |
F73_NATUR | ExistChav("SED") |
F73_COINI | ExistChav("AK5") .AND. FIN272Vld(‘F73_CO’,INCLUI)* |
F73_COFIM | ExistChav("AK5") .AND. FIN272Vld(‘F73_CO’,INCLUI)* |
F73_CLASSE | Vazio() .or. ExistChav("AK6") |
F73_ CCINI | Vazio() .or. ExistChav("CTT").AND. FIN272Vld(‘F73_ CCINI’,INCLUI)* |
F73_ CCFIM | Vazio() .or. ExistChav("CTT").AND. FIN272Vld(‘F73_ CCFIM’,INCLUI)* |
F73_ITCTBI | Vazio() .or. ExistChav("CTD").AND. FIN272Vld(‘F73_ ITCTBI’,INCLUI)* |
F73_ITCTBF | Vazio() .or. ExistChav("CTD").AND. FIN272Vld(‘F73_ ITCTBF’,INCLUI)* |
F73_CLVRLI | Vazio() .or. ExistChav("CTH").AND. FIN272Vld(‘F73_ CLVRLI’,INCLUI)* |
F73_CLVRLF | Vazio() .or. ExistChav("CTH").AND. FIN272Vld(‘F73_ CLVRLF’,INCLUI)* |
*Function FIN272Vld() will be responsible for all field validations
Index.
Index | Order | Key | Description |
F73_FILIAL | 1 | F73_FILIAL+F73_NATUR+F73_ITEM | Nature + Item |
Triggers.
Field | Seq | Rule | Key | Condition | Alias |
F73_NATUR | 001 | M->F73_DESNAT:=SED->ED_DESCRIC | xFilial("SED")+M->F73_NATUR | !EMPTY(M->F73_NATUR) | SED |
IMPORTANT!
It is Important to apply package 008342 and add routine to menu.
| Card documentos | ||||
|---|---|---|---|---|
|
...
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas