biuan SAP® BUSINESS ONE SDK
API TRS1
TRS1 - Tax Report Saving Object - Approved Documents Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OTRS
Tax Report Saving Object
SECONDARYYes
ObjTypeObject TypenVarChar
20
LineIDInternal Row NumberInt
11
ApDocTypeApproved Document TypenVarChar
20
ApDocEntryApproved Document KeyInt
11
ApDocOrdNoAppr. Doc. Ordinal NumberInt
11
-1
ApDocAdRefAppr. Doc. Additional ReferenceInt
11
-1
MeansTypePayment Means TypeInt
11
-1
PayLineIDPayment Means Line IDInt
11
-1
PayDocTypePayment Document TypeInt
11
-1
PayDocEntrPayment Document EntryInt
11
-1

SELECT statement

SELECT TRS1.AbsEntry AS 'Internal Number', TRS1.ObjType AS 'Object Type', TRS1.LineID AS 'Internal Row Number', TRS1.ApDocType AS 'Approved Document Type', TRS1.ApDocEntry AS 'Approved Document Key', TRS1.ApDocOrdNo AS 'Appr. Doc. Ordinal Number', TRS1.ApDocAdRef AS 'Appr. Doc. Additional Reference', TRS1.MeansType AS 'Payment Means Type', TRS1.PayLineID AS 'Payment Means Line ID', TRS1.PayDocType AS 'Payment Document Type', TRS1.PayDocEntr AS 'Payment Document Entry' FROM TRS1 AS TRS1

Related information


Tax Report Saving Object OTRS 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