Credit/Debit

In data files, debits and credits can appear in one of the following ways:

Different Positions

In the following example, debits and credits appear in positions 9 (for the first two lines) and 10 (for the last two lines):

CSV Data File Sample

Detail,01-101-11000,,,100,,100801,200114,125.36,0

Detail,01-101-11000,,,,,100801,200114,1800.00,0

Detail,01-101-40001-101-101-1,,,100,,100801,200114,0,125.36

Detail,01-101-40001-101-101-1,,,,,100801,200114,0,1800.00

CSV *.DEF File Sample

TETRANS_DEBIT,9,0,,,,0

TETRANS_CREDIT,10,0,,,,0

Same Position—Distinguished by - and +

In the following example, debits and credits appear in the same position (6) and credits are distinguished by a minus (-) sign:

CSV Data File Sample

07/18/01,From United Methodist,2,0110111001,,100.00

07/18/01,From United Methodist,2,01101400011011011,,-100

07/18/01,From United Methodist,2,0110111001,,25.00

07/18/01,From United Methodist,2,01101400011011011,,-25

07/18/01,From United Methodist,2,0110111001,,35.00

07/18/01,From United Methodist,2,01101400011011011,,-35

CSV *.DEF File Sample

TETRANS_DEBIT,6,0,,,,0

TETRANS_CREDIT,6,0,,,,0

Same Position—Distinguished by Debit or Credit

In the following example, debits and credits appear in the same position (3) and are distinguished by a letter or series of letters that is clearly described in the definition file.

However credit (such as C, CR, or Credit) and debit (such as D, DR, or Debit) are identified in the data file, must match the TETRANS flag in the *.DEF file.

CSV Data File Sample

01-101-40001-101-101-1,04/06/2001,C,10.00,,FASE Dean's Fund-Cash,

01-101-11001,04/06/2001,D,10.00,,FASE Dean's Fund-Cash,

01-101-40001-101-101-1,04/06/2001,C,10.00,,Night in New Orleans-Cash,

01-101-11001,04/06/2001,D,10.00,,Night in New Orleans-Cash,

CSV *.DEF File Sample

TETRANS_CREDIT_FLAG,C

TETRANS_DEBIT_FLAG,D

TETRANS_AMOUNT_INDICATOR,3,D

TETRANS_DEBIT,4,,,,,0

TETRANS_CREDIT,4,,,,,0

The definition file must contain all five of these lines. Notice that the amount indicator contains a D. Because the D is in the third position, the system defaults to debit.

Note: If a fixed-width data file is used, the TETRANS_AMOUNT_INDICATOR must include the position, length, and default.