AR_Salesperson AR Salesperson Master Rel: 6.00 Bld: 1024 3/10/2020 Physical Path: "MAS_"+%C$+"/AR"+%C$+"/AR_Salesperson.M4T" SQL Create: Y SQL Sys DB: N SQL Null Dates: N Exclude V/I: N Create Tbl: N Bus Obj: AR_Salesperson_bus
KPRIMARY: SalespersonDivisionNo+SalespersonNo KCRMUSER: CRMUserID KUSERKEY: UserKey
Fld Column Name M/L TUR Description/Notes Class
1 SalespersonDivisionNo . . . . 2 SNY Salesperson Division Number . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARD$(1,2)} 2 SalespersonNo . . . . . . . . 4 SYY Salesperson Number. . . . . . .SALESPERSONNO FmtType:CHARNUM Notes: {ARD$(3,4)} 3 SalespersonName . . . . . . . 30 SNN Salesperson Name. . . . . . . .NAME Notes: {ARD$(7,30)} 4 AddressLine1. . . . . . . . . 30 SNN Address Line 1. . . . . . . . .ADDRESSLINE Notes: {ARD$(37,30)} 5 AddressLine2. . . . . . . . . 30 SNN Address Line 2. . . . . . . . .ADDRESSLINE Notes: {ARD$(67,30)} 6 AddressLine3. . . . . . . . . 30 SNN Address Line 3. . . . . . . . .ADDRESSLINE Notes: {ARD$(167,30)} 7 City. . . . . . . . . . . . . 20 SNN City. . . . . . . . . . . . . .CITY Notes: {ARD$(97,20)} 8 State . . . . . . . . . . . . 2 SYN State . . . . . . . . . . . . .STATE Notes: {ARD$(117,2)} 9 ZipCode . . . . . . . . . . . 10 SYN Zip Code. . . . . . . . . . . .ZIPCODE Notes: {ARD$(119,10)} 10 CountryCode . . . . . . . . . 3 SYN Country Code. . . . . . . . . .COUNTRY Notes: {ARD$(197,3)} 11 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . .TELEPHONENO Notes: {ARD$(150,17)} 12 TelephoneExt. . . . . . . . . 5 SNN Telephone Ext . . . . . . . . .TELEPHONEEXT Notes: {ARD$(139,5)} 13 EmailAddress. . . . . . . . . 50 SNN Email Address . . . . . . . . .EMAILADDRESS Notes: {ARD$(200,50)} 14 SalesManagerDivisionNo. . . . 2 SNN Sales Manager AR Division NumbeARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARD$(144,2)} 15 SalesManagerNo. . . . . . . . 4 SYN Sales Manager Number. . . . . .SALESPERSONNO FmtType:CHARNUM DepVal:REQUIR ED Notes: {ARD$(146,4)} 16 CRMUserID . . . . . . . . . . 11 SNN CRM User ID . . . . . . . . . . 17 UserKey . . . . . . . . . . . 10 SNN User Key. . . . . . . . . . . .USER DepVal:REQUIRED 18 CommissionRate. . . . . . . . 9.3 NNN Salesperson Commission Rate . .COMMISSIONRATE Mask:###0.000 Notes: {ARD[0]} 19 SalesManagerCommRate. . . . . 9.3 NNN Sales Manager Commission Rate .COMMISSIONRATE Mask:###0.000 Notes: {ARD[10]} 20 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 21 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .TIME Read Only:Y 22 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 23 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 24 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .TIME Read Only:Y 25 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL