Posted Gen. Journal Line

Dynamics 365 BC Table ReferenceTablesCompany TablesPPosted Gen. Journal Line

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

Table Type: Company

Table Name: Posted Gen. Journal Line
Database Table Name: CRONUS UK Ltd_$Posted Gen_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 181

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 Posted Gen. Journal Line 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 Posted Gen. Journal Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Journal Template Name SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
2Line No. SearchLine No.NormalInteger4Line No_int
3Account Type Primary Key SearchAccount TypeNormalOption4Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
4Account No. SearchAccount No.NormalCode20Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

5Posting Date SearchPosting DateNormalDate4Posting Datedatetime
6Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
7Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
10VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
11Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
12Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

13Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
14Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
15Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
16Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
17Balance (LCY) SearchBalance ($)NormalDecimal12Balance (LCY)decimal(38,38)
18Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
19Sales/Purch. (LCY) SearchSales/Purch. ($)NormalDecimal12Sales_Purch_ (LCY)decimal(38,38)
20Profit (LCY) SearchProfit ($)NormalDecimal12Profit (LCY)decimal(38,38)
21Inv. Discount (LCY) SearchInv. Discount ($)NormalDecimal12Inv_ Discount (LCY)decimal(38,38)
22Bill-to/Pay-to No. SearchBill-to/Pay-to No.NormalCode20Bill-to_Pay-to No_nvarchar(40)
23Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

24Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

25Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

26Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
29Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

30System-Created Entry SearchSystem-Created EntryNormalBoolean4
34On Hold SearchOn HoldNormalCode3On Holdnvarchar(6)
35Applies-to Doc. Type SearchApplies-to Doc. TypeNormalOption4Applies-to Doc_ Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
36Applies-to Doc. No. SearchApplies-to Doc. No.NormalCode20Applies-to Doc_ No_nvarchar(40)
38Due Date SearchDue DateNormalDate4Due Datedatetime
39Pmt. Discount Date SearchPmt. Discount DateNormalDate4Pmt_ Discount Datedatetime
40Payment Discount % SearchPayment Discount %NormalDecimal12Payment Discount _decimal(38,38)
42Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

43Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
44VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
45VAT Posting SearchTax PostingNormalOption4VAT Postingint
Available options are:
  • “Automatic VAT Entry”
  • “Manual VAT Entry”
47Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

48Applies-to ID SearchApplies-to IDNormalCode50Applies-to IDnvarchar(100)
50Business Unit Code SearchBusiness Unit CodeNormalCode20Business Unit Codenvarchar(40)
Key to join to the Business Unit table.

Show/hide example query

51Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
52Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

53Recurring Method SearchRecurring MethodNormalOption4Recurring Methodint
Available options are:
  • ” “
  • “F Fixed”
  • “V Variable”
  • “B Balance”
  • “RF Reversing Fixed”
  • “RV Reversing Variable”
  • “RB Reversing Balance”
  • “BD Balance by Dimension”
  • “RBD Reversing Balance by Dimension”
54Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
55Recurring Frequency SearchRecurring FrequencyNormalDateFormula32Recurring Frequencyvarchar(32)
57Gen. Posting Type SearchGen. Posting TypeNormalOption4Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
58Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

59Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

60VAT Calculation Type SearchTax Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
61EU 3-Party Trade SearchEU 3-Party TradeNormalBoolean4EU 3-Party Tradetinyint
62Allow Application SearchAllow ApplicationNormalBoolean4Allow Applicationtinyint
63Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
64Bal. Gen. Posting Type SearchBal. Gen. Posting TypeNormalOption4Bal_ Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
65Bal. Gen. Bus. Posting Group SearchBal. Gen. Bus. Posting GroupNormalCode20Bal_ Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

66Bal. Gen. Prod. Posting Group SearchBal. Gen. Prod. Posting GroupNormalCode20Bal_ Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

67Bal. VAT Calculation Type SearchBal. Tax Calculation TypeNormalOption4Bal_ VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
68Bal. VAT % SearchBal. Tax %NormalDecimal12Bal_ VAT _decimal(38,38)
69Bal. VAT Amount SearchBal. Tax AmountNormalDecimal12Bal_ VAT Amountdecimal(38,38)
70Bank Payment Type SearchBank Payment TypeNormalOption4Bank Payment Typeint
Available options are:
  • ” “
  • “Computer Check”
  • “Manual Check”
  • “Electronic Payment”
  • “Electronic Payment-IAT”
