Diagrams


Table

Maintenance

DynamicsDocs.comMaintenance«Table 5626»MaintenanceCode [PK,NN]Description«Table 121»Purch. Rcpt. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Qty. Rcd. Not InvoicedQuantity InvoicedOrder No....«Table 123»Purch. Inv. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Receipt No....«Table 125»Purch. Cr. Memo LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Pay-to Vendor No....«Table 39»Purchase LineDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 Code...«Table 49»Invoice Post. BufferType; [Prepmt. Exch. Rate Difference,G...G/L Account [PK]Global Dimension 1 CodeGlobal Dimension 2 CodeJob No. [PK]AmountVAT AmountGen. Bus. Posting Group [PK]Gen. Prod. Posting Group [PK]VAT Calculation Type; [Normal VAT,Reve...VAT Base AmountSystem-Created EntryTax Area Code [PK]Tax Liable [PK]Tax Group Code [PK]QuantityUse Tax [PK]VAT Bus. Posting Group [PK]VAT Prod. Posting Group [PK]Amount [ACY]VAT Amount [ACY]VAT Base Amount [ACY]VAT DifferenceVAT %Dimension Set ID [PK]Deferral Code [PK]Deferral Line No.FA Posting DateFA Posting Type; [,Acquisition Cost,Ma...Depreciation Book CodeSalvage Value...«Table 5110»Purchase Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 5612»FA Depreciation BookFA No. [PK,NN]Depreciation Book Code [PK,NN]Depreciation Method; [Straight-Line,De...Depreciation Starting DateStraight-Line %No. of Depreciation YearsNo. of Depreciation MonthsFixed Depr. AmountDeclining-Balance %Depreciation Table CodeFinal Rounding AmountEnding Book ValueFA Posting GroupDepreciation Ending DateAcquisition CostDepreciationBook ValueProceeds on DisposalGain/LossWrite-DownAppreciationCustom 1Custom 2Depreciable BasisSalvage ValueBook Value on DisposalMaintenanceMaintenance Code FilterFA Posting Date FilterAcquisition DateG/L Acquisition Date...«Table 5621»FA Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]Depreciation Book CodeFA Posting Type; [Acquisition Cost,Dep...FA No.FA Posting DatePosting DateDocument Type; [,,Invoice,Credit Memo]Document DateDocument No.External Document No.DescriptionAmountDebit AmountCredit AmountSalvage ValueQuantityCorrectionNo. of Depreciation DaysDepr. until FA Posting DateDepr. Acquisition CostFA Posting GroupMaintenance CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeInsurance No.Budgeted FA No.Use Duplication ListDuplicate in Depreciation BookFA Reclassification Entry...«Table 5625»Maintenance Ledger EntryEntry No. [PK]G/L Entry No.FA No.FA Posting DatePosting DateDocument Type; [,Payment,Invoice,Credi...Document DateDocument No.External Document No.DescriptionAmountDebit AmountCredit AmountQuantityFA No./Budgeted FA No.FA Subclass CodeFA Location CodeFA Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeUser IDJournal Batch NameSource CodeReason CodeTransaction No.Bal. Account Type; [G/L Account,Custom...Bal. Account No.VAT AmountGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting Group...«Table 6651»Return Shipment LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Quantity InvoicedPay-to Vendor No.Vendor Item No.Gen. Bus. Posting Group...«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...<Maintenance Code><Maintenance Code><Maintenance Code><Maintenance Code><Maintenance Code><Maintenance Code><Maintenance Code Filter><Maintenance Code><Maintenance Code><Maintenance Code><Maintenance Code><Attached to Line No.><Blanket Order Line No.><Attached to Line No.><Blanket Order Line No.><Attached to Line No.><Blanket Order Line No.><Attached to Line No.><Blanket Order Line No.><Blanket Order Line No.><Attached to Line No.><Reversed by Entry No.><Reversed Entry No.><Attached to Line No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Description Text50

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
FA Depreciation Book Maintenance Code Filter 1..n
FA Journal Line Maintenance Code 1..n
Gen. Journal Line Maintenance Code 1..n
Invoice Post. Buffer Maintenance Code 1..n
Maintenance Ledger Entry Maintenance Code 1..n
Purch. Cr. Memo Line Maintenance Code 1..n
Purch. Inv. Line Maintenance Code 1..n
Purch. Rcpt. Line Maintenance Code 1..n
Purchase Line Maintenance Code 1..n
Purchase Line Archive Maintenance Code 1..n
Return Shipment Line Maintenance Code 1..n