Read (GET) Journal Entries
Use this API to read journal entries from the Transactions Center. Read journal entries of salaries, withholdings, bonuses, or accruals.
To get journal entries:
Execute a GET command on the endpoint
{{url}}/ledger/JE.
For example, here is a request submitted using cURL:
curl --request GET \ --url 'https://{{url}}/ledger/JE' \ --header 'authorization: Bearer {{oauth_token}}' \ --header 'content-type: application/json' \
A successful GET returns the JSON representation of a journal entry, for example:
{ "Period": 201601, "PostSeq": 56, "PKey": "566385761153", "WBS1": "CAR00000000000000024", "WBS2": " ", "WBS3": " ", "Account": "522.00", "Org": "00", "TransType": "JE", "SubType": "", "RefNo": "JIGSJOU", "TransDate": "2016-12-19T00:00:00.000", "Desc1": "Journal Entry Description 1", "Desc2": "Journal Entry Grid Description C", "Amount": -400, "CBAmount": 0, "BillExt": 0, "ProjectCost": "Y", "AutoEntry": "N", "SuppressBill": "N", "BillStatus": "T", "SkipGL": "N", "BankCode": "", "Invoice": "", "InvoiceSection": "", "Employee": "", "Vendor": "", "Line": 0, "PartialPayment": 0, "Discount": 0, "Voucher": "", "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": -400, "TransactionCurrencyCode": " ", "ExchangeInfo": "", "AmountProjectCurrency": -400, "ProjectExchangeInfo": "", "AmountBillingCurrency": -400, "BillingExchangeInfo": "", "AutoEntryAmount": 0, "AutoEntryExchangeInfo": "", "AutoEntryOrg": "", "AutoEntryAccount": "", "AmountSourceCurrency": 0, "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": 0, "InvoiceStatus": "", "OriginatingVendor": "", "Diary": "", "DiaryNo": 0, "CreditCardPrimaryCode": "", "CreditCardCode": "", "CreditCardPKey": "", "TransferredPeriod": 0, "TransferredBillStatus": "", "PreInvoice": "", "EquipmentID": "", "BookCode": "", "EmOrg": "", "LastPSAExportDate": "" },