Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/380
Table Type: Company
Table Name: Detailed Vendor Ledg. Entry
Database Table Name: CRONUS UK Ltd_$Detailed Vendor Ledg_ Entry$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Detailed Vendor Ledg. Entry can be queried.
Show/hide an example select of all columns
Show/hide an example select of all columns by name
Show/hide an example select of all columns including those from all joined tables
Show/hide columns in Detailed Vendor Ledg. Entry table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Entry No. ![]() | Entry No. | Normal | Integer | 4 | Entry No_ | int |
2 | Vendor Ledger Entry No. ![]() ![]() | Vendor Ledger Entry No. | Normal | Integer | 4 | Vendor Ledger Entry No_ | int |
Key to join to the Vendor Ledger Entry table.Show/hide example query | |||||||
3 | Entry Type ![]() | Entry Type | Normal | Option | 4 | Entry Type | int |
Available options are:
| |||||||
4 | Posting Date ![]() | Posting Date | Normal | Date | 4 | Posting Date | datetime |
5 | Document Type ![]() | Document Type | Normal | Option | 4 | Document Type | int |
Available options are:
| |||||||
6 | Document No. ![]() | Document No. | Normal | Code | 20 | Document No_ | nvarchar(40) |
7 | Amount ![]() | Amount | Normal | Decimal | 12 | Amount | decimal(38,38) |
8 | Amount (LCY) ![]() | Amount ($) | Normal | Decimal | 12 | Amount (LCY) | decimal(38,38) |
9 | Vendor No. ![]() | Vendor No. | Normal | Code | 20 | Vendor No_ | nvarchar(40) |
Key to join to the Vendor table.Show/hide example query | |||||||
10 | Currency Code ![]() | Currency Code | Normal | Code | 10 | Currency Code | nvarchar(20) |
Key to join to the Currency table.Show/hide example query | |||||||
11 | User ID ![]() | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
12 | Source Code ![]() | Source Code | Normal | Code | 10 | Source Code | nvarchar(20) |
Key to join to the Source Code table.Show/hide example query | |||||||
13 | Transaction No. ![]() | Transaction No. | Normal | Integer | 4 | Transaction No_ | int |
14 | Journal Batch Name ![]() | Journal Batch Name | Normal | Code | 10 | Journal Batch Name | nvarchar(20) |
15 | Reason Code ![]() | Reason Code | Normal | Code | 10 | Reason Code | nvarchar(20) |
Key to join to the Reason Code table.Show/hide example query | |||||||
16 | Debit Amount ![]() | Debit Amount | Normal | Decimal | 12 | Debit Amount | decimal(38,38) |
17 | Credit Amount ![]() | Credit Amount | Normal | Decimal | 12 | Credit Amount | decimal(38,38) |
18 | Debit Amount (LCY) ![]() | Debit Amount ($) | Normal | Decimal | 12 | Debit Amount (LCY) | decimal(38,38) |
19 | Credit Amount (LCY) ![]() | Credit Amount ($) | Normal | Decimal | 12 | Credit Amount (LCY) | decimal(38,38) |
20 | Initial Entry Due Date ![]() | Initial Entry Due Date | Normal | Date | 4 | Initial Entry Due Date | datetime |
21 | Initial Entry Global Dim. 1 ![]() | Initial Entry Global Dim. 1 | Normal | Code | 20 | Initial Entry Global Dim_ 1 | nvarchar(40) |
22 | Initial Entry Global Dim. 2 ![]() | Initial Entry Global Dim. 2 | Normal | Code | 20 | Initial Entry Global Dim_ 2 | nvarchar(40) |
24 | Gen. Bus. Posting Group ![]() | Gen. Bus. Posting Group | Normal | Code | 20 | Gen_ Bus_ Posting Group | nvarchar(40) |
Key to join to the Gen. Business Posting Group table.Show/hide example query | |||||||
25 | Gen. Prod. Posting Group ![]() | Gen. Prod. Posting Group | Normal | Code | 20 | Gen_ Prod_ Posting Group | nvarchar(40) |
Key to join to the Gen. Product Posting Group table.Show/hide example query | |||||||
29 | Use Tax ![]() | Use Tax | Normal | Boolean | 4 | Use Tax | tinyint |
30 | VAT Bus. Posting Group ![]() | VAT Bus. Posting Group | Normal | Code | 20 | VAT Bus_ Posting Group | nvarchar(40) |
Key to join to the VAT Business Posting Group table.Show/hide example query | |||||||
31 | VAT Prod. Posting Group ![]() | VAT Prod. Posting Group | Normal | Code | 20 | VAT Prod_ Posting Group | nvarchar(40) |
Key to join to the VAT Product Posting Group table.Show/hide example query | |||||||
35 | Initial Document Type ![]() | Initial Document Type | Normal | Option | 4 | Initial Document Type | int |
Available options are:
| |||||||
36 | Applied Vend. Ledger Entry No. ![]() | Applied Vend. Ledger Entry No. | Normal | Integer | 4 | Applied Vend_ Ledger Entry No_ | int |
37 | Unapplied ![]() | Unapplied | Normal | Boolean | 4 | Unapplied | tinyint |
38 | Unapplied by Entry No. ![]() | Unapplied by Entry No. | Normal | Integer | 4 | Unapplied by Entry No_ | int |
39 | Remaining Pmt. Disc. Possible ![]() | Remaining Pmt. Disc. Possible | Normal | Decimal | 12 | Remaining Pmt_ Disc_ Possible | decimal(38,38) |
40 | Max. Payment Tolerance ![]() | Max. Payment Tolerance | Normal | Decimal | 12 | Max_ Payment Tolerance | decimal(38,38) |
41 | Tax Jurisdiction Code ![]() | Tax Jurisdiction Code | Normal | Code | 10 | Tax Jurisdiction Code | nvarchar(20) |
Key to join to the Tax Jurisdiction table.Show/hide example query | |||||||
42 | Application No. ![]() | Application No. | Normal | Integer | 4 | Application No_ | int |
43 | Ledger Entry Amount ![]() | Ledger Entry Amount | Normal | Boolean | 4 | Ledger Entry Amount | tinyint |
44 | Posting Group ![]() | Vendor Posting Group | Normal | Code | 20 | Posting Group | nvarchar(40) |
Key to join to the Customer Posting Group table.Show/hide example query | |||||||
45 | Exch. Rate Adjmt. Reg. No. ![]() | Exch. Rate Adjmt. Reg. No. | Normal | Integer | 4 | Exch_ Rate Adjmt_ Reg_ No_ | int |
Key to join to the Exch. Rate Adjmt. Reg. table.Show/hide example query | |||||||
2000000000 | $systemId ![]() | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt ![]() | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy ![]() | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example query | |||||||
2000000003 | SystemModifiedAt ![]() | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy ![]() | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |