Import/Export Transaction Fields

Related Information

Transaction Fields

These are the Data Fields that are associated with the Transaction Record.

Each Data Field has its own FIELD INDEX within the record. Each Data Field has a set maximum character WIDTH as well as the TYPE of data the field can contain.

The Transaction record also has fields that contain different Sub Indexes. The Sub Index relates to a subform on the Transaction. Refer to the Sub Index Appendix.

The Transaction record also contains Virtual Links which can be used to append the Transaction to the correct Debtor.

Transaction Field Types
Field	Record	Field index	Sub index	Type	Width	Description
Debtor	Transaction	0	8	String	62	Debtor account transaction pertains to
Type	Transaction	3	8	String	10	The type of transaction
Payment	Transaction	4	8	Integer	1	Indicates a payment
Interest	Transaction	5	8	Integer	1	Indicates interest
Fee	Transaction	6	8	Integer	1	Indicates fee
Adjustment	Transaction	7	8	Integer	1	Indicates adjustment
Principal	Transaction	8	8	Integer	1	Indicates principal
To us	Transaction	9	8	Double	15	Amount paid to the agency
Direct	Transaction	10	8	Double	15	Amount paid to the Client
Disbursement	Transaction	11	8	Double	15
Description	Transaction	12	8	String	126	The description of the transaction
Payment date	Transaction	13	8	Long	8	The date of the payment as MM/DD/YYYY
Posted date	Transaction	14	8	Long	8	The date payment was posted as MM/DD/YYYY
Operator	Transaction	15	8	String	8	The collector who is credited with the transaction
Sales	Transaction	16	8	String	8	The sales team credited with the transaction
Commission rate	Transaction	17	8	Double	8	Commission rate for the transaction
Commission amount	Transaction	18	8	Double	15	The dollar amount of the commission
Tax rate	Transaction	19	8	Double	8	Tax rate for tax charged on commission
Tax	Transaction	20	8	Double	15	The amount of tax charged on the commission
User 1	Transaction	21	8	String	31	User field
User 2	Transaction	22	8	String	31	User field
User 3	Transaction	23	8	String	31	User field
User 4	Transaction	24	8	String	31	User field
User 5	Transaction	25	8	String	31	User field
User 6	Transaction	26	8	String	31	User field
Attachment	Transaction	27	8	String	31	Name of file attached to transaction
Omit from client statement	Transaction	28	8	Integer	1	Indicates omit from statement
Omit from daily cash report	Transaction	29	8	Integer	1	Indicates don't include in daily cash report
Don't calculate commission	Transaction	30	8	Integer	1	Indicates no commission calculation
Don't calculate tax	Transaction	31	8	Integer	1	Indicates no tax calculation
Currency	Transaction	32	8	Long	8	Currency payment was made in
To currency	Transaction	33	8	Long	8	Client's statement currency
Exchange rate	Transaction	34	8	Double	15	Exchange rate when transaction is posted
To principal	Transaction	35	8	Double	15	Amount assigned to debtor's principal
To interest	Transaction	36	8	Double	15	Amount assigned to debtor's interest
To fees	Transaction	37	8	Double	15	Amount assigned to debtor's fees
Receipt number	Transaction	38	8	Long	10	Receipt number assigned to transaction
Invoice number	Transaction	39	8	Long	10	Invoice number assigned to transaction
UID	Transaction	40	8	Long	7
Return	Transaction	41	8	Double	15
Financial type	Transaction	44	8	Integer	4
To legal	Transaction	45	8	Double	15
To misc	Transaction	46	8	Double	15
To other	Transaction	47	8	Double	15
To adjustment	Transaction	48	8	Double	15
Use confirmation delay	Transaction	55	8	Integer	1
Deposited	Transaction	56	8	Long	8
Confirmed	Transaction	57	8	Long	8
Confirmation #	Transaction	58	8	String	63
C1	Transaction	66	8	Integer	4
C2	Transaction	67	8	Integer	4
C3	Transaction	68	8	Integer	4
Created	Transaction	69	8	Long	8
Created time	Transaction	70	8	Long	8
Posted by	Transaction	71	8	String	7
Modified	Transaction	72	8	Long	8
Mtime	Transaction	73	8	Long	8
Mby	Transaction	74	8	String	7
User 7	Transaction	88	8	String	63
Commission Rate 1	Transaction	89	8	Double	9
Commission Rate 2	Transaction	90	8	Double	9
Commission Rate 3	Transaction	91	8	Double	9
Tax Rate 1	Transaction	92	8	Double	9
Tax Rate 2	Transaction	93	8	Double	9
Tax Rate 3	Transaction	94	8	Double	9
Ctime	Transaction	9	165	Long	8
Cby	Transaction	10	165	String	7
Principal	Transaction	0	166	Double	9
Interest	Transaction	2	166	Double	9
Fee	Transaction	3	166	Double	9
Other	Transaction	4	166	Double	9
Legal	Transaction	5	166	Double	9
Misc	Transaction	6	166	Double	9
Adjustment	Transaction	7	166	Double	9
Comm Princ	Transaction	8	166	Double	9
Comm Interest	Transaction	9	166	Double	9
Comm Fees	Transaction	10	166	Double	9
Comm Legal	Transaction	11	166	Double	9
Comm Misc	Transaction	12	166	Double	9
Comm Other	Transaction	13	166	Double	9
Princ Tax	Transaction	14	166	Double	9
Int Tax	Transaction	15	166	Double	9
FeeTax	Transaction	16	166	Double	9
Legal Tax	Transaction	17	166	Double	9
Misc Tax	Transaction	18	166	Double	9
Other Tax	Transaction	19	166	Double	9
Tax Amount	Transaction	25	166	Double	9
Debtor exchange rate	Transaction	0	173	Double	9
Actual	Transaction	1	173	Double	9
Actual currency	Transaction	2	173	Long	8
Debtor currency	Transaction	3	173	Long	8
Posted	Transaction	6	173	Long	8
Agency exchange rate	Transaction	8	173	Double	9
To agency	Transaction	9	173	Double	9
Agency account currency	Transaction	10	173	Long	4
To us	Transaction	11	173	Integer	1
Direct	Transaction	12	173	Integer	1

Transaction Sub Index Appendix
Sub Index Number	Form/Tab	Sub Index Number	Form/Tab
Sub Index 8	Transaction	Sub Index 166	Breakdown
Sub Index 165	Trans Detail	Sub Index 173	Multi Currency

Virtual Links	If you use one of these virtual fields in your import, make sure that 'Use as key to find existing' is switched OFF (no check mark).
Field	Record	Field index	Sub index	Type	Width	Description
*File	Transaction	2	8	Long	9	The Collect! file number of the Debtor
*Contact	Transaction	1	8	String	62	Contact person for debtor
*Home Phone	Transaction	59	8	String	23	Debtor's home phone
*Work Phone	Transaction	60	8	String	14	Debtor's work phone
*Client Account #	Transaction	61	8	String	31	Reference number assigned by the Client
*DL	Transaction	62	8	String	31	Debtor's driver's license
*SSN	Transaction	63	8	String	31	Debtor's social security number
+Paid	Transaction	64	8	Double	15
+Owing	Transaction	54	8	Double	15
+Owing before transaction	Transaction	42	8	Double	15
+Owing after transaction	Transaction	43	8	Double	15
**Client	Transaction	65	8	Long	8	The Client that the Debtor is assigned to

Notes:

* These fields are fields from related records.
** For efficiency, use only for exporting.
+ Collect! automatically calculates this value from the transactions. Use only for export.

Transaction Fields

See Also