biuan SAP® BUSINESS ONE SDK
API OTRB
OTRB - Tax Report Wizard for Brazil Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
BPLIdBranch IDInt
11OBPL
Business Place
GPCIdGovernment Payment CodeInt
11OGPC
Government Payment Code
GPCCodeGovernment Payment CodenVarChar
6
YearReporting YearInt
6
PrdTypePeriod TypeVarChar
Q) Quarter
M) Month
H) Half Month
T) Ten Days
1
PrdNumPeriod NumberInt
11
PrdDatePeriod Date ToDate
8
RunName KEY UNIQUEWizard Run NamenVarChar
100
SECONDARYYes
RunDateWizard Run DateDate
8
StatusWizard Run StatusVarChar
S) Saved
E) Executed
C) Canceled
1
StateTaxState TaxVarChar
Y) Yes
N) No
1
N
DueDateDue DateDate
8
UserSignUser SignatureInt
6
UserSign2Updating UserInt
6
CreateDateCreation DateDate
8
CreateTimeGeneration TimeInt
6
UpdateDateDate of UpdateDate
8

Table relationship map

SELECT statement

SELECT OTRB.AbsEntry AS 'Internal Number', OTRB.BPLId AS 'Branch ID', OTRB.GPCId AS 'Government Payment Code', OTRB.GPCCode AS 'Government Payment Code', OTRB.Year AS 'Reporting Year', OTRB.PrdType AS 'Period Type', OTRB.PrdNum AS 'Period Number', OTRB.PrdDate AS 'Period Date To', OTRB.RunName AS 'Wizard Run Name', OTRB.RunDate AS 'Wizard Run Date', OTRB.Status AS 'Wizard Run Status', OTRB.StateTax AS 'State Tax', OTRB.DueDate AS 'Due Date', OTRB.UserSign AS 'User Signature', OTRB.UserSign2 AS 'Updating User', OTRB.CreateDate AS 'Creation Date', OTRB.CreateTime AS 'Generation Time', OTRB.UpdateDate AS 'Date of Update' FROM OTRB AS OTRB

Related information


OTRB SQL Table

Business Place OBPL SQL Table

Government Payment Code OGPC 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