表名: po.po_requisition_headers_all 说明: 采购请求 REQUISITION_HEADER_ID NUMBER PR头标识码 SEGMENT1 VARCHAR2(20) PR号 ENABLE_FLAG VARCHAR2(1) 使能标志(Y/N) AUTHORIZATION_STATUS VARCHAR2(25) 批准标志(APPROVED/) TYPE_LOOKUP_CODE VARCHAR2(25) 类型(PURCHASE) REQUIST_ID NUMBER 请求标识码 CANC...
表名: po.po_requisition_headers_all 说明: 采购请求 REQUISITION_HEADER_ID NUMBER PR头标识码 SEGMENT1 VARCHAR2(20) PR号 ENABLE_FLAG VARCHAR2(1) 使能标志(Y/N) AUTHORIZATION_STATUS VARCHAR2(25) 批准标志(APPROVED/) TYPE_LOOKUP_CODE VARCHAR2(25) 类型(PURCHASE) REQUIST_ID NUMBER 请求标识码 CANC...
1、OracleERPPO模块常用表结构(中英文对照)表名:po.po_requisition_headers_all说明:采购请求REQUISITION_HEADER_IDNUMBERPR头标识码SEGMENT1VARCHAR2(20)PR号ENABLE_FLAGVARCHAR2(1)使能标志(Y/N)AUTHORIZATION_STATUSVARCHAR2(25)批准标志(APPROVED/)TYPE_LOOKUP_CODEVARCHAR2(25)类型(PURCHASE)REQUIST_IDNUMBER请求...
po_requisition_headers_all 采购请示 REQUISITION_HEADER_ID是系统生成的唯一请购单编号,对用户不可见。SEGMENT1是申请单的编号。 image.png SEGMENT1:编号 AUTHORIZATION_STATUS:审批状态 (处理中、批准……) CREATION_DATE:创建日期 image.png person_id:编制人 (因EBS里是ID,需要在per_people_f表里查找person_id...
表名: po.po_requisition_headers_all 说明: 采购请求 REQUISITION_HEADER_ID NUMBER PR头标识码 SEGMENT1 VARCHAR2(20) PR号 ENABLE_FLAG VARCHAR2(1) 使能标志(Y/N) AUTHORIZATION_STATUS VARCHAR2(25) 批准标志(APPROVED/) TYPE_LOOKUP_CODE VARCHAR2(25) 类型(PURCHASE) REQUIST_ID NUMBER 请求标识码 CANC...
表名:po.po_requisition_headers_all说明:采购请求 REQUISITION_HEADER_IDSEGMENT1ENABLE_FLAGAUTHORIZATION_STATUSTYPE_LOOKUP_CODEREQUIST_IDCANCEL_FLAGTRANSFERRED_TO_OE_FLAGPREPARER_IDNUMBERVARCHAR2(20)VARCHAR2(1)VARCHAR2(25)VARCHAR2(25)NUMBERVARCHAR2(1)VARCHAR2(1)NUMBERPR头标识码PR号使能标志(Y/N)批准...
PO_REQUISITION_LINES_ALL RQL, PO_REQUISITION_HEADERS_ALL RQH where RQL.REQUISITION_HEADER_ID = RQH.REQUISITION_HEADER_ID and RQL.SOURCE_TYPE_CODE = 'INVENTORY' and RQL.SOURCE_ORGANIZATION_ID is not null and not exists (select 'existing internal order' from OE_ORDER_LINES_ALL LIN where LIN...
purchaseorder一请购订单poporequisitionheadersall请购单题头表poporequisitionlinesall请购单行表poporeqdistributionsall请购单分配表请购订单关联erpopoheadersall采购订单题头表popolinesall采购订单行明细表popolinelocationsall采购订单的发运表po科目的计算单价priceoverridepopodistributionsall采购订单的分配表poporeleasesall...
po.po_requisition_headers_all prh, po.po_requisition_lines_all prl, apps.per_people_f ppf1, (select distinct agent_id,agent_name from apps.po_agents_v ) ppf2, po.po_req_distributions_all prd, inv.mtl_system_items_b msi, po.po_line_locations_all pll, ...
PO_HEADERS_ALL•PO_HEADER_ID PO_VENDORS•VENDOR_ID •VENDOR_ID•VENDOR_SITE_ID PO_REQUISITION_LINES_ALL•REQUISITION_HEADER_ID•REQUISITION_LINE_ID•VENDOR_ID•VENDOR_SITE_ID•INVENTORY_ITEM_ID•LINE_LOCATION_ID PO_VENDOR_SITES_ALL PO_LINES_ALL •VENDOR_ID •VENDOR_SITE_ID...