CRM Form Table

CRM Form Data Table

Field name
Field Code
How filled
Purpose
Name NAME Contains generated name for payments plan element Nowhere is used
TN-Auftrag-ID DEAL A deal is generated for each CRM contact that is specified in the product field "Teilnehmer" when the product is saved, and the deal ID is inserted into this field Used in code to determine whether a deal and payment match
Datum der Zahlung über EPay Bayern PAID_DATE Filled in on successful payment. Contains the date of payment Nowhere is used
Kurs / Weiterbildungsangebot PRODUCT Contains the name of the product Used in PDF document
TN-ID CONTACT Contains the ID of the CRM contact from the product field "Teilnehmer" Used in code to determine whether a contact and payment match
Pk Nr. PK_NR Contains Pk Nr. from contact field "Pk Nr." Used in PDF document, displaying in payment form and for sending to EPay Bayern for paying
Rechnungsbetrag1 PAYMENT_SUM Calculated from the full cost of the product divided by the number of payment parts (product field "PRICE_PARTS") and rounded upward Used in payment, in PDF document, and for displaying in payment form (only if field SALE_SUM is empty)
Rechnungsbetrag2 SALE_SUM Calculated from the full cost of the product divided by the number of payment parts (product field "PRICE_PARTS") and rounded upward Used in payment, in PDF document, and for displaying in payment form
Datum Fälligkeit PAYMENT_DATE The data is taken from the product field "PAY_DATE" Used in PDF document
Payment Code PAYMENT_CODE Generated for each payment plan element when it is created Used to determine payment plan element when a person opens a link with this code
Link zur Zahlseite PAYMENT_LINK Generated for each payment plan element when it is created Used in PDF document and emails
Status 1 STATUS_1 Initially chosen as "active" Used in code to determine if payment plan element is active. If another value is selected, this element becomes inactive (user can't open link, document will not be generated, email will not be sent)
Status 2 STATUS_2 Initially chosen as "open" Used in code to determine if payment plan element is paid/not paid. After successful payment, value will be changed to "paid"
Kürzel ABBR The data is taken from the product field "ABBR_1" Used in PDF document
Kürzel 2 ABBR_2 The data is taken from the product field "ABBR_2" Used in PDF document
Part № PART_NUM Contains the current payment sequence number calculated based on the total number of payments, specified in the product field "PRICE_PARTS" Nowhere is used
Parts Total PARTS_TOTAL The data is taken from the product field "PRICE_PARTS" Nowhere is used
Parts Formatted PARTS_FORMATTED Contains a formatted string for the current payment sequence number (e.g. "1 von 5") Used in PDF document, displaying in payment form and in emails
Epay Document EPAY_DOCUMENT Contains the ID of the generated PDF document. Initially empty, document is generated only by clicking on the button "Generate PDF Document" on the payments plan page. Used in emails
Datum geplante Rechnungsstellung BILL_PLANNED_SEND_DATE Calculated from two product fields - "PAY_DATE" and "COUNT_DAYS_FOR_BILLS". The number of days specified in "COUNT_DAYS_FOR_BILLS" is subtracted from the date specified in the "PAY_DATE" field and saved here. Used in PDF document and in an agent that sends emails
Datum, an dem die Rechnung erstellt und per E-Mail versandt wurde BILL_ACTUAL_SEND_DATE Initially empty. Contains the date the email was actually sent. Used in code to determine if an email was already sent for every payment plan element.
Kostenträger KOSTENTRAEGER Contains the name of the product Nowhere is used
Address ADDRESS Contains the address from the "Rechnungsadresse" field from the deal. Used in PDF document
Course Responsible Name COURSE_RESPONSIBLE_NAME Contains the name of the Bitrix user filled in the "Verantwortliche Kurskoordination" product field Used in PDF document
Course Responsible Phone COURSE_RESPONSIBLE_PHONE Contains the phone number of the Bitrix user filled in the "Verantwortliche Kurskoordination" product field Used in PDF document
Course Responsible Email COURSE_RESPONSIBLE_EMAIL Contains the email of the Bitrix user filled in the "Verantwortliche Kurskoordination" product field Used in PDF document
Payer Number PAYER_NUMBER The data is taken from the product field "PAYER_NUMBER" Used in PDF document
Invoice Number INVOICE_NUMBER Generated for each payment plan element when it is created. The format is as follows:[Product_name]_[Contact last name]_[Contact name]_[Parts formatted]_[Pk Nr.] Used in PDF document, emails
Semester text SEMESTER_TEXT Contains the address from the "Semester text" field from the deal, that is in "Customer journey" pipeline and with the same contact as this payment plan element Used in PDF document
Document Type DOC_TYPE Contains the same value as the field "Document type" in product Used when generating PDF document and sending email
Wir verwenden Cookies
Cookie-Einstellungen
Unten finden Sie Informationen über die Zwecke, für welche wir und unsere Partner Cookies verwenden und Daten verarbeiten. Sie können Ihre Einstellungen der Datenverarbeitung ändern und/oder detaillierte Informationen dazu auf der Website unserer Partner finden.
Analytische Cookies Alle deaktivieren
Funktionelle Cookies
Andere Cookies
Wir verwenden Cookies, um die Inhalte und Werbung zu personalisieren, Funktionen sozialer Medien anzubieten und unseren Traffic zu analysieren. Mehr über unsere Cookie-Verwendung
Alle akzeptieren Alle ablehnen Einstellungen ändern
Cookies