biuan SAP® BUSINESS ONE SDK
API AMDR
AMDR - Manual Distribution Rule Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OcrCode KEY UNIQUEFactor CodenVarChar
8
PRIMARYYes
OcrNameFactor DescriptionnVarChar
30
OcrTotalTotal FactorNum
20
DirectDirectVarChar
Y) Yes
N) No
1
N
LockedLockedVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
DimCodeIn Which DimensionInt
6ODIM
Cost Accounting Dimension
1
AbsEntryNumeratorInt
11
ActiveActiveVarChar
Y) Yes
N) No
1
Y
logInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
updateDateDate of UpdateDate
8

Table relationship map

SELECT statement

SELECT AMDR.OcrCode AS 'Factor Code', AMDR.OcrName AS 'Factor Description', AMDR.OcrTotal AS 'Total Factor', AMDR.Direct AS 'Direct', AMDR.Locked AS 'Locked', AMDR.DataSource AS 'Data Source', AMDR.UserSign AS 'User Signature', AMDR.DimCode AS 'In Which Dimension', AMDR.AbsEntry AS 'Numerator', AMDR.Active AS 'Active', AMDR.logInstanc AS 'Log Instance', AMDR.UserSign2 AS 'Updating User', AMDR.updateDate AS 'Date of Update' FROM AMDR AS AMDR

Related information


Cost Accounting Dimension ODIM SQL Table

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