Objects ID List
The following table lists the business objects that are exposed through the DI API.
Object Name Object ID Description
ACT 1 Chart of Accounts
CRD 2 Business Partner Cards
ITM 4 Items
PLN 6 Price list names
SPP 7 Special prices
CPR 11 Contact employees
USR 12 Users
INV 13 Invoices
RIN 14 Credit notes
DLN 15 Delivery notes
RDN 16 Revert delivery notes
RDR 17 Orders
PCH 18 Purchases
RPC 19 Revert purchases
PDN 20 Purchase delivery notes
RPD 21 Revert purchase delivery notes
POR 22 Purchase orders
QUT 23 Quotations
RCT 24 Receipts incoming payments
DPS 25 Bill of Exchange Deposits
BTD 28 Journal vouchers
JDT 30 Journal entries
ITW 31 Item warehouse
CLG 33 Contact activities
CRN 37 Currency codes
CTG 40 Payment terms types
BNK 42 Bank pages
VPM 46 Payments to vendors
ITB 52 Item groups
CHO 57 Checks for payment
IGN 59 Inventory general entry
IGE 60 Inventory general exit
WHS 64 Warehouses codes and names
ITT 66 Product trees
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)