Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jul 27, 2012 at 11:15 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2012 at 10:53 AM

    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

    ValueDescriptionlf_None-1No target objectlf_UserDefinedObject0User-defined objectlf_GLAccounts1G/L account objectlf_BusinessPartner2Business Partner objectlf_Items4Item objectlf_SalesEmployee53Sales employee objectlf_TransactionTemplates55Transaction templatelf_JournalPosting30Journal Posting objectlf_LoadingFactors62Loading Factor objectlf_RecurringTransactions34Recurring Transaction objectlf_ProductTree66Product Tree objectlf_CheckForPayment57Check for Payment objectlf_PaymentTermsTypes40Payment Terms objectlf_Deposit25Deposit objectlf_PredatedDeposit76Predated Deposit objectlf_Warehouses64Warehouse objectlf_ImportFile69Import File objectlf_BudgetSystem78Budget System objectlf_SalesTaxAuthorities126Sales Tax Authorities objectlf_SalesTaxCodes128Sales Tax Codes objectlf_RunExternalsApplications86Run External Application objectlf_DueDates71Due Date objectslf_UserDefaults93User Defaults objectlf_FinancePeriod111Financial Period objectlf_SalesOpportunity97Sales Opportunity objectlf_ConfirmationLevel120Confirmation Level objectlf_ConfirmationTemplates121Confirmation Template objectlf_ConfirmationDocumnets122Confirmation Document objectlf_Drafts112Draft objectlf_GoodsIssue60Goods Issue objectlf_GoodsReceipt59Goods Receipt objectlf_ProjectCodes63Project Code objectlf_ContactWithCustAndVend33Contact objectlf_JournalVoucher28Journal Voucher objectlf_ProfitCenter61Profit Center objectlf_VendorPayment46Vendor Payment objectlf_Receipt24Receipt objectlf_Quotation23Quotation objectlf_Order17Order objectlf_DeliveryNotes15Delivery Note objectlf_DeliveryNotesReturns16Delivery Note Return objectlf_Invoice13Invoice objectlf_InvoiceCreditMemo14Invoice Credit Memo objectlf_PurchaseOrder22Purchase Order objectlf_GoodsReceiptPO20Goods Receipt PO objectlf_GoodsReturns21Goods Return objectlf_PurchaseInvoice18Purchase Invoice objectlf_PurchaseInvoiceCreditMemo19Purchase Invoice Credit Memo objectlf_CorrectionInvoice132Correction Invoice objectlf_StockTransfers67Stock Transfer objectlf_WorkInstructions68Work Instructions objectlf_AlertsTemplate80Alerts Template objectlf_SpecialPricesForGroups85Special Prices objectlf_CustomerVendorCatalogNumber73Customer/Vendor Catalog Numberlf_SpecialPrices7Special Prices objectlf_SerialNumbersForItems94Serial Numbers for Items objectlf_ItemBatchNumbers106Item Batch Numbers objectlf_UserValidValues110User Valid Values objectlf_UserDisplayCategories114User Display Categories objectlf_AddressFormats113Address Format objectlf_Indicator138Indicator objectlf_CashDiscount133Cash Discount objectlf_DeliveryTypes49Delivery Type objectlf_VatGroup5VAT Group objectlf_VatIndicator135VAT Indicator objectlf_GoodsShipment139Goods Shipment objectlf_ExpensesDefinition125Expense Definition objectlf_CreditCards36Credit Card objectlf_CentralBankIndicator161Business Partner Central Bank Indicator objectlf_BPBankAccount187Business Partner Bank Account objectlf_DiscountCodes3Discount Code objectlf_PaymentBlock159Block Payment object for vendors and customerslf_AgentPerson177Agent Person objectlf_PeriodIndicator184Period Indicator object for document numberinglf_HolidaysTable186Holidays Table objectlf_Employee171Employee objectlf_PredefinedText215Pre-defined Text object for sales and marketing documentslf_Territory200Territory (geographic location, brand, or item) objectlf_User12SAP Business One User objectlf_ProductionOrder202Production Order objectlf_BillOfExchange181Bill of Exchange objectlf_BillOfExchangeTransaction182Bill of Exchange Transaction objectlf_AddressFormat131Address Pattern objectlf_AccountSegmentationCode143Account Segmentation Code objectlf_FileFormat183File Format objectlf_StockRevaluation162Stock Revaluation objectlf_PickList156Inventory Pick List objectlf_DunningTerms196Dunning Term objectlf_ServiceContract190Service Contract objectlf_ContractTemplete170Contract Template objectlf_InstallBase176Install Base objectlf_ServiceCall191Service Call objectlf_ServiceCallSolution189Service Call Solution objectlf_ItemGroups52Item Groups objectlf_PackageType206Package Type objectlf_SalesForecast198Sales Forecast objectlf_PaymentMethod147Payment Method objectlf_WithHoldingTax178Withholding Tax object


    Regards

    Kennedy

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.