biuan SAP® BUSINESS ONE SDK
SQL Banking / Bill Of Exchang Transaction
DTW Banking / Bill of Exchange / Bill of Exchange Transactions
API OBOT / Bill Of Exchange Transaction
OBOT - Bill Of Exchang Transaction Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEBOE Transaction keyInt
11
PRIMARYYes
UserSignUser SignatureInt
6OUSR
Users
StatusFromStatus fromVarChar
S) Sent
G) Generated
D) Deposit
P) Paid
F) Failed
V) BoE to Vendor
1
StatusToStatus ToVarChar
C) Canceled
G) Generated
D) Deposit
P) Paid
F) Failed
L) Closed
V) BoE to Vendor
1
TranDateTransaction DateDate
8
TranTimeTransaction TimeInt
6
Reconciledwas the Boe ReconciledVarChar
Y) Yes
N) No
1
N
TransIdTransaction NumberInt
11OJDT
Journal Entry
PostDatePosting DateDate
8
TaxDateDocument DateDate
8

Table relationship map

SELECT statement

SELECT OBOT.AbsEntry AS 'BOE Transaction key', OBOT.UserSign AS 'User Signature', OBOT.StatusFrom AS 'Status from', OBOT.StatusTo AS 'Status To', OBOT.TranDate AS 'Transaction Date', OBOT.TranTime AS 'Transaction Time', OBOT.Reconciled AS 'was the Boe Reconciled', OBOT.TransId AS 'Transaction Number', OBOT.PostDate AS 'Posting Date', OBOT.TaxDate AS 'Document Date' FROM OBOT AS OBOT

Related information


Bill Of Exchange Transaction BillOfExchangeTransaction Object· Table: OBOT
BillOfExchangeTransaction is a business object that represents the Bill Of Exchange Transaction table in the Banking module. Bill Of Exchange is a commercial document used as a payment method in Spain, Portugal, Italy, and France. Use this...

OBOT SQL Table

Journal Entry OJDT SQL Table

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