Table 6012 "Service Line Archive"

Base Application · Microsoft.Service.Archive · BC25-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Service Line Archive
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Document Type	Enum “Service Document Type”	—	enum Enum 5900 “Service Document Type”
2	Customer No.	Code[20]	—	TableRelation Table 18 “Customer”; not editable
3	Document No.	Code[20]	—	TableRelation Table 6010 “Service Header Archive” (“Service Header Archive”.“No.” where(“Document Type” = field(“Document Type”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”)))
4	Line No.	Integer	—
5	Type Δ BC28	Enum “Service Line Type”	Specifies the type of the service line.	enum Enum 5902 “Service Line Type”
6	No. Δ BC28	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.	TableRelation Table 15 “G/L Account”, Table 156 “Resource”, Table 27 “Item” (if (Type = const(” “)) “Standard Text” else if (Type = const(“G/L Account”)) “G/L Account” else if (Type = const(Item)) Item else if (Type = const(Resource)) Resource else if (Type = const(Cost)) “Service Cost”)
7	Location Code Δ BC28	Code[10]	Specifies the inventory location from where the items on the line should be taken and where they should be registered.	TableRelation Table 14 “Location”
8	Posting Group Δ BC28	Code[20]	Specifies the inventory posting group assigned to the item.	TableRelation Table 94 “Inventory Posting Group” (if (Type = const(Item)) “Inventory Posting Group”); not editable
11	Description Δ BC28	Text[100]	Specifies the description of an item, resource, cost, or a standard text on the line.
12	Description 2 Δ BC28	Text[50]	Specifies an additional description of the item, resource, or cost.
13	Unit of Measure	Text[50]	—
15	Quantity Δ BC28	Decimal	Specifies the number of item units, resource hours, cost on the service line.
16	Outstanding Quantity Δ BC28	Decimal	—	not editable
17	Qty. to Invoice Δ BC28	Decimal	—
18	Qty. to Ship Δ BC28	Decimal	—
22	Unit Price Δ BC28	Decimal	Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card.
23	Unit Cost (LCY) Δ BC28	Decimal	Specifies the cost, in LCY, of one unit of the item or resource on the line. via Page 6275 “Service Quote Archive Lines”
25	VAT % Δ BC28	Decimal	Specifies the VAT percentage used to calculate Amount Including VAT on this line.	not editable
27	Line Discount % Δ BC28	Decimal	Specifies the discount percentage that is granted for the item on the line.
28	Line Discount Amount Δ BC28	Decimal	Specifies the discount amount that is granted for the item on the line.
29	Amount	Decimal	—	not editable
30	Amount Including VAT Δ BC28	Decimal	Specifies the net amount, including VAT, for this line.	not editable
32	Allow Invoice Disc. Δ BC28	Boolean	Specifies if the invoice line is included when the invoice discount is calculated.
34	Gross Weight Δ BC28	Decimal	—
35	Net Weight Δ BC28	Decimal	—
36	Units per Parcel Δ BC28	Decimal	—
37	Unit Volume Δ BC28	Decimal	—
38	Appl.-to Item Entry	Integer	—
40	Shortcut Dimension 1 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
41	Shortcut Dimension 2 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
42	Customer Price Group	Code[10]	—	TableRelation Table 6 “Customer Price Group” (Customer Price Group); not editable
45	Job No. Δ BC28	Code[20]	Project No. caption	TableRelation Job.“No.”
46	Job Task No.	Code[20]	Project Task No. caption	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
47	Job Line Type	Enum “Job Line Type”	Project Line Type caption	enum Enum 1002 “Job Line Type”
52	Work Type Code Δ BC28	Code[10]	Specifies a code for the type of work performed by the resource registered on this line.	TableRelation Table 200 “Work Type” (Work Type)
57	Outstanding Amount	Decimal	—	not editable
58	Qty. Shipped Not Invoiced Δ BC28	Decimal	—	not editable
59	Shipped Not Invoiced	Decimal	—	not editable
60	Quantity Shipped Δ BC28	Decimal	—	not editable
61	Quantity Invoiced Δ BC28	Decimal	—	not editable
63	Shipment No.	Code[20]	—
64	Shipment Line No.	Integer	—	not editable
65	Order No.	Code[20]	—
68	Bill-to Customer No.	Code[20]	—	TableRelation Table 18 “Customer”; not editable
69	Inv. Discount Amount Δ BC28	Decimal	Specifies the total calculated invoice discount amount for the line.	not editable
74	Gen. Bus. Posting Group Δ BC28	Code[20]	Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
75	Gen. Prod. Posting Group Δ BC28	Code[20]	Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
77	VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”; not editable
78	Transaction Type	Code[10]	—	TableRelation Table 258 “Transaction Type” (Transaction Type)
79	Transport Method	Code[10]	—	TableRelation Table 259 “Transport Method” (Transport Method)
80	Attached to Line No.	Integer	—	TableRelation Table 6012 “Service Line Archive” (“Service Line Archive”.“Line No.” where(“Document Type” = field(“Document Type”), “Document No.” = field(“Document No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”))); not editable
81	Exit Point	Code[10]	—	TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
82	Area	Code[10]	—	TableRelation Table 284 “Area”
83	Transaction Specification	Code[10]	—	TableRelation Table 285 “Transaction Specification” (Transaction Specification)
85	Tax Area Code	Code[20]	—	TableRelation Table 318 “Tax Area” (Tax Area)
86	Tax Liable	Boolean	—
87	Tax Group Code	Code[20]	—	TableRelation Table 321 “Tax Group” (Tax Group)
88	VAT Clause Code	Code[20]	—	TableRelation Table 560 “VAT Clause” (VAT Clause)
89	VAT Bus. Posting Group	Code[20]	—	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
90	VAT Prod. Posting Group	Code[20]	—	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
91	Currency Code	Code[10]	—	TableRelation Table 4 “Currency”; not editable
92	Outstanding Amount (LCY) Δ BC28	Decimal	—	not editable
93	Shipped Not Invoiced (LCY) Δ BC28	Decimal	—	not editable
96	Reserve	Enum “Reserve Method”	—	enum Enum 100 “Reserve Method”
99	VAT Base Amount Δ BC28	Decimal	Specifies the amount that serves as a base for calculating the Amount Including VAT field.	not editable
100	Unit Cost	Decimal	—	not editable
101	System-Created Entry	Boolean	—	not editable
103	Line Amount Δ BC28	Decimal	Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
104	VAT Difference	Decimal	—	not editable
105	Inv. Disc. Amount to Invoice	Decimal	—	not editable
106	VAT Identifier	Code[20]	—	not editable
145	Pmt. Discount Amount	Decimal	—
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
950	Time Sheet No.	Code[20]	—	TableRelation Table 950 “Time Sheet Header” (Time Sheet Header)
951	Time Sheet Line No.	Integer	—	TableRelation Table 951 “Time Sheet Line” (“Time Sheet Line”.“Line No.” where(“Time Sheet No.” = field(“Time Sheet No.”)))
952	Time Sheet Date	Date	—	TableRelation Table 952 “Time Sheet Detail” (“Time Sheet Detail”.Date where(“Time Sheet No.” = field(“Time Sheet No.”), “Time Sheet Line No.” = field(“Time Sheet Line No.”)))
1019	Job Planning Line No.	Integer	Project Planning Line No. caption
1030	Job Remaining Qty. Δ BC28	Decimal	Project Remaining Qty. caption
1031	Job Remaining Qty. (Base) Δ BC28	Decimal	Project Remaining Qty. (Base) caption
1032	Job Remaining Total Cost	Decimal	Project Remaining Total Cost caption	not editable
1033	Job Remaining Total Cost (LCY) Δ BC28	Decimal	Project Remaining Total Cost (LCY) caption	not editable
1034	Job Remaining Line Amount	Decimal	Project Remaining Line Amount caption	not editable
5047	Version No.	Integer	—
5048	Doc. No. Occurrence	Integer	—
5402	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”)))
5403	Bin Code	Code[20]	—	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”)))
5404	Qty. per Unit of Measure Δ BC28	Decimal	—	not editable
5405	Planned	Boolean	—	not editable
5407	Unit of Measure Code Δ BC28	Code[10]	Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.	TableRelation Table 204 “Unit of Measure”, Table 205 “Resource Unit of Measure”, Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else if (Type = const(Resource)) “Resource Unit of Measure”.Code where(“Resource No.” = field(“No.”)) else “Unit of Measure”)
5408	Qty. Rounding Precision Δ BC28	Decimal	—	not editable
5409	Qty. Rounding Precision (Base) Δ BC28	Decimal	—	not editable
5415	Quantity (Base) Δ BC28	Decimal	—
5416	Outstanding Qty. (Base) Δ BC28	Decimal	—	not editable
5417	Qty. to Invoice (Base) Δ BC28	Decimal	—
5418	Qty. to Ship (Base) Δ BC28	Decimal	—
5458	Qty. Shipped Not Invd. (Base) Δ BC28	Decimal	—	not editable
5460	Qty. Shipped (Base) Δ BC28	Decimal	—	not editable
5461	Qty. Invoiced (Base) Δ BC28	Decimal	—	not editable
5700	Responsibility Center	Code[10]	—	TableRelation Table 5714 “Responsibility Center” (Responsibility Center); not editable
5709	Item Category Code	Code[20]	—	TableRelation Table 5722 “Item Category” (Item Category)
5710	Nonstock Δ BC28	Boolean	Specifies that the item is a catalog item.	not editable
5725	Item Reference No.	Code[50]	—
5726	Item Reference Unit of Measure	Code[10]	Reference Unit of Measure caption	TableRelation Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)))
5727	Item Reference Type	Enum “Item Reference Type”	—	enum Enum 5726 “Item Reference Type”
5728	Item Reference Type No.	Code[30]	—
5752	Completely Shipped	Boolean	—	not editable
5790	Requested Delivery Date	Date	—
5791	Promised Delivery Date	Date	—
5792	Shipping Time	DateFormula	—
5794	Planned Delivery Date	Date	—
5796	Shipping Agent Code	Code[10]	—	TableRelation Table 291 “Shipping Agent” (Shipping Agent)
5797	Shipping Agent Service Code	Code[10]	—	TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”)))
5811	Appl.-from Item Entry	Integer	—
5902	Service Item No. Δ BC28	Code[20]	Specifies the service item number linked to this service line.	TableRelation Table 5940 “Service Item” (“Service Item”.“No.”)
5903	Appl.-to Service Entry	Integer	—	not editable
5904	Service Item Line No. Δ BC28	Integer	Specifies the service item line number linked to this service line.	TableRelation Table 6011 “Service Item Line Archive” (“Service Item Line Archive”.“Line No.” where(“Document Type” = field(“Document Type”), “Document No.” = field(“Document No.”), “Doc. No. Occurrence” = field(“Doc. No. Occurrence”), “Version No.” = field(“Version No.”)))
5905	Service Item Serial No. Δ BC28	Code[50]	Specifies the service item serial number linked to this line.
5906	Service Item Line Description Δ BC28	Text[100]	Specifies the description of the service item line in the service order.	not editable
5907	Serv. Price Adjmt. Gr. Code Δ BC28	Code[10]	Specifies the service price adjustment group code that applies to this line.	TableRelation Table 6082 “Service Price Adjustment Group” (Service Price Adjustment Group); not editable
5908	Posting Date Δ BC28	Date	Specifies the date when the service line should be posted.
5909	Order Date	Date	—	not editable
5910	Needed by Date	Date	—
5916	Ship-to Code	Code[10]	—	TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Customer No.”))); not editable
5917	Qty. to Consume Δ BC28	Decimal	—
5918	Quantity Consumed Δ BC28	Decimal	—	not editable
5919	Qty. to Consume (Base) Δ BC28	Decimal	—
5920	Qty. Consumed (Base) Δ BC28	Decimal	—	not editable
5928	Service Price Group Code	Code[10]	—	TableRelation Table 6080 “Service Price Group” (Service Price Group)
5929	Fault Area Code Δ BC28	Code[10]	Specifies the code of the fault area associated with this line.	TableRelation Table 5915 “Fault Area” (Fault Area)
5930	Symptom Code Δ BC28	Code[10]	Specifies the code of the symptom associated with this line.	TableRelation Table 5916 “Symptom Code” (Symptom Code)
5931	Fault Code Δ BC28	Code[10]	Specifies the code of the fault associated with this line.	TableRelation Table 5918 “Fault Code” (“Fault Code”.Code where(“Fault Area Code” = field(“Fault Area Code”), “Symptom Code” = field(“Symptom Code”)))
5932	Resolution Code Δ BC28	Code[10]	Specifies the code of the resolution associated with this line.	TableRelation Table 5919 “Resolution Code” (Resolution Code)
5933	Exclude Warranty Δ BC28	Boolean	Specifies that the warranty discount is excluded on this line.
5934	Warranty Δ BC28	Boolean	Specifies that a warranty discount is available on this line of type Item or Resource.	not editable
5936	Contract No. Δ BC28	Code[20]	Specifies the number of the contract, if the service quote originated from a service contract.	TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract)))
5938	Contract Disc. % Δ BC28	Decimal	Specifies the contract discount percentage that is valid for the items, resources, and costs on this line.	not editable
5939	Warranty Disc. % Δ BC28	Decimal	Specifies the percentage of the warranty discount that is valid for the items or resources on this line.	not editable
5965	Component Line No.	Integer	—
5966	Spare Part Action	Option	—	OptionCaption: ,Permanent,Temporary,Component Replaced,Component Installed
5967	Fault Reason Code Δ BC28	Code[10]	Specifies the code of the fault reason for this service line.	TableRelation Table 5917 “Fault Reason Code” (Fault Reason Code)
5968	Replaced Item No.	Code[20]	—	TableRelation Table 27 “Item”, Table 5940 “Service Item” (if (“Replaced Item Type” = const(Item)) Item else if (“Replaced Item Type” = const(“Service Item”)) “Service Item”)
5969	Exclude Contract Discount Δ BC28	Boolean	Specifies that the contract discount is excluded for the item, resource, or cost on this line.
5970	Replaced Item Type	Enum “Replaced Service Item Component Type”	—	enum Enum 5943 “Replaced Service Item Component Type”
5994	Price Adjmt. Status	Option	—	OptionCaption: ,Adjusted,Modified; not editable
5997	Line Discount Type Δ BC28	Option	Specifies the type of the line discount assigned to this line.	OptionCaption: ,Warranty Disc.,Contract Disc.,Line Disc.,Manual; not editable
5999	Copy Components From	Option	—	OptionCaption: None,Item BOM,Old Service Item,Old Serv.Item w/o Serial No.
6608	Return Reason Code	Code[10]	—	TableRelation Table 6635 “Return Reason” (Return Reason)
7000	Price Calculation Method	Enum “Price Calculation Method”	—	enum Enum 7000 “Price Calculation Method”
7001	Allow Line Disc.	Boolean	—
7002	Customer Disc. Group	Code[20]	—	TableRelation Table 340 “Customer Discount Group” (Customer Discount Group)
7300	Qty. Picked Δ BC28	Decimal	—	not editable
7301	Qty. Picked (Base) Δ BC28	Decimal	—	not editable
7302	Completely Picked	Boolean	—	not editable
7303	Pick Qty. (Base) Δ BC28	Decimal	—	not editable

