biuan SAP® BUSINESS ONE SDK
API ORFL
ORFL - Already Displayed 347, 349 and WTax Reports Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ReportTypeReport TypeInt
1) 347
2) 349
3) WT
4) O & P
5) Annual List
6) Tax Report
11
DocTypeDocument TypenVarChar
13) Invoice
14) Revert Invoice
18) Purchase
19) Revert purchase
203) A/R Down Payment
204) A/P Down Payment
20
DocEntry KEY UNIQUEDocument Internal IDInt
11
PRIMARYYes
LineNumRow No.Int
11
TaxCodeTax CodenVarChar
8
OrdinalNumOrdinal Num (BTF & Cancelled)Int
11
-1

SELECT statement

SELECT ORFL.ReportType AS 'Report Type', ORFL.DocType AS 'Document Type', ORFL.DocEntry AS 'Document Internal ID', ORFL.LineNum AS 'Row No.', ORFL.TaxCode AS 'Tax Code', ORFL.OrdinalNum AS 'Ordinal Num (BTF & Cancelled)' FROM ORFL AS ORFL

Related information




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