|
|
DTW Administration / Setup
API OTOB
OTOB - 1099 Opening Balance Table
1099 Forms OTNN SQL Table
Business Partner OCRD SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | VendCode KEY UNIQUE | Vendor Code | nVarChar | 15 | OCRD Business Partner | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Form1099 | 1099 Form | Int | 11 | OTNN 1099 Forms | ||||
| Box1099 | 1099 Box | nVarChar | 20 | |||||
| PostDate | Posting Date | Date | 8 | |||||
| AmountLC | Amount (LC) | Num | 20 | |||||
| Submitted | Submitted | VarChar | Y) Yes N) New | 1 | N |
Table relationship map
SELECT statement
SELECT
OTOB.VendCode AS 'Vendor Code',
OTOB.Form1099 AS '1099 Form',
OTOB.Box1099 AS '1099 Box',
OTOB.PostDate AS 'Posting Date',
OTOB.AmountLC AS 'Amount (LC)',
OTOB.Submitted AS 'Submitted'
FROM OTOB AS OTOB
Related information
1099 Forms OTNN SQL Table
Business Partner OCRD SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates