biuan SAP® BUSINESS ONE SDK
SQL Others / Route Stages
API ORST
ORST - Route Stages Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUERoute Stage Internal NumberInt
11
PRIMARYYes
RStageCode KEY UNIQUERoute Stage CodenVarChar
40
SECONDARYYes
RStagDescrRoute Stage DescriptionnVarChar
120
BarCodeValBar CodenVarChar
60
EnforLocatEnforce Route LocationVarChar
Y) Yes
N) No
1
N
EnforCommeEnforce Comment on ProcessingVarChar
Y) Yes
N) No
1
N
EnforOwnerEnforce OwnershipVarChar
Y) Yes
N) No
1
N
AllowMulOwMultiple Ownership AllowedVarChar
Y) Yes
N) No
1
N
EnforTmRecActual Time Recording EnforcedVarChar
Y) Yes
N) No
1
N
EnforQCQuality Check EnforcedVarChar
Y) Yes
N) No
1
N
EnforPasswPassword EnforcedVarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6
UpdateDateDate of UpdateDate
8
UserSign2Updating UserInt
6
LogInstancLog InstanceInt
11
0

SELECT statement

SELECT ORST.AbsEntry AS 'Route Stage Internal Number', ORST.RStageCode AS 'Route Stage Code', ORST.RStagDescr AS 'Route Stage Description', ORST.BarCodeVal AS 'Bar Code', ORST.EnforLocat AS 'Enforce Route Location', ORST.EnforComme AS 'Enforce Comment on Processing', ORST.EnforOwner AS 'Enforce Ownership', ORST.AllowMulOw AS 'Multiple Ownership Allowed', ORST.EnforTmRec AS 'Actual Time Recording Enforced', ORST.EnforQC AS 'Quality Check Enforced', ORST.EnforPassw AS 'Password Enforced', ORST.UserSign AS 'User Signature', ORST.UpdateDate AS 'Date of Update', ORST.UserSign2 AS 'Updating User', ORST.LogInstanc AS 'Log Instance' FROM ORST AS ORST

Related information


ORST 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