biuan SAP® BUSINESS ONE SDK
SQL Finance / Doc. Type Filter / Doc. Type Filter
DTW Doc. Type Filter
API Tax Report Documents / Tax Report Document
VTR2 - Doc. Type Filter Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ObjectCodeObject CodenVarChar
13) A/R Invoices
14) A/R Credit Memos
18) A/P Invoices
19) A/P Credit Memos
24) Incoming Payments
30) Journal Entries
46) Outgoing Payments
57) Checks for Payment
67) Inventory Transfers
203) A/R Down Payment
204) A/P Down Payment
15
FromDocNoDoc. Number FromInt
11
ToDocNoTo Doc NumberInt
11
SelectedIs Selected Object.VarChar
N) No
Y) Yes
1
N

SELECT statement

SELECT VTR2.AbsEntry AS 'Internal Number', VTR2.ObjectCode AS 'Object Code', VTR2.FromDocNo AS 'Doc. Number From', VTR2.ToDocNo AS 'To Doc Number', VTR2.Selected AS 'Is Selected Object.' FROM VTR2 AS VTR2

Related information


Tax Report Document TaxReportDocument Object· Table: VTR2
TaxReportDocument is a data structure related to the TaxReportsService. Source table: VTR2.
   Parent: Tax Report Documents TaxReportDocuments Collection· Table: VTR2

Tax Report Documents TaxReportDocuments Collection· Table: VTR2
TaxReportDocuments is a Data Collection of TaxReportDocument data structures. Source table: VTR2.
   Parent: Tax Report Filter TaxReportFilter Object· Table: OVTR


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