Danh sách các bảng trong SAP Business One | List of tables in SAP B1
Danh sách bảng dữ liệu này sẽ giúp các bạn viết các câu truy vấn dữ liệu (query) trong SAP Business One. Nếu có thắc mắc gì liên quan, các bạn bình luận nhé.
Để hiểu rõ hơn cấu trúc của từng bảng dữ liệu, bạn có thể sử dụng Query Generator: Tools -> Queries -> Query Generator để tham khảo chi tiết hơn.
hoặc download file SDK này để tìm hiểu.
- Mở file SDK_EN.chm.
- Dưới tab Contents, chọn Customizations Tools.
- Chọn Database Tables Reference.
- Chọn các bảng liên quan tới các module của SAP.
Các bảng thường dùng khi viết Query trong SAP B1
Master Files:
OITM = Item Master
OCRD = Customer, Vendor, and Lead Master
CRD1 = Customer Master Address
OCRG = Customer Master Group Code
OHEM = Employee Master
OUSR = SBO Users
Document Files:
ORDR = Sales Order Header
RDR1 = Sales Order Detail (Items)
OINV = Invoice Header
INV1 = Invoice Line Details (Items)
Dưới đây là danh sách các bảng (table) trong SAP Business One phân loại Module
Administration
| DunningLetters | Dunning levels definition | ODUN |
| Recipients | Message recipient list | AOB1 |
| Messages | Messages | OALR |
| Currencies | Currency codes | OCRN |
| UserPermissionTree | User authorizations for add-on forms | OUPT |
| UserPermissionForms | User permission forms | UPT1 |
| Users | Users of SAP Business One application | OUSR |
| UserPermission | User authorizations | USR3 |
| AddonChecking(SBO-COMMON Database Only runned this table) | Overall Addon Path Defining | SARI |
| User Queries | User Queries | OUQR |
Finance
| Budget | Budget management | OBGT |
| Budget_Lines | Budget item details of an account | BGT1 |
| BudgetDistribution | Budget distribution methods | OBGD |
| BudgetScenarios | Budget scenarios | OBGS |
| ChartOfAccounts | G/L accounts | OACT |
| JournalVouchers | Journal vouchers | OBTD |
| JournalEntries_Lines | Journal transaction – rows | JDT1 |
| JournalEntries | Journal transaction | OJDT |
| SalesTaxAuthorities | Sales tax jurisdictions | OSTA |
| SalesTaxAuthoritiesTypes | Sales tax authority types | OSTT |
| SalesTaxCodes | Inclusive sales tax codes | OSTC |
Marketing Documents and Receipts
(Sales Opportunities, Sales A/R, and Purchasing A/P)
| Document_Lines | Delivery note rows | DLN1 |
| Document_LinesAdditionalExpenses | Delivery note rows – expenses | DLN2 |
| DocumentsAdditionalExpenses | Delivery note – expenses | DLN3 |
| AdditionalExpenses | Defines additional expenses | OEXD |
| Document_Lines | Draft – rows | DRF1 |
| Document_LinesAdditionalExpenses | Draft rows – expenses | DRF2 |
| DocumentsAdditionalExpenses | Draft – expenses | DRF3 |
| Document_Lines | Invoice – rows | INV1 |
| Document_LinesAdditionalExpenses | Invoice rows – expenses | INV2 |
| DocumentsAdditionalExpenses | Invoice – expenses | INV3 |
| Document (oDeliveryNote) | Delivery – header | ODLN |
| Documents | Drafts – header | ODRF |
| Documents (oInvoice) | Invoice – header | OINV |
| Document (oPurchaseInvoices) | AP invoice – header | OPCH |
| Document (oPurchaseDeliveryNotes) | Goods receipt purchase order – header | OPDN |
| Document (oPurchaseOrders) | Purchase order – header | OPOR |
| Document (oQuotation) | Quotation – header | OQUT |
| Document (oReturn) | Returns – header | ORDN |
| Document (oOrder) | Order – header | ORDR |
| Document (oCreditNote) | AR credit memo – header | ORIN |
| Document (oPurchaseCreditNotes) | AP credit memo – header | ORPC |
| Document (oPurchaseReturns) | Goods return – header | ORPD |
| Document_Lines | AP invoice – rows | PCH1 |
| Document_LinesAdditionalExpenses | AP invoice rows – expenses | PCH2 |
| DocumentsAdditionalExpenses | AP invoice – expenses | PCH3 |
| Document_Lines | Goods receipt purchase order – row | PDN1 |
| Document_LinesAdditionalExpenses | Goods receipt purchase order rows – expenses | PDN2 |
| DocumentsAdditionalExpenses | Goods receipt purchase order – expenses | PDN3 |
| Document_Lines | Purchase order – rows | POR1 |
| Document_LinesAdditionalExpenses | Purchase order rows – expenses | POR2 |
| DocumentsAdditionalExpenses | Purchase order – expenses | POR3 |
| Document_Lines | Quotation – rows | QUT1 |
| Document_LinesAdditionalExpenses | Quotation rows – expenses | QUT2 |
| DocumentsAdditionalExpenses | Quotation – expenses | QUT3 |
| Document_Lines | Returns – rows | RDN1 |
| Document_LinesAdditionalExpenses | Return rows – expenses | RDN2 |
| DocumentsAdditionalExpenses | Returns – expenses | RDN3 |
| Document_Lines | Order – rows | RDR1 |
| Document_LinesAdditionalExpenses | Order rows – expenses | RDR2 |
| DocumentsAdditionalExpenses | Order – expenses | RDR3 |
| Document_Lines | Credit memo – rows | RIN1 |
| Document_LinesAdditionalExpenses | Credit memo rows -Expenses | RIN2 |
| DocumentsAdditionalExpenses | Credit memo – expenses | RIN3 |
| Document_Lines | AP credit memo – rows | RPC1 |
| Document_LinesAdditionalExpenses | AP credit memo rows – expenses | RPC2 |
| DocumentsAdditionalExpenses | AP credit memo – expenses | RPC3 |
| Document_Lines | Goods return – rows | RPD1 |
| Document_LinesAdditionalExpenses | Goods return rows – expenses | RPD2 |
| DocumentsAdditionalExpenses | Goods return – expenses | RPD3 |
| BatchNumbers | Batch number for item | OIBT |
| Industries | Industries list for sales opportunities | OOND |
| Relationships | Relationships for sales opportunities | OORL |
| SerialNumbers | Serial numbers for items | OSRI |
| WithholdingTaxData | Withholding tax data | INV5 |
| TaxInvoices (botit_Invoice) | Master header data of a tax invoice of sales document | OTSI |
| TaxInvoice_Lines (botit_Invoice) | Tax invoice of sales document – rows | TSI1 |
| TaxInvoices (botit_Payment) | Master header data of a tax invoice of purchase document | OTPI |
| TaxInvoice_Lines (botit_Payment) | Tax invoice of purchase document – rows | TPI1 |
| TaxInvoices (botit_JournalEntry) | Master header data of a tax invoice of journal entry document | OTXD |
| TaxInvoice_Lines (botit_JournalEntry) | Tax invoice of journal entry document – rows | TXD1 |
Business Partners
| ActivityLocations | Business partner activity locations | OCLO |
| ActivityStatus | Statuses for Task type activities | OCLA |
| ActivityTypes | Business partner activity types | OCLT |
| AlternateCatNum | Customer or vendor catalog number | OSCN |
| BusinessPartners | Business partners | OCRD |
| BPAddresses | Business partner addresses | CRD1 |
| BPPaymentMethods | Business partner payment methods | CRD2 |
| BPAccountReceivablePayble | Business partner account receivable payable | CRD3 |
| BPWithholdingTax | Business partner withholding tax | CRD4 |
| BPPaymentDates | Business partners payment dates | CRD5 |
| BPBankAccounts | Business partners bank accounts | OCRB |
| Contacts | Contact customers and vendors | OCLG |
| ContactEmployees | Contact persons | OCPR |
| SalesOpportunities | Sales opportunities | OOPR |
| SalesOpportunitiesLines | Sales opportunity – rows | OPR1 |
| SalesOpportunitiesPartners | Sales opportunity partners | OPR2 |
| SalesOpportunitiesCompetition | Sales opportunity competition | OPR3 |
| SalesOpportunitiesInterests | Sales opportunity interests range | OPR4 |
| SalesOpportunitiesReasons | Sales opportunity failure reasons | OPR5 |
| Territories | Territory segmentations | OTER |
Inventory and Production
| Document_Lines | Goods issue – rows | IGE1 |
| Document_LinesAdditionalExpenses | Goods issue rows – expenses | IGE2 |
| DocumentsAdditionalExpenses | Goods issue – expenses | IGE3 |
| Document_Lines | Goods receipt – rows | IGN1 |
| Document_LinesAdditionalExpenses | Goods receipt rows – expenses | IGN2 |
| DocumentsAdditionalExpenses | Goods receipt – expenses | IGN3 |
| Document (oInvetoryGenExit) | Goods issue | OIGE |
| Document (oInvetoryGenEntry) | Goods receipt | OIGN |
| StockTransfer | Stock transfers | OWTR |
| StockTransfer_Lines | Stock transfers – rows | WTR1 |
| ProductTrees_Lines | Product tree – child | ITT1 |
| ProductTrees | Product tree | OITT |
| WorkOrders | Work instructions | OWKO |
| WorkOrder_Lines | Work instructions – rows | WKO1 |
| Items_Prices | Items – prices | ITM1 |
| Items | Items | OITM |
| ItemWarehouseInfo | Items – warehouse | OITW |
| ItemGroups | Item groups definition | OITB |
| MaterialRevaluation | Stock revaluation | OMRV |
| MaterialRevaluation_Lines | Stock revaluation – rows | MRV1 |
| PackagesTypes | Package types for deliveries | OPKG |
| PriceLists | Price lists management | OPLN |
| StockTaking | Items – warehouse | OITW |
| SpecialPrices | Special prices | OSPP |
| SpecialPricesDataAreas | Special prices for specified periods | SPP1 |
| SpecialPricesQuantityAreas | Special prices for specified quantities | SPP2 |
| Warehouses | Warehouses definition | OWHS |
MRP
| SalesForecast | Sales forecast | OFCT |
| SalesForecast_Lines | Sales forecast – rows | FCT1 |
Banking
| Payments | Receipt | ORCT |
| Payments | Vendor payment | OVPM |
| Payments_Checks | Receipt – checks | RCT1 |
| Payments_Invoices | Receipt – invoices | RCT2 |
| Payments_CreditCards | Receipt – credit vouchers | RCT3 |
| Payments_Accounts | Receipt – account list | RCT4 |
| Payments_Checks | Payments – check rows | VPM1 |
| Payments_Invoices | Payments – invoices | VPM2 |
| Payments_CreditCards | Payments – credit memos | VPM3 |
| Payments_Accounts | Payments – list of accounts | VPM4 |
| ChecksforPaymentLines | Checks for payment – rows | CHO1 |
| BankPages | External bank statement | OBNK |
| ChecksforPayment | Check for payment | OCHO |
| PaymentTermsTypes | Payment term types | OCTG |
| PaymentRunExport | Payment results table | OPEX |
| PaymentRunExport_Lines | Payment results table – rows | PEX1 |
| BillOfExchange | Bill of exchange table | OBOE |
| BillOfExchangeTransaction | Bill of exchange transactions table | OBOT |
| BillOfExchangeTransaction_Lines | Bill of exchange transactions table – rows | BOT1 |
Service
| ContractTemplates | Contract template (CRM) | OCTT |
| CustomerEquipmentCards | Customer equipment card | OINS |
| KnowledgeBaseSolutions | Knowledge base solution | OSLT |
| Queue | Queues list for assigning to a service calls | OQUE |
| QueueMembers | Queue member users | QUE1 |
| ServiceContracts | Service contract | OCTR |
| ServiceContracts_Lines | Service contract – rows | CTR1 |
| ServiceCalls | Service call | OSCL |
| ServiceCallActivities | Service call activities | OCLG |
| ServiceCallInventoryExpenses | Service call inventory expenses | INV1 |
Human Resources
| EmployeesInfo | Employees information | OHEM |
| EmployeeAbsenceInfo | Employee absence information | HEM1 |
| EmployeeEducationInfo | Employee education | HEM2 |
| EmployeeReviewsInfo | Employee reviews | HEM3 |
| EmployeePrevEmpoymentInfo | Employee previous employment information | HEM4 |
| EmployeeRolesInfo | Employee rolls information | HEM6 |
| Teams | List of teams | OHTM |
| TeamMembers | Employee membership role in a team | HTM1 |