Diagrams

Table

FA Posting Group

DynamicsDocs.comFA Posting Group«Table 5606»FA Posting GroupCode [PK,NN]Acquisition Cost AccountAccum. Depreciation AccountWrite-Down AccountAppreciation AccountCustom 1 AccountCustom 2 AccountAcq. Cost Acc. on DisposalAccum. Depr. Acc. on DisposalWrite-Down Acc. on DisposalAppreciation Acc. on DisposalCustom 1 Account on DisposalCustom 2 Account on DisposalGains Acc. on DisposalLosses Acc. on DisposalBook Val. Acc. on Disp. [Gain]Sales Acc. on Disp. [Gain]Write-Down Bal. Acc. on Disp.Apprec. Bal. Acc. on Disp.Custom 1 Bal. Acc. on DisposalCustom 2 Bal. Acc. on DisposalMaintenance Expense AccountMaintenance Bal. Acc.Acquisition Cost Bal. Acc.Depreciation Expense Acc.Write-Down Expense Acc.Appreciation Bal. AccountCustom 1 Expense Acc.Custom 2 Expense Acc.Sales Bal. Acc.Allocated Acquisition Cost %...«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 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 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«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 5608»FA SubclassCode [PK,NN]NameFA Class CodeDefault FA Posting Group«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 5615»FA AllocationCode [PK,NN]Line No. [PK]DescriptionAccount No.Global Dimension 1 CodeGlobal Dimension 2 CodeAllocation %Allocation Type; [Acquisition,Deprecia...Account NameDimension Set ID«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 5637»FA G/L Posting BufferEntry No. [PK]Account No.AmountCorrectionGlobal Dimension 1 CodeGlobal Dimension 2 CodeFA Entry Type; [,Fixed Asset,Maintenan...FA Entry No.Automatic EntryFA Posting GroupFA Allocation Type; [Acquisition,Depre...FA Allocation Line No.Original General Journal LineNet DisposalDimension Set ID«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 751»Standard General Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Account Type; [G/L Account,Customer,Ve...Account No.Document Type; [,Payment,Invoice,Credi...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 CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Payment Discount %Job No.QuantityVAT AmountPayment Terms Code...«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...«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....<Acquisition Cost Account><Accum. Depreciation Account><Write-Down Account><Appreciation Account><Custom 1 Account><Custom 2 Account><Acq. Cost Acc. on Disposal><Accum. Depr. Acc. on Disposal><Write-Down Acc. on Disposal><Appreciation Acc. on Disposal><Custom 1 Account on Disposal><Custom 2 Account on Disposal><Gains Acc. on Disposal><Losses Acc. on Disposal><Book Val. Acc. on Disp. (Gain)><Sales Acc. on Disp. (Gain)><Write-Down Bal. Acc. on Disp.><Apprec. Bal. Acc. on Disp.><Custom 1 Bal. Acc. on Disposal><Custom 2 Bal. Acc. on Disposal><Maintenance Expense Account><Maintenance Bal. Acc.><Acquisition Cost Bal. Acc.><Depreciation Expense Acc.><Write-Down Expense Acc.><Appreciation Bal. Account><Custom 1 Expense Acc.><Custom 2 Expense Acc.><Sales Bal. Acc.><Sales Acc. on Disp. (Loss)><Book Val. Acc. on Disp. (Loss)><Posting Group><Posting Group><Posting Group><Posting Group><Posting Group><Posting Group><Posting Group><Posting Group><Posting Group><Posting Group><FA Posting Group><FA Posting Group><Default FA Posting Group><FA Posting Group><Code><FA Posting Group><FA Posting Group><FA Posting Group><Posting Group><Posting Group><Posting Group><Posting Group><No.><No.><Attached to Line No.><Blanket Order Line No.><No.><No.><Attached to Line No.><Blanket Order Line No.><No.><No.><Attached to Line No.><Blanket Order Line No.><No.><No.><Budgeted FA No.><Attached to Line No.><Blanket Order Line No.><No.><No.><Budgeted FA No.><Attached to Line No.><Blanket Order Line No.><No.><No.><Budgeted FA 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.><Budgeted FA No.><Purch. Order Line No.><Special Order Purch. Line No.><Blanket Order Line No.><No.><No.><Attached to Line No.><No.><No.><Budgeted FA No.><Attached to Line No.><FA Subclass Code><Component of Main Asset><FA No.><FA No./Budgeted FA No.><Bal. Account No.><Canceled from FA No.><FA No.><Component of Main Asset><FA No.><Budgeted FA No.><FA No.><FA No./Budgeted FA No.><Bal. Account No.><No.><Budgeted FA No.><No.><Account No.><Bal. Account No.><Source No.><Account No.><Bal. Account No.><Source No.><Budgeted FA No.><FA Subclass Code><Bal. Account No.><Reversed by Entry No.><Reversed Entry No.><FA Error Entry No.><FA Error Entry No.><FA Subclass Code><Account No.><Bal. Account No.><Reversed by Entry No.><Reversed Entry No.><Account No.><No.><Attached to Line No.><No.><Attached to Line No.><Account No.><Bal. Account No.><Account No.><Bal. Account No.>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Acquisition Cost Account (Acquisition Cost Account) Code20
3 Accum. Depreciation Account (Accum. Depreciation Account) Code20
4 Write-Down Account (Write-Down Account) Code20
5 Appreciation Account (Appreciation Account) Code20
6 Custom 1 Account (Custom 1 Account) Code20
7 Custom 2 Account (Custom 2 Account) Code20
8 Acq. Cost Acc. on Disposal (Acq. Cost Acc. on Disposal) Code20
9 Accum. Depr. Acc. on Disposal (Accum. Depr. Acc. on Disposal) Code20
10 Write-Down Acc. on Disposal (Write-Down Acc. on Disposal) Code20
11 Appreciation Acc. on Disposal (Appreciation Acc. on Disposal) Code20
12 Custom 1 Account on Disposal (Custom 1 Account on Disposal) Code20
13 Custom 2 Account on Disposal (Custom 2 Account on Disposal) Code20
14 Gains Acc. on Disposal (Gains Acc. on Disposal) Code20
15 Losses Acc. on Disposal (Losses Acc. on Disposal) Code20
16 Book Val. Acc. on Disp. (Gain) (Book Val. Acc. on Disp. (Gain)) Code20
17 Sales Acc. on Disp. (Gain) (Sales Acc. on Disp. (Gain)) Code20
18 Write-Down Bal. Acc. on Disp. (Write-Down Bal. Acc. on Disp.) Code20
19 Apprec. Bal. Acc. on Disp. (Apprec. Bal. Acc. on Disp.) Code20
20 Custom 1 Bal. Acc. on Disposal (Custom 1 Bal. Acc. on Disposal) Code20
21 Custom 2 Bal. Acc. on Disposal (Custom 2 Bal. Acc. on Disposal) Code20
22 Maintenance Expense Account (Maintenance Expense Account) Code20
23 Maintenance Bal. Acc. (Maintenance Bal. Acc.) Code20
24 Acquisition Cost Bal. Acc. (Acquisition Cost Bal. Acc.) Code20
25 Depreciation Expense Acc. (Depreciation Expense Acc.) Code20
26 Write-Down Expense Acc. (Write-Down Expense Acc.) Code20
27 Appreciation Bal. Account (Appreciation Bal. Account) Code20
28 Custom 1 Expense Acc. (Custom 1 Expense Acc.) Code20
29 Custom 2 Expense Acc. (Custom 2 Expense Acc.) Code20
30 Sales Bal. Acc. (Sales Bal. Acc.) Code20
31 Allocated Acquisition Cost % (Allocated Acquisition Cost %) Decimal (1:1) Editable: No
FlowField
32 Allocated Depreciation % (Allocated Depreciation %) Decimal (1:1) Editable: No
FlowField
33 Allocated Write-Down % (Allocated Write-Down %) Decimal (1:1) Editable: No
FlowField
34 Allocated Appreciation % (Allocated Appreciation %) Decimal (1:1) Editable: No
FlowField
35 Allocated Custom 1 % (Allocated Custom 1 %) Decimal (1:1) Editable: No
FlowField
36 Allocated Custom 2 % (Allocated Custom 2 %) Decimal (1:1) Editable: No
FlowField
37 Allocated Sales Price % (Allocated Sales Price %) Decimal (1:1) Editable: No
FlowField
38 Allocated Maintenance % (Allocated Maintenance %) Decimal (1:1) Editable: No
FlowField
39 Allocated Gain % (Allocated Gain %) Decimal (1:1) Editable: No
FlowField
40 Allocated Loss % (Allocated Loss %) Decimal (1:1) Editable: No
FlowField
41 Allocated Book Value % (Gain) (Allocated Book Value % (Gain)) Decimal (1:1) Editable: No
FlowField
42 Allocated Book Value % (Loss) (Allocated Book Value % (Loss)) Decimal (1:1) Editable: No
FlowField
43 Sales Acc. on Disp. (Loss) (Sales Acc. on Disp. (Loss)) Code20
44 Book Val. Acc. on Disp. (Loss) (Book Val. Acc. on Disp. (Loss)) Code20

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Book Val. Acc. on Disp. (Loss) (Book Val. Acc. on Disp. (Loss)) G/L Account No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
FA Allocation Code (Code) 1..n
FA Depreciation Book FA Posting Group (FA Posting Group) 1..n
FA G/L Posting Buffer FA Posting Group (FA Posting Group) 1..n
FA Journal Line FA Posting Group (FA Posting Group) 1..n
FA Ledger Entry FA Posting Group (FA Posting Group) 1..n
FA Subclass Default FA Posting Group (Default FA Posting Group) 1..n
Fixed Asset FA Posting Group (FA Posting Group) 1..n
Gen. Journal Line Posting Group (Posting Group) 1..n
Maintenance Ledger Entry FA Posting Group (FA Posting Group) 1..n
Purch. Cr. Memo Line Posting Group (Posting Group) 1..n
Purch. Inv. Line Posting Group (Posting Group) 1..n
Purch. Rcpt. Line Posting Group (Posting Group) 1..n
Purchase Line Posting Group (Posting Group) 1..n
Purchase Line Archive Posting Group (Posting Group) 1..n
Return Receipt Line Posting Group (Posting Group) 1..n
Return Shipment Line Posting Group (Posting Group) 1..n
Sales Cr.Memo Line Posting Group (Posting Group) 1..n
Sales Invoice Line Posting Group (Posting Group) 1..n
Sales Line Posting Group (Posting Group) 1..n
Sales Line Archive Posting Group (Posting Group) 1..n
Sales Shipment Line Posting Group (Posting Group) 1..n
Standard General Journal Line Posting Group (Posting Group) 1..n