Output Data

This section describes output data for English relation references.

Relation Reference Content Relation Field
#VARIABLE #TIME Currenttime
#TODAYSDATE Currentdate
#DAYNUMBER Day number of the year
1..10 The value in variable 1..10
#PAYMENTAGENT #ADDRESS1 PaymentAgent.Address1
#ADDRESS2 PaymentAgent.Address2
#ADDRESS3 PaymentAgent.Address3
#ADDRESS4 PaymentAgent.Address4
#OURCONTACTPERSON PaymentAgent.OurContactPerson
#OURTELEPHONE PaymentAgent.OurTelephone
#YOURCONTACTPERSON PaymentAgent.YourContactPerson
#YOURTELEPHONE PaymentAgent.YourTelephone
#OUTGOINGPAYMENTFORM #COMBINEDPAYMENT OutgoingPaymentForm.AllowJointPayment
#CURRENCYPAYMENT OutgoingPaymentForm.CurrencyPayment
#CUSTOMERPAYMENTFORM #CURRENCYPAYMENT CustPaymentFormInfor.CurrencyCollection
#BLANKETPAYMENT CustPaymentFormInfor.AllowJointCollection
#COMPANYINFORMATION

(see Note A below)

#ADDRESS1..8 Address line 1..8 for the company based on the country-specific address format

(see Note B below)

#ADDRESS2 CompanyInformation.Name2
#ADDRESS3 CompanyInformation.Name3
#ADDRESS4 CompanyInformation.PostalCode
#ADDRESS5 CompanyInformation.PostalDistrict
#ADDRESS6 CompanyInformation.Name4
#ADDRESS7 CompanyInformation.Name5
#PAYMENTSERVICENUMBER CompanyInformation.PaymentServiceNumber
#BANK CompanyInformation.Bank
#BLOCKED CompanyInformation.IsBlocked
#COMPANYNUMBER CompanyInformation.CompanyNumber
#COMPANYREGISTRATIONNUMBER CompanyInformation.CompanyRegistrationNumber
#COUNTRY ISO Code for CompanyInformation.Country
#CURRENCY CompanyInformation.Currency
#TELEFAX CompanyInformation.Telefax
#GIRO CompanyInformation.Giro
#NAME1 CompanyInformation.Name1
#NAME2 CompanyInformation.Name2
#NAME3 CompanyInformation.Name3
#NAME4 CompanyInformation.Name4
#NAME5 CompanyInformation.Name5
#ZIPCODE CompanyInformation.PostalCode
#POSTALDISTRICT CompanyInformation.PostalDistrict
#TELEPHONE CompanyInformation.Telephone
#REMARK1 CompanyInformation.Note1
#REMARK2 CompanyInformation.Note2
#REMARK3 CompanyInformation.Note3
#REMARK4 CompanyInformation.Note4
#REMARK5 CompanyInformation.Note5
#STATISTICS1 CompanyInformation.Statistic1
#STATISTICS2 CompanyInformation.Statistic2
#STATISTICS3 CompanyInformation.Statistic3
#STATISTICS4 CompanyInformation.Statistic4
#VATNUMBER CompanyInformation.VATNumber
#TELEX CompanyInformation.Telex
#TEXT1..20 CompanyInformation.Text1..20
#DATE1..5 CompanyInformation.Date1..5
#INTEGER1..5 CompanyInformation.Integer1..5
#REAL1..5 CompanyInformation.Real1..5
#POPUP1..5 CompanyInformation.Popup1..5
#BOOLEAN1..5 CompanyInformation.Boolean1..5
#VENDOR #ADDRESS1

(see Note B below)

