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!

AP_INVOICE_DISTRIBUTIONS_ALL table

Discussion in 'Oracle Apps Technical' started by yknev, Apr 10, 2010.

  1. yknev

    yknev Active Member

    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    100
    Dear All,

    Please clarify below query:-

    When will populate with zero or null or value in PREPAY_AMOUNT_REMAINING column in ap_invoice_distributions_all table

    Thanks inadvance,

    Rgds,

    yknev
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    PREPAY_AMOUNT_REMAINING stores the amount of prepayment that can still be applied to an invoice. Why don't you try a few transactions in TEST instance and see what values get populated when.
     
  3. yknev

    yknev Active Member

    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    100
    I have tried so many tiimes before posting a comment, but it shows different values like 0, null & remaining amount. which one is correct. Can u give me idea for this query.