biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup
API OTOB
OTOB - 1099 Opening Balance Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
VendCode KEY UNIQUEVendor CodenVarChar
15OCRD
Business Partner
PRIMARYYes
Form10991099 FormInt
11OTNN
1099 Forms
Box10991099 BoxnVarChar
20
PostDatePosting DateDate
8
AmountLCAmount (LC)Num
20
SubmittedSubmittedVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates