biuan SAP® BUSINESS ONE SDK
API AOC1
AOC1 - Distribution Rule - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OcrCode KEY UNIQUEFactor CodenVarChar
8OOCR
Distribution Rule
PRIMARYYes
PrcCode KEYCost Center CodenVarChar
8OPRC
Cost Center
PROF_IDNo
PrcAmountTotal in Cost CenterNum
20
OcrTotalTotal FactorNum
20
DirectDirectVarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
ValidFromEffective fromDate
8
ValidToEffective toDate
8
logInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
updateDateDate of UpdateDate
8

Table relationship map

SELECT statement

SELECT AOC1.OcrCode AS 'Factor Code', AOC1.PrcCode AS 'Cost Center Code', AOC1.PrcAmount AS 'Total in Cost Center', AOC1.OcrTotal AS 'Total Factor', AOC1.Direct AS 'Direct', AOC1.UserSign AS 'User Signature', AOC1.ValidFrom AS 'Effective from', AOC1.ValidTo AS 'Effective to', AOC1.logInstanc AS 'Log Instance', AOC1.UserSign2 AS 'Updating User', AOC1.updateDate AS 'Date of Update' FROM AOC1 AS AOC1

Related information


Distribution Rule OOCR SQL Table

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