Business Central tables

2,473 tables, versions 17 to 29

Every key that declares SumIndexFields, the fields CalcSums and FlowFields sum fast on that key. One row per key.

186 keys

table 17 "G/L Entry"Base Application17-29
Key Key2Key fields G/L Account No., Posting DateSum fields Amount, Debit Amount, Credit Amount, Additional-Currency Amount, Add.-Currency Debit Amount, Add.-Currency Credit Amount, VAT Amount, Quantity, Source Currency Amount, Source Currency VAT Amount
table 17 "G/L Entry"Base Application17-29
Key Key3Key fields G/L Account No., Global Dimension 1 Code, Global Dimension 2 Code, Posting Date, VAT Reporting Date, Source Currency CodeSum fields Amount, Debit Amount, Credit Amount, Additional-Currency Amount, Add.-Currency Debit Amount, Add.-Currency Credit Amount, VAT Amount, Source Currency Amount, Source Currency VAT Amount
table 17 "G/L Entry"Base Application17-29
Key Key4Key fields G/L Account No., Business Unit Code, Posting DateSum fields Amount, Debit Amount, Credit Amount, Additional-Currency Amount, Add.-Currency Debit Amount, Add.-Currency Credit Amount
table 17 "G/L Entry"Base Application17-29
Key Key5Key fields G/L Account No., Business Unit Code, Global Dimension 1 Code, Global Dimension 2 Code, Posting DateSum fields Amount, Debit Amount, Credit Amount, Additional-Currency Amount, Add.-Currency Debit Amount, Add.-Currency Credit Amount
table 17 "G/L Entry"Base Application17-29
Key Key6Key fields Document No., Posting DateSum fields Amount, Debit Amount, Credit Amount, Additional-Currency Amount, Add.-Currency Debit Amount, Add.-Currency Credit Amount, VAT Amount
table 17 "G/L Entry"Base Application17-29
Key Key9Key fields G/L Account No., Job No., Posting DateSum fields Amount
table 17 "G/L Entry"Base Application17-29
Key Key10Key fields Posting Date, G/L Account No., Dimension Set IDSum fields Amount
table 21 "Cust. Ledger Entry"Base Application17-29
Key Key2Key fields Customer No., Currency CodeSum fields Sales (LCY), Profit (LCY), Inv. Discount (LCY)
table 21 "Cust. Ledger Entry"Base Application17-29
Key Key18Key fields Document Type, Posting DateSum fields Sales (LCY)
table 25 "Vendor Ledger Entry"Base Application17-29
Key Key2Key fields Vendor No., Currency CodeSum fields Purchase (LCY), Inv. Discount (LCY)
table 32 "Item Ledger Entry"Base Application17-29
Key Key2Key fields Item No., SIFT Bucket No.Sum fields Invoiced Quantity, Quantity
table 32 "Item Ledger Entry"Base Application17-29
Key Key4Key fields Item No., Entry Type, Variant Code, Drop Shipment, Location Code, Posting Date, SIFT Bucket No.Sum fields Quantity, Invoiced Quantity
table 96 "G/L Budget Entry"Base Application17-29
Key Key2Key fields Budget Name, G/L Account No., DateSum fields Amount
table 115 "Sales Cr.Memo Line"Base Application17-29
Key Key8Key fields Document No., Location CodeSum fields Amount, Amount Including VAT, Inv. Discount Amount
table 160 "Res. Capacity Entry"Base Application17-29
Key Key2Key fields Resource No., DateSum fields Capacity
table 160 "Res. Capacity Entry"Base Application17-29
Key Key3Key fields Resource Group No., DateSum fields Capacity
table 169 "Job Ledger Entry"Base Application17-29
Key Key9Key fields Job No., Entry Type, Type, Posting DateSum fields Total Cost (LCY), Line Amount (LCY), Total Cost, Line Amount
table 254 "VAT Entry"Base Application17-29
Key Key2Key fields Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Posting Date, G/L Acc. No., VAT Reporting DateSum fields Base, Amount, Additional-Currency Base, Additional-Currency Amount, Remaining Unrealized Amount, Remaining Unrealized Base, Add.-Curr. Rem. Unreal. Amount, Add.-Curr. Rem. Unreal. Base
table 254 "VAT Entry"Base Application17-29
Key Key3Key fields Type, Closed, Tax Jurisdiction Code, Use Tax, Posting DateSum fields Base, Amount, Unrealized Amount, Unrealized Base, Remaining Unrealized Amount
table 254 "VAT Entry"Base Application17-29
Key Key4Key fields Type, Country/Region Code, VAT Registration No., VAT Bus. Posting Group, VAT Prod. Posting Group, Posting DateSum fields Base, Additional-Currency Base
table 254 "VAT Entry"Base Application17-29
Key Key9Key fields Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Tax Jurisdiction Code, Use Tax, Posting Date, G/L Acc. No.Sum fields Base, Amount, Unrealized Amount, Unrealized Base, Additional-Currency Base, Additional-Currency Amount, Add.-Currency Unrealized Amt., Add.-Currency Unrealized Base, Remaining Unrealized Amount
table 254 "VAT Entry"Base Application17-29
Key Key10Key fields Posting Date, Type, Closed, VAT Bus. Posting Group, VAT Prod. Posting Group, Reversed, G/L Acc. No., VAT Reporting DateSum fields Base, Amount, Unrealized Amount, Unrealized Base, Additional-Currency Base, Additional-Currency Amount, Add.-Currency Unrealized Amt., Add.-Currency Unrealized Base, Remaining Unrealized Amount
table 271 "Bank Account Ledger Entry"Base Application17-29
Key Key2Key fields Bank Account No., Posting DateSum fields Amount, Amount (LCY), Debit Amount, Credit Amount, Debit Amount (LCY), Credit Amount (LCY)
table 271 "Bank Account Ledger Entry"Base Application17-29
Key Key4Key fields Document Type, Bank Account No., Posting DateSum fields Amount
table 271 "Bank Account Ledger Entry"Base Application17-29
Key Key7Key fields Bank Account No., Global Dimension 1 Code, Global Dimension 2 Code, Posting DateSum fields Amount, Amount (LCY), Debit Amount, Credit Amount, Debit Amount (LCY), Credit Amount (LCY)
table 271 "Bank Account Ledger Entry"Base Application17-29
Key Key13Key fields Bank Account No., Posting Date, Statement No., Closed at Date, Statement Status, Reversed, OpenSum fields Amount
table 281 "Phys. Inventory Ledger Entry"Base Application17-29
Key Key2Key fields Item No., Variant Code, Location Code, Posting Date, SIFT Bucket No.Sum fields Quantity
table 281 "Phys. Inventory Ledger Entry"Base Application17-29
Key Key3Key fields Item No., Variant Code, Global Dimension 1 Code, Global Dimension 2 Code, Location Code, Posting Date, SIFT Bucket No.Sum fields Quantity
table 296 "Reminder Line"Base Application17-29
Key Key2Key fields Reminder No., Type, Line Type, Detailed Interest Rates EntrySum fields Amount, VAT Amount, Remaining Amount
table 296 "Reminder Line"Base Application17-29
Key Key3Key fields Reminder No., Detailed Interest Rates EntrySum fields Amount, VAT Amount, Remaining Amount
table 296 "Reminder Line"Base Application17-29
Key Key4Key fields Reminder No., TypeSum fields VAT Amount
table 298 "Issued Reminder Line"Base Application17-29
Key Key2Key fields Reminder No., Type, Line Type, Detailed Interest Rates EntrySum fields Amount, VAT Amount, Remaining Amount
table 298 "Issued Reminder Line"Base Application17-29
Key Key3Key fields Reminder No., Detailed Interest Rates EntrySum fields Amount, VAT Amount, Remaining Amount
table 298 "Issued Reminder Line"Base Application17-29
Key Key4Key fields Reminder No., TypeSum fields VAT Amount
table 303 "Finance Charge Memo Line"Base Application17-29
Key Key2Key fields Finance Charge Memo No., Type, Detailed Interest Rates EntrySum fields Amount, VAT Amount, Remaining Amount
table 303 "Finance Charge Memo Line"Base Application17-29
Key Key3Key fields Finance Charge Memo No., Detailed Interest Rates EntrySum fields Amount, VAT Amount, Remaining Amount
table 305 "Issued Fin. Charge Memo Line"Base Application17-29
Key Key2Key fields Finance Charge Memo No., Type, Detailed Interest Rates EntrySum fields Amount, VAT Amount, Remaining Amount
table 305 "Issued Fin. Charge Memo Line"Base Application17-29
Key Key3Key fields Finance Charge Memo No., Detailed Interest Rates EntrySum fields Amount, VAT Amount, Remaining Amount
table 307 "Inventory Buffer"Base Application17-29
Key Key2Key fields Location Code, Variant Code, QuantitySum fields Quantity
table 365 "Analysis View Entry"Base Application17-29
Key Key2Key fields Analysis View Code, Account No., Account Source, Dimension 1 Value Code, Dimension 2 Value Code, Dimension 3 Value Code, Dimension 4 Value Code, Business Unit Code, Posting Date, Cash Flow Forecast No.Sum fields Amount, Debit Amount, Credit Amount, Add.-Curr. Amount, Add.-Curr. Debit Amount, Add.-Curr. Credit Amount
table 366 "Analysis View Budget Entry"Base Application17-29
Key Key2Key fields Analysis View Code, Business Unit Code, Budget Name, G/L Account No., Posting Date, Dimension 1 Value Code, Dimension 2 Value Code, Dimension 3 Value Code, Dimension 4 Value CodeSum fields Amount
table 379 "Detailed Cust. Ledg. Entry"Base Application17-29
Key Key2Key fields Customer No., Currency Code, Excluded from calculationSum fields Amount, Amount (LCY)
table 379 "Detailed Cust. Ledg. Entry"Base Application17-29
Key Key12Key fields Document TypeSum fields Amount (LCY)
table 379 "Detailed Cust. Ledg. Entry"Base Application17-29
Key Key13Key fields Initial Document Type, Initial Entry Due DateSum fields Amount (LCY)
table 380 "Detailed Vendor Ledg. Entry"Base Application17-29
Key Key2Key fields Vendor No., Currency Code, Excluded from calculationSum fields Amount, Amount (LCY)
table 380 "Detailed Vendor Ledg. Entry"Base Application17-29
Key Key11Key fields Initial Document Type, Initial Entry Due DateSum fields Amount (LCY)
table 383 "Detailed CV Ledg. Entry Buffer"Base Application17-29
Key Key2Key fields CV Ledger Entry No., Entry TypeSum fields Amount, Amount (LCY), Debit Amount, Credit Amount, Debit Amount (LCY), Credit Amount (LCY)
table 383 "Detailed CV Ledg. Entry Buffer"Base Application17-29
Key Key3Key fields CV No., Initial Entry Due Date, Posting Date, Currency CodeSum fields Amount, Amount (LCY), Debit Amount, Credit Amount, Debit Amount (LCY), Credit Amount (LCY)
table 383 "Detailed CV Ledg. Entry Buffer"Base Application17-29
Key Key4Key fields CV No., Posting Date, Entry Type, Currency CodeSum fields Amount, Amount (LCY)
table 383 "Detailed CV Ledg. Entry Buffer"Base Application17-29
Key Key5Key fields CV No., Initial Document Type, Document TypeSum fields Amount, Amount (LCY)
table 383 "Detailed CV Ledg. Entry Buffer"Base Application17-29
Key Key7Key fields Initial Document Type, CV No., Posting Date, Currency Code, Entry TypeSum fields Amount, Amount (LCY)
table 383 "Detailed CV Ledg. Entry Buffer"Base Application17-29
Key Key8Key fields CV No., Initial Entry Due Date, Posting Date, Initial Entry Global Dim. 1, Initial Entry Global Dim. 2, Currency CodeSum fields Amount, Amount (LCY), Debit Amount, Credit Amount, Debit Amount (LCY), Credit Amount (LCY)
table 383 "Detailed CV Ledg. Entry Buffer"Base Application17-29
Key Key9Key fields CV No., Posting Date, Entry Type, Initial Entry Global Dim. 1, Initial Entry Global Dim. 2, Currency CodeSum fields Amount, Amount (LCY)
table 383 "Detailed CV Ledg. Entry Buffer"Base Application17-29
Key Key10Key fields CV No., Initial Document Type, Document Type, Initial Entry Global Dim. 1, Initial Entry Global Dim. 2Sum fields Amount, Amount (LCY)
table 383 "Detailed CV Ledg. Entry Buffer"Base Application17-29
Key Key11Key fields Initial Document Type, CV No., Posting Date, Currency Code, Entry Type, Initial Entry Global Dim. 1, Initial Entry Global Dim. 2Sum fields Amount, Amount (LCY)
table 846 "Cash Flow Worksheet Line"Base Application17-29
Key Key2Key fields Cash Flow Forecast No., Document No.Sum fields Amount (LCY)
table 847 "Cash Flow Forecast Entry"Base Application17-29
Key Key2Key fields Cash Flow Account No., Cash Flow Date, Cash Flow Forecast No.Sum fields Amount (LCY)
table 847 "Cash Flow Forecast Entry"Base Application17-29
Key Key3Key fields Cash Flow Forecast No., Cash Flow Account No., Source Type, Cash Flow Date, PositiveSum fields Amount (LCY), Payment Discount
table 847 "Cash Flow Forecast Entry"Base Application17-29
Key Key4Key fields Cash Flow Account No., Cash Flow Forecast No., Global Dimension 1 Code, Global Dimension 2 Code, Cash Flow DateSum fields Amount (LCY), Payment Discount
table 956 "Time Sheet Detail Archive"Base Application17-29
Key Key2Key fields Type, Job No., Job Task No., Status, PostedSum fields Quantity
table 958 "Time Sheet Posting Entry"Base Application17-29
Key Key2Key fields Time Sheet No., Time Sheet Line No., Time Sheet DateSum fields Quantity
table 1003 "Job Planning Line"Base Application17-29
Key Key2Key fields Job No., Job Task No., Schedule Line, Planning DateSum fields Total Price (LCY), Total Cost (LCY), Line Amount (LCY), Remaining Total Cost (LCY), Remaining Line Amount (LCY), Total Cost, Line Amount
table 1003 "Job Planning Line"Base Application17-29
Key Key3Key fields Job No., Job Task No., Contract Line, Planning DateSum fields Total Price (LCY), Total Cost (LCY), Line Amount (LCY), Remaining Total Cost (LCY), Remaining Line Amount (LCY), Total Cost, Line Amount
table 1003 "Job Planning Line"Base Application17-29
Key Key6Key fields Job No., Schedule Line, Type, No., Planning DateSum fields Quantity (Base)
table 1003 "Job Planning Line"Base Application17-29
Key Key7Key fields Job No., Schedule Line, Type, Resource Group No., Planning DateSum fields Quantity (Base)
table 1003 "Job Planning Line"Base Application17-29
Key Key8Key fields Status, Schedule Line, Type, No., Planning DateSum fields Quantity (Base)
table 1003 "Job Planning Line"Base Application17-29
Key Key9Key fields Status, Schedule Line, Type, Resource Group No., Planning DateSum fields Quantity (Base)
table 1003 "Job Planning Line"Base Application17-29
Key Key13Key fields Status, Type, No., Variant Code, Location Code, Planning DateSum fields Remaining Qty. (Base)
table 1004 "Job WIP Entry"Base Application17-29
Key Key2Key fields Job No., Job Posting Group, WIP Posting Date, Type, Job CompleteSum fields WIP Entry Amount
table 1004 "Job WIP Entry"Base Application17-29
Key Key4Key fields Job No., Job Complete, TypeSum fields WIP Entry Amount
table 1005 "Job WIP G/L Entry"Base Application17-29
Key Key2Key fields Job No., Reversed, Job Complete, TypeSum fields WIP Entry Amount
table 1005 "Job WIP G/L Entry"Base Application17-29
Key Key3Key fields Job No., Reverse, Job Complete, TypeSum fields WIP Entry Amount
table 1021 "Job WIP Total"Base Application17-29
Key Key3Key fields Job No., Posted to G/LSum fields Calc. Recog. Sales Amount, Calc. Recog. Costs Amount
table 1022 "Job Planning Line Invoice"Base Application17-29
Key Key3Key fields Job No., Job Planning Line No., Job Task No., Document TypeSum fields Quantity Transferred, Invoiced Amount (LCY), Invoiced Cost Amount (LCY)
table 1104 "Cost Entry"Base Application17-29
Key Key2Key fields Cost Type No., Posting DateSum fields Amount, Debit Amount, Credit Amount, Additional-Currency Amount, Add.-Currency Debit Amount, Add.-Currency Credit Amount
table 1104 "Cost Entry"Base Application17-29
Key Key3Key fields Cost Type No., Cost Center Code, Cost Object Code, Allocated, Posting DateSum fields Amount, Debit Amount, Credit Amount, Additional-Currency Amount, Add.-Currency Debit Amount, Add.-Currency Credit Amount
table 1104 "Cost Entry"Base Application17-29
Key Key4Key fields Cost Center Code, Cost Type No., Allocated, Posting DateSum fields Amount
table 1104 "Cost Entry"Base Application17-29
Key Key5Key fields Cost Object Code, Cost Type No., Allocated, Posting DateSum fields Amount
table 1104 "Cost Entry"Base Application17-29
Key Key9Key fields Cost Type No., Posting Date, Cost Center Code, Cost Object CodeSum fields Amount, Debit Amount, Credit Amount
table 1109 "Cost Budget Entry"Base Application17-29
Key Key2Key fields Budget Name, Cost Type No., DateSum fields Amount
table 1109 "Cost Budget Entry"Base Application17-29
Key Key3Key fields Budget Name, Cost Type No., Cost Center Code, Cost Object Code, DateSum fields Amount
table 1109 "Cost Budget Entry"Base Application17-29
Key Key4Key fields Budget Name, Cost Center Code, Cost Type No., Allocated, DateSum fields Amount
table 1109 "Cost Budget Entry"Base Application17-29
Key Key5Key fields Budget Name, Cost Object Code, Cost Type No., Allocated, DateSum fields Amount
table 1702 "Deferral Line"Base Application17-29
Key Key2Key fields Deferral Doc. Type, Gen. Jnl. Template Name, Gen. Jnl. Batch Name, Document Type, Document No., Line No.Sum fields Amount
table 1921 "Profiling Node"System Applicationnew in 20
Key PKKey fields Session ID, No.Sum fields Self Time, Full Time
table 5093 "Opportunity Entry"Base Application17-29
Key Key3Key fields Contact Company No., Contact No., ActiveSum fields Estimated Value (LCY), Calcd. Current Value (LCY)
table 5093 "Opportunity Entry"Base Application17-29
Key Key4Key fields Campaign No., ActiveSum fields Estimated Value (LCY), Calcd. Current Value (LCY)
table 5093 "Opportunity Entry"Base Application17-29
Key Key5Key fields Active, Sales Cycle Code, Sales Cycle Stage, Estimated Close DateSum fields Estimated Value (LCY), Calcd. Current Value (LCY), Days Open
table 5093 "Opportunity Entry"Base Application17-29
Key Key6Key fields Active, Opportunity No.Sum fields Estimated Value (LCY), Calcd. Current Value (LCY), Days Open
table 5093 "Opportunity Entry"Base Application17-29
Key Key7Key fields Active, Salesperson Code, Date of ChangeSum fields Estimated Value (LCY), Calcd. Current Value (LCY)
table 5207 "Employee Absence"Base Application17-29
Key Key2Key fields Employee No., From DateSum fields Quantity, Quantity (Base)
table 5207 "Employee Absence"Base Application17-29
Key Key3Key fields Employee No., Cause of Absence Code, From DateSum fields Quantity, Quantity (Base)
table 5207 "Employee Absence"Base Application17-29
Key Key4Key fields Cause of Absence Code, From DateSum fields Quantity, Quantity (Base)
table 5338 "Integration Synch. Job"Base Application17-29
Key Key5Key fields Integration Table Mapping NameSum fields Failed
table 5406 "Prod. Order Line"Base Application17-29
Key Key3Key fields Status, Item No., Variant Code, Location Code, Ending DateSum fields Remaining Qty. (Base), Cost Amount
table 5406 "Prod. Order Line"Base Application17-29
Key Key4Key fields Status, Item No., Variant Code, Location Code, Starting DateSum fields Remaining Qty. (Base)
table 5406 "Prod. Order Line"Base Application17-29
Key Key5Key fields Status, Item No., Variant Code, Location Code, Due DateSum fields Remaining Qty. (Base)
table 5406 "Prod. Order Line"Base Application17-29
Key Key6Key fields Status, Item No., Variant Code, Shortcut Dimension 1 Code, Shortcut Dimension 2 Code, Location Code, Due DateSum fields Remaining Qty. (Base)
table 5406 "Prod. Order Line"Base Application17-29
Key Key8Key fields Status, Prod. Order No., Routing No., Routing Reference No.Sum fields Quantity, Finished Quantity
table 5406 "Prod. Order Line"Base Application17-29
Key Key11Key fields Item No., Variant Code, Location Code, Status, Ending DateSum fields Remaining Qty. (Base)
table 5406 "Prod. Order Line"Base Application17-29
Key Key12Key fields Item No., Variant Code, Location Code, Status, Due DateSum fields Remaining Qty. (Base)
table 5407 "Prod. Order Component"Base Application17-29
Key Key3Key fields Status, Prod. Order No., Prod. Order Line No., Due DateSum fields Expected Quantity, Cost Amount
table 5407 "Prod. Order Component"Base Application17-29
Key Key5Key fields Status, Item No., Variant Code, Location Code, Due DateSum fields Expected Quantity, Remaining Qty. (Base), Cost Amount, Overhead Amount
table 5407 "Prod. Order Component"Base Application17-29
Key Key6Key fields Item No., Variant Code, Location Code, Shortcut Dimension 1 Code, Shortcut Dimension 2 Code, Due DateSum fields Expected Quantity, Remaining Qty. (Base), Cost Amount, Overhead Amount
table 5407 "Prod. Order Component"Base Application17-29
Key Key9Key fields Item No., Variant Code, Location Code, Status, Due DateSum fields Expected Qty. (Base), Remaining Qty. (Base), Cost Amount, Overhead Amount, Qty. Picked (Base)
table 5409 "Prod. Order Routing Line"Base Application17-29
Key Key5Key fields Status, Prod. Order No., Routing Reference No., Routing No., Sequence No. (Actual)Sum fields Expected Operation Cost Amt.
table 5409 "Prod. Order Routing Line"Base Application17-29
Key Key6Key fields Work Center No.Sum fields Expected Operation Cost Amt.
table 5409 "Prod. Order Routing Line"Base Application17-29
Key Key7Key fields Type, No., Starting DateSum fields Expected Operation Cost Amt.
table 5409 "Prod. Order Routing Line"Base Application17-29
Key Key8Key fields Status, Work Center No.Sum fields Expected Operation Cost Amt.
table 5409 "Prod. Order Routing Line"Base Application17-29
Key Key12Key fields Type, No., StatusSum fields Expected Operation Cost Amt.
table 5601 "FA Ledger Entry"Base Application17-29
Key Key2Key fields FA No., Depreciation Book Code, FA Posting DateSum fields Amount
table 5601 "FA Ledger Entry"Base Application17-29
Key Key3Key fields FA No., Depreciation Book Code, FA Posting Category, FA Posting Type, FA Posting Date, Part of Book Value, Reclassification EntrySum fields Amount
table 5601 "FA Ledger Entry"Base Application17-29
Key Key4Key fields FA No., Depreciation Book Code, Part of Book Value, FA Posting DateSum fields Amount
table 5601 "FA Ledger Entry"Base Application17-29
Key Key5Key fields FA No., Depreciation Book Code, Part of Depreciable Basis, FA Posting DateSum fields Amount
table 5601 "FA Ledger Entry"Base Application17-29
Key Key6Key fields FA No., Depreciation Book Code, FA Posting Category, FA Posting Type, Posting DateSum fields Amount
table 5615 "FA Allocation"Base Application17-29
Key Key2Key fields Allocation Type, CodeSum fields Allocation %
table 5625 "Maintenance Ledger Entry"Base Application17-29
Key Key2Key fields FA No., Depreciation Book Code, FA Posting DateSum fields Amount
table 5625 "Maintenance Ledger Entry"Base Application17-29
Key Key3Key fields FA No., Depreciation Book Code, Posting DateSum fields Amount
table 5625 "Maintenance Ledger Entry"Base Application17-29
Key Key4Key fields FA No., Depreciation Book Code, Maintenance Code, FA Posting DateSum fields Amount
table 5625 "Maintenance Ledger Entry"Base Application17-29
Key Key5Key fields FA No., Depreciation Book Code, Maintenance Code, Posting DateSum fields Amount
table 5629 "Ins. Coverage Ledger Entry"Base Application17-29
Key Key2Key fields Insurance No., Posting DateSum fields Amount
table 5629 "Ins. Coverage Ledger Entry"Base Application17-29
Key Key3Key fields Insurance No., Disposed FA, Posting DateSum fields Amount
table 5629 "Ins. Coverage Ledger Entry"Base Application17-29
Key Key4Key fields FA No., Insurance No., Disposed FA, Posting DateSum fields Amount
table 5649 "FA Posting Group Buffer"Base Application17-29
Key Key2Key fields Account No.Sum fields Amount
table 5773 "Registered Whse. Activity Line"Base Application17-29
Key Key5Key fields Source Type, Source Subtype, Source No., Source Line No., Source Subline No., Whse. Document No., Serial No., Lot No., Action TypeSum fields Qty. (Base)
table 5802 "Value Entry"Base Application17-29
Key Key7Key fields Item No., Valuation Date, Location Code, Variant Code, SIFT Bucket No.Sum fields Cost Amount (Expected), Cost Amount (Actual), Cost Amount (Expected) (ACY), Cost Amount (Actual) (ACY), Item Ledger Entry Quantity, Invoiced Quantity
table 5817 "Matched Order Line"Base Applicationnew in 28
Key Key1Key fields Document Line SystemId, Matched Order Line SystemId, Matched Rcpt./Shpt. Line SysIdSum fields Qty. to Invoice, Qty. to Invoice (Base)
table 5870 "BOM Buffer"Base Application17-29
Key Key3Key fields Type, No., IndentationSum fields Able to Make Parent
table 5878 "Phys. Invt. Record Line"Base Application17-29
Key Key2Key fields Order No., Order Line No.Sum fields Quantity (Base)
table 5882 "Pstd. Phys. Invt. Record Line"Base Application17-29
Key Key2Key fields Order No., Order Line No.Sum fields Quantity (Base)
table 5895 "Inventory Adjustment Buffer"Base Application17-29
Key Key2Key fields Item Ledger Entry No.Sum fields Cost Amount (Expected), Cost Amount (Actual), Cost Amount (Expected) (ACY), Cost Amount (Actual) (ACY)
table 5895 "Inventory Adjustment Buffer"Base Application17-29
Key Key3Key fields Item No., Valuation Date, Location Code, Variant CodeSum fields Cost Amount (Expected), Cost Amount (Actual), Cost Amount (Expected) (ACY), Cost Amount (Actual) (ACY), Item Ledger Entry Quantity
table 5907 "Service Ledger Entry"Base Application17-29
Key Key4Key fields Service Contract No., Entry No., Entry Type, Type, Moved from Prepaid Acc., Posting Date, Open, Prepaid, Service Item No. (Serviced), Customer No., Contract Group Code, Responsibility CenterSum fields Amount (LCY), Cost Amount, Quantity, Charged Qty., Contract Disc. Amount
table 5907 "Service Ledger Entry"Base Application17-29
Key Key5Key fields Service Order No., Service Item No. (Serviced), Entry Type, Moved from Prepaid Acc., Posting Date, Open, Type, Service Contract No.Sum fields Amount (LCY), Cost Amount, Quantity, Charged Qty., Amount
table 5907 "Service Ledger Entry"Base Application17-29
Key Key6Key fields Type, No., Entry Type, Moved from Prepaid Acc., Posting Date, Open, PrepaidSum fields Amount (LCY), Cost Amount, Quantity, Charged Qty.
table 5907 "Service Ledger Entry"Base Application17-29
Key Key7Key fields Service Item No. (Serviced), Entry Type, Moved from Prepaid Acc., Type, Posting Date, Open, Service Contract No., Prepaid, Customer No., Contract Group Code, Responsibility CenterSum fields Amount (LCY), Cost Amount
table 5907 "Service Ledger Entry"Base Application17-29
Key Key8Key fields Service Item No. (Serviced), Entry Type, Type, Service Contract No., Posting Date, Service Order No.Sum fields Amount (LCY), Cost Amount, Quantity, Charged Qty.
table 5950 "Service Order Allocation"Base Application17-29
Key Key2Key fields Status, Document Type, Document No., Service Item Line No., Allocation Date, Starting Time, PostedSum fields Allocated Hours
table 5950 "Service Order Allocation"Base Application17-29
Key Key3Key fields Document Type, Document No., Status, Resource Group No., Allocation Date, Starting Time, PostedSum fields Allocated Hours
table 5950 "Service Order Allocation"Base Application17-29
Key Key4Key fields Status, Document Type, Document No., Service Item Line No., Resource No., Allocation Date, Starting Time, PostedSum fields Allocated Hours
table 5950 "Service Order Allocation"Base Application17-29
Key Key5Key fields Document Type, Document No., Service Item Line No., Allocation Date, Starting Time, PostedSum fields Allocated Hours
table 5964 "Service Contract Line"Base Application17-29
Key Key4Key fields Contract Type, Contract No., Credited, New LineSum fields Line Amount, Profit
table 5969 "Contract Gain/Loss Entry"Base Application17-29
Key Key2Key fields Contract No., Change Date, Reason CodeSum fields Amount
table 5969 "Contract Gain/Loss Entry"Base Application17-29
Key Key3Key fields Contract Group Code, Change DateSum fields Amount
table 5969 "Contract Gain/Loss Entry"Base Application17-29
Key Key4Key fields Customer No., Ship-to Code, Change DateSum fields Amount
table 5969 "Contract Gain/Loss Entry"Base Application17-29
Key Key5Key fields Reason Code, Change DateSum fields Amount
table 5969 "Contract Gain/Loss Entry"Base Application17-29
Key Key6Key fields Responsibility Center, Change DateSum fields Amount
table 5993 "Service Invoice Line"Base Application17-29
Key Key5Key fields Document No., Service Item Line No., Serv. Price Adjmt. Gr. CodeSum fields Amount
table 5993 "Service Invoice Line"Base Application17-29
Key Key7Key fields Type, No., Variant Code, Location Code, Posting Date, Shortcut Dimension 1 Code, Shortcut Dimension 2 CodeSum fields Quantity (Base)
table 5993 "Service Invoice Line"Base Application17-29
Key Key12Key fields Document No., TypeSum fields Amount
table 5995 "Service Cr.Memo Line"Base Application17-29
Key Key5Key fields Document No.Sum fields Amount
table 5995 "Service Cr.Memo Line"Base Application17-29
Key Key7Key fields Type, No., Variant Code, Location Code, Posting Date, Shortcut Dimension 1 Code, Shortcut Dimension 2 CodeSum fields Quantity (Base)
table 5995 "Service Cr.Memo Line"Base Application17-29
Key Key12Key fields Document No., TypeSum fields Amount
table 6012 "Service Line Archive"Base Applicationnew in 25
Key Key6Key fields Document No., Document Type, Doc. No. Occurrence, Version No.Sum fields Amount, Amount Including VAT, Outstanding Amount, Shipped Not Invoiced, Outstanding Amount (LCY), Shipped Not Invoiced (LCY)
table 6014 "Service Order Allocat. Archive"Base Applicationnew in 25
Key Key2Key fields Document Type, Document No., Doc. No. Occurrence, Version No., Allocation Date, Resource No., Status, Resource Group No.Sum fields Allocated Hours
table 6164 "E-Doc. Order Match"E-Document Corenew in 24
Key Key2Key fields E-Document Entry No., E-Document Line No., Document Order No.Sum fields Precise Quantity
table 6216 "Sustainability Ledger Entry"Sustainabilitynew in 24
Key SummaryOnChartPageKey fields Account No., Posting Date, Dimension Set ID, Global Dimension 1 Code, Global Dimension 2 Code, Responsibility CenterSum fields Emission CO2, Emission CH4, Emission N2O
table 7134 "Item Budget Entry"Base Application17-29
Key Key2Key fields Analysis Area, Budget Name, Item No., Source Type, Source No., Date, Location Code, Global Dimension 1 Code, Global Dimension 2 Code, Budget Dimension 1 Code, Budget Dimension 2 Code, Budget Dimension 3 CodeSum fields Cost Amount, Sales Amount, Quantity
table 7134 "Item Budget Entry"Base Application17-29
Key Key3Key fields Analysis Area, Budget Name, Source Type, Source No., Item No., Date, Location Code, Global Dimension 1 Code, Global Dimension 2 Code, Budget Dimension 1 Code, Budget Dimension 2 Code, Budget Dimension 3 CodeSum fields Cost Amount, Sales Amount, Quantity
table 7312 "Warehouse Entry"Base Application17-29
Key Key5Key fields Item No., Bin Code, Location Code, Variant Code, Unit of Measure Code, Lot No., Serial No., Entry Type, Dedicated, Package No., Bin Type Code, SIFT Bucket No.Sum fields Qty. (Base), Cubage, Weight, Quantity
table 7312 "Warehouse Entry"Base Application17-29
Key Key7Key fields Bin Code, Location Code, Item No., SIFT Bucket No.Sum fields Cubage, Weight, Quantity, Qty. (Base)
table 7312 "Warehouse Entry"Base Application17-29
Key Key8Key fields Location Code, Item No., Variant Code, Zone Code, Bin Code, Lot No., SIFT Bucket No.Sum fields Quantity, Qty. (Base)
table 7319 "Posted Whse. Receipt Line"Base Application17-29
Key Key3Key fields Item No., Location Code, Variant CodeSum fields Qty. (Base), Qty. Put Away (Base)
table 7321 "Warehouse Shipment Line"Base Application17-29
Key Key9Key fields Source Type, Source Subtype, Source No., Source Line No., Assemble to OrderSum fields Qty. Outstanding, Qty. Outstanding (Base)
table 7321 "Warehouse Shipment Line"Base Application17-29
Key Key11Key fields Item No., Location Code, Variant Code, Due DateSum fields Qty. Outstanding (Base), Qty. Picked (Base), Qty. Shipped (Base)
table 7321 "Warehouse Shipment Line"Base Application17-29
Key Key12Key fields Bin Code, Location CodeSum fields Cubage, Weight
table 7332 "Whse. Internal Put-away Line"Base Application17-29
Key Key7Key fields Item No., From Bin Code, Location Code, Unit of Measure Code, Variant CodeSum fields Qty. (Base)
table 8006 "Usage Data Billing"Subscription Billingnew in 26
Key key1Key fields Usage Data Import Entry No., Subscription Header No., Subscription Line Entry No., Partner, Document Type, Charge End DateSum fields Quantity, Amount
table 8006 "Usage Data Billing"Subscription Billingnew in 26
Key key3Key fields Subscription Line Entry No., Document Type, Charge End DateSum fields Quantity, Amount, Cost Amount
table 8700 "Table Information Cache"System Applicationnew in 18
Key pkKey fields Company Name, Table No.Sum fields Size (KB), Data Size (KB), Index Size (KB)
table 8701 "Company Size Cache"System Applicationnew in 18
Key pkKey fields Company NameSum fields Size (KB), Data Size (KB), Index Size (KB)
table 20406 "Qlty. Inspection Line"Quality Managementnew in 28
Key Key2Key fields Template Code, Inspection No., Re-inspection No., Test Code, Result CodeSum fields Evaluation Sequence
table 30119 "Shpfy Order Line"Shopify Connectornew in 20
Key Idx001Key fields Shopify Order Id, Gift Card, TipSum fields Quantity
table 30133 "Shpfy Order Transaction"Shopify Connectornew in 20
Key Idx001Key fields Gift Card IdSum fields Amount
table 30141 "Shpfy Return Line"Shopify Connectornew in 22
Key Idx01Key fields Return Id, Discounted Total Amount, Presentment Disc. Total Amt.Sum fields Discounted Total Amount, Presentment Disc. Total Amt.
table 135039 "Cues And KPIs Test 1 Cue"System Application Test Librarynew in 18
Key PKKey fields Primary KeySum fields NormalInteger, NormalDecimal
table 149001 "BCPT Line"Performance Toolkit17-29
Key Key2Key fields No. of SessionsSum fields No. of Sessions
table 149002 "BCPT Log Entry"Performance Toolkit17-29
Key Key3Key fields Duration (ms)Sum fields Duration (ms)
table 99000757 "Calendar Entry"Base Application17-29
Key Key2Key fields Work Center No., Date, Work Shift CodeSum fields Capacity (Total), Capacity (Effective)
table 99000757 "Calendar Entry"Base Application17-29
Key Key3Key fields Work Center Group Code, Date, Work Shift CodeSum fields Capacity (Total), Capacity (Effective)
table 99000829 "Planning Component"Base Application17-29
Key Key2Key fields Item No., Variant Code, Location Code, Due Date, Planning Line OriginSum fields Expected Quantity (Base), Cost Amount
table 99000829 "Planning Component"Base Application17-29
Key Key3Key fields Item No., Variant Code, Location Code, Shortcut Dimension 1 Code, Shortcut Dimension 2 Code, Planning Line Origin, Due DateSum fields Expected Quantity (Base), Cost Amount
table 99000849 "Action Message Entry"Base Application17-29
Key Key2Key fields Reservation Entry, CalculationSum fields Quantity
table 99000849 "Action Message Entry"Base Application17-29
Key Key3Key fields Source Type, Source Subtype, Source ID, Source Batch Name, Source Prod. Order Line, Source Ref. No., Item No., Location Code, Bin Code, Variant CodeSum fields Quantity
table 99000852 "Production Forecast Entry"Base Application17-29
Key Key2Key fields Production Forecast Name, Item No., Location Code, Forecast Date, Component Forecast, Variant CodeSum fields Forecast Quantity (Base)
table 99000852 "Production Forecast Entry"Base Application17-29
Key Key3Key fields Production Forecast Name, Item No., Component Forecast, Forecast Date, Location Code, Variant CodeSum fields Forecast Quantity (Base)