Payables payment
These tables show the field mapping information of the fields that you can use to build your payables payment IDM template.
/PayablesPayment
| XML field | Description |
|---|---|
| Detail | PaymentOutputFileDetail |
| PayablesHeader | PaymentOutputFileHeader |
| PayablesHeaderName | PaymentOutputFileHeader.FileName |
| PayablesHeaderCreateDate | PaymentOutputFileHeader.CreateDate |
| PayablesHeaderCashCode | PaymentOutputFileHeader.CashCode |
| PayablesHeaderCashCodeGroup | PaymentOutputFileHeader.CashCodeGroup |
| PayablesHeaderBankTransactionCode | PaymentOutputFileHeader.BankTransactionCode |
| PayablesHeaderRequisitionType | PaymentOutputFileHeader.RequisitionType |
| PayablesHeaderPayablesProcessGroup | PaymentOutputFileHeader.PayablesProcessGroup |
| CashCode | PaymentOutputFileDetail.CashCode |
| FinancialInstitution | CashCode.FinancialInstitution |
| FinancialInstitutionDescription | CashCode.FinancialInstitution.Description |
| FinancialInstitutionURL | CashCode.FinancialInstitution.FinancialInstitutionURL |
| FIBranch | CashCode.FinancialInstitutionBranch |
| FIBranchDescription | CashCode.FinancialInstitutionBranch.Description |
| FIBranchType | CashCode.FinancialInstitutionBranch.BranchType |
| FIBranchSwift | CashCode.FinancialInstitutionBranch.BranchSwift |
| FIBranchIdentifier | CashCode.FinancialInstitutionBranch.BranchIdentifier |
| FIBranchClearingSystemMemberID | CashCode.FinancialInstitutionBranch.ClearingSystemMemberID |
| FIBranchAddress1 | CashCode.FinancialInstitutionBranch.Address.DeliveryAddress.AddressLine1 |
| FIBranchAddress2 | CashCode.FinancialInstitutionBranch.Address.DeliveryAddress.AddressLine2 |
| FIBranchAddress3 | CashCode.FinancialInstitutionBranch.Address.DeliveryAddress.AddressLine3 |
| FIBranchAddress4 | CashCode.FinancialInstitutionBranch.Address.DeliveryAddress.AddressLine4 |
| FIBranchMunicipality | CashCode.FinancialInstitutionBranch.Address.Municipality |
| FIBranchStateProvince | CashCode.FinancialInstitutionBranch.Address.StateProvince |
| FIBranchPostalCode | CashCode.FinancialInstitutionBranch.Address.PostalCode |
| FIBranchCountry | CashCode.FinancialInstitutionBranch.Address.Country |
| BankAccountCurrency | PaymentOutputFileDetail.BankAccountCurrency |
| BankCountry | PaymentOutputFileDetail.BankCountry |
| BankClientIdentifier | PaymentOutputFileDetail.BankClientIdentifier |
| CashLedgerTransactionIdentifier | PaymentOutputFileDetail.CashLedgerTransactionIdentifier |
| TransactionNumber | PaymentOutputFileDetail.TransactionNumber |
| GeneralLedgerSourceCode | PaymentOutputFileDetail.GeneralLedgerSourceCode |
| BankTransactionCode | PaymentOutputFileDetail.BankTransactionCode |
| EffectiveDate | PaymentOutputFileDetail.EffectiveDate |
| PaymentDate | PaymentOutputFileDetail.PaymentDate |
| PaymentAmount | PaymentOutputFileDetail.PaymentAmount |
| PaymentAmountInWords | PaymentOutputFileDetail.PaymentAmountInWords |
| PayBankCurrency | PaymentOutputFileDetail.PayBankCurrency |
| PayBankAmount | PaymentOutputFileDetail.PayBankAmount |
| ApprovalCostCenter | PaymentOutputFileDetail.ApprovalCostCenter |
| PaidName | PaymentOutputFileDetail.PaidName |
| MailingName | PaymentOutputFileDetail.MailingName |
| PayeePostalAddress1 | PaymentOutputFileDetail.PayeePostalAddress.DeliveryAddress.AddressLine1 |
| PayeePostalAddress2 | PaymentOutputFileDetail.PayeePostalAddress.DeliveryAddress.AddressLine2 |
| PayeePostalAddress3 | PaymentOutputFileDetail.PayeePostalAddress.DeliveryAddress.AddressLine3 |
| PayeePostalAddress4 | PaymentOutputFileDetail.PayeePostalAddress.DeliveryAddress.AddressLine4 |
| PayeeMunicipality | PaymentOutputFileDetail.PayeePostalAddress.Municipality |
| PayeeStateProvince | PaymentOutputFileDetail.PayeePostalAddress.StateProvince |
| PayeePostalCode | PaymentOutputFileDetail.PayeePostalAddress.PostalCode |
| PayeePostalCountry | PaymentOutputFileDetail.PayeePostalAddress.Country |
| PayBankAccountNumber | PaymentOutputFileDetail.PayBankAccountNumber |
| ElectronicPaymentCode | PaymentOutputFileDetail.ElectronicPaymentCode |
| FirstPartyReference | PaymentOutputFileDetail.FirstPartyReference |
| SecondPartyReference | PaymentOutputFileDetail.SecondPartyReference |
| PayorName | PaymentOutputFileDetail.PayorName |
| PayorPostalAddress1 | PaymentOutputFileDetail.PayorPostalAddress.DeliveryAddress.AddressLine1 |
| PayorPostalAddress2 | PaymentOutputFileDetail.PayorPostalAddress.DeliveryAddress.AddressLine2 |
| PayorPostalAddress3 | PaymentOutputFileDetail.PayorPostalAddress.DeliveryAddress.AddressLine3 |
| PayorPostalAddress4 | PaymentOutputFileDetail.PayorPostalAddress.DeliveryAddress.AddressLine4 |
| PayorMunicipality | PaymentOutputFileDetail.PayorPostalAddress.Municipality |
| PayorStateProvince | PaymentOutputFileDetail.PayorPostalAddress.StateProvince |
| PayorPotalCode | PaymentOutputFileDetail.PayorPostalAddress.PostalCode |
| PayorPostalCountry | PaymentOutputFileDetail.PayorPostalAddress.Country |
| PayBankName | PaymentOutputFileDetail.PayBankName |
| PayBankPostalAddress1 | PaymentOutputFileDetail.PayBankPostalAddress.DeliveryAddress.AddressLine1 |
| PayBankPostalAddress2 | PaymentOutputFileDetail.PayBankPostalAddress.DeliveryAddress.AddressLine2 |
| PayBankPostalAddress3 | PaymentOutputFileDetail.PayBankPostalAddress.DeliveryAddress.AddressLine3 |
| PayBankPostalAddress4 | PaymentOutputFileDetail.PayBankPostalAddress.DeliveryAddress.AddressLine4 |
| PayBankMunicipality | PaymentOutputFileDetail.PayBankPostalAddress.Municipality |
| PayBankStateProvince | PaymentOutputFileDetail.PayBankPostalAddress.StateProvince |
| PayBankPostalCode | PaymentOutputFileDetail.PayBankPostalAddress.PostalCode |
| PayBankPostalCountry | PaymentOutputFileDetail.PayBankPostalAddress.Country |
| CrossBorderIdentifier | PaymentOutputFileDetail.CrossBorderIdentifier |
| PayBankEntity | PaymentOutputFileDetail.PayBankEntity |
| PayBankBranchName | PaymentOutputFileDetail.PayBankEntity.BranchName |
| SwiftID | PaymentOutputFileDetail.SwiftID |
| InternationalBankAccountNumber | PaymentOutputFileDetail.InternationalBankAccountNumber |
| ChargeCode | PaymentOutputFileDetail.ChargeCode |
| BankToBankInformation | PaymentOutputFileDetail.BankToBankInformation |
| IntermediaryBankName | PaymentOutputFileDetail.IntermediaryBankName |
| IntermediaryBankPostalAddress | PaymentOutputFileDetail.IntermediaryBankPostalAddress |
| IntermediaryCrossBorderIdentifier | PaymentOutputFileDetail.IntermediaryCrossBorderIdentifier |
| IntermediaryBankEntity | PaymentOutputFileDetail.IntermediaryBankEntity |
| IntermediarySwiftID | PaymentOutputFileDetail.IntermediarySwiftID |
| LanguageCode | PaymentOutputFileDetail.LanguageCode |
| NormalOrExpressCode | PaymentOutputFileDetail.NormalOrExpressCode |
| InvoiceVendor | PaymentOutputFileDetail.InvoiceVendor |
| InvoiceVendorName | PaymentOutputFileDetail.InvoiceVendorName |
| InvoiceVendorEmailAddress | PaymentOutputFileDetail.InvoiceVendorEmailAddress |
| PaidVendor | PaymentOutputFileDetail.PaidVendor |
| Invoice | PaymentOutputFileDetail.Invoice |
| PaymentComment | PaymentOutputFileDetail.PaymentComment |
| TransactionData1 | TramentOutputFileDetail.TransactionData.DeliveryData.DataLine1 |
| TransactionData2 | TramentOutputFileDetail.TransactionData.DeliveryData.DataLine2 |
| TransactionData3 | TramentOutputFileDetail.TransactionData.DeliveryData.DataLine3 |
| TransactionData4 | TramentOutputFileDetail.TransactionData.DeliveryData.DataLine4 |
| PayBankAccountType | PaymentOutputFileDetail.PayBankAccountType |
| PayBankTypeDescription | PaymentOutputFileDetail.PayBankTypeDescription |
| TotalPaymentAmount | Total Payment Amount |
| TotalDiscountAmount | Total Discount Amount |
| TotalNetPaymentAmount | Total NetPayment Amount |
| CashManagementGroup | PaymentOutputFileDetail.CashManagementGroup |
| PaymentOutputFileHeader | PaymentOutputFileDetail.PaymentOutputFileHeader |
| Account | PaymentOutputFileDetail.CashManagementAccount |
| FractionalRoutingNumber | CashPaymentFormat.FractionalRoutingNumber |
| RoutingNumber | PaymentOutputFileDetail.RoutingNumber |
| CheckNumber | PaymentOutputFileDetail.TransactionNumber |
MICR line fields
/PayablesPayment
| XML field | Description |
|---|---|
| AuxOnUsField | Auxillary On-Us Field (full length including character spacing) E13B-10 font style not included |
| TransitField | Transit Field or Routing Number (full length including character spacing) E13B-10 font style not included |
| AccountOrOnUsField | Account Or On-Us Field (full length including character spacing) E13B-10 font style not included |
| EmailFrom | Email From for Check |
Always Attached Remittance Option or Remittance lines with Check
/PayablesPayment/RemittanceDetails/RemittanceDetail
| XML field | Description |
|---|---|
| Remittance | PaymentOutputFileRemittance |
| Company | Payables Company |
| CompanyName | Payables Company Name |
| InvoiceVendor | Invoice Vendor |
| InvoiceVendorName | Invoice Vendor Name |
| TransactionNumber | Transaction Number |
| BankClientIdentifier | Bank Client Identifier |
| CashLedgerTransactionIdentifier | Cash Ledger Transation Identifier |
| PaidVendor | Paid Vendor |
| Invoice | Invoice |
| InvoiceSuffix | Invoice Suffix |
| InvoiceDate | Invoice Date |
| NetPaymentAmount | Net Payment Amount |
| PaymentAmount | Payment Amount |
| DiscountAmount | Discount Amount |
| InvoiceCurrency | Invoice Currency |
| PurchaseOrder | Purchase Order |
| VoucherNumber | Voucher Number |
| ProcessLevel | Process Level |
| ReasonCode | Reason Code |
| ReasonCodeDescription | Reason Code Description |
| InvoiceDescription | Invoice Description |
| InvoiceComment | Invoice Comment |
| TransactionData1 | Transaction Data1 |
| TransactionData2 | Transaction Data2 |
| TransactionData3 | Transaction Data3 |
| TransactionData4 | Transaction Data4 |
Overflow or Separate Remittance Option
/PayablesPayment/OverFlowOrSeparateRemittanceDetails/OverFlowOrSeparateRemittanceDetail
| XML field | Description |
|---|---|
| Remittance | PaymentOutputFileRemittance |
| Company | Payables Company |
| CompanyName | Payables Company Name |
| InvoiceVendor | Invoice Vendor |
| InvoiceVendorName | Invoice Vendor Name |
| CheckNumber | Transaction Number |
| TransactionNumber | Transaction Number |
| BankClientIdentifier | Bank Client Identifier |
| CashLedgerTransactionIdentifier | Cash Ledger Transation Identifier |
| PaidVendor | Paid Vendor |
| Invoice | Invoice |
| InvoiceSuffix | Invoice Suffix |
| InvoiceDate | Invoice Date |
| NetPaymentAmount | Net Payment Amount |
| PaymentAmount | Payment Amount |
| DiscountAmount | Discount Amount |
| InvoiceCurrency | Invoice Currency |
| PurchaseOrder | Purchase Order |
| VoucherNumber | Voucher Number |
| ProcessLevel | Process Level |
| ReasonCode | Reason Code |
| ReasonCodeDescription | Reason Code Description |
| InvoiceDescription | Invoice Description |
| InvoiceComment | Invoice Comment |
| TransactionData1 | Transaction Data1 |
| TransactionData2 | Transaction Data2 |
| TransactionData3 | Transaction Data3 |
| TransactionData4 | Transaction Data4 |
| RemittanceEmailFrom | Email From for Separate Remittance |