71VAT Base Amount SearchTax Base AmountNormalDecimal12VAT Base Amountdecimal(38,38)
72Bal. VAT Base Amount SearchBal. Tax Base AmountNormalDecimal12Bal_ VAT Base Amountdecimal(38,38)
73Correction SearchCorrectionNormalBoolean4Correctiontinyint
74Print Posted Documents SearchPrint Posted DocumentsNormalBoolean4Print Posted Documentstinyint
75Check Printed SearchCheck PrintedNormalBoolean4Check Printedtinyint
76Document Date SearchDocument DateNormalDate4Document Datedatetime
77External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
78Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
79Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
80Posting No. Series SearchPosting No. SeriesNormalCode20Posting No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

82Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

83Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
84Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

85Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
86Bal. Tax Area Code SearchBal. Tax Area CodeNormalCode20Bal_ Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

87Bal. Tax Liable SearchBal. Tax LiableNormalBoolean4Bal_ Tax Liabletinyint
88Bal. Tax Group Code SearchBal. Tax Group CodeNormalCode20Bal_ Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

89Bal. Use Tax SearchBal. Use TaxNormalBoolean4Bal_ Use Taxtinyint
90VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

91VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

92Bal. VAT Bus. Posting Group SearchBal. VAT Bus. Posting GroupNormalCode20Bal_ VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

93Bal. VAT Prod. Posting Group SearchBal. VAT Prod. Posting GroupNormalCode20Bal_ VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

95Additional-Currency Posting SearchAdditional-Currency PostingNormalOption4Additional-Currency Postingint
Available options are:
  • “None”
  • “Amount Only”
  • “Additional-Currency Amount Only”
98FA Add.-Currency Factor SearchFA Add.-Currency FactorNormalDecimal12FA Add_-Currency Factordecimal(38,38)
99Source Currency Code SearchSource Currency CodeNormalCode10Source Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

100Source Currency Amount SearchSource Currency AmountNormalDecimal12Source Currency Amountdecimal(38,38)
101Source Curr. VAT Base Amount SearchSource Curr. Tax Base AmountNormalDecimal12Source Curr_ VAT Base Amountdecimal(38,38)
102Source Curr. VAT Amount SearchSource Curr. Tax AmountNormalDecimal12Source Curr_ VAT Amountdecimal(38,38)
103VAT Base Discount % SearchTax Base Discount %NormalDecimal12VAT Base Discount _decimal(38,38)
104VAT Amount (LCY) SearchTax Amount ($)NormalDecimal12VAT Amount (LCY)decimal(38,38)
105VAT Base Amount (LCY) SearchTax Base Amount ($)NormalDecimal12VAT Base Amount (LCY)decimal(38,38)
106Bal. VAT Amount (LCY) SearchBal. Tax Amount ($)NormalDecimal12Bal_ VAT Amount (LCY)decimal(38,38)
107Bal. VAT Base Amount (LCY) SearchBal. Tax Base Amount ($)NormalDecimal12Bal_ VAT Base Amount (LCY)decimal(38,38)
108Reversing Entry SearchReversing EntryNormalBoolean4Reversing Entrytinyint
109Allow Zero-Amount Posting SearchAllow Zero-Amount PostingNormalBoolean4Allow Zero-Amount Postingtinyint
110Ship-to/Order Address Code SearchShip-to/Order Address CodeNormalCode10Ship-to_Order Address Codenvarchar(20)
111VAT Difference SearchTax DifferenceNormalDecimal12VAT Differencedecimal(38,38)
112Bal. VAT Difference SearchBal. Tax DifferenceNormalDecimal12Bal_ VAT Differencedecimal(38,38)
113IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

114IC Direction SearchIC DirectionNormalOption4IC Directionint
Available options are:
  • “Outgoing”
  • “Incoming”
