Cust. Ledger Entry

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/21

Table Type: Company

Table Name: Cust. Ledger Entry
Database Table Name: CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 21

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 Cust. Ledger Entry can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Entry No_]
   ,[Customer No_]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Description]
   ,[Customer Name]
   ,[Your Reference]
   ,[Currency Code]
   ,[Sales (LCY)]
   ,[Profit (LCY)]
   ,[Inv_ Discount (LCY)]
   ,[Sell-to Customer No_]
   ,[Customer Posting Group]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Salesperson Code]
   ,[User ID]
   ,[Source Code]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Open]
   ,[Due Date]
   ,[Pmt_ Discount Date]
   ,[Original Pmt_ Disc_ Possible]
   ,[Pmt_ Disc_ Given (LCY)]
   ,[Orig_ Pmt_ Disc_ Possible(LCY)]
   ,[Positive]
   ,[Closed by Entry No_]
   ,[Closed at Date]
   ,[Closed by Amount]
   ,[Applies-to ID]
   ,[Journal Templ_ Name]
   ,[Journal Batch Name]
   ,[Reason Code]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[Transaction No_]
   ,[Closed by Amount (LCY)]
   ,[Document Date]
   ,[External Document No_]
   ,[Calculate Interest]
   ,[Closing Interest Calculated]
   ,[No_ Series]
   ,[Closed by Currency Code]
   ,[Closed by Currency Amount]
   ,[Adjusted Currency Factor]
   ,[Original Currency Factor]
   ,[Remaining Pmt_ Disc_ Possible]
   ,[Pmt_ Disc_ Tolerance Date]
   ,[Max_ Payment Tolerance]
   ,[Last Issued Reminder Level]
   ,[Accepted Payment Tolerance]
   ,[Accepted Pmt_ Disc_ Tolerance]
   ,[Pmt_ Tolerance (LCY)]
   ,[Amount to Apply]
   ,[IC Partner Code]
   ,[Applying Entry]
   ,[Reversed]
   ,[Reversed by Entry No_]
   ,[Reversed Entry No_]
   ,[Prepayment]
   ,[Payment Reference]
   ,[Payment Method Code]
   ,[Applies-to Ext_ Doc_ No_]
   ,[Recipient Bank Account]
   ,[Message to Recipient]
   ,[Exported to Payment File]
   ,[Dimension Set ID]
   ,[Direct Debit Mandate ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Cust. Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Cust. Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Cust. Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Cust. Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Cust. Ledger Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Cust. Ledger Entry].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Cust. Ledger Entry].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Cust. Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Cust. Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Cust. Ledger Entry].[Closed by Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Cust. Ledger Entry].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Cust. Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Cust. Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Cust. Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Cust. Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Cust. Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Cust. Ledger Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
3Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Cust. Ledger Entry].[Customer No_] = [Customer].[No_]
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
6Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Customer Name SearchCustomer NameNormalText100Customer Namenvarchar(200)
10Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
11Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Cust. Ledger Entry].[Currency Code] = [Currency].[Code]
13Amount SearchAmountFlowFieldDecimal12
14Remaining Amount SearchRemaining AmountFlowFieldDecimal12
15Original Amt. (LCY) SearchOriginal Amt. ($)FlowFieldDecimal12
16Remaining Amt. (LCY) SearchRemaining Amt. ($)FlowFieldDecimal12
17Amount (LCY) SearchAmount ($)FlowFieldDecimal12
18Sales (LCY) SearchSales ($)NormalDecimal12Sales (LCY)decimal(38,38)
19Profit (LCY) SearchProfit ($)NormalDecimal12Profit (LCY)decimal(38,38)
20Inv. Discount (LCY) SearchInv. Discount ($)NormalDecimal12Inv_ Discount (LCY)decimal(38,38)
21Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Cust. Ledger Entry].[Sell-to Customer No_] = [Customer].[No_]
22Customer Posting Group SearchCustomer Posting GroupNormalCode20Customer Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Customer Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Cust. Ledger Entry].[Customer Posting Group] = [Customer Posting Group].[Code]
23Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Cust. Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
24Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Cust. Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
25Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Cust. Ledger Entry].[Salesperson Code] = [Salesperson/Purchaser].[Code]
27User ID SearchUser IDNormalCode50User IDnvarchar(100)
28Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Cust. Ledger Entry].[Source Code] = [Source Code].[Code]
33On Hold SearchOn HoldNormalCode3On Holdnvarchar(6)
34Applies-to Doc. Type SearchApplies-to Doc. TypeNormalOption4Applies-to Doc_ Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
35Applies-to Doc. No. SearchApplies-to Doc. No.NormalCode20Applies-to Doc_ No_nvarchar(40)
36Open SearchOpenNormalBoolean4Opentinyint
37Due Date SearchDue DateNormalDate4Due Datedatetime
38Pmt. Discount Date SearchPmt. Discount DateNormalDate4Pmt_ Discount Datedatetime
39Original Pmt. Disc. Possible SearchOriginal Pmt. Disc. PossibleNormalDecimal12Original Pmt_ Disc_ Possibledecimal(38,38)
40Pmt. Disc. Given (LCY) SearchPmt. Disc. Given ($)NormalDecimal12Pmt_ Disc_ Given (LCY)decimal(38,38)
42Orig. Pmt. Disc. Possible(LCY) SearchOrig. Pmt. Disc. Possible ($)NormalDecimal12Orig_ Pmt_ Disc_ Possible(LCY)decimal(38,38)
43Positive SearchPositiveNormalBoolean4Positivetinyint
44Closed by Entry No. SearchClosed by Entry No.NormalInteger4Closed by Entry No_int
45Closed at Date SearchClosed at DateNormalDate4Closed at Datedatetime
46Closed by Amount SearchClosed by AmountNormalDecimal12Closed by Amountdecimal(38,38)
47Applies-to ID SearchApplies-to IDNormalCode50Applies-to IDnvarchar(100)
48Journal Templ. Name SearchJournal Template NameNormalCode10Journal Templ_ Namenvarchar(20)
49Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
50Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Cust. Ledger Entry].[Reason Code] = [Reason Code].[Code]
51Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
52Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
53Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
54Closed by Amount (LCY) SearchClosed by Amount ($)NormalDecimal12Closed by Amount (LCY)decimal(38,38)
58Debit Amount SearchDebit AmountFlowFieldDecimal12
59Credit Amount SearchCredit AmountFlowFieldDecimal12
60Debit Amount (LCY) SearchDebit Amount ($)FlowFieldDecimal12
61Credit Amount (LCY) SearchCredit Amount ($)FlowFieldDecimal12
62Document Date SearchDocument DateNormalDate4Document Datedatetime
63External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
64Calculate Interest SearchCalculate InterestNormalBoolean4Calculate Interesttinyint
65Closing Interest Calculated SearchClosing Interest CalculatedNormalBoolean4Closing Interest Calculatedtinyint
66No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Cust. Ledger Entry].[No_ Series] = [No. Series].[Code]
67Closed by Currency Code SearchClosed by Currency CodeNormalCode10Closed by Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Closed by Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Cust. Ledger Entry].[Closed by Currency Code] = [Currency].[Code]
68Closed by Currency Amount SearchClosed by Currency AmountNormalDecimal12Closed by Currency Amountdecimal(38,38)
73Adjusted Currency Factor SearchAdjusted Currency FactorNormalDecimal12Adjusted Currency Factordecimal(38,38)
74Original Currency Factor SearchOriginal Currency FactorNormalDecimal12Original Currency Factordecimal(38,38)
75Original Amount SearchOriginal AmountFlowFieldDecimal12
76Date Filter SearchDate FilterFlowFilterDate4
77Remaining Pmt. Disc. Possible SearchRemaining Pmt. Disc. PossibleNormalDecimal12Remaining Pmt_ Disc_ Possibledecimal(38,38)
78Pmt. Disc. Tolerance Date SearchPmt. Disc. Tolerance DateNormalDate4Pmt_ Disc_ Tolerance Datedatetime
79Max. Payment Tolerance SearchMax. Payment ToleranceNormalDecimal12Max_ Payment Tolerancedecimal(38,38)
80Last Issued Reminder Level SearchLast Issued Reminder LevelNormalInteger4Last Issued Reminder Levelint
81Accepted Payment Tolerance SearchAccepted Payment ToleranceNormalDecimal12Accepted Payment Tolerancedecimal(38,38)
82Accepted Pmt. Disc. Tolerance SearchAccepted Pmt. Disc. ToleranceNormalBoolean4Accepted Pmt_ Disc_ Tolerancetinyint
83Pmt. Tolerance (LCY) SearchPmt. Tolerance ($)NormalDecimal12Pmt_ Tolerance (LCY)decimal(38,38)
84Amount to Apply SearchAmount to ApplyNormalDecimal12Amount to Applydecimal(38,38)
85IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Cust. Ledger Entry].[IC Partner Code] = [IC Partner].[Code]
86Applying Entry SearchApplying EntryNormalBoolean4Applying Entrytinyint
87Reversed SearchReversedNormalBoolean4Reversedtinyint
88Reversed by Entry No. SearchReversed by Entry No.NormalInteger4Reversed by Entry No_int
89Reversed Entry No. SearchReversed Entry No.NormalInteger4Reversed Entry No_int
90Prepayment SearchPrepaymentNormalBoolean4Prepaymenttinyint
171Payment Reference SearchPayment ReferenceNormalCode50Payment Referencenvarchar(100)
172Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Cust. Ledger Entry].[Payment Method Code] = [Payment Method].[Code]
173Applies-to Ext. Doc. No. SearchApplies-to Ext. Doc. No.NormalCode35Applies-to Ext_ Doc_ No_nvarchar(70)
288Recipient Bank Account SearchRecipient Bank AccountNormalCode20Recipient Bank Accountnvarchar(40)
289Message to Recipient SearchMessage to RecipientNormalText140Message to Recipientnvarchar(280)
290Exported to Payment File SearchExported to Payment FileNormalBoolean4Exported to Payment Filetinyint
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Cust. Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
1200Direct Debit Mandate ID SearchDirect Debit Mandate IDNormalCode35Direct Debit Mandate IDnvarchar(70)
1300Payment Prediction SearchPayment PredictionNormalOption4
1301Prediction Confidence SearchPrediction ConfidenceNormalOption4
1302Prediction Confidence % SearchPrediction Confidence %NormalDecimal12
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10019Electronic Document Sent SearchElectronic Document SentNormalBoolean4
10020Original Document XML SearchOriginal Document XMLNormalBLOB8
10021No. of E-Documents Sent SearchNo. of E-Documents SentNormalInteger4
10022Original String SearchOriginal StringNormalBLOB8
10023Digital Stamp SAT SearchDigital Stamp SATNormalBLOB8
10024Certificate Serial No. SearchCertificate Serial No.NormalText250
10025Signed Document XML SearchSigned Document XMLNormalBLOB8
10026Digital Stamp PAC SearchDigital Stamp PACNormalBLOB8
10030Electronic Document Status SearchElectronic Document StatusNormalOption4
10031Date/Time Stamped SearchDate/Time StampedNormalText50
10032Date/Time Sent SearchDate/Time SentNormalText50
10033Date/Time Canceled SearchDate/Time CanceledNormalText50
10035Error Code SearchError CodeNormalCode10
10036Error Description SearchError DescriptionNormalText250
10037Date/Time Stamp Received SearchDate/Time Stamp ReceivedNormalDateTime8
10038Date/Time Cancel Sent SearchDate/Time Cancel SentNormalDateTime8
10040PAC Web Service Name SearchPAC Web Service NameNormalText50
10041QR Code SearchQR CodeNormalBLOB8
10042Fiscal Invoice Number PAC SearchFiscal Invoice Number PACNormalText50
10043Date/Time First Req. Sent SearchDate/Time First Req. SentNormalText50
27002CFDI Cancellation Reason Code SearchCFDI Cancelation Reason CodeNormalCode10
27003Substitution Entry No. SearchSubstitution Entry No.NormalInteger4
27007CFDI Cancellation ID SearchCFDI Cancelation IDNormalText50
27008Marked as Canceled SearchMarked as CanceledNormalBoolean4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cust. Ledger Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Cust. Ledger Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Cust. Ledger Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Cust. Ledger Entry table

Leave a Reply

Your email address will not be published. Required fields are marked *