biuan SAP® BUSINESS ONE SDK
SQL Reports / Tax Report Saving Object
API OTRS
OTRS - Tax Report Saving Object Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ObjTypeObject TypenVarChar
20
ReportTypeReport TypeInt
1) VAT Report (UK)
11
PeriodTypeReport Period TypeVarChar
Y) Year
Q) Quarter
M) Month
P) Period
1
PeriodNumReport Period NumberInt
11
YearReport YearInt
6
AdjustNumReport Adjustment NumberInt
6
ApUserSignApproved By (User Signature)Int
6
ApDateApproval DateDate
8
ApTimeApproval TimeInt
6
DeclTypeDeclaration TypeVarChar
O) Original
S) Substitute
C) Complementary
1
O
SCDateFromSelection Criteria - Date FromDate
8
SCDateToSelection Criteria - Date ToDate
8
BosCodeBox Set CodeInt
11OBOS
Box Set Definition
BatchNumJournal Voucher No.Int
11OBTD
Journal Vouchers List

Table relationship map

SELECT statement

SELECT OTRS.AbsEntry AS 'Internal Number', OTRS.ObjType AS 'Object Type', OTRS.ReportType AS 'Report Type', OTRS.PeriodType AS 'Report Period Type', OTRS.PeriodNum AS 'Report Period Number', OTRS.Year AS 'Report Year', OTRS.AdjustNum AS 'Report Adjustment Number', OTRS.ApUserSign AS 'Approved By (User Signature)', OTRS.ApDate AS 'Approval Date', OTRS.ApTime AS 'Approval Time', OTRS.DeclType AS 'Declaration Type', OTRS.SCDateFrom AS 'Selection Criteria - Date From', OTRS.SCDateTo AS 'Selection Criteria - Date To', OTRS.BosCode AS 'Box Set Code', OTRS.BatchNum AS 'Journal Voucher No.' FROM OTRS AS OTRS

Related information


OTRS SQL Table

Journal Vouchers List OBTD SQL Table

Box Set Definition OBOS 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