Number Counting Method

INR Calculation	Amount	USD Calculation	Power
Unit	1	Unit	1
Tens	10	Tens	101
Hundred	100	Hundred	102
Thousand	1,000	Thousand	103
10 Thousand	10,000	10 Thousand	104
Lakh	1,00,000	100 Thousand	105
10 Lakhs	10,00,000	Million	106
Crore	1,00,00,000	10 Million	107
Arbud (10 Crores)	10,00,00,000	100 Million	108
Ajo/Arab (100 Crores)	1,00,00,00,000	Billion	109
Kharab (10 Arab)	10,00,00,00,000	10 Billion	1010
Nikharab (10 Kharab)	1,00,00,00,00,000	100 Billion	1011
Sankha (10 Nikharab)	10,00,00,00,00,000	Trillion	1012

If there is any other better option,

Please share it here or mail to me arkaa4@gmail.com

Thank You,

Arka Gupta.

http://arkaguptablog.blogspot.in/

https://in.linkedin.com/in/arkagupta

https://plus.google.com/+ArkaGupta-arkagupta/posts

SQL Database Mail Queries in details.

View Database Mail Log : 

SELECT * FROM msdb.dbo.sysmail_log

If you need to see a list of Successful emails you need to run :

SELECT * FROM msdb.dbo.sysmail_mailitems

You will only get the list of Failed emails:

SELECT * FROM msdb.dbo.sysmail_faileditems

List of All emails Event Log:

SELECT * FROM msdb.dbo.sysmail_event_log

Use the below query to get details for All emails sent the same date:

SELECT * FROM msdb..sysmail_mailitems WHERE sent_date > DATEADD(DAY, -1,GETDATE())

Here is the complete query to get All the Failed emails from the past 24 hours:

SELECT items.subject ,

       items.recipients ,

       items.copy_recipients ,

       items.blind_copy_recipients ,

       items.last_mod_date ,

       l.description

FROM   msdb.dbo.sysmail_faileditems AS items

       LEFT OUTER JOIN msdb.dbo.sysmail_event_log AS l

                    ON items.mailitem_id = l.mailitem_id

WHERE  items.last_mod_date > DATEADD(DAY, -1,GETDATE())

Some important Tables for DBMail Account, Profile, Configuration, etc.

SELECT * FROM msdb.dbo.sysmail_profile

SELECT * FROM msdb.dbo.sysmail_profileaccount

SELECT * FROM msdb.dbo.sysmail_account

SELECT * FROM msdb.dbo.sysmail_server

Some important SP for DBMail Account, Profile, Configuration, etc.

EXEC msdb.dbo.sysmail_help_configure_sp;

EXEC msdb.dbo.sysmail_help_account_sp;

EXEC msdb.dbo.sysmail_help_profile_sp;

EXEC msdb.dbo.sysmail_help_profileaccount_sp;

EXEC msdb.dbo.sysmail_help_principalprofile_sp;

All of SQL DBMail details:

SELECT *

FROM msdb.dbo.sysmail_profile p

JOIN msdb.dbo.sysmail_profileaccount pa on p.profile_id = pa.profile_id

JOIN msdb.dbo.sysmail_account a on pa.account_id = a.account_id

JOIN msdb.dbo.sysmail_server s on a.account_id = s.account_id

If there is any other better option,

Please share it here or mail to me arkaa4@gmail.com

Thank You,

Arka Gupta.

http://arkaguptablog.blogspot.in/

https://in.linkedin.com/in/arkagupta

https://plus.google.com/+ArkaGupta-arkagupta/posts

All Object Type in SAP B1

