BOT1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Banking /

Bill Of Exchang Transaction / Bill of Exchange Transactions

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

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

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
OBOT SQL Table

OBOE SQL Table

OCRY SQL Table

biuan SAP® BUSINESS ONE

Object
BillOfExchangeTransaction

Object
BillOfExchangeTransaction_Lines

Enumeration

BoBOETypes

Method

Add

SetCurrentLine

Property

BillOfExchangeDueDate

BillOfExchangeNo

DTW DB

BillOfExchangeType

DTW DB

Count

UserFields

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