Read (GET) Cash Receipts
Use this API to read cash receipts from the Transactions Center.
To get cash receipts transaction data:
Execute a GET command on the endpoint
{{url}}/ledger/CR.
For example, here is a request submitted using cURL:
curl --request GET \ --url 'https://{{url}}/ledger/CR' \ --header 'authorization: Bearer {{oauth_token}}' \ --header 'content-type: application/json' \
A successful GET returns the JSON representation of the cash receipts transaction data, for example:
{ "Period": 201601, "PostSeq": 46, "PKey": "566380714947", "WBS1": "CAR00000000000000024", "WBS2": " ", "WBS3": " ", "Account": "524.00", "Org": "00", "TransType": "CR", "SubType": "", "RefNo": "REF", "TransDate": "2016-12-18T00:00:00.000", "Desc1": "Deposit - Cash Receipts Comment", "Desc2": "Cash Receipts Description", "Amount": -5000, "CBAmount": 0, "BillExt": 0, "ProjectCost": "Y", "AutoEntry": "N", "SuppressBill": "N", "BillStatus": "B", "SkipGL": "N", "BankCode": "Corporate", "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": -5000, "TransactionCurrencyCode": "", "ExchangeInfo": "", "AmountProjectCurrency": -5000, "ProjectExchangeInfo": "", "AmountBillingCurrency": -5000, "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": "A", "OriginatingVendor": "", "Diary": "", "DiaryNo": 0, "CreditCardPrimaryCode": "", "CreditCardCode": "", "CreditCardPKey": "", "TransferredPeriod": 0, "TransferredBillStatus": "", "PreInvoice": "", "EquipmentID": "", "BookCode": "", "EmOrg": "", "LastPSAExportDate": "" },