Diagrams


Table

Depreciation Book

DynamicsDocs.comDepreciation Book«Table 5611»Depreciation BookCode [PK,NN]DescriptionG/L Integration - Acq. CostG/L Integration - DepreciationG/L Integration - Write-DownG/L Integration - AppreciationG/L Integration - Custom 1G/L Integration - Custom 2G/L Integration - DisposalG/L Integration - MaintenanceDisposal Calculation Method; [Net,Gros...Use Custom 1 DepreciationAllow Depr. below ZeroUse FA Exch. Rate in Duplic.Part of Duplication ListLast Date ModifiedAllow IndexationUse Same FA+G/L Posting DatesDefault Exchange RateUse FA Ledger CheckUse Rounding in Periodic Depr.New Fiscal Year Starting DateNo. of Days in Fiscal YearAllow Changes in Depr. FieldsDefault Final Rounding AmountDefault Ending Book ValuePeriodic Depr. Date Calc.; [Last Entry...Mark Errors as CorrectionsAdd-Curr Exch Rate - Acq. CostAdd.-Curr. Exch. Rate - Depr.Add-Curr Exch Rate -Write-Down...«Table 111»Sales Shipment LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No....«Table 113»Sales Invoice LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeShipment No....«Table 115»Sales Cr.Memo LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeBill-to Customer No....«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 37»Sales LineDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«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 5108»Sales Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupQuantity Disc. CodeShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«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 5601»FA Ledger EntryEntry No. [PK]G/L Entry No.FA No.FA Posting DatePosting DateDocument Type; [,Payment,Invoice,Credi...Document DateDocument No.External Document No.DescriptionDepreciation Book CodeFA Posting Category; [,Disposal,Bal. D...FA Posting Type; [Acquisition Cost,Dep...AmountDebit AmountCredit AmountReclassification EntryPart of Book ValuePart of Depreciable BasisDisposal Calculation Method; [,Net,Gro...Disposal Entry No.No. of Depreciation DaysQuantityFA No./Budgeted FA No.FA Subclass CodeFA Location CodeFA Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeUser ID...«Table 5603»FA SetupPrimary Key [PK]Allow Posting to Main AssetsDefault Depr. BookAllow FA Posting FromAllow FA Posting ToInsurance Depr. BookAutomatic Insurance PostingFixed Asset Nos.Insurance Nos.«Table 5604»FA Posting Type SetupFA Posting Type; [Write-Down,Appreciat...Depreciation Book Code [PK,NN]Part of Book ValuePart of Depreciable BasisInclude in Depr. CalculationInclude in Gain/Loss Calc.Reverse before DisposalSign; [,Debit,Credit]Depreciation TypeAcquisition Type«Table 5605»FA Journal SetupDepreciation Book Code [PK,NN]User ID [PK]FA Jnl. Template NameFA Jnl. Batch NameGen. Jnl. Template NameGen. Jnl. Batch NameInsurance Jnl. Template NameInsurance Jnl. Batch Name«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 5624»FA Reclass. Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]FA No.New FA No.FA Posting DatePosting DateDepreciation Book CodeReclassify Acq. Cost AmountReclassify Acq. Cost %Reclassify Acquisition CostReclassify DepreciationReclassify Write-DownReclassify AppreciationReclassify Custom 1Reclassify Custom 2Reclassify Salvage ValueInsert Bal. AccountDescriptionDocument No.Calc. DB1 Depr. Amount«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 6661»Return Receipt LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQuantity InvoicedBill-to Customer 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...<Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Default Depr. Book><Insurance Depr. Book><Depreciation Book Code><Depreciation Book Code><Depreciation Book Code><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Depreciation Book Code><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><Depreciation Book Code><Duplicate in Depreciation Book><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.><Attached to Line No.><Blanket Order Line No.><Attached to Line No.><Blanket Order Line No.><Purch. Order Line No.><Special Order Purch. Line No.><Sales Order Line No.><Special Order Sales Line No.><Attached to Line No.><Blanket Order Line No.><Blanket Order Line No.><Sales Order Line No.><Special Order Sales Line No.><Blanket Order Line No.><Blanket Order Line No.><Attached to Line No.><Blanket Order Line No.><Purch. Order Line No.><Special Order Purch. Line No.><Blanket Order Line No.><Attached to Line No.><Attached to Line No.><Reversed by Entry No.><Reversed Entry No.><FA Error Entry No.><FA Error Entry No.><Reversed by Entry No.><Reversed Entry No.><Attached to Line 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
3 G/L Integration - Acq. Cost Boolean
4 G/L Integration - Depreciation Boolean
5 G/L Integration - Write-Down Boolean
6 G/L Integration - Appreciation Boolean
7 G/L Integration - Custom 1 Boolean
8 G/L Integration - Custom 2 Boolean
9 G/L Integration - Disposal Boolean
10 G/L Integration - Maintenance Boolean
11 Disposal Calculation Method Option
12 Use Custom 1 Depreciation Boolean
13 Allow Depr. below Zero Boolean
14 Use FA Exch. Rate in Duplic. Boolean
15 Part of Duplication List Boolean
17 Last Date Modified Date Editable: No
18 Allow Indexation Boolean
19 Use Same FA+G/L Posting Dates Boolean
20 Default Exchange Rate Decimal (4:4)
23 Use FA Ledger Check Boolean
24 Use Rounding in Periodic Depr. Boolean
25 New Fiscal Year Starting Date Date
26 No. of Days in Fiscal Year Integer
27 Allow Changes in Depr. Fields Boolean
28 Default Final Rounding Amount Decimal
29 Default Ending Book Value Decimal
32 Periodic Depr. Date Calc. Option
33 Mark Errors as Corrections Boolean
34 Add-Curr Exch Rate - Acq. Cost Boolean
35 Add.-Curr. Exch. Rate - Depr. Boolean
36 Add-Curr Exch Rate -Write-Down Boolean
37 Add-Curr. Exch. Rate - Apprec. Boolean
38 Add-Curr. Exch Rate - Custom 1 Boolean
39 Add-Curr. Exch Rate - Custom 2 Boolean
40 Add.-Curr. Exch. Rate - Disp. Boolean
41 Add.-Curr. Exch. Rate - Maint. Boolean
42 Use Default Dimension Boolean
43 Subtract Disc. in Purch. Inv. Boolean
44 Allow Correction of Disposal Boolean
45 Allow more than 360/365 Days Boolean
46 VAT on Net Disposal Entries Boolean
47 Allow Acq. Cost below Zero Boolean
48 Allow Identical Document No. Boolean
49 Fiscal Year 365 Days Boolean

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 Depreciation Book Code 1..n
FA Journal Line Duplicate in Depreciation Book 1..n
FA Journal Setup Depreciation Book Code 1..n
FA Ledger Entry Depreciation Book Code 1..n
FA Posting Type Setup Depreciation Book Code 1..n
FA Reclass. Journal Line Depreciation Book Code 1..n
FA Setup Insurance Depr. Book 1..n
Gen. Journal Line Duplicate in Depreciation Book 1..n
Invoice Post. Buffer Duplicate in Depreciation Book 1..n
Maintenance Ledger Entry Depreciation Book Code 1..n
Purch. Cr. Memo Line Duplicate in Depreciation Book 1..n
Purch. Inv. Line Duplicate in Depreciation Book 1..n
Purch. Rcpt. Line Duplicate in Depreciation Book 1..n
Purchase Line Duplicate in Depreciation Book 1..n
Purchase Line Archive Duplicate in Depreciation Book 1..n
Return Receipt Line Duplicate in Depreciation Book 1..n
Return Shipment Line Duplicate in Depreciation Book 1..n
Sales Cr.Memo Line Duplicate in Depreciation Book 1..n
Sales Invoice Line Duplicate in Depreciation Book 1..n
Sales Line Duplicate in Depreciation Book 1..n
Sales Line Archive Duplicate in Depreciation Book 1..n
Sales Shipment Line Duplicate in Depreciation Book 1..n