ITPub博客

首页 > Linux操作系统 > Linux操作系统 > OracleERP表结构--PO模块(2)

OracleERP表结构--PO模块(2)

原创 Linux操作系统 作者:zuibunan 时间:2009-09-22 10:36:08 0 删除 编辑

表名: po.po_un_numbers  
说明: 货期表  
UN_NUMBER_ID NUMBER 货期标识码
UN_NUMBER       VARCHAR2(25) 货期
DESCRIPTION     VARCHAR2(240) 说明

表名:po.rcv_transactions  
说明:到货接收  
TRANSACTION_ID                  NUMBER 接收交易ID
CREATION_DATE                   DATE 创建时间
CREATED_BY                      NUMBER 创建人ID
REQUEST_ID                      NUMBER
TRANSACTION_TYPE                VARCHAR2(25) 交易类型*
TRANSACTION_DATE                DATE 交易日期
QUANTITY                        NUMBER 数量
UNIT_OF_MEASURE                 VARCHAR2(25) 单位
SHIPMENT_HEADER_ID              NUMBER 发运头ID
SHIPMENT_LINE_ID                NUMBER 发运行ID
INV_TRANSACTION_ID              NUMBER INV模块交易登记ID
SOURCE_DOCUMENT_CODE            VARCHAR2(25) 来源文档
DESTINATION_TYPE_CODE           VARCHAR2(25) 目的类型*
PRIMARY_QUANTITY                NUMBER 主单位数量
PRIMARY_UNIT_OF_MEASURE         VARCHAR2(25) 主单位
EMPLOYEE_ID                     NUMBER(9) 员工ID
PARENT_TRANSACTION_ID           NUMBER 父交易ID
PO_HEADER_ID                    NUMBER PO头ID
PO_RELEASE_ID                   NUMBER
PO_LINE_ID                      NUMBER PO行ID
PO_LINE_LOCATION_ID             NUMBER PO定位行ID
PO_DISTRIBUTION_ID              NUMBER PO发散ID
PO_REVISION_NUM                 NUMBER PO版本
REQUISITION_LINE_ID             NUMBER PR行ID
PO_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) 投递给员工ID
DELIVER_TO_LOCATION_ID          NUMBER 投递地点ID
VENDOR_ID                       NUMBER 供应商ID
VENDOR_SITE_ID                  NUMBER 供应商地址ID
ORGANIZATION_ID                 NUMBER 组织代码
SUBINVENTORY                    VARCHAR2(10) 子库
LOCATION_ID                     NUMBER 库位ID(与inv.mtl_item_locations关联)
RMA_REFERENCE                   VARCHAR2(30) RMA参考
COMMENTS                        VARCHAR2(240) 备注
INVOICE_ID                      NUMBER 发票ID
INVOICE_STATUS_CODE             VARCHAR2(25) 发票状态
说明:TRANSACTION_TYPE 与 DESTINATION_TYPE_CODE 取值  
TRANSACTION_TYPE  
ACCEPT 接受 检验合格
CORRECT 校正 录入错误,信息调整
DELIVER 交货 正式入库
RECEIVE 接收 收货
REJECT 拒绝 接收后未作入库或退货处理
RETURN TO RECEIVING 返回至接收 从库房返回到暂存库
RETURN TO VENDOR 返回至供应商 从暂存库/库房/车间退货到供应商
TRANSFER 转帐 香港暂存库转公司暂存库
DESTINATION_TYPE_CODE
EXPENSE 费用
INVENTORY 库房
RECEIVING 暂存
SHOP FLOOR 车间

表名:po.po_vendors
说明:供应商表
VENDOR_ID                       NUMBER
VENDOR_NAME                     VARCHAR2(80)
SEGMENT1                        VARCHAR2(30)
CREATION_DATE                   DATE
CREATED_BY                      NUMBER
EMPLOYEE_ID                     NUMBER
VENDOR_TYPE_LOOKUP_CODE         VARCHAR2(25)
CUSTOMER_NUM                    VARCHAR2(25)
MIN_ORDER_AMOUNT                NUMBER
SHIP_TO_LOCATION_ID             NUMBER
BILL_TO_LOCATION_ID             NUMBER
SHIP_VIA_LOOKUP_CODE            VARCHAR2(25)
FREIGHT_TERMS_LOOKUP_CODE       VARCHAR2(25)
FOB_LOOKUP_CODE                 VARCHAR2(25)
TERMS_ID                        NUMBER
SET_OF_BOOKS_ID                 NUMBER
CREDIT_STATUS_LOOKUP_CODE       VARCHAR2(25)
CREDIT_LIMIT                    NUMBER
ALWAYS_TAKE_DISC_FLAG           VARCHAR2(1)
PAY_DATE_BASIS_LOOKUP_CODE      VARCHAR2(25)
PAY_GROUP_LOOKUP_CODE           VARCHAR2(25)
PAYMENT_PRIORITY                NUMBER
INVOICE_CURRENCY_CODE           VARCHAR2(15)
PAYMENT_CURRENCY_CODE           VARCHAR2(15)
INVOICE_AMOUNT_LIMIT            NUMBER
EXCHANGE_DATE_LOOKUP_CODE       VARCHAR2(25)
HOLD_ALL_PAYMENTS_FLAG          VARCHAR2(1)
HOLD_FUTURE_PAYMENTS_FLAG       VARCHAR2(1)
HOLD_REASON                     VARCHAR2(240)
DISTRIBUTION_SET_ID             NUMBER
ACCTS_PAY_CODE_COMBINATION_ID   NUMBER
DISC_LOST_CODE_COMBINATION_ID   NUMBER
DISC_TAKEN_CODE_COMBINATION_ID NUMBER
EXPENSE_CODE_COMBINATION_ID     NUMBER
PREPAY_CODE_COMBINATION_ID      NUMBER
NUM_1099                        VARCHAR2(30)
TYPE_1099                       VARCHAR2(10)
WITHHOLDING_STATUS_LOOKUP_CODE VARCHAR2(25)
WITHHOLDING_START_DATE          DATE
ORGANIZATION_TYPE_LOOKUP_CODE   VARCHAR2(25)
VAT_CODE                        VARCHAR2(15)
START_DATE_ACTIVE               DATE
END_DATE_ACTIVE                 DATE
MINORITY_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                       DATE
TERMS_DATE_BASIS                VARCHAR2(25)
PRICE_TOLERANCE                 NUMBER
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)
DAYS_EARLY_RECEIPT_ALLOWED      NUMBER
DAYS_LATE_RECEIPT_ALLOWED       NUMBER
RECEIPT_DAYS_EXCEPTION_CODE     VARCHAR2(25)
RECEIVING_ROUTING_ID            NUMBER
ALLOW_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           DATE
NAME_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)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15725751/viewspace-615260/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-09-15

  • 博文量
    39
  • 访问量
    92242