Diagrams


Table

Service Line

DynamicsDocs.comService Line«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 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 5900»Service HeaderDocument Type; [Quote,Order,Invoice,Cr...Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 7»Standard TextCode [PK,NN]Description«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....«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 5905»Service CostCode [PK,NN]DescriptionAccount No.Default Unit PriceDefault QuantityUnit of Measure CodeCost Type; [Travel,Support,Other]Service Zone CodeDefault Unit Cost«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 94»Inventory Posting GroupCode [PK,NN]Description«Table 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 1001»Job TaskJob No. [PK,NN]Job Task No. [PK,NN]DescriptionJob Task Type; [Posting,Heading,Total,...WIP-Total; [,Total,Excluded]Job Posting GroupWIP MethodSchedule [Total Cost]Schedule [Total Price]Usage [Total Cost]Usage [Total Price]Contract [Total Cost]Contract [Total Price]Contract [Invoiced Price]Contract [Invoiced Cost]Posting Date FilterPlanning Date FilterTotalingNew PageNo. of Blank LinesIndentationRecognized Sales AmountRecognized Costs AmountRecognized Sales G/L AmountRecognized Costs G/L AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeOutstanding OrdersAmt. Rcd. Not InvoicedRemaining [Total Cost]Remaining [Total Price]...«Table 200»Work TypeCode [PK,NN]DescriptionUnit of Measure Code«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 258»Transaction TypeCode [PK,NN]Description«Table 259»Transport MethodCode [PK,NN]Description«Table 282»Entry/Exit PointCode [PK,NN]Description«Table 285»Transaction SpecificationCode [PK,NN]Text«Table 318»Tax AreaCode [PK,NN]Description«Table 321»Tax GroupCode [PK,NN]Description«Table 560»VAT ClauseCode [PK,NN]DescriptionDescription 2«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 950»Time Sheet HeaderNo. [PK]Starting DateEnding DateResource No.Owner User IDApprover User IDOpen ExistsSubmitted ExistsRejected ExistsApproved ExistsPosted ExistsQuantityPosted QuantityCommentStatus Filter; [Open,Submitted,Rejecte...Job No. FilterJob Task No. FilterDate FilterPosted FilterType Filter; [,Resource,Job,Service,Ab...«Table 951»Time Sheet LineTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 952»Time Sheet DetailTime Sheet No. [PK]Time Sheet Line No. [PK]Date [PK]Type; [,Resource,Job,Service,Absence,A...Resource No.Job No.Job Task No.Cause of Absence CodeService Order No.Service Order Line No.QuantityPosted QuantityAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Posted«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 7302»Bin ContentLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Bin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Bin RankingQuantityPick Qty.Neg. Adjmt. Qty.Put-away Qty.Pos. Adjmt. Qty.FixedCross-Dock BinDefaultQuantity [Base]Pick Quantity [Base]Negative Adjmt. Qty. [Base]Put-away Quantity [Base]Positive Adjmt. Qty. [Base]ATO Components Pick Qty.ATO Components Pick Qty [Base]Variant Code [PK]Qty. per Unit of MeasureUnit of Measure Code [PK,NN]Lot No. FilterSerial No. FilterDedicated...«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 205»Resource Unit of MeasureResource No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureRelated to Base Unit of Meas.«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount«Table 5722»Item CategoryCode [PK,NN]Parent CategoryDescriptionIndentationPresentation OrderHas Children«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...«Table 5901»Service Item LineDocument No. [PK]Line No. [PK]Service Item No.Service Item Group CodeItem No.Serial No.DescriptionDescription 2Repair Status CodePriority; [Low,Medium,High]Response Time [Hours]Response DateResponse TimeStarting DateStarting TimeFinishing DateFinishing TimeService Shelf No.Warranty Starting Date [Parts]Warranty Ending Date [Parts]WarrantyWarranty % [Parts]Warranty % [Labor]Warranty Starting Date [Labor]Warranty Ending Date [Labor]Contract No.Location of Service ItemLoaner No.Vendor No.Vendor Item No.Fault Reason Code...«Table 6082»Service Price Adjustment GroupCode [PK,NN]Description«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«Table 6080»Service Price GroupCode [PK,NN]Description«Table 5915»Fault AreaCode [PK,NN]Description«Table 5916»Symptom CodeCode [PK,NN]Description«Table 5918»Fault CodeFault Area Code [PK]Symptom Code [PK]Code [PK,NN]Description«Table 5919»Resolution CodeCode [PK,NN]Description«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 5917»Fault Reason CodeCode [PK,NN]DescriptionExclude Warranty DiscountExclude Contract Discount«Table 6635»Return ReasonCode [PK,NN]DescriptionDefault Location CodeInventory Value Zero«Table 340»Customer Discount GroupCode [PK,NN]Description<Customer No.><Bill-to Customer No.><Document No.><No.><No.><No.><Replaced Item No.><No.><No.><Location Code><Posting Group><Customer Price Group><Job No.><Job Task No.><Work Type Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Transaction Type><Transport Method><Attached to Line No.><Exit Point><Transaction Specification><Tax Area Code><Tax Group Code><VAT Clause Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Time Sheet No.><Time Sheet Line No.><Time Sheet Date><Variant Code><Bin Code><Bin Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Responsibility Center><Item Category Code><Shipping Agent Code><Shipping Agent Service Code><Service Item No.><Replaced Item No.><Service Item Line No.><Serv. Price Adjmt. Gr. Code><Ship-to Code><Service Price Group Code><Fault Area Code><Symptom Code><Fault Code><Resolution Code><Contract No.><Fault Reason Code><Return Reason Code><Customer Disc. Group><Customer Price Group><Shipping Agent Code><Customer Disc. Group><Bill-to Customer No.><Location Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><Responsibility Center><Shipping Agent Service Code><Ship-to Filter><Customer No.><Bill-to Customer No.><Customer No.><Bill-to Customer No.><Customer Filter><Customer No.><Customer No.><Customer No.><Bill-to Customer No.><Ship-to Code><Location Code><Location Filter><Customer Price Group><Customer Disc. Group><Bal. Account No.><Gen. Bus. Posting Group><Transaction Type><Transport Method><Exit Point><Transaction Specification><Shipping Agent Code><Tax Area Code><VAT Bus. Posting Group><Responsibility Center><Shipping Agent Service Code><Contract No.><Contract Filter><Resource Filter><Document No.><Service Order Filter><Service Order Filter><Service Order No.><Service Order No.><Price Inv. Increase Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Account No.><Inventory Posting Group><Alternative Item No.><Location Filter><VAT Bus. Posting Gr. (Price)><Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item Category Code><Item No.><Item No.><Item Filter><Item No.><Base Unit of Measure><Unit of Measure Filter><Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><Person Responsible><Resource Filter><Resource No.><Resource Filter><Preferred Resource><Resource No.><Resource No.><Unit of Measure Code><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code><Location Code><Location Code><Default Location Code><Location Code><VAT Bus. Posting Gr. (Price)><Customer Price Group><Customer Disc. Group><Job No.><Job No.><Job No.><Job Task No.><Job Task No.><Unit of Measure Code><Work Type Code><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><Tax Area Code><Time Sheet No.><Time Sheet No.><Variant Code><Variant Code><Variant Code><Bin Code><Unit of Measure Code><Unit of Measure Filter><Code><Unit of Measure Code><Code><Unit of Measure Code><Responsibility Center><Responsibility Center><Parent Category><Shipping Agent Code><Shipping Agent Code><Shipping Agent Service Code><Ship-to Code><Service Price Group Code><Contract Filter><Service Item No.><Contract No.><Fault Reason Code><Service Price Group Code><Fault Area Code><Symptom Code><Fault Code><Resolution Code><Serv. Price Adjmt. Gr. Code><Ship-to Code><Ship-to Code><Fault Area Code><Symptom Code>

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

Fields

# Name Type
1 Document Type Option
2 Customer No. Code20 Editable: No
3 Document No. Code20
4 Line No. Integer
5 Type Option
6 No. Code20
7 Location Code Code10
8 Posting Group Code10 Editable: No
11 Description Text50
12 Description 2 Text50
13 Unit of Measure Text10
15 Quantity Decimal (0:5)
16 Outstanding Quantity Decimal (0:5) Editable: No
17 Qty. to Invoice Decimal (0:5)
18 Qty. to Ship Decimal (0:5)
22 Unit Price Decimal
23 Unit Cost (LCY) Decimal
25 VAT % Decimal (0:5) Editable: No
27 Line Discount % Decimal (0:5)
28 Line Discount Amount Decimal
29 Amount Decimal Editable: No
30 Amount Including VAT Decimal Editable: No
32 Allow Invoice Disc. Boolean
34 Gross Weight Decimal (0:5)
35 Net Weight Decimal (0:5)
36 Units per Parcel Decimal (0:5)
37 Unit Volume Decimal (0:5)
38 Appl.-to Item Entry Integer
40 Shortcut Dimension 1 Code Code20
41 Shortcut Dimension 2 Code Code20
42 Customer Price Group Code10 Editable: No
45 Job No. Code20
46 Job Task No. Code20
47 Job Line Type Option
52 Work Type Code Code10
57 Outstanding Amount Decimal Editable: No
58 Qty. Shipped Not Invoiced Decimal (0:5) Editable: No
59 Shipped Not Invoiced Decimal Editable: No
60 Quantity Shipped Decimal (0:5) Editable: No
61 Quantity Invoiced Decimal (0:5) Editable: No
63 Shipment No. Code20
64 Shipment Line No. Integer Editable: No
68 Bill-to Customer No. Code20 Editable: No
69 Inv. Discount Amount Decimal Editable: No
74 Gen. Bus. Posting Group Code10
75 Gen. Prod. Posting Group Code10
77 VAT Calculation Type Option Editable: No
78 Transaction Type Code10
79 Transport Method Code10
80 Attached to Line No. Integer Editable: No
81 Exit Point Code10
82 Area Code10
83 Transaction Specification Code10
85 Tax Area Code Code20
86 Tax Liable Boolean
87 Tax Group Code Code10
88 VAT Clause Code Code10
89 VAT Bus. Posting Group Code10
90 VAT Prod. Posting Group Code10
91 Currency Code Code10 Editable: No
92 Outstanding Amount (LCY) Decimal Editable: No
93 Shipped Not Invoiced (LCY) Decimal Editable: No
95 Reserved Quantity Decimal (0:5) Editable: No
FlowField
96 Reserve Option
99 VAT Base Amount Decimal Editable: No
100 Unit Cost Decimal Editable: No
101 System-Created Entry Boolean Editable: No
103 Line Amount Decimal
104 VAT Difference Decimal Editable: No
105 Inv. Disc. Amount to Invoice Decimal Editable: No
106 VAT Identifier Code10 Editable: No
480 Dimension Set ID Integer Editable: No
950 Time Sheet No. Code20
951 Time Sheet Line No. Integer
952 Time Sheet Date Date
1019 Job Planning Line No. Integer BlankZero: Yes
1030 Job Remaining Qty. Decimal (0:5)
1031 Job Remaining Qty. (Base) Decimal
1032 Job Remaining Total Cost Decimal Editable: No
1033 Job Remaining Total Cost (LCY) Decimal Editable: No
1034 Job Remaining Line Amount Decimal Editable: No
5402 Variant Code Code10
5403 Bin Code Code20
5404 Qty. per Unit of Measure Decimal (0:5) Editable: No
5405 Planned Boolean Editable: No
5407 Unit of Measure Code Code10
5415 Quantity (Base) Decimal (0:5)
5416 Outstanding Qty. (Base) Decimal (0:5) Editable: No
5417 Qty. to Invoice (Base) Decimal (0:5)
5418 Qty. to Ship (Base) Decimal (0:5)
5458 Qty. Shipped Not Invd. (Base) Decimal (0:5) Editable: No
5460 Qty. Shipped (Base) Decimal (0:5) Editable: No
5461 Qty. Invoiced (Base) Decimal (0:5) Editable: No
5495 Reserved Qty. (Base) Decimal (0:5) Editable: No
FlowField
5700 Responsibility Center Code10 Editable: No
5702 Substitution Available Boolean Editable: No
FlowField
5709 Item Category Code Code20
5710 Nonstock Boolean Editable: No
5712 Product Group Code Code10
5750 Whse. Outstanding Qty. (Base) Decimal BlankZero: Yes
Editable: No
FlowField
5752 Completely Shipped Boolean Editable: No
5790 Requested Delivery Date Date
5791 Promised Delivery Date Date
5792 Shipping Time DateFormula
5794 Planned Delivery Date Date
5796 Shipping Agent Code Code10
5797 Shipping Agent Service Code Code10
5811 Appl.-from Item Entry Integer
5902 Service Item No. Code20
5903 Appl.-to Service Entry Integer Editable: No
5904 Service Item Line No. Integer
5905 Service Item Serial No. Code20
5906 Service Item Line Description Text50 Editable: No
FlowField
5907 Serv. Price Adjmt. Gr. Code Code10 Editable: No
5908 Posting Date Date
5909 Order Date Date Editable: No
5910 Needed by Date Date
5916 Ship-to Code Code10 Editable: No
5917 Qty. to Consume Decimal (0:5) BlankZero: Yes
5918 Quantity Consumed Decimal (0:5) Editable: No
5919 Qty. to Consume (Base) Decimal (0:5) BlankZero: Yes
5920 Qty. Consumed (Base) Decimal (0:5) Editable: No
5928 Service Price Group Code Code10
5929 Fault Area Code Code10
5930 Symptom Code Code10
5931 Fault Code Code10
5932 Resolution Code Code10
5933 Exclude Warranty Boolean Editable: Yes
5934 Warranty Boolean Editable: No
5936 Contract No. Code20
5938 Contract Disc. % Decimal (0:5) Editable: No
5939 Warranty Disc. % Decimal (0:5) Editable: No
5965 Component Line No. Integer
5966 Spare Part Action Option
5967 Fault Reason Code Code10
5968 Replaced Item No. Code20
5969 Exclude Contract Discount Boolean Editable: Yes
5970 Replaced Item Type Option
5994 Price Adjmt. Status Option Editable: No
5997 Line Discount Type Option Editable: No
5999 Copy Components From Option
6608 Return Reason Code Code10
7001 Allow Line Disc. Boolean
7002 Customer Disc. Group Code20
7300 Qty. Picked Decimal (0:5) Editable: No
7301 Qty. Picked (Base) Decimal (0:5) Editable: No
7302 Completely Picked Boolean Editable: No
7303 Pick Qty. (Base) Decimal (0:5) Editable: No

Keys

# Fields
0 Document Type,Document No.,Line No. Clustered: Yes
1 Type,No.,Order Date
2 Service Item No.,Type,Posting Date
3 Document Type,Bill-to Customer No.,Currency Code
4 Document Type,Document No.,Service Item No.
5 Document Type,Document No.,Service Item Line No.,Serv. Price Adjmt. Gr. Code
6 Document Type,Document No.,Service Item Line No.,Type,No.
7 Type,No.,Variant Code,Location Code,Needed by Date,Document Type,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code
8 Appl.-to Service Entry
9 Document Type,Document No.,Service Item Line No.,Component Line No.
10 Fault Reason Code
11 Document Type,Customer No.,Shipment No.
12 Document Type,Document No.,Location Code
13 Document Type,Document No.,Type,No.

Table Relations To Other Tables

Field Related Table Related Field
Area Area Code 1..n
Bin Code Bin Code 1..n
Bin Code Bin Content Bin Code 1..n
Currency Code Currency Code 1..n
Bill-to Customer No. Customer No. 1..n
Customer Disc. Group Customer Discount Group Code 1..n
Customer Price Group Customer Price Group Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Exit Point Entry/Exit Point Code 1..n
Fault Area Code Fault Area Code 1..n
Fault Code Fault Code Code 1..n
Fault Reason Code Fault Reason Code Code 1..n
No. G/L Account No. 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Posting Group Inventory Posting Group Code 1..n
Replaced Item No. Item No. 1..n
Item Category Code Item Category Code 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Job No. Job No. 1..n
Job Task No. Job Task Job Task No. 1..n
Location Code Location Code 1..n
Resolution Code Resolution Code Code 1..n
No. Resource No. 1..n
Unit of Measure Code Resource Unit of Measure Code 1..n
Responsibility Center Responsibility Center Code 1..n
Return Reason Code Return Reason Code 1..n
Contract No. Service Contract Header Contract No. 1..n
No. Service Cost Code 1..n
Document No. Service Header No. 1..n
Replaced Item No. Service Item No. 1..n
Service Item Line No. Service Item Line Line No. 1..n
Attached to Line No. Service Line Line No. 1..n
Serv. Price Adjmt. Gr. Code Service Price Adjustment Group Code 1..n
Service Price Group Code Service Price Group Code 1..n
Ship-to Code Ship-to Address Code 1..n
Shipping Agent Code Shipping Agent Code 1..n
Shipping Agent Service Code Shipping Agent Services Code 1..n
No. Standard Text Code 1..n
Symptom Code Symptom Code Code 1..n
Tax Area Code Tax Area Code 1..n
Tax Group Code Tax Group Code 1..n
Time Sheet Date Time Sheet Detail Date 1..n
Time Sheet No. Time Sheet Header No. 1..n
Time Sheet Line No. Time Sheet Line Line No. 1..n
Transaction Specification Transaction Specification Code 1..n
Transaction Type Transaction Type Code 1..n
Transport Method Transport Method Code 1..n
Unit of Measure Code Unit of Measure Code 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
VAT Clause Code VAT Clause Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n
Work Type Code Work Type Code 1..n

Table Relations From Other Tables

From Table From Field
Service Line Attached to Line No. 1..n