You can abbreviate table names in S41 and M41 formats. Here is a list of table name abbreviations:
Table Name |
Abbreviation |
borrower |
bt |
borrower_barcode |
bb |
borrower_address |
ba |
borrower_phone |
bp |
borrower_bstat |
bs |
borrower_image |
bi |
header1.txt
x– bt(1).name; bt(1).second_id; bb(1).bbarcode; ba(1).address_type; ba(1).mail_sort_type;
ba(1).address1; ba(1).address2; bi(1)
data1.txt
M-Bown, Alisa; 859-08-3798; 23124000009085; 0; dom; 1882 Columbia Lane; Orem UT 84058
M-Jensen, Dave; 338-96-9754; 23124000009098; 0; dom; 90 S 2025 N Orem UT; 84058; C:\Users\Administrator\My Pictures\9085.jpg
header2.txt
x– bt(1).name[20] bt(1).second_id[12]bb(1).bbarcode[15] ba(1).address_type[2] ba(1).mail_sort_type[5] ba(1).address1[20] ba(1).address2[20] ba(2).address_type[7] ba(2).mail_sort_type[5] ba(2).address1[21] ba(2).address2[20]
data2.txt
M Bown, Alisa 809-76-7432 23124000009085 1 dom 1882 S Columbia Ln Orem UT 84058 0 dom 18743 Fairfax Drive Farmington MI 48660
M Jensen, Dave 759-89-2234 23124000009098 1 dom
90 S 2025 N Orem UT 84058 0 dom 1660 Oak Place Nashville TN 59901
© 1998-2017 Sirsi Corporation