Diagrams

Table

Standard Text

DynamicsDocs.comStandard Text«Table 7»Standard TextCode [PK,NN]Description«Table 1003»Job Planning LineLine No. [PK]Job No. [PK,NN]Planning DateDocument No.Type; [Resource,Item,G/L Account,Text]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeLast Date ModifiedUser IDWork Type CodeCustomer Price GroupCountry/Region CodeGen. Bus. Posting GroupGen. Prod. Posting GroupDocument DateJob Task No. [PK,NN]Line Amount [LCY]Unit CostTotal CostUnit PriceTotal PriceLine Amount...«Table 171»Standard Sales LineStandard Sales Code [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.DescriptionQuantityAmount Excl. VATUnit of Measure CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVariant CodeDimension Set ID«Table 174»Standard Purchase LineStandard Purchase Code [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.DescriptionQuantityAmount Excl. VATUnit of Measure CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVariant CodeDimension Set ID«Table 279»Extended Text HeaderTable Name; [Standard Text,G/L Account...No. [PK]Language Code [PK]Text No. [PK]Starting DateEnding DateAll Language CodesDescriptionSales QuoteSales InvoiceSales OrderSales Credit MemoPurchase QuotePurchase InvoicePurchase OrderPurchase Credit MemoReminderFinance Charge MemoSales Blanket OrderPurchase Blanket OrderPrepmt. Sales InvoicePrepmt. Sales Credit MemoPrepmt. Purchase InvoicePrepmt. Purchase Credit MemoService OrderService QuoteService InvoiceService Credit MemoSales Return OrderPurchase Return Order«Table 280»Extended Text LineTable Name; [Standard Text,G/L Account...No. [PK]Language Code [PK]Text No. [PK]Line No. [PK]Text«Table 296»Reminder LineReminder No. [PK]Line No. [PK,NN]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.No. of RemindersPosting DateDocument DateDue DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionOriginal AmountRemaining AmountNo.AmountInterest RateGen. Prod. Posting GroupVAT %VAT Calculation Type; [Normal VAT,Reve...VAT AmountTax Group CodeVAT Prod. Posting GroupVAT IdentifierLine Type; [Reminder Line,Not Due,Begi...VAT Clause CodeApplies-to Document Type; [,Payment,In...Applies-to Document No.System-Created Entry«Table 298»Issued Reminder LineReminder No. [PK]Line No. [PK]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.No. of RemindersPosting DateDocument DateDue DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionOriginal AmountRemaining AmountNo.AmountInterest RateGen. Prod. Posting GroupVAT %VAT Calculation Type; [Normal VAT,Reve...VAT AmountTax Group CodeVAT Prod. Posting GroupVAT IdentifierLine Type; [Reminder Line,Not Due,Begi...VAT Clause CodeApplies-To Document Type; [,Payment,In...Applies-To Document No.System-Created Entry«Table 303»Finance Charge Memo LineFinance Charge Memo No. [PK]Line No. [PK,NN]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.Posting DateDocument DateDue DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionOriginal AmountRemaining AmountNo.AmountInterest RateGen. Prod. Posting GroupVAT %VAT Calculation Type; [Normal VAT,Reve...VAT AmountTax Group CodeVAT Prod. Posting GroupVAT IdentifierLine Type; [Finance Charge Memo Line,B...VAT Clause CodeSystem-Created Entry«Table 305»Issued Fin. Charge Memo LineFinance Charge Memo No. [PK]Line No. [PK]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.Posting DateDocument DateDue DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionOriginal AmountRemaining AmountNo.AmountInterest RateGen. Prod. Posting GroupVAT %VAT Calculation Type; [Normal VAT,Reve...VAT AmountTax Group CodeVAT Prod. Posting GroupVAT IdentifierVAT Clause CodeSystem-Created Entry«Table 427»IC Outbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Shipment No.Shipment Line No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Delivery DatePromised Delivery DateReturn Receipt No.Return Receipt Line No.«Table 429»IC Outbox Purchase LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Receipt DatePromised Receipt Date«Table 431»Handled IC Outbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Shipment No.Shipment Line No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Delivery DatePromised Delivery DateReturn Receipt No.Return Receipt Line No.«Table 433»Handled IC Outbox Purch. LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Rejected by Curre...Unit of Measure CodeRequested Receipt DatePromised Receipt Date«Table 435»IC Inbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Item Ref.; [Local Item No.,Cross Refer...Unit of Measure CodeRequested Delivery DatePromised Delivery Date«Table 437»IC Inbox Purchase LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Receipt No.Receipt Line No.Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Item Ref.; [Local Item No.,Cross Refer...Unit of Measure CodeRequested Receipt DatePromised Receipt DateReturn Shipment No.Return Shipment Line No.«Table 439»Handled IC Inbox Sales LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityUnit PriceLine Discount %Line Discount AmountAmount Including VATJob No.Drop ShipmentCurrency CodeVAT Base AmountLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Item Ref.; [Local Item No.,Cross Refer...Unit of Measure CodeRequested Delivery DatePromised Delivery Date«Table 441»Handled IC Inbox Purch. LineDocument Type; [Order,Invoice,Credit M...Document No.Line No. [PK]DescriptionQuantityDirect Unit CostLine Discount %Line Discount AmountAmount Including VATJob No.Indirect Cost %Receipt No.Receipt Line No.Drop ShipmentCurrency CodeVAT Base AmountUnit CostLine AmountIC Partner Ref. Type; [,G/L Account,It...IC Partner ReferenceIC Partner Code [PK]IC Transaction No. [PK]Transaction Source; [Returned by Partn...Unit of Measure CodeRequested Receipt DatePromised Receipt DateReturn Shipment No.Return Shipment Line No.«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 5902»Service LineDocument Type; [Quote,Order,Invoice,Cr...Customer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 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 CodeCustomer Price Group...«Table 5907»Service Ledger EntryEntry No. [PK]Service Contract No.Document Type; [,Payment,Invoice,Credi...Document No.Serv. Contract Acc. Gr. CodeDocument Line No.Moved from Prepaid Acc.Posting DateAmount [LCY]Customer No.Ship-to CodeItem No. [Serviced]Serial No. [Serviced]User IDContract Invoice PeriodGlobal Dimension 1 CodeGlobal Dimension 2 CodeService Item No. [Serviced]Variant Code [Serviced]Contract Group CodeType; [,Resource,Item,Service Cost,Ser...No.Cost AmountDiscount AmountUnit CostQuantityCharged Qty.Unit PriceDiscount %Contract Disc. AmountBill-to Customer No....«Table 5908»Warranty Ledger EntryEntry No. [PK]Document No.Posting DateCustomer No.Ship-to CodeBill-to Customer No.Variant Code [Serviced]Service Item No. [Serviced]Item No. [Serviced]Serial No. [Serviced]Service Item Group [Serviced]Service Order No.Service Contract No.Fault Reason CodeFault Area CodeFault CodeSymptom CodeResolution CodeType; [,Item,Resource,Service Cost]No.QuantityWork Type CodeUnit of Measure CodeAmountDescriptionGen. Bus. Posting GroupGen. Prod. Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeOpenVendor No....«Table 5911»Service Mgt. SetupPrimary Key [PK]Fault Reporting Level; [None,Fault,Fau...Link Service to Service ItemSalesperson MandatoryWarranty Disc. % [Parts]Warranty Disc. % [Labor]Contract Rsp. Time MandatoryService Order Starting FeeRegister Contract ChangesContract Inv. Line Text CodeContract Line Inv. Text CodeContract Inv. Period Text CodeContract Credit Line Text CodeSend First Warning ToSend Second Warning ToSend Third Warning ToFirst Warning Within [Hours]Second Warning Within [Hours]Third Warning Within [Hours]Next Service Calc. Method; [Planned,Ac...Service Order Type MandatoryService Zones Option; [Code Shown,Warn...Service Order Start MandatoryService Order Finish MandatoryResource Skills Option; [Code Shown,Wa...One Service Item Line/OrderUnit of Measure MandatoryFault Reason Code MandatoryContract Serv. Ord. Max. DaysLast Contract Service DateWork Type Code Mandatory...«Table 5965»Service Contract HeaderContract No. [PK]Contract Type; [Quote,Contract] [PK]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...«Table 5968»Service Contract TemplateNo. [PK]DescriptionInvoice Period; [Month,Two Months,Quar...Max. Labor Unit PriceCombine InvoicesPrepaidService Zone CodeLanguage CodeDefault Response Time [Hours]Contract Lines on InvoiceDefault Service PeriodInvoice after ServiceAllow Unbalanced AmountsContract Group CodeService Order TypeAutomatic Credit MemosNo. SeriesPrice Update PeriodPrice Inv. Increase CodeServ. Contract Acc. Gr. Code«Table 5970»Filed Service Contract HeaderContract No.Contract Type; [Quote,Contract]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...«Table 5991»Service Shipment LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 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 GroupWork Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No.Order Line No.Bill-to Customer No....«Table 5993»Service Invoice LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 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 GroupWork Type CodeShipment No.Shipment Line No.Bill-to Customer No....«Table 5995»Service Cr.Memo LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Bill-to Customer No.Inv. Discount AmountGen. Bus. Posting Group...«Table 5997»Standard Service LineStandard Service Code [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.DescriptionQuantityAmount Excl. VATUnit of Measure CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVariant CodeDimension Set ID<No.><No.><No.><No.><No.><No.><No.><No.><No.><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><IC Partner Reference><No.><No.><No.><No.><No.><Contract Inv. Line Text Code><Contract Line Inv. Text Code><Contract Inv. Period Text Code><Contract Credit Line Text Code><Price Inv. Increase Code><Price Inv. Increase Code><Price Inv. Increase Code><No.><No.><No.><No.><Attached to Line No.><Attached to Line No.><Attached to Line No.><Attached to Line No.><Attached to Line No.><Service Contract No.><Attached to Line No.><Attached to Line No.><Contract No.><Service Contract No.><No.><Service Contract No.><Contract No. Relation><Contract No.><Contract No.><Contract 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 (Code) Code20 NotBlank: Yes
2 Description (Description) Text50

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Extended Text Header No. (No.) 1..n
Extended Text Line No. (No.) 1..n
Filed Service Contract Header Price Inv. Increase Code (Price Inv. Increase Code) 1..n
Finance Charge Memo Line No. (No.) 1..n
Handled IC Inbox Purch. Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Inbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Outbox Purch. Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Outbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
IC Inbox Purchase Line IC Partner Reference (IC Partner Reference) 1..n
IC Inbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
IC Outbox Purchase Line IC Partner Reference (IC Partner Reference) 1..n
IC Outbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
Issued Fin. Charge Memo Line No. (No.) 1..n
Issued Reminder Line No. (No.) 1..n
Job Planning Line No. (No.) 1..n
Purchase Line Archive No. (No.) 1..n
Reminder Line No. (No.) 1..n
Sales Line Archive No. (No.) 1..n
Service Contract Header Price Inv. Increase Code (Price Inv. Increase Code) 1..n
Service Contract Template Price Inv. Increase Code (Price Inv. Increase Code) 1..n
Service Cr.Memo Line No. (No.) 1..n
Service Invoice Line No. (No.) 1..n
Service Ledger Entry No. (No.) 1..n
Service Line No. (No.) 1..n
Service Mgt. Setup Contract Credit Line Text Code (Contract Credit Line Text Code) 1..n
Service Shipment Line No. (No.) 1..n
Standard Purchase Line No. (No.) 1..n
Standard Sales Line No. (No.) 1..n
Standard Service Line No. (No.) 1..n
Warranty Ledger Entry No. (No.) 1..n