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