|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Branches
Table Name: OBPL
Table Description: Branches
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| BPLId | Branch ID | Int | 11 | - | Â | Â | Â |
| BPLName | Branch Name | nVarChar | 200 | - | Â | Â | Â |
| BPLFrName | Branch Name (Foreign) | nVarChar | 200 | - | Â | Â | Â |
| VATRegNum | VAT Reg. Number | nVarChar | 12 | - | Â | Â | Â |
| RepName | Rep. Name | nVarChar | 15 | - | Â | Â | Â |
| Industry | Industry | nVarChar | 20 | - | Â | Â | Â |
| Business | Business | nVarChar | 20 | - | Â | Â | Â |
| Address | Address | nVarChar | 254 | - | Â | Â | Â |
| AddressFr | Address (Foreign) | nVarChar | 254 | - | Â | Â | Â |
| MainBPL | Main BPL | VarChar | 1 | - | N | Y | Main Business Place |
| Â | Â | Â | Â | Â | Â | N | Not Main Business Place |
| TxOffcNo | Tax Office No. | nVarChar | 3 | - | Â | Â | Â |
| Disabled | Disabled | VarChar | 1 | - | N | Y | Disabled |
| Â | Â | Â | Â | Â | Â | N | Enabled |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| DflCust | Default Customer ID | nVarChar | 15 | OCRD | Â | Â | Â |
| DflVendor | Default Vendor ID | nVarChar | 15 | OCRD | Â | Â | Â |
| DflWhs | Default Warehouse ID | nVarChar | 8 | OWHS | Â | Â | Â |
| DflTaxCode | Default Tax Code | nVarChar | 8 | OCNA | Â | Â | Â |
| 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 | -1 | Â | Â |
| EconActT | Economic Activity Type | Int | 11 | OBNI | -1 | Â | Â |
| CredCOrig | Credit Contribution Origin | nVarChar | 2 | OBSI | Â | Â | Â |
| IPIPeriod | IPI Period | nVarChar | 2 | OBSI | Â | Â | Â |
| CoopAssocT | Cooperative Association Type | Int | 11 | OBNI | -1 | Â | Â |
| PrefState | Default State | nVarChar | 3 | - | Â | Â | Â |
| ProfTax | Profit Taxation | Int | 11 | OBNI | -1 | Â | Â |
| CompQualif | Company Qualification | Int | 11 | OBNI | -1 | Â | Â |
| DeclType | Declarer Type | Int | 11 | OBNI | -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 | Â | Â | Â |
| Country | Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| PmtClrAct | Payment Clearing Account | nVarChar | 15 | OACT | Â | Â | Â |
| CommerReg | Commercial Register | nVarChar | 60 | - | Â | Â | Â |
| DateOfInc | Date of Incorporation | Date | 8 | - | Â | Â | Â |
| SPEDProf | SPED Profile | nVarChar | 2 | OBSI | Â | Â | Â |
| EnvTypeNFe | Environment Type NFe | Int | 11 | OBNI | -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 | Â | Â | Â |
| SnapshotId | Snapshot ID | Int | 11 | - | 0 | Â | Â |
| BPLNum | Branch No. | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | BPLId |
| NAME | Yes | BPLName |