General Technical Discussions for Service

Get Involved. Join the Conversation.

Topic

    Tracey Weetman
    How to Retrieve List of ENTITY Names for ERP Object DFF...
    Topic posted April 10, 2019 by Tracey Weetman 
    91 Views, 2 Comments
    Title:
    How to Retrieve List of ENTITY Names for ERP Object DFF Update Service
    Summary:
    Need to find list of ENTITY Names for ERP Object DFF Update Web Service
    Content:

    How can I retrieve a list of ERP Object Names using the web service.

    Eg:  If I want to update the AR_PAYMENT_SCHEDULE DFF Attributes using the ErpObjectDFFUpdateService what is the Entity Name for AR Payment Schedule etc..

    For AR Invoices, the Entity Name is 'Receivables Invoice' and I need to get a list of available items which would include the AR Payment Schedule DFFs

     

    Comment

     

    • Geert Buyckx

      Hi Tracey,

      I am looking for the same functionality.  I would like to update standard DFF's (not Global DFF's) on an installment of a receivable transaction.  Did you ever find out if this webservice can be used?

      In the repository I found REST API for Global DFF's "Receivables Invoice Installment Global Descriptive Flexfields REST Endpoints" but I don't think I can use this for standard DFF's.

      Regards,

      Geert

    • Massimo D'Angelo

      Hi, below my list and references.

      How to run webservice: ERP Object Descriptive Flexfield Update Service (ErpObjectDFFUpdateService) if using duplicate transaction numbers for more than one transaction. (Doc ID 2193597.1)
      EntityName = Receivables Invoice
      ContextValue = Transactions = Context name of the descriptive flexfield (DFF).
      Choose name = Transactions
      Key A: Transaction Number
      Key B: Transaction Source
      Key C: Reference Data Set Name
      Key D: Customer Transaction ID
      KEY E: Null

      Sample Payload to Update DFF at Receivables Invoice Line Level (Doc ID 2513530.1)
      EntityName = Receivables Invoice Lines
      ContextValue = Invoice Lines
      User Key A Line Number *
      User Key B Transaction Number **
      User Key C Batch Source Name **
      User Key D Set Name **
      User Key E Customer Transaction Id (Required only if Key B,C,D can not fetch unique record)
      User Key F Customer Transaction Line Id (Required only if Key B,C,D can not fetch unique record)
      User Key G Null
      User Key H Null
      * Mandatory
      ** Required if there can be duplicate Line Numbers

      Error while trying to Update AP Invoices, Lines And Distributions DFF Using ErpObjectDFFUpdateService Webservice (Doc ID 2546651.1)

      For invoice header DFFs, customer needs to use the entity name as ‘Payables Invoice’ instead of ‘Standard Payable Invoices’ and below is the suggested mapping:
      • Invoice Number in User Key A
      • Business Unit Name in User Key B
      • Supplier Name in User Key C
      • Supplier Number in User Key D
      • Supplier Site Name in User Key E
      • Invoice Identifier in User Key F

      For Payables Invoice Lines, customer needs to use the entity name as 'Payables Invoice Lines' and here is the suggested mapping:
      • Line Number in User Key A
      • Invoice Number in User Key B
      • Business Unit Name in User Key C
      • Supplier Name in User Key D
      • Supplier Number in User Key E
      • Supplier Site Name in User Key F
      • Invoice Identifier in User Key G

      Regards

      Massimo