CU_Person CU Person Mirror Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/CU"+%C$+"/CU_Person.M4T"
KPRIMARY: PersonID
KPERSON: ARDivisionNo+CustomerNo+ContactCode
KUPDATED: Updated
KCOMPANY: ARDivisionNo+CustomerNo
KCOMPANYID: CompanyID
KPERSONNAME: LastName+FirstName+PersonID
KEMAILADDRESS: EmailAddress+PersonID
KPHONENO: AreaCode+PhoneNumber+PersonID
KPRIMARYADDRESSID: PrimaryAddressID
Fld Column Name M/L TUR Description/Notes Class
1 PersonID. . . . . . . . . . . 11 SNY Person ID . . . . . . . . . . .
2 ChannelID . . . . . . . . . . 11 SNN Channel ID. . . . . . . . . . .
3 CompanyID . . . . . . . . . . 11 SNN Company ID. . . . . . . . . . .
4 FaxAreaCode . . . . . . . . . 40 SNN Fax Area Code . . . . . . . . .
5 FaxNumber . . . . . . . . . . 40 SNN Fax Number. . . . . . . . . . .
6 FirstName . . . . . . . . . . 60 SNN First Name. . . . . . . . . . .
7 LastName. . . . . . . . . . . 80 SNN Last Name . . . . . . . . . . .
8 PrimaryAddressID. . . . . . . 11 SNN Primary Address ID. . . . . . .
9 Salutation. . . . . . . . . . 20 SNN Salutation. . . . . . . . . . .
10 Territory . . . . . . . . . . 80 SNN Territory . . . . . . . . . . .
11 Title . . . . . . . . . . . . 60 SNN Title . . . . . . . . . . . . .
12 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00
13 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO
14 ContactCode . . . . . . . . . 10 SNN Contact Code. . . . . . . . . .
15 DateTimeStamp . . . . . . . . 23 SNN Date Time Stamp . . . . . . . .
16 Updated . . . . . . . . . . . 1 SYN Updated . . . . . . . . . . . .YESNO
DfltVal:Y Valid:Y,N
17 ComputerName. . . . . . . . . 15 SNN Computer Name . . . . . . . . .
18 AreaCode. . . . . . . . . . . 40 SNN Area Code . . . . . . . . . . .
19 PhoneNumber . . . . . . . . . 40 SNN Phone Number. . . . . . . . . .
20 EmailAddress. . . . . . . . . 510 SNN Email Address . . . . . . . . .