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": ""
    },