|
|
DTW Administration / Setup / Financials / Forms 1099 / 1099 Boxes
API Forms 1099 / Boxes 1099
TNN1 - 1099 Boxes Table
Boxes 1099 Boxes1099 Object· Table: TNN1
Parent: Forms 1099 Forms1099 Object· Table: OTNN
1099 Forms OTNN SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | FormCode KEY UNIQUE | Form Code | Int | 11 | OTNN 1099 Forms | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Box1099 | 1099 Box | nVarChar | 20 | |||||
| BoxDescr | Box Description | nVarChar | 100 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Locked | Locked | VarChar | N) Changeable Y) Locked | 1 | N | |||
| Min1099Amt | Minimum 1099 Amount | Num | 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
Forms1099
Object
Boxes1099
Method
Property
Box1099
DTW DB
BoxDescription
DTW DB
FormCode
DB
Minimum1099Amount
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
