SAP Business One 8.8 - Introducing the new Cockpit
Data Type ID in SAP B1
Data Types used in SAP B1
dt_LONG_NUMBER = 0
dt_SHORT_NUMBER = ,
dt_QUANTITY = 2
dt_PRICE = 3
dt_RATE = 4
dt_MEASURE = 5
dt_SUM = 6
dt_PERCENT = 7
dt_LONG_TEXT = 8
dt_SHORT_TEXT = 9
dt_DATE = 10
SAP B1 Control Type Property
The application supports the
following item types:
Member
|
Description
|
Value
|
it_BUTTON
|
Button item. Not relevant in Column.Type.
|
4
|
it_STATIC
|
Static text. Not relevant in Column.Type.
|
8
|
it_EDIT
|
Text Box.
|
16
|
it_FOLDER
|
Tab. Not relevant in Column.Type.
|
99
|
it_RECTANGLE
|
Frame rectangle. Not relevant in
Column.Type.
|
100
|
it_COMBO_BOX
|
Combo Box (List Box, Popup, etc.)
|
113
|
it_LINKED_BUTTON
|
Link arrow to other items.
|
116
|
it_PICTURE
|
Image.
|
117
|
it_EXTEDIT
|
Text Box with multiple lines. Not relevant
in Column.Type.
|
118
|
it_CHECK_BOX
|
Check Box. Not relevant in Column.Type.
|
121
|
it_OPTION_BUTTON
|
Option Button. Not relevant in Column.Type.
|
122
|
it_MATRIX
|
Matrix (table). Not relevant in Column.Type.
|
127
|
it_PANE_COMBO_BOX
|
Pane Combo Box. Not relevant in Column.Type.
|
104
|
it_ACTIVE_X
|
102
|
Convert Date Time Format
SELECT DATENAME(DW,getdate()) Displays the Day
Name of the date
select convert(varchar(10),getdate(),8) GET TIME ONLY FROM SQL
SELECT
convert(datetime, 'Oct 23 2012 11:01AM',
100) -- mon dd yyyy
hh:mmAM (or PM)
SELECT
convert(datetime, 'Oct 23 2012 11:01AM')
-- 2012-10-23 11:01:00.000
SELECT
convert(datetime, 'Oct 23 12 11:01AM', 0) -- mon dd yy hh:mmAM (or
PM)
SELECT
convert(datetime, 'Oct 23 12 11:01AM') -- 2012-10-23 11:01:00.000
SELECT
convert(datetime, '10/23/2016', 101) -- mm/dd/yyyy
SELECT
convert(datetime, '2016.10.23', 102) -- yyyy.mm.dd
SELECT
convert(datetime, '23/10/2016', 103) -- dd/mm/yyyy
SELECT
convert(datetime, '23.10.2016', 104) -- dd.mm.yyyy
SELECT
convert(datetime, '23-10-2016', 105) -- dd-mm-yyyy
SELECT
convert(datetime, '23 OCT 2016', 106) -- dd mon yyyy
SELECT
convert(datetime, 'Oct 23, 2016', 107) -- mon dd, yyyy
SELECT
convert(datetime, '20:10:44', 108) -- hh:mm:ss
SELECT
convert(datetime, 'Oct 23 2016 11:02:44:013AM',
109) -- 2016-10-23
11:02:44.013
SELECT
convert(datetime, '10-23-2016', 110) -- mm-dd-yyyy
SELECT
convert(datetime, '2016/10/23', 111) -- yyyy/mm/dd
SELECT
convert(datetime, '20161023')
SELECT
convert(datetime, '20161023', 112) -- yyyymmdd
SELECT
convert(datetime, '23 Oct 2016 11:02:07:577',
113) -- dd mon yyyy
hh:mm:ss:mmm
SELECT
convert(datetime, '20:10:25:300', 114) -- hh:mm:ss:mmm(24h)
SELECT
convert(datetime, '2016-10-23 20:44:11',
120) -- yyyy-mm-dd
hh:mm:ss(24h)
SELECT
convert(datetime, '2016-10-23 20:44:11.500',
121) -- yyyy-mm-dd
hh:mm:ss.mmm
SELECT
convert(datetime, '2008-10-23T18:52:47.513',
126) --
yyyy-mm-ddThh:mm:ss(.mmm)
SELECT
convert(datetime, STUFF(STUFF('31012016',3,0,'-'),6,0,'-'), 105)
SELECT
convert(datetime, 'Oct 23 16 11:02:44AM')
-- Default
SELECT
convert(datetime, '10/23/16', 1) -- mm/dd/yy U.S.
SELECT
convert(datetime, '16.10.23', 2) -- yy.mm.dd ANSI
SELECT
convert(datetime, '23/10/16', 3) -- dd/mm/yy UK/FR
SELECT
convert(datetime, '23.10.16', 4) -- dd.mm.yy German
SELECT
convert(datetime, '23-10-16', 5) -- dd-mm-yy Italian
SELECT
convert(datetime, '23 OCT 16', 6) -- dd mon yy non-det.
SELECT
convert(datetime, 'Oct 23, 16', 7) -- mon dd, yy non-det.
SELECT
convert(datetime, '20:10:44', 8) -- hh:mm:ss
SELECT
convert(datetime, 'Oct 23 16 11:02:44:013AM',
9) -- Default with
msec
SELECT
convert(datetime, '10-23-16', 10) -- mm-dd-yy U.S.
SELECT
convert(datetime, '16/10/23', 11) -- yy/mm/dd Japan
SELECT
convert(datetime, '161023', 12) -- yymmdd ISO
SELECT
convert(datetime, '23 Oct 16 11:02:07:577',
13) -- dd mon yy
hh:mm:ss:mmm EU dflt
SELECT
convert(datetime, '20:10:25:300', 14) -- hh:mm:ss:mmm(24h)
SELECT
convert(datetime, '2016-10-23 20:44:11',20) -- yyyy-mm-dd
hh:mm:ss(24h) ODBC can.
Refer Links :
Subscribe to:
Posts (Atom)