Transaction File Format
© 2012 Comtech Systems Inc. All rights reserved.
The following file format listing contains basic information about the
file specification for import purposes. For more information about the file
layout please refer to the actual file format specification in Collect!.
Choose Import/Export from the File menu and select Specify File
Format.
File Format Details
Name: Transaction
Note: Import Transactions
File: ..\import\transaction.csv
CSV: X
Record Layouts
The list on the left contains the record types that this file format
works with.
If there is more than one record definition in an import specification then
each record type requires its own unique identifier. The identifier is
typically the first field exported on the line containing the record.
For each record type a list of fields is shown listing the database
field name, the length (for fixed length records), a short note,
a default value and the accumulator ID. Check the on line help in
Collect! for more information.
Keyed fields are indicated with an asterisk [*], and are used to
avoid duplication of data and to make sure data is attached to
the correct Client or Debtor.
Debtor Record Layout
- Record Name: Debtor
- Note: Import Debtor Information
- ID:
Debtor fields
The following fields are included in this record definition.
Offset and length are only significant in fixed length files. If a length
is displayed for CSV files it can safely be ignored.
For information about the actual field widths in Collect! check the
Import Export menu Field Definitions option for a comprehensive list
of all fields, their data type and size.
| Count |
Field Name |
Offset |
Length |
Notes |
Default Value |
Accumulator |
| 1 |
*Client number |
|
|
A - Client Number |
|
|
| 2 |
*Acct |
|
|
B - Debtor Account Number |
|
|
Transaction Record Layout
- Record Name: Transaction
- Note: Import Transaction Information
- ID:
Transaction fields
The following fields are included in this record definition.
Offset and length are only significant in fixed length files. If a length
is displayed for CSV files it can safely be ignored.
For information about the actual field widths in Collect! check the
Import Export menu Field Definitions option for a comprehensive list
of all fields, their data type and size.
| Count |
Field Name |
Offset |
Length |
Notes |
Default Value |
Accumulator |
| 1 |
|
|
|
A - Field skipped |
|
|
| 2 |
|
|
|
B - Field skipped |
|
|
| 3 |
Type |
|
|
C - Transaction type (3 digit code) |
|
|
| 4 |
To us |
|
|
D - Amount of transaction with agency |
|
|
| 5 |
Direct |
|
|
E - Amount of transaction with Client |
|
|
| 6 |
Commission amount |
|
|
F - Commission amount |
|
|
| 7 |
Payment date |
|
|
G - Payment Date (format: MM/DD/YYYY) |
|
|
| 8 |
Posted date |
|
|
H - Posted Date (format: MM/DD/YYYY) |
|
|
| 9 |
Operator |
|
|
I - Operator ID |
|
|
| 10 |
Sales |
|
|
J - Sales ID |
|
|
| 11 |
User 1 |
|
|
K - User-defined field 1 |
|
|
| 12 |
User 2 |
|
|
L - User-defined field 2 |
|
|
| 13 |
User 3 |
|
|
M - User-defined field 3 |
|
|
| 14 |
User 4 |
|
|
N - User-defined field 4 |
|
|
| 15 |
User 5 |
|
|
O - User-defined field 5 |
|
|
| 16 |
User 6 |
|
|
P - User-defined field 6 |
|
|
| 17 |
Attachment |
|
|
Q - Attachment (File name with full path |
|
|
| 18 |
Receipt number |
|
|
R - Receipt Number |
|
|
| 19 |
Invoice number |
|
|
S - Invoice Number |
|
|
End of Transaction file format specification.
See Also
- Import/Export Topics
| 
Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.
Please click this link to send us your comments: helpinfo@collect.org