biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Forms 1099 / 1099 Boxes
API Forms 1099 / Boxes 1099
TNN1 - 1099 Boxes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FormCode KEY UNIQUEForm CodeInt
11OTNN
1099 Forms
PRIMARYYes
Box10991099 BoxnVarChar
20
BoxDescrBox DescriptionnVarChar
100
UserSignUser SignatureInt
6OUSR
Users
LockedLockedVarChar
N) Changeable
Y) Locked
1
N
Min1099AmtMinimum 1099 AmountNum
20

Table relationship map

SELECT statement

SELECT TNN1.FormCode AS 'Form Code', TNN1.Box1099 AS '1099 Box', TNN1.BoxDescr AS 'Box Description', TNN1.UserSign AS 'User Signature', TNN1.Locked AS 'Locked', TNN1.Min1099Amt AS 'Minimum 1099 Amount' FROM TNN1 AS TNN1

Related information


Boxes 1099 Boxes1099 Object· Table: TNN1
Boxes1099 is a child object of the Forms1099 object. It enables to add 1099 reporting boxes to a specified 1099 Form type. Source table: TNN1.
   Parent: Forms 1099 Forms1099 Object· Table: OTNN
1099 Forms OTNN 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