Keys

Key1: Document Type, Document No., Doc. No. Occurrence, Version No., Line No. (clustered)
Key2: Document Type, Document No., Line No., Doc. No. Occurrence, Version No.
Key3: Customer No.
Key4: Bill-to Customer No.
Key5: Type, No.
Key6: Document No., Document Type, Doc. No. Occurrence, Version No.

Trigger event subscribers

OnBeforeInsertEvent: Codeunit 5999 “Service Experience Tier” BlockInsertServiceLineArchive

Procedures

ShowLineComments()
ShowDimensions()
GetCaptionClass(FieldNumber: Integer): Text[80]

Plus 1 local procedures.

Triggers

OnDelete

Relations

Job Task No.: TableRelation Table 1001 “Job Task”
Location Code: TableRelation Table 14 “Location”
No.: TableRelation Table 15 “G/L Account” (conditional)
No.: TableRelation Table 156 “Resource” (conditional)
Bill-to Customer No.: TableRelation Table 18 “Customer”
Customer No.: TableRelation Table 18 “Customer”
Work Type Code: TableRelation Table 200 “Work Type”
Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
Unit of Measure Code: TableRelation Table 205 “Resource Unit of Measure” (conditional)
Ship-to Code: TableRelation Table 222 “Ship-to Address”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
Transaction Type: TableRelation Table 258 “Transaction Type”
Transport Method: TableRelation Table 259 “Transport Method”
No.: TableRelation Table 27 “Item” (conditional)
Replaced Item No.: TableRelation Table 27 “Item” (conditional)
Exit Point: TableRelation Table 282 “Entry/Exit Point”
Area: TableRelation Table 284 “Area”
Transaction Specification: TableRelation Table 285 “Transaction Specification”
Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
Tax Area Code: TableRelation Table 318 “Tax Area”
Tax Group Code: TableRelation Table 321 “Tax Group”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Customer Disc. Group: TableRelation Table 340 “Customer Discount Group”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Currency Code: TableRelation Table 4 “Currency”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Variant Code: TableRelation Table 5401 “Item Variant”
Item Reference Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
VAT Clause Code: TableRelation Table 560 “VAT Clause”
Responsibility Center: TableRelation Table 5714 “Responsibility Center”
Item Category Code: TableRelation Table 5722 “Item Category”
Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
No.: TableRelation Table 5905 “Service Cost” (conditional)
Fault Area Code: TableRelation Table 5915 “Fault Area”
Symptom Code: TableRelation Table 5916 “Symptom Code”
Fault Reason Code: TableRelation Table 5917 “Fault Reason Code”
Fault Code: TableRelation Table 5918 “Fault Code”
Resolution Code: TableRelation Table 5919 “Resolution Code”
Replaced Item No.: TableRelation Table 5940 “Service Item” (conditional)
Service Item No.: TableRelation Table 5940 “Service Item”
Contract No.: TableRelation Table 5965 “Service Contract Header”
Customer Price Group: TableRelation Table 6 “Customer Price Group”
Document No.: TableRelation Table 6010 “Service Header Archive”
Service Item Line No.: TableRelation Table 6011 “Service Item Line Archive”
Attached to Line No.: TableRelation Table 6012 “Service Line Archive”
Service Price Group Code: TableRelation Table 6080 “Service Price Group”
Serv. Price Adjmt. Gr. Code: TableRelation Table 6082 “Service Price Adjustment Group”
Return Reason Code: TableRelation Table 6635 “Return Reason”
No.: TableRelation Table 7 “Standard Text” (conditional)
Bin Code: TableRelation Table 7354 “Bin”
Posting Group: TableRelation Table 94 “Inventory Posting Group”
Time Sheet No.: TableRelation Table 950 “Time Sheet Header”
Time Sheet Line No.: TableRelation Table 951 “Time Sheet Line”
Time Sheet Date: TableRelation Table 952 “Time Sheet Detail”

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 6012 “Service Line Archive”: Attached to Line No.

Pages and codeunits on this table

Page 6275 “Service Quote Archive Lines” (source table)
Page 6276 “Service Order Archive Lines” (source table)

Extended by

Table extension 5040 “Serv. Decl. Serv. Line Archive”

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
Codeunit 6479 “Serv. Catalog Item Mgt.” (1 call: OnDelete → DelNonStockServiceArch)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Service Line Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.