Displaying Debit and Credit Columns

The DRCRSplit expression is used to parse split numeric columns . By default, Data Management assumes that numeric values in Amount fields are debits. However, you can position debit values on the left and credit values on the right.

Table 4-5 DRCRSplit expression example

Account Number	Description	Debit	Credit
1000-000-00	Cash-Operating Account	68,603.91
1010-000-00	Cash-FANB-AP		177,216.16

DRCRSplit, which enables Data Management to interpret left-right positioning and to assign the correct sign, follows the format DRCRSplit=Mid Point of the DR and CR columns.

When the file is imported, credit amounts are assigned negative signs (and thus are interpreted as positive), and debit amounts are unchanged (and thus are interpreted as negative).