Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Mapping Source fields to the ORACLE R12 Purchasing Open Interface table

  1. #1
    Join Date
    May 2012
    Posts
    110

    Default Mapping Source fields to the ORACLE R12 Purchasing Open Interface table

    I was hoping to use Pentaho to insert rows in the ORACLE R12 Purchasing Open Interface table: PO_REQUISITIONS_INTERFACE_ALL tables
    But I do not know how to map/populate all of the Source System fields. How do I store the source system order number so that I can link it to the Oracle R12 Purchase Request when it is authorised?
    PO_REQUISITIONS_INTERFACE_ALL MV_PURCHASE_REQUEST
    INTERFACE_SOURCE_CODE Default to ‘SYSTEM’
    DESTINATION_TYPE_CODE Default to ‘INVENTORY’
    AUTHORIZATION_STATUS Default to ‘INCOMPLETE’
    PREPARER_ID or PREPARER_NAME Default to ‘WEB_MIGRATION’
    QUANTITY QUANTITY_DUE
    CHARGE_ACCOUNT_ID TBD The Default Charge Account for SYSTEM
    DESTINATION_ORGANIZATION_ID or DESTINATION_ORGANIZATION_CODE SEGREGATION_CODE
    DELIVER_TO_LOCATION_ID or DELIVER_TO_LOCATION_CODE SEGREGATION_CODE
    DELIVER_TO_REQUESTOR_ID or DELIVER_TO_REQUESTOR_NAME Lookup Table Global Address Name using SEGREGATION_CODE
    ITEM_ID TBD Is this the PART or the Internal ITEM_ID in the Target System for the PART
    CATEGORY_ID TBD Lookup Table PARTS Inventory Class Code using PART/CAGE
    UNIT_OF_MEASURE UM_ORDER_CODE
    NEED_BY_DATE NEED_DATE
    ???
    ORDER_NUMBER The Source System Order Number to link the AR to the PR for the SYSTEM
    Last edited by vincepop01; 01-14-2014 at 08:03 AM. Reason: punctuation
    Regards Vince

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.