biuan SAP® BUSINESS ONE SDK
SQL Finance / Project Codes / Project Codes
DTW Project Codes
API Projects Service / Project
OPRJ - Project Codes Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PrjCode KEY UNIQUEProject CodenVarChar
20
PRIMARYYes
PrjNameProject NamenVarChar
100
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
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 OPRJ.PrjCode AS 'Project Code', OPRJ.PrjName AS 'Project Name', OPRJ.Locked AS 'Locked', OPRJ.DataSource AS 'Data Source', OPRJ.UserSign AS 'User Signature', OPRJ.ValidFrom AS 'Valid From', OPRJ.ValidTo AS 'Valid To', OPRJ.Active AS 'Active', OPRJ.LogInstanc AS 'Log Instance', OPRJ.UserSign2 AS 'Updating User', OPRJ.UpdateDate AS 'Update Date' FROM OPRJ AS OPRJ

Related information


Project Project Object· Table: OPRJ
A data structure object holding properties for the ProjectsService (Code and Name). Source table: OPRJ.
   Parent: Projects Service ProjectsService Service· Table: OPRJ

Projects Service ProjectsService Service· Table: OPRJ
This service manages projects in SAP Business One. The service enables to add or delete projects, and update projects' name and code. Source table: OPRJ.

OPRJ 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