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