biuan SAP® BUSINESS ONE SDK
API TRB5
TRB5 - Tax Report Wizard Reported Tax Sums Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OTRB
Tax Report Wizard for Brazil
PRIMARYYes
StateState CodenVarChar
3OCST
States
CardCodeVendor CodenVarChar
15OCRD
Business Partner
TransCrdtTransferred CreditNum
20
TotalDbtTotal Reported DebitNum
20
TtlDbtScTotal Reported Debit SCNum
20
TotalCrdtTotal Reported CreditNum
20
TtlCrdtScTotal Reported Credit SCNum
20
TotalDedTotal Reported Tax DeductionsNum
20
TtlDedScTotal Reported Tax Deductions SCNum
20
BlncDueBalance DueNum
20
TransIdTransaction NumberInt
11OJDT
Journal Entry

Table relationship map

SELECT statement

SELECT TRB5.AbsEntry AS 'Internal Number', TRB5.State AS 'State Code', TRB5.CardCode AS 'Vendor Code', TRB5.TransCrdt AS 'Transferred Credit', TRB5.TotalDbt AS 'Total Reported Debit', TRB5.TtlDbtSc AS 'Total Reported Debit SC', TRB5.TotalCrdt AS 'Total Reported Credit', TRB5.TtlCrdtSc AS 'Total Reported Credit SC', TRB5.TotalDed AS 'Total Reported Tax Deductions', TRB5.TtlDedSc AS 'Total Reported Tax Deductions SC', TRB5.BlncDue AS 'Balance Due', TRB5.TransId AS 'Transaction Number' FROM TRB5 AS TRB5

Related information


Tax Report Wizard for Brazil OTRB SQL Table

Business Partner OCRD SQL Table

States OCST SQL Table

Journal Entry OJDT 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