| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
API OTRB | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
OTRB - Tax Report Wizard for Brazil Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationOTRB 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. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |