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 . . . . . . . . .