📚 SAP Business One SDK Help

Table Name: ACP1

Table Description: Campaign - BPs

Field Description Type Size Related Default Value Constraints
CpnNo Campaign No. Int 11 OCPN      
CpnLineNum Campaign Line Number Int 11 -      
BpCode BP Code nVarChar 15 OCRD      
BpName BP Name nVarChar 200 -      
GroupName BP Group Name nVarChar 100 -      
Industry BP Industry Name nVarChar 40 -      
Status BP Status VarChar 1 -   A Active
            I Inactive
CntCode Contact Code nVarChar 50 -      
CntTitle Contact Title nVarChar 10 -      
CntPstn Contact Position nVarChar 90 -      
CntEmail Contact E-Mail nVarChar 100 -      
CntTel Contact Telephone nVarChar 50 -      
CntMobile Contact Mobile nVarChar 50 -      
CntFax Contact Fax nVarChar 50 -      
CntAddr Contact Address nVarChar 254 -      
Response Response from Company VarChar 1 - N Y Yes
            N No
OpprId Related Opportunity Int 11 OOPR      
LogIns Log Instance - History Int 11 -      
VisOrder Visual Order Int 11 -      
Street Street nVarChar 100 -      
Block Block nVarChar 100 -      
City City nVarChar 100 -      
ZipCode Zip Code nVarChar 100 -      
County County nVarChar 100 -      
State State nVarChar 3 OCST      
Country Country/Region nVarChar 3 OCRY      
Building Building/Floor/Room Text 16 -      
CActivity Create Activity [Y/N] VarChar 1 - Y    
DocType Document Type nVarChar 20 - -1 E  
            P Opportunities
            Q Sales Quotations
            O Sales Orders
            D Deliveries
            I A/R Invoices
            -97 Purchase Opportunities
            540000006 Purchase Quotations
            22 Purchase Orders
            20 Goods Receipt POs
            18 A/P Invoices
ShowBPDoc Show BP Documents [Y/N] VarChar 1 - N    
DocNumber Related Document Int 11 -      
DocEntry Document Entry Int 11 -      
AssignTo Assign to User or Employee VarChar 1 - U U User
            E Employee
AssignName User or Employee Name Int 11 -      
FirstName First Name nVarChar 50 -      
MiddleName Middle Name nVarChar 50 -      
LastName Last Name nVarChar 50 -      
LicTradNum Federal Tax ID nVarChar 32 -      
AddrType Address Type nVarChar 100 -      
Address2 Address Name 2 nVarChar 50 -      
Address3 Address Name 3 nVarChar 50 -      
StreetNo Street No. nVarChar 100 -      
AddressID Address ID nVarChar 50 -      
RspType Response Type nVarChar 20 ORPT      
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
            B Blocked
            U Unblocked
EncryptIV Encrypt IV nVarChar 100 -      
EnLicTradN Encrypt TAX ID Number Text 16 -      
Key Unique Field
PRIMARY Yes CpnNo
    CpnLineNum
    LogIns