Oracle ERP 數(shù)據(jù)字典- PO之采購中英文對照

1、OracleERPPO模塊常用表結(jié)構(gòu)(中英文對照)表名：po.po_requisition_headers_all說明：采購請求REQUISITION_HEADER_IDNUMBERPR頭標(biāo)識碼SEGMENT1VARCHAR2(20)PR號ENABLE_FLAGVARCHAR2(1)使能標(biāo)志(Y/N)AUTHORIZATION_STATUSVARCHAR2(25)批準(zhǔn)標(biāo)志(APPROVED/)TYPE_LOOKUP_CODEVARCHAR2(25)類型(PURCHASE)REQUIST_IDNUMBER請求標(biāo)識碼CANCEL_FLAGVARCHAR2(1)取消標(biāo)志(Y/N)TRANSFERRE

2、D_TO_OE_FLAGVARCHAR2(1)可否轉(zhuǎn)入OE標(biāo)志(Y/N)PREPARER_IDNUMBER準(zhǔn)備人ID(可與HR.PER_PEOPLE_F.PERSON_ID關(guān)聯(lián))表名：po.po_requisition_lines_all說明：采購請求明細(xì)REQUISITION_LINE_IDNUMBERPR行IDREQUISITION_HEADER_IDNUMBERPR頭IDLINE_NUMNUMBER欄目LINE_TYPE_IDNUMBER行類別CATEGORY_IDNUMBER歸類標(biāo)識碼ITEM_DESCRIPTIONVARCHAR2(240)項目描述UNIT_MEAS_LOOKUP_C

3、ODEVARCHAR2(25)單位UNIT_PRICENUMBER單價(已折為人民幣)QUANTITYNUMBER數(shù)量DELIVER_TO_LOCATION_IDNUMBER交貨位置碼(與HR.HR_LOCATIONS.LOCATION_ID關(guān)聯(lián))TO_PERSON_IDSOURCE_TYPE_CODEITEM_IDITEM_REVISIONQUANTITY_DELIVEREDSUGGESTED_BUYER_IDENCUMBERED_FLAGRFQ_REQUIRED_FLAGNEED_BY_DATELINE_LOCATION_IDNUMBER收貨人代碼VARCHAR2(25)來源類型NUMBE

4、R項目內(nèi)碼VARCHAR2(3)項目版本NUMBER已交付數(shù)量NUMBER建議采購員代碼VARCHAR2(1)分?jǐn)倶?biāo)志VARCHAR2(1)DATE需求日期(原始)NUMBER定位行標(biāo)識碼(為空時表示未生成PO)MODIFIED_BY_AGENT_FLAGPARENTREQLINEIDVARCHAR2(1)被采購員更改標(biāo)志(被拆分Y/NULL)NUMBER父PR行ID(由拆分而來的PR)NOTE_TO_AGENTVARCHAR2(100)給采購員意見PURCHASING_AGENT_IDNUMBER采購員標(biāo)識碼DOCUMENT_TYPE_CODEVARCHAR2(25)文檔類型BLANKET_

5、PO_HEADER_IDNUMBER一攬子訂單頭標(biāo)識碼BLANKET_PO_LINE_NUMCURRENCY_CODERATE_TYPERATE_DATERATECURRENCY_UNIT_PRICESUGGESTED_VENDOR_NAMESUGGESTED_VENDOR_CONTACTSUGGESTED_VENDOR_PHONEUN_NUMBER_IDHAZARD_CLASS_IDMUST_USE_SUGG_VENDOR_FLAGREFERENCE_NUMON_RFQ_FLAGURGENT_FLAGCANCEL_FLAGSOURCE_ORGANIZATION_IDSOURCE_SUBINV

