Que es el @object_type?

[LilianaN]

Hola Compañeros buen día, tengo una duda, les cuento me estoy topando en Crystal Reports y SQL para realizar notificaciones en SBO_SP_TransactionNotification que me solicita el @object_type pero no se que es o como se obtiene. alguien que me pueda ayudar,

Saludos!!

[meqs]

Pues … haciendo algo muy sencillo que es “una busqueda” en el foro, tienes multitud de referencias al campo (por cierto, un campo clave en la organización interna de SAPB1).
Por ejemplo:
Object Type

[Sijil]

Hello @LilianaN

Please find the below list of SAP B1 Object types.

Object Types
Object Type	Description
1	ChartOfAccounts object
2	BusinessPartners object
3	Banks object
4	Items object
5	VatGroups object
6	PriceLists object
7	SpecialPrices object
8	ItemProperties object
12	Users object
13	Documents object that represents a sales invoice document
14	Documents object that represents a sales credit note document
15	Documents object that represents a sales delivery note document
16	Documents object that represents a sales return document
17	Documents object that represents a sales order document
18	Documents object that represents a purchase invoice document
19	Documents object that represents a purchase credit note document
20	Documents object that represents a purchase delivery note document
21	Documents object that represents a a purchase return document
22	Documents object that represents a purchase order document
23	Documents object that represents a sales quotation document
24	Payments object
28	JournalVouchers object
30	JournalEntries object that represents a normal journal entry
31	StockTaking object
33	Contacts object
36	CreditCards object
37	Currencies object
40	PaymentTermsTypes object
42	BankPages object
43	Manufacturers object
46	Payments object that represents payments to vendors
48	LandedCostsCodes object
49	ShippingTypes object
50	LengthMeasures object
51	WeightMeasures object
52	ItemGroups object
53	SalesPersons object
56	CustomsGroups object
57	ChecksforPayment object
59	Documents object for entering general items to inventory
60	Documents object for removing general items from inventory
64	Warehouses object
65	CommissionGroups object
66	ProductTrees object
67	StockTransfer object
68	WorkOrders object
70	CreditPaymentMethods object
71	CreditCardPayments object
73	AlternateCatNum object
77	Budget object
78	BudgetDistribution object
81	Messages object
91	BudgetScenarios object
97	SalesOpportunities object
93	UserDefaultGroups object
101	SalesStages object
103	ActivityTypes object
104	ActivityLocations object
112	Documents object that represents a draft document (see Creating a draft document sample)
116	DeductionTaxHierarchies object
117	DeductionTaxGroups object
125	AdditionalExpenses object
126	SalesTaxAuthorities object
127	SalesTaxAuthoritiesTypes object
128	SalesTaxCodes object
134	QueryCategories object
138	FactoringIndicators object
140	Payments object
142	AccountSegmentations object
143	AccountSegmentationCategories object
144	WarehouseLocations object
145	Forms1099 object
146	InventoryCycles object
147	WizardPaymentMethods object
150	BPPriorities object
151	DunningLetters object
152	UserFieldsMD object
153	UserTablesMD object
156	PickLists object
158	PaymentRunExport object
160	UserQueries object
162	MaterialRevaluation object
163	Documents object that represents a purchase invoice correction document
164	Documents object that represents a reverse purchase invoice correction document
165	Documents object that represents a correction invoice document
166	Documents object that represents a reverse invoice correction document
170	ContractTemplates object
171	EmployeesInfo object
176	CustomerEquipmentCards object
178	WithholdingTaxCodes object
182	BillOfExchangeTransaction object
189	KnowledgeBaseSolutions object
190	ServiceContracts object
191	ServiceCalls object
193	UserKeysMD object
194	Queue object
198	SalesForecast object
200	Territories object
201	Industries object
202	ProductionOrders object
205	PackagesTypes object
206	UserObjectsMD object
211	Teams object
212	Relationships object
214	UserPermissionTree object
217	ActivityStatus object
218	ChooseFromList object
219	FormattedSearches object
221	Attachments2 object
223	UserLanguages object
224	MultiLanguageTranslations object
229	DynamicSystemStrings object
231	HouseBankAccounts object
247	BusinessPlaces object
250	LocalEra object
280	Sales tax invoice object (see TaxInvoices object and DocType property with the valid value botit_Invoice)
281	Purchase tax invoice object (see TaxInvoices object and DocType property with the valid value botit_Payment)
300	Recordset object
305	SBObob object
260	NotaFiscalUsage object
258	NotaFiscalCFOP object
259	NotaFiscalCST object
261	ClosingDateProcedure object
10	BusinessPartnerGroups object
278	BPFiscalRegistryID object
203	Documents object that represents a down payments document
204	Documents object that represents a purchase down payments document
1179	StockTransfer draft object
540000006	Documents object that represents a purchase quotation document

[LilianaN]

Muchas gracias por sus respuestas, soy nueva en esto y estaba un poco confundida al respecto…

Salduos

[andresramirez]

Hola Liliana
Otra forma es consultar el ObjType desde la tabla de encabezado de la operación que necesitas validar en el SP.
SELECT TOP 1 T0."ObjType" FROM OINV T0

[LilianaN]

Muchas gracias!!!