biuan SAP® BUSINESS ONE SDK
DTW Banking / Outgoing Payments / Checks for Payment / Document Numbering
API Series Service / Document Change Menu Name
ONNM - Document Numbering Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ObjectCode KEY UNIQUEDocumentnVarChar
20
PRIMARYYes
AutoKeyAutomatic KeyInt
11
0
DfltSeriesDefault SeriesInt
6
0
UpdCounterUpdate CounterInt
6
0
UserSignUser SignatureInt
6OUSR
Users
DocSubTypeDocument Sub-TypenVarChar
--)
IE) Invoice Exempt
DN) Debit Memo
IB) Bill
EB) Exempt Bill
RI) Reserve Invoice
IR) Invoice & Receipt
DM) A/P Debit Memo
IX) Export Invoice
RP) A/P Reserve Invoice
OV) Outgoing VAT - Withholding Tax
OG) Outgoing Gross Income - Withholding Tax
ON) Outgoing Income - Withholding Tax
OS) Outgoing Social Security - Withholding Tax
OI) Outgoing Industry Specific - Withholding Tax
OD) Outgoing District Specific - Withholding Tax
IC) Incoming WTax Certificate
2
--
DocAliasAlternative Document NamenVarChar
20
PeriodTypSeq. Period Type of Supply CodeVarChar
1

Table relationship map

SELECT statement

SELECT ONNM.ObjectCode AS 'Document', ONNM.AutoKey AS 'Automatic Key', ONNM.DfltSeries AS 'Default Series', ONNM.UpdCounter AS 'Update Counter', ONNM.UserSign AS 'User Signature', ONNM.DocSubType AS 'Document Sub-Type', ONNM.DocAlias AS 'Alternative Document Name', ONNM.PeriodTyp AS 'Seq. Period Type of Supply Code' FROM ONNM AS ONNM

Related information


Document Change Menu Name DocumentChangeMenuName Object· Table: ONNM
Represents the user-defined menu name for a specific document type/document subtype. For example, the menu for sales order documents is Sales Orders. The name can be changed to Orders (or any other string) with this object. Source table: The...
   Parent: Series Service SeriesService Service· Table: NNM1
ONNM SQL Table

Users OUSR 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