biuan SAP® BUSINESS ONE SDK
API APRJ
APRJ - 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

SELECT statement

SELECT APRJ.PrjCode AS 'Project Code', APRJ.PrjName AS 'Project Name', APRJ.Locked AS 'Locked', APRJ.DataSource AS 'Data Source', APRJ.UserSign AS 'User Signature', APRJ.ValidFrom AS 'Valid From', APRJ.ValidTo AS 'Valid To', APRJ.Active AS 'Active', APRJ.LogInstanc AS 'Log Instance', APRJ.UserSign2 AS 'Updating User', APRJ.UpdateDate AS 'Update Date' FROM APRJ AS APRJ

Related information


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