biuan SAP® BUSINESS ONE SDK
SQL Administration / Reference Links Definition
DTW User Defined Data / Formatted Searches
API ORLD
ORLD - Reference Links Definition Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
ObjectCode KEY UNIQUEDocumentnVarChar
20
OBJ_FIELDYes
DocSubTypeDocument SubtypenVarChar
--)
IE) Invoice Exempt
DN) Debit Memo
IB) Bill
EB) Exempt Bill
DM) A/P Debit Memo
IX) Export Invoice
2
--
StatusStatusVarChar
O) Original
C) Customized
1
O

SELECT statement

SELECT ORLD.AbsEntry AS 'Internal Number', ORLD.ObjectCode AS 'Document', ORLD.DocSubType AS 'Document Subtype', ORLD.Status AS 'Status' FROM ORLD AS ORLD

Related information


ORLD 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