1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Mandatory columns to import the data into PO base tables

Discussion in 'Oracle Financials' started by kartheekbk, May 23, 2014.

  1. kartheekbk

    kartheekbk Active Member

    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    80
    Hi,

    Can you provide me the mandatory fields to import the data into below base tables
    PO_HEADERS_ALL
    PO_LINES_ALL
    PO_DISTRIBUTIONS_ALL

    I will be running the "Import Standard Purchase Orders" program to load data into the above base tables.

    I have some required columns below but please update me If I need to add/remove any fields.
    BATCH_ID,
    ORG_ID,
    ACTION,
    DOCUMENT_TYPE_CODE,
    CURRENCY_CODE,
    AGENT_ID,
    VENDOR_NAME,
    VENDOR_NAME,
    VENDOR_SITE_CODE,
    SHIP_TO_LOCATION_ID,
    BILL_TO_LOCATION_ID,
    APPROVAL_STATUS,
    FREIGHT_CARRIER,
    FOB,
    FREIGHT_TERMS,
    LINE_NUM,
    SHIPMENT_NUM,
    LINE_TYPE,
    ITEM,
    ITEM_DESCRIPTION,
    ITEM_ID,
    UOM_CODE,
    QUANTITY,
    UNIT_PRICE,
    SHIP_TO_ORGANIZATION_CODE,
    LIST_PRICE_PER_UNIT,
    QUANTITY_ORDERED,
    DESTINATION_ORGANIZATION_ID,
    SET_OF_BOOKS_ID,
    CHARGE_ACCOUNT_ID,
    DISTRIBUTION_NUM,
    SHIP_TO_ORGANIZATION_ID
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Note the proper location for this post.