Read (GET) Employee Payments

Use this API to read employee payments from the Transactions Center. Employees are paid for their expenses from their expense reports.

To get employee payments transaction data:

Execute a GET command on the endpoint {{url}}/ledger/EP.

For example, here is a request submitted using cURL:

curl --request GET \
  --url 'https://{{url}}/ledger/EP' \
  --header 'authorization: Bearer {{oauth_token}}' \
  --header 'content-type: application/json' \

A successful GET returns the JSON representation of the employee payments transaction data, for example:

    {
        "Period": 201111,
        "PostSeq": 12,
        "PKey": "PKEYTEST375190867034",
        "WBS1": "",
        "WBS2": "",
        "WBS3": "",
        "Account": "212.00",
        "Org": "00:00",
        "TransType": "EP",
        "SubType": "R",
        "RefNo": "000000005",
        "TransDate": "2011-11-21T00:00:00.000",
        "Desc1": "Hetfield, James",
        "Desc2": "dDinner 11/18/2017",
        "Amount": 136.48,
        "CBAmount": 0,
        "BillExt": 0,
        "ProjectCost": "N",
        "AutoEntry": "N",
        "SuppressBill": "N",
        "BillStatus": "",
        "SkipGL": "N",
        "BankCode": "001",
        "Invoice": "",
        "InvoiceSection": "",
        "Employee": "00002",
        "Vendor": "",
        "Line": 0,
        "PartialPayment": 0,
        "Discount": 0,
        "Voucher": "000000001",
        "BilledWBS1": "",
        "BilledWBS2": "",
        "BilledWBS3": "",
        "BilledInvoice": "",
        "BilledPeriod": 0,
        "Unit": "",
        "UnitTable": "",
        "UnitQuantity": 0,
        "UnitCostRate": 0,
        "UnitBillingRate": 0,
        "UnitBillExt": 0,
        "XferWBS1": "",
        "XferWBS2": "",
        "XferWBS3": "",
        "XferAccount": "",
        "TaxCode": "",
        "TaxBasis": 0,
        "TaxCBBasis": 0,
        "BillTaxCodeOverride": "",
        "WrittenOffPeriod": 0,
        "TransactionAmount": 136.48,
        "TransactionCurrencyCode": "USD",
        "ExchangeInfo": "",
        "AmountProjectCurrency": 0,
        "ProjectExchangeInfo": "",
        "AmountBillingCurrency": 0,
        "BillingExchangeInfo": "",
        "AutoEntryAmount": 0,
        "AutoEntryExchangeInfo": "",
        "AutoEntryOrg": "",
        "AutoEntryAccount": "",
        "AmountSourceCurrency": 136.48,
        "SourceExchangeInfo": "",
        "PONumber": "",
        "UnitCostRateBillingCurrency": 0,
        "LinkCompany": "",
        "LinkWBS1": "",
        "LinkWBS2": "",
        "LinkWBS3": "",
        "BillTax2CodeOverride": "",
        "GainsAndLossesType": "",
        "AmountTaxCurrency": 0,
        "CBAmountTaxCurrency": 0,
        "TaxBasisTaxCurrency": 0,
        "TaxCBBasisTaxCurrency": 0,
        "TaxBasisFunctionalCurrency": 0,
        "TaxCBBasisFunctionalCurrency": 0,
        "DiscountFunctionalCurrency": 0,
        "ModUser": "",
        "AuthorizedBy": "",
        "RealizationAmountEmployeeCurrency": 0,
        "RealizationAmountProjectCurrency": 0,
        "RealizationAmountBillingCurrency": 0,
        "NonBill": "",
        "CreditMemoRefNo": "",
        "OriginalAmountSourceCurrency": 0,
        "OriginalPaymentCurrencyCode": "",
        "InProcessAccount": "N",
        "InProcessAccountCleared": "N",
        "InvoiceStatus": "",
        "EKOriginalLine": 0,
        "OriginatingVendor": "",
        "Diary": "",
        "DiaryNo": 0,
        "CreditCardPrimaryCode": "",
        "CreditCardCode": "",
        "CreditCardPKey": "",
        "TransferredPeriod": 0,
        "TransferredBillStatus": "",
        "PreInvoice": "",
        "EquipmentID": "",
        "BookCode": "",
        "EmOrg": "",
        "LastPSAExportDate": ""
    },