1 / 11

# * PR_KEY * PR_NUMBER 0 MOD_NUMBER

TITLE: SPEDI 7.0 DATA DIAGRAM AUTHOR: Laura Killoran Miller UPDATED: October 2005. PURCHASE_REQUESTS. # * PR_KEY * PR_NUMBER 0 MOD_NUMBER * PR_TYPE 0 PR_METHOD * DATE_ORIGINATED

lilah
Download Presentation

# * PR_KEY * PR_NUMBER 0 MOD_NUMBER

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TITLE: SPEDI 7.0 DATA DIAGRAM AUTHOR: Laura Killoran Miller UPDATED: October 2005 PURCHASE_REQUESTS # * PR_KEY * PR_NUMBER 0 MOD_NUMBER * PR_TYPE 0 PR_METHOD * DATE_ORIGINATED 0 BUYER_ID * ORIGINATOR_ID * PLANNED_LEAD_TIME * DATE_PR_RECEIVED * EXPEDITE_IND * PCT10_IND 0 SUGGESTED_VENDOR 0 SUGGESTED_VENDOR_ DUNSKEY 0 MODIFYING_PO_NUMBER 0 DATE_REQUIRED 0 NOTE 0 CONTROL_NUMBER 0 SFO_1 0 SFO_2 0 EXTERNAL_NOTE 0 DATE_COMMITTED 0 PR_TRACK 0 RETURN_LIST 0 MODIFIED_DATE 0 PR_TYPE2 0 PR_ACCEPTED 0 PR_AWARDED 0 SHORT_DESC 0 ORAL_WRITTEN 0 MOD_TOTAL 0 EPR_NUMBER 0 SYNOPSIZED 0 DIVISION_ID 0 SECTION_ID 0 TEAM_ID 0 BPA_IND PR_ORIGINATED_BY PR_BUYER PR_SUSPENSE_ACTIVITIES # * PR_KEY # * STATUS # * START_DATE 0 END_DATE 0 NOTE PR_MOD_PO PRSA_PR_FK PR_STATUS_ACTIVITIES # * PR_KEY # * STATUS # * DATE_OCCURRED 0 NOTE 0 ORPHAN_PR PRA_PR_FK PR_LINE_ITEMS # * PR_KEY # * ITEM_NO * ESTIMATED_UNIT_PRICE * QUANTITY 0 PRICE_SCHEDULE_IND * UNIT 0 PR_TYPE * SHORT_DESC 0 RFQ_KEY 0 RFQ_ITEM_NO 0 LONG_DESC PRLI_PR_FK PR_SP_SECTS_FK PR_SP_TEAMS_FK PR_SP_DIVS_FK PRLI_RFQLI_FK PRLI_UNIT

  2. PLQA_PRLI_FK PR_LI_QTY_ASSIGNMENTS PRACCT_PR_FK # * PR_KEY # * PR_LI_ITEM_NO * QTY 0 BUYING_OFFICE * SHIPPED_TO_OFFICE 0 FINAL_DESTINATION_OFFICE PR_ACCOUNTING_DATA # * PR_KEY * ITEM_NUMBER 0 ACCOUNT_NUMBER 0 RQL 0 AMOUNT 0 BEGIN_BUDGET_FY 0 DOCUMENT_CONTROL_NUMBER 0 FUND_APPROPRIATION 0 OBJECT_CLASS 0 PROGRAM 0 THEMES_INITIATIVE 0 SITE_PROJECT 0 ORG 0 END_BUDGET_YR 0 COST_ORG 0 IFMS_LINE_NUMBER 0 IFMS_RPIO 0 IFMS_TREASURY_SYMBOL 0 IFMS_CLOSED_AMOUNT 0 IFMS_OBLIGATED_AMOUNT PLQA_SHIPPED_TO PLQA_BOUGHT_BY FPDS_CONFIG CLAUSE_HISTORY PR_TRANSFER * CONTROL_NUMBER 0 PR_TYPE 0 ORIGINATOR_NAME 0 ORIGINATOR_MAIL_CODE 0 ORIGINATOR_PHONE 0 DATE_ORIGINATED 0 DATE_REQUIRED 0 PR_METHOD 0 DEL2_NAME * CC_KEY 0 TITLE 0 CLAUSE_NUMBER 0 PO_STANDARD_CLAUSE 0 RFQ_STANDARD_CLAUS 0 USER_ID 0 DATE_CHANGED 0 VARIABLE_NAME 0 VARIABLE_VALUE PR_TRANSFER_SAVE PR_TRANSFER_ERROR DELETE_HISTORY * CONTROL_NUMBER 0 PR_TYPE 0 ORIGINATOR_NAME 0 ORIGINATOR_MAIL_CODE 0 ORIGINATOR_PHONE 0 DATE_ORIGINATED 0 DATE_REQUIRED 0 PR_METHOD 0 DEL2_NAME * CONTROL_NUMBER 0 PR_TYPE 0 ORIGINATOR_NAME 0 ORIGINATOR_MAIL_CODE 0 ORIGINATOR_PHONE 0 DATE_ORIGINATED 0 DATE_REQUIRED 0 PR_METHOD 0 DEL2_NAME 0 RECORD_TYPE 0 ACTION_NUMBER 0 MOD_NO 0 CONTROL_NUMBER 0 ACTION_KEY 0 BUYER_ID 0 USER_ID 0 DELETE_DATE

  3. VENDOR_BUSINESS_CLASS VBC_VENDOR_FK VENDOR_EXCEPTION_TYPES # * VENDOR_ID # * BUSINESS_CLASS # * VENDOR_ID # * EXCEPTION_TYPE VET_VENDOR_FK RFQ_CLAUSES RFQ_TARGET_VENDOR_LIST RTV_RFQ_FK # * RFQ_KEY # * VENDOR_ID # * DUNSKEY # * RFQ_KEY # * CC_KEY * SUBJECT 0 TITLE 0 CLAUSE_NUMBER 0 ISSUE_DATE 0 CLAUSE RFQ_CLAUSE_CC_FK REQUEST_FOR_QUOTES # * RFQ_KEY * RFQ_NUMBER 0 MOD_NO 0 BUYER_PERSON_ID * DATE_ISSUED * RESPONSE_DATE 0 EDI_INDICATOR * READY_FOR_EDI 0 TRADING_PARTNER_PROFILE_REQUES 0 FSCN 0 SIC_CODE 0 NOTE 0 CONTROL_NUMBER 0 SMALL_BUSINESS_SET_ASIDE 0 PROVISIONS_AND_REPRESENTATIONS 0 EXTERNAL_NOTE 0 MOD_NOTE 0 NAICS 0 WEB_INDICATOR 0 CO_PERSON_ID 0 CLASS_CODE 0 SYNOPSIS_DESC 0 SYNOPSIS RFQ_CLAUSE_RFQ_FK PR_APPROVALS # * PR_KEY * APPROVAL_ROLE * DATE_APPROVED * APPROVED_BY_ID 0 APPROVAL_NOTE PRAPPRVL_PR_FK PRAPPRVL_PEOPLE_FK RFQ_PR_LIST # * RFQ_KEY # * PR_KEY RFQPR_PR_FK RFQPR_RFQ_FK RSA_RFQ_FK RFQ_STATUS_ACTIVITIES # * RFQ_KEY # * STATUS # * START_DATE 0 NOTE RFQ_LINE_ITEMS # * RFQ_KEY # * ITEM_NO * DELIVER_BY_DATE * METHOD_OF_SHIPMENT * ACCEPT_INSPECT * DELIVERY_IND * METHOD_OF_SHIPMENT_PAYMENT * HAZMAT_IND 0 SIC_CODE 0 FSCN 0 NAICS RFQLIRFQ_FK

  4. SP_DIVISIONS # * DIVISION_ID * NAME SP_TEAMS SP_SECTIONS # * TEAM_ID * NAME * SECTION_ID # * SECTION_ID * NAME * DIVISION_ID SP_TEAMS_SP_SECTS_FK SP_SECTIONS_SP_DIVS_FK RLDS_RFQ_FK RFQ_LI_DELIVERY_SCHEDULES # * RFQ_KEY # * RFQ_ITEM_NO # * SCHEDULE_NO * START_DATE * END_DATE 0 DURATION 0 UNIT_OF_MEAS 0 FREQUENCY RLDS_UNIT_MEAS_FK EMAIL_REFS SP_CCR_CLASSIFICATIONS SP_PRINT_VENDORS SIC_REF 0 PR_KEY 0 RFQ_KEY 0 VENDOR_ID 0 DUNSKEY 0 PO_KEY 0 BUS_TYPE 0 CLASSIFICATION * MAIL_HOST * PORT * SENDER * RECIPIENT * USER_ID * PASSWORD # * ID_CD * NAME 0 DSCR 0 OBS_IND INSTANCE RELEASE_NOTES SP_LOOKUP # * INSTANCE 0 STATE_CODE 0 DYNACOMM_PATH 0 PRINT_QUEUE 0 FINANCE_OFFICE_KEY 0 IFMS_FLAG 0 INSTANCE_ID 0 INSTANCE_ID2 # * LOOKUP 0 CODE 0 DESCRIPTION 0 ORDER_BY 0 TYPE # * VERSION 0 RELEASE_NOTES INSTANCE_ FINANCE_FK

  5. VENDORS # * VENDOR_ID * NAME * STREET_ADDRESS_1 0 STREET_ADDRESS_2 * CITY 0 STATE * ZIP_CODE 0 ZIP_PLUS_CODE 0 EDI_ID 0 VAN 0 SECOND_NAME 0 FAX_PHONE_NO 0 PHONE_NO 0 INTERNATIONAL_ADDRESS 0 TAX_ID 0 CORPORATE_STATUS 0 EDI_PLUS 0 NON_US_PHONE 0 COUNTRY_CODE 0 POSTAL_CODE 0 INTERNATIONAL_ZIP_CODE 0 ORG_TYPE 0 SUSPENDED 0 EXCEPTION_FLAG 0 DUNSKEY 0 DISABLE CONTRACT_CLAUSES # * CC_KEY * SUBJECT 0 TITLE 0 CLAUSE_NUMBER 0 ISSUE_DATE 0 CLAUSE 0 PO_STANDARD_CLAUSE 0 OBSOLETE 0 RFQ_STANDARD_CLAUSE 0 DISPLAY 0 CCR 0 EPS QTE_BUY_FK QTE_PR_FK QUOTES # * QUOTE_KEY 0 PR_KEY 0 RFQ_KEY * DATE_OF_QUOTE * DATE_RECEIVED * FROM_VENDOR_ID * FROM_VENDOR_DUNSKEY 0 PAYMENT_DISCOUNT_PERCENT 0 VENDOR_DELIVERY_DATE 0 VENDOR_PHONE 0 VENDOR_QUOTE_ACCEPTANCE_PERIOD 0 VENDOR_QUOTE_ID 0 VENDOR_POC 0 PAYMENT_TERMS 0 PAYMENT_DISCOUNT_PERIOD 0 VENDOR_NOTE 0 VENDOR_PHONE_EXT 0 BUYER_ID 0 CONTROL_NUMBER 0 RECEIVED_VIA_EDI 0 RECEIVED_VIA 0 ONE_SOURCE_REASON 0 BASIS_FOR_PRICE 0 OTHER_FACTORS QTE_RFQ_FK QLI_QTE_FK QUOTE_LINE_ITEMS # * QUOTE_KEY # * ITEM_NO * QUANTITY * UNIT_PRICE 0 UNIT_OF_MEASURE * AMOUNT 0 PR_KEY 0 PR_LI_ITEM_NO 0 RFQ_KEY 0 RFQ_LI_ITEM_NO 0 CONTRACT_NO 0 CONTRACT_NO_TYPE 0 VENDOR_SHORT_DESC 0 VENDOR_LONG_DESC FSC_REF # * FSC * TITLE QLIRFQLI_FK QLI_UNIT QLIPRQLI_FK

  6. SP_UNITS # * UNIT * NAME 0 DESCRIPTION PO_LINE_ITEM_COMMITMENTS # * PO_LI_COM_KEY * PO_KEY * POLI_ITEM_NO 0 PRACCT_PR_KEY 0 PRACCT_ITEM_NUMBER 0 AMOUNT 0 FISCAL_YEAR POLIC_PO_FK POLIC_PRAACT_FK ADD_VENDOR_FK ADD_VENDOR_HISTORY # * VENDOR_ID 0 NAME 0 EDI_ID 0 EDI_PLUS 0 USER_ID 0 ADD_DATE OFFICES # * ORG_KEY * ORG_CODE 0 BUYING_OFFICE_CODE * NAME * STREET_ADDRESS * CITY * STATE_CODE * ZIP_CODE 0 ZIP_PLUS_CODE * MAIL_DROP_NO 0 EMAIL_ADDR 0 GOVT_PHONE_NO 0 FAX_PHONE_NO 0 COMM_PHONE_NO * GOVT_AGENCY_CODE * REGION_CODE 0 MANAGING_OFFICE_KEY 0 EXPIRATION_DATE 0 STREET_ADDRESS2 0 GO_ID_CD 0 DUNS 0 DUNS_PLUS OFF_MANAGED_BY_FK

  7. PO_CLAUSE_CC_FK PURCHASE_ORDERS PO_CLAUSES #* PO_KEY * PO_NUMBER 0 MOD_NO * PARTIAL_OBLIGATION_IND * TYPE_OF_ORDER 0 ISSUED_OFF_KEY 0 CO_PERSON_KEY 0 PAID_FOR_OFF_KEY * FISCAL_YEAR 0 DATE_OF_ORDER * TYPE_OF_MOD 0 READY_FOR_EDI 0 NOTE 0 PARTIAL_OBLIG_TXN_COUNTER 0 CONTRACT_NO 0 SPECIAL_INSTRUCTIONS 0 DELIVER_BY_DATE 0 ACCEPT_INSPECT 0 DELIVERY_IND 0 DATE_TO_DISTRIBUTION 0 DISTRIBUTION_PERSON 0 MOD_NOTE 0 IFMS_FLAG 0 BUYER_ID 0 CONTROL_NUMBER 0 FOB_CITY 0 FOB_STATE 0 ADVANCED_PAY_AUTHORIZED 0 FOREIGN_CURRENCY_ALLOWED 0 PARTIAL_PAY_ALLOWED 0 OPAC_ORDER 0 QUOTE_KEY 0 VENDOR_ID 0 PO_AWARDED 0 SHORT_DESC 0 CALL_NUMBER 0 MOD_TOTAL 0 PO_LI_NOTE 0 DATE_OF_CLOSE 0 PO_REF 0 PERF_START_DATE 0 PERF_END_DATE 0 MAX_EXPIRE_DATE 0 SYNOPSIZED 0 EFORM_NOTE 0 ETHNICITY 0 NAICS 0 PBC 0 FSCN 0 WEB_INDICATOR 0 SIC_CODE 0 OF279 0 SIC_2_CODE 0 PO_TYPE 0 PSC_CODE 0 PO_METHOD 0 BPA_NUMBER 0 DUNSKEY 0 FDS_INDICATOR PO_CLAUSE_PO_FK # * PO_KEY # * CC_KEY * SUBJECT 0 TITLE 0 CLAUSE_NUMBER 0 ISSUE_DATE 0 CLAUSE PO_STATUS_ACTIVITIES POSA_PO_FK # * PO_KEY # * STATUS # * START_DATE 0 END_DATE 0 NOTES PO_AUTHORITIES PO_AUTH_PO_FK # * PO_KEY # * AUTH_CODE 0 AUTH_NOTE SP_PO_CLASSIFICATIONS POCLASS_PO_FK # * PO_KEY # * CLASSIFICATION PO_QUOTE_FK PO_CO_FK PO_DP_FK PO_BUY_FK VENPOEX_PO_ FK VENDOR_PO_EXCEPTION_TYPES # * PO_KEY # * VENDOR_ID # * EXCEPTION_TYPE PO_ISSUED_BY PO_PAID_FOR_BY

  8. POLI_PART_OF PO_LINE_ITEMS # * PO_KEY # * ITEM_NO * AMOUNT 0 QUOTE_KEY 0 QUOTE_ITEM_NO 0 GOVT_BILL_OF_LADING_NO 0 GROSS_SHIP_WEIGHT * QUANTITY * UNIT_PRICE 0 UNIT_OF_MEASURE 0 CONTRACT_NO 0 CONTRACT_NO_TYPE 0 SHORT_DESC 0 LONG_DESC POLI_QUOTE_FK POLIUNIT_FK TT2_DATA 0 TT2_TENDIGIT_CODE 0 TT2_REQ_NUM 0 TT2_LINE_AMT 0 TT2_BUDGET_FY 0 TT2_APPROPRIATION 0 TT2_BUDGET_OCC 0 TT2_PROG_ELEMENT 0 TT2_SITE_PROJECT 0 TT2_BUDGET_ORG 0 TT2_COST_ORG 0 TT2_BUDGET_LINE_NUM 0 TT2_IFMS_RPIO 0 TT2_TREASURY_SYM 0 TT2_CLOSED_AMT 0 TT2_OBLIGATED_AMT 0 TT2_USER_ID

  9. PEOPLE PRINT_DESTINATIONS # * PERSON_ID * FIRST_NAME 0 MIDDLE_NAME * LAST_NAME 0 NAME_SUFFIX 0 NAME_ALIAS 0 GOVT_PHONE_NO 0 ASSIGNED_TO_OFFICE 0 WARRANT_LEVEL 0 EMAIL_ADDRESS 0 COMM_PHONE_NO 0 SEPARATION_DATE 0 USER_ID 0 GSM_ID_CD 0 EPA_REGION_NAME 0 FAX_PHONE_NO 0 MAIL_DROP 0 GSM_SSN_ID 0 GSM_DUTY_ID 0 GSM_DETAIL_DUTY_CD 0 GSM_PSTN_NAME 0 GSM_TRMN_IND 0 MANAGER 0 ROOM_NO 0 EDI_KEY 0 PRINT_KEY 0 EDI_EXPIRE_DATE 0 RELEASE_NOTES 0 CLOSEOUT 0 DIVISION_ID 0 SECTION_ID 0 TEAM_ID 0 ACTION 0 IE_PATH PEOPLE_PRINT_FK # * PRINT_KEY * DESTINATION * USERNAME REPORT_QUEUE_FK REPORT_QUEUE # * SEQ_NO * FILE_NAME * REPORT_NAME 0 PARAM1 0 PARAM2 0 RPTUSER 0 RPTTIME 0 PARAM3 0 SYSTEM_NAME REPORT_PARAMETERS_FK REPORT_PARAMETERS * SEQ_NO * PARAM_NAME * PARAM_VALUE RFQ_BUYER

  10. PEOPLE_SP_ DIVS_FK PEOPLE_SP_ TEAMS_FK PEOPLE_SP_ SECTS_FK PERSON_ ASSIGNED_ TO_FK

  11. VENDORS SPEDI_CCR_VENDORS (view) # * VENDOR_ID 0 DUNSKEY * NAME 0 TAX_ID * STREET_ADDRESS_1 0 CORPORATE_STATUS 0 STREET_ADDRESS_2 0 EDI_PLUS * CITY 0 NON_US_PHONE 0 STATE 0 COUNTRY_CODE * ZIP_CODE 0 POSTAL_CODE 0 ZIP_PLUS_CODE 0 ORG_TYPE 0 EDI_ID 0 SUSPENDED 0 VAN 0 EXCEPTION_FLAG 0 SECOND_NAME 0 DISABLE 0 FAX_PHONE_NO 0 PHONE_NO 0 INTERNATIONAL_ADDRESS 0 INTERNATIONAL_ZIP_CODE * DUNSKEY 0 DUNS 0 DUNS_PLUS4 0 CAGE_CODE 0 RECORD_DELETION_FLAG 0 LEGAL_BUSINESS_NAME 0 DOING_BUSINESS_AS_NAME 0 COMPANY_DIVISION 0 CORPORATE_URL 0 ORGANIZATIONAL_TYPE 0 PARENT_DUNS_NUMBER 0 TAX_PAYER_ID_NUMBER 0 SOCIAL_SECURITY_NUMBER 0 AVG_NUMBER_OF_EMPLOYEES 0 ANNUAL_REVENUE SPEDI_CCR_EXCPT_VENDORS (view) # * VENDOR_ID 0 CITY 0 ORG_TYPE # * DUNSKEY 0 STATE 0 DUNS 0 COUNTRY_CODE 0 DUNS_PLUS4 0 POSTAL_CODE 0 LEGAL_BUS_NAME 0 PHONE_NO 0 DOING_BUS_AS_NAME 0 NON_US_PHONE_NO 0 STREET_ADDRESS_1 0 FAX_NO 0 STREET_ADDRESS_2 0 TAX_ID VENDORS_HISTORY # * VENDOR_ID 0 CITY 0 ORG_TYPE # * DUNSKEY 0 STATE 0 DUNS 0 COUNTRY_CODE 0 DUNS_PLUS4 0 POSTAL_CODE 0 LEGAL_BUS_NAME 0 PHONE_NO 0 DOING_BUS_AS_NAME 0 NON_US_PHONE_NO 0 STREET_ADDRESS_1 0 FAX_NO 0 STREET_ADDRESS_2 0 TAX_ID \ PO_VENDORS_HISTORY # * VENDOR_ID 0 CITY # * DUNSKEY 0 STATE # * PO_KEY 0 COUNTRY_CODE 0 DUNS 0 POSTAL_CODE 0 DUNS_PLUS4 0 PHONE_NO 0 LEGAL_BUS_NAME 0 NON_US_PHONE_NO 0 DOING_BUS_AS_NAME 0 FAX_NO 0 STREET_ADDRESS_1 0 TAX_ID 0 STREET_ADDRESS_2 0 ORG_TYPE This page represents Super-Type/Sub-Type Relationships

More Related