116IC Partner G/L Acc. No. SearchIC Partner G/L Acc. No.NormalCode20IC Partner G_L Acc_ No_nvarchar(40)
117IC Partner Transaction No. SearchIC Partner Transaction No.NormalInteger4IC Partner Transaction No_int
118Sell-to/Buy-from No. SearchSell-to/Buy-from No.NormalCode20Sell-to_Buy-from No_nvarchar(40)
119VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
120Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
121Prepayment SearchPrepaymentNormalBoolean4Prepaymenttinyint
122Financial Void SearchFinancial VoidNormalBoolean4Financial Voidtinyint
123Copy VAT Setup to Jnl. Lines SearchCopy Tax Setup to Jnl. LinesNormalBoolean4Copy VAT Setup to Jnl_ Linestinyint
125VAT Base Before Pmt. Disc. SearchTax Base Before Pmt. Disc.NormalDecimal12VAT Base Before Pmt_ Disc_decimal(38,38)
126Orig. Pmt. Disc. Possible SearchOriginal Pmt. Disc. PossibleNormalDecimal12Orig_ Pmt_ Disc_ Possibledecimal(38,38)
127Orig. Pmt. Disc. Possible(LCY) SearchOrig. Pmt. Disc. Possible ($)NormalDecimal12Orig_ Pmt_ Disc_ Possible(LCY)decimal(38,38)
130IC Account Type SearchIC Account TypeNormalOption4IC Account Typeint
Available options are:
  • “G/L Account”
  • “Bank Account”
131IC Account No. SearchIC Account No.NormalCode20IC Account No_nvarchar(40)
160Job Queue Status SearchJob Queue StatusNormalOption4Job Queue Statusint
Available options are:
  • ” “
  • “Scheduled for Posting”
  • “Error”
  • “Posting”
161Job Queue Entry ID SearchJob Queue Entry IDNormalGUID16Job Queue Entry IDuniqueidentifier
165Incoming Document Entry No. SearchIncoming Document Entry No.NormalInteger4Incoming Document Entry No_int
Key to join to the Incoming Document table.

Show/hide example query

170Creditor No. SearchCreditor No.NormalCode20Creditor No_nvarchar(40)
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

173Applies-to Ext. Doc. No. SearchApplies-to Ext. Doc. No.NormalCode35Applies-to Ext_ Doc_ No_nvarchar(70)
175Invoice Received Date SearchInvoice Received DateNormalDate4Invoice Received Datedatetime
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

1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1002Job Unit Price (LCY) SearchJob Unit Price ($)NormalDecimal12Job Unit Price (LCY)decimal(38,38)
1003Job Total Price (LCY) SearchJob Total Price ($)NormalDecimal12Job Total Price (LCY)decimal(38,38)
1004Job Quantity SearchJob QuantityNormalDecimal12Job Quantitydecimal(38,38)
1005Job Unit Cost (LCY) SearchJob Unit Cost ($)NormalDecimal12Job Unit Cost (LCY)decimal(38,38)
1006Job Line Discount % SearchJob Line Discount %NormalDecimal12Job Line Discount _decimal(38,38)
1007Job Line Disc. Amount (LCY) SearchJob Line Disc. Amount ($)NormalDecimal12Job Line Disc_ Amount (LCY)decimal(38,38)
1008Job Unit Of Measure Code SearchJob Unit Of Measure CodeNormalCode10Job Unit Of Measure Codenvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

1009Job Line Type SearchJob Line TypeNormalOption4Job Line Typeint
Available options are:
  • ” “
  • “Budget”
  • “Billable”
  • “Both Budget and Billable”
