The TABS_CM3.DTA and CM3_TABS.DTA files are used to import Tabs3 Client information to and from third party practice management systems. Both files use the same format.

TABS_CM3.DTA Contains the information from Tabs3 for importing into a third party practice management system. The Tabs3 Client file and Transfer all Client Information to Practice Management program create this file.
CM3_TABS.DTA Contains the information from a third party practice management system for importing into Tabs3. The Merge Practice Management Client Changes program imports this file.

Note: These interface files need to be deleted after being read to avoid duplication of entries.

The following information shows the field descriptions and lengths of the required fields used by each record in the interface files. The first byte of each record indicates if the record is a new addition (A) or if the existing record contains changes (C). The Type column indicates A=alphanumeric or N=numeric.

Field                                       Type Length  Start
-----                                       ---- ------  -----
Operation (A=add, C=change)                    A      1      1
Client ID (ex. 200.03) (Right Justified)       A     12      2
Client Name                                    A     50     14
Work Description*                              A     50     64
Address Line 1*                                A     35    114
Address Line 2*                                A     35    149
Address Line 3*                                A     35    184
City*                                          A     20    219
State                                          A      3    239
Zip                                            A     10    242
Primary Timekeeper (0 PADDED)                  N      3    252
Secondary Timekeeper (0 PADDED)                N      3    255
Originating Timekeeper (0 PADDED)              N      3    258
Category (0 PADDED)                            N      3    261
Contact Name*                                  A     25    264
Work Phone Number                              A     12    289
Filler (1 space)                               A      1    301
Misc Line 1*                                   A     35    302
Misc Line 2*                                   A     35    337
Misc Line 3*                                   A     35    372
Open Date (MMDDYYYY) (blank = no date)         N      8    407
Other Phone Number                             A     12    415
Filler (1 space)                               A      1    427
Close Date (MMDDYYYY) (blank = no date)        N      8    428
Cr/Lf CHR$(13)+CHR$(10)                        A      2    436
                                                           ===
                                            Record length  437

Note: Multiple Tabs3 field lengths have been increased since this format was created. To ensure compatibility with existing import/export processes, records in Tabs3 with field values larger than the specified limits will be trimmed to the limits shown. Fields with a maximum length that is greater than the value shown are indicated by an “*” (asterisk).