Address line 1..8 for the company based on the country-specific address format
#ADDRESS2 Address line 1..8 for the company based on the country-specific address format
#ADDRESS3 Address line 1..8 for the company based on the country-specific address format
#ADDRESS4 Address line 1..8 for the company based on the country-specific address format
#ADDRESS5 Address line 1..8 for the company based on the country-specific address format
#ADDRESS6 Address line 1..8 for the company based on the country-specific address format
#ADDRESS7 Address line 1..8 for the company based on the country-specific address format
#ADDRESS8 Address line 1..8 for the company based on the country-specific address format
#ATTENTION CompanyVendor.Attention
#PAYMENTSERVICENUMBER CompanyVendor.BankPaymen tServiceNumber
#TOTALBASE CompanyVendor.DebitBalanceBase - CompanyVendor.CreditBalanceBase
#TOTALCURRENCY CompanyVendor.DebitBalanceStandard - CompanyVendor.CreditBalanceStandar
#BANKACCOUNT CompanyVendor.BankAccount
#BANKADDRESS1 CompanyVendor.BankAddress1
#BANKADDRESS2 CompanyVendor.BankAddress2
#BANKADDRESS3 CompanyVendor.BankAddress3
#BANKADDRESS4 CompanyVendor.BankAddress4
#COMPANYREGISTRATIONNUMBER CompanyVendor.CompanyRegistrationNumber
#BANKREGISTRATIONNO. CompanyVendor.BankRegistrationNumb
#POSTALDISTRICT CompanyVendor.PostalDistrict
#BLANKETACCOUNT CompanyVendor.ControlAccountCode
#COUNTRY ISO Code for CompanyVendor.Country
#CURRENCY CompanyVendor.Currency
#DEPARTMENT CompanyVendor.DepartmentNumber
#ENTITYNAME CompanyVendor.EntityName
#TELEFAX CompanyVendor.Telefax
#CPCNUMBER CompanyVendor.CPCNumber
#GIRO CompanyVendor.Giro
#LANGUAGE CompanyVendor.Language
#LOCATIONNAME CompanyVendor.LocationName
#NAME1 CompanyVendor.Name1
#NAME2 CompanyVendor.Name2
#NAME3 CompanyVendor.Name3
#NAME4 CompanyVendor.Name4
#NAME5 CompanyVendor.Name5
#OURCUSTOMERNUMBER CompanyVendor.OurCustomerNumber
#OURREFERENCE CompanyVendor.OurReference
#PAYMENTMODE CompanyVendor.PaymentMode
#PAYMENTVENDOR CompanyVendor.PaymentCreditor
#TELEPHONE CompanyVendor.Telephone
#PROJECTNAME CompanyVendor.ProjectName
#RESPONSIBLE CompanyVendor.Responsible
#STANDARDCARDTYPECODE CompanyVendor.StandardCardTypeCode
#STANDARDPAYERDENTIFICATION CompanyVendor.StandardPayerIdentification
#STATISTICS1 CompanyVendor.Statistic1
#STATISTICS2 CompanyVendor.Statistic2
#STATISTICS3 CompanyVendor.Statistic3
#STATISTICS4 CompanyVendor.Statistic4
#STOPPAYMENT CompanyVendor.StopPayment
#SWIFTCODE CompanyVendor.SWIFTCode
#VAT CompanyVendor.VAT
#VATNUMBER CompanyVendor.VATNumber
#TELEX CompanyVendor.Telex
#SUPPLIERGROUP CompanyVendor.SupplierGroup
#YOURREFERENCE CompanyVendor.YourReference
#ZIPCODE CompanyVendor.PostalCode
#CUSTOMER #ADDRESS1

(see Note B below)

Address line 1..8 for the company based on the country-specific address format
#ADDRESS2

(see Note B below)

Address line 1..8 for the company based on the country-specific address format
#ADDRESS3

(see Note B below)

Address line 1..8 for the company based on the country-specific address format
#ADDRESS4

(see Note B below)

Address line 1..8 for the company based on the country-specific address format
#ADDRESS5

(see Note B below)

Address line 1..8 for the company based on the country-specific address format
#ADDRESS6

(see Note B below)

Address line 1..8 for the company based on the country-specific address format
#ADDRESS7

(see Note B below)

Address line 1..8 for the company based on the country-specific address format
#ADDRESS8

(see Note B below)

