Table 309 "No. Series Line"
Business Foundation · Microsoft.Foundation.NoSeries
Across versions
- BC23present
- BC2412 procedures removed, 1 fields changed
- BC25-26unchanged
- BC27declaration changed
- BC28changed
- BC29-30unchanged
Neighbourhood 12 connected objects and pages
Business Foundation · Microsoft.Foundation.NoSeries · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 457 “No. Series Lines” (4 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | No. Series Line |
| DataClassification | CustomerContent |
| LookupPageId | No. Series Lines |
| DrillDownPageId | No. Series Lines |
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 | Series Code | Code[20] | Specifies the code for the number series to which this line applies. via Page 457 “No. Series Lines” | TableRelation Table 308 “No. Series” (No. Series); NotBlank |
| 2 | Line No. | Integer | — | |
| 3 | Starting Date | Date | Specifies the date from which you would like this line to apply. via Page 457 “No. Series Lines” | |
| 4 | Starting No. | Code[20] | Specifies the first number in the series. via Page 457 “No. Series Lines” | |
| 5 | Ending No. | Code[20] | Specifies the last number in the series. via Page 457 “No. Series Lines” | |
| 6 | Warning No. | Code[20] | Specifies when you want to receive a warning that the number series is running out. via Page 457 “No. Series Lines” | |
| 7 | Increment-by No. | Integer | Specifies the size of the interval by which you would like to space the numbers in the number series. via Page 457 “No. Series Lines” | |
| 8 | Last No. Used | Code[20] | Specifies the last number that was used from the number series. via Page 457 “No. Series Lines” | |
| 9 | Open | Boolean | Specifies whether the number series line is open. It is open until the last number in the series has been used. via Page 457 “No. Series Lines” | not editable |
| 10 | Last Date Used | Date | Specifies the date when a number was most recently assigned from the number series. via Page 457 “No. Series Lines” | |
| 12 | Sequence Name | Code[40] | — | not editable; DataClassification SystemMetadata |
| 13 | Starting Sequence No. Δ BC24 | BigInteger | — | not editable |
| 14 | Implementation + BC24 | Enum “No. Series Implementation” | Specifies the implementation to use for getting numbers. Some may produce gaps in the number series. This is practical for records, such as item cards and warehouse documents that, unlike financial transactions, can be deleted and cause gaps in the number sequence. via Page 457 “No. Series Lines” | enum Enum 397 “No. Series Implementation”; DataClassification SystemMetadata |
| 15 | Temp Current Sequence No. + BC24 Δ BC25 | BigInteger | Temporary Sequence Number caption | DataClassification SystemMetadata |
Keys
- Key1: Series Code, Line No. (clustered)
- Key2: Series Code, Starting Date, Starting No., Open
- Key3: Starting No.
- Key4: Last Date Used
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 305 “No. Series - Setup Impl.” OnDeleteNoSeriesLine, Codeunit 307 “No. Series - Sequence Impl.” OnDeleteNoSeriesLine
- OnBeforeInsertEvent: Codeunit 307 “No. Series - Sequence Impl.” OnInsertNoSeriesLine
- OnBeforeModifyEvent: Codeunit 307 “No. Series - Sequence Impl.” OnModifyNoSeriesLine
- OnBeforeValidateEvent(Implementation): Codeunit 306 “No. Series - Stateless Impl.” OnValidateImplementation, Codeunit 307 “No. Series - Sequence Impl.” OnValidateImplementation
- OnBeforeValidateEvent(Increment-by No.): Codeunit 307 “No. Series - Sequence Impl.” OnValidateIncrementByNo
- OnBeforeValidateEvent(Last No. Used): Codeunit 307 “No. Series - Sequence Impl.” OnValidateLastNoUsed
- OnBeforeValidateEvent(Starting No.): Codeunit 307 “No. Series - Sequence Impl.” OnValidateNoSeriesLine
Relations
- drill-down page Page 457 “No. Series Lines”
- lookup page Page 457 “No. Series Lines”
- Series Code: TableRelation Table 308 “No. Series”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 9059 “Administration Cue”: No. Series Period
Pages and codeunits on this table
- Page 421 “No. Series Lines Part” (source table)
- Page 457 “No. Series Lines” (source table)
Extended by
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). 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: "No. Series Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.