|
|
DTW Administration / Setup / Financials / Business Places / Branch I.E. Numbers
API Business Places / Business Place IE Numbers
BPL1 - Branch I.E. Numbers Table
v8.8 Business Place IE Numbers BusinessPlaceIENumbers Object· Table: BPL1
Parent: Business Places BusinessPlaces Object· Table: OBPL
Business Place OBPL SQL Table
States OCST SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | BPLId KEY UNIQUE | BPL ID | Int | 11 | OBPL Business Place | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DstState | Destination State | nVarChar | 3 | OCST States | ||||
| IENumber | I.E. Number | nVarChar | 32 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
BPL1.BPLId AS 'BPL ID',
BPL1.DstState AS 'Destination State',
BPL1.IENumber AS 'I.E. Number',
BPL1.LogInstanc AS 'Log Instance'
FROM BPL1 AS BPL1
Related information
v8.8 Business Place IE Numbers BusinessPlaceIENumbers Object· Table: BPL1
The company Inscrição Estadual (I.E.) number in the Brazilian localization.
Source table: BPL1.
Parent: Business Places BusinessPlaces Object· Table: OBPL Business Place OBPL SQL Table
States OCST SQL Table
BusinessPlaces
Object
BusinessPlaceIENumbers
Method
Property
BPLID
8.8 DB
IENumber
8.8 DB
State
8.8 DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
