biuan SAP® BUSINESS ONE SDK
SQL Finance / VAT Transactions
API OTAX
OTAX - VAT Transactions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
SrcObjType KEY UNIQUESource Object TypenVarChar
-1)
13) A/R Invoice
14) A/R Credit Memo
165) Correction A/R Invoice
166) Correction A/R Invoice Reversals
18) A/P Invoice
19) A/P Credit Memo
163) Correction A/P Invoice
164) Correction A/P Invoice Reversals
46) Outgoing Payment
24) Incoming Payment
57) Check for Payment
30) Journal Transaction
67) Warehouse Transfer
25) Deposit
321) Internal Reconciliation
76) Deposit Temporary
140000010) Incoming Excise Invoice
140000009) Outgoing Excise Invoice
69) Import file
20
-1SECONDARYYes
SrcObjAbsSource Object Internal IDInt
11
-1
OrdinLNumOrdial Num (BTF & Canceled)Int
11
-1
CancelledCanceledVarChar
N) No
Y) Yes
1
N

SELECT statement

SELECT OTAX.AbsEntry AS 'Internal Number', OTAX.SrcObjType AS 'Source Object Type', OTAX.SrcObjAbs AS 'Source Object Internal ID', OTAX.OrdinLNum AS 'Ordial Num (BTF & Canceled)', OTAX.Cancelled AS 'Canceled' FROM OTAX AS OTAX

Related information


OTAX 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