Complete reference of every table, table extension, and field shipped by Ventoo Pingen Connector.
PingenSetupVTO
Stores the global configuration. Holds exactly one record (Primary Key = 1).
|
Field |
Type |
Description |
|---|---|---|
|
Primary Key |
Integer |
Primary key. Always |
|
Client ID |
Text[250] |
Client ID from the Pingen Developer App. |
|
Organisation ID |
Text[100] |
Pingen Organisation ID. |
|
Send Days Delay |
Integer |
Delay in days after the posting date. Default: |
|
Document Sending Profile Code |
Code[20] |
Profile code that qualifies a customer for automatic dispatch. Table relation: Document Sending Profile.Code. |
|
Address Position |
Enum (PingenAddressPositionVTO) |
Address window position. Default: |
|
Delivery Product |
Enum (PingenDeliveryProductVTO) |
Postal product. Default: |
|
Print Mode |
Enum (PingenPrintModeVTO) |
Print mode. Default: |
|
Print Spectrum |
Enum (PingenPrintSpectrumVTO) |
Color mode. Default: |
|
Enable for Sales Quotes |
Boolean |
Enables the Send via Pingen action on Sales Quotes. |
|
Enable for Sales Orders |
Boolean |
Enables the Send via Pingen action on Sales Orders. |
|
Enable for Posted Invoices |
Boolean |
Enables job queue + manual dispatch for posted invoices. Default: enabled. |
|
Enable for Posted Credit Memos |
Boolean |
Enables the Send via Pingen action on Posted Sales Credit Memos. |
|
Invoice Report ID |
Integer |
Report ID for posted invoice PDFs. Default: |
|
Quote Report ID |
Integer |
Report ID for sales quote PDFs. Default: |
|
Order Report ID |
Integer |
Report ID for sales order PDFs. Default: |
|
Credit Memo Report ID |
Integer |
Report ID for credit memo PDFs. Default: |
Note on the Client Secret: The Client Secret is not a table field. It's stored encrypted in the Business Central Isolated Storage (module scope). Access goes through the SetClientSecret, GetClientSecret, and HasClientSecret procedures on the table.
Table extensions
The connector extends three standard document tables with status fields.
Sales Header (Sales Quotes and Sales Orders)
|
Field |
Field ID |
Type |
Description |
|---|---|---|---|
|
Processed |
70679750 |
Boolean |
True once the document has been submitted to Pingen or manually disabled. Documents with this flag are skipped by the job queue. |
|
Sent via Pingen at |
70679751 |
DateTime |
Timestamp of successful dispatch. Cleared when the document is re-enabled. |
Sales Invoice Header (Posted Sales Invoices)
|
Field |
Field ID |
Type |
Description |
|---|---|---|---|
|
Processed |
70679750 |
Boolean |
True once the invoice has been submitted to Pingen or manually disabled. |
|
Sent via Pingen at |
70679751 |
DateTime |
Timestamp of successful dispatch. |
|
Pingen Auto-Send |
70679752 |
Boolean |
Set automatically at posting time if the bill-to customer had the configured Document Sending Profile at that moment. The job queue filters on this flag (not the current customer profile), so later profile changes don't retroactively dispatch older invoices. Hidden from the page layout by default — add it via Personalize if needed. |
Sales Cr.Memo Header (Posted Sales Credit Memos)
|
Field |
Field ID |
Type |
Description |
|---|---|---|---|
|
Processed |
70679750 |
Boolean |
True once the credit memo has been submitted to Pingen or manually disabled. |
|
Sent via Pingen at |
70679751 |
DateTime |
Timestamp of successful dispatch. |
Note: Processed and Sent via Pingen at are displayed on each supported document in the Pingen fast-tab group. Sent via Pingen at is read-only.
Related
-
Permissions
-
Enumerations
-
General Setup