Attachment 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: Attachment
Note: Import Attachments
File: ..\import\attachment.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 |
|
|
Attachment Record Layout
- Record Name: Attachment
- Note: Import Attachment Information
- ID:
Attachment 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 |
Class |
|
|
C - Class |
|
|
| 4 |
Type |
|
|
D - Type |
|
|
| 5 |
Description |
|
|
E - Description |
|
|
| 6 |
Index 1 |
|
|
F - Index 1 |
|
|
| 7 |
Index 2 |
|
|
G - Index 2 |
|
|
| 8 |
Date 1 |
|
|
H - Date 1 |
|
|
| 9 |
Date 2 |
|
|
I - Date 2 |
|
|
| 10 |
Date 3 |
|
|
J - Date 3 |
|
|
| 11 |
Value |
|
|
K - Value |
|
|
| 12 |
Factor |
|
|
L - Factor |
|
|
| 13 |
Credits |
|
|
M - Credits |
|
|
| 14 |
Debits |
|
|
N - Debits |
|
|
| 15 |
Result |
|
|
O - Result |
|
|
| 16 |
User 8 |
|
|
P - User 8 |
|
|
| 17 |
User 9 |
|
|
Q - User 9 |
|
|
| 18 |
User 10 |
|
|
R - User 10 |
|
|
| 19 |
User 11 |
|
|
S - User 11 |
|
|
| 20 |
User 12 |
|
|
T - User 12 |
|
|
| 21 |
User 13 |
|
|
U- User 13 |
|
|
| 22 |
User 14 |
|
|
V - User 14 |
|
|
| 23 |
User 15 |
|
|
W - User 15 |
|
|
| 24 |
User 16 |
|
|
X - User 16 |
|
|
| 25 |
User 17 |
|
|
Y - User 17 |
|
|
| 26 |
User 18 |
|
|
Z - User 18 |
|
|
| 27 |
User 19 |
|
|
AA - User 19 |
|
|
| 28 |
User 20 |
|
|
AB - User 20 |
|
|
| 29 |
User 21 |
|
|
AC - User 21 |
|
|
| 30 |
File |
|
|
AD - File name (with full path) |
|
|
| 31 |
Created By |
|
|
AE - Created by ID |
|
|
End of Attachment file format specification.
See Also
- Import/Export Topics
| 
Please click this link to send us your comments: helpinfo@collect.org