CU_Phone CU Phone Mirror Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/CU"+%C$+"/CU_Phone.M4T"
KPRIMARY: PhoneID
KCOMPANY: ARDivisionNo+CustomerNo
KPERSON: ARDivisionNo+CustomerNo+ContactCode
KCOMPANYID: CompanyID
KPERSONID: PersonID
KUPDATED: Updated
KPHONENO: AreaCode+PhoneNumber+PhoneID
KCOMPANYPHONETYPE: ARDivisionNo+CustomerNo+Type+PhoneID
KPERSONPHONETYPE: ARDivisionNo+CustomerNo+ContactCode+Type+PhoneID
Fld Column Name M/L TUR Description/Notes Class
1 PhoneID . . . . . . . . . . . 11 SNY Phone ID. . . . . . . . . . . .
2 ChannelID . . . . . . . . . . 11 SNN Channel ID. . . . . . . . . . .
3 CompanyID . . . . . . . . . . 11 SNN Company ID. . . . . . . . . . .
4 AreaCode. . . . . . . . . . . 40 SNN Area Code . . . . . . . . . . .
5 PhoneNumber . . . . . . . . . 40 SNN Phone Number. . . . . . . . . .
6 PersonID. . . . . . . . . . . 11 SNN PersonID. . . . . . . . . . . .
7 Type. . . . . . . . . . . . . 80 SNN Type. . . . . . . . . . . . . .
8 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00
9 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO
10 ContactCode . . . . . . . . . 10 SNN Contact Code. . . . . . . . . .
11 DateTimeStamp . . . . . . . . 23 SNN Date Time Stamp . . . . . . . .
12 Updated . . . . . . . . . . . 1 SYN Updated . . . . . . . . . . . .YESNO
DfltVal:Y Valid:Y,N
13 ComputerName. . . . . . . . . 15 SNN Computer Name . . . . . . . . .