Oracle ERP 数据字典- PO之采购中英文对照

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关联)表名：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数量DELIVER_TO_LOCATION_IDNUMBER交货位置码(与HR.HR_LOCATIONS.LOCATION_ID关联)TO_PERSON_IDSOURCE_TYPE_CODEITEM_IDITEM_REVISIONQUANTITY_DELIVEREDSUGGESTED_BUYER_IDENCUMBERED_FLAGRFQ_REQUIRED_FLAGNEED_BY_DATELINE_LOCATION_IDNUMBER收货人代码VARCHAR2(25)来源类型NUMBE

4、R项目内码VARCHAR2(3)项目版本NUMBER已交付数量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)建议供应商联系方式VARCHAR2(20)建议供应商电话NUMBER货期标识码(一般与货期天数同)NUMBER风险类别标识码VARCHAR2(1)是否必须使用建议供应商VARCHAR2(25)参考栏目VARCHAR2(1)VARCHAR2(1)紧急标志VARCHAR2(1)取消标志NUMBER来源组织VARCHAR2(10)来源子库VARCHAR2

7、(25)目标类型DESTINATION_SUBINVENTORYVARCHAR2(10)目标子库DESTINATION_ORGANIZATION_IDNUMBER目标组织NUMBER取消数量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关联)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供应商联系方式标识码NUMBER发运地点标识码NUMBER付款地点标识码NUMBER条款标识码VARCHAR2(25)运输方式VARCHAR2(25)口岸代码VARCHAR2(25)运送条款VARCHAR2(25)状态VARCHAR2(15)币种VARCHAR2(30)汇率类型DATE汇率日期NUMBER汇率NUMBER来源订单头标识码VARCHAR2(25)来源检查类型DATE开始时间DATE结束时间NUMBER一揽子订单总金额VARCHAR2(

12、25)审批状态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)供应协议标志VARCHAR2(1)VARCHAR2(10)NUMBER行标识码NUMBER订单头标识码NUMBER行类型NUMBER行栏目NUMBER项目内码VA

16、RCHAR2(3)项目版本NUMBER归类标识码VARCHAR2(240)项目描述VARCHAR2(25)单位NUMBER提交数量NUMBER提交金额VARCHAR2(1)价格佣金允许NUMBER不允许超过价格NUMBERNUMBER单价NUMBER数量NUMBER货期标识码NUMBER风险类别标识码VARCHAR2(240)对供应商的说明NUMBER来源订单头号NUMBER来源行号NUMBER最小订单数量NUMBER最大订单数量NUMBER可接收数量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数量NUMBER接收数量NUMBER

20、接受数量NUMBER拒绝数量NUMBER付款数量NUMBER取消数量NUMBER发运数量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接收差异数量VARCHAR2(25)接收例外代码ALLOW_SUBSTITUTE_RECEIPTS_FLAGDAYS_EARLY_RECEIPT_ALLOWEDDAYS_LATE_RECEIPT_ALLOWEDRECEIPT_DAYS_EXCEPTION_CODEINVOICE_CLOSE_TOLERANCERECEIVE_CLOSE_TOLERANCESHIP_TO_ORGANIZATION_IDSHIPMENTNUMVARCHAR2(1)允许接收替代标志NUMBER可提前天数NUMBER可推后

24、天数VARCHAR2(25)接收天数例外代码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项目内码VARCHAR2(3)项目版本NUMBER归类标识码VARCHAR2(240)项目描述VARCHAR2(25)单位NUMBER提交数量NUMBER提交金额VARCHAR2(1)价格佣金允许NUMBER不允许超过价格NUMBERNUMBER单价NUMBER数量NUMBER货期标识码NUMBER风险类别标识码VARCHAR2(240)对供应商的说明NUMBER来源订单头号NUMBER来源行号NUMBER最小订单数量NUMBER最大订单数量NUMBER可接收数量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数量NUMBER接收数量NUMBER接受数量NUMBER拒绝数量NUMBER付款数量NUMBER取消数量NUMBER发运数量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接收差异数量VARCHAR2(25)接收例外代码ALLOW

34、_SUBSTITUTE_RECEIPTS_FLAGVARCHAR2(1)允许接收替代标志DAYSEARLYRECEIPTALLOWEDDAYSLATERECEIPTALLOWEDRECEIPTDAYSEXCEPTIONCODEINVOICECLOSETOLERANCENUMBER可提前天数NUMBER可推后天数VARCHAR2(25)接收天数例外代码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关联)RMA_REFERENCECOMMENTSNUMBER接收交易IDDATE创建时间NUMBER创建人IDNUMBERVARCHAR2(25)交易类型*DATE交易日期NUMBER数量VARCHAR2(25)单位NUMBER发运头IDNUMBER发运行IDNUMBERINV模块交易登记IDVARCHAR2(25)来源文档VARCHAR2(25)目的类型*NUMBER主单位数量VARCHAR2(25)主单位NUMBER(9)员工IDNUMBER父交易IDNUMBERPO头IDNUMBERNUMBERPO行IDNUMBERP

39、O定位行IDNUMBERPO发散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发票IDINVOICE_STATUS_CODEVARCHAR2(25)发票状态说明：TRANSACTION_TYPE与DESTINATIO

40、N_TYPE_CODE取值TRANSACTION_TYPEACCEPT接受检验合格CORRECT校正录入错误，信息调整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