cancel
Showing results for 
Search instead for 
Did you mean: 

How to check the object type in OPRJ table in SAP Business One?

Former Member
0 Kudos

Hi all experts,

I use BoObjectTypes Enumeration but i don't know how to find the object type on Table Project (OPRJ).

Anybody know how to check the object type of this table?

Note:

I used to use like this:

set @Error=-1

set @Error_Message=@ObjectTyp

but it display with incorrect number because i tested with OITM Table, It return 31 number but in fact OITM Table is 4.

Thanks

TONY

Accepted Solutions (1)

Accepted Solutions (1)

former_member184718
Active Contributor
0 Kudos

Hi Soeun,

OPRJ Object type is 63.

You can easily get the object type code from SP_TransactionNotification stored procedure itself.

Just enter as below:

select @error = -1

select @error_message = @object_type

You can use the list below.

Member Value Description

lf_None -1 No target object

lf_UserDefinedObject 0 User-defined object

lf_GLAccounts 1 G/L account object

lf_BusinessPartner 2 Business Partner object

lf_Items 4 Item object

lf_SalesEmployee 53 Sales employee object

lf_TransactionTemplates 55 Transaction template

lf_JournalPosting 30 Journal Posting object

lf_LoadingFactors 62 Loading Factor object

lf_RecurringTransactions 34 Recurring Transaction object

lf_ProductTree 66 Product Tree object

lf_CheckForPayment 57 Check for Payment object

lf_PaymentTermsTypes 40 Payment Terms object

lf_Deposit 25 Deposit object

lf_PredatedDeposit 76 Predated Deposit object

lf_Warehouses 64 Warehouse object

lf_ImportFile 69 Import File object

lf_BudgetSystem 78 Budget System object

lf_SalesTaxAuthorities 126 Sales Tax Authorities object

lf_SalesTaxCodes 128 Sales Tax Codes object

lf_RunExternalsApplications 86 Run External Application object

lf_DueDates 71 Due Date objects

lf_UserDefaults 93 User Defaults object

lf_FinancePeriod 111 Financial Period object

lf_SalesOpportunity 97 Sales Opportunity object

lf_ConfirmationLevel 120 Confirmation Level object

lf_ConfirmationTemplates 121 Confirmation Template object

lf_ConfirmationDocumnets 122 Confirmation Document object

lf_Drafts 112 Draft object

lf_GoodsIssue 60 Goods Issue object

lf_GoodsReceipt 59 Goods Receipt object

lf_ProjectCodes 63 Project Code object

lf_ContactWithCustAndVend 33 Contact object

lf_JournalVoucher 28 Journal Voucher object

lf_ProfitCenter 61 Profit Center object

lf_VendorPayment 46 Vendor Payment object

lf_Receipt 24 Receipt object

lf_Quotation 23 Quotation object

lf_Order 17 Order object

lf_DeliveryNotes 15 Delivery Note object

lf_DeliveryNotesReturns 16 Delivery Note Return object

lf_Invoice 13 Invoice object

lf_InvoiceCreditMemo 14 Invoice Credit Memo object

lf_PurchaseOrder 22 Purchase Order object

lf_GoodsReceiptPO 20 Goods Receipt PO object

lf_GoodsReturns 21 Goods Return object

lf_PurchaseInvoice 18 Purchase Invoice object

lf_PurchaseInvoiceCreditMemo 19 Purchase Invoice Credit Memo object

lf_CorrectionInvoice 132 Correction Invoice object

lf_StockTransfers 67 Stock Transfer object

lf_WorkInstructions 68 Work Instructions object

lf_AlertsTemplate 80 Alerts Template object

lf_SpecialPricesForGroups 85 Special Prices object

lf_CustomerVendorCatalogNumber 73 Customer/Vendor Catalog Number

lf_SpecialPrices 7 Special Prices object

lf_SerialNumbersForItems 94 Serial Numbers for Items object

lf_ItemBatchNumbers 106 Item Batch Numbers object

lf_UserValidValues 110 User Valid Values object

