Sales Sub. Line Archive #8069

Other table in Microsoft Dynamics 365 Business Central. 39 fields, 0 records in Cronus demo.

39
Fields
0
Records
1
Primary key
1
FlowFields
7
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Line No..

All fields (39)

Sales Sub. Line Archive — FIELDS
NO.FIELDTYPECLASSRELATION
1 Document Type Option Normal
2 Document No. Code Normal → Sales Header Archive #5107
3 Document Line No. Integer Normal
4 Line No. PK Integer Normal
5 Version No. Integer Normal
6 Doc. No. Occurrence Integer Normal
10 Item No. Code Normal → Item #27
11 Item Description ⚡ FLOW Text FlowField
12 Partner Option Normal
13 Description Text Normal
14 Calculation Base Type Option Normal
15 Calculation Base Amount Decimal Normal
16 Calculation Base % Decimal Normal
17 Price Decimal Normal
18 Discount % Decimal Normal
19 Discount Amount Decimal Normal
20 Amount Decimal Normal
21 Subscription Line Start Formula DateFormula Normal
22 Agreed Subscription Line Start Date Date Normal
23 Initial Term DateFormula Normal
24 Notice Period DateFormula Normal
25 Subsequent Term DateFormula Normal
26 Billing Base Period DateFormula Normal
27 Billing Rhythm DateFormula Normal
28 Invoicing via Option Normal
30 Template Code Normal → Sub. Package Line Template #8054
31 Package Code Code Normal → Subscription Package #8055
32 Customer Price Group Code Normal → Customer Price Group #6
34 Currency Code Code Normal
60 Linked to No. Code Normal
61 Linked to Line No. Integer Normal
62 Process Option Normal
100 Unit Cost Decimal Normal
101 Unit Cost ($) Decimal Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (6)

Tables referenced by fields on the Sales Sub. Line Archive table through TableRelation properties.

Sales Header Archive
#5107 · Other · via Document No.
Item
#27 · Inventory · via Item No.
Sub. Package Line Template
#8054 · Other · via Template
Subscription Package
#8055 · Other · via Package Code
Customer Price Group
#6 · General Ledger · via Customer Price Group