Main Table for Document

[Former Member]

Dear all ,

Can any one tell me the main table of document codes (and description)

i.e IN for Sales Invoice OB for Opening balance etc

Regards,

Ghazanfar

[former_member187989]

hi,

Available in [SDK Help Center 2005] - Database tables reference.

Jeyakanthan

[Former Member]

Dear Jeyakanthan,

Please tell me the name , I have searched it before asking the question.For distinguish among documents I need its codes and description (i.e IN for Sales Item ,OB Opening balance ). Actually I will put it in the selection criteria to get records from Osri table.

Regards,

Ghazanfar

[Former Member]

There is no table with this informations.

The source type is stored as basetype in tables, for translating to proper object you may use function as

create FUNCTION [dbo].[trans](@trans integer)
RETURNS varchar(100)

AS
BEGIN
DECLARE @ret varchar(100)

select @ret =
case @trans
when	1	then	'oChartOfAccounts'
when	2	then	'oBusinessPartners'
when	3	then	'oBanks'
when	4	then	'oItems'
when	5	then	'oVatGroups'
when	6	then	'oPriceLists'
when	7	then	'oSpecialPrices'
when	8	then	'oItemProperties'
when	12	then	'oUsers'
when	13	then	'oInvoices'
when	14	then	'oCreditNotes'
when	15	then	'oDeliveryNotes'
when	16	then	'oReturns'
when	17	then	'oOrders'
when	18	then	'oPurchaseInvoices'
when	19	then	'oPurchaseCreditNotes'
when	20	then	'oPurchaseDeliveryNotes'
when	21	then	'oPurchaseReturns'
when	22	then	'oPurchaseOrders'
when	23	then	'oQuotations'
when	24	then	'oIncomingPayments'
when	28	then	'oJournalVouchers'
when	30	then	'oJournalEntries'
when	31	then	'oStockTakings'
when	33	then	'oContacts'
when	36	then	'oCreditCards'
when	37	then	'oCurrencyCodes'
when	40	then	'oPaymentTermsTypes'
when	42	then	'oBankPages'
when	43	then	'oManufacturers'
when	46	then	'oVendorPayments'
when	48	then	'oLandedCostsCodes'
when	49	then	'oShippingTypes'
when	50	then	'oLengthMeasures'
when	51	then	'oWeightMeasures'
when	52	then	'oItemGroups'
when	53	then	'oSalesPersons'
when	56	then	'oCustomsGroups'
when	57	then	'oChecksforPayment'
when	59	then	'oInventoryGenEntry'
when	60	then	'oInventoryGenExit'
when	64	then	'oWarehouses'
when	65	then	'oCommissionGroups'
when	66	then	'oProductTrees'
when	67	then	'oStockTransfer'
when	68	then	'oWorkOrders'
when	70	then	'oCreditPaymentMethods'
when	71	then	'oCreditCardPayments'
when	73	then	'oAlternateCatNum'
when	77	then	'oBudget'
when	78	then	'oBudgetDistribution'
when	81	then	'oMessages'
when	91	then	'oBudgetScenarios'
when	97	then	'oSalesOpportunities'
when	93	then	'oUserDefaultGroups'
when	101	then	'oSalesStages'
when	103	then	'oActivityTypes'
when	104	then	'oActivityLocations'
when	112	then	'oDrafts'
when	116	then	'oDeductionTaxHierarchies'
when	117	then	'oDeductionTaxGroups'
when	125	then	'oAdditionalExpenses'
when	126	then	'oSalesTaxAuthorities'
when	127	then	'oSalesTaxAuthoritiesTypes'
when	128	then	'oSalesTaxCodes'
when	134	then	'oQueryCategories'
when	138	then	'oFactoringIndicators'
when	140	then	'oPaymentsDrafts'
when	142	then	'oAccountSegmentations'
when	143	then	'oAccountSegmentationCategories'
when	144	then	'oWarehouseLocations'
when	145	then	'oForms1099'
when	146	then	'oInventoryCycles'
when	147	then	'oWizardPaymentMethods'
when	150	then	'oBPPriorities'
when	151	then	'oDunningLetters'
when	152	then	'oUserFields'
when	153	then	'oUserTables'
when	156	then	'oPickLists'
when	158	then	'oPaymentRunExport'
when	160	then	'oUserQueries'
when	162	then	'oMaterialRevaluation'
when	163	then	'oCorrectionPurchaseInvoice'
when	164	then	'oCorrectionPurchaseInvoiceReversal'
when	165	then	'oCorrectionInvoice'
when	166	then	'oCorrectionInvoiceReversal'
when	170	then	'oContractTemplates'
when	171	then	'oEmployeesInfo'
when	176	then	'oCustomerEquipmentCards'
when	178	then	'oWithholdingTaxCodes'
when	182	then	'oBillOfExchangeTransactions'
when	189	then	'oKnowledgeBaseSolutions'
when	190	then	'oServiceContracts'
when	191	then	'oServiceCalls'
when	193	then	'oUserKeys'
when	194	then	'oQueue'
when	198	then	'oSalesForecast'
when	200	then	'oTerritories'
when	201	then	'oIndustries'
when	202	then	'oProductionOrders'
when	205	then	'oPackagesTypes'
when	206	then	'oUserObjectsMD'
when	211	then	'oTeams'
when	212	then	'oRelationships'
when	214	then	'oUserPermissionTree'
when	217	then	'oActivityStatus'
when	218	then	'oChooseFromList'
when	219	then	'oFormattedSearches'
when	221	then	'oAttachments2'
when	223	then	'oUserLanguages'
when	224	then	'oMultiLanguageTranslations'
when	229	then	'oDynamicSystemStrings'
when	231	then	'oHouseBankAccounts'
when	247	then	'oBusinessPlaces'
when	250	then	'oLocalEra'
when	280	then	'oSalesTaxInvoice'
when	281	then	'oPurchaseTaxInvoice'
when	300	then	'BoRecordset'
when	305	then	'BoBridge'
when	260	then	'oNotaFiscalUsage'
when	258	then	'oNotaFiscalCFOP'
when	259	then	'oNotaFiscalCST'
when	261	then	'oClosingDateProcedure'
when	10	then	'oBusinessPartnerGroups'
when	278	then	'oBPFiscalRegistryID'
else '?' end

return @ret 
end

[Former Member]

Dear Petr ,

Thanx , I will test it I m sure that ur reply will solve my problem.

Regadrs,

Ghazanfar