Archive / Delete Integration Elements and Integration Transactions (tfgld4283m000)
Use this session to clear up the database after the integration transactions are posted.
A large amount of logged data that is no longer needed can have a negative impact on the performance of the processes that handle integration transactions and reconciliation transactions. To save space and avoid a possible low performance, at regular intervals you can run this session. All integration transactions and their mapping elements within the selection that have the Posted status are archived and/or deleted depending on the selected options.
After the transactions are posted, the transactions details are no longer needed. The logistic data required for inquiries, reporting, and reconciliation is stored separately in the Reconciliation Data (tfgld495) table which you can view in the Operations Management - Financial Reconciliation (tfgld4595m000) session.
The mapping elements reflect logistic data. If the logistic data changes, for example, if item codes or projects expire or you redefine the order types, you cannot at a later stage create a correction integration transaction or remap the integration transactions. In such a situation, you can archive the mapping elements.
If the master data has not yet been archived, it is recommended that you also archive the master data. For details, refer to Using an archive company.
Field Information
- Delete or Archive
-
- Type of Process
-
Specify whether the integration elements and integration transactions data can be archived or deleted.
Allowed values
- Delete Only
-
Deletes the selected data.
- Archive Only
-
Copies the selected data to an archive company.
- Archive and Delete
-
Copies the selected data to an archive company and deletes from the original company.
- Selection Range
-
- Business Object Company
- The From and To fields define a range of: logistic companies in which the processed integration transactions originate.
- Financial Company
- The From and To fields define a range of: financial companies in which the processed integration transactions originate.
- Integration Document Type
- The From and To fields define a range of: integration document types of the processed integration transactions.
- Transaction Type
- The From and To fields define a range of: transaction types associated with the processed integration transactions.
- Based on Period
- If this check box is selected, the processed integration transactions are archived or deleted based on the period.
- Up to Transaction Date
- The date and time up to which the
integration elements and integration transactions are archived or
deleted.Note: This field is enabled only if the Based on Period check box is cleared.
- Up to Fiscal Period
- The fiscal year up to which integration elements and transactions must be archived or deleted.
- Period
- The period of the fiscal year up to which the integration elements and transactions must be archived or deleted.
- Options
-
- Archive Option
-
The type of archive action that must be performed on the integration elements and transactions.
Allowed values
- Only Integration Elements
- Infor LN only archives (or deletes) the integration elements.
- Both Integration Trans. and Elements
- Infor LN archives (and deletes) both the integration transactions and intergation elements.
- Delete also retained elements
- If this check box is selected, the
elements that are retained during the archive or delete process are also
deleted.Note: This field is enabled only if:
- The Type of Process field is set to Delete Only or Archive and Delete.
- The Archive Option field is set to Only Integration Elements.
- From Reconciliation Group
-
The From and To fields define a range of: reconciliation groups of which the integration elements and the integration transactions must be archived or deleted.
Allowed values
- Inventory
- Consigned/Customer Owned Inventory
- Invoice Accrual
- Consigned/Customer Owned Accrual
- Borrow/Loan Accrual
- Production Order WIP
- Production Schedule WIP
- Project (PCS) WIP
- Assembly Order WIP
- Assembly Line WIP
- Service Order WIP
- Service Call WIP
- Maintenance Sales Order WIP
- Maintenance Work Order WIP
- Purchase Order WIP
- Purchase Schedule WIP
- Project (TP) WIP
- Project Provisional Revenues
- Work Cell Cost Document WIP
- Inventory WIP
- Interim Costs
- Interim Revenues
- Interim Contract
- Interim Variance
- Interim Transit
- Interim Customer Claim
- Interim Supplier Claim
- Commitments
- End Account
- Not Applicable
Note: This field is enabled only if:- The Type of Process field is set to Delete Only or Archive and Delete.
- The Archive Option field is set to Only Integration Elements.
- Reconciliation Sub Area
- The From and To fields define a range of:
reconciliation subarea of the reconciliation
group for which the integration elements and integration
transactions data must be archived or deleted.Note: This field is enabled only if:
- The Type of Process field is set to Delete Only or Archive and Delete.
- The Archive Option field is set to Only Integration Elements.
- Archive Text
-
If this check box is selected, LN archives the texts related to the archive or delete process.
Note: This field is enabled only if the Type of Process field is set to Archive Only or Archive and Delete. - Overwrite Text
-
If this check box is selected, LN overwrites the texts related to the archive or delete process.
- Print Options
-
- Statistics
- If this check box is selected, Infor LN prints the statistics related to the archive or delete process.