ArchiveData configuration
The ArchiveData configuration stores settings for the Archive Billing Data task in
the Batch Manager. See the Infor Public Sector Batch
Processing Administration Guide for more information.
The root node has two children: and . The node has these attributes:
| Attribute | Description |
|---|---|
| Archive Table Prefix | Prefix that will be used for the names of the archive tables. |
| Archive Table Suffix | Suffix that will be used for the names of the archive tables. |
| Log Type | Type of log entry to add to an account when its transactions are archived. |
| Schema Name | Schema that the archive tables will be assigned to. |
The node has one or more nodes as children. Each node has one attribute:
| Attribute | Description |
|---|---|
| Root Table | Fully qualified name of the root table. |
Each node has one or more nodes as children. Each node can have these attributes:
| Attribute | Description |
|---|---|
| Cardinality | Cardinality of the table to the parent table. Options are OneToOne, OneToMany, ManyToOne, and ManyToMany. |
| DML Action | Action that will be completed for this table. Options are Delete, Update, and Exclude. |
| Parent Table Name | Name of the parent table. |
| Sql Query | SQL query that the Archive Billing Data task will run. |
| Table Name | Name of the table that will be updated. |