OTOB - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Administration /

1099 Opening Balance

DTW Administration / Setup

API OTOB

OTOB - 1099 Opening Balance 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

OTNN SQL Table

OCRD SQL Table

biuan SAP® BUSINESS ONE

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