Diagrams

Table

Standard Service Code

DynamicsDocs.comStandard Service Code«Table 5996»Standard Service CodeCode [PK,NN]DescriptionCurrency Code«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«Table 5998»Standard Service Item Gr. CodeService Item Group Code [PK]Code [PK,NN]Description«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...<Currency Code><Standard Service Code><Code>

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 Description (Description) Text50
3 Currency Code (Currency Code) Code10

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code (Currency Code) Currency Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Standard Service Item Gr. Code Code (Code) 1..n
Standard Service Line Standard Service Code (Standard Service Code) 1..n