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

SQL

Human Resources /

Employee ID Type

API OIDT

OIDT - Employee ID Type Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
IDType ^KEY ^UNIQUE	ID Type	nVarChar		30			PRIMARY	Yes
Locked	Locked	VarChar	Y) Yes N) No	1		N
DataSource	Data Source	VarChar	N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer	1		N
UserSign	User Signature	Int		6	OUSR Users

Table relationship map

SELECT statement

SELECT
   OIDT.IDType AS 'ID Type', 
   OIDT.Locked AS 'Locked', 
   OIDT.DataSource AS 'Data Source', 
   OIDT.UserSign AS 'User Signature'
FROM OIDT AS OIDT

Related information

OIDT SQL Table

OUSR 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