Oracle_ERP_PO_表结构
PO模块常用表结构表名: po.po_requisition_headers_all
表名: po.po_requisition_lines_all
表名: po.po_lookup_codes
表名: po.po_lookup_types
表名: po.po_headers_all
表名: po.po_lines_all
表名: po.po_line_locations_all
表名: po.po_un_numbers
表名：po.rcv_transactions
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)
ID关联)