Debtor Cosigner 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: Debtor Cosigner
Note: Import Debtor Cosigners
File: ..\import\cosigner.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 Cosigner Record Layout
- Record Name: Debtor Cosigner
- Note: Import Cosigner Information
- ID:
Debtor Cosigner 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 |
Debtor Cl Acct |
|
|
A - Key used to find Debtor with same Ac |
|
|
| 2 |
Name |
|
|
B - Cosigner Name |
|
|
| 3 |
Address |
|
|
C - Address |
|
|
| 4 |
Address 2 |
|
|
D - Second Address Line |
|
|
| 5 |
City |
|
|
E - City |
|
|
| 6 |
State |
|
|
F - State |
|
|
| 7 |
ZIP |
|
|
G - Postal Code |
|
|
| 8 |
Home |
|
|
H - Home Phone |
|
|
| 9 |
Work |
|
|
I - Work Phone |
|
|
| 10 |
Other |
|
|
J - Other Phone |
|
|
| 11 |
Cell |
|
|
K - Cell Phone |
|
|
| 12 |
Email |
|
|
L - Email Address |
|
|
| 13 |
SSN |
|
|
M - SSN |
|
|
| 14 |
DL |
|
|
N - Driver's License |
|
|
| 15 |
DOB |
|
|
O - Date of Birth |
|
|
| 16 |
Class |
|
|
Set Class to Cosigner |
Cosigner |
|
End of Debtor Cosigner 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