|
|
DTW Administration / Setup / Financials / Business Places
API OBPL / Business Places
OBPL - Business Place Table
Business Places BusinessPlaces Object· Table: OBPL
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BPLId KEY UNIQUE | Branch ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BPLName KEY UNIQUE | Branch Name | nVarChar | 100 | NAME | Yes | |||
| BPLFrName | Branch Name (Foreign) | nVarChar | 100 | |||||
| VATRegNum | VAT Reg. Number | nVarChar | 12 | |||||
| RepName | Rep. Name | nVarChar | 15 | |||||
| Industry | Industry | nVarChar | 20 | |||||
| Business | Business | nVarChar | 20 | |||||
| Address | Address | nVarChar | 127 | |||||
| AddressFr | Address (Foreign) | nVarChar | 127 | |||||
| MainBPL | Main BPL | VarChar | Y) Main Business Place N) Not Main Business Place | 1 | N | |||
| TxOffcNo | Tax Office No. | nVarChar | 3 | |||||
| Disabled | Disabled | VarChar | Y) Disabled N) Enabled | 1 | N | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| DflCust | Default Customer ID | nVarChar | 15 | OCRD Business Partner | ||||
| DflVendor | Default Vendor ID | nVarChar | 15 | OCRD Business Partner | ||||
| DflWhs | Default Warehouse ID | nVarChar | 8 | OWHS Warehouses | ||||
| DflTaxCode | Default Tax Code | nVarChar | 8 | OCNA CNAE Code | ||||
| RevOffice | Tax Office | nVarChar | 100 | |||||
| TaxIdNum | Branch Reg. No. | nVarChar | 32 | |||||
| TaxIdNum2 | Federal Tax ID 2 | nVarChar | 32 | |||||
| TaxIdNum3 | Federal Tax ID 3 | nVarChar | 32 | |||||
| AddtnlId | Additional ID Number | nVarChar | 32 | |||||
| CompNature | Nature of Company | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| EconActT | Economic Activity Type | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| CredCOrig | Credit Contribution Origin | nVarChar | 2 | OBSI Brazil String Indexer | ||||
| IPIPeriod | IPI Period | nVarChar | 2 | OBSI Brazil String Indexer | ||||
| CoopAssocT | Cooperative Association Type | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| PrefState | Default State | nVarChar | 3 | |||||
| ProfTax | Profit Taxation | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| CompQualif | Company Qualification | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| DeclType | Declarer Type | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| AddrType | Address Type | nVarChar | 100 | |||||
| Street | Street | nVarChar | 100 | |||||
| StreetNo | Street No. | nVarChar | 100 | |||||
| Building | Building/Floor/Room | nVarChar | 100 | |||||
| ZipCode | Zip Code | nVarChar | 20 | |||||
| Block | Block | nVarChar | 100 | |||||
| City | City | nVarChar | 100 | |||||
| State | State | nVarChar | 3 | |||||
| County | County | nVarChar | 100 | OCNT Counties | ||||
| Country | Country | nVarChar | 3 | OCRY Countries | ||||
| PmtClrAct | Payment Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CommerReg | Commercial Register | nVarChar | 60 | |||||
| DateOfInc | Date of Incorporation | Date | 8 | |||||
| SPEDProf | SPED Profile | nVarChar | 2 | OBSI Brazil String Indexer | ||||
| EnvTypeNFe | Environment Type NFe | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| Opt4ICMS | Opting for ICMS 115_03 | VarChar | 1 | N | ||||
| AliasName | Alias Name | Text | 16 | |||||
| GlblLocNum | Global Location Number | nVarChar | 50 | |||||
| TaxRptFrm | Tax Wizard Reporting From | Date | 8 | |||||
| Suframa | SUFRAMA | nVarChar | 100 | |||||
| DfltResWhs | Default Resource Warehouse ID | nVarChar | 8 | OWHS 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
BusinessPlaces
Method
Object
Property
AdditionalIdNumber
DTW DB
Address
DTW DB
Addressforeign
DTW DB
AddressType
DTW DB
AliasName
DTW DB
Block
DTW DB
BPLID
DTW DB
BPLName
DTW DB
BPLNameForeign
DTW DB
Building
DTW DB
Business
DTW DB
City
DTW DB
CommercialRegister
DTW DB
CompanyQualificationCode
DTW DB
Country
DTW DB
County
DTW DB
CreditContributionOriginCode
DTW DB
DateOfIncorporation
DTW DB
DeclarerTypeCode
DTW DB
DefaultCustomerID
DTW DB
DefaultResourceWarehouseID
DTW DB
DefaultTaxCode
DTW DB
DefaultVendorID
DTW DB
DefaultWarehouseID
DTW DB
Disabled
DTW DB
EconomicActivityTypeCode
DTW DB
EnvironmentType
DTW DB
FederalTaxID
DTW DB
FederalTaxID2
DTW DB
FederalTaxID3
DTW DB
GlobalLocationNumber
DTW DB
Industry
DTW DB
IPIPeriodCode
DTW DB
MainBPL
DTW DB
NatureOfCompanyCode
DTW DB
Opting4ICMS
DTW DB
PaymentClearingAccount
DTW DB
PreferredStateCode
DTW DB
ProfitTaxationCode
DTW DB
RepName
DTW DB
SPEDProfile
DTW DB
State
DTW DB
Street
DTW DB
StreetNo
DTW DB
TaxOffice
DTW DB
TaxOfficeNo
DTW DB
VATRegNum
DTW DB
ZipCode
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