6、ENTORYDESTINATION_TYPE_CODENUMBER一攬子訂單欄目VARCHAR2(15)幣種VARCHAR2(30)匯率類別DATE匯率日期NUMBER匯率NUMBER本幣單價VARCHAR2(80)建議供應(yīng)商VARCHAR2(80)建議供應(yīng)商聯(lián)系方式VARCHAR2(20)建議供應(yīng)商電話NUMBER貨期標(biāo)識碼(一般與貨期天數(shù)同)NUMBER風(fēng)險類別標(biāo)識碼VARCHAR2(1)是否必須使用建議供應(yīng)商VARCHAR2(25)參考欄目VARCHAR2(1)VARCHAR2(1)緊急標(biāo)志VARCHAR2(1)取消標(biāo)志NUMBER來源組織VARCHAR2(10)來源子庫VARCHAR2

7、(25)目標(biāo)類型DESTINATION_SUBINVENTORYVARCHAR2(10)目標(biāo)子庫DESTINATION_ORGANIZATION_IDNUMBER目標(biāo)組織NUMBER取消數(shù)量DATE取消日期QUANTITY_CANCELLEDCANCEL_DATECLOSED_CODEVARCHAR2(25)關(guān)閉表名：po.po_lookup_codes說明：檢查代碼LOOKUP_CODEVARCHAR2(25)檢查代碼LOOKUP_TYPEVARCHAR2(30)檢查類型DISPLAYED_FIELDVARCHAR2(25)顯示字段DESCRIPTIONVARCHAR2(80)描述表名:po

8、.po_lookup_types說明：檢查類型LOOKUP_TYPEVARCHAR2(30)檢查類型USERUPDATABLEFLAGVARCHAR2(1)用戶可否更改DESCRIPTIONVARCHAR2(80)描述表名:po.po_headers_all說明：采購訂單頭NUMBER訂單頭標(biāo)識碼NUMBER(9)采購員ID(與VARCHAR2(25)類型PO_HEADER_IDAGENT_IDHR.PER_PEOPLE_F.PERSON_ID關(guān)聯(lián))TYPE_LOOKUP_CODE(STANDARD,QUOTATION)SEGMENT1SUMMARY_FLAGENABLED_FLAGVENDO

9、R_IDVENDOR_SITE_IDVENDOR_CONTACT_IDSHIP_TO_LOCATION_IDBILL_TO_LOCATION_IDTERMS_IDSHIP_VIA_LOOKUP_CODEFOB_LOOKUP_CODEFREIGHT_TERMS_LOOKUP_CODESTATUS_LOOKUP_CODECURRENCY_CODERATE_TYPERATE_DATERATEFROM_HEADER_IDFROM_TYPE_LOOKUP_CODESTART_DATEEND_DATEBLANKET_TOTAL_AMOUNTAUTHORIZATION_STATUSREVISION_NUMR

10、EVISED_DATEAPPROVED_FLAGAPPROVED_DATEAMOUNT_LIMITMIN_RELEASE_AMOUNTNOTE_TO_AUTHORIZERNOTE_TO_VENDORNOTE_TO_RECEIVERPRINT_COUNTPRINTED_DATEVENDOR_ORDER_NUMCONFIRMING_ORDER_FLAGCOMMENTSREPLY_DATEREPLY_METHOD_LOOKUP_CODERFQ_CLOSE_DATEQUOTE_TYPE_LOOKUP_CODEQUOTATION_CLASS_CODEQUOTE_WARNING_DELAY_UNITVAR

