|
|
DTW Banking / Bill of Exchange / Bill of Exchange Transactions / Bill of Exchange Transactions
API Bill Of Exchange Transaction / Bill Of Exchange Transaction Lines
BOT1 - Bill of Exchange Transactions Table
Bill Of Exchange Transaction Lines BillOfExchangeTransaction_Lines Object· Table: BOT1
Parent: Bill Of Exchange Transaction BillOfExchangeTransaction Object· Table: OBOT
Bill Of Exchang Transaction OBOT SQL Table
Bill of Exchange for Payment OBOE SQL Table
Countries OCRY SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Transaction No. | Int | 11 | OBOT Bill Of Exchang Transaction | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BOENumber | Bill of Exchange No. | Int | 11 | |||||
| BoeType | Bill of Exchange Type | VarChar | I) Incoming O) Outgoing | 1 | I | |||
| DueDate | Bill of Exchange Due Date | Date | 8 | |||||
| BPBankCtr | BP Bank Country | nVarChar | 3 | OCRY Countries | ||||
| BPBankCod | BP Bank Code | nVarChar | 30 | |||||
| BPBankAct | BP Bank Account | nVarChar | 50 | |||||
| BPBankBrnc | BP Bank Branch | nVarChar | 50 | |||||
| ExReconNum | Extra Reconciliation Number | Int | 11 | |||||
| BOEAbs | Bill of Exchange Key | Int | 11 | OBOE Bill of Exchange for Payment |
Table relationship map
SELECT statement
SELECT
BOT1.AbsEntry AS 'Transaction No.',
BOT1.BOENumber AS 'Bill of Exchange No.',
BOT1.BoeType AS 'Bill of Exchange Type',
BOT1.DueDate AS 'Bill of Exchange Due Date',
BOT1.BPBankCtr AS 'BP Bank Country',
BOT1.BPBankCod AS 'BP Bank Code',
BOT1.BPBankAct AS 'BP Bank Account',
BOT1.BPBankBrnc AS 'BP Bank Branch',
BOT1.ExReconNum AS 'Extra Reconciliation Number',
BOT1.BOEAbs AS 'Bill of Exchange Key'
FROM BOT1 AS BOT1
Related information
Bill Of Exchange Transaction Lines BillOfExchangeTransaction_Lines Object· Table: BOT1
BillOfExchangeTransaction_Lines is a child object of the BillOfExchangeTransaction object, and represents the line entries of the Bill Of Exchange Transaction. This object enables you to add a line entry to the Bill Of Exchange Transaction...
Parent: Bill Of Exchange Transaction BillOfExchangeTransaction Object· Table: OBOT Bill Of Exchang Transaction OBOT SQL Table
Bill of Exchange for Payment OBOE SQL Table
Countries OCRY SQL Table
BillOfExchangeTransaction
Object
BillOfExchangeTransaction_Lines
Enumeration
Method
Property
BillOfExchangeNo
DTW DB
BillOfExchangeType
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
