Read (GET) Employee Expenses
Use this API to read employee expenses from the Transactions Center.
To get employee expenses transaction data:
Execute a GET command on the endpoint
{{url}}/ledger/EX.
For example, here is a request submitted using cURL:
curl --request GET \ --url 'https://{{url}}/ledger/EX' \ --header 'authorization: Bearer {{oauth_token}}' \ --header 'content-type: application/json' \
A successful GET returns the JSON representation of the employee expense transaction data, for example:
{ "Period": 201601, "PostSeq": 57, "PKey": "566393116936", "WBS1": "CAR00000000000000020", "WBS2": " ", "WBS3": " ", "Account": "525.00", "Org": "00", "TransType": "EX", "SubType": "", "RefNo": "0000001", "TransDate": "2016-12-20T00:00:00.000", "Desc1": "Enrile, Jon", "Desc2": "Employee Expense description", "Amount": 1000.56, "CBAmount": 0, "BillExt": 0, "ProjectCost": "Y", "AutoEntry": "N", "SuppressBill": "N", "BillStatus": "X", "SkipGL": "N", "BankCode": "", "Invoice": "", "InvoiceSection": "", "Employee": "JON ENRILE", "Vendor": "", "Line": 3, "PartialPayment": 0, "Discount": 0, "Voucher": "0000001", "BilledWBS1": "CAR00000000000000020", "BilledWBS2": " ", "BilledWBS3": " ", "BilledInvoice": "0000002", "BilledPeriod": 201601, "Unit": "", "UnitTable": "", "UnitQuantity": 0, "UnitCostRate": 0, "UnitBillingRate": 0, "UnitBillExt": 0, "XferWBS1": "CAR00000000000000024", "XferWBS2": " ", "XferWBS3": " ", "XferAccount": "525.00", "TaxCode": "", "TaxBasis": 0, "TaxCBBasis": 0, "BillTaxCodeOverride": "", "WrittenOffPeriod": 201601, "TransactionAmount": 1000.56, "TransactionCurrencyCode": " ", "ExchangeInfo": "", "AmountProjectCurrency": 1000.56, "ProjectExchangeInfo": "", "AmountBillingCurrency": 1000.56, "BillingExchangeInfo": "", "AutoEntryAmount": 0, "AutoEntryExchangeInfo": "", "AutoEntryOrg": "", "AutoEntryAccount": "", "AmountSourceCurrency": 1000.56, "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", "EKOriginalLine": 1, "InvoiceStatus": "", "OriginatingVendor": "", "Diary": "", "DiaryNo": 0, "CreditCardPrimaryCode": "", "CreditCardCode": "", "CreditCardPKey": "", "TransferredPeriod": 0, "TransferredBillStatus": "", "PreInvoice": "", "EquipmentID": "", "BookCode": "", "EmOrg": "", "LastPSAExportDate": "" },