版權說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權,請進行舉報或認領
文檔簡介
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請求標識碼CANCEL_FLAGVARCHAR2(1)取消標志(Y/N)TRANSFERRE
2、D_TO_OE_FLAGVARCHAR2(1)可否轉入OE標志(Y/N)PREPARER_IDNUMBER準備人ID(可與HR.PER_PEOPLE_F.PERSON_ID關聯(lián))表名:po.po_requisition_lines_all說明:采購請求明細REQUISITION_LINE_IDNUMBERPR行IDREQUISITION_HEADER_IDNUMBERPR頭IDLINE_NUMNUMBER欄目LINE_TYPE_IDNUMBER行類別CATEGORY_IDNUMBER歸類標識碼ITEM_DESCRIPTIONVARCHAR2(240)項目描述UNIT_MEAS_LOOKUP_C
3、ODEVARCHAR2(25)單位UNIT_PRICENUMBER單價(已折為人民幣)QUANTITYNUMBER數(shù)量DELIVER_TO_LOCATION_IDNUMBER交貨位置碼(與HR.HR_LOCATIONS.LOCATION_ID關聯(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)分攤標志VARCHAR2(1)DATE需求日期(原始)NUMBER定位行標識碼(為空時表示未生成PO)MODIFIED_BY_AGENT_FLAGPARENTREQLINEIDVARCHAR2(1)被采購員更改標志(被拆分Y/NULL)NUMBER父PR行ID(由拆分而來的PR)NOTE_TO_AGENTVARCHAR2(100)給采購員意見PURCHASING_AGENT_IDNUMBER采購員標識碼DOCUMENT_TYPE_CODEVARCHAR2(25)文檔類型BLANKET_
5、PO_HEADER_IDNUMBER一攬子訂單頭標識碼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)建議供應商VARCHAR2(80)建議供應商聯(lián)系方式VARCHAR2(20)建議供應商電話NUMBER貨期標識碼(一般與貨期天數(shù)同)NUMBER風險類別標識碼VARCHAR2(1)是否必須使用建議供應商VARCHAR2(25)參考欄目VARCHAR2(1)VARCHAR2(1)緊急標志VARCHAR2(1)取消標志NUMBER來源組織VARCHAR2(10)來源子庫VARCHAR2
7、(25)目標類型DESTINATION_SUBINVENTORYVARCHAR2(10)目標子庫DESTINATION_ORGANIZATION_IDNUMBER目標組織NUMBER取消數(shù)量DATE取消日期QUANTITY_CANCELLEDCANCEL_DATECLOSED_CODEVARCHAR2(25)關閉表名: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訂單頭標識碼NUMBER(9)采購員ID(與VARCHAR2(25)類型PO_HEADER_IDAGENT_IDHR.PER_PEOPLE_F.PERSON_ID關聯(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)匯總標志VARCHAR2(1)使能標志NUMBER供應商標識碼NUMBER供應商地址標識碼NUMBER供應商聯(lián)系方式標識碼NUMBER發(fā)運地點標識碼NUMBER付款地點標識碼NUMBER條款標識碼VARCHAR2(25)運輸方式VARCHAR2(25)口岸代碼VARCHAR2(25)運送條款VARCHAR2(25)狀態(tài)VARCHAR2(15)幣種VARCHAR2(30)匯率類型DATE匯率日期NUMBER匯率NUMBER來源訂單頭標識碼VARCHAR2(25)來源檢查類型DATE開始時間DATE結束時間NUMBER一攬子訂單總金額VARCHAR2(
12、25)審批狀態(tài)NUMBER版本號VARCHAR2(25)修訂日期VARCHAR2(1)批準標志DATE批準日期NUMBER金額限制NUMBER最小金額VARCHAR2(240對審批人的說明VARCHAR2(240對供應商的說明VARCHAR2(240對接收者的說明NUMBERDATE制單日期VARCHAR2(25)VARCHAR2(1)簽返(確認)訂單標志VARCHAR2(240注釋DATE回復日期VARCHAR2(25)回復方法檢查代碼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)必須接受標志DATE接受截止日期DATE關閉日期VARCHAR2(1)VARCHAR2(1)必須批準標志VARCHAR2(1)取消標志VARCHAR2(30)DATEVARCHAR2(1)凍結標志VARCHAR2(25)關閉VARCHAR2(30)VARCHAR2(30)VARCHAR2(1)供應協(xié)議標志VARCHAR2(1)VARCHAR2(10)NUMBER行標識碼NUMBER訂單頭標識碼NUMBER行類型NUMBER行欄目NUMBER項目內(nèi)碼VA
16、RCHAR2(3)項目版本NUMBER歸類標識碼VARCHAR2(240)項目描述VARCHAR2(25)單位NUMBER提交數(shù)量NUMBER提交金額VARCHAR2(1)價格傭金允許NUMBER不允許超過價格NUMBERNUMBER單價NUMBER數(shù)量NUMBER貨期標識碼NUMBER風險類別標識碼VARCHAR2(240)對供應商的說明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)超差示錯標志NUMBER市價VARCHAR2(1)不定貨標志VARCHAR2(1)關閉標志VARCHAR2(1)VARCHAR2(1)取消標志NUMBER(9)取消者DATE取消日期VARCHAR2(240)取消原因VARCHAR2(30)DATETAXABLE_FLAGTAX_NAMECAPITAL_EXPENSE_FLAGVARCHAR2(1)應稅標志VARCHAR2(15)稅種VARCHAR2(1)大寫
18、金額標志NEGOTIATED_BY_PREPARER_FLAGVARCHAR2(1)CLOSED_DATECLOSED_REASONTRANSACTION_REASON_CODEATTRIBUTE10VARCHAR2(150)廠家ATTRIBUTE11VARCHAR2(150)型號DATE關閉日期VARCHAR2(240)關閉原因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行定位標識碼NUMBER訂單頭標識碼NUMBER行標識碼NUMBER數(shù)量NUMBER接收數(shù)量NUMBER
20、接受數(shù)量NUMBER拒絕數(shù)量NUMBER付款數(shù)量NUMBER取消數(shù)量NUMBER發(fā)運數(shù)量VARCHAR2(25)單位NUMBERNUMBER送貨位置VARCHAR2(25)運輸方式DATE要求到貨日期DATE訂約日期DATE最后接受日期NUMBER傭金價格VARCHAR2(1)負擔標志DATE負擔日期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)應稅標志VARCHAR2(15)稅種NUMBER估計稅金NUMBER從訂單頭號NUMBER從訂單行號NUMBER從定位行號DATE開始日期DATE結束日期NUMBER前導時間VARCHAR2(25)前導時間單位NUMBER價格折扣NUMBERVARCHAR2(1)批準標志DATE批準日期VARCHAR2(1)關閉標志VARCHAR2(1)取消標志NUMBER(9)被誰取消DATE取消日期VARCHAR2(240)取消原因VARCHAR2(25)DATEVARCHAR2(25)單位VA
23、RCHAR2(1)VARCHAR2(1)必須檢查標志VARCHAR2(1)必須簽收標志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)允許接收替代標志NUMBER可提前天數(shù)NUMBER可推后
24、天數(shù)VARCHAR2(25)接收天數(shù)例外代碼NUMBERNUMBERNUMBER送貨到組織代碼NUMBERSOURCE_SHIPMENT_IDSHIPMENT_TYPECLOSED_CODEUSSGL_TRANSACTION_CODEGOVERNMENT_CONTEXTRECEIVINGROUTINGIDNUMBERVARCHAR2(25)送貨方式VARCHAR2(25)關閉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)關閉原因CLOSED_DATEDATE關閉日期表名:po.po_un_numbers說明:貨期表UN_NUMBER_IDNUMBER貨期標識碼UN_NUMBERVARCHAR2(25)貨期DESCRIPTIONVARCHAR2(240)說明NUMBER行標
27、識碼NUMBER訂單頭標識碼NUMBER行類型NUMBER行欄目NUMBER項目內(nèi)碼VARCHAR2(3)項目版本NUMBER歸類標識碼VARCHAR2(240)項目描述VARCHAR2(25)單位NUMBER提交數(shù)量NUMBER提交金額VARCHAR2(1)價格傭金允許NUMBER不允許超過價格NUMBERNUMBER單價NUMBER數(shù)量NUMBER貨期標識碼NUMBER風險類別標識碼VARCHAR2(240)對供應商的說明NUMBER來源訂單頭號NUMBER來源行號NUMBER最小訂單數(shù)量NUMBER最大訂單數(shù)量NUMBER可接收數(shù)量VARCHAR2(25)超差示錯標志NUMBER市價VA
28、RCHAR2(1)不定貨標志VARCHAR2(1)關閉標志VARCHAR2(1)VARCHAR2(1)取消標志NUMBER(9)取消者DATE取消日期VARCHAR2(240)取消原因VARCHAR2(30)DATEVARCHAR2(1)應稅標志VARCHAR2(15)稅種VARCHAR2(1)大寫金額標志DATE關閉日期VARCHAR2(240)關閉原因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行定位標識碼NUMBER訂單頭標識碼NUMBER行標識碼NUMBER數(shù)量NUMBER接收數(shù)量NUMBER接受數(shù)量NUMBER拒絕數(shù)量NUMBER付款數(shù)量NUMBER取消數(shù)量NUMBER發(fā)運數(shù)量VARCHAR2(25)單位NUMBERNUMBER送貨位置VARCHAR2(25)運輸方式DATE要求到貨日期DATE訂約日期DATE最后接受日期NUMBER傭金價格VARCHAR2(1)負擔標志DATE負擔日期NUMBERVARCHAR2(25)VARCHAR2(25)VARCHAR2(1)應稅標志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結束日期NUMBER前導時間VARCHAR2(25)前導時間單位NUMBER價格折扣NUMBERVARCHAR2(1)批準標志DATE批準日期VARCHAR2(1)關閉標志VARCHAR2(1)取消標志NUMBER(9)被誰取消DATE取消日期VARCHAR2(240)取消原因VARCHAR2(25)DATEVARCHAR2(25)單位VARCHAR2(1)VARCHAR2(1)必須檢查標志VARCHAR2(1)必須簽收標志NUMBER接收差異數(shù)量VARCHAR2(25)接收例外代碼ALLOW
34、_SUBSTITUTE_RECEIPTS_FLAGVARCHAR2(1)允許接收替代標志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)關閉VARCHAR2(30)VARCHAR2(30)NUMBERVARCHAR2(1)VARCHAR2(240)關閉原因DATE關閉日期表名:po.po_un_numbers說明:貨期表UN_NUMBER_IDNUMBER貨期標識碼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關聯(lián))RMA_REFERENCECOMMENTSNUMBER接收交易IDDATE創(chuàng)建時間NUMBER創(chuàng)建人IDNUMBERVARCHAR2(25)交易類型*DATE交易日期NUMBER數(shù)量VARCHAR2(25)單位NUMBER發(fā)運頭IDNUMBER發(fā)運行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)貨幣轉換類型NUMBER匯率DATE匯率日期NUMBER(9)投遞給員工IDNUMBER投遞地點IDNUMBER供應商IDNUMBER供應商地址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返回至供應商從暫存庫/庫房/車間退貨到供應商TRANSFER轉帳香港暫存庫轉公司暫存庫DESTINATION_TYPE_CODEEXPENSE費用INVENTORY庫房RECEIVING暫存SHOPFLOOR車間表名:po.po_vendors說明:供應商表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
溫馨提示
- 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
- 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權益歸上傳用戶所有。
- 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預覽,若沒有圖紙預覽就沒有圖紙。
- 4. 未經(jīng)權益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
- 5. 人人文庫網(wǎng)僅提供信息存儲空間,僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理,對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對任何下載內(nèi)容負責。
- 6. 下載文件中如有侵權或不適當內(nèi)容,請與我們聯(lián)系,我們立即糾正。
- 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。
最新文檔
- GB/T 32124-2024磷石膏的處理處置規(guī)范
- GB/T 10476-2024尿素高壓冷凝器技術條件
- 果品綜合檢測技術方案
- 土木工程實習工作周記(5篇)
- 初級中學校長開學典禮講話
- 2017年吉林中考道德與法治真題及答案
- 高考數(shù)學復習解答題提高第一輪專題復習專題01空間幾何體的外接球與內(nèi)切球問題(典型題型歸類訓練)(學生版+解析)
- 語文統(tǒng)編版(2024)一年級上冊7.兩件寶 課件
- 《學前兒童衛(wèi)生保健》 課件 1.2.3 幼兒循環(huán)系統(tǒng)的特點及衛(wèi)生保健
- 新生兒臍帶護理課件
- 九上道德與法治期中復習提綱(知識梳理)(全冊)
- 2024秋期國家開放大學《鋼結構(本)》一平臺在線形考(階段性學習測驗1至4)試題及答案
- 2024年秋10月全國自考網(wǎng)絡經(jīng)濟與企業(yè)管理預測試題含解析
- 2024人教版初中九年級數(shù)學上冊第二十五章概率初步大單元整體教學設計
- DB53∕T 1269-2024 改性磷石膏用于礦山廢棄地生態(tài)修復回填技術規(guī)范
- 2. 2.發(fā)現(xiàn)生長(課件)-2024-2025學年一年級科學上冊教科版
- 國家管網(wǎng)集團高校畢業(yè)生招聘筆試真題2023
- 運輸安全合同協(xié)議書2024年
- 2024-2030年中國智能SCADA系統(tǒng)市場運行狀況與前景展望研究研究報告
- 2、中國六大茶類 (1)課件講解
- 機電材料見證取樣復試
評論
0/150
提交評論