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

SQL

Finance /

G/L Account Determination Criteria - Inventory - History

API ADMC

ADMC - G/L Account Determination Criteria - Inventory - History Table

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
DmcId ^KEY ^UNIQUE	Determination ID	Int		6			PRIMARY	Yes
DmcAlias	Determination Alias	nVarChar		100
Active	Determination Status	VarChar	Y) Yes N) No	1		N
Priority	Determination Priority	Int		6
LogInstanc	Log Instance	Int		11
UpdateDate	Date of Update	Date		8
UserSign	User Signature	Int		6	OUSR Users
UserSign2	Updating User	Int		6	OUSR Users
AdvRulCol	Advanced Rules Column	Int		6

SELECT statement

SELECT
   ADMC.DmcId AS 'Determination ID', 
   ADMC.DmcAlias AS 'Determination Alias', 
   ADMC.Active AS 'Determination Status', 
   ADMC.Priority AS 'Determination Priority', 
   ADMC.LogInstanc AS 'Log Instance', 
   ADMC.UpdateDate AS 'Date of Update', 
   ADMC.UserSign AS 'User Signature', 
   ADMC.UserSign2 AS 'Updating User', 
   ADMC.AdvRulCol AS 'Advanced Rules Column'
FROM ADMC AS ADMC

Related information

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