Payables & Cash Management

Get Involved. Join the Conversation.


    Juan David Cantillo Hincapie
    Employee Info in Payment from Expenses
    Topic posted October 21, 2019 by Juan David Cantillo HincapieBlue Ribbon: 750+ Points, tagged Expenses, Financials, Payables, Reports 
    18 Views, 1 Comment
    Employee Info in Payment from Expenses
    How to obtain the employee National ID in payments from Expenses

    How can I get the Employee National ID, Person Number or Security Number in payments originating in expenses?

    Business case
    In creating the files from {IBY_TRXN_DOCUMENTS table (.Document) XML attribute}, that are sent to make payments at the banks, the banks need the employee identification, but this does not appear in the IBY_TRXN_DOCUMENTS table, how can it be obtained? Or which other attribute in employee I can use for this.

    19C (



    • Kondaiah Mandadi


      In the case of employee expense reimbursements, Payments fetch the National identifier the funds disbursement extract under the following structure -




      <Name>IBY1 ONE</Name>



      . . . . . 

      Recently, we have also addressed an ER - through which, we are also fetching the National Identifier type.  This will be available in 20A.