Table	Table Description	Primary Key	Object Type
OACT	G/L Accounts	AcctCode	1
OCRD	Business Partner	CardCode	2
ODSC	Bank Codes	AbsEntry	3
OITM	Items	ItemCode	4
OVTG	Tax Definition	Code	5
OPLN	Price Lists	ListNum	6
OSPP	Special Prices	CardCode, ItemCode	7
OITG	Item Properties	ItmsTypCod	8
ORTM	Rate Differences	LineNum, IsSysCurr	9
OCRG	Card Groups	GroupCode	10
OCPR	Contact Persons	CntctCode	11
OUSR	Users	USERID	12
OINV	A/R Invoice	DocEntry	13
ORIN	A/R Credit Memo	DocEntry	14
ODLN	Delivery	DocEntry	15
ORDN	Returns	DocEntry	16
ORDR	Sales Order	DocEntry	17
OPCH	A/P Invoice	DocEntry	18
ORPC	A/P Credit Memo	DocEntry	19
OPDN	Goods Receipt PO	DocEntry	20
ORPD	Goods Return	DocEntry	21
OPOR	Purchase Order	DocEntry	22
OQUT	Sales Quotation	DocEntry	23
ORCT	Incoming Payment	DocEntry	24
ODPS	Deposit	DeposId	25
OMTH	Reconciliation History	MthAcctCod, IsInternal, MatchNum	26
OCHH	Check Register	CheckKey	27
OBTF	Journal Voucher Entry	BatchNum, TransId	28
OBTD	Journal Vouchers List	BatchNum	29
OJDT	Journal Entry	TransId	30
OITW	Items – Warehouse	ItemCode, WhsCode	31
OADP	Print Preferences	PrintId	32
OCLG	Activities	ClgCode	33
ORCR	Recurring Postings	RcurCode, Instance	34
ONNM	Document Numbering	ObjectCode, DocSubType	35
OCRC	Credit Cards	CreditCard	36
OCRN	Currency Codes	CurrCode	37
OIDX	CPI Codes	IdexCode	38
OADM	Administration	Code	39
OCTG	Payment Terms	GroupNum	40
OPRF	Preferences	FormNumber, UserSign	41
OBNK	External Bank Statement Received	AcctCode, Sequence	42
OMRC	Manufacturers	FirmCode	43
OCQG	Card Properties	GroupCode	44
OTRC	Journal Entry Codes	TrnsCode	45
OVPM	Outgoing Payments	DocEntry	46
OSRL	Serial Numbers	ItemCode, SerialNum	47
OALC	Loading Expenses	AlcCode	48
OSHP	Delivery Types	TrnspCode	49
OLGT	Length Units	UnitCode	50
OWGT	Weight Units	UnitCode	51
OITB	Item Groups	ItmsGrpCod	52
OSLP	Sales Employee	SlpCode	53
OFLT	Report – Selection Criteria	FormNum, UserSign, FilterName	54
OTRT	Posting Templates	TrtCode	55
OARG	Customs Groups	CstGrpCode	56
OCHO	Checks for Payment	CheckKey	57
OINM	Whse Journal	TransNum, Instance	58
OIGN	Goods Receipt	DocEntry	59
OIGE	Goods Issue	DocEntry	60
OPRC	Cost Center	PrcCode	61
OOCR	Cost Rate	OcrCode	62
OPRJ	Project Codes	PrjCode	63
OWHS	Warehouses	WhsCode	64
OCOG	Commission Groups	GroupCode	65
OITT	Product Tree	Code	66
OWTR	Inventory Transfer	DocEntry	67
OWKO	Production Instructions	OrderNum	68
OIPF	Landed Costs	DocEntry	69
OCRP	Payment Methods	CrTypeCode	70
OCDT	Credit Card Payment	Code	71
OCRH	Credit Card Management	AbsId, Instance	72
OSCN	Customer/Vendor Cat. No.	ItemCode, CardCode, Substitute	73
OCRV	Credit Payments	AbsId, PayId, Instance	74
ORTT	CPI and FC Rates	RateDate, Currency	75
ODPT	Postdated Deposit	DeposId	76
OBGT	Budget	AbsId	77
OBGD	Budget Cost Assess. Mthd	BgdCode	78
ORCN	Retail Chains	ChainCode	79
OALT	Alerts Template	Code	80
OALR	Alerts	Code	81
OAIB	Received Alerts	AlertCode, UserSign	82
OAOB	Message Sent	AlertCode, UserSign	83
OCLS	Activity Subjects	Code	84
OSPG	Special Prices for Groups	CardCode, ObjType, ObjKey	85
SPRG	Application Start	LineNum, UserCode	86
OMLS	Distribution List	Code	87
OENT	Shipping Types	DocEntry	88
OSAL	Outgoing	DocEntry	89
OTRA	Transition	DocEntry	90
OBGS	Budget Scenario	AbsId	91
OIRT	Interest Prices	Numerator	92
OUDG	User Defaults	Code	93
OSRI	Serial Numbers for Items	ItemCode, SysSerial	94
OFRT	Financial Report Templates	AbsId	95
OFRC	Financial Report Categories	TemplateId, CatId	96
OOPR	Opportunity	OpprId	97
OOIN	Interest	Num	98
OOIR	Interest Level	Num	99
OOSR	Information Source	Num	100
OOST	Opportunity Stage	Num	101
OOFR	Defect Cause	Num	102
OCLT	Activity Types	Code	103
OCLO	Meetings Location	Code	104
OISR	Service Calls	RequestNum	105
OIBT	Batch No. for Item	ItemCode, BatchNum, WhsCode	106
OALI	Alternative Items 2	OrigItem, AltItem	107
OPRT	Partners	PrtId	108
OCMT	Competitors	CompetId	109
OUVV	User Validations	IndexID, LineNum	110
OFPR	Posting Period	AbsEntry	111
ODRF	Drafts	DocEntry	112
OSRD	Batches and Serial Numbers	ItemCode, DocType, DocEntry, DocLineNum	113
OUDC	User Display Cat.	CodeID	114
OPVL	Lender – Pelecard	Code	115
ODDT	Withholding Tax Deduction Hierarchy	Numerator	116
ODDG	Withholding Tax Deduction Groups	Numerator	117
OUBR	Branches	Code	118
OUDP	Departments	Code	119
OWST	Confirmation Level	WstCode	120
OWTM	Approval Templates	WtmCode	121
OWDD	Docs. for Confirmation	WddCode	122
OCHD	Checks for Payment Drafts	CheckKey	123
CINF	Company Info	Version	124
OEXD	Freight Setup	ExpnsCode	125
OSTA	Sales Tax Authorities	Code, Type	126
OSTT	Sales Tax Authorities Type	AbsId	127
OSTC	Sales Tax Codes	Code	128
OCRY	Countries	Code	129
OCST	States	Country, Code	130
OADF	Address Formats	Code	131
OCIN	A/R Correction Invoice	DocEntry	132
OCDC	Cash Discount	Code	133
OQCN	Query Catagories	CategoryId	134
OIND	Triangular Deal	Code	135
ODMW	Data Migration	Code	136
OCSTN	Workstation ID	Code	137
OIDC	Indicator	Code	138
OGSP	Goods Shipment	Code	139
OPDF	Payment Draft	DocEntry	140
OQWZ	Query Wizard	Code	141
OASG	Account Segmentation	AbsId	142
OASC	Account Segmentation Categories	SegmentId, Code	143
OLCT	Location	Code	144
OTNN	1099 Forms	FormCode	145
OCYC	Cycle	Code	146
OPYM	Payment Methods for Payment Wizard	PayMethCod	147
OTOB	1099 Opening Balance	VendCode, Form1099, Box1099	148
ORIT	Dunning Interest Rate	Code	149
OBPP	BP Priorities	PrioCode	150
ODUN	Dunning Letters	LineNum	151
CUFD	User Fields – Description	TableID, FieldID	152
OUTB	User Tables	TableName	153
OCUMI	My Menu Items	UserSign , Id_	154
OPYD	Payment Run	Code	155
OPKL	Pick List	AbsEntry	156
OPWZ	Payment Wizard	IdNumber	157
OPEX	Payment Results Table	AbsEntry	158
OPYB	Payment Block	AbsEntry	159
OUQR	Queries	IntrnalKey, Qcategory	160
OCBI	Central Bank Ind.	Indicator	161
OMRV	Inventory Revaluation	DocEntry	162
OCPI	A/P Correction Invoice	DocEntry	163
OCPV	A/P Correction Invoice Reversal	DocEntry	164
OCSI	A/R Correction Invoice	DocEntry	165
OCSV	A/R Correction Invoice Reversal	DocEntry	166
OSCS	Service Call Statuses	statusID	167
OSCT	Service Call Types	callTypeID	168
OSCP	Service Call Problem Types	prblmTypID	169
OCTT	Contract Template	TmpltName	170
OHEM	Employees	empID	171
OHTY	Employee Types	typeID	172
OHST	Employee Status	statusID	173
OHTR	Termination Reason	reasonID	174
OHED	Education Types	edType	175
OINS	Customer Equipment Card	insID	176
OAGP	Agent Name	AgentCode	177
OWHT	Withholding Tax	WTCode	178
ORFL	Already Displayed 347, 349 and WTax Reports	DocEntry, ReportType, DocType, LineNum, TaxCode, OrdinalNum	179
OVTR	Tax Report	AbsEntry	180
OBOE	Bill of Exchange for Payment	BoeKey	181
OBOT	Bill Of Exchang Transaction	AbsEntry	182
OFRM	File Format	AbsEntry	183
OPID	Period Indicator	Indicator	184
ODOR	Doubtful Debts	AbsEntry	185
OHLD	Holiday Table	HldCode	186
OCRB	BP – Bank Account	Country, BankCode, Account, CardCode	187
OSST	Service Call Solution Statuses	Number	188
OSLT	Service Call Solutions	SltCode	189
OCTR	Service Contracts	ContractID	190
OSCL	Service Calls	callID	191
OSCO	Service Call Origins	originID	192
OUKD	User Key Description	TableName, KeyId	193
OQUE	Queue	queueID	194
OIWZ	Inflation Wizard	AbsEntry	195
ODUT	Dunning Terms	TermCode	196
ODWZ	Dunning Wizard	WizardId	197
OFCT	Sales Forecast	AbsID	198
OMSN	MRP Scenarios	AbsEntry	199
OTER	Territories	territryID	200
OOND	Industries	IndCode	201
OWOR	Production Order	DocEntry	202
ODPI	A/R Down Payment	DocEntry	203
ODPO	A/P Down Payment	DocEntry	204
OPKG	Package Types	PkgCode	205
OUDO	User-Defined Object	Code	206
ODOW	Data Ownership – Objects	Object, SubObject	207
ODOX	Data Ownership – Exceptions	QueryId, Object, SubObject	208
			209
OHPS	Employee Position	posID	210
OHTM	Employee Teams	teamID	211
OORL	Relationships	OrlCode	212
ORCM	Recommendation Data	DocEntry	213
OUPT	User Autorization Tree	AbsId	214
OPDT	Predefined Text	AbsEntry	215
OBOX	Box Definition	BoxCode, ReportType, BosCode	216
OCLA	Activity Status	statusID	217
OCHF	312	ObjName	218
OCSHS	User-Defined Values	IndexID	219
OACP	Periods Category	AbsEntry	220
OATC	Attachments	AbsEntry	221
OGFL	Grid Filter	FormID, GridID, UserCode	222
OLNG	User Language Table	Code	223
OMLT	Multi-Language Translation	TranEntry	224
OAPA3			225
OAPA4			226
OAPA5			227
SDIS	Dynamic Interface (Strings)	FormId, ItemId, ColumnId, Language	229
OSVR	Saved Reconciliations	acctCode	230
DSC1	House Bank Accounts	AbsEntry	231
RDOC	Document	DocCode	232
ODGP	Document Generation Parameter Sets	AbsEntry	233
OMHD	#740	AlertCode	234
OACG	Account Category	AbsId	238
OBCA	Bank Charges Allocation Codes	Code	239
OCFT	Cash Flow Transactions – Rows	CFTId	241
OCFW	Cash Flow Line Item	CFWId	242
OBPL	Business Place	BPLId	247
OJPE	Local Era Calendar	Code	250
ODIM	Cost Accounting Dimension	DimCode	251
OSCD	Service Code Table	AbsEntry	254
OSGP	Service Group for Brazil	AbsEntry	255
OMGP	Material Group	AbsEntry	256
ONCM	NCM Code	AbsEntry	257
OCFP	CFOP for Nota Fiscal	ID	258
OTSC	CST Code for Nota Fiscal	ID	259
OUSG	Usage of Nota Fiscal	ID	260
OCDP	Closing Date Procedure	ClsDateNum	261
ONFN	Nota Fiscal Numbering	ObjectCode, DocSubType	263
ONFT	Nota Fiscal Tax Category (Brazil)	AbsId	264
OCNT	Counties	AbsId	265
OTCD	Tax Code Determination	AbsId	266
ODTY	BoE Document Type	AbsEntry	267
OPTF	BoE Portfolio	AbsEntry	268
OIST	BoE Instruction	AbsEntry	269
OTPS	Tax Parameter	AbsId	271
OTFC	Tax Type Combination	AbsId	275
OFML	Tax Formula Master Table	AbsId	276
OCNA	CNAE Code	AbsId	278
OTSI	Sales Tax Invoice	DocEntry	280
OTPI	Purchase Tax Invoice	DocEntry	281
OCCD	Cargo Customs Declaration Numbers	CCDNum	283
ORSC	Resources	ResCode	290
ORSG	Resource Properties	ResTypCod	291
ORSB	ResGrpCod	ResGrpCod	292
	RecordSet		300
	Bridge		305