1010Job Unit Price SearchJob Unit PriceNormalDecimal12Job Unit Pricedecimal(38,38)
1011Job Total Price SearchJob Total PriceNormalDecimal12Job Total Pricedecimal(38,38)
1012Job Unit Cost SearchJob Unit CostNormalDecimal12Job Unit Costdecimal(38,38)
1013Job Total Cost SearchJob Total CostNormalDecimal12Job Total Costdecimal(38,38)
1014Job Line Discount Amount SearchJob Line Discount AmountNormalDecimal12Job Line Discount Amountdecimal(38,38)
1015Job Line Amount SearchJob Line AmountNormalDecimal12Job Line Amountdecimal(38,38)
1016Job Total Cost (LCY) SearchJob Total Cost ($)NormalDecimal12Job Total Cost (LCY)decimal(38,38)
1017Job Line Amount (LCY) SearchJob Line Amount ($)NormalDecimal12Job Line Amount (LCY)decimal(38,38)
1018Job Currency Factor SearchJob Currency FactorNormalDecimal12Job Currency Factordecimal(38,38)
1019Job Currency Code SearchJob Currency CodeNormalCode10Job Currency Codenvarchar(20)
1020Job Planning Line No. SearchJob Planning Line No.NormalInteger4Job Planning Line No_int
1030Job Remaining Qty. SearchJob Remaining Qty.NormalDecimal12Job Remaining Qty_decimal(38,38)
1200Direct Debit Mandate ID SearchDirect Debit Mandate IDNormalCode35Direct Debit Mandate IDnvarchar(70)
1220Data Exch. Entry No. SearchData Exch. Entry No.NormalInteger4Data Exch_ Entry No_int
Key to join to the Data Exch. table.

Show/hide example query

1221Payer Information SearchPayer InformationNormalText50Payer Informationnvarchar(100)
1222Transaction Information SearchTransaction InformationNormalText100Transaction Informationnvarchar(200)
1223Data Exch. Line No. SearchData Exch. Line No.NormalInteger4Data Exch_ Line No_int
1224Applied Automatically SearchApplied AutomaticallyNormalBoolean4Applied Automaticallytinyint
1700Deferral Code SearchDeferral CodeNormalCode10Deferral Codenvarchar(20)
Key to join to the Deferral Template table.

Show/hide example query

1701Deferral Line No. SearchDeferral Line No.NormalInteger4Deferral Line No_int
5050Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

5400Prod. Order No. SearchProd. Order No.NormalCode20Prod_ Order No_nvarchar(40)
5600FA Posting Date SearchFA Posting DateNormalDate4FA Posting Datedatetime
5601FA Posting Type SearchFA Posting TypeNormalOption4FA Posting Typeint
Available options are:
  • ” “
  • “Acquisition Cost”
  • “Depreciation”
  • “Write-Down”
  • “Appreciation”
  • “Custom 1”
  • “Custom 2”
  • “Disposal”
  • “Maintenance”
5602Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

5603Salvage Value SearchSalvage ValueNormalDecimal12Salvage Valuedecimal(38,38)
5604No. of Depreciation Days SearchNo. of Depreciation DaysNormalInteger4No_ of Depreciation Daysint
5605Depr. until FA Posting Date SearchDepr. until FA Posting DateNormalBoolean4Depr_ until FA Posting Datetinyint
5606Depr. Acquisition Cost SearchDepr. Acquisition CostNormalBoolean4Depr_ Acquisition Costtinyint
5609Maintenance Code SearchMaintenance CodeNormalCode10Maintenance Codenvarchar(20)
Key to join to the Maintenance table.

Show/hide example query

5610Insurance No. SearchInsurance No.NormalCode20Insurance No_nvarchar(40)
Key to join to the Insurance table.

Show/hide example query

5611Budgeted FA No. SearchBudgeted FA No.NormalCode20Budgeted FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

5612Duplicate in Depreciation Book SearchDuplicate in Depreciation BookNormalCode10Duplicate in Depreciation Booknvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

5613Use Duplication List SearchUse Duplication ListNormalBoolean4Use Duplication Listtinyint
5614FA Reclassification Entry SearchFA Reclassification EntryNormalBoolean4FA Reclassification Entrytinyint
5615FA Error Entry No. SearchFA Error Entry No.NormalInteger4FA Error Entry No_int
Key to join to the FA Ledger Entry table.

Show/hide example query

