<taCreateSalesperson>*
Element name |
Data type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
SLPRSNID |
string |
15 |
Y |
Not applicable |
Salesperson ID |
SALSTERR |
string |
15 |
Y |
Not applicable |
Territory ID |
EMPLOYID |
string |
15 |
N |
<blank> |
Employee ID |
VEDORID |
string |
15 |
N |
<blank> |
Vendor ID |
SLPRSNFN |
string |
15 |
N |
<blank> |
Salesperson first name |
SPRSNSMN |
string |
15 |
N |
<blank> |
Salesperson middle name |
SPRSNSLN |
string |
20 |
N |
<blank> |
Salesperson last name |
ADDRESS1 |
string |
60 |
N |
<blank> |
Address ID 1 |
ADDRESS2 |
string |
60 |
N |
<blank> |
Address ID 2 |
ADDRESS3 |
string |
60 |
N |
<blank> |
Address ID 3 |
CITY |
string |
35 |
N |
<blank> |
City |
STATE |
string |
29 |
N |
<blank> |
State |
ZIP |
string |
10 |
N |
<blank> |
ZIP Code |
COUNTRY |
string |
60 |
N |
<blank> |
Country |
PHONE1 |
string |
21 |
N |
00000000000000 |
Phone1 |
PHONE2 |
string |
21 |
N |
00000000000000 |
Phone2 |
PHONE3 |
string |
21 |
N |
00000000000000 |
Phone3 |
FAX |
string |
21 |
N |
00000000000000 |
Fax |
INACTIVE |
i4 |
1 |
N |
0 |
Inactive salesperson |
COMMCODE |
string |
15 |
N |
<blank> |
Commission code |
COMPRCNT |
number |
21 |
N |
0 |
Commission percent |
STDCPRCT |
number |
21 |
N |
0 |
Standard commission percent |
COMAPPTO |
i4 |
2 |
N |
0 |
Commission applied: Apply to sales=0; Invoice=1 |
COSTTODT |
number |
21 |
N |
0 |
Cost to date |
CSTLSTYR |
number |
21 |
N |
0 |
Cost last year |
TTLCOMTD |
number |
21 |
N |
0 |
Total commissions to date |
TTLCOMLY |
number |
21 |
N |
0 |
Total commissions last year |
COMSLTDT |
number |
21 |
N |
0 |
Commissioned sales to date |
COMSLLYR |
number |
21 |
N |
0 |
Commissioned sales last year |
NCOMSLTD |
number |
21 |
N |
0 |
Non-commissioned sales to date |
NCOMSLYR |
number |
21 |
N |
0 |
Non-commissioned sales last year |
KPCALHST |
i4 |
1 |
N |
1 |
Keep calendar history |
KPERHIST |
i4 |
1 |
N |
1 |
Keep fiscal year history |
MODIFDT |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Modified date |
CREATDDT |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Create date |
COMMDEST |
i4 |
2 |
N |
0 |
Commission destination |
UpdateIfExists |
i4 |
1 |
N |
0 |
Flag to allow data to be updated if it exists: 0=No; 1=Yes |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction: 0=False; 1=True (if True, it populates requester shadow table) |
USRDEFND1 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND2 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND3 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND4 |
string |
8000 |
N |
<blank> |
Use-defined field--developer use only |
USRDEFND5 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
* The default action for the <taCreateSalesperson> node is to use document exchange to provide update functionality. To use field level updates, set UpdateIfExists to 1.