biuan SAP® BUSINESS ONE SDK
API APRC
APRC - Cost Center Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PrcCode KEY UNIQUECenter CodenVarChar
8
PRIMARYYes
PrcNameCenter NamenVarChar
30
GrpCodeGroup CodenVarChar
4
BalanceBalanceNum
20
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
CCTypeCodeCost Center Type CodenVarChar
8OCCT
Cost Center Type
ValidFromValid FromDate
8
ValidToValid ToDate
8
ActiveActiveVarChar
Y) Yes
N) No
1
Y
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8

Table relationship map

SELECT statement

SELECT APRC.PrcCode AS 'Center Code', APRC.PrcName AS 'Center Name', APRC.GrpCode AS 'Group Code', APRC.Balance AS 'Balance', APRC.Locked AS 'Locked', APRC.DataSource AS 'Data Source', APRC.UserSign AS 'User Signature', APRC.DimCode AS 'In Which Dimension', APRC.CCTypeCode AS 'Cost Center Type Code', APRC.ValidFrom AS 'Valid From', APRC.ValidTo AS 'Valid To', APRC.Active AS 'Active', APRC.LogInstanc AS 'Log Instance', APRC.UserSign2 AS 'Updating User', APRC.UpdateDate AS 'Update Date' FROM APRC AS APRC

Related information


Cost Center Type OCCT SQL Table

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