Diagrams


Table

Gen. Journal Line

DynamicsDocs.comGen. Journal Line«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«Table 221»Gen. Jnl. AllocationJournal Template Name [PK]Journal Batch Name [PK]Journal Line No. [PK]Line No. [PK]Account No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeAllocation QuantityAllocation %AmountGen. Posting Type; [,Purchase,Sale]Gen. Bus. Posting GroupGen. Prod. Posting GroupVAT Calculation Type; [Normal VAT,Reve...VAT AmountVAT %Account NameTax Area CodeTax LiableTax Group CodeUse TaxVAT Bus. Posting GroupVAT Prod. Posting GroupAdditional-Currency AmountDimension Set ID«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting Group«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,E-...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line Account«Table 93»Vendor Posting GroupCode [PK,NN]Payables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.«Table 5606»FA Posting GroupCode [PK,NN]Acquisition Cost AccountAccum. Depreciation AccountWrite-Down AccountAppreciation AccountCustom 1 AccountCustom 2 AccountAcq. Cost Acc. on DisposalAccum. Depr. Acc. on DisposalWrite-Down Acc. on DisposalAppreciation Acc. on DisposalCustom 1 Account on DisposalCustom 2 Account on DisposalGains Acc. on DisposalLosses Acc. on DisposalBook Val. Acc. on Disp. [Gain]Sales Acc. on Disp. [Gain]Write-Down Bal. Acc. on Disp.Apprec. Bal. Acc. on Disp.Custom 1 Bal. Acc. on DisposalCustom 2 Bal. Acc. on DisposalMaintenance Expense AccountMaintenance Bal. Acc.Acquisition Cost Bal. Acc.Depreciation Expense Acc.Write-Down Expense Acc.Appreciation Bal. AccountCustom 1 Expense Acc.Custom 2 Expense Acc.Sales Bal. Acc.Allocated Acquisition Cost %...«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Order,Complete...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«Table 220»Business UnitCode [PK,NN]ConsolidateConsolidation %Starting DateEnding DateIncome Currency FactorBalance Currency FactorExch. Rate Losses Acc.Exch. Rate Gains Acc.Residual AccountLast Balance Currency FactorNameCompany NameCurrency CodeComp. Exch. Rate Gains Acc.Comp. Exch. Rate Losses Acc.Equity Exch. Rate Gains Acc.Equity Exch. Rate Losses Acc.Minority Exch. Rate Gains Acc.Minority Exch. Rate Losses AccCurrency Exchange Rate Table; [Local,B...Data Source; [Local Curr. <LCY>,Add. R...File Format; [Version 4.00 or Later <....«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 318»Tax AreaCode [PK,NN]Description«Table 321»Tax GroupCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«Table 224»Order AddressVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Country/Region CodeLast Date ModifiedFax No.Telex Answer BackPost CodeCountyE-MailHome Page«Table 410»IC G/L AccountNo. [PK,NN]NameAccount Type; [Posting,Heading,Total,B...Income/Balance; [Income Statement,Bala...BlockedMap-to G/L Acc. No.Indentation«Table 130»Incoming DocumentEntry No. [PK]DescriptionCreated Date-TimeCreated By User IDCreated By User NameReleasedReleased Date-TimeReleased By User IDReleased By User NameLast Date-Time ModifiedLast Modified By User IDLast Modified By User NamePostedPosted Date-TimeDocument Type; [Journal,Sales Invoice,...Document No.Posting DateStatus; [New,Released,Rejected,Posted,...URL1URL2URL3URL4Vendor NameVendor VAT Registration No.Vendor IBANDocument DateVendor Bank Branch No.Vendor Bank Account No.Vendor No.Data Exchange TypeOCR Data Corrected...«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Payment Processor; [,Dynamics Online]Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. Type«Table 287»Customer Bank AccountCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeContactPhone No.Telex No.Bank Branch No.Bank Account No.Transit No.Currency CodeCountry/Region CodeCountyFax No.Telex Answer BackLanguage CodeE-MailHome PageIBANSWIFT CodeBank Clearing CodeBank Clearing Standard«Table 288»Vendor Bank AccountVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeContactPhone No.Telex No.Bank Branch No.Bank Account No.Transit No.Currency CodeCountry/Region CodeCountyFax No.Telex Answer BackLanguage CodeE-MailHome PageIBANSWIFT CodeBank Clearing CodeBank Clearing Standard«Table 827»DO Payment Credit CardNo. [PK]Type [NN]Credit Card NumberExpiry Date [NN]Card Holder Name [NN]Customer No. [NN]Contact No. [NN]Cvc No.No. Series«Table 1001»Job TaskJob No. [PK,NN]Job Task No. [PK,NN]DescriptionJob Task Type; [Posting,Heading,Total,...WIP-Total; [,Total,Excluded]Job Posting GroupWIP MethodSchedule [Total Cost]Schedule [Total Price]Usage [Total Cost]Usage [Total Price]Contract [Total Cost]Contract [Total Price]Contract [Invoiced Price]Contract [Invoiced Cost]Posting Date FilterPlanning Date FilterTotalingNew PageNo. of Blank LinesIndentationRecognized Sales AmountRecognized Costs AmountRecognized Sales G/L AmountRecognized Costs G/L AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeOutstanding OrdersAmt. Rcd. Not InvoicedRemaining [Total Cost]Remaining [Total Price]...«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 1230»SEPA Direct Debit MandateID [PK]Customer No. [NN]Customer Bank Account Code [NN]Valid FromValid ToDate of Signature [NN]Type of Payment; [OneOff,Recurrent]BlockedExpected Number of DebitsDebit CounterNo. SeriesClosed«Table 1220»Data Exch.Entry No. [PK]File NameFile ContentData Exch. Def CodeData Exch. Line Def CodeTable FiltersIncoming Entry No.«Table 1700»Deferral TemplateDeferral Code [PK,NN]DescriptionDeferral Account [NN]Deferral %Calc. Method; [Straight-Line,Equal per...Start Date; [Posting Date,Beginning of...No. of PeriodsPeriod Description«Table 5071»CampaignNo. [PK]DescriptionStarting DateEnding DateSalesperson CodeCommentLast Date ModifiedNo. SeriesGlobal Dimension 1 CodeGlobal Dimension 2 CodeStatus CodeTarget Contacts ContactedContacts RespondedDuration [Min.]Cost [LCY]No. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterContact FilterContact Company FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P...To-do Closed Filter...«Table 5611»Depreciation BookCode [PK,NN]DescriptionG/L Integration - Acq. CostG/L Integration - DepreciationG/L Integration - Write-DownG/L Integration - AppreciationG/L Integration - Custom 1G/L Integration - Custom 2G/L Integration - DisposalG/L Integration - MaintenanceDisposal Calculation Method; [Net,Gros...Use Custom 1 DepreciationAllow Depr. below ZeroUse FA Exch. Rate in Duplic.Part of Duplication ListLast Date ModifiedAllow IndexationUse Same FA+G/L Posting DatesDefault Exchange RateUse FA Ledger CheckUse Rounding in Periodic Depr.New Fiscal Year Starting DateNo. of Days in Fiscal YearAllow Changes in Depr. FieldsDefault Final Rounding AmountDefault Ending Book ValuePeriodic Depr. Date Calc.; [Last Entry...Mark Errors as CorrectionsAdd-Curr Exch Rate - Acq. CostAdd.-Curr. Exch. Rate - Depr.Add-Curr Exch Rate -Write-Down...«Table 5626»MaintenanceCode [PK,NN]Description«Table 5628»InsuranceNo. [PK]Effective DateExpiration DatePolicy No.Annual PremiumPolicy CoverageTotal Value InsuredCommentInsurance TypeLast Date ModifiedInsurance Vendor No.FA Class CodeFA Subclass CodeFA Location CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeBlockedDescriptionSearch DescriptionDate FilterNo. Series<Account No.><Bal. Account No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Account No.><Bal. Account No.><Source No.><Account No.><Bal. Account No.><Source No.><Budgeted FA No.><Account No.><Bal. Account No.><IC Partner Code><Posting Group><Posting Group><Posting Group><Job No.><Payment Terms Code><Business Unit Code><Reason Code><Gen. Bus. Posting Group><Bal. Gen. Bus. Posting Group><Gen. Prod. Posting Group><Bal. Gen. Prod. Posting Group><Tax Area Code><Bal. Tax Area Code><Tax Group Code><Bal. Tax Group Code><VAT Bus. Posting Group><Bal. VAT Bus. Posting Group><VAT Prod. Posting Group><Bal. VAT Prod. Posting Group><Ship-to/Order Address Code><Ship-to/Order Address Code><IC Partner G/L Acc. No.><Incoming Document Entry No.><Payment Method Code><Recipient Bank Account><Recipient Bank Account><Credit Card No.><Job Task No.><Job Unit Of Measure Code><Direct Debit Mandate ID><Data Exch. Entry No.><Deferral Code><Campaign No.><Depreciation Book Code><Duplicate in Depreciation Book><Maintenance Code><Insurance No.><Journal Line No.><Account No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Business Unit Filter><Exch. Rate Losses Acc.><Exch. Rate Gains Acc.><Residual Account><Comp. Exch. Rate Gains Acc.><Comp. Exch. Rate Losses Acc.><Equity Exch. Rate Gains Acc.><Equity Exch. Rate Losses Acc.><Minority Exch. Rate Gains Acc.><Minority Exch. Rate Losses Acc><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Default IC Partner G/L Acc. No><Map-to G/L Acc. No.><Default Deferral Template Code><Deferral Account><Bal. Account No.><Receivables Account><Payables Account><Acquisition Cost Account><Accum. Depreciation Account><Write-Down Account><Appreciation Account><Custom 1 Account><Custom 2 Account><Acq. Cost Acc. on Disposal><Accum. Depr. Acc. on Disposal><Write-Down Acc. on Disposal><Appreciation Acc. on Disposal><Custom 1 Account on Disposal><Custom 2 Account on Disposal><Gains Acc. on Disposal><Losses Acc. on Disposal><Book Val. Acc. on Disp. (Gain)><Sales Acc. on Disp. (Gain)><Write-Down Bal. Acc. on Disp.><Apprec. Bal. Acc. on Disp.><Custom 1 Bal. Acc. on Disposal><Custom 2 Bal. Acc. on Disposal><Maintenance Expense Account><Maintenance Bal. Acc.><Acquisition Cost Bal. Acc.><Depreciation Expense Acc.><Write-Down Expense Acc.><Appreciation Bal. Account><Custom 1 Expense Acc.><Custom 2 Expense Acc.><Sales Bal. Acc.><Sales Acc. on Disp. (Loss)><Book Val. Acc. on Disp. (Loss)><Receivables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding Account><Additional Fee Account><Interest Account><Debit Curr. Appln. Rndg. Acc.><Credit Curr. Appln. Rndg. Acc.><Debit Rounding Account><Credit Rounding Account><Payment Disc. Credit Acc.><Payment Tolerance Debit Acc.><Payment Tolerance Credit Acc.><Add. Fee per Line Account><Payables Account><Service Charge Acc.><Payment Disc. Debit Acc.><Invoice Rounding Account><Debit Curr. Appln. Rndg. Acc.><Credit Curr. Appln. Rndg. Acc.><Debit Rounding Account><Credit Rounding Account><Payment Disc. Credit Acc.><Payment Tolerance Debit Acc.><Payment Tolerance Credit Acc.><Customer Posting Group><Payment Terms Code><Cash Flow Payment Terms Code><Bill-to Customer No.><Payment Method Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Customer No.><Preferred Bank Account><Customer No.><Ship-to Filter><Customer No.><Customer No.><Bill-to Customer No.><Customer No.><Vendor Posting Group><Payment Terms Code><Cash Flow Payment Terms Code><Pay-to Vendor No.><Payment Method Code><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Vendor No.><Preferred Bank Account><Vendor No.><Vendor No.><Vendor No.><Vendor No.><Maintenance Vendor No.><Insurance Vendor No.><Bal. Account No.><Component of Main Asset><FA Posting Group><Job No.><Direct Debit Pmt. Terms Code><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group><Tax Area Code><Incoming Entry No.><Customer Bank Account Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Journal Template Name Code10
2 Line No. Integer
3 Account Type Option
4 Account No. Code20
5 Posting Date Date [ClosingDates:Yes]
6 Document Type Option
7 Document No. Code20
8 Description Text50
10 VAT % Decimal (0:5) Editable: No
11 Bal. Account No. Code20
12 Currency Code Code10
13 Amount Decimal
14 Debit Amount Decimal BlankZero: Yes
15 Credit Amount Decimal BlankZero: Yes
16 Amount (LCY) Decimal
17 Balance (LCY) Decimal Editable: No
18 Currency Factor Decimal (0:15) Editable: No
19 Sales/Purch. (LCY) Decimal
20 Profit (LCY) Decimal
21 Inv. Discount (LCY) Decimal
22 Bill-to/Pay-to No. Code20 Editable: No
23 Posting Group Code10 Editable: No
24 Shortcut Dimension 1 Code Code20
25 Shortcut Dimension 2 Code Code20
26 Salespers./Purch. Code Code10
29 Source Code Code10 Editable: No
30 System-Created Entry Boolean Editable: No
34 On Hold Code3
35 Applies-to Doc. Type Option
36 Applies-to Doc. No. Code20
38 Due Date Date
39 Pmt. Discount Date Date
40 Payment Discount % Decimal (0:5)
42 Job No. Code20
43 Quantity Decimal (0:5)
44 VAT Amount Decimal
45 VAT Posting Option Editable: No
47 Payment Terms Code Code10
48 Applies-to ID Code50
50 Business Unit Code Code20
51 Journal Batch Name Code10
52 Reason Code Code10
53 Recurring Method Option BlankZero: Yes
54 Expiration Date Date
55 Recurring Frequency DateFormula
56 Allocated Amt. (LCY) Decimal Editable: No
FlowField
57 Gen. Posting Type Option
58 Gen. Bus. Posting Group Code10
59 Gen. Prod. Posting Group Code10
60 VAT Calculation Type Option Editable: No
61 EU 3-Party Trade Boolean Editable: No
62 Allow Application Boolean
63 Bal. Account Type Option
64 Bal. Gen. Posting Type Option
65 Bal. Gen. Bus. Posting Group Code10
66 Bal. Gen. Prod. Posting Group Code10
67 Bal. VAT Calculation Type Option Editable: No
68 Bal. VAT % Decimal (0:5) Editable: No
69 Bal. VAT Amount Decimal
70 Bank Payment Type Option
71 VAT Base Amount Decimal
72 Bal. VAT Base Amount Decimal
73 Correction Boolean
75 Check Printed Boolean Editable: No
76 Document Date Date [ClosingDates:Yes]
77 External Document No. Code35
78 Source Type Option
79 Source No. Code20
80 Posting No. Series Code10
82 Tax Area Code Code20
83 Tax Liable Boolean
84 Tax Group Code Code10
85 Use Tax Boolean
86 Bal. Tax Area Code Code20
87 Bal. Tax Liable Boolean
88 Bal. Tax Group Code Code10
89 Bal. Use Tax Boolean
90 VAT Bus. Posting Group Code10
91 VAT Prod. Posting Group Code10
92 Bal. VAT Bus. Posting Group Code10
93 Bal. VAT Prod. Posting Group Code10
95 Additional-Currency Posting Option Editable: No
98 FA Add.-Currency Factor Decimal (0:15)
99 Source Currency Code Code10 Editable: No
100 Source Currency Amount Decimal Editable: No
101 Source Curr. VAT Base Amount Decimal Editable: No
102 Source Curr. VAT Amount Decimal Editable: No
103 VAT Base Discount % Decimal (0:5) Editable: No
104 VAT Amount (LCY) Decimal Editable: No
105 VAT Base Amount (LCY) Decimal Editable: No
106 Bal. VAT Amount (LCY) Decimal Editable: No
107 Bal. VAT Base Amount (LCY) Decimal Editable: No
108 Reversing Entry Boolean Editable: No
109 Allow Zero-Amount Posting Boolean Editable: No
110 Ship-to/Order Address Code Code10
111 VAT Difference Decimal Editable: No
112 Bal. VAT Difference Decimal Editable: No
113 IC Partner Code Code20 Editable: No
114 IC Direction Option
116 IC Partner G/L Acc. No. Code20
117 IC Partner Transaction No. Integer Editable: No
118 Sell-to/Buy-from No. Code20
119 VAT Registration No. Text20
120 Country/Region Code Code10
121 Prepayment Boolean
122 Financial Void Boolean Editable: No
165 Incoming Document Entry No. Integer
170 Creditor No. Code20 [Numeric:Yes]
171 Payment Reference Code50 [Numeric:Yes]
172 Payment Method Code Code10
173 Applies-to Ext. Doc. No. Code35
288 Recipient Bank Account Code10
289 Message to Recipient Text140
290 Exported to Payment File Boolean Editable: No
291 Has Payment Export Error Boolean Editable: No
FlowField
480 Dimension Set ID Integer Editable: No
827 Credit Card No. Code20
1001 Job Task No. Code20
1002 Job Unit Price (LCY) Decimal Editable: No
1003 Job Total Price (LCY) Decimal Editable: No
1004 Job Quantity Decimal (0:5)
1005 Job Unit Cost (LCY) Decimal Editable: No
1006 Job Line Discount % Decimal
1007 Job Line Disc. Amount (LCY) Decimal Editable: No
1008 Job Unit Of Measure Code Code10
1009 Job Line Type Option
1010 Job Unit Price Decimal
1011 Job Total Price Decimal Editable: No
1012 Job Unit Cost Decimal Editable: No
1013 Job Total Cost Decimal Editable: No
1014 Job Line Discount Amount Decimal
1015 Job Line Amount Decimal
1016 Job Total Cost (LCY) Decimal Editable: No
1017 Job Line Amount (LCY) Decimal Editable: No
1018 Job Currency Factor Decimal
1019 Job Currency Code Code10
1020 Job Planning Line No. Integer BlankZero: Yes
1030 Job Remaining Qty. Decimal (0:5)
1200 Direct Debit Mandate ID Code35
1220 Data Exch. Entry No. Integer Editable: No
1221 Payer Information Text50
1222 Transaction Information Text100
1223 Data Exch. Line No. Integer Editable: No
1224 Applied Automatically Boolean
1700 Deferral Code Code10
1701 Deferral Line No. Integer
5050 Campaign No. Code20
5400 Prod. Order No. Code20 Editable: No
5600 FA Posting Date Date
5601 FA Posting Type Option
5602 Depreciation Book Code Code10
5603 Salvage Value Decimal
5604 No. of Depreciation Days Integer BlankZero: Yes
5605 Depr. until FA Posting Date Boolean
5606 Depr. Acquisition Cost Boolean
5609 Maintenance Code Code10
5610 Insurance No. Code20
5611 Budgeted FA No. Code20
5612 Duplicate in Depreciation Book Code10
5613 Use Duplication List Boolean
5614 FA Reclassification Entry Boolean
5615 FA Error Entry No. Integer BlankZero: Yes
5616 Index Entry Boolean
5617 Source Line No. Integer
5618 Comment Text250

Keys

# Fields
0 Journal Template Name,Journal Batch Name,Line No. Clustered: Yes
MaintainSIFTIndex: No
1 Journal Template Name,Journal Batch Name,Posting Date,Document No. MaintainSQLIndex: No
2 Account Type,Account No.,Applies-to Doc. Type,Applies-to Doc. No.
3 Document No. MaintainSQLIndex: No
4 Incoming Document Entry No.

Table Relations To Other Tables

Field Related Table Related Field
Source No. Bank Account No. 1..n
Business Unit Code Business Unit Code 1..n
Campaign No. Campaign No. 1..n
Country/Region Code Country/Region Code 1..n
Source Currency Code Currency Code 1..n
Sell-to/Buy-from No. Customer No. 1..n
Recipient Bank Account Customer Bank Account Code 1..n
Posting Group Customer Posting Group Code 1..n
Credit Card No. DO Payment Credit Card No. 1..n
Data Exch. Entry No. Data Exch. Entry No. 1..n
Deferral Code Deferral Template Deferral Code 1..n
Duplicate in Depreciation Book Depreciation Book Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
FA Error Entry No. FA Ledger Entry Entry No. 1..n
Posting Group FA Posting Group Code 1..n
Budgeted FA No. Fixed Asset No. 1..n
Bal. Account No. G/L Account 1..n
Bal. Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Journal Batch Name Gen. Journal Batch Name 1..n
Journal Template Name Gen. Journal Template Name 1..n
Bal. Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
IC Partner G/L Acc. No. IC G/L Account No. 1..n
IC Partner Code IC Partner Code 1..n
Incoming Document Entry No. Incoming Document Entry No. 1..n
Insurance No. Insurance No. 1..n
Job No. Job No. 1..n
Job Task No. Job Task Job Task No. 1..n
Maintenance Code Maintenance Code 1..n
Posting No. Series No. Series Code 1..n
Ship-to/Order Address Code Order Address Code 1..n
Payment Method Code Payment Method Code 1..n
Payment Terms Code Payment Terms Code 1..n
Reason Code Reason Code Code 1..n
Direct Debit Mandate ID SEPA Direct Debit Mandate ID 1..n
Salespers./Purch. Code Salesperson/Purchaser Code 1..n
Ship-to/Order Address Code Ship-to Address Code 1..n
Source Code Source Code Code 1..n
Bal. Tax Area Code Tax Area Code 1..n
Bal. Tax Group Code Tax Group Code 1..n
Job Unit Of Measure Code Unit of Measure Code 1..n
Bal. VAT Bus. Posting Group VAT Business Posting Group Code 1..n
Bal. VAT Prod. Posting Group VAT Product Posting Group Code 1..n
Sell-to/Buy-from No. Vendor No. 1..n
Recipient Bank Account Vendor Bank Account Code 1..n
Posting Group Vendor Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Gen. Jnl. Allocation Journal Line No. 1..n