lf_UserDisplayCategories 114 User Display Categories object

lf_AddressFormats 113 Address Format object

lf_Indicator 138 Indicator object

lf_CashDiscount 133 Cash Discount object

lf_DeliveryTypes 49 Delivery Type object

lf_VatGroup 5 VAT Group object

lf_VatIndicator 135 VAT Indicator object

lf_GoodsShipment 139 Goods Shipment object

lf_ExpensesDefinition 125 Expense Definition object

lf_CreditCards 36 Credit Card object

lf_CentralBankIndicator 161 Business Partner Central Bank Indicator object

lf_BPBankAccount 187 Business Partner Bank Account object

lf_DiscountCodes 3 Discount Code object

lf_PaymentBlock 159 Block Payment object for vendors and customers

lf_AgentPerson 177 Agent Person object

lf_PeriodIndicator 184 Period Indicator object for document numbering

lf_HolidaysTable 186 Holidays Table object

lf_Employee 171 Employee object

lf_PredefinedText 215 Pre-defined Text object for sales and marketing documents

lf_Territory 200 Territory (geographic location, brand, or item) object

lf_User 12 SAP Business One User object

lf_ProductionOrder 202 Production Order object

lf_BillOfExchange 181 Bill of Exchange object

lf_BillOfExchangeTransaction 182 Bill of Exchange Transaction object

lf_AddressFormat 131 Address Pattern object

lf_AccountSegmentationCode 143 Account Segmentation Code object

lf_FileFormat 183 File Format object

lf_StockRevaluation 162 Stock Revaluation object

lf_PickList 156 Inventory Pick List object

lf_DunningTerms 196 Dunning Term object

lf_ServiceContract 190 Service Contract object

lf_ContractTemplete 170 Contract Template object

lf_InstallBase 176 Install Base object

lf_ServiceCall 191 Service Call object

lf_ServiceCallSolution 189 Service Call Solution object

lf_ItemGroups 52 Item Groups object

lf_PackageType 206 Package Type object

lf_SalesForecast 198 Sales Forecast object

lf_PaymentMethod 147 Payment Method object

lf_WithHoldingTax 178 Withholding Tax object

Thank you.

Hari

Former Member
0 Kudos

Hi Harikuma,

I tested with 63 but it doesn't raise an error to me to know.here is my code in

SBO_SP_TransactionNotification

if @object_type='63' and (@transaction_type='A' or @transaction_type='U')

    begin

        set @error=-1

        set @error_message='This is the project set up'

    end

In my code, if i have change something on project set up table, it should raise an error "This is the project set up". but when i changed, it doesn't raise error.

Thanks

TONY

former_member184718
Active Contributor
0 Kudos

Hi Soeun,

Your same code works in my machine.

You pls check the attachments here.

Thank you,

Hari

Former Member
0 Kudos

Hi Harikumar,

If i add new project, it works ( display my error). but if you update ( edit project name or other), it doesn't work.

Thanks

TONY

Answers (1)

Answers (1)

KennedyT21
Active Contributor
0 Kudos

HI Soeun,

Please search SDK help file  using the keyword  BoLinkedObject Enumeration , you will get the list off all available objects

lf_ProjectCodes63Project Code object

Member

