Importing Transaction Lines
The following section defines the field references used in the Transaction Information section of the *.DEF file. You are required to define the same data in the import file as you would when entering transactions directly into the system.
| Table: tblTETrans | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,TRANSENTRY,DETAIL,DDOC | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
TETRANS_SESSION |
Y |
14 |
Session ID |
|
|
TETRANS_DOCNUM |
Y |
User Defined |
No |
Document Number |
|
TETRANS_ |
Y |
User Defined |
Document Description |
Transaction Description |
|
TETRANS_ENTRY_ |
Y |
2 |
N |
Normal (N), Beginning Balance (UO), Adjust Opening Balance (AO), or End of Year Adjustment (A). |
|
TETRANS_ |
Y |
Date |
Document Date |
Can be 6, 8, or 10 digit date. |
|
TETRANS_SEGMENT_ |
Y |
User Defined |
Replace {segment name} with the actual segment name (one line in *.DEF file for each). |
|
|
TETRANS_DEBIT |
Y |
Currency |
0.00 |
Debit Amount |
|
TETRANS_CREDIT |
Y |
Currency |
0.00 |
Credit Amount |
|
TETRANS_1099BOX |
Y |
2 |
1099 Box Number. Only applies to CD, API, APC, or APM, if Vendor is set to 1099. See Table 2. |
|
|
TETRANS_MATCH_ |
N |
User Defined |
N |
Original Invoice, Encumbrance, or Receipt Number. Required for APM, APC, ARM, ARC, and ENL. See Table 1. |
|
TETRANS_MATCH_ |
Y |
Original Invoice. Required for ARC. See Table 1. |
||
|
TETRANS_CREDIT_ |
Y |
0.00 |
The way a credit (such as C, CR, or Credit) is identified in the data. |
|
|
TETRANS_DEBIT_ |
Y |
0.00 |
The way a debit (such as D, DR, or Debit) is identified in the data. |
|
|
TETRANS_AMOUNT_ |
Y |
0.00 |
Identifies the transaction flags, such as Debit_Flag or Credit_Flag. |
|
Note: You cannot use more than one entry type (TETRANS_ENTRY_TYPE) within a session.