biuan SAP® BUSINESS ONE SDK
API ADRC
ADRC - G/L Account Determination Criteria - Resources - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DmcId KEY UNIQUEDetermination IDInt
11
PRIMARYYes
DmcAliasDetermination AliasnVarChar
100
ActiveDetermination StatusVarChar
Y) Yes
N) No
1
N
PriorityDetermination PriorityInt
6
LogInstancLog InstanceInt
11
UpdateDateDate of UpdateDate
8
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
AdvRulColAdvanced Rules ColumnInt
6

SELECT statement

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

Related information


Users OUSR SQL Table



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