Import/Export Phone Fields

Examples & Tutorials

Use Import/Export Create A Single Record Import Map Create A Fixed Length Import Map Create An Import Map Use A Custom Import Routine Get Help With Import/Export Order Custom Import/Export Routines Attach Credit Reports To Debtor Accounts Import Inter Office Files Import From Different File Formats Set Default Values For Imports Batch Process Accounts After Importing

Phone Fields

These are the Data Fields that are associated with the Phone 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.

Phone Field Types
Field	Record	Field index	Sub index	Type	Width	Description
UID	Phone	0	170	Long	8	*** Internal Use Only
Position	Phone	2	170	Integer	11	Home, POE# etc.
Phone number	Phone	3	170	String	23	Phone number
Extension	Phone	4	170	String	5	Phone extension
Active	Phone	5	170	Integer	9	Active Yes/No
Date	Phone	6	170	Long	8	Last called Date
RPC	Phone	7	170	Integer	1	Right party contact
Owner	Phone	8	170	Integer	25	Owner of number
Last result	Phone	9	170	Integer	14	Last result pick list
Timezone	Phone	10	170	Integer	18	Time zone
Source	Phone	11	170	Integer	29	Source for number
SMS	Phone	14	170	Integer	1	SMS
Invalid number	Phone	15	170	Integer	1	Number is invalid
Do not call	Phone	16	170	Integer	1	Do not call this number
Not in service	Phone	17	170	Integer	1	Number is Not in service
Time	Phone	18	170	Long	8	Last called Time
NIS ID	Phone	19	170	Integer	12	NIS ID pick list
NIS Reason	Phone	20	170	Integer	21	NIS reason pick list
Created	Phone	21	170	Long	8	*** Internal Use Only
Created By	Phone	22	170	String	4	*** Internal Use Only
Created time	Phone	23	170	Long	8	*** Internal Use Only
Modified	Phone	24	170	Long	8	*** Internal Use Only
Modified by	Phone	25	170	String	4	*** Internal Use Only
Modified time	Phone	26	170	Long	8	*** Internal Use Only

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
*Debtor name	Phone	1	170	String	62	Debtor name

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.

Phone Fields

See Also