po模块表结构

《po模块表结构》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、PurchaseOrder•、请购订单1PO.PO_REQUISITION_HEADERS_ALL请购单题失表2PO.PO_REQUISITION_LINES_ALL请购单行表3PO.PO_REQ_DISTRIBUTIONS_ALL请购单分配表请购订单关联E-R图PO.POREQUISITIONHEADERSALLPKKKOUISIIIONHKADKKIDUlUlSEGMENT1ORGIDamPO.POKU)LISITION_LINtS一ALLPKRKOtlSITIONLINEII)KK1REQUISITIONHEADERIDPO.POREQDISTRIBUTIONSALLPKDI

2、STRIBUTIONII)FKIREQUISITIONLINEID二、采购订单1PO.PO_HEADERS_ALL采购订单题义-表2PO.PO_LINES_ALL采购id‘单行明细表3PO.PO_LINE_LOCATIONS_ALL采购订单的发运表P0科0的计算肀价Price_override4PO.PO_DISTRIBUTIONS_ALL采购订单的分配表5PO.PO_RELEASES_ALL订划订单或一揽子订单表只冇为计划或一揽子订单时，才会更新此表采购订单关联E-R图PO.POHtADLRSALLPKPOHEADERII)UlUlUlSEGMENTIORGJDTYPE一LOOK

3、UPCODEFROMHEADERIDPO.POLINESALLPKPOLINEIDFKIJJIUlPOJIEADLRJI)LINtNUM"POPORELEASESALLPKPORELEASEIDFKIPOHEADERIDPO.POIJNFLOCATIONSALLPKLINELOCATIONIDFK2POLINEIDpriceoverridePO.PODISTRIBUTIONSAILPKPODISTRIBUTIONIPSoAi中J。,

4、IIOK/S.OK/；FK1r?i/aPOLINEID■KIC罝三、PO报价单与PO订单是同一张表。。1po.po_headers_allPO报价单题

5、头表PO_HEADERS_RFQQT_V2PO.PO_LINES_ALLPO报价单行明细表PO_LINES_RFQQT_V3PO.PO_LINE_LOCATIONS_ALLPO报价单分段价格表四、接受Receiving接收冇三种方式：直接交货、标准接收、检验接收。1PO.RCV_TRANSACTIONS接收、接受、交货事务表inspection_status_code会记录当前的接收方式2PO.RCV_SHIPMENT_HEADERS接收货物头表3PO.RCV_SHIPMENT_LINES接收货物行明细表当PO行有多个收货地点4PO.RCV_SUPPLY已接收，但尚未接受或检验的P

6、0表1PO.RCV_ACCOUNTING_EVENTS接收科H事件表2PO.RCV_RECE1VING_SUB_LEDGER接收会计科目表接收关联E-R阁POR(VSHIPMENTHEADERSPKSIIIPMPNTIIIMHRll>PO.KtV1KANSACTIONSPKnuNx'crio、ii>FK2IKI1*0IIKADFRIDK)RELEASEIDK)IINFII)poKlocationIDIODMKIIU1I(

7、IDSHIPMENTIIEADFklbSIIIPMII_L1NLJDK)k(V八(UKxnv,FVFNTSPKACCOIMI卜GMtNIU>PKIRCVTRA

8、NSACTIONIDIKAsVll<)II)POR(VSHIPMENTLINESPKMI1PMFST1l、f：ll>IKIHIPMIMIIIADIRJI)PO.RCVSIITIYPORCV-RECE1VING-SUB-LTDGERFKIRCVTRANSACTIONII)ACCOUNTED.DR、(((，lKA(XHMDIRIDFOUrIDK>LISEL(XATK)NII)SHFpMFVTIfFADFRIDSHlPrMLIhll>OFOKI》FkUFAiSFK」()oeorder"l

9、ineid'五、PO层次结构相关的表：员工、职务、职位、职位层次、审批组、职位帘批组分配。1HR.PER_ALL_PEOPLE_FHR员工定义表2HR.PER_ALL_ASSIGNMENTS_FHR员工职位分配表3HR.PER_ALL_POSITIONSHR职位定义表4HR.PERJOBSHR职务定义表PER_JOBS_TL多语言表5HR.PER_FOSITION_STRUCTURES职位层级题尖表6HR.PER_POS_STRUCTURE_VERSIONS职位层级版