G/L Register #45

Sales Documents table in Microsoft Dynamics 365 Business Central. 17 fields, 1,024 records in Cronus demo.

17
Fields
1,024
Records
1
Primary key
0
FlowFields
8
Relations
Open in Data Explorer →

Primary key

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

All fields (17)

G/L Register — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Integer Normal
2 From Entry No. Integer Normal → G/L Entry #17
3 To Entry No. Integer Normal → G/L Entry #17
4 Creation Date Date Normal
5 Source Code Code Normal → Source Code #230
6 User ID Code Normal
7 Journal Batch Name Code Normal
8 From VAT Entry No. Integer Normal → VAT Entry #254
9 To VAT Entry No. Integer Normal → VAT Entry #254
10 Reversed Boolean Normal
11 Creation Time Time Normal
12 Journal Template Name Code 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 (4)

Tables referenced by fields on the G/L Register table through TableRelation properties.

G/L Entry
#17 · Ledger Entries · via From Entry No., To Entry No.
Source Code
#230 · Other · via Source Code
VAT Entry
#254 · Ledger Entries · via From VAT Entry No., To VAT Entry No.