About Reconciliation Attribute File Format Rules
The attribute input file is indexed by the segments with one row per reconciliation. The columns may vary depending on which attributes you want to update.
Column (Attribute) | UI Export Option | Pending Reconciliation Status | Open Reconciliation Status | Closed Reconciliation Status |
---|---|---|---|---|
Segment <n> | <Default> | No | No | No |
Account Name | Name | Yes | Yes | Yes |
Description | Description | Yes | Yes | Yes |
Process | Process | Yes | Yes | Yes |
Organizational Unit | Organizational Unit | Yes | Yes | Yes |
Risk Rating | Risk Rating | Yes | Yes | Yes |
Account Type | Account Type | Yes | Yes | Yes |
Instructions | Instructions | Yes | Yes | Yes |
Normal Balance | Normal Balance | Yes | No | No |
Auto Recon Method | Auto Reconciliation Method | Yes | No | No |
Auto Recon Bal Low | Auto Reconciliation Method | Yes | No | No |
Auto Recon Bal High | Auto Reconciliation Method | Yes | No | No |
Auto Recon Threshold Number | Auto Reconciliation Method | Yes | No | No |
Auto Recon Threshold Percent | Auto Reconciliation Method | Yes | No | No |
Max Age Adjustments | Maximum Age Adjustments | Yes | No | No |
Max Age Explanations | Maximum Age Explanation | Yes | No | Yes |
Manual Balance Source System | Enter Source System Balances | Yes | Yes | Yes |
Manual Balance Subsystem | Enter Subsystem Balances | Yes | Yes | Yes |
Preparer | Preparer | Yes | Yes | Yes |
Preparer Backup | Preparer | Yes | Yes | Yes |
Preparer Require Action By | Preparer | Yes | Yes | Yes |
Start Date | Preparer | Yes | No | No |
Duration | Preparer | Yes | Yes | Yes |
Reviewer <n> | Reviewer | Yes | Yes | Yes |
Reviewer Backup <n> | Reviewer | Yes | Yes | Yes |
Reviewer Duration <n> | Reviewer | Yes | Yes | Yes |
Commentator | Commentator | Commentator | Commentator | Commentator |
Viewer | Viewer | Viewer | Viewer | Viewer |
Historical Rate | Historical Rate | Yes | No | No |
Rate Type | Rate Type | Yes | No | No |
Attribute 1 | <Custom Attribute> | Yes | Yes | Yes |
Attribute Value 1 | <Custom Attribute> | Yes | Yes | Yes |
Attribute Access 1 | <Custom Attribute> | Yes | Yes | Yes |
Attribute Attachment Access 1 | <Custom Attribute> | Yes | Yes | Yes |
Attribute Copy To Profile 1 | <Custom Attribute> | Yes | Yes | Yes |
Enable Currency Bucket 1 | Currency Bucket Enabled (Entered) | Yes | No | No |
Default Currency Bucket 1 | Currency Bucket Default Currency (Entered) | Yes | Yes | Yes |
Enable Currency Bucket 2 | Currency Bucket Enabled (Functional) | Yes | No | No |
Default Currency Bucket 2 | Currency Bucket Default Currency (Functional) | Yes | Yes | Yes |
Enable Currency Bucket 3 | Currency Bucket Enabled (Reporting) | Yes | No | No |
Default Currency Bucket 3 | Currency Bucket Default Currency (Reporting) | Yes | Yes | Yes |