Address line 1..8 for the company based on the country-specific address format
#AGREEMENTNUMBER CompanyCustomer.CollectionAgreementN
#ATTENTION CompanyCustomer.Attention
#TOTALBASE CompanyCustomer.DebitBalanceBase - CompanyCustomer.CreditBalanceBase
#TOTALCURRENCY CompanyCustomer.DebitBalanceStandard - CompanyCustomer.CreditBalanceStandard
#ACTIVESTATUS CompanyCustomer.ActiveStatus
#CITY CompanyCustomer.PostalDistrict
#COLLECTIONGROUP CompanyCustomer.CollectionGroupNumbe
#CONTACTPERSON CompanyCustomer.ContactPerson
#CONTROLACCOUNT CompanyCustomer.BlanketAccountCode
#COUNTRY CompanyCustomer.Country
#CREDITMAX CompanyCustomer.CreditMax
#CURRENCY CompanyCustomer.Currency
#CUSTOMERGROUP CompanyCustomer.CustomerGroup
#DEPARTMENT CompanyCustomer.DepartmentNumber
#ENTITYNAME CompanyCustomer.EntityName
#TELEX CompanyCustomer.Telex
#GIRO CompanyCustomer.Giro
#INTERESTCHARGEREMINDERPRINCIPLE CompanyCustomer.InterestReminderPrinciple
#LANGUAGE CompanyCustomer.Language
#LOCATIONNAME CompanyCustomer.LocationName
#NAME1 CompanyCustomer.Name1
#NAME2 CompanyCustomer.Name2
#NAME3 CompanyCustomer.Name3
#NAME4 CompanyCustomer.Name4
#NAME5 CompanyCustomer.Name5
#ORDERVOLUME CompanyCustomer.OrderBook
#PAYMENTCUSTOMER CompanyCustomer.PaymentCustomer
#TELEPHONE CompanyCustomer.Telephone
#PROJECTNAME CompanyCustomer.ProjectName
#REMINDERLEVEL CompanyCustomer.ReminderLevel
#REMINDERS CompanyCustomer.SendReminder
#SALESEMPLOYEENUMBER CompanyCustomer.SalesPersonNumber
#STATISTICS1 CompanyCustomer.Statistic1
#STATISTICS2 CompanyCustomer.Statistic2
#STATISTICS3 CompanyCustomer.Statistic3
#STATISTICS4 CompanyCustomer.Statistic4
#TELETAX CompanyCustomer.VAT
#TAXNUMBER CompanyCustomer.VATNumber
#TELEX CompanyCustomer.Telex
#ZIPCODE CompanyCustomer.PostalCode
#PAYMENTMODE #ACCOUNTNUMBER ExternalAccount.BankAccountNumber
#REGISTRATIONNUMBER ExternalAccount.BankRegistrationNumber
#DESCRIPTION ExternalAccount.Description
#IBANACCOUNTNUMBER ExternalAccount.IbanAccountNumber
#SWIFTCODE ExternalAccount.SwiftCode
#TEXT1..3 ExternalAccount.Text1..3
#CHARACTERSPERLINE PaymentMode.NumberOfCharactersPerLine
#ALLOWPASSEDPAYMENTDATES PaymentMode.AllowPassedPaymentDates
#BLANKETPAYMENT PaymentMode.JointPayment
#FIELD1 PaymentMode.PaymentField1
#FIELD2 PaymentMode.PaymentField2
#FIELD3 PaymentMode.PaymentField3
#FIELD4 PaymentMode.PaymentField4
#FIELD5 PaymentMode.PaymentField5
#FIELD6 PaymentMode.PaymentField6
#FIELD7 PaymentMode.PaymentField7
#FIELD8 PaymentMode.PaymentField8
#FIELD9 PaymentMode.PaymentField9
#FIELD10 PaymentMode.PaymentField10
# MOREREMITTANCES PaymentMode.MoreRemittancesPerLine
#REMITTANCE PaymentMode.CreateReceiptLines
#REMITTANCETEXT1 PaymentMode.RemittanceText1
#REMITTANCETEXT2 PaymentMode.RemittanceText2
#REMITTANCETEXT3 PaymentMode.RemittanceText3
#REMITTANCETEXT4 PaymentMode.RemittanceText4
#CUSTOMERPAYMENTMODE #ACCOUNTNUMBER ExternalAccount.BankAccountNumbe
#REGISTRATIONNUMBER ExternalAccount.BankRegistrationNumb
#DESCRIPTION ExternalAccount.Description
#IBANACCOUNTNUMBER ExternalAccount.IbanAccountNumber
#SWIFTCODE ExternalAccount.SwiftCode
#TEXT1..3 ExternalAccount.Text1..3
#CHARACTERSPERLINE CustomerPaymentMode.NumberOfCharsPerLine
#INCLUDEHEADINGS CustomerPaymentMode.IncludeHeadings
#BLANKETCOLLECTION CustomerPaymentMode.JointCollection
#MOREREMITTANCES CustomerPaymentMode.MoreRemittancesPerLi
#REMITTANCE CustomerPaymentMode.NotifyConsignee
#REMITTANCETEXT1 CustomerPaymentMode.RemittanceField1
#REMITTANCETEXT2 CustomerPaymentMode.RemittanceField2
#REMITTANCETEXT3 CustomerPaymentMode.RemittanceField3
#REMITTANCETEXT4 CustomerPaymentMode.RemittanceField4
#FIELD1..10 CustomerPaymentMode.PaymentField1..10
#PAYMENT #AMOUNT OutputDataHeader.AmountTotal
#AMOUNTENTRIES OutputDataHeader.NumberOfAmountEntrie
#PAYMENTAGENT OutputDataHeader.PaymentAgent
#PAYMENTNUMBER OutputDataHeader.AutomaticPaymentNumber
#PRODUCTIONDATE OutputDataHeader.ProductionDate
#SECURITYCODE1 Security code 1 can be specified when you create the payment file.
#SECURITYCODE2 Security code 2 can be specified when you create the payment file.
#SYSTEMNUMBER1 OutputDataHeader.SystemNumber1
#SYSTEMNUMBER2 OutputDataHeader.SystemNumber2
#SYSTEMNUMBER3 OutputDataHeader.SystemNumber3
#ENTRIESINTOTAL OutputDataHeader.TotalNumberOfEntries
#ACCOUNTNUMBERTOTAL OutputDataHeader.AccountNumberSum
#PAYMENTGROUP #AMOUNT PaymentGroup.GroupTotalAmount
#AMOUNTENTRIES PaymentGroup.GroupNumberAmountEntries
#GROUPING1 PaymentGroup.Grouping1
#GROUPING2 PaymentGroup.Grouping2
#GROUPING3 PaymentGroup.Grouping3
#ENTRIESINTOTAL PaymentGroup.GroupTotalNumberEntries
#PAYMENTLINE #BANKACCOUNTNUMBER OutputDataLine.BankAccount
#BANKREGISTRATIONNO OutputDataLine.BankRegistrationNo.
#CARDTYPECODE OutputDataLine.CardTypeCode
#CPCNUMBER OutputDataLine.CPCNumber
#CURRENCY OutputDataLine.Currency
#CUSTOMERNUMBER OutputDataLine.CustomerNumber
#DISCOUNTBASE OutputDataLine.DiscountBase
#DISCOUNTCURRENCY OutputDataLine.DiscountCurrency
#DISCOUNTENTERPRISE OutputDataLine.DiscountEnterprise
#EXTERNALACCOUNTNUMBER OutputDataLine.ExternalAccountNumber
#EXTERNALREGISTRATIO NNUMBER OutputDataLine.ExternalRegistrationNumber
#GIRO OutputDataLine.Giro
#IMPORTDATE OutputDataLine.EntranceDate
#LINENUMBER OutputDataLine.LineNumber
#NUMBEROFREMITTANCES OutputDataLine.LastRemittanceLineNu
#OUTPUTDATAIDENTIFIC ATION OutputDataLine.OutputDataIdentifica
#REMARK OutputDataLine.Remark
#PAYERIDENTIFICATION OutputDataLine.PayerIdentification
#PAYMENTCURRENCY OutputDataLine.PaymentCurrency
#PAYMENTENTERPRISE OutputDataLine.PaymentEnterprise
#PAYMENTBASE OutputDataLine.PaymentBase
#PAYMENTDATE OutputDataLine.PaymentDate