ValueDescription
lf_None-1No target object
lf_UserDefinedObject0User-defined object
lf_GLAccounts1G/L account object
lf_BusinessPartner2Business Partner object
lf_Items4Item object
lf_SalesEmployee53Sales employee object
lf_TransactionTemplates55Transaction template
lf_JournalPosting30Journal Posting object
lf_LoadingFactors62Loading Factor object
lf_RecurringTransactions34Recurring Transaction object
lf_ProductTree66Product Tree object
lf_CheckForPayment57Check for Payment object
lf_PaymentTermsTypes40Payment Terms object
lf_Deposit25Deposit object
lf_PredatedDeposit76Predated Deposit object
lf_Warehouses64Warehouse object
lf_ImportFile69Import File object
lf_BudgetSystem78Budget System object
lf_SalesTaxAuthorities126Sales Tax Authorities object
lf_SalesTaxCodes128Sales Tax Codes object
lf_RunExternalsApplications86Run External Application object
lf_DueDates71Due Date objects
lf_UserDefaults93User Defaults object
lf_FinancePeriod111Financial Period object
lf_SalesOpportunity97Sales Opportunity object
lf_ConfirmationLevel120Confirmation Level object
lf_ConfirmationTemplates121Confirmation Template object
lf_ConfirmationDocumnets122Confirmation Document object
lf_Drafts112Draft object
lf_GoodsIssue60Goods Issue object
lf_GoodsReceipt59Goods Receipt object
lf_ProjectCodes63Project Code object
lf_ContactWithCustAndVend33Contact object
lf_JournalVoucher28Journal Voucher object
lf_ProfitCenter61Profit Center object
lf_VendorPayment46Vendor Payment object
lf_Receipt24Receipt object
lf_Quotation23Quotation object
lf_Order17Order object
lf_DeliveryNotes15Delivery Note object
lf_DeliveryNotesReturns16Delivery Note Return object
lf_Invoice13Invoice object
lf_InvoiceCreditMemo14Invoice Credit Memo object
lf_PurchaseOrder22Purchase Order object
lf_GoodsReceiptPO20Goods Receipt PO object
lf_GoodsReturns21Goods Return object
lf_PurchaseInvoice18Purchase Invoice object
lf_PurchaseInvoiceCreditMemo19Purchase Invoice Credit Memo object
lf_CorrectionInvoice132Correction Invoice object
lf_StockTransfers67Stock Transfer object
lf_WorkInstructions68Work Instructions object
lf_AlertsTemplate80Alerts Template object
lf_SpecialPricesForGroups85Special Prices object
lf_CustomerVendorCatalogNumber73Customer/Vendor Catalog Number
lf_SpecialPrices7Special Prices object
lf_SerialNumbersForItems94Serial Numbers for Items object
lf_ItemBatchNumbers106Item Batch Numbers object
lf_UserValidValues110User Valid Values object
lf_UserDisplayCategories114User Display Categories object
lf_AddressFormats113Address Format object
lf_Indicator138Indicator object
lf_CashDiscount133Cash Discount object
lf_DeliveryTypes49Delivery Type object
lf_VatGroup5VAT Group object
lf_VatIndicator135VAT Indicator object
lf_GoodsShipment139Goods Shipment object
lf_ExpensesDefinition125Expense Definition object
lf_CreditCards36Credit Card object
lf_CentralBankIndicator161Business Partner Central Bank Indicator object
lf_BPBankAccount187Business Partner Bank Account object
lf_DiscountCodes3Discount Code object
lf_PaymentBlock159Block Payment object for vendors and customers
lf_AgentPerson177Agent Person object
lf_PeriodIndicator184Period Indicator object for document numbering
lf_HolidaysTable186Holidays Table object
lf_Employee171Employee object
lf_PredefinedText215Pre-defined Text object for sales and marketing documents
lf_Territory200Territory (geographic location, brand, or item) object
lf_User12SAP Business One User object
lf_ProductionOrder202Production Order object
lf_BillOfExchange181Bill of Exchange object
lf_BillOfExchangeTransaction182Bill of Exchange Transaction object
lf_AddressFormat131Address Pattern object
lf_AccountSegmentationCode143Account Segmentation Code object
lf_FileFormat183File Format object
lf_StockRevaluation162Stock Revaluation object
lf_PickList156Inventory Pick List object
lf_DunningTerms196Dunning Term object
lf_ServiceContract190Service Contract object
lf_ContractTemplete170Contract Template object
lf_InstallBase176Install Base object
lf_ServiceCall191Service Call object
lf_ServiceCallSolution189Service Call Solution object
lf_ItemGroups52Item Groups object
lf_PackageType206Package Type object
lf_SalesForecast198Sales Forecast object
lf_PaymentMethod147Payment Method object
lf_WithHoldingTax178Withholding Tax object 



Regards

Kennedy