biuan SAP® BUSINESS ONE SDK
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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUETransaction No.Int
11OBOT
Bill Of Exchang Transaction
PRIMARYYes
BOENumberBill of Exchange No.Int
11
BoeTypeBill of Exchange TypeVarChar
I) Incoming
O) Outgoing
1
I
DueDateBill of Exchange Due DateDate
8
BPBankCtrBP Bank CountrynVarChar
3OCRY
Countries
BPBankCodBP Bank CodenVarChar
30
BPBankActBP Bank AccountnVarChar
50
BPBankBrncBP Bank BranchnVarChar
50
ExReconNumExtra Reconciliation NumberInt
11
BOEAbsBill of Exchange KeyInt
11OBOE
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates