CU_Company CU Company Mirror Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/CU"+%C$+"/CU_Company.M4T"
KPRIMARY: CompanyID KCOMPANY: ARDivisionNo+CustomerNo KUPDATED: Updated KCOMPANYNAME: Name+CompanyID KPRIMARYADDRESSID: PrimaryAddressID KPRIMARYPERSONID: PrimaryPersonID KEMAILADDRESS: EmailAddress+CompanyID
Fld Column Name M/L TUR Description/Notes Class
1 CompanyID . . . . . . . . . . 11 SNY Company ID. . . . . . . . . . . 2 ChannelID . . . . . . . . . . 11 SNN Channel ID. . . . . . . . . . . 3 FaxAreaCode . . . . . . . . . 40 SNN Fax Area Code . . . . . . . . . 4 FaxNumber . . . . . . . . . . 40 SNN Fax Number. . . . . . . . . . . 5 Name. . . . . . . . . . . . . 120 SNN Name. . . . . . . . . . . . . . 6 PrimaryAddressID. . . . . . . 11 SNN Primary Address ID. . . . . . . 7 PrimaryPersonID . . . . . . . 11 SNN Primary Person ID . . . . . . . 8 PrimaryUserID . . . . . . . . 11 SNN Primary User ID . . . . . . . . 9 Territory . . . . . . . . . . 80 SNN Territory . . . . . . . . . . . 10 Website . . . . . . . . . . . 80 SNN Website . . . . . . . . . . . . 11 Type. . . . . . . . . . . . . 80 SNN Type. . . . . . . . . . . . . . 12 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 13 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO 14 DateTimeStamp . . . . . . . . 23 SNN Date Time Stamp . . . . . . . . 15 Updated . . . . . . . . . . . 1 SYN Updated . . . . . . . . . . . .YESNO DfltVal:Y Valid:Y,N 16 ComputerName. . . . . . . . . 15 SNN ComputerName. . . . . . . . . . 17 AreaCode. . . . . . . . . . . 40 SNN Area Code . . . . . . . . . . . 18 PhoneNumber . . . . . . . . . 40 SNN Phone Number. . . . . . . . . . 19 EmailAddress. . . . . . . . . 510 SNN Email Address . . . . . . . . . 20 SalespersonDivisionNo . . . . 2 SNN Salesperson Division Number . . 21 SalespersonNo . . . . . . . . 4 SNN Salesperson Number. . . . . . . 22 TermsCode . . . . . . . . . . 2 SNN Terms Code. . . . . . . . . . . 23 TermsCodeDesc . . . . . . . . 30 SNN Terms Code Description. . . . . 24 TaxSchedule . . . . . . . . . 9 SNN Tax Schedule. . . . . . . . . . 25 TaxScheduleDesc . . . . . . . 30 SNN Tax Schedule Description. . . . 26 DefaultPaymentType. . . . . . 5 SNN Default Payment Type. . . . . . 27 CustomerType. . . . . . . . . 4 SNN Customer Type . . . . . . . . . 28 PriceLevel. . . . . . . . . . 1 SNN Price Level . . . . . . . . . .