| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| CntctCode |
Internal Number |
Int |
11 |
- |
|
|
|
| CardCode |
BP Code |
nVarChar |
15 |
OCRD |
|
|
|
| Name |
Contact Person Name |
nVarChar |
50 |
- |
|
|
|
| Position |
Position |
nVarChar |
90 |
- |
|
|
|
| Address |
Address |
nVarChar |
254 |
- |
|
|
|
| Tel1 |
Telephone 1 |
nVarChar |
50 |
- |
|
|
|
| Tel2 |
Telephone 2 |
nVarChar |
50 |
- |
|
|
|
| Cellolar |
Mobile Phone |
nVarChar |
50 |
- |
|
|
|
| Fax |
Fax |
nVarChar |
50 |
- |
|
|
|
| E_MailL |
E-Mail |
nVarChar |
100 |
- |
|
|
|
| Pager |
Pager |
nVarChar |
30 |
- |
|
|
|
| Notes1 |
Remark 1 |
nVarChar |
100 |
- |
|
|
|
| Notes2 |
Remark 2 |
nVarChar |
100 |
- |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| Password |
Password |
nVarChar |
8 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
11 |
|
|
| BirthPlace |
Place of Birth |
nVarChar |
100 |
- |
|
|
|
| BirthDate |
Date of Birth |
Date |
8 |
- |
|
|
|
| Gender |
Gender |
VarChar |
1 |
- |
E |
M |
Male |
| |
|
|
|
|
|
F |
Female |
| |
|
|
|
|
|
E |
Not Specified |
| |
|
|
|
|
|
* |
Masked |
| Profession |
Profession |
nVarChar |
50 |
- |
|
|
|
| updateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| updateTime |
Update Time |
Int |
11 |
- |
|
|
|
| Title |
Title |
nVarChar |
10 |
- |
|
|
|
| BirthCity |
City of Birth |
nVarChar |
100 |
- |
|
|
|
| Active |
Active |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FirstName |
First Name |
nVarChar |
50 |
- |
|
|
|
| MiddleName |
Middle Name |
nVarChar |
50 |
- |
|
|
|
| LastName |
Last Name |
nVarChar |
50 |
- |
|
|
|
| BirthState |
State of Birth |
nVarChar |
3 |
OCST |
|
|
|
| ResidCity |
City of Residence |
nVarChar |
100 |
- |
|
|
|
| ResidCntry |
Country/Region of Residence |
nVarChar |
100 |
- |
|
|
|
| ResidState |
State of Residence |
nVarChar |
3 |
OCST |
|
|
|
| NFeRcpn |
NF-e Recipient |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EmlGrpCode |
E-Mail Group Code |
nVarChar |
20 |
OEGP |
|
|
|
| BlockComm |
Block Sending Marketing |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| FiscalCode |
Fiscal Code for Resident |
nVarChar |
16 |
- |
|
|
|
| CtyPrvsYr |
City for Previous Year |
nVarChar |
100 |
- |
|
|
|
| SttPrvsYr |
State for Previous Year |
nVarChar |
3 |
OCST |
|
|
|
| CtyCdPrvsY |
City Code for Previous Year |
nVarChar |
4 |
- |
|
|
|
| CtyCurYr |
City for Current Year |
nVarChar |
100 |
- |
|
|
|
| SttCurYr |
State for Current Year |
nVarChar |
3 |
OCST |
|
|
|
| CtyCdCurYr |
City Code for Current Year |
nVarChar |
4 |
- |
|
|
|
| NotResdSch |
Not resident Schumacker |
VarChar |
1 |
- |
|
|
|
| |
|
|
|
|
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CtyFsnCode |
Fusione comuni |
nVarChar |
100 |
- |
|
|
|
| NaturalPer |
Natural Person |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| |
|
|
|
|
|
B |
Blocked |
| |
|
|
|
|
|
U |
Unblocked |
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| CreateTS |
Creation Time Incl. Sec. |
Int |
11 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| CnnectAddr |
Connected Address |
nVarChar |
50 |
- |
|
|
|
| CnAddrType |
Connected Address Type |
VarChar |
1 |
- |
|
S |
Ship To |
| |
|
|
|
|
|
B |
Bill To |
| Frgncntry |
Stato Estero |
nVarChar |
3 |
- |
|
|
|
| EnGender |
Encryption of Gender |
Text |
16 |
- |
|
|
|