This discussion is archived
3 Replies Latest reply: Nov 21, 2012 9:42 PM by user12990981 RSS

Need Project Fields

Delli Newbie
Currently Being Moderated
Hi ,

i`m new to EBS, which table to get this following fields.
Account number
Project Name
Receipt Amount
Invoice Number
Date

Please help..
  • 1. Re: Need Project Fields
    MN_Twins Newbie
    Currently Being Moderated
    I would suggest being more specific in your request of field names.

    Account Number (customer?)
    Project Name - pa_projects_all
    Receipt Amount - ?
    Invoice Number - AP or AR?
    Date - expenditure item date? project creation date? Invoice date?

    Too many fields to determine which one you are referring to.
  • 2. Re: Need Project Fields
    Sanjay Desai Journeyer
    Currently Being Moderated
    You can get

    Account number ( table : GL_CODE_COMBINATIONS. SEGMENT1||'.'||SEGMENT2||'.'||SEGMENT3||'.'||SEGMENT4||'.'||SEGMENT5 -- no.of segment1 as per your organization acount code setup)
    Project Name ( PA_PROJECTS_ALL.SEGMENT1)
    Receipt Amount ( RCV_SHIPMENT_HEADERS.RECEIPT_NUM ) --- THIS IS FOR PO RECEIPT
    AP Invoice Number ( AP_INVOICES_ALL.INVOICE_NUM)
    AP INV.Date (AP_INVOICES_ALL.INVOICE_DATE)

    AR Invoice Number (RA_CUSTOMER_TRX_ALL.TRX_NUMBER)
    AR INV.Date (RA_CUSTOMER_TRX_ALL.TRX_DATE)

    HTH
    Sanjay
  • 3. Re: Need Project Fields
    user12990981 Explorer
    Currently Being Moderated
    Hi,

    Go to Projects > Billing > Revenue, select ur project, got to Lines then, on the tool bar Help > Diagnostics > Examine > Block - System, Field- Last Query, Value - Is ur output.

    Regards
    Raghavender K

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points