Oracle Fusion常用表
| 模块 | 表名 | 表描述 | 字段说明 |
|---|---|---|---|
| so | doo_headers_all | 销售订单头表 | |
| so | doo_lines_all | 销售订单行表 | |
| so | doo_fulfill_lines_all | 销售订单明细行表 | |
| po | po_headers_all | 采购订单头表 | |
| po | po_lines_all | 采购订单行表 | |
| po | po_line_locations_all | 采购订单分配表 | |
| po | po_distributions_all | 采购订单发运表 | |
| inv | EGP_SYSTEM_ITEMS_B | 物料表 | 字段:物料编码(ITEM_NUMBER) |
| INV | MSC_PARAMETERS | 库存组织 | SELECT ORGANIZATION_ID ,ORGANIZATION_CODE ,ORGANIZATION_NAME FROM MSC_PARAMETERS |
| AR | HZ_CUST_ACCOUNTS | 客户信息 | select hca.account_number,hcas.* from HZ_PARTIES t ,HZ_CUST_ACCOUNTS hca ,HZ_CUST_ACCT_SITES_ALL hcas where hca.party_id = t.party_id and hca.cust_account_id = hcas.cust_account_id and t.party_name = ‘’ |
| AR | HZ_CUST_ACCT_SITES_ALL | 客户地址信息 | |
| INV | Wsh_Delivery_Details | 销售订单发运明细表 | SELECT Tax_Invoice_Number FROM Wsh_Delivery_Details t WHERE t.Cust_Po_Number = ‘’ |
待持续补充…
信息来源：https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/25b/oedsc/index.html