biuan SAP® BUSINESS ONE SDK
SQL Finance / G/L Account Determination Criteria - Inventory / G/L Account Determination Criteria - Inventory
DTW G/L Account Determination Criteria - Inventory
API Determination Criterias Service / Determination Criteria
ODMC - G/L Account Determination Criteria - Inventory Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DmcId KEY UNIQUEDetermination IDInt
6
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 ODMC.DmcId AS 'Determination ID', ODMC.DmcAlias AS 'Determination Alias', ODMC.Active AS 'Determination Status', ODMC.Priority AS 'Determination Priority', ODMC.LogInstanc AS 'Log Instance', ODMC.UpdateDate AS 'Date of Update', ODMC.UserSign AS 'User Signature', ODMC.UserSign2 AS 'Updating User', ODMC.AdvRulCol AS 'Advanced Rules Column' FROM ODMC AS ODMC

Related information


Determination Criteria DeterminationCriteria Object· Table: ODMC
The available determination criteria are predefined (you cannot define additional determination criteria): Item Group Item Code Warehouse Code Business Partner Group Ship-to Country Ship-to State You can activate and...
   Parent: Determination Criterias Service DeterminationCriteriasService Service· Table: ODMC

Determination Criterias Service DeterminationCriteriasService Service· Table: ODMC
The DeterminationCriteriasService service enables you to look up and update determination criteria. Source table: ODMC.

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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates