Importing Transaction Sessions
Note: When importing transactions, the system appends to current records. If you get a partial import, you must delete the session before trying the import again.
Depending on the format of the data file, either use the MasterT1.DEF or MasterT3.DEF file for importing Sessions and Transactions from other software programs. If the session, document, and transaction information appears on every line, use T3. If the session, document, and transaction information appears on separate lines in the data files, use T1.
You are required to define the same data in the import file as you would when entering transactions directly into the system.
Note: Segments (such as Fund or GL) have to be set up in the system prior to Import. Segments are established when the organization is created. As the Administrator, to view these settings use the Organization>Organization Information form.
Although you are not required to have a cash account included in a transaction entry line for CD or APC documents for the Import process, a cash account is required by the system in the user interface. Therefore, when you access imported CD or APC documents through the system and make changes, the cash account on the check must match the cash account on the session. Otherwise, you cannot save the changes.
Multicurrency Users
The SESSION_CURRENCY_TYPE and SESSION_RATE_TYPE fields are only available if this module is installed and added to the organization by the Administrator (Organization>Add a Module).
The following table defines the field references to be used in the Sessions Header Information section of the MasterT1.DEF and MasterT3.DEF files. The field IDs are used with both fixed-width and CSV formatted data files.
| Table: tblTESession | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,SESSION,HEADER,HSESSN | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
SESSION_ |
Y |
14 |
Session ID |
|
|
SESSION_STATUS |
Y |
2 |
BP |
BP (Batch-To Post) or BS (Batch-To Suspend) |
|
SESSION_ |
Y |
3 |
Active or inactive Currency code. |
|
|
SESSION_RATE_ |
Y |
3 |
DSR (Daily Spot Rate) or MAR (Monthly Average Rate) |
|
|
SESSION_ |
Y |
User Defined |
Required for Enter Encumbrances only. |
|
|
SESSION_ |
Y |
Date |
Current Date |
Can be 6, 8, or 10 digit date. |
|
SESSION_ |
N |
60 |
Required if BD Transaction Source. If the Budget Version, in the data file, does not already exist in the system, it will be added to the budget version ID list during the Import process. |
|
|
SESSION_ |
Y |
3 |
Transaction Source Codes: JV, CD, CR, BD, ENC, ENL, API, APM, APC, ARB, ARM, ARP, or ARC only. See Table 1. |
|