biuan SAP® BUSINESS ONE SDK
SQL Others / FORM resource
API RFRM
RFRM - FORM resource Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CreatedCreation dateDate
8
UpdatedUpdate dateDate
8
Language KEY UNIQUELanguage codeInt
11
NUMYes
Name KEYForm namenVarChar
64
M_NAMENo
Num KEYForm numberInt
11
M_NUMNo
TitleTitlenVarChar
64
TitleUpdTitle updateDate
8
TitleLenTitle lengthInt
11
TypeForm typeInt
0
1) Dialog Box
3) No Title Document
4) Fixed Document
5) Resize No Title Document
6) Toolbar
11
0
CloseBoxClose boxVarChar
0
1) No
1
1
DfltButtonDefault buttonInt
11
0
_TopTopInt
11
1
_BottomBottomInt
11
_LeftLeftInt
11
_RightRightInt
11
DoColorUse color tableVarChar
0
1) No
1
1
CT_SEEDCT_SEEDInt
11
CT_RESERVECT_RESERVEInt
11
CT_SIZECT_SIZEInt
11
CT_S0_VALCT_S0_VALUEInt
11
CT_S0_REDCT_S0_REDInt
11
CT_S0_GRNCT_S0_GREENInt
11
CT_S0_BLUECT_S0_BLUEInt
11
CT_S1_VALCT_S1_VALUEInt
11
CT_S1_REDCT_S1_REDInt
11
CT_S1_GRNCT_S1_GREENInt
11
CT_S1_BLUECT_S1_BLUEInt
11
CT_S2_VALCT_S2_VALUEInt
11
CT_S2_REDCT_S2_REDInt
11
CT_S2_GRNCT_S2_GREENInt
11
CT_S2_BLUECT_S2_BLUEInt
11
CT_S3_VALCT_S3_VALUEInt
11
CT_S3_REDCT_S3_REDInt
11
CT_S3_GRNCT_S3_GREENInt
11
CT_S3_BLUECT_S3_BLUEInt
11
CT_S4_VALCT_S4_VALUEInt
11
CT_S4_REDCT_S4_REDInt
11
CT_S4_GRNCT_S4_GREENInt
11
CT_S4_BLUECT_S4_BLUEInt
11
MaxUniqueMax UniqueInt
11

SELECT statement

SELECT RFRM.Created AS 'Creation date', RFRM.Updated AS 'Update date', RFRM.Language AS 'Language code', RFRM.Name AS 'Form name', RFRM.Num AS 'Form number', RFRM.Title AS 'Title', RFRM.TitleUpd AS 'Title update', RFRM.TitleLen AS 'Title length', RFRM.Type AS 'Form type', RFRM.CloseBox AS 'Close box', RFRM.DfltButton AS 'Default button', RFRM._Top AS 'Top', RFRM._Bottom AS 'Bottom', RFRM._Left AS 'Left', RFRM._Right AS 'Right', RFRM.DoColor AS 'Use color table', RFRM.CT_SEED AS 'CT_SEED', RFRM.CT_RESERVE AS 'CT_RESERVE', RFRM.CT_SIZE AS 'CT_SIZE', RFRM.CT_S0_VAL AS 'CT_S0_VALUE', RFRM.CT_S0_RED AS 'CT_S0_RED', RFRM.CT_S0_GRN AS 'CT_S0_GREEN', RFRM.CT_S0_BLUE AS 'CT_S0_BLUE', RFRM.CT_S1_VAL AS 'CT_S1_VALUE', RFRM.CT_S1_RED AS 'CT_S1_RED', RFRM.CT_S1_GRN AS 'CT_S1_GREEN', RFRM.CT_S1_BLUE AS 'CT_S1_BLUE', RFRM.CT_S2_VAL AS 'CT_S2_VALUE', RFRM.CT_S2_RED AS 'CT_S2_RED', RFRM.CT_S2_GRN AS 'CT_S2_GREEN', RFRM.CT_S2_BLUE AS 'CT_S2_BLUE', RFRM.CT_S3_VAL AS 'CT_S3_VALUE', RFRM.CT_S3_RED AS 'CT_S3_RED', RFRM.CT_S3_GRN AS 'CT_S3_GREEN', RFRM.CT_S3_BLUE AS 'CT_S3_BLUE', RFRM.CT_S4_VAL AS 'CT_S4_VALUE', RFRM.CT_S4_RED AS 'CT_S4_RED', RFRM.CT_S4_GRN AS 'CT_S4_GREEN', RFRM.CT_S4_BLUE AS 'CT_S4_BLUE', RFRM.MaxUnique AS 'Max Unique' FROM RFRM AS RFRM

Related information
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