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