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 | Job No. (Job No.) | Code20 |
|
|
4 | Posting Date (Posting Date) | Date | ||
5 | Document No. (Document No.) | Code20 | ||
6 | Type (Type) | Option | [Resource,Item,G/L Account] | |
8 | No. (No.) | Code20 |
|
|
9 | Description (Description) | Text50 | ||
10 | Quantity (Quantity) | Decimal (0:5) | ||
12 | Direct Unit Cost (LCY) (Direct Unit Cost (LCY)) | Decimal | AutoFormatType: 2 | |
13 | Unit Cost (LCY) (Unit Cost (LCY)) | Decimal | AutoFormatType: 2 | Editable: No |
14 | Total Cost (LCY) (Total Cost (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
15 | Unit Price (LCY) (Unit Price (LCY)) | Decimal | AutoFormatType: 2 | Editable: No |
16 | Total Price (LCY) (Total Price (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
17 | Resource Group No. (Resource Group No.) | Code20 |
|
Editable: No |
18 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
21 | Location Code (Location Code) | Code10 |
|
|
22 | Chargeable (Chargeable) | Boolean | InitValue: Yes | |
30 | Posting Group (Posting Group) | Code20 |
|
Editable: No |
31 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
32 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
33 | Work Type Code (Work Type Code) | Code10 |
|
|
34 | Customer Price Group (Customer Price Group) | Code10 |
|
|
37 | Applies-to Entry (Applies-to Entry) | Integer | AccessByPermission: TableData 27=R | |
61 | Entry Type (Entry Type) | Option | [Usage,Sale] | Editable: No |
62 | Source Code (Source Code) | Code10 |
|
Editable: No |
73 | Journal Batch Name (Journal Batch Name) | Code10 |
|
|
74 | Reason Code (Reason Code) | Code10 |
|
|
75 | Recurring Method (Recurring Method) | Option | [,Fixed,Variable] | BlankZero: Yes |
76 | Expiration Date (Expiration Date) | Date | ||
77 | Recurring Frequency (Recurring Frequency) | DateFormula | ||
79 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code20 |
|
|
80 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code20 |
|
|
81 | Transaction Type (Transaction Type) | Code10 |
|
|
82 | Transport Method (Transport Method) | Code10 |
|
|
83 | Country/Region Code (Country/Region Code) | Code10 |
|
|
86 | Entry/Exit Point (Entry/Exit Point) | Code10 |
|
|
87 | Document Date (Document Date) | Date | ||
88 | External Document No. (External Document No.) | Code35 | ||
89 | Area (Area) | Code10 |
|
|
90 | Transaction Specification (Transaction Specification) | Code10 |
|
|
91 | Serial No. (Serial No.) | Code20 | ||
92 | Posting No. Series (Posting No. Series) | Code20 |
|
|
93 | Source Currency Code (Source Currency Code) | Code10 |
|
Editable: No |
94 | Source Currency Total Cost (Source Currency Total Cost) | Decimal | AutoFormatType: 1 | Editable: No |
95 | Source Currency Total Price (Source Currency Total Price) | Decimal | AutoFormatType: 1 | Editable: No |
96 | Source Currency Line Amount (Source Currency Line Amount) | Decimal | AutoFormatType: 1 | Editable: No |
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
950 | Time Sheet No. (Time Sheet No.) | Code20 |
|
|
951 | Time Sheet Line No. (Time Sheet Line No.) | Integer |
|
|
952 | Time Sheet Date (Time Sheet Date) | Date |
|
|
1000 | Job Task No. (Job Task No.) | Code20 |
|
|
1001 | Total Cost (Total Cost) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
1002 | Unit Price (Unit Price) | Decimal | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
|
1003 | Line Type (Line Type) | Option | [ ,Budget,Billable,Both Budget and Billable] | |
1004 | Applies-from Entry (Applies-from Entry) | Integer | ||
1005 | Job Posting Only (Job Posting Only) | Boolean | ||
1006 | Line Discount % (Line Discount %) | Decimal (0:5) | MaxValue: 100 | |
1007 | Line Discount Amount (Line Discount Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
1008 | Currency Code (Currency Code) | Code10 |
|
Editable: No |
1009 | Line Amount (Line Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
1010 | Currency Factor (Currency Factor) | Decimal (0:15) | Editable: No | |
1011 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
|
1012 | Line Amount (LCY) (Line Amount (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
1013 | Line Discount Amount (LCY) (Line Discount Amount (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
1014 | Total Price (Total Price) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
1015 | Cost Factor (Cost Factor) | Decimal | Editable: No | |
1016 | Description 2 (Description 2) | Text50 | ||
1017 | Ledger Entry Type (Ledger Entry Type) | Option | [ ,Resource,Item,G/L Account] | |
1018 | Ledger Entry No. (Ledger Entry No.) | Integer |
|
BlankZero: Yes |
1019 | Job Planning Line No. (Job Planning Line No.) | Integer | BlankZero: Yes | |
1030 | Remaining Qty. (Remaining Qty.) | Decimal (0:5) | ||
1031 | Remaining Qty. (Base) (Remaining Qty. (Base)) | Decimal | ||
5402 | Variant Code (Variant Code) | Code10 |
|
|
5403 | Bin Code (Bin Code) | Code20 | AccessByPermission: TableData 5771=R | |
5404 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | InitValue: 1 | Editable: No |
5410 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
5468 | Reserved Qty. (Base) (Reserved Qty. (Base)) | Decimal (0:5) | AccessByPermission: TableData 27=R
|
Editable: No FlowField |
5900 | Service Order No. (Service Order No.) | Code20 | ||
5901 | Posted Service Shipment No. (Posted Service Shipment No.) | Code20 | ||
6501 | Lot No. (Lot No.) | Code20 | Editable: No |
Keys
# | Fields | ||
---|---|---|---|
0 | Journal Template Name,Journal Batch Name,Line No. (Journal Template Name,Journal Batch Name,Line No.) | Clustered: Yes | |
1 | Journal Template Name,Journal Batch Name,Type,No.,Unit of Measure Code,Work Type Code (Journal Template Name,Journal Batch Name,Type,No.,Unit of Measure Code,Work Type Code) | MaintainSQLIndex: No |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Area (Area) | Area | Code (Code) |
|
1..n |
Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
Customer Price Group (Customer Price Group) | Customer Price Group | 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 |
Entry/Exit Point (Entry/Exit Point) | Entry/Exit Point | Code (Code) |
|
1..n |
No. (No.) | G/L Account | No. (No.) |
|
1..n |
Ledger Entry No. (Ledger Entry No.) | G/L Entry | Entry No. (Entry No.) |
|
1..n |
Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
Posting Group (Posting Group) | Inventory Posting Group | Code (Code) |
|
1..n |
No. (No.) | Item | No. (No.) |
|
1..n |
Ledger Entry No. (Ledger Entry No.) | Item Ledger Entry | Entry No. (Entry No.) |
|
1..n |
Unit of Measure Code (Unit of Measure Code) | Item Unit of Measure | Code (Code) |
|
1..n |
Variant Code (Variant Code) | Item Variant | Code (Code) |
|
1..n |
Job No. (Job No.) | Job | No. (No.) |
|
1..n |
Journal Batch Name (Journal Batch Name) | Job Journal Batch | Name (Name) |
|
1..n |
Journal Template Name (Journal Template Name) | Job Journal Template | Name (Name) |
|
1..n |
Job Task No. (Job Task No.) | Job Task | Job Task No. (Job Task No.) |
|
1..n |
Location Code (Location Code) | Location | () |
|
1..n |
Posting No. Series (Posting No. Series) | No. Series | Code (Code) |
|
1..n |
Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
Ledger Entry No. (Ledger Entry No.) | Res. Ledger Entry | Entry No. (Entry No.) |
|
1..n |
No. (No.) | Resource | No. (No.) |
|
1..n |
Resource Group No. (Resource Group No.) | Resource Group | No. (No.) |
|
1..n |
Unit of Measure Code (Unit of Measure Code) | Resource Unit of Measure | Code (Code) |
|
1..n |
Source Code (Source Code) | Source Code | Code (Code) |
|
1..n |
Time Sheet Date (Time Sheet Date) | Time Sheet Detail | Date (Date) |
|
1..n |
Time Sheet No. (Time Sheet No.) | Time Sheet Header | No. (No.) |
|
1..n |
Time Sheet Line No. (Time Sheet Line No.) | Time Sheet Line | Line No. (Line No.) |
|
1..n |
Transaction Specification (Transaction Specification) | Transaction Specification | Code (Code) |
|
1..n |
Transaction Type (Transaction Type) | Transaction Type | Code (Code) |
|
1..n |
Transport Method (Transport Method) | Transport Method | Code (Code) |
|
1..n |
Unit of Measure Code (Unit of Measure Code) | Unit of Measure | Code (Code) |
|
1..n |
Work Type Code (Work Type Code) | Work Type | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field |
---|