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.