📚 SAP Business One SDK Help

Table Name: OCPR

Table Description: Contact Persons

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
            I Not Valid for System
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 -      
GenderEx Gender nVarChar 15 OGDR E    
EnGenderEx Encryption of GenderEx Text 16 -      
Key Unique Field
PRIMARY Yes CntctCode
CARD Yes CardCode
    Name