User Tools

Site Tools


business:import_jv_transactions

Import JV Transactions File Layout

This file layout is used to import general journal transactions.

Field Length Class Codes
Account Code20
Appropriation Amount116, 8
Expenditure Amount116, 8
Estimated Revenue Amount115, 7
Realized Revenue Amount115, 7
Balance Amount111, 2, 3
Journal Voucher Number6
JV Number Description30
JV Voucher Reason30
General Ledger Account Description30

Notes:

This is a comma-delimited file format, which means that commas are not allowed within a field. For example, there should not be any commas in the JV Number Description or the GL Account Description fields.

For amounts, decimal places not implied. For example, 6789 indicates $6,789, and 67.89 indicates $67.89. Eleven numeric characters can be entered with two decimal places, or when whole number are entered, nine numeric characters are allowed.

Credit amounts should start with a minus sign (e.g., -).

Amount fields with no data should be empty in the file; do not use zeros.

Newly created accounts will be validated by each component within the Finance > Tables > Account Codes tabs and will contain the same edits as found on the Finance > Maintenance > Create Chart of Accounts page.

business/import_jv_transactions.txt ยท Last modified: 2018/07/24 12:21 (external edit)

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.