ACPR - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Business Partners / Contact Persons - History

API ACPR

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
CntctCode ^KEY ^UNIQUE	Internal Number	Int		11			PRIMARY	Yes
CardCode	BP Code	nVarChar		15	OCRD Business Partner
Name	Contact Person Name	nVarChar		50
Position	Position	nVarChar		90
Address	Address	nVarChar		100
Tel1	Telephone 1	nVarChar		20
Tel2	Telephone 2	nVarChar		20
Cellolar	Mobile Phone Number	nVarChar		50
Fax	Fax Number	nVarChar		20
E_MailL	E-Mail	nVarChar		100
Pager	Pager	nVarChar		30
Notes1	Remark 1	nVarChar		100
Notes2	Remark 2	nVarChar		100
DataSource	Data Source	VarChar	N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer	1		N
UserSign	User Signature	Int		6	OUSR Users
Password	Password	nVarChar		8
LogInstanc	Log Instance	Int		11		0
ObjType	Object Type	nVarChar		20	ADP1 Object Settings - History
BirthPlace	Place of Birth	nVarChar		100
BirthDate	Date of Birth	Date		8
Gender	Gender	VarChar	M) Male F) Female E)	1		E
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	Y) Yes N) No	1		Y
FirstName	First Name	nVarChar		50
MiddleName	Middle Name	nVarChar		50
LastName	Last Name	nVarChar		50
BirthState	State of Birth	nVarChar		3	OCST States
ResidCity	City of Residence	nVarChar		100
ResidCntry	Country of Residence	nVarChar		100
ResidState	State of Residence	nVarChar		3	OCST States
NFeRcpn	NF-e Recipient	VarChar	Y) Yes N) No	1		N
EmlGrpCode	E-Mail Group Code	nVarChar		20	OEGP E-Mail Group
BlockComm	Block Sending Marketing	VarChar	N) No Y) Yes	1		N
FiscalCode	Fiscal Code for Resident	nVarChar		16
CtyPrvsYr	City for Previous Year	nVarChar		100
SttPrvsYr	State for Previous Year	nVarChar		3	OCST States
CtyCdPrvsY	City Code for Previous Year	nVarChar		4
CtyCurYr	City for Current Year	nVarChar		100
SttCurYr	State for Current Year	nVarChar		3	OCST States
CtyCdCurYr	City Code for Current Year	nVarChar		4

Table relationship map

SELECT statement

SELECT
   ACPR.CntctCode AS 'Internal Number', 
   ACPR.CardCode AS 'BP Code', 
   ACPR.Name AS 'Contact Person Name', 
   ACPR.Position AS 'Position', 
   ACPR.Address AS 'Address', 
   ACPR.Tel1 AS 'Telephone 1', 
   ACPR.Tel2 AS 'Telephone 2', 
   ACPR.Cellolar AS 'Mobile Phone Number', 
   ACPR.Fax AS 'Fax Number', 
   ACPR.E_MailL AS 'E-Mail', 
   ACPR.Pager AS 'Pager', 
   ACPR.Notes1 AS 'Remark 1', 
   ACPR.Notes2 AS 'Remark 2', 
   ACPR.DataSource AS 'Data Source', 
   ACPR.UserSign AS 'User Signature', 
   ACPR.Password AS 'Password', 
   ACPR.LogInstanc AS 'Log Instance', 
   ACPR.ObjType AS 'Object Type', 
   ACPR.BirthPlace AS 'Place of Birth', 
   ACPR.BirthDate AS 'Date of Birth', 
   ACPR.Gender AS 'Gender', 
   ACPR.Profession AS 'Profession', 
   ACPR.updateDate AS 'Date of Update', 
   ACPR.updateTime AS 'Update Time', 
   ACPR.Title AS 'Title', 
   ACPR.BirthCity AS 'City of Birth', 
   ACPR.Active AS 'Active', 
   ACPR.FirstName AS 'First Name', 
   ACPR.MiddleName AS 'Middle Name', 
   ACPR.LastName AS 'Last Name', 
   ACPR.BirthState AS 'State of Birth', 
   ACPR.ResidCity AS 'City of Residence', 
   ACPR.ResidCntry AS 'Country of Residence', 
   ACPR.ResidState AS 'State of Residence', 
   ACPR.NFeRcpn AS 'NF-e Recipient', 
   ACPR.EmlGrpCode AS 'E-Mail Group Code', 
   ACPR.BlockComm AS 'Block Sending Marketing', 
   ACPR.FiscalCode AS 'Fiscal Code for Resident', 
   ACPR.CtyPrvsYr AS 'City for Previous Year', 
   ACPR.SttPrvsYr AS 'State for Previous Year', 
   ACPR.CtyCdPrvsY AS 'City Code for Previous Year', 
   ACPR.CtyCurYr AS 'City for Current Year', 
   ACPR.SttCurYr AS 'State for Current Year', 
   ACPR.CtyCdCurYr AS 'City Code for Current Year'
FROM ACPR AS ACPR

Related information

OCST SQL Table

OCRD SQL Table

OEGP SQL Table

ADP1 SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates