2 Replies Latest reply on Apr 1, 2011 6:59 AM by sachin ahuja

    Default Charge Account in PO Requisition using Interface

    Allen Sandiego
      Hi,

      I have a requirement to bring in Requisition data from another system and will be using PO Requisition Interface to do so. I will be given most of the required fields listed below:

      COLUMN_NAME
      BATCH_ID
      INTERFACE_SOURCE_CODE
      ORG_ID
      AUTHORIZATION_STATUS
      PREPARER_NAME
      ITEM_DESCRIPTION
      UNIT_OF_MEASURE
      UOM_CODE
      QUANTITY
      UNIT_PRICE
      DESTINATION_TYPE_CODE
      DELIVER_TO_REQUESTOR_NAME
      DESTINATION_ORGANIZATION_CODE
      DELIVER_TO_LOCATION_CODE
      SOURCE_TYPE_CODE
      SUGGESTED_VENDOR_NAME
      SUGGESTED_VENDOR_SITE
      PROJECT_NUMBER
      TASK_NUMBER
      EXPENDITURE_TYPE
      EXPENDITURE_ITEM_DATE
      EXPENDITURE_ORGANIZATION_ID

      Problem is that the CHARGE_ACCOUNT_ID is also required but not provided. I was told that I should be able to derive a default CHARGE_ACCOUNT based on the PROJECT_NUMBER and TASK_NUMBER. If so, how do I do this?

      Thanks.
      Allen