OITR	Internal Reconciliation	ReconNum	321
OPOS	POS Master Data	EquipNo	541
ODRF	Stock Transfer Draft	DocEntry	1179
OMSG	Messaging Service Settings	USERID	10000105
OBTN	Batch Numbers Master Data	AbsEntry	10000044
OSRN	Serial Numbers Master Data	AbsEntry	10000045
OIVK	IVL Vs OINM Keys	TransSeq	10000062
OIQR	Inventory Posting	DocEntry	10000071
OFYM	Financial Year Master	AbsId	10000073
OSEC	Sections	AbsId	10000074
OCSN	Certificate Series	AbsId	10000075
ONOA	Nature of Assessee	AbsId	10000077
RTYP	Document Type List	CODE	10000196
OUGP	UoM Group	UgpEntry	10000197
OUOM	UoM Master Data	UomEntry	10000199
OBFC	Bin Field Configuration	AbsEntry	10000203
OBAT	Bin Location Attribute	AbsEntry	10000204
OBSL	Warehouse Sublevel	AbsEntry	10000205
OBIN	Bin Location	AbsEntry	10000206
ODNF	DNF Code	AbsEntry	140000041
OUGR	Authorization Group	GroupId	231000000
OEGP	E-Mail Group	EmlGrpCode	234000004
OGPC	Government Payment Code	AbsId	243000001
OIQI	Inventory Opening Balance	DocEntry	310000001
OBTW	Batch Attributes in Location	AbsEntry	310000008
OLLF	Legal List Format	AbsEntry	410000005
OHET	Object: HR Employee Transfer	TransferID	480000001
OTCX	Tax Code Determination	DocEntry	540000005
OPQT	Purchase Quotation	DocEntry	540000006
ORCP	Recurring Transaction Template	AbsEntry	540000040
OCCT	Cost Center Type	CctCode	540000042
OACR	Accrual Type	Code	540000048
ONFM	Nota Fiscal Model	AbsEntry	540000056
OBFI	Brazil Fuel Indexer	ID	540000067
OBBI	Brazil Beverage Indexer	ID	540000068
OCPT	Cockpit Main Table	AbsEntry	1210000000
OWTQ	Inventory Transfer Request	DocEntry	1250000001
OOAT	Blanket Agreement	AbsID	1250000025
OKPI	Key Performance Indicator Package	AbsEntry	1320000000
OTGG	Target Group	TargetCode	1320000002
OCPN	Campaign	CpnNo	1320000012
OROC	Retorno Operation Codes	AbsEntry	1320000028
OPSC	Product Source Code	Code	1320000039
ODTP	Fixed Assets Depreciation Types	Code	1470000000
OADT	Fixed Assets Account Determination	Code	1470000002
ODPA	Fixed Asset Depreciation Areas	Code	1470000003
ODPP	Depreciation Type Pools	Code	1470000004
OACS	Asset Classes	Code	1470000032
OAGS	Asset Groups	Code	1470000046
ODMC	G/L Account Determination Criteria – Inventory	DmcId	1470000048
OACQ	Capitalization	DocEntry	1470000049
OGAR	G/L Account Advanced Rules	AbsEntry	1470000057
OACD	Credit Memo	DocEntry	1470000060
OBCD	Bar Code Master Data	BcdEntry	1470000062
OINC	Inventory Counting	DocEntry	1470000065
OEDG	Discount Groups	AbsEntry	1470000077
OCCS	Cycle Count Determination	WhsCode	1470000092
OPRQ	Purchase Request	DocEntry	1470000113
OWLS	Workflow – Task Details	TaskID	1620000000

If there is any other information wrong or missing,

Please share it here or mail to me arkaa4@gmail.com

Thank You,

Arka Gupta.

http://arkaguptablog.blogspot.in/

https://in.linkedin.com/in/arkagupta

https://plus.google.com/+ArkaGupta-arkagupta/posts