11、CHAR2(20)訂單號VARCHAR2(1)匯總標(biāo)志VARCHAR2(1)使能標(biāo)志NUMBER供應(yīng)商標(biāo)識碼NUMBER供應(yīng)商地址標(biāo)識碼NUMBER供應(yīng)商聯(lián)系方式標(biāo)識碼NUMBER發(fā)運(yùn)地點標(biāo)識碼NUMBER付款地點標(biāo)識碼NUMBER條款標(biāo)識碼VARCHAR2(25)運(yùn)輸方式VARCHAR2(25)口岸代碼VARCHAR2(25)運(yùn)送條款VARCHAR2(25)狀態(tài)VARCHAR2(15)幣種VARCHAR2(30)匯率類型DATE匯率日期NUMBER匯率NUMBER來源訂單頭標(biāo)識碼VARCHAR2(25)來源檢查類型DATE開始時間DATE結(jié)束時間NUMBER一攬子訂單總金額VARCHAR2(

12、25)審批狀態(tài)NUMBER版本號VARCHAR2(25)修訂日期VARCHAR2(1)批準(zhǔn)標(biāo)志DATE批準(zhǔn)日期NUMBER金額限制NUMBER最小金額VARCHAR2(240對審批人的說明VARCHAR2(240對供應(yīng)商的說明VARCHAR2(240對接收者的說明NUMBERDATE制單日期VARCHAR2(25)VARCHAR2(1)簽返(確認(rèn))訂單標(biāo)志VARCHAR2(240注釋DATE回復(fù)日期VARCHAR2(25)回復(fù)方法檢查代碼DATEVARCHAR2(25)報價類型檢查代碼VARCHAR2(25)報價類代碼VARCHAR2(25)QUOTE_WARNING_DELAYQUOTE_V

13、ENDOR_QUOTE_NUMBERACCEPTANCE_REQUIRED_FLAGACCEPTANCE_DUE_DATECLOSED_DATEUSER_HOLD_FLAGAPPROVAL_REQUIRED_FLAGCANCEL_FLAGFIRM_STATUS_LOOKUP_CODEFIRM_DATEFROZEN_FLAGCLOSED_CODEUSSGL_TRANSACTION_CODEGOVERNMENT_CONTEXTSUPPLY_AGREEMENT_FLAGEDI_PROCESSED_FLAGEDI_PROCESSED_STATUS表名：po.po_lines_all說明：采購訂單行PO

14、_LINE_IDPO_HEADER_IDLINE_TYPE_IDLINE_NUMITEM_IDITEM_REVISIONCATEGORY_IDITEM_DESCRIPTIONUNIT_MEAS_LOOKUP_CODEQUANTITY_COMMITTEDCOMMITTED_AMOUNTALLOW_PRICE_OVERRIDE_FLAGNOT_TO_EXCEED_PRICELIST_PRICE_PER_UNITUNIT_PRICEQUANTITYUN_NUMBER_IDHAZARD_CLASS_IDNOTE_TO_VENDORFROM_HEADER_IDFROM_LINE_IDMIN_ORDER_

15、QUANTITYMAX_ORDER_QUANTITYQTY_RCV_TOLERANCENUMBERVARCHAR2(25)VARCHAR2(1)必須接受標(biāo)志DATE接受截止日期DATE關(guān)閉日期VARCHAR2(1)VARCHAR2(1)必須批準(zhǔn)標(biāo)志VARCHAR2(1)取消標(biāo)志VARCHAR2(30)DATEVARCHAR2(1)凍結(jié)標(biāo)志VARCHAR2(25)關(guān)閉VARCHAR2(30)VARCHAR2(30)VARCHAR2(1)供應(yīng)協(xié)議標(biāo)志VARCHAR2(1)VARCHAR2(10)NUMBER行標(biāo)識碼NUMBER訂單頭標(biāo)識碼NUMBER行類型NUMBER行欄目NUMBER項目內(nèi)碼VA

16、RCHAR2(3)項目版本NUMBER歸類標(biāo)識碼VARCHAR2(240)項目描述VARCHAR2(25)單位NUMBER提交數(shù)量NUMBER提交金額VARCHAR2(1)價格傭金允許NUMBER不允許超過價格NUMBERNUMBER單價NUMBER數(shù)量NUMBER貨期標(biāo)識碼NUMBER風(fēng)險類別標(biāo)識碼VARCHAR2(240)對供應(yīng)商的說明NUMBER來源訂單頭號NUMBER來源行號NUMBER最小訂單數(shù)量NUMBER最大訂單數(shù)量NUMBER可接收數(shù)量OVER_TOLERANCE_ERROR_FLAGMARKET_PRICEUNORDERED_FLAGCLOSED_FLAGUSER_HOLD_

17、FLAGCANCEL_FLAGCANCELLED_BYCANCEL_DATECANCEL_REASONFIRM_STATUS_LOOKUP_CODEFIRMDATEVARCHAR2(25)超差示錯標(biāo)志NUMBER市價VARCHAR2(1)不定貨標(biāo)志VARCHAR2(1)關(guān)閉標(biāo)志VARCHAR2(1)VARCHAR2(1)取消標(biāo)志NUMBER(9)取消者DATE取消日期VARCHAR2(240)取消原因VARCHAR2(30)DATETAXABLE_FLAGTAX_NAMECAPITAL_EXPENSE_FLAGVARCHAR2(1)應(yīng)稅標(biāo)志VARCHAR2(15)稅種VARCHAR2(1)大寫

18、金額標(biāo)志NEGOTIATED_BY_PREPARER_FLAGVARCHAR2(1)CLOSED_DATECLOSED_REASONTRANSACTION_REASON_CODEATTRIBUTE10VARCHAR2(150)廠家ATTRIBUTE11VARCHAR2(150)型號DATE關(guān)閉日期VARCHAR2(240)關(guān)閉原因VARCHAR2(25)交易原因表名：po.po_line_locations_all說明：采購定位表LINE_LOCATION_IDPO_HEADER_IDPO_LINE_IDQUANTITYQUANTITY_RECEIVEDQUANTITY_ACCEPTEDQUA

19、NTITY_REJECTEDQUANTITY_BILLEDQUANTITY_CANCELLEDQUANTITY_SHIPPEDUNIT_MEAS_LOOKUP_CODEPO_RELEASE_IDSHIP_TO_LOCATION_IDSHIP_VIA_LOOKUP_CODENEED_BY_DATEPROMISED_DATELAST_ACCEPT_DATEPRICE_OVERRIDEENCUMBERED_FLAGENCUMBERED_DATEUNENCUMBERED_QUANTITYNUMBER行定位標(biāo)識碼NUMBER訂單頭標(biāo)識碼NUMBER行標(biāo)識碼NUMBER數(shù)量NUMBER接收數(shù)量NUMBER

20、接受數(shù)量NUMBER拒絕數(shù)量NUMBER付款數(shù)量NUMBER取消數(shù)量NUMBER發(fā)運(yùn)數(shù)量VARCHAR2(25)單位NUMBERNUMBER送貨位置VARCHAR2(25)運(yùn)輸方式DATE要求到貨日期DATE訂約日期DATE最后接受日期NUMBER傭金價格VARCHAR2(1)負(fù)擔(dān)標(biāo)志DATE負(fù)擔(dān)日期NUMBERFOB_LOOKUP_CODEFREIGHT_TERMS_LOOKUP_CODETAXABLE_FLAGTAX_NAMEESTIMATED_TAX_AMOUNTFROM_HEADER_IDFROM_LINE_IDFROM_LINE_LOCATION_IDSTART_DATEEND_DA

21、TELEAD_TIMELEAD_TIME_UNITPRICE_DISCOUNTTERMS_IDAPPROVED_FLAGAPPROVED_DATECLOSED_FLAGCANCEL_FLAGCANCELLED_BYCANCEL_DATECANCEL_REASONFIRM_STATUS_LOOKUP_CODEFIRM_DATEUNIT_OF_MEASURE_CLASSENCUMBER_NOWINSPECTION_REQUIRED_FLAGRECEIPT_REQUIRED_FLAGQTY_RCV_TOLERANCEQTY_RCV_EXCEPTION_CODEENFORCE_SHIP_TO_LOCA

22、TION_CODEVARCHAR2(25)VARCHAR2(25)VARCHAR2(25)VARCHAR2(1)應(yīng)稅標(biāo)志VARCHAR2(15)稅種NUMBER估計稅金NUMBER從訂單頭號NUMBER從訂單行號NUMBER從定位行號DATE開始日期DATE結(jié)束日期NUMBER前導(dǎo)時間VARCHAR2(25)前導(dǎo)時間單位NUMBER價格折扣NUMBERVARCHAR2(1)批準(zhǔn)標(biāo)志DATE批準(zhǔn)日期VARCHAR2(1)關(guān)閉標(biāo)志VARCHAR2(1)取消標(biāo)志NUMBER(9)被誰取消DATE取消日期VARCHAR2(240)取消原因VARCHAR2(25)DATEVARCHAR2(25)單位VA

23、RCHAR2(1)VARCHAR2(1)必須檢查標(biāo)志VARCHAR2(1)必須簽收標(biāo)志NUMBER接收差異數(shù)量VARCHAR2(25)接收例外代碼ALLOW_SUBSTITUTE_RECEIPTS_FLAGDAYS_EARLY_RECEIPT_ALLOWEDDAYS_LATE_RECEIPT_ALLOWEDRECEIPT_DAYS_EXCEPTION_CODEINVOICE_CLOSE_TOLERANCERECEIVE_CLOSE_TOLERANCESHIP_TO_ORGANIZATION_IDSHIPMENTNUMVARCHAR2(1)允許接收替代標(biāo)志NUMBER可提前天數(shù)NUMBER可推后

24、天數(shù)VARCHAR2(25)接收天數(shù)例外代碼NUMBERNUMBERNUMBER送貨到組織代碼NUMBERSOURCE_SHIPMENT_IDSHIPMENT_TYPECLOSED_CODEUSSGL_TRANSACTION_CODEGOVERNMENT_CONTEXTRECEIVINGROUTINGIDNUMBERVARCHAR2(25)送貨方式VARCHAR2(25)關(guān)閉VARCHAR2(30)VARCHAR2(30)NUMBER表名：po.po_lines_all說明：采購訂單行PO_LINE_IDPO_HEADER_IDLINE_TYPE_IDLINE_NUMITEM_IDITEM_R

25、EVISIONCATEGORY_IDITEM_DESCRIPTIONUNIT_MEAS_LOOKUP_CODEQUANTITY_COMMITTEDCOMMITTED_AMOUNTALLOW_PRICE_OVERRIDE_FLAGNOT_TO_EXCEED_PRICELIST_PRICE_PER_UNITUNIT_PRICEQUANTITYUN_NUMBER_IDHAZARD_CLASS_IDNOTE_TO_VENDORFROM_HEADER_IDFROM_LINE_IDMIN_ORDER_QUANTITYMAX_ORDER_QUANTITYQTY_RCV_TOLERANCEOVER_TOLER

26、ANCE_ERROR_FLAGMARKET_PRICEUNORDERED_FLAGCLOSED_FLAGUSER_HOLD_FLAGCANCEL_FLAGCANCELLED_BYCANCEL_DATECANCEL_REASONACCRUE_ON_RECEIPT_FLAGVARCHAR2(1)CLOSED_REASONVARCHAR2(240)關(guān)閉原因CLOSED_DATEDATE關(guān)閉日期表名：po.po_un_numbers說明：貨期表UN_NUMBER_IDNUMBER貨期標(biāo)識碼UN_NUMBERVARCHAR2(25)貨期DESCRIPTIONVARCHAR2(240)說明NUMBER行標(biāo)

27、識碼NUMBER訂單頭標(biāo)識碼NUMBER行類型NUMBER行欄目NUMBER項目內(nèi)碼VARCHAR2(3)項目版本NUMBER歸類標(biāo)識碼VARCHAR2(240)項目描述VARCHAR2(25)單位NUMBER提交數(shù)量NUMBER提交金額VARCHAR2(1)價格傭金允許NUMBER不允許超過價格NUMBERNUMBER單價NUMBER數(shù)量NUMBER貨期標(biāo)識碼NUMBER風(fēng)險類別標(biāo)識碼VARCHAR2(240)對供應(yīng)商的說明NUMBER來源訂單頭號NUMBER來源行號NUMBER最小訂單數(shù)量NUMBER最大訂單數(shù)量NUMBER可接收數(shù)量VARCHAR2(25)超差示錯標(biāo)志NUMBER市價VA

28、RCHAR2(1)不定貨標(biāo)志VARCHAR2(1)關(guān)閉標(biāo)志VARCHAR2(1)VARCHAR2(1)取消標(biāo)志NUMBER(9)取消者DATE取消日期VARCHAR2(240)取消原因VARCHAR2(30)DATEVARCHAR2(1)應(yīng)稅標(biāo)志VARCHAR2(15)稅種VARCHAR2(1)大寫金額標(biāo)志DATE關(guān)閉日期VARCHAR2(240)關(guān)閉原因VARCHAR2(25)交易原因FIRM_STATUS_LOOKUP_CODEFIRM_DATETAXABLE_FLAGTAX_NAMECAPITAL_EXPENSE_FLAGNEGOTIATED_BY_PREPARER_FLAGVARCHA

29、R2(1)CLOSED_DATECLOSED_REASONTRANSACTION_REASON_CODEATTRIBUTE10VARCHAR2(150)廠家ATTRIBUTE11VARCHAR2(150)型號表名：po.po_line_locations_all說明：采購定位表LINE_LOCATION_IDPO_HEADER_IDPO_LINE_IDQUANTITYQUANTITY_RECEIVEDQUANTITY_ACCEPTEDQUANTITY_REJECTEDQUANTITY_BILLEDQUANTITY_CANCELLEDQUANTITY_SHIPPEDUNIT_MEAS_LOOKU

30、P_CODEPO_RELEASE_IDSHIP_TO_LOCATION_IDSHIP_VIA_LOOKUP_CODENEED_BY_DATEPROMISED_DATELAST_ACCEPT_DATEPRICE_OVERRIDEENCUMBERED_FLAGENCUMBERED_DATEUNENCUMBERED_QUANTITYFOB_LOOKUP_CODEFREIGHT_TERMS_LOOKUP_CODETAXABLE_FLAGTAX_NAMEESTIMATED_TAX_AMOUNTFROM_HEADER_IDFROM_LINE_IDFROM_LINE_LOCATION_IDSTART_DAT

31、ENUMBER行定位標(biāo)識碼NUMBER訂單頭標(biāo)識碼NUMBER行標(biāo)識碼NUMBER數(shù)量NUMBER接收數(shù)量NUMBER接受數(shù)量NUMBER拒絕數(shù)量NUMBER付款數(shù)量NUMBER取消數(shù)量NUMBER發(fā)運(yùn)數(shù)量VARCHAR2(25)單位NUMBERNUMBER送貨位置VARCHAR2(25)運(yùn)輸方式DATE要求到貨日期DATE訂約日期DATE最后接受日期NUMBER傭金價格VARCHAR2(1)負(fù)擔(dān)標(biāo)志DATE負(fù)擔(dān)日期NUMBERVARCHAR2(25)VARCHAR2(25)VARCHAR2(1)應(yīng)稅標(biāo)志VARCHAR2(15)稅種NUMBER估計稅金NUMBER從訂單頭號NUMBER從訂單行

32、號NUMBER從定位行號DATE開始日期END_DATELEAD_TIMELEAD_TIME_UNITPRICE_DISCOUNTTERMS_IDAPPROVED_FLAGAPPROVED_DATECLOSED_FLAGCANCEL_FLAGCANCELLED_BYCANCEL_DATECANCEL_REASONFIRM_STATUS_LOOKUP_CODEFIRM_DATEUNIT_OF_MEASURE_CLASSENCUMBER_NOWINSPECTION_REQUIRED_FLAGRECEIPT_REQUIRED_FLAGQTY_RCV_TOLERANCEQTY_RCV_EXCEPTIO

33、N_CODEENFORCE_SHIP_TO_LOCATION_CODEVARCHAR2(25)DATE結(jié)束日期NUMBER前導(dǎo)時間VARCHAR2(25)前導(dǎo)時間單位NUMBER價格折扣NUMBERVARCHAR2(1)批準(zhǔn)標(biāo)志DATE批準(zhǔn)日期VARCHAR2(1)關(guān)閉標(biāo)志VARCHAR2(1)取消標(biāo)志NUMBER(9)被誰取消DATE取消日期VARCHAR2(240)取消原因VARCHAR2(25)DATEVARCHAR2(25)單位VARCHAR2(1)VARCHAR2(1)必須檢查標(biāo)志VARCHAR2(1)必須簽收標(biāo)志NUMBER接收差異數(shù)量VARCHAR2(25)接收例外代碼ALLOW

34、_SUBSTITUTE_RECEIPTS_FLAGVARCHAR2(1)允許接收替代標(biāo)志DAYSEARLYRECEIPTALLOWEDDAYSLATERECEIPTALLOWEDRECEIPTDAYSEXCEPTIONCODEINVOICECLOSETOLERANCENUMBER可提前天數(shù)NUMBER可推后天數(shù)VARCHAR2(25)接收天數(shù)例外代碼NUMBERRECEIVE_CLOSE_TOLERANCESHIP_TO_ORGANIZATION_IDSHIPMENT_NUMSOURCE_SHIPMENT_IDSHIPMENT_TYPECLOSED_CODEUSSGL_TRANSACTION_

35、CODEGOVERNMENT_CONTEXTRECEIVING_ROUTING_IDACCRUE_ON_RECEIPT_FLAGCLOSED_REASONCLOSED_DATENUMBERNUMBER送貨到組織代碼NUMBERNUMBERVARCHAR2(25)送貨方式VARCHAR2(25)關(guān)閉VARCHAR2(30)VARCHAR2(30)NUMBERVARCHAR2(1)VARCHAR2(240)關(guān)閉原因DATE關(guān)閉日期表名：po.po_un_numbers說明：貨期表UN_NUMBER_IDNUMBER貨期標(biāo)識碼UN_NUMBERDESCRIPTIONVARCHAR2(25)貨期VAR

36、CHAR2(240)說明表名：po.rcv_transaetions說明：到貨接收TRANSACTION_IDCREATION_DATECREATED_BYREQUESTEDTRANSACTION_TYPETRANSACTION_DATEQUANTITYUNIT_OF_MEASURESHIPMENT_HEADER_IDSHIPMENT_LINE_IDINV_TRANSACTION_IDSOURCE_DOCUMENT_CODEDESTINATION_TYPE_CODEPRIMARY_QUANTITYPRIMARY_UNIT_OF_MEASUREEMPLOYEE_IDPARENT_TRANSACT

37、ION_IDPO_HEADER_IDPO_RELEASE_IDPO_LINE_IDPO_LINE_LOCATION_IDPO_DISTRIBUTION_IDPO_REVISION_NUMREQUISITION_LINE_IDPO_UNIT_PRICECURRENCY_CODECURRENCY_CONVERSION_TYPECURRENCY_CONVERSION_RATECURRENCY_CONVERSION_DATEDELIVER_TO_PERSON_IDDELIVER_TO_LOCATION_IDVENDOR_IDVENDOR_SITE_IDORGANIZATION_IDSUBINVENTO

38、RYLOCATION_IDinv.mtl_item_locations關(guān)聯(lián))RMA_REFERENCECOMMENTSNUMBER接收交易IDDATE創(chuàng)建時間NUMBER創(chuàng)建人IDNUMBERVARCHAR2(25)交易類型*DATE交易日期NUMBER數(shù)量VARCHAR2(25)單位NUMBER發(fā)運(yùn)頭IDNUMBER發(fā)運(yùn)行IDNUMBERINV模塊交易登記IDVARCHAR2(25)來源文檔VARCHAR2(25)目的類型*NUMBER主單位數(shù)量VARCHAR2(25)主單位NUMBER(9)員工IDNUMBER父交易IDNUMBERPO頭IDNUMBERNUMBERPO行IDNUMBERP

39、O定位行IDNUMBERPO發(fā)散IDNUMBERPO版本NUMBERPR行IDNUMBER單位VARCHAR2(15)幣種VARCHAR2(30)貨幣轉(zhuǎn)換類型NUMBER匯率DATE匯率日期NUMBER(9)投遞給員工IDNUMBER投遞地點IDNUMBER供應(yīng)商IDNUMBER供應(yīng)商地址IDNUMBER組織代碼VARCHAR2(10)子庫NUMBER庫位ID(與VARCHAR2(30)RMA參考VARCHAR2(240)備注INVOICE_IDNUMBER發(fā)票IDINVOICE_STATUS_CODEVARCHAR2(25)發(fā)票狀態(tài)說明：TRANSACTION_TYPE與DESTINATIO

40、N_TYPE_CODE取值TRANSACTION_TYPEACCEPT接受檢驗合格CORRECT校正錄入錯誤，信息調(diào)整DELIVER交貨正式入庫RECEIVE接收收貨REJECT拒絕接收后未作入庫或退貨處理RETURNTORECEIVING返回至接收從庫房返回到暫存庫RETURNTOVENDOR返回至供應(yīng)商從暫存庫/庫房/車間退貨到供應(yīng)商TRANSFER轉(zhuǎn)帳香港暫存庫轉(zhuǎn)公司暫存庫DESTINATION_TYPE_CODEEXPENSE費用INVENTORY庫房RECEIVING暫存SHOPFLOOR車間表名：po.po_vendors說明:供應(yīng)商表VENDOR_IDVENDOR_NAMESEG

41、MENT1CREATION_DATECREATED_BYEMPLOYEE_IDVENDOR_TYPE_LOOKUP_CODECUSTOMER_NUMMIN_ORDER_AMOUNTSHIP_TO_LOCATION_IDBILL_TO_LOCATION_IDSHIP_VIA_LOOKUP_CODEFREIGHT_TERMS_LOOKUP_CODEFOB_LOOKUP_CODETERMS_IDSET_OF_BOOKS_IDCREDIT_STATUS_LOOKUP_CODECREDIT_LIMITALWAYS_TAKE_DISC_FLAGPAY_DATE_BASIS_LOOKUP_CODEPAY_G

42、ROUP_LOOKUP_CODEPAYMENT_PRIORITYINVOICE_CURRENCY_CODEPAYMENT_CURRENCY_CODENUMBERVARCHAR2(80)VARCHAR2(30)DATENUMBERNUMBERVARCHAR2(25)VARCHAR2(25)NUMBERNUMBERNUMBERVARCHAR2(25)VARCHAR2(25)VARCHAR2(25)NUMBERNUMBERVARCHAR2(25)NUMBERVARCHAR2(1)VARCHAR2(25)VARCHAR2(25)NUMBERVARCHAR2(15)VARCHAR2(15)INVOICEAMOUNTLIMITEXCHANGEDATELOOKUPCODEHOLDALLPAYMENTSFLAGHOLDFUTUREPAYMENTSFLAGNUMBERVARCHAR2(25)VARCHAR2(1)VARCHAR2(1)HOLDREASONVARCHAR2(240)NUMBERDISTRIBUTIONSETIDACCTSPAYCODECOMBINATIONIDNUMBERDISCLOSTCODECOMBINATIONIDNUMBERDISCTAKENCODECOMBINATIONIDNUMBEREXPEN