3 Replies Latest reply: Nov 21, 2012 11:42 PM by user12990981 RSS

    Need Project Fields

    pavan.Rempar
      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
          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 EBS
            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
              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