Current payables and vendor dossier — Pro
Current retained item balances and due dates; complete context and separate current vendor.
NOT VALIDATED ON A REAL ERP INSTALLATION. Unofficial configuration based on Sage 100 US 2026 FLOR Rel 7.50 own open-item layouts, complete logical keys, public functional help and synthetic validation. Verify installed schema, currency, NULL, roles, date adapters, padding, collation, least-privilege SELECT permissions and query cost at import. Not a real Sage SQL Server test.
Inspect current retained supplier open items, native item balances, due/discount/posting dates, invoice amount, paid-today and hold context. Open the separately identified current vendor dossier.
Why Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.
Pro: one source, 2 lists, 1 lazy dossier buttons, parameterized read-only SELECT and at most 2,000 rows per request. No scheduled refresh. No implicit Last 7 days or Balance<>0 filter: old debts, retained zero-balance rows and unrecognized dates remain available. Oldest due dates sort first with a complete-identity tie break; NULL dates can sort ahead of dated rows. Local Search, Filters and sorting affect loaded rows only, not the entire source. A 2,000-row limit hit means the list may be incomplete; adapt source-side filtering before relying on totals. No fabricated aggregate total or full-catalog claim.
CURRENT native open-item records, not a historical closing balance, a reconstructed aging report or a complete payment ledger. Invoice/due-date filtering selects current retained records; it does not show the balance as of the selected date. Retention, purges and balance-forward accounting options affect availability. Source changes between reads are not a transaction-consistent snapshot. A missing row or master is not evidence of no debt or a zero balance.
Balance, original invoice/tax/freight components, payments today, discount and retention are separate native values. NULL remains NULL, never zero. No general paid/unpaid status, source currency code, USD assumption, universal debit/credit sign normalization or reconstructed amount due. Monetary labels refer to source currency; verify its meaning in your company setup.
AP PaidToday is a native Y/N context flag, not a general paid status. Open-item HoldPayment and current vendor payment selection hold are separate. AP_OpenInvoice has no InvoiceType projection here: no AR legend is borrowed. Full identity is APDivisionNo + VendorNo + InvoiceNo.
Master contacts, payment terms, balances and last payment values are CURRENT, separately labeled from this individual open item. InvoiceHistoryHeaderSeqNo is kept internally but does not certify a history or line linkage; no partial invoice-number join is provided. Technical keys are hidden. Exact binary Unicode and byte-length comparisons preserve complete strings, but installed physical types, padding, collation and performance still require validation. SQL Server 2012+/compatibility 110+ is required for defensive date conversion; invalid or unsupported dates become NULL, not 1900, with interpretation labels.
No source credentials, server addresses, cached business rows, banking/check/taxpayer data or audit-user identifiers in the package. DEMO captures must be wholly fictional. Public layouts prove selected logical names and keys, not installed DDL/indexes or speed. Native ERP operator permissions do not carry into direct SQL: separately authorized least-privilege SELECT is required. Unofficial, not endorsed by Sage; not France, Contractor or ProvideX.
Own open-item layout: https://help-sage100.na.sage.com/2026/FLOR/Content/File_Layouts/Accounts_Payable/AP_OpenInvoice.htm
Own master layout: https://help-sage100.na.sage.com/2026/FLOR/Content/File_Layouts/Accounts_Payable/AP_Vendor.htm
Screenshots
What this package creates
1 Home1 Details2 lists1 sources to map
- Home: Current payables
- Details: Current vendor dossier
- Sub-button: Current vendor dossier
Sources are mapped locally and verified before applying.
Custom queriesPRO2 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT o.APDivisionNo, o.VendorNo, o.InvoiceNo, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),8) ELSE NULL END,112) AS InvoiceDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),8) ELSE NULL END,112) AS InvoiceDueDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))),8) ELSE NULL END,112) AS InvoiceDiscountDate, o.InvoiceHistoryHeaderSeqNo, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))),8) ELSE NULL END,112) AS PostingDate, o.TermsCode, o.HoldPayment, o.Comment, o.JobNo, o.PaidToday, o.InvoiceAmt, o.DiscountAmt, o.RetentionCost, o.Balance, o.TaxableAmt, o.NonTaxableAmt, o.FreightAmt, o.TaxAmt, o.NonRecoverableAmt, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), o.APDivisionNo)),N':',CONVERT(nvarchar(4000), o.APDivisionNo),N'|',DATALENGTH(CONVERT(nvarchar(4000), o.VendorNo)),N':',CONVERT(nvarchar(4000), o.VendorNo),N'|',DATALENGTH(CONVERT(nvarchar(4000), o.InvoiceNo)),N':',CONVERT(nvarchar(4000), o.InvoiceNo),N'|') AS OpenItemKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), o.APDivisionNo)),N':',CONVERT(nvarchar(4000), o.APDivisionNo),N'|',DATALENGTH(CONVERT(nvarchar(4000), o.VendorNo)),N':',CONVERT(nvarchar(4000), o.VendorNo),N'|') AS AccountKey, COALESCE(NULLIF(m.VendorName,N''),o.VendorNo) AS PartyDisplayName, CASE WHEN m.VendorNo IS NULL THEN N'Missing: verify source integrity' ELSE N'Available' END AS PartyAvailability, CASE WHEN o.InvoiceDate IS NULL THEN N'Missing source date' WHEN TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),8) ELSE NULL END,112) IS NULL THEN N'Unrecognized source date / convention' ELSE N'Readable source date' END AS InvoiceDateReadState, CASE WHEN o.InvoiceDueDate IS NULL THEN N'Missing source date' WHEN TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),8) ELSE NULL END,112) IS NULL THEN N'Unrecognized source date / convention' ELSE N'Readable source date' END AS DueDateReadState FROM dbo.AP_OpenInvoice o LEFT JOIN dbo.AP_Vendor m ON (CONVERT(nvarchar(4000), o.APDivisionNo) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.APDivisionNo) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), o.APDivisionNo))=DATALENGTH(CONVERT(nvarchar(4000), m.APDivisionNo))) AND (CONVERT(nvarchar(4000), o.VendorNo) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.VendorNo) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), o.VendorNo))=DATALENGTH(CONVERT(nvarchar(4000), m.VendorNo))) WHERE o.APDivisionNo IS NOT NULL AND o.VendorNo IS NOT NULL AND o.InvoiceNo IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT m.APDivisionNo, m.VendorNo, m.VendorName, m.AddressLine1, m.AddressLine2, m.AddressLine3, m.City, m.State, m.ZipCode, m.CountryCode, m.PrimaryContact, m.TelephoneNo, m.TelephoneExt, m.EmailAddress, m.TermsCode, m.Reference, m.HoldPayment, m.Comment, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))),8) ELSE NULL END,112) AS LastPurchaseDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))),8) ELSE NULL END,112) AS LastPaymentDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))),8) ELSE NULL END,112) AS DateEstablished, m.AverageDaysToPay, m.AverageDaysOverDue, m.BalanceDue, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), m.APDivisionNo)),N':',CONVERT(nvarchar(4000), m.APDivisionNo),N'|',DATALENGTH(CONVERT(nvarchar(4000), m.VendorNo)),N':',CONVERT(nvarchar(4000), m.VendorNo),N'|') AS AccountKey, CASE m.VendorStatus WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'T' THEN N'Temporary' ELSE CONCAT(N'Unknown / unset: ', m.VendorStatus) END AS VendorState FROM dbo.AP_Vendor m WHERE (CONVERT(nvarchar(4000), m.APDivisionNo) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :division) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), m.APDivisionNo))=DATALENGTH(CONVERT(nvarchar(4000), :division))) AND (CONVERT(nvarchar(4000), m.VendorNo) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :party) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), m.VendorNo))=DATALENGTH(CONVERT(nvarchar(4000), :party)))
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 100 US — SQL Server company database",
"id": "DE7F91E1-A49C-52E3-833C-A89E8A10B3E8",
"kind": "sqlServer",
"requiredObjects": [
"dbo.AP_Vendor",
"dbo.AP_OpenInvoice"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "FB11735C-3787-5AA4-90B5-0E7CED9BA057",
"key": "InvoiceDueDate",
"type": "date"
},
{
"direction": "ascending",
"id": "B964634B-49A9-5A8F-BDF3-CFF9848AE88D",
"key": "OpenItemKey",
"type": "text"
}
],
"id": "246EE7E0-96F4-53BA-A292-D3E10BF0754B",
"integration": "Sage 100 US",
"mappings": [
{
"commonFieldKey": "",
"key": "APDivisionNo",
"label": "Internal vendor division",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "APDivisionNo",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorNo",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VendorNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceNo",
"label": "Invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceDate",
"label": "Invoice / reference date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceDueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceDiscountDate",
"label": "Discount date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceDiscountDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceHistoryHeaderSeqNo",
"label": "Internal retained invoice history sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceHistoryHeaderSeqNo",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PostingDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PostingDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TermsCode",
"label": "Stored payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TermsCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HoldPayment",
"label": "Native open-item hold (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HoldPayment",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Comment",
"label": "Retained open-item note",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Comment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "JobNo",
"label": "Job reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "JobNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaidToday",
"label": "Native paid-today flag (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaidToday",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceAmt",
"label": "Native invoice amount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceAmt",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DiscountAmt",
"label": "Native discount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountAmt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "RetentionCost",
"label": "Native retention cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RetentionCost",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Balance",
"label": "Current item balance — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Balance",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TaxableAmt",
"label": "Native taxable amount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TaxableAmt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NonTaxableAmt",
"label": "Native nontaxable amount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NonTaxableAmt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FreightAmt",
"label": "Native freight — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FreightAmt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TaxAmt",
"label": "Native tax — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TaxAmt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NonRecoverableAmt",
"label": "Native nonrecoverable amount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NonRecoverableAmt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OpenItemKey",
"label": "Internal complete open-item identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OpenItemKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountKey",
"label": "Internal complete account identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyDisplayName",
"label": "Current account name / stored code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartyDisplayName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartyAvailability",
"label": "Current account dossier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartyAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceDateReadState",
"label": "Invoice date interpretation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceDateReadState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DueDateReadState",
"label": "Due date interpretation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DueDateReadState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Current payables",
"primaryKey": "OpenItemKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VendorNo",
"InvoiceNo",
"TermsCode",
"HoldPayment",
"Comment",
"JobNo",
"PaidToday",
"PartyDisplayName",
"PartyAvailability",
"InvoiceDateReadState",
"DueDateReadState"
],
"sourceID": "DE7F91E1-A49C-52E3-833C-A89E8A10B3E8",
"sqlQuery": "SELECT o.APDivisionNo, o.VendorNo, o.InvoiceNo, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),8) ELSE NULL END,112) AS InvoiceDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),8) ELSE NULL END,112) AS InvoiceDueDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDiscountDate, 112))),8) ELSE NULL END,112) AS InvoiceDiscountDate, o.InvoiceHistoryHeaderSeqNo, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.PostingDate, 112))),8) ELSE NULL END,112) AS PostingDate, o.TermsCode, o.HoldPayment, o.Comment, o.JobNo, o.PaidToday, o.InvoiceAmt, o.DiscountAmt, o.RetentionCost, o.Balance, o.TaxableAmt, o.NonTaxableAmt, o.FreightAmt, o.TaxAmt, o.NonRecoverableAmt, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), o.APDivisionNo)),N':',CONVERT(nvarchar(4000), o.APDivisionNo),N'|',DATALENGTH(CONVERT(nvarchar(4000), o.VendorNo)),N':',CONVERT(nvarchar(4000), o.VendorNo),N'|',DATALENGTH(CONVERT(nvarchar(4000), o.InvoiceNo)),N':',CONVERT(nvarchar(4000), o.InvoiceNo),N'|') AS OpenItemKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), o.APDivisionNo)),N':',CONVERT(nvarchar(4000), o.APDivisionNo),N'|',DATALENGTH(CONVERT(nvarchar(4000), o.VendorNo)),N':',CONVERT(nvarchar(4000), o.VendorNo),N'|') AS AccountKey, COALESCE(NULLIF(m.VendorName,N''),o.VendorNo) AS PartyDisplayName, CASE WHEN m.VendorNo IS NULL THEN N'Missing: verify source integrity' ELSE N'Available' END AS PartyAvailability, CASE WHEN o.InvoiceDate IS NULL THEN N'Missing source date' WHEN TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDate, 112))),8) ELSE NULL END,112) IS NULL THEN N'Unrecognized source date / convention' ELSE N'Readable source date' END AS InvoiceDateReadState, CASE WHEN o.InvoiceDueDate IS NULL THEN N'Missing source date' WHEN TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), o.InvoiceDueDate, 112))),8) ELSE NULL END,112) IS NULL THEN N'Unrecognized source date / convention' ELSE N'Readable source date' END AS DueDateReadState FROM dbo.AP_OpenInvoice o LEFT JOIN dbo.AP_Vendor m ON (CONVERT(nvarchar(4000), o.APDivisionNo) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.APDivisionNo) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), o.APDivisionNo))=DATALENGTH(CONVERT(nvarchar(4000), m.APDivisionNo))) AND (CONVERT(nvarchar(4000), o.VendorNo) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.VendorNo) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), o.VendorNo))=DATALENGTH(CONVERT(nvarchar(4000), m.VendorNo))) WHERE o.APDivisionNo IS NOT NULL AND o.VendorNo IS NOT NULL AND o.InvoiceNo IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 300",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "D5B71B7F-A683-5FCE-93DE-AFE3EBA82A9B",
"key": "AccountKey",
"type": "text"
}
],
"id": "B641C9E2-B7A1-5A09-B943-2D4A26BD9A4C",
"integration": "Sage 100 US",
"mappings": [
{
"commonFieldKey": "",
"key": "APDivisionNo",
"label": "Internal vendor division",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "APDivisionNo",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorNo",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VendorNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorName",
"label": "Current vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VendorName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AddressLine1",
"label": "Current address",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AddressLine1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AddressLine2",
"label": "Current address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AddressLine2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AddressLine3",
"label": "Current address 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AddressLine3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "City",
"label": "Current city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "City",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "State",
"label": "Current state",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "State",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ZipCode",
"label": "Current postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ZipCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CountryCode",
"label": "Current country code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CountryCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PrimaryContact",
"label": "Primary contact code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PrimaryContact",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TelephoneNo",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TelephoneNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TelephoneExt",
"label": "Telephone extension",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TelephoneExt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "EmailAddress",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "EmailAddress",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TermsCode",
"label": "Current master payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TermsCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Reference",
"label": "Vendor reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Reference",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HoldPayment",
"label": "Current vendor payment selection hold (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HoldPayment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Comment",
"label": "Current master note",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Comment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LastPurchaseDate",
"label": "Vendor last purchase date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LastPurchaseDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LastPaymentDate",
"label": "Vendor last payment date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LastPaymentDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DateEstablished",
"label": "Vendor established date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DateEstablished",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AverageDaysToPay",
"label": "Stored average days to pay",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AverageDaysToPay",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AverageDaysOverDue",
"label": "Stored average days overdue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AverageDaysOverDue",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BalanceDue",
"label": "Current vendor balance — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BalanceDue",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountKey",
"label": "Internal complete account identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VendorState",
"label": "Vendor status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VendorState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Current vendor dossier",
"primaryKey": "AccountKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "APDivisionNo",
"id": "81AAA9CE-58D4-59A4-93FC-2027638C989B",
"name": "division",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "VendorNo",
"id": "E0847A53-338B-513E-B7AE-93BA6526E4F2",
"name": "party",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"VendorNo",
"VendorName",
"AddressLine1",
"AddressLine2",
"AddressLine3",
"City",
"State",
"ZipCode",
"CountryCode",
"PrimaryContact",
"TelephoneNo",
"TelephoneExt",
"EmailAddress",
"TermsCode",
"Reference",
"HoldPayment",
"Comment",
"VendorState"
],
"sourceID": "DE7F91E1-A49C-52E3-833C-A89E8A10B3E8",
"sqlQuery": "SELECT m.APDivisionNo, m.VendorNo, m.VendorName, m.AddressLine1, m.AddressLine2, m.AddressLine3, m.City, m.State, m.ZipCode, m.CountryCode, m.PrimaryContact, m.TelephoneNo, m.TelephoneExt, m.EmailAddress, m.TermsCode, m.Reference, m.HoldPayment, m.Comment, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPurchaseDate, 112))),8) ELSE NULL END,112) AS LastPurchaseDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.LastPaymentDate, 112))),8) ELSE NULL END,112) AS LastPaymentDate, TRY_CONVERT(date, CASE WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))))=8 AND LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))) NOT LIKE '%[^0-9]%' THEN LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))) WHEN LEN(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))))>9 AND LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))),8) NOT LIKE '%[^0-9]%' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))),9,1)='.' AND SUBSTRING(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))),10,31) NOT LIKE '%[^0]%' THEN LEFT(LTRIM(RTRIM(CONVERT(varchar(40), m.DateEstablished, 112))),8) ELSE NULL END,112) AS DateEstablished, m.AverageDaysToPay, m.AverageDaysOverDue, m.BalanceDue, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), m.APDivisionNo)),N':',CONVERT(nvarchar(4000), m.APDivisionNo),N'|',DATALENGTH(CONVERT(nvarchar(4000), m.VendorNo)),N':',CONVERT(nvarchar(4000), m.VendorNo),N'|') AS AccountKey, CASE m.VendorStatus WHEN N'A' THEN N'Active' WHEN N'I' THEN N'Inactive' WHEN N'T' THEN N'Temporary' ELSE CONCAT(N'Unknown / unset: ', m.VendorStatus) END AS VendorState FROM dbo.AP_Vendor m WHERE (CONVERT(nvarchar(4000), m.APDivisionNo) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :division) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), m.APDivisionNo))=DATALENGTH(CONVERT(nvarchar(4000), :division))) AND (CONVERT(nvarchar(4000), m.VendorNo) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :party) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), m.VendorNo))=DATALENGTH(CONVERT(nvarchar(4000), :party)))",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "E76CDB4C-0B5D-55A5-A0BD-5018CDD5ECCE",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "62D9CA7C-B2F2-53D0-B2DD-F58DE83EF105",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B641C9E2-B7A1-5A09-B943-2D4A26BD9A4C",
"title": "Vendor",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Invoice / reference date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HoldPayment",
"label": "Native open-item hold (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAmt",
"label": "Invoice amount — source",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Balance",
"label": "Current balance — source",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "246EE7E0-96F4-53BA-A292-D3E10BF0754B",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "VendorNo",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceNo",
"label": "Invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Invoice / reference date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDiscountDate",
"label": "Discount date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "PostingDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "TermsCode",
"label": "Stored payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "HoldPayment",
"label": "Native open-item hold (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "Comment",
"label": "Retained open-item note",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "JobNo",
"label": "Job reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "PaidToday",
"label": "Native paid-today flag (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceAmt",
"label": "Native invoice amount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "DiscountAmt",
"label": "Native discount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "RetentionCost",
"label": "Native retention cost — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "Balance",
"label": "Current item balance — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "TaxableAmt",
"label": "Native taxable amount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "NonTaxableAmt",
"label": "Native nontaxable amount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "FreightAmt",
"label": "Native freight — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "TaxAmt",
"label": "Native tax — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "NonRecoverableAmt",
"label": "Native nonrecoverable amount — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "PartyDisplayName",
"label": "Current account name / stored code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "PartyAvailability",
"label": "Current account dossier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDateReadState",
"label": "Invoice date interpretation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "DueDateReadState",
"label": "Due date interpretation",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "2054A28B-D8E0-5B26-B5B8-8D8D153CFDE0",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "FB11735C-3787-5AA4-90B5-0E7CED9BA057",
"key": "InvoiceDueDate",
"type": "date"
},
{
"direction": "ascending",
"id": "B964634B-49A9-5A8F-BDF3-CFF9848AE88D",
"key": "OpenItemKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "PartyDisplayName",
"systemImage": "doc.text",
"title": "Current payables",
"titleKey": "InvoiceNo"
},
{
"actions": [],
"badgeKey": "VendorState",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "City",
"label": "Current city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TelephoneNo",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "EmailAddress",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BalanceDue",
"label": "Master balance — source",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B641C9E2-B7A1-5A09-B943-2D4A26BD9A4C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "VendorNo",
"label": "Vendor code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "VendorName",
"label": "Current vendor name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "AddressLine1",
"label": "Current address",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "AddressLine2",
"label": "Current address 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "AddressLine3",
"label": "Current address 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "City",
"label": "Current city",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "State",
"label": "Current state",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "ZipCode",
"label": "Current postal code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "CountryCode",
"label": "Current country code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "PrimaryContact",
"label": "Primary contact code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "TelephoneNo",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "TelephoneExt",
"label": "Telephone extension",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "EmailAddress",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "TermsCode",
"label": "Current master payment terms code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "Reference",
"label": "Vendor reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "HoldPayment",
"label": "Current vendor payment selection hold (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "Comment",
"label": "Current master note",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "LastPurchaseDate",
"label": "Vendor last purchase date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "LastPaymentDate",
"label": "Vendor last payment date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "DateEstablished",
"label": "Vendor established date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "AverageDaysToPay",
"label": "Stored average days to pay",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "AverageDaysOverDue",
"label": "Stored average days overdue",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Native values — source currency",
"detailRole": "information",
"isVisible": true,
"key": "BalanceDue",
"label": "Current vendor balance — source currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Business context",
"detailRole": "information",
"isVisible": true,
"key": "VendorState",
"label": "Vendor status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "16930EB3-9240-536C-99D3-8AD29E9683DA",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "D5B71B7F-A683-5FCE-93DE-AFE3EBA82A9B",
"key": "AccountKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "VendorNo",
"systemImage": "doc.text",
"title": "Current vendor dossier",
"titleKey": "VendorName"
}
],
"relations": [
{
"childDatasetID": "B641C9E2-B7A1-5A09-B943-2D4A26BD9A4C",
"childKey": "AccountKey",
"id": "62D9CA7C-B2F2-53D0-B2DD-F58DE83EF105",
"name": "Current vendor dossier",
"parentDatasetID": "246EE7E0-96F4-53BA-A292-D3E10BF0754B",
"parentKey": "AccountKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage 100 US — SQL Server",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-09T00:00:00Z",
"description": "NOT VALIDATED ON A REAL ERP INSTALLATION. Unofficial configuration based on Sage 100 US 2026 FLOR Rel 7.50 own open-item layouts, complete logical keys, public functional help and synthetic validation. Verify installed schema, currency, NULL, roles, date adapters, padding, collation, least-privilege SELECT permissions and query cost at import. Not a real Sage SQL Server test.\n\nInspect current retained supplier open items, native item balances, due/discount/posting dates, invoice amount, paid-today and hold context. Open the separately identified current vendor dossier.\n\nWhy Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorized source and your Cifru plan.\n\nPro: one source, 2 lists, 1 lazy dossier buttons, parameterized read-only SELECT and at most 2,000 rows per request. No scheduled refresh. No implicit Last 7 days or Balance<>0 filter: old debts, retained zero-balance rows and unrecognized dates remain available. Oldest due dates sort first with a complete-identity tie break; NULL dates can sort ahead of dated rows. Local Search, Filters and sorting affect loaded rows only, not the entire source. A 2,000-row limit hit means the list may be incomplete; adapt source-side filtering before relying on totals. No fabricated aggregate total or full-catalog claim.\n\nCURRENT native open-item records, not a historical closing balance, a reconstructed aging report or a complete payment ledger. Invoice/due-date filtering selects current retained records; it does not show the balance as of the selected date. Retention, purges and balance-forward accounting options affect availability. Source changes between reads are not a transaction-consistent snapshot. A missing row or master is not evidence of no debt or a zero balance.\n\nBalance, original invoice/tax/freight components, payments today, discount and retention are separate native values. NULL remains NULL, never zero. No general paid/unpaid status, source currency code, USD assumption, universal debit/credit sign normalization or reconstructed amount due. Monetary labels refer to source currency; verify its meaning in your company setup.\n\nAP PaidToday is a native Y/N context flag, not a general paid status. Open-item HoldPayment and current vendor payment selection hold are separate. AP_OpenInvoice has no InvoiceType projection here: no AR legend is borrowed. Full identity is APDivisionNo + VendorNo + InvoiceNo.\n\nMaster contacts, payment terms, balances and last payment values are CURRENT, separately labeled from this individual open item. InvoiceHistoryHeaderSeqNo is kept internally but does not certify a history or line linkage; no partial invoice-number join is provided. Technical keys are hidden. Exact binary Unicode and byte-length comparisons preserve complete strings, but installed physical types, padding, collation and performance still require validation. SQL Server 2012+/compatibility 110+ is required for defensive date conversion; invalid or unsupported dates become NULL, not 1900, with interpretation labels.\n\nNo source credentials, server addresses, cached business rows, banking/check/taxpayer data or audit-user identifiers in the package. DEMO captures must be wholly fictional. Public layouts prove selected logical names and keys, not installed DDL/indexes or speed. Native ERP operator permissions do not carry into direct SQL: separately authorized least-privilege SELECT is required. Unofficial, not endorsed by Sage; not France, Contractor or ProvideX.\n\nOwn open-item layout: https://help-sage100.na.sage.com/2026/FLOR/Content/File_Layouts/Accounts_Payable/AP_OpenInvoice.htm\nOwn master layout: https://help-sage100.na.sage.com/2026/FLOR/Content/File_Layouts/Accounts_Payable/AP_Vendor.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "25E387FB-78C9-52CA-B817-6CE3F1B42418",
"rootButtonCount": 1,
"summary": "Current retained item balances and due dates; complete context and separate current vendor.",
"tags": [
"Sage 100 US",
"SQL Server",
"Accounting",
"Payables",
"Pro"
],
"title": "Current payables and vendor dossier — Pro"
}
}