|
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。如果您注册时有任何问题请联系客服QQ： 83569622 。
您需要 登录 才可以下载或查看，没有帐号？注册
x
PO模块常用表结构表名: 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)TRANSFERRED_TO_OE_FLAGVARCHAR2(1)可否转入OE标志(Y/N)PREPARER_IDNUMBER准备人ID(可与HR.PER_PEOPLE_F.PERSON_ID关联） 表名: po.po_requisition_lines_all说明: 采购请求明细REQUISITION_LINE_ID NUMBERPR行IDREQUISITION_HEADER_ID NUMBERPR头IDLINE_NUM NUMBER栏目LINE_TYPE_ID NUMBER行类别CATEGORY_ID NUMBER归类标识码ITEM_DESCRIPTION VARCHAR2(240)项目描述UNIT_MEAS_LOOKUP_CODEVARCHAR2(25)单位UNIT_PRICE NUMBER单价(已折为人民币)QUANTITY NUMBER数量DELIVER_TO_LOCATION_ID NUMBER交货位置码（与HR.HR_LOCATIONS.LOCATION_ID关联）TO_PERSON_ID NUMBER收货人代码SOURCE_TYPE_CODE VARCHAR2(25)来源类型ITEM_ID NUMBER项目内码ITEM_REVISION VARCHAR2(3)项目版本QUANTITY_DELIVERED NUMBER已交付数量SUGGESTED_BUYER_ID NUMBER建议采购员代码ENCUMBERED_FLAG VARCHAR2(1)分摊标志RFQ_REQUIRED_FLAG VARCHAR2(1) NEED_BY_DATE DATE需求日期(原始)LINE_LOCATION_ID NUMBER定位行标识码(为空时表示未生成PO)MODIFIED_BY_AGENT_FLAG VARCHAR2(1)被采购员更改标志（被拆分Y/NULL）PARENT_REQ_LINE_ID NUMBER父PR行ID（由拆分而来的PR）NOTE_TO_AGENTVARCHAR2(100)给采购员意见PURCHASING_AGENT_ID NUMBER采购员标识码DOCUMENT_TYPE_CODE VARCHAR2(25)文档类型BLANKET_PO_HEADER_ID NUMBER一揽子订单头标识码BLANKET_PO_LINE_NUM NUMBER一揽子订单栏目CURRENCY_CODE VARCHAR2(15)币种RATE_TYPE VARCHAR2(30)汇率类别RATE_DATE DATE汇率日期RATE NUMBER汇率CURRENCY_UNIT_PRICE NUMBER本币单价SUGGESTED_VENDOR_NAME VARCHAR2(80)建议供应商SUGGESTED_VENDOR_CONTACT VARCHAR2(80)建议供应商联系方式SUGGESTED_VENDOR_PHONE VARCHAR2(20)建议供应商电话UN_NUMBER_ID NUMBER货期标识码（一般与货期天数同）HAZARD_CLASS_ID NUMBER风险类别标识码MUST_USE_SUGG_VENDOR_FLAG VARCHAR2(1)是否必须使用建议供应商REFERENCE_NUM VARCHAR2(25)参考栏目ON_RFQ_FLAG VARCHAR2(1) URGENT_FLAG VARCHAR2(1)紧急标志CANCEL_FLAG VARCHAR2(1)取消标志SOURCE_ORGANIZATION_ID NUMBER来源组织SOURCE_SUBINVENTORY VARCHAR2(10)来源子库DESTINATION_TYPE_CODE VARCHAR2(25)目标类型DESTINATION_ORGANIZATION_IDNUMBER目标组织DESTINATION_SUBINVENTORY VARCHAR2(10)目标子库QUANTITY_CANCELLED NUMBER取消数量CANCEL_DATE DATE取消日期CLOSED_CODEVARCHAR2(25)关闭 表名: po.po_lookup_codes说明: 检查代码LOOKUP_CODE VARCHAR2(25)检查代码LOOKUP_TYPE VARCHAR2(30)检查类型DISPLAYED_FIELDVARCHAR2(25)显示字段DESCRIPTIONVARCHAR2(80)描述 表名: po.po_lookup_types说明: 检查类型LOOKUP_TYPEVARCHAR2(30)检查类型USER_UPDATABLE_FLAGVARCHAR2(1)用户可否更改DESCRIPTIONVARCHAR2(80)描述 表名: po.po_headers_all说明: 采购订单头PO_HEADER_ID NUMBER订单头标识码AGENT_ID NUMBER(9)采购员ID(与HR.PER_PEOPLE_F.PERSON_ID关联)TYPE_LOOKUP_CODE VARCHAR2(25)类型(STANDARD,QUOTATION)SEGMENT1 VARCHAR2(20)订单号SUMMARY_FLAG VARCHAR2(1)汇总标志ENABLED_FLAG VARCHAR2(1)使能标志VENDOR_ID NUMBER供应商标识码VENDOR_SITE_ID NUMBER供应商地址标识码VENDOR_CONTACT_ID NUMBER供应商联系方式标识码SHIP_TO_LOCATION_ID NUMBER发运地点标识码BILL_TO_LOCATION_ID NUMBER付款地点标识码TERMS_ID NUMBER条款标识码SHIP_VIA_LOOKUP_CODE VARCHAR2(25)运输方式FOB_LOOKUP_CODE VARCHAR2(25)口岸代码FREIGHT_TERMS_LOOKUP_CODE VARCHAR2(25)运送条款STATUS_LOOKUP_CODE VARCHAR2(25)状态CURRENCY_CODE VARCHAR2(15)币种RATE_TYPE VARCHAR2(30)汇率类型RATE_DATE DATE汇率日期RATE NUMBER汇率FROM_HEADER_ID NUMBER来源订单头标识码FROM_TYPE_LOOKUP_CODE VARCHAR2(25)来源检查类型START_DATE DATE开始时间END_DATE DATE结束时间BLANKET_TOTAL_AMOUNT NUMBER一揽子订单总金额AUTHORIZATION_STATUS VARCHAR2(25)审批状态REVISION_NUM NUMBER版本号REVISED_DATE VARCHAR2(25)修订日期APPROVED_FLAG VARCHAR2(1)批准标志APPROVED_DATE DATE批准日期AMOUNT_LIMIT NUMBER金额限制MIN_RELEASE_AMOUNT NUMBER最小金额NOTE_TO_AUTHORIZER VARCHAR2(240对审批人的说明NOTE_TO_VENDOR VARCHAR2(240对供应商的说明NOTE_TO_RECEIVER VARCHAR2(240对接收者的说明PRINT_COUNT NUMBER PRINTED_DATE DATE制单日期VENDOR_ORDER_NUM VARCHAR2(25) CONFIRMING_ORDER_FLAG VARCHAR2(1)签返(确认)订单标志COMMENTS VARCHAR2(240注释REPLY_DATE DATE回复日期REPLY_METHOD_LOOKUP_CODE VARCHAR2(25)回复方法检查代码RFQ_CLOSE_DATE DATE QUOTE_TYPE_LOOKUP_CODE VARCHAR2(25)报价类型检查代码QUOTATION_CLASS_CODE VARCHAR2(25)报价类代码QUOTE_WARNING_DELAY_UNIT VARCHAR2(25) QUOTE_WARNING_DELAY NUMBER QUOTE_VENDOR_QUOTE_NUMBER VARCHAR2(25) ACCEPTANCE_REQUIRED_FLAG VARCHAR2(1)必须接受标志ACCEPTANCE_DUE_DATE DATE接受截止日期CLOSED_DATE DATE关闭日期USER_HOLD_FLAG VARCHAR2(1) APPROVAL_REQUIRED_FLAG VARCHAR2(1)必须批准标志CANCEL_FLAG VARCHAR2(1)取消标志FIRM_STATUS_LOOKUP_CODE VARCHAR2(30) FIRM_DATE DATE FROZEN_FLAG VARCHAR2(1)冻结标志CLOSED_CODE VARCHAR2(25)关闭USSGL_TRANSACTION_CODE VARCHAR2(30) GOVERNMENT_CONTEXT VARCHAR2(30) SUPPLY_AGREEMENT_FLAG VARCHAR2(1)供应协议标志EDI_PROCESSED_FLAG VARCHAR2(1) EDI_PROCESSED_STATUS VARCHAR2(10) 表名: po.po_lines_all说明: 采购订单行PO_LINE_ID NUMBER行标识码PO_HEADER_ID NUMBER订单头标识码LINE_TYPE_ID NUMBER行类型LINE_NUM NUMBER行栏目ITEM_ID NUMBER项目内码ITEM_REVISION VARCHAR2(3)项目版本CATEGORY_ID NUMBER归类标识码ITEM_DESCRIPTION VARCHAR2(240)项目描述UNIT_MEAS_LOOKUP_CODE VARCHAR2(25)单位QUANTITY_COMMITTED NUMBER提交数量COMMITTED_AMOUNT NUMBER提交金额ALLOW_PRICE_OVERRIDE_FLAG VARCHAR2(1)价格佣金允许NOT_TO_EXCEED_PRICE NUMBER不允许超过价格LIST_PRICE_PER_UNIT NUMBER UNIT_PRICE NUMBER单价QUANTITY NUMBER数量UN_NUMBER_ID NUMBER货期标识码HAZARD_CLASS_ID NUMBER风险类别标识码NOTE_TO_VENDOR VARCHAR2(240)对供应商的说明FROM_HEADER_ID NUMBER来源订单头号FROM_LINE_ID NUMBER来源行号MIN_ORDER_QUANTITY NUMBER最小订单数量MAX_ORDER_QUANTITY NUMBER最大订单数量QTY_RCV_TOLERANCE NUMBER可接收数量OVER_TOLERANCE_ERROR_FLAG VARCHAR2(25)超差示错标志MARKET_PRICE NUMBER市价UNORDERED_FLAG VARCHAR2(1)不定货标志CLOSED_FLAG VARCHAR2(1)关闭标志USER_HOLD_FLAG VARCHAR2(1) CANCEL_FLAG VARCHAR2(1)取消标志CANCELLED_BY NUMBER(9)取消者CANCEL_DATE DATE取消日期CANCEL_REASON VARCHAR2(240)取消原因FIRM_STATUS_LOOKUP_CODE VARCHAR2(30) FIRM_DATE DATE TAXABLE_FLAG VARCHAR2(1)应税标志TAX_NAME VARCHAR2(15)税种CAPITAL_EXPENSE_FLAG VARCHAR2(1)大写金额标志NEGOTIATED_BY_PREPARER_FLAGVARCHAR2(1) CLOSED_DATE DATE关闭日期CLOSED_REASON VARCHAR2(240)关闭原因TRANSACTION_REASON_CODE VARCHAR2(25)交易原因ATTRIBUTE10VARCHAR2(150)厂家ATTRIBUTE11VARCHAR2(150)型号 表名: po.po_line_locations_all说明: 采购定位表LINE_LOCATION_ID NUMBER行定位标识码PO_HEADER_ID NUMBER订单头标识码PO_LINE_ID NUMBER行标识码QUANTITY NUMBER数量QUANTITY_RECEIVED NUMBER接收数量QUANTITY_ACCEPTED NUMBER接受数量QUANTITY_REJECTED NUMBER拒绝数量QUANTITY_BILLED NUMBER付款数量QUANTITY_CANCELLED NUMBER取消数量QUANTITY_SHIPPED NUMBER发运数量UNIT_MEAS_LOOKUP_CODE VARCHAR2(25)单位PO_RELEASE_ID NUMBER SHIP_TO_LOCATION_ID NUMBER送货位置SHIP_VIA_LOOKUP_CODE VARCHAR2(25)运输方式NEED_BY_DATE DATE要求到货日期PROMISED_DATE DATE订约日期LAST_ACCEPT_DATE DATE最后接受日期PRICE_OVERRIDE NUMBER佣金价格ENCUMBERED_FLAG VARCHAR2(1)负担标志ENCUMBERED_DATE DATE负担日期UNENCUMBERED_QUANTITY NUMBER FOB_LOOKUP_CODE VARCHAR2(25) FREIGHT_TERMS_LOOKUP_CODE VARCHAR2(25) TAXABLE_FLAG VARCHAR2(1)应税标志TAX_NAME VARCHAR2(15)税种ESTIMATED_TAX_AMOUNT NUMBER估计税金FROM_HEADER_ID NUMBER从订单头号FROM_LINE_ID NUMBER从订单行号FROM_LINE_LOCATION_ID NUMBER从定位行号START_DATE DATE开始日期END_DATE DATE结束日期LEAD_TIME NUMBER前导时间LEAD_TIME_UNIT VARCHAR2(25)前导时间单位PRICE_DISCOUNT NUMBER价格折扣TERMS_ID NUMBER APPROVED_FLAG VARCHAR2(1)批准标志APPROVED_DATE DATE批准日期CLOSED_FLAG VARCHAR2(1)关闭标志CANCEL_FLAG VARCHAR2(1)取消标志CANCELLED_BY NUMBER(9)被谁取消CANCEL_DATE DATE取消日期CANCEL_REASON VARCHAR2(240)取消原因FIRM_STATUS_LOOKUP_CODE VARCHAR2(25) FIRM_DATE DATE UNIT_OF_MEASURE_CLASS VARCHAR2(25)单位ENCUMBER_NOW VARCHAR2(1) INSPECTION_REQUIRED_FLAG VARCHAR2(1)必须检查标志RECEIPT_REQUIRED_FLAG VARCHAR2(1)必须签收标志QTY_RCV_TOLERANCE NUMBER接收差异数量QTY_RCV_EXCEPTION_CODE VARCHAR2(25)接收例外代码ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25) ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1)允许接收替代标志DAYS_EARLY_RECEIPT_ALLOWED NUMBER可提前天数DAYS_LATE_RECEIPT_ALLOWED NUMBER可推后天数RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25)接收天数例外代码INVOICE_CLOSE_TOLERANCE NUMBER RECEIVE_CLOSE_TOLERANCE NUMBER SHIP_TO_ORGANIZATION_ID NUMBER送货到组织代码SHIPMENT_NUM NUMBER SOURCE_SHIPMENT_ID NUMBER SHIPMENT_TYPE VARCHAR2(25)送货方式CLOSED_CODE VARCHAR2(25)关闭USSGL_TRANSACTION_CODE VARCHAR2(30) GOVERNMENT_CONTEXT VARCHAR2(30) RECEIVING_ROUTING_ID NUMBER ACCRUE_ON_RECEIPT_FLAG VARCHAR2(1) CLOSED_REASON VARCHAR2(240)关闭原因CLOSED_DATE DATE关闭日期 表名: po.po_un_numbers说明: 货期表UN_NUMBER_IDNUMBER货期标识码UN_NUMBER VARCHAR2(25)货期DESCRIPTION VARCHAR2(240)说明 表名：po.rcv_transactions说明：到货接收TRANSACTION_ID NUMBER接收交易IDCREATION_DATE DATE创建时间CREATED_BY NUMBER创建人IDREQUEST_ID NUMBER TRANSACTION_TYPE VARCHAR2(25)交易类型*TRANSACTION_DATE DATE交易日期QUANTITY NUMBER数量UNIT_OF_MEASURE VARCHAR2(25)单位SHIPMENT_HEADER_ID NUMBER发运头IDSHIPMENT_LINE_ID NUMBER发运行IDINV_TRANSACTION_ID NUMBERINV模块交易登记IDSOURCE_DOCUMENT_CODE VARCHAR2(25)来源文档DESTINATION_TYPE_CODE VARCHAR2(25)目的类型*PRIMARY_QUANTITY NUMBER主单位数量PRIMARY_UNIT_OF_MEASURE VARCHAR2(25)主单位EMPLOYEE_ID NUMBER(9)员工IDPARENT_TRANSACTION_ID NUMBER父交易IDPO_HEADER_ID NUMBERPO头IDPO_RELEASE_ID NUMBER PO_LINE_ID NUMBERPO行IDPO_LINE_LOCATION_ID NUMBERPO定位行IDPO_DISTRIBUTION_ID NUMBERPO发散IDPO_REVISION_NUM NUMBERPO版本REQUISITION_LINE_ID NUMBERPR行IDPO_UNIT_PRICE NUMBER单位CURRENCY_CODE VARCHAR2(15)币种CURRENCY_CONVERSION_TYPE VARCHAR2(30)货币转换类型CURRENCY_CONVERSION_RATE NUMBER汇率CURRENCY_CONVERSION_DATE DATE汇率日期DELIVER_TO_PERSON_ID NUMBER(9)投递给员工IDDELIVER_TO_LOCATION_ID NUMBER投递地点IDVENDOR_ID NUMBER供应商IDVENDOR_SITE_ID NUMBER供应商地址IDORGANIZATION_ID NUMBER组织代码SUBINVENTORY VARCHAR2(10)子库LOCATION_ID NUMBER库位ID（与inv.mtl_item_locations关联）RMA_REFERENCE VARCHAR2(30)RMA参考COMMENTS VARCHAR2(240)备注INVOICE_ID NUMBER发票IDINVOICE_STATUS_CODE VARCHAR2(25)发票状态说明：TRANSACTION_TYPE 与 DESTINATION_TYPE_CODE 取值TRANSACTION_TYPEACCEPT接受检验合格CORRECT校正录入错误,信息调整DELIVER交货正式入库RECEIVE接收收货REJECT拒绝接收后未作入库或退货处理RETURN TO RECEIVING返回至接收从库房返回到暂存库RETURN TO VENDOR返回至供应商从暂存库/库房/车间退货到供应商TRANSFER转帐香港暂存库转公司暂存库DESTINATION_TYPE_CODEEXPENSE费用INVENTORY库房RECEIVING暂存SHOP FLOOR车间表名:po.po_vendors说明:供应商表VENDOR_ID NUMBERVENDOR_NAME VARCHAR2(80)SEGMENT1 VARCHAR2(30)CREATION_DATE DATECREATED_BY NUMBEREMPLOYEE_ID NUMBERVENDOR_TYPE_LOOKUP_CODE VARCHAR2(25)CUSTOMER_NUM VARCHAR2(25)MIN_ORDER_AMOUNT NUMBERSHIP_TO_LOCATION_ID NUMBERBILL_TO_LOCATION_ID NUMBERSHIP_VIA_LOOKUP_CODE VARCHAR2(25)FREIGHT_TERMS_LOOKUP_CODE VARCHAR2(25)FOB_LOOKUP_CODE VARCHAR2(25)TERMS_ID NUMBERSET_OF_BOOKS_ID NUMBERCREDIT_STATUS_LOOKUP_CODE VARCHAR2(25)CREDIT_LIMIT NUMBERALWAYS_TAKE_DISC_FLAG VARCHAR2(1)PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2(25)PAY_GROUP_LOOKUP_CODE VARCHAR2(25)PAYMENT_PRIORITY NUMBERINVOICE_CURRENCY_CODE VARCHAR2(15)PAYMENT_CURRENCY_CODE VARCHAR2(15)INVOICE_AMOUNT_LIMIT NUMBEREXCHANGE_DATE_LOOKUP_CODE VARCHAR2(25)HOLD_ALL_PAYMENTS_FLAG VARCHAR2(1)HOLD_FUTURE_PAYMENTS_FLAG VARCHAR2(1)HOLD_REASON VARCHAR2(240)DISTRIBUTION_SET_ID NUMBERACCTS_PAY_CODE_COMBINATION_ID NUMBERDISC_LOST_CODE_COMBINATION_ID NUMBERDISC_TAKEN_CODE_COMBINATION_ID NUMBEREXPENSE_CODE_COMBINATION_ID NUMBERPREPAY_CODE_COMBINATION_ID NUMBERNUM_1099 VARCHAR2(30)TYPE_1099 VARCHAR2(10)WITHHOLDING_STATUS_LOOKUP_CODE VARCHAR2(25)WITHHOLDING_START_DATE DATEORGANIZATION_TYPE_LOOKUP_CODE VARCHAR2(25)VAT_CODE VARCHAR2(15)START_DATE_ACTIVE DATEEND_DATE_ACTIVE DATEMINORITY_GROUP_LOOKUP_CODE VARCHAR2(25)PAYMENT_METHOD_LOOKUP_CODE VARCHAR2(25)BANK_ACCOUNT_NAME VARCHAR2(80)BANK_ACCOUNT_NUM VARCHAR2(30)BANK_NUM VARCHAR2(25)BANK_ACCOUNT_TYPE VARCHAR2(25)WOMEN_OWNED_FLAG VARCHAR2(1)SMALL_BUSINESS_FLAG VARCHAR2(1)STANDARD_INDUSTRY_CLASS VARCHAR2(25)HOLD_FLAG VARCHAR2(1)PURCHASING_HOLD_REASON VARCHAR2(240)HOLD_BY NUMBER(9)HOLD_DATE DATETERMS_DATE_BASIS VARCHAR2(25)PRICE_TOLERANCE NUMBERINSPECTION_REQUIRED_FLAG VARCHAR2(1)RECEIPT_REQUIRED_FLAG VARCHAR2(1)QTY_RCV_TOLERANCE NUMBERQTY_RCV_EXCEPTION_CODE VARCHAR2(25)ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25)DAYS_EARLY_RECEIPT_ALLOWED NUMBERDAYS_LATE_RECEIPT_ALLOWED NUMBERRECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25)RECEIVING_ROUTING_ID NUMBERALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1)ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1)HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2(1)EXCLUSIVE_PAYMENT_FLAG VARCHAR2(1)TAX_VERIFICATION_DATE DATENAME_CONTROL VARCHAR2(4)STATE_REPORTABLE_FLAG VARCHAR2(1)FEDERAL_REPORTABLE_FLAG VARCHAR2(1)BANK_NUMBER VARCHAR2(30)EDI_TRANSACTION_HANDLING VARCHAR2(25)EDI_PAYMENT_METHOD VARCHAR2(25)EDI_PAYMENT_FORMAT VARCHAR2(25)EDI_REMITTANCE_METHOD VARCHAR2(25)EDI_REMITTANCE_INSTRUCTION VARCHAR2(256)BANK_CHARGE_BEARER VARCHAR2(1)BANK_BRANCH_TYPE VARCHAR2(25) |
|
[复制链接]
|Archiver|小黑屋|手机版|壹佰网 ERP100
( 京ICP备19053597号-2 )
IP卡
狗仔卡
发表于 2006/9/20 20:03:14
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
抢沙发
千斤顶
显身卡
发表于 2006/10/18 14:00:23
发表于 2006/11/10 15:47:53
发表于 2006/11/23 09:21:45
:/kuk
，你们都是为什么东西叫好啊，我什么都没有看到