This appendix lists the XML fields and the source of the data that is extracted from the JD Edwards EnterpriseOne tables. Not all formats require all of the data. You set processing options for each payment format to determine the data to extract.
This table lists the XML fields and JD Edwards EnterpriseOne source:
XML Field | JD Edwards EnterpriseOne Source |
---|---|
InstructionGrouping/BankAccount/BankAccountNumber | Bank account number of the payer fromF04572.CBNK. |
InstructionGrouping/BankAccount/BankNumber | The first four digits of the G/L bank transitnumber from F0030.TNST.
Note: Only the Spanish EFT payment format uses this field. |
InstructionGrouping/BankAccount/BranchNumber | Digits 5 through 8 of the G/L bank transit number from F0030.TNST.
Note: Only the Spanish EFT payment format uses this field. |
InstructionGrouping/BankAccount/CheckDigits | G/L bank account control digit fromF0030.CHKD. |
InstructionGrouping/Payer/Address/AddressLine1 | Payer's address line 1 from F0116.ADD1.
This field includes information about the Company to which the payer account belongs; it might be different from the company that created the voucher. |
InstructionGrouping/Payer/Address/AddressLine2 | Payer's address line 2 from F0116.ADD2.
This field includes information about the Company to which the payer account belongs; it might be different from the company that created the voucher. |
InstructionGrouping/Payer/Address/AddressLine3 | Payer's address line 3 from F0116.ADD3.
This field includes information about the Company to which the payer account belongs; it might be different from the company that created the voucher. |
InstructionGrouping/Payer/Address/City | Payer's city from F0116.CTY1.
This field includes information about the Company to which the payer account belongs; it might be different from the company that created the voucher. |
InstructionGrouping/Payer/LegalEntityName | Payer's mailing name from F0111.MLNM. |
InstructionGrouping/Payer/LegalEntityRegistrationNumber | Company tax ID from F0101.TAX.
This is the tax ID for the company to which the payer account belongs. |
InstructionGrouping/PaymentDate | Date for G/L from F04572.DGJ. |
InstructionTotals/PaymentCount | The system sums the number of payments and writes the total to this field. |
OutboundPayment/BankAccount/BankAccountNumber | Payer's bank account number fromF04572.CBNK. |
OutboundPayment/BankAccount/BankAddress/AddressLine1 | G/L bank address line 1 from F0116.ADD1. |
OutboundPayment/BankAccount/BankAddress/City | G/L bank city from F0116.CTY1. |
OutboundPayment/BankAccount/BankAddress/Country | G/L bank country from F0116.CTR. |
OutboundPayment/BankAccount/BankAddress/PostalCode | G/L bank postal code from F0116.ADDZ. |
OutboundPayment/BankAccount/BankName | G/L bank mailing name from F0111.MLNM. |
OutboundPayment/BankAccount/BankNumber | G/L bank account transit number fromF0030.TNST. |
OutboundPayment/BankAccount/CheckDigits | G/L bank account control digit fromF0030.CHKD. |
OutboundPayment/BankAccount/IBANNumber | G/L bank account IBAN from F0030.IBAN. |
OutboundPayment/BankAccount/SwiftCode | G/L bank account SWIFT code fromF0030.SWFT. |
OutboundPayment/BankAccount/UserEnteredBankAccountNumber | Bank account number of the customer fromF04572.CBNK. |
OutboundPayment/DeliveryChannel/FormatValue | The system does not complete this field. |
OutboundPayment/DocumentPayable/DiscountTaken/Amount/Value | The discount amount from F04573.ADSA. |
OutboundPayment/DocumentPayable/DocumentDate | The date of the document from F04573.DIVJ. |
OutboundPayment/DocumentPayable/DocumentDescription | The remark from F04573.RMK. |
OutboundPayment/DocumentPayable/DocumentNumber/ReferenceNumber | The supplier invoice number fromF04573.VINV. |
OutboundPayment/DocumentPayable/PaymentAmount/Value | The payment amount from F04573.PAAP. |
OutboundPayment/DocumentPayable/PaymentDueDate | The discount due date from F04573.DDJ. |
OutboundPayment/Payee/Address/AddressLine1 | Address line 1 for payee from F0116.ADD1. |
OutboundPayment/Payee/Address/AddressLine2 | Address line 2 for payee from F0116.ADD2. |
OutboundPayment/Payee/Address/AddressLine3 | Address line 3 for payee from F0116.ADD3. |
OutboundPayment/Payee/Address/AddressName | The payee mailing name from F0111.MLNM. |
OutboundPayment/Payee/Address/City | City of the payee from F0116.CTY1. |
OutboundPayment/Payee/Address/Country | Country of the payee from F0116.CTR. |
OutboundPayment/Payee/Address/CountryName | The description of the country of the payee UDC 00/CN. |
OutboundPayment/Payee/Address/PostalCode | Payee postal code from F0116.ADDZ. |
OutboundPayment/Payee/Address/State | Payee state from F0116.ADDS. |
OutboundPayment/Payee/Name | Payee mailing name from F0111.MLNM. |
OutboundPayment/Payee/PartyNumber | Payee address number from F04572.PYE. |
OutboundPayment/Payee/TaxRegistrationNumber | Payee tax ID from F0101.TAX. |
OutboundPayment/PayeeBankAccount/BankAccountName | Payee mailing name from F0111.MLNM. |
OutboundPayment/PayeeBankAccount/BankAccountNumber | Bank account number for the customer from F04572.CBNK.
Note: The system uses a special validation routine for the Netherlands Domestic EFT payment format to strip out non-numerical values. |
OutboundPayment/PayeeBankAccount/BankAddress/City | Payee's bank city from F0111.CTY1. |
OutboundPayment/PayeeBankAccount/BankAddress/Country | Payee's bank county from F0030.CTR.
If no value exists for the country in the F0030 table, the system uses F0116.CTR. |
OutboundPayment/PayeeBankAccount/BankNumber | The first 4 characters of the value for the bank transit number from F04572.TNST. |
OutboundPayment/PayeeBankAccount/BranchNumber | Characters 5–8 of the value for the bank transit number from F04572.TNST. |
OutboundPayment/PayeeBankAccount/CheckDigits | Payee's bank control digit from F0030.CHKD. |
OutboundPayment/PayeeBankAccount/IBANNumber | Payee's bank IBAN from F0030.IBAN. |
OutboundPayment/PayeeBankAccount/SwiftCode | Payee's bank SWIFT code from F0030.SWFT. |
OutboundPayment/Payer/Address/AddressLine1 | Company address line 1 from F0116.ADD1. |
OutboundPayment/Payer/Address/AddressLine2 | Company address line 2 from F0116.ADD2. |
OutboundPayment/Payer/Address/City | Company's city from F0116.CTY1. |
OutboundPayment/Payer/Address/Country | Company's country from F0116.CTR. |
OutboundPayment/Payer/Address/PostalCode | Company's postal code from F0116.ADDZ. |
OutboundPayment/Payer/LegalEntityRegistrationNumber | Company tax ID from F0101.TAX. |
OutboundPayment/Payer/Name | Company mailing name from F0111.MLNM. |
OutboundPayment/PaymentAmount/Currency/Code | Currency code from the payment. If the currency code exists in the UDC 70/CC, then this field includes the cross-reference from the Description 01 field of the UDC.
For SEPA payments, the currency code must be EUR (euro). |
OutboundPayment/PaymentAmount/Value | The amount of the payment from F04572.PAAP.
The amount must be 0.01 or more, up to999999999.99. |
OutboundPayment/PaymentAmountText | The payment amount in text.
The system uses the conversion program that you specify in the processing options. |
OutboundPayment/PaymentDate | The date of the payment from F04373.DGJ. |
OutboundPayment/PaymentDetails | The supplier invoice number from F04573.VINV.
The system fills the remaining characters with blanks. |
OutboundPayment/PaymentMethod/PaymentMethodFormatValue | Hard-coded value of TRF. |
OutboundPayment/PaymentNumber/CheckNumber | The check number from F04571.SNG. |
OutboundPayment/PaymentNumber/LogicalGroupReference | The next number in the numbering scheme for the type of payment. |
OutboundPayment/PaymentNumber/PaymentReferenceNumber | A value that is the concatenation of the company number, account bank, and next number as set up for system 70, line 1. |
OutboundPayment/PaymentReason/Code | The system does not complete this field. |
OutboundPayment/PaymentStatus/Code | If a single stub check, the text VOID_BY_SETUP. If a multi-stub check, the text VOID_BY_OVERFLOW. For all other instances, the system leaves this field blank. |
PaymentInstructionInfo/InstructionCreationDate | The system generated date and time stamp. |
PaymentInstructionInfo/InstructionReferenceNumber | The next number from the numbering scheme set up in line 1 for system 70 in the Next Numbers program (P0002). |
PaymentProcessProfile/BatchBookingFlag | The system completes this field with N (nosummarization). |
PaymentProcessProfile/LogicalGroupingMode | A hard-coded value of SNGL. |