Diagrams


Table

Insurance

DynamicsDocs.comInsurance«Table 5628»InsuranceNo. [PK]Effective DateExpiration DatePolicy No.Annual PremiumPolicy CoverageTotal Value InsuredCommentInsurance TypeLast Date ModifiedInsurance Vendor No.FA Class CodeFA Subclass CodeFA Location CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeBlockedDescriptionSearch DescriptionDate FilterNo. Series«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 352»Default DimensionTable ID [PK,NN]No. [PK]Dimension Code [PK,NN]Dimension Value CodeValue Posting; [,Code Mandatory,Same C...Table CaptionMulti Selection Action; [,Change,Delet...«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 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 5629»Ins. Coverage Ledger EntryEntry No. [PK]Insurance No.Disposed FAFA No.FA DescriptionPosting DateDocument Type; [,Payment,Invoice,Credi...Document DateDocument No.External Document No.AmountDescriptionFA Class CodeFA Subclass CodeFA Location CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeUser IDSource CodeJournal Batch NameReason CodeIndex EntryNo. SeriesDimension Set ID«Table 5635»Insurance Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]Insurance No.FA No.FA DescriptionPosting DateDocument Type; [,,Invoice,Credit Memo]Document DateDocument No.External Document No.AmountDescriptionShortcut Dimension 1 CodeShortcut Dimension 2 CodeReason CodeSource CodeIndex EntryPosting No. SeriesDimension Set ID«Table 5650»Total Value InsuredFA No. [PK]Insurance No. [PK]DescriptionTotal Value Insured«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...«Table 97»Comment LineTable Name; [G/L Account,Customer,Vend...No. [PK]Line No. [PK]DateCodeComment«Table 5630»Insurance TypeCode [PK,NN]Description«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 5607»FA ClassCode [PK,NN]Name«Table 5608»FA SubclassCode [PK,NN]Name«Table 5609»FA LocationCode [PK,NN]Name«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Insurance Type><Insurance Vendor No.><FA Class Code><FA Subclass Code><FA Location Code><Global Dimension 1 Code><Global Dimension 2 Code><Location Code><No. Series><Insurance No.><Insurance No.><Insurance No.><No.><Insurance No.><Insurance No.><Insurance No.><Insurance No.><Insurance No.><Insurance No.><Insurance No.><Insurance No.><Insurance No.><No.><Buy-from Vendor No.><Pay-to Vendor No.><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Blanket Order Line No.><Buy-from Vendor No.><Pay-to Vendor No.><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Blanket Order Line No.><Buy-from Vendor No.><Pay-to Vendor No.><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Blanket Order Line No.><No.><Dimension Value Code><Buy-from Vendor No.><Pay-to Vendor No.><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Blanket Order Line No.><Blanket Order Line No.><Global Dimension 1 Code><Global Dimension 2 Code><Buy-from Vendor No.><Pay-to Vendor No.><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Posting No. Series><FA Class Code><FA Subclass Code><FA Location Code><Global Dimension 1 Code><Global Dimension 2 Code><Location Code><No. Series><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Posting No. Series><Buy-from Vendor No.><Pay-to Vendor No.><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Attached to Line No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Posting No. Series><No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Pay-to Vendor No.><No. Series><Location Code>

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

Fields

# Name Type
1 No. Code20
2 Effective Date Date
3 Expiration Date Date
4 Policy No. Text30
6 Annual Premium Decimal BlankZero: Yes
7 Policy Coverage Decimal BlankZero: Yes
10 Total Value Insured Decimal BlankZero: Yes
Editable: No
FlowField
11 Comment Boolean Editable: No
FlowField
12 Insurance Type Code10
13 Last Date Modified Date Editable: No
14 Insurance Vendor No. Code20
15 FA Class Code Code10
16 FA Subclass Code Code10
17 FA Location Code Code10
18 Global Dimension 1 Code Code20
19 Global Dimension 2 Code Code20
20 Location Code Code10
32 Blocked Boolean
33 Description Text50
34 Search Description Code50
35 Date Filter Date FlowFilter
36 No. Series Code10 Editable: No

Keys

# Fields
0 No. Clustered: Yes
1 Search Description

Table Relations To Other Tables

Field Related Table Related Field
Global Dimension 2 Code Dimension Value Code 1..n
FA Class Code FA Class Code 1..n
FA Location Code FA Location Code 1..n
FA Subclass Code FA Subclass Code 1..n
Insurance Type Insurance Type Code 1..n
Location Code Location 1..n
No. Series No. Series Code 1..n
Insurance Vendor No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
Comment Line No. 1..n
Default Dimension No. 1..n
FA Journal Line Insurance No. 1..n
Gen. Journal Line Insurance No. 1..n
Ins. Coverage Ledger Entry Insurance No. 1..n
Insurance Journal Line Insurance No. 1..n
Invoice Post. Buffer Insurance No. 1..n
Purch. Cr. Memo Line Insurance No. 1..n
Purch. Inv. Line Insurance No. 1..n
Purch. Rcpt. Line Insurance No. 1..n
Purchase Line Insurance No. 1..n
Purchase Line Archive Insurance No. 1..n
Return Shipment Line Insurance No. 1..n
Total Value Insured Insurance No. 1..n