|
|
SQL Administration / 1099 Forms
DTW Administration / Setup / Financials / Forms 1099
API OTNN / Forms 1099
OTNN - 1099 Forms Table
Forms 1099 Forms1099 Object· Table: OTNN
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 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Form1099 KEY UNIQUE | 1099 Form | nVarChar | 100 | NAME | Yes | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Locked | Locked | VarChar | N) Changeable Y) Locked | 1 | N |
Table relationship map
SELECT statement
SELECT
OTNN.FormCode AS 'Form Code',
OTNN.Form1099 AS '1099 Form',
OTNN.UserSign AS 'User Signature',
OTNN.Locked AS 'Locked'
FROM OTNN AS OTNN
Related information
Forms 1099 Forms1099 Object· Table: OTNN
Forms1099 object enables to define new Form 1099 types in addition to the existing types: 1099 Miscellaneous, 1099 Interest, and 1099 Dividends.
Source table: OTNN.
OTNN SQL Table
Users OUSR SQL Table
Forms1099
Method
Object
Boxes1099 TNN1
Property
Form1099
DTW DB
FormCode
DTW DB
Collection
Enumeration
Method
Object
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates