biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Business Places
API OBPL / / Business Places
OBPL - Business Place Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BPLId KEY UNIQUEBranch IDInt
11
PRIMARYYes
BPLName KEY UNIQUEBranch NamenVarChar
100
NAMEYes
BPLFrNameBranch Name (Foreign)nVarChar
100
VATRegNumVAT Reg. NumbernVarChar
12
RepNameRep. NamenVarChar
15
IndustryIndustrynVarChar
20
BusinessBusinessnVarChar
20
AddressAddressnVarChar
127
AddressFrAddress (Foreign)nVarChar
127
MainBPLMain BPLVarChar
Y) Main Business Place
N) Not Main Business Place
1
N
TxOffcNoTax Office No.nVarChar
3
DisabledDisabledVarChar
Y) Disabled
N) Enabled
1
N
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
DflCustDefault Customer IDnVarChar
15OCRD
Business Partner
DflVendorDefault Vendor IDnVarChar
15OCRD
Business Partner
DflWhsDefault Warehouse IDnVarChar
8OWHS
Warehouses
DflTaxCodeDefault Tax CodenVarChar
8OCNA
CNAE Code
RevOfficeTax OfficenVarChar
100
TaxIdNumBranch Reg. No.nVarChar
32
TaxIdNum2Federal Tax ID 2nVarChar
32
TaxIdNum3Federal Tax ID 3nVarChar
32
AddtnlIdAdditional ID NumbernVarChar
32
CompNatureNature of CompanyInt
11OBNI
Brazil Numeric Indexer
-1
EconActTEconomic Activity TypeInt
11OBNI
Brazil Numeric Indexer
-1
CredCOrigCredit Contribution OriginnVarChar
2OBSI
Brazil String Indexer
IPIPeriodIPI PeriodnVarChar
2OBSI
Brazil String Indexer
CoopAssocTCooperative Association TypeInt
11OBNI
Brazil Numeric Indexer
-1
PrefStateDefault StatenVarChar
3
ProfTaxProfit TaxationInt
11OBNI
Brazil Numeric Indexer
-1
CompQualifCompany QualificationInt
11OBNI
Brazil Numeric Indexer
-1
DeclTypeDeclarer TypeInt
11OBNI
Brazil Numeric Indexer
-1
AddrTypeAddress TypenVarChar
100
StreetStreetnVarChar
100
StreetNoStreet No.nVarChar
100
BuildingBuilding/Floor/RoomnVarChar
100
ZipCodeZip CodenVarChar
20
BlockBlocknVarChar
100
CityCitynVarChar
100
StateStatenVarChar
3
CountyCountynVarChar
100OCNT
Counties
CountryCountrynVarChar
3OCRY
Countries
PmtClrActPayment Clearing AccountnVarChar
15OACT
G/L Accounts
CommerRegCommercial RegisternVarChar
60
DateOfIncDate of IncorporationDate
8
SPEDProfSPED ProfilenVarChar
2OBSI
Brazil String Indexer
EnvTypeNFeEnvironment Type NFeInt
11OBNI
Brazil Numeric Indexer
-1
Opt4ICMSOpting for ICMS 115_03VarChar
1
N
AliasNameAlias NameText
16
GlblLocNumGlobal Location NumbernVarChar
50
TaxRptFrmTax Wizard Reporting FromDate
8
SuframaSUFRAMAnVarChar
100
DfltResWhsDefault Resource Warehouse IDnVarChar
8OWHS
Warehouses

Table relationship map

SELECT statement

SELECT OBPL.BPLId AS 'Branch ID', OBPL.BPLName AS 'Branch Name', OBPL.BPLFrName AS 'Branch Name (Foreign)', OBPL.VATRegNum AS 'VAT Reg. Number', OBPL.RepName AS 'Rep. Name', OBPL.Industry AS 'Industry', OBPL.Business AS 'Business', OBPL.Address AS 'Address', OBPL.AddressFr AS 'Address (Foreign)', OBPL.MainBPL AS 'Main BPL', OBPL.TxOffcNo AS 'Tax Office No.', OBPL.Disabled AS 'Disabled', OBPL.LogInstanc AS 'Log Instance', OBPL.UserSign2 AS 'Updating User', OBPL.UpdateDate AS 'Update Date', OBPL.DflCust AS 'Default Customer ID', OBPL.DflVendor AS 'Default Vendor ID', OBPL.DflWhs AS 'Default Warehouse ID', OBPL.DflTaxCode AS 'Default Tax Code', OBPL.RevOffice AS 'Tax Office', OBPL.TaxIdNum AS 'Branch Reg. No.', OBPL.TaxIdNum2 AS 'Federal Tax ID 2', OBPL.TaxIdNum3 AS 'Federal Tax ID 3', OBPL.AddtnlId AS 'Additional ID Number', OBPL.CompNature AS 'Nature of Company', OBPL.EconActT AS 'Economic Activity Type', OBPL.CredCOrig AS 'Credit Contribution Origin', OBPL.IPIPeriod AS 'IPI Period', OBPL.CoopAssocT AS 'Cooperative Association Type', OBPL.PrefState AS 'Default State', OBPL.ProfTax AS 'Profit Taxation', OBPL.CompQualif AS 'Company Qualification', OBPL.DeclType AS 'Declarer Type', OBPL.AddrType AS 'Address Type', OBPL.Street AS 'Street', OBPL.StreetNo AS 'Street No.', OBPL.Building AS 'Building/Floor/Room', OBPL.ZipCode AS 'Zip Code', OBPL.Block AS 'Block', OBPL.City AS 'City', OBPL.State AS 'State', OBPL.County AS 'County', OBPL.Country AS 'Country', OBPL.PmtClrAct AS 'Payment Clearing Account', OBPL.CommerReg AS 'Commercial Register', OBPL.DateOfInc AS 'Date of Incorporation', OBPL.SPEDProf AS 'SPED Profile', OBPL.EnvTypeNFe AS 'Environment Type NFe', OBPL.Opt4ICMS AS 'Opting for ICMS 115_03', OBPL.AliasName AS 'Alias Name', OBPL.GlblLocNum AS 'Global Location Number', OBPL.TaxRptFrm AS 'Tax Wizard Reporting From', OBPL.Suframa AS 'SUFRAMA', OBPL.DfltResWhs AS 'Default Resource Warehouse ID' FROM OBPL AS OBPL

Related information


Business Places BusinessPlaces Object· Table: OBPL
BusinessPlaces is a business object that represents a company's business locations. Each Korean company that issues tax invoices and VAT reports must indicate its business place. Each business place is bound with a VAT registry number. This...

OBPL SQL Table

Brazil Numeric Indexer OBNI SQL Table

Countries OCRY SQL Table

Counties OCNT SQL Table

Brazil String Indexer OBSI SQL Table

Business Partner OCRD SQL Table

CNAE Code OCNA SQL Table

Users OUSR SQL Table



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