Read (GET) AP Payments
Use this API to read an accounts payable payment from the Transactions Center. AP payments are for vendors' vouchers.
To get AP payment transaction data:
Execute a GET command on the endpoint
{{url}}/ledger/PP.
For example, here is a request submitted using cURL:
curl --request GET \ --url 'https://{{url}}/ledger/PP' \ --header 'authorization: Bearer {{oauth_token}}' \ --header 'content-type: application/json' \
A successful GET returns the JSON representation of the accounts payable payment transaction data, for example:
{ "Period": 201601, "PostSeq": 56, "PKey": "566385731109", "WBS1": "CAR00000000000000020", "WBS2": " ", "WBS3": " ", "Account": "522.00", "Org": "", "TransType": "PP", "SubType": "C", "RefNo": "JIGSPAY", "TransDate": "2017-12-12T00:00:00.000", "Desc1": "VENDOR Name", "Desc2": "Voucher 0000007 Line 3", "Amount": 500.66, "CBAmount": 0, "BillExt": 0, "ProjectCost": "N", "AutoEntry": "N", "SuppressBill": "N", "BillStatus": "", "SkipGL": "Y", "BankCode": "Corporate", "Invoice": "", "InvoiceSection": "", "Employee": "", "Vendor": "JIGSVENDOR", "Line": 3, "PartialPayment": 0, "Discount": 0, "Voucher": "0000007", "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": 500.66, "TransactionCurrencyCode": " ", "ExchangeInfo": "", "AmountProjectCurrency": 0, "ProjectExchangeInfo": "", "AmountBillingCurrency": 0, "BillingExchangeInfo": "", "AutoEntryAmount": 0, "AutoEntryExchangeInfo": "", "AutoEntryOrg": "", "AutoEntryAccount": "", "AmountSourceCurrency": 500.66, "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": "" }