5616Index Entry SearchIndex EntryNormalBoolean4Index Entrytinyint
5617Source Line No. SearchSource Line No.NormalInteger4Source Line No_int
5618Comment SearchCommentNormalText250Commentnvarchar(500)
5701Check Exported SearchCheck ExportedNormalBoolean4Check Exportedtinyint
5702Check Transmitted SearchCheck TransmittedNormalBoolean4Check Transmittedtinyint
6200Non-Deductible VAT % SearchNon-Deductible Tax %NormalDecimal12Non-Deductible VAT _decimal(38,38)
6201Non-Deductible VAT Base SearchNon-Deductible Tax BaseNormalDecimal12Non-Deductible VAT Basedecimal(38,38)
6202Non-Deductible VAT Amount SearchNon-Deductible Tax AmountNormalDecimal12Non-Deductible VAT Amountdecimal(38,38)
6203Non-Deductible VAT Base LCY SearchNon-Deductible Tax Base LCYNormalDecimal12Non-Deductible VAT Base LCYdecimal(38,38)
6204Non-Deductible VAT Amount LCY SearchNon-Deductible Tax Amount LCYNormalDecimal12Non-Deductible VAT Amount LCYdecimal(38,38)
6205Non-Deductible VAT Base ACY SearchNon-Deductible Tax Base ACYNormalDecimal12Non-Deductible VAT Base ACYdecimal(38,38)
6206Non-Deductible VAT Amount ACY SearchNon-Deductible Tax Amount ACYNormalDecimal12Non-Deductible VAT Amount ACYdecimal(38,38)
6208Non-Deductible VAT Diff. SearchNon-Deductible Tax DifferenceNormalDecimal12Non-Deductible VAT Diff_decimal(38,38)
8001Account Id SearchAccount IdNormalGUID16Account Iduniqueidentifier
Key to join to the G/L Account table.

Show/hide example query

8002Customer Id SearchCustomer IdNormalGUID16Customer Iduniqueidentifier
Key to join to the Customer table.

Show/hide example query

8003Applies-to Invoice Id SearchApplies-to Invoice IdNormalGUID16Applies-to Invoice Iduniqueidentifier
Key to join to the Sales Invoice Header table.

Show/hide example query

8004Contact Graph Id SearchContact Graph IdNormalText250Contact Graph Idnvarchar(500)
8005Last Modified DateTime SearchLast Modified DateTimeNormalDateTime8Last Modified DateTimedatetime
8006Journal Batch Id SearchJournal Batch IdNormalGUID16Journal Batch Iduniqueidentifier
Key to join to the Gen. Journal Batch table.

Show/hide example query

8007Payment Method Id SearchPayment Method IdNormalGUID16Payment Method Iduniqueidentifier
Key to join to the Payment Method table.

Show/hide example query

8010G/L Register No. SearchG/L Register No.NormalInteger4G_L Register No_int
8011Indentation SearchIndentationNormalInteger4Indentationint
10006Export File Name SearchExport File NameNormalText30
10011Tax Jurisdiction Code SearchTax Jurisdiction CodeNormalCode10
Key to join to the Tax Jurisdiction table.

Show/hide example query

10012Tax Type SearchTax TypeNormalOption4
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10020IRS 1099 Code SearchIRS 1099 CodeNormalCode10
10021IRS 1099 Amount SearchIRS 1099 AmountNormalDecimal12
10030Foreign Exchange Indicator SearchForeign Exchange IndicatorNormalOption4
10031Foreign Exchange Ref.Indicator SearchForeign Exchange Ref.IndicatorNormalOption4
10032Foreign Exchange Reference SearchForeign Exchange ReferenceNormalCode20
10033Gateway Operator OFAC Scr.Inc SearchGateway Operator OFAC Scr.IncNormalOption4
10034Secondary OFAC Scr.Indicator SearchSecondary OFAC Scr.IndicatorNormalOption4
10035Origin. DFI ID Qualifier SearchOrigin. DFI ID QualifierNormalOption4
10036Receiv. DFI ID Qualifier SearchReceiv. DFI ID QualifierNormalOption4
10037Transaction Type Code SearchTransaction Type CodeNormalOption4
10038Transaction Code SearchTransaction CodeNormalCode3
10039Company Entry Description SearchCompany Entry DescriptionNormalText10
10040Payment Related Information 1 SearchPayment Related Information 1NormalText80
10041Payment Related Information 2 SearchPayment Related Information 2NormalText52
10045GST/HST SearchGST/HSTNormalOption4
10046EFT Export Sequence No. SearchEFT Export Sequence No.NormalInteger4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Posted Gen. Journal Line table

Dynamics 365 BC Table ReferenceTablesCompany TablesPPosted Gen. Journal Line

Leave a Reply

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