(see Note F below)

#PAYMENTDESCRIPTION OutputDataLine.PaymentDescription
#PAYMENTSERVICENUMBER OutputDataLine.PaymentServiceNumber
#NUMBEROFRECONCILIATIONS OutputDataLine.NumberOfReconciliations
#TRANSACTIONNUMBER OutputDataLine.TransactionSystemNum
#VENDORACCOUNTNUMBER OutputDataLine.VendorAccountNumbe
#VENDORNUMBER OutputDataLine.VendorNumber
#TEXT1..5 OutputDataLine.Text1..5
#BOOLEAN1..5 OutputDataLine.Boolean1..5
  • Note A: You can specify different companies in this field, corresponding to the following references:
    • #COMPANYINFORMATION = Standard Company
    • #USERCOMPANY = UserInformation.EmployeeCompanyNumber
    • #VENDORCOMPANY = CompanyVendor.SettlingCompany
    • #CUSTOMERCOMPANY = CompanyCustomer.SettlingCompany
    • #COUNTRYOFORIGIN = OutputDataLine.CompanyOfOrigin
  • Note B: Address information is formatted according to the format defined for the current country.
  • Note C: The content of the remittance field on the payment mode is user-selectable. The following options exist:
    • TransactionNumber= VendorEntry.TransactionNumber
    • Invoice No.= VendorEntry.InvoiceNumber
    • Entry Description= VendorEntry.TextOfEntry
    • Entry Date= VendorEntry.DateOfEntry
    • Invoice Date= VendorEntry.InvoiceDate
    • Due Date = VendorEntry.DueDate
    • Paid in currency - The user can select Paid in currency and the calculation will depend on the type (invoice or credit memo).
      • Invoice= PaymentOutputDataReconciliation.ReconciliationCurrency – PaymentOutputDataReconciliation.DiscountCurrency
      • Credit Memo= - PaymentOutputDataReconciliation.ReconciliationCurrency + PaymentOutputDataReconciliation.DiscountCurrency
    • Paid in base - The user can select Paid in base and the calculation will depend on the type (invoice or credit memo).
      • Invoice = PaymentOutputDataReconciliation.ReconciliationBase – PaymentOutputDataReconciliation.DiscountBase
      • Credit Memo = - PaymentOutputDataReconciliation.ReconciliationBase + PaymentOutputDataReconciliation.DiscountBase
    • Discount in currency = PaymentOutputDataReconciliation.DiscountCurrency
    • Discount in base = PaymentOutputDataReconciliation.DiscountBase
    • Vendor No. = VendorEntry.CreditorNumber
    • Payment Description = VendorEntry.PaymentDescription
    • Card Type Code = VendorEntry.CardTypeCode
    • Payer ID = VendorEntry.PayerIdentification
    • Amount in currency = VendorEntry.CreditCurrency - VendorEntry.DebitCurrency
    • Amount in Base Currency = VendorEntry.CreditBase - VendorEntry.DebitBase
    • Payment Currency = VendorEntry.EntryCurrency
    • Original Amount = VendorEntry.OriginalAmount
    • Original Currency = VendorEntry.OriginalCurrency
    • Company of Origin Number = VendorEntry.CompanyOfOrigin
    • Phone Number, Company of Origin = Phone no. for VendorEntry.CompanyOfOrigin
    • Original Currency = VendorEntry.OriginalCurrency
    • Name1-5 = CompanyVendor.Name1-5 (five fields)
  • Note D: The content of the remittance field on the customer payment mode is user-selectable. The following options exist:
    • Entry Date = CustomerEntry.DateOfEntry
    • Due Date = CustomerEntry.DueDate
    • Entry Description = CustomerEntry.EntryText
    • Transaction Number = CustomerEntry.VoucherNumber
    • Collected in currency - The user can select Collected in currency and the calculation will depend on the type (invoice or credit memo).
      • Invoice = PaymentOutputDataReconciliation.ReconciliationCurren
      • Credit Memo = - PaymentOutputDataReconciliation.ReconciliationCurren
    • Collected in base - The user can select Collected in base and the calculation will depend on the type (invoice or credit memo).
      • Invoice = PaymentOutputDataReconciliation.ReconciliationBase
      • Credit Memo = -PaymentOutputDataReconciliation.ReconciliationBase
    • Original Currency = CustomerEntry.OriginalCurrency
    • Original Amount = CustomerEntry.OriginalAmount
    • Interest Sum in Currency = CustomerEntry.InterestSum
    • Interest Date = CustomerEntry.InterestDate
    • Payer ID = CustomerEntry.PayerIdentification
    • Interest Sum for Reminder = CustomerEntry.ReminderInterestSum
    • Job Number = CustomerEntry.JobNumber
  • Note E: The values for “SecurityCode1” and “SecurityCode2” are specified in the Payment Files window in the Banking module.
  • Note F: If "PaymentLine.PaymentDate" occurs before the current date and your system does not allow payment dates earlier than the current date, the database will use the date today.

    If the Allow Passed Payment Dates checkbox is selected in the Payment Modes single dialog, the database will allow payment dates in the past.