|
|
DTW Banking / Bill of Exchange / Bill of Exchange Transactions / POS Master Data
API Bank Statement Row / BP Bank Account
OPOS - POS Master Data Table
BP Bank Account BPBankAccount Property· Table: OPOS
Parent: Bank Statement Row BankStatementRow Object· Table: OBNK
OPOS SQL Table
Nota Fiscal Model ONFM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | EquipNo KEY UNIQUE | Equipment No. | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Model | Model | nVarChar | 20 | |||||
| ManufSN | Manufacturer Serial No. | nVarChar | 21 | |||||
| RegNo | Register No. | Int | 6 | |||||
| NFModel | Fiscal Document Model | nVarChar | 6 | ONFM Nota Fiscal Model |
Table relationship map
SELECT statement
SELECT
OPOS.EquipNo AS 'Equipment No.',
OPOS.Model AS 'Model',
OPOS.ManufSN AS 'Manufacturer Serial No.',
OPOS.RegNo AS 'Register No.',
OPOS.NFModel AS 'Fiscal Document Model'
FROM OPOS AS OPOS
Related information
BP Bank Account BPBankAccount Property· Table: OPOS
Sets or returns the business partner bank account.
Field name:OposAct.
Parent: Bank Statement Row BankStatementRow Object· Table: OBNK OPOS SQL Table
Nota Fiscal Model ONFM SQL Table
BankStatementRow
Property
BPBankAccount
Collection
Enumeration
Method
Property
AccountName
DB
Balance
DB
BPBankCode
DB
BPCode
DB
BPName
DB
CreateMethod
DB
Details
DB
Details2
DB
DocNumType
DB
DocumentType
DB
DueDate
DB
ExchangeRate
DB
ExternalCode
DB
FeeOnTheLine
DB
FeeProject
DB
Reference
DB
SequenceNo
DB
VATAmountFC
DB
VATAmountLC
DB
VisualOrder
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
