biuan SAP® BUSINESS ONE SDK
DTW Sales / Correction Invoice Reversal
API PJT1
PJT1 - Project Plan Steps Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
StepCodeStep CodeInt
11
FatherFather Step CodeInt
11
VisOrderVisual OrderInt
11
LevelNode LevelInt
11
StepNameStep NamenVarChar
127
StepInfoStep InfonVarChar
127
StepNotesStep NotesnVarChar
127
StepLinkStep Link to Menu IDnVarChar
32
StartDateStart DateDate
8
EndDateEnd DateDate
8
IsCompleteIs CompleteVarChar
1
LogInstancLog InstanceInt
11
OwnerOwnernVarChar
127OUSR
Users
StatusStatusInt
11
0
DurationDurationNum
20
PlanTimePlanned TimeNum
20
AtcEntryAttachment EntryInt
11OATC
Attachments
TotalPTimeTotal Planned TimeNum
20
QueryIDStep Link Query IDInt
11OUQR
Queries

Table relationship map

SELECT statement

SELECT PJT1.DocEntry AS 'Internal Number', PJT1.StepCode AS 'Step Code', PJT1.Father AS 'Father Step Code', PJT1.VisOrder AS 'Visual Order', PJT1.Level AS 'Node Level', PJT1.StepName AS 'Step Name', PJT1.StepInfo AS 'Step Info', PJT1.StepNotes AS 'Step Notes', PJT1.StepLink AS 'Step Link to Menu ID', PJT1.StartDate AS 'Start Date', PJT1.EndDate AS 'End Date', PJT1.IsComplete AS 'Is Complete', PJT1.LogInstanc AS 'Log Instance', PJT1.Owner AS 'Owner', PJT1.Status AS 'Status', PJT1.Duration AS 'Duration', PJT1.PlanTime AS 'Planned Time', PJT1.AtcEntry AS 'Attachment Entry', PJT1.TotalPTime AS 'Total Planned Time', PJT1.QueryID AS 'Step Link Query ID' FROM PJT1 AS PJT1

Related information


Attachments OATC SQL Table

Users OUSR SQL Table

Queries OUQR 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