XML Fields and JD Edwards EnterpriseOne Source

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.