AL objects · query
459 query objects
Agents: llms.txt.
- Query 1 "Distinct Items Sold"
- Query 2 "Customer Interaction Stats."
- Query 3 "Customer Sales per Period"
- Query 4 "Distinct Items Purchased"
- Query 19 "VAT Entries Base Amt. Sum"
- Query 21 "Cust. Ledg. Entry Remain. Amt."
- Query 22 "Cust. Remain. Amt. By Due Date"
- Query 25 "Vend. Ledg. Entry Remain. Amt."
- Query 33 "Recon. Cust. Posting Gr. Sum"
- Query 34 "Recon. Vend. Posting Gr. Sum"
- Query 35 "Customer Debit Credit Amount"
- Query 36 "Vendor Debit Credit Amount"
- Query 37 "RemQtyBaseInvtItemSalesLine"
- Query 39 "RemQtyBaseInvtItemPurchaseLine"
- Query 50 "Power BI Customer List"
- Query 51 "Power BI Vendor List"
- Query 52 "Power BI Item Purchase List"
- Query 53 "Power BI GL Amount List"
- Query 54 "Power BI Jobs List"
- Query 55 "Power BI Sales List"
- Query 56 "Power BI Purchase List"
- Query 57 "Power BI Item Sales List"
- Query 58 "Power BI GL Budgeted Amount"
- Query 59 "Power BI Top Cust. Overview"
- Query 60 "Power BI Sales Hdr. Cust."
- Query 61 "Power BI Cust. Item Ledg. Ent."
- Query 62 "Power BI Cust. Ledger Entries"
- Query 63 "Power BI Vendor Ledger Entries"
- Query 64 "Power BI Purchase Hdr. Vendor"
- Query 65 "Power BI Vend. Item Ledg. Ent."
- Query 100 "Top Customer Overview"
- Query 101 "Sales Dashboard"
- Query 102 "Item Sales by Customer"
- Query 103 "Item Sales and Profit"
- Query 104 "Sales Orders by Sales Person"
- Query 105 "Sales Opportunities"
- Query 106 "Segment Lines"
- Query 115 "Sales Shipped Not Invoiced LCY"
- Query 123 "Fixed Assets Analysis"
- Query 124 "Sales Order Analysis"
- Query 130 "Posted Docs. With No Inc. Doc."
- Query 133 "Inc. Doc. Atts. Ready for OCR"
- Query 134 "OCR Vendors"
- Query 135 "OCR Vendor Bank Accounts"
- Query 141 "EU VAT Entries"
- Query 200 "Purchase Invoices By Order"
- Query 201 "Sales Invoices By Order"
- Query 202 "Service Invoices By Order"
- Query 203 "Item Ledger Entry Types"
- Query 204 "Purch. Cr. Memos By Ret. Order"
- Query 205 "Sales Cr. Memos By Ret. Order"
- Query 250 "G/L Entry Dimensions"
- Query 251 "G/L Budget Entry Dimensions"
- Query 252 "Analysis View Entry Dimensions"
- Query 253 "Analysis View Budg. Entry Dims"
- Query 256 "CF Forecast Entry Dimensions"
- Query 257 "Dimension Sets"
- Query 260 "Dimension Set Entries"
- Query 261 "G/L Entries"
- Query 262 "Cust. Ledger Entries"
- Query 263 "Vendor Ledger Entries"
- Query 264 "Bank Account Ledger Entries"
- Query 265 "Item Ledger Entries"
- Query 266 "Value Entries"
- Query 267 "FA Ledger Entries"
- Query 268 "Job Ledger Entries"
- Query 269 "Res. Ledger Entries"
- Query 270 "G/L Budget Entries"
- Query 302 "Item Application Entries"
- Query 303 "Item Application Entries Inb."
- Query 304 "Item Application Entries Outb."
- Query 410 "Analysis View Source"
- Query 472 "Failed Job Queue Entry"
- Query 486 "ProjectsAnalysis"
- Query 487 "Project Planning Analysis"
- Query 488 "Purch. Order Perf. Analysis"
- Query 520 "Item By Lot No. Res."
- Query 521 "Item By Lot No. Item Ledg."
- Query 522 "Qty. Reserved From Item Ledger"
- Query 523 "Sales Reserv. From Item Ledger"
- Query 760 "Trailing Sales Order Qry"
- Query 762 "Acc. Sched. Line Desc. Count"
- Query 763 "Colm. Layt. Colm. Header Count"
- Query 770 "Analysis Line Desc. Count"
- Query 771 "Analysis Column Header Count"
- Query 774 "Users in Plans"
- Query 775 "Plan"
- Query 776 "Device"
- Query 777 "Role Center from Plans"
- Query 901 "RemQtyBaseInvtItemAssemblyLine"
- Query 984 "Get Time Sheet Lines"
- Query 985 "Get Time Sheet Archive Lines"
- Query 986 "Time Sheet Line Status Count"
- Query 1003 "RemQtyBaseInvtItemJobPlannLine"
- Query 1033 "GetJobPlanningLines"
- Query 1038 "Job Task by Bill-to Customer"
- Query 1232 "Data Exch. Field Details"
- Query 1302 "Sales Outstd. Amount On VAT"
- Query 1310 "Cust. Ledg. Entry Sales"
- Query 1311 "Top 10 Customer Sales"
- Query 1312 "Num CustLedgEntries per Cust"
- Query 1313 "Purch. Outstd. Amount On VAT"
- Query 1316 "Value Item Ledger Entries"
- Query 1319 "Sales by Cust. Grp. Chart Mgt."
- Query 1440 "Best Sold Item Headline"
- Query 1441 "Top Customer Headline"
- Query 1442 "Sales Increase Headline"
- Query 1501 "Workflow Instance"
- Query 1502 "Workflow Definition"
- Query 1511 "User IDs by Notification Type"
- Query 1850 "Sales Forecast Query"
- Query 1950 "LPP Sales Invoice Header Input"
- Query 2400 "Account Summary"
- Query 2401 "General Ledger Entries"
- Query 2402 "Bank Acct Ledger Entries"
- Query 2403 "GL Entries with Dimensions"
- Query 2450 "Customer Ship To Addresses"
- Query 2451 "CustomerAndSalesperson"
- Query 2452 "Blocked Customers"
- Query 2453 "CustomersWithCreditLimit"
- Query 2454 "Unposted Sales Trx Quotes"
- Query 2455 "Unposted Sales Trx Orders"
- Query 2456 "Unposted Sales Trx Invoices"
- Query 2457 "Unposted Sales Trx Returns"
- Query 2458 "Unposted Sales Trx Credit Memo"
- Query 2459 "Unposted Sales Trx Blnkt Ordr"
- Query 2460 "Posted Sales Invoices"
- Query 2461 "Posted Sales Credit Memos"
- Query 2462 "Unposted Sales Line Quotes"
- Query 2463 "Posted Sales I Line Item"
- Query 2464 "Posted Sales C Memo Line Item"
- Query 2465 "Customer And Contact"
- Query 2467 "Unposted Sales Line Orders"
- Query 2468 "Unposted Sales Line Invoices"
- Query 2469 "Unposted Sales Line Returns"
- Query 2470 "Unposted Sales Line Crdt Memo"
- Query 2471 "Unposted Sales Line Blkt Ordr"
- Query 2500 "Vendor Order Addresses"
- Query 2501 "Vendor And Purchaser"
- Query 2502 "Blocked Vendors"
- Query 2504 "Vendor Balance"
- Query 2506 "Purchasing Rcpt Line Items"
- Query 2507 "Purchase Orders"
- Query 2508 "Purchase Order Line Items"
- Query 2510 "Purchasing Trx Invoices"
- Query 2511 "Purchasing Trx Crdt Memos"
- Query 2512 "Blanket Purchase Orders"
- Query 2513 "Blanket Purchase Order Lines"
- Query 2514 "Purchasing Inv Line Items"
- Query 2515 "Purchasing Cr Memo Line Items"
- Query 2550 "Items"
- Query 2552 "Item Quantities"
- Query 2553 "Item Purchase Receipts"
- Query 2554 "Items By Location"
- Query 2556 "Negative Quantity Items"
- Query 2557 "Items Overdue For Count"
- Query 2558 "Items Due For Count"
- Query 2900 "Item With Variants"
- Query 2901 "Item With Locations"
- Query 2902 "Item With Variants & Locations"
- Query 3000 "GPHistAllSalesTrx"
- Query 3001 "GPHistSalesInvoices"
- Query 3002 "GPHistSalesOrders"
- Query 3003 "GPHistSalesQuotes"
- Query 3004 "GPHistSalesReturns"
- Query 3005 "GPHistReceivablesTrx"
- Query 3006 "GPOpenReceivablesTrx"
- Query 3007 "GPHistSalesLineItems"
- Query 3008 "GPHistPayablesTrx"
- Query 3009 "GPHistReceivingsTrx"
- Query 3010 "GPHistReceivingsLineItems"
- Query 3011 "GPHistInventoryTrx"
- Query 3303 "PA Posted Purch. Inv. Users"
- Query 3688 "BOM Component Items"
- Query 3689 "Item Production BOMs"
- Query 3691 "Production BOM & Line Details"
- Query 4000 "Hybrid Tables For Replication"
- Query 4001 "Hybrid Enabled Co Rep. Details"
- Query 4002 "Hybrid Unique Table Status"
- Query 4098 "GP Item Transaction Average"
- Query 4099 "GP Item Transaction"
- Query 4101 "GP Item Transaction Standard"
- Query 4401 "EXR Top Vendor Balance"
- Query 4402 "EXR Top Vendor Purchase"
- Query 4403 "EXR Top Customer Balance"
- Query 4404 "EXR Top Customer Sales"
- Query 4405 "EXR Trial Balance"
- Query 4406 "EXR Trial Balance Budget"
- Query 4407 "EXR Trial Balance BU"
- Query 4700 "VAT Group Submission Status"
- Query 5001 "Locations from items Sales"
- Query 5002 "Locations from items Purch"
- Query 5280 "Qty. Item Ledger Entry SAF-T"
- Query 5281 "Cust. Ledger Entry SAF-T"
- Query 5282 "Vendor Ledger Entry SAF-T"
- Query 5283 "Item Ledger Entry SAF-T"
- Query 5284 "G/L Entry SAF-T"
- Query 5285 "FA Ledger Entry SAF-T"
- Query 5286 "G/L Entry By Trans. SAF-T"
- Query 5400 "Delayed Prod. Orders - by Cost"
- Query 5401 "Pending Prod. Orders - by Cost"
- Query 5402 "Top-10 Prod. Orders - by Cost"
- Query 5403 "My Prod. Orders - By Cost"
- Query 5404 "My Delayed Prod. Orders"
- Query 5407 "RemQtyBaseInvtItemProdOrdComp"
- Query 5480 "Customer Sales Entity"
- Query 5481 "Vendor Purchases Entity"
- Query 5502 "Tax Groups For Tax Areas"
- Query 5741 "RemQtyBaseInvtItemTransferLine"
- Query 5756 "Grouped Item Ledger Entries"
- Query 5833 "Item to Value Entries"
- Query 5840 "Avg. Cost Entry Points Not Adj"
- Query 5842 "Residual Amount - Items"
- Query 5896 "Calculate Actual Material Cost"
- Query 5900 "Service Analysis"
- Query 5902 "RemQtyBaseInvtItemServiceLine"
- Query 6100 "E-Doc. Line by Receipt"
- Query 6210 "Country Region - PBI API"
- Query 6211 "Emission Fees - PBI API"
- Query 6212 "Employee Absence - PBI API"
- Query 6213 "EmployeeLedgerEntry - PBI API"
- Query 6214 "Employee Quali - PBI API"
- Query 6215 "Employees - PBI API"
- Query 6216 "Resp Centre - PBI API"
- Query 6217 "SusSub Act Category - PBI API"
- Query 6218 "Sust Account Cat - PBI API"
- Query 6219 "Sust Accounts - PBI API"
- Query 6220 "Sustainability Goals - PBI API"
- Query 6221 "Sust Ledger Entries - PBI API"
- Query 6502 "Items With Expiration Date"
- Query 6610 "FS Item Avail. by Location"
- Query 7079 "Expense Projects List"
- Query 7080 "Expense User Assigned Plan Ln"
- Query 7081 "Expense User Assigned Projects"
- Query 7082 "Expense Per Diem Locations"
- Query 7089 "Expense Project Tasks Qry"
- Query 7111 "Travel Request Employees"
- Query 7150 "Item Analysis View Source"
- Query 7300 "Lot Numbers by Bin"
- Query 7301 "Whse. Employees at Locations"
- Query 7302 "Bin Content by Item Tracking"
- Query 7314 "CalcRsvQtyOnPicksShipsWithIT"
- Query 7315 "CalcQtyOnBlockedITOnSNQuery"
- Query 7316 "CalcQtyOnBlockedITOnLNQuery"
- Query 7317 "CalcQtyOnBlockedITOnPNQuery"
- Query 7318 "CalcQtyInWhseEntries"
- Query 7319 "CalcPickableQtyFromWhseEntry"
- Query 7320 "CalcQtyInReservEntry"
- Query 7321 "Summarized Stock By Item Trkg."
- Query 7323 "CalcOutstandQtyOnWhseActLine"
- Query 7345 "Avail Qty. (Base) In QC Bins"
- Query 7346 "Whse. Entry Tracking Distinct"
- Query 8000 "Overdue Customer Serv. Comm."
- Query 8001 "Overdue Vendor Serv. Comm."
- Query 8888 "Outbox Emails"
- Query 8889 "Sent Emails"
- Query 8890 "Email Related Record"
- Query 9059 "Service Header Doc. Type Count"
- Query 9060 "Count Sales Orders"
- Query 9063 "Count Purchase Orders"
- Query 9088 "Top 10 Vendor Purchases"
- Query 9089 "Purchase by Vendor Group"
- Query 9150 "My Customers"
- Query 9151 "My Vendors"
- Query 9152 "My Items"
- Query 9153 "Non-Inventory Telemetry"
- Query 10504 "EU VAT Entries GB" (GB)
- Query 10670 "SAF-T G/L Entry By Trans." (NO)
- Query 10671 "SAF-T G/L Entry By Doc." (NO)
- Query 11400 "Data Exch. Find Column No." (NL)
- Query 11401 "CountPartnerTypes" (NL)
- Query 11700 "VAT Report Entry Link CZL" (CZ)
- Query 12400 "Value Entry Item Tariff No." (RU)
- Query 18000 "GSTR2NonGSTExemp" (IN)
- Query 18001 "GSTR1ATADJQuery" (IN)
- Query 18002 "GSTR1ATADJCessAmt" (IN)
- Query 18003 "GSTR1ATADJGSTPer" (IN)
- Query 18004 "GSTR1ATCessAmt" (IN)
- Query 18005 "GSTR1ATPer" (IN)
- Query 18006 "GSTR1ATQuery" (IN)
- Query 18007 "GSTR1B2BCessAmt" (IN)
- Query 18008 "GSTR1B2BGSTPer" (IN)
- Query 18009 "GSTR1B2BQuery" (IN)
- Query 18010 "GSTR1B2CLCessAmt" (IN)
- Query 18011 "GSTR1B2CLPer" (IN)
- Query 18012 "GSTR1B2CLQuery" (IN)
- Query 18013 "GSTR1B2CSCessAmt" (IN)
- Query 18014 "GSTR1B2CSPer" (IN)
- Query 18015 "GSTR1B2CSQuery" (IN)
- Query 18016 "GSTR1CDNRCess" (IN)
- Query 18017 "GSTR1CDNRPerQuery" (IN)
- Query 18018 "GSTR1CDNRQuery" (IN)
- Query 18019 "GSTR1CDNURCessAmt" (IN)
- Query 18020 "GSTR2ATADJ" (IN)
- Query 18021 "GSTR1CDNURGSTPer" (IN)
- Query 18022 "GSTR1CDNURQuery" (IN)
- Query 18023 "GSTR1EXEMPQuery" (IN)
- Query 18024 "GSTR1ExpCessAmt" (IN)
- Query 18025 "GSTR1ExpExemp" (IN)
- Query 18026 "GSTR1ExpPer" (IN)
- Query 18027 "GSTR1ExpQuery" (IN)
- Query 18028 "GSTR1HSNGSTAmt" (IN)
- Query 18029 "GSTR1HSNQty" (IN)
- Query 18030 "GSTR1HSNQuery" (IN)
- Query 18031 "GSTR1NonGSTExemp" (IN)
- Query 18032 "GSTR2ATADJGSTPer" (IN)
- Query 18033 "GSTR1B2CSInter" (IN)
- Query 18034 "GSTR1B2CIntraCess" (IN)
- Query 18035 "GSTR2B2BQuery" (IN)
- Query 18036 "GSTR1B2CSIntra" (IN)
- Query 18037 "GSTR2ATCessAmt" (IN)
- Query 18038 "GSTR2ATPer" (IN)
- Query 18039 "GSTR1B2CInterCess" (IN)
- Query 18040 "GST Amount GSTR3B" (IN)
- Query 18041 "GSTR2ATQuery" (IN)
- Query 18042 "GSTR2IGST" (IN)
- Query 18043 "GSTR2ATADJCessAmt" (IN)
- Query 18044 "GSTR2IMPSQuery" (IN)
- Query 18045 "GSTR2SGSTAmt" (IN)
- Query 18046 "GSTR2Exemp" (IN)
- Query 18047 "GSTR2CDNRQuery" (IN)
- Query 18048 "GSTR2ExempNil" (IN)
- Query 18049 "GSTR2GSTPer" (IN)
- Query 18050 "GSTR2B2BURQuery" (IN)
- Query 18051 "GSTR2CompTaxValue" (IN)
- Query 18052 "GSTR2HSNGSTAmt" (IN)
- Query 18053 "GSTR2HSNQty" (IN)
- Query 18054 "GSTR2HSNQuery" (IN)
- Query 18055 "GSTR2HSNSUM" (IN)
- Query 18056 "GSTR2BaseAmt" (IN)
- Query 18057 "GSTR2CDNURQuery" (IN)
- Query 18058 "GSTR2IMPSIGSTAmt" (IN)
- Query 18059 "TDS 27Q" (IN)
- Query 18060 "GSTR1B2BSalesTranship" (IN)
- Query 18061 "TCS 27 EQ" (IN)
- Query 18062 "GSTR2IMPGCess" (IN)
- Query 18063 "GSTR2IMPGQuery" (IN)
- Query 18064 "GSTR2CDNRCess" (IN)
- Query 18065 "GSTR1NonGSTExempCrMemo" (IN)
- Query 18066 "GSTR1B2CSCrMemo" (IN)
- Query 18071 "GSTR2CessAmt" (IN)
- Query 18072 "GSTR2CGSTAmt" (IN)
- Query 18073 "GSTR2IMPGBaseAmt" (IN)
- Query 20000 "APIV1 - Customer Sales"
- Query 20001 "APIV1 - Vendor Purchases"
- Query 20401 "Qlty. Inspection Values"
- Query 20402 "Qlty. Item Ledger By Location"
- Query 30000 "APIV2 - Customer Sales"
- Query 30001 "APIV2 - Vendor Purchases"
- Query 30300 "API Finance - GL Entry"
- Query 30301 "API Fin - Dtld Cust Ledg Entry"
- Query 30302 "API Fin - Cust Ledg Entry"
- Query 30303 "API Fin - Vend Ledg Entry"
- Query 30304 "API Fin - Dtld Vend Ledg Entry"
- Query 30305 "API Finance - GL Budget Entry"
- Query 36950 "PowerBI Dimension Set Entries"
- Query 36951 "PowerBI Dimension Sets"
- Query 36952 "Dimensions"
- Query 36953 "Items - PBI API"
- Query 36954 "Account Categories"
- Query 36955 "G\L Entries - Balance Sheet"
- Query 36956 "G/L Entries - Closing"
- Query 36957 "Customer Ledger Entries"
- Query 36958 "G/L Account Categories"
- Query 36959 "G/L Accounts"
- Query 36960 "G/L Budget Entries - PBI API"
- Query 36961 "G/L Budgets"
- Query 36962 "G/L Entries - Income Statement"
- Query 36963 "Vendor Ledg. Entries - PBI API"
- Query 36964 "Assembly Headers - Order"
- Query 36965 "Assembly Lines - Item"
- Query 36966 "Bins"
- Query 36967 "Value Entries - Item"
- Query 36968 "Item Ledger Entries - PBI API"
- Query 36969 "Job Planning Lines - Item"
- Query 36970 "Planning Components"
- Query 36971 "Prod. Order Comp. - Invt."
- Query 36972 "Prod. Order Lines - Invt."
- Query 36973 "Purchase Lines - Outstanding"
- Query 36974 "Requisition Lines"
- Query 36975 "Sales Lines - Outstanding"
- Query 36976 "Service Lines - Order"
- Query 36977 "Transfer Lines"
- Query 36978 "Warehouse Activity Lines"
- Query 36979 "Warehouse Entries"
- Query 36980 "Whse. Journal Lines - From Bin"
- Query 36981 "Whse. Journal Lines - To Bin"
- Query 36982 "Zones"
- Query 36983 "Calendar Entries"
- Query 36984 "Capacity Ledger Entries"
- Query 36985 "Machine Centers"
- Query 36986 "Item Ledger Entries - Prod."
- Query 36987 "Prod. Order Capacity Needs"
- Query 36988 "Prod. Order Comp. - Manuf."
- Query 36989 "Prod. Order Lines - Manuf."
- Query 36990 "Prod. Order Routing Lines"
- Query 36991 "Work Centers"
- Query 36992 "Job Ledger Entries - PBI API"
- Query 36993 "Job Planning Lines"
- Query 36994 "Job Tasks"
- Query 36995 "Jobs"
- Query 36996 "Purch. Lines - Job Outstanding"
- Query 36997 "Purch. Lines - Job Received"
- Query 36998 "Purch. Lines - Item Outstd."
- Query 36999 "Item Budget Entries - Purch."
- Query 37000 "Value Entries - Purch."
- Query 37001 "Purch. Lines - Item Received"
- Query 37002 "Item Budget Names"
- Query 37003 "Sales Line - Item Outstanding"
- Query 37004 "Item Budget Entries - Sales"
- Query 37005 "Value Entries - Sales"
- Query 37006 "Sales Line - Item Shipped"
- Query 37007 "Manufacturing Setup - PBI API"
- Query 37008 "Prod. Orders - PBI API"
- Query 37009 "Routing Links - PBI API"
- Query 37010 "Routings - PBI API"
- Query 37011 "Manuf. Value Entries - PBI API"
- Query 37012 "Work Center Groups - PBI API"
- Query 37013 "Close Income Source - PBI API"
- Query 37014 "G/L Income Statement - PBI API"
- Query 37015 "Inventory by Location"
- Query 37016 "Dynamic Dimensions - PBI API"
- Query 37017 "Opportunity - PBI API"
- Query 37018 "Opportunity Entries - PBI API"
- Query 37019 "Sales Line - PBI API"
- Query 37020 "Inv. Adj. Ent Order - PBI API"
- Query 37022 "ABC Analysis Setup - PBI API"
- Query 37023 "Purch. Value Entries - PBI API"
- Query 37024 "Sales Line V2 - PBI API"
- Query 37025 "Sales Value Entries - PBI API"
- Query 37070 "Resources - PBI API"
- Query 37071 "Sales Cr Project Ledger Entry"
- Query 37073 "Purchase Lines - PBI API"
- Query 37074 "Sales Invoice Lines - PBI API"
- Query 37107 "Purchase Invoice Lines"
- Query 37108 "Purchase Credit Lines"
- Query 37109 "Sales Credit Lines - PBI API"
- Query 37110 "Sales Inv Project Ledger Entry"
- Query 40100 "GP Populate Item Transactions"
- Query 40101 "GP Item Aggregate"
- Query 42800 "SL Hist. Shippers"
- Query 42801 "SL Hist. InventoryTransactions"
- Query 42802 "SL Hist. OpenARDocuments"
- Query 42803 "SL Hist. APDocuments"
- Query 42804 "SL Hist. ARDocuments"
- Query 42805 "SL Hist. POReceiptLineItems"
- Query 42806 "SL Hist. POReceiptDocuments"
- Query 42807 "SL Hist. ARInvoiceDocuments"
- Query 42808 "SL Hist. SalesOrderLineItems"
- Query 42809 "SL Hist. SalesOrders"
- Query 42810 "SL Hist. SalesOrderQuotes"
- Query 42811 "SL Hist. SalesOrderReturns"
- Query 42812 "SL Hist. ShipperLineItems"
- Query 42813 "SL Hist. ARTransactions"
- Query 42814 "SL Hist. APTransactions"
- Query 42815 "SL Hist. GLTransactions"
- Query 42816 "SL Hist. Batch"
- Query 47000 "SL Inventory QtyOnHand All"
- Query 47001 "SL AcctHist Active Accounts"