Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
2 | Buy-from Vendor No. (Buy-from Vendor No.) | Code20 |
|
Editable: No |
3 | Document No. (Document No.) | Code20 |
|
|
4 | Line No. (Line No.) | Integer | ||
5 | Type (Type) | Option | [ ,G/L Account,Item,,Fixed Asset,Charge (Item)] | |
6 | No. (No.) | Code20 | CaptionClass: GetCaptionClass(FIELDNO("No."))
|
|
7 | Location Code (Location Code) | Code10 |
|
|
8 | Posting Group (Posting Group) | Code20 |
|
Editable: No |
10 | Expected Receipt Date (Expected Receipt Date) | Date | ||
11 | Description (Description) | Text50 | ||
12 | Description 2 (Description 2) | Text50 | ||
13 | Unit of Measure (Unit of Measure) | Text10 | ||
15 | Quantity (Quantity) | Decimal (0:5) | ||
22 | Direct Unit Cost (Direct Unit Cost) | Decimal | AutoFormatType: 2 AutoFormatExpr: GetCurrencyCodeFromHeader |
|
23 | Unit Cost (LCY) (Unit Cost (LCY)) | Decimal | AutoFormatType: 2 | |
25 | VAT % (VAT %) | Decimal (0:5) | Editable: No | |
27 | Line Discount % (Line Discount %) | Decimal (0:5) | MaxValue: 100 | |
31 | Unit Price (LCY) (Unit Price (LCY)) | Decimal | AutoFormatType: 2 | |
32 | Allow Invoice Disc. (Allow Invoice Disc.) | Boolean | InitValue: Yes | |
34 | Gross Weight (Gross Weight) | Decimal (0:5) | ||
35 | Net Weight (Net Weight) | Decimal (0:5) | ||
36 | Units per Parcel (Units per Parcel) | Decimal (0:5) | ||
37 | Unit Volume (Unit Volume) | Decimal (0:5) | ||
38 | Appl.-to Item Entry (Appl.-to Item Entry) | Integer | AccessByPermission: TableData 27=R | |
39 | Item Rcpt. Entry No. (Item Rcpt. Entry No.) | Integer | ||
40 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
41 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
45 | Job No. (Job No.) | Code20 |
|
|
54 | Indirect Cost % (Indirect Cost %) | Decimal (0:5) | ||
58 | Qty. Rcd. Not Invoiced (Qty. Rcd. Not Invoiced) | Decimal (0:5) | AccessByPermission: TableData 120=R | Editable: No |
61 | Quantity Invoiced (Quantity Invoiced) | Decimal (0:5) | Editable: No | |
65 | Order No. (Order No.) | Code20 | AccessByPermission: TableData 120=R | |
66 | Order Line No. (Order Line No.) | Integer | AccessByPermission: TableData 120=R | |
68 | Pay-to Vendor No. (Pay-to Vendor No.) | Code20 |
|
|
70 | Vendor Item No. (Vendor Item No.) | Text20 | ||
71 | Sales Order No. (Sales Order No.) | Code20 | ||
72 | Sales Order Line No. (Sales Order Line No.) | Integer | ||
74 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code20 |
|
|
75 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code20 |
|
|
77 | VAT Calculation Type (VAT Calculation Type) | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | |
78 | Transaction Type (Transaction Type) | Code10 |
|
|
79 | Transport Method (Transport Method) | Code10 |
|
|
80 | Attached to Line No. (Attached to Line No.) | Integer |
|
|
81 | Entry Point (Entry Point) | Code10 |
|
|
82 | Area (Area) | Code10 |
|
|
83 | Transaction Specification (Transaction Specification) | Code10 |
|
|
85 | Tax Area Code (Tax Area Code) | Code20 |
|
|
86 | Tax Liable (Tax Liable) | Boolean | ||
87 | Tax Group Code (Tax Group Code) | Code20 |
|
|
88 | Use Tax (Use Tax) | Boolean | ||
89 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code20 |
|
|
90 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code20 |
|
|
91 | Currency Code (Currency Code) | Code10 |
|
Editable: No FlowField |
97 | Blanket Order No. (Blanket Order No.) | Code20 |
|
|
98 | Blanket Order Line No. (Blanket Order Line No.) | Integer |
|
|
99 | VAT Base Amount (VAT Base Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCodeFromHeader |
Editable: No |
100 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 AutoFormatExpr: GetCurrencyCodeFromHeader |
Editable: No |
131 | Posting Date (Posting Date) | Date | ||
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
1001 | Job Task No. (Job Task No.) | Code20 |
|
|
1002 | Job Line Type (Job Line Type) | Option | [ ,Budget,Billable,Both Budget and Billable] | |
1003 | Job Unit Price (Job Unit Price) | Decimal | BlankZero: Yes | |
1004 | Job Total Price (Job Total Price) | Decimal | BlankZero: Yes | |
1005 | Job Line Amount (Job Line Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Job Currency Code" |
BlankZero: Yes |
1006 | Job Line Discount Amount (Job Line Discount Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Job Currency Code" |
BlankZero: Yes |
1007 | Job Line Discount % (Job Line Discount %) | Decimal (0:5) | MaxValue: 100 | BlankZero: Yes |
1008 | Job Unit Price (LCY) (Job Unit Price (LCY)) | Decimal | BlankZero: Yes | |
1009 | Job Total Price (LCY) (Job Total Price (LCY)) | Decimal | BlankZero: Yes | |
1010 | Job Line Amount (LCY) (Job Line Amount (LCY)) | Decimal | AutoFormatType: 1 | BlankZero: Yes |
1011 | Job Line Disc. Amount (LCY) (Job Line Disc. Amount (LCY)) | Decimal | AutoFormatType: 1 | BlankZero: Yes |
1012 | Job Currency Factor (Job Currency Factor) | Decimal | BlankZero: Yes | |
1013 | Job Currency Code (Job Currency Code) | Code20 | ||
5401 | Prod. Order No. (Prod. Order No.) | Code20 |
|
|
5402 | Variant Code (Variant Code) | Code10 |
|
|
5403 | Bin Code (Bin Code) | Code20 |
|
|
5404 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | Editable: No | |
5407 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
5415 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
5461 | Qty. Invoiced (Base) (Qty. Invoiced (Base)) | Decimal (0:5) | Editable: No | |
5600 | FA Posting Date (FA Posting Date) | Date | ||
5601 | FA Posting Type (FA Posting Type) | Option | [ ,Acquisition Cost,Maintenance] | |
5602 | Depreciation Book Code (Depreciation Book Code) | Code10 |
|
|
5603 | Salvage Value (Salvage Value) | Decimal | AutoFormatType: 1 | |
5605 | Depr. until FA Posting Date (Depr. until FA Posting Date) | Boolean | ||
5606 | Depr. Acquisition Cost (Depr. Acquisition Cost) | Boolean | ||
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 | ||
5700 | Responsibility Center (Responsibility Center) | Code10 |
|
|
5705 | Cross-Reference No. (Cross-Reference No.) | Code20 | AccessByPermission: TableData 5717=R | |
5706 | Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) | Code10 |
|
|
5707 | Cross-Reference Type (Cross-Reference Type) | Option | [ ,Customer,Vendor,Bar Code] | |
5708 | Cross-Reference Type No. (Cross-Reference Type No.) | Code30 | ||
5709 | Item Category Code (Item Category Code) | Code20 |
|
|
5710 | Nonstock (Nonstock) | Boolean | ||
5711 | Purchasing Code (Purchasing Code) | Code10 |
|
|
5712 | Product Group Code (Product Group Code) | Code10 |
|
|
5714 | Special Order Sales No. (Special Order Sales No.) | Code20 | ||
5715 | Special Order Sales Line No. (Special Order Sales Line No.) | Integer | ||
5790 | Requested Receipt Date (Requested Receipt Date) | Date | AccessByPermission: TableData 99000880=R | |
5791 | Promised Receipt Date (Promised Receipt Date) | Date | ||
5792 | Lead Time Calculation (Lead Time Calculation) | DateFormula | AccessByPermission: TableData 120=R | |
5793 | Inbound Whse. Handling Time (Inbound Whse. Handling Time) | DateFormula | AccessByPermission: TableData 14=R | |
5794 | Planned Receipt Date (Planned Receipt Date) | Date | ||
5795 | Order Date (Order Date) | Date | AccessByPermission: TableData 120=R | |
5811 | Item Charge Base Amount (Item Charge Base Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCodeFromHeader |
|
5817 | Correction (Correction) | Boolean | Editable: No | |
6608 | Return Reason Code (Return Reason Code) | Code10 |
|
|
99000750 | Routing No. (Routing No.) | Code20 |
|
|
99000751 | Operation No. (Operation No.) | Code10 |
|
|
99000752 | Work Center No. (Work Center No.) | Code20 |
|
|
99000754 | Prod. Order Line No. (Prod. Order Line No.) | Integer |
|
|
99000755 | Overhead Rate (Overhead Rate) | Decimal (0:5) | ||
99000759 | Routing Reference No. (Routing Reference No.) | Integer |
Keys
# | Fields | ||
---|---|---|---|
0 | Document No.,Line No. (Document No.,Line No.) | Clustered: Yes | |
1 | Order No.,Order Line No. (Order No.,Order Line No.) | ||
2 | Blanket Order No.,Blanket Order Line No. (Blanket Order No.,Blanket Order Line No.) | ||
3 | Item Rcpt. Entry No. (Item Rcpt. Entry No.) | ||
4 | Pay-to Vendor No. (Pay-to Vendor No.) | ||
5 | Buy-from Vendor No. (Buy-from Vendor No.) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Area (Area) | Area | Code (Code) |
|
1..n |
Bin Code (Bin Code) | Bin | Code (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 |
Entry Point (Entry Point) | Entry/Exit Point | Code (Code) |
|
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 |
No. (No.) | G/L Account | No. (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 |
Insurance No. (Insurance No.) | Insurance | No. (No.) |
|
1..n |
Posting Group (Posting Group) | Inventory Posting Group | Code (Code) |
|
1..n |
No. (No.) | Item | No. (No.) |
|
1..n |
Item Category Code (Item Category Code) | Item Category | Code (Code) |
|
1..n |
No. (No.) | Item Charge | No. (No.) |
|
1..n |
Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) | 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 |
Job Task No. (Job Task No.) | Job Task | Job Task No. (Job Task No.) |
|
1..n |
Location Code (Location Code) | Location | () |
|
1..n |
Maintenance Code (Maintenance Code) | Maintenance | Code (Code) |
|
1..n |
Prod. Order Line No. (Prod. Order Line No.) | Prod. Order Line | Line No. (Line No.) |
|
1..n |
Operation No. (Operation No.) | Prod. Order Routing Line | Operation No. (Operation No.) |
|
1..n |
Document No. (Document No.) | Purch. Rcpt. Header | No. (No.) |
|
1..n |
Attached to Line No. (Attached to Line No.) | Purch. Rcpt. Line | Line No. (Line No.) |
|
1..n |
Blanket Order No. (Blanket Order No.) | Purchase Header | No. (No.) |
|
1..n |
Blanket Order Line No. (Blanket Order Line No.) | Purchase Line | Line No. (Line No.) |
|
1..n |
Purchasing Code (Purchasing Code) | Purchasing | Code (Code) |
|
1..n |
Responsibility Center (Responsibility Center) | Responsibility Center | Code (Code) |
|
1..n |
Return Reason Code (Return Reason Code) | Return Reason | Code (Code) |
|
1..n |
Routing No. (Routing No.) | Routing Header | No. (No.) |
|
1..n |
Tax Area Code (Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
Tax Group Code (Tax Group Code) | Tax Group | Code (Code) |
|
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 |
VAT Bus. Posting Group (VAT Bus. Posting Group) | VAT Business Posting Group | Code (Code) |
|
1..n |
VAT Prod. Posting Group (VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
Pay-to Vendor No. (Pay-to Vendor No.) | Vendor | No. (No.) |
|
1..n |
Work Center No. (Work Center No.) | Work Center | No. (No.) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Item Charge Assignment (Purch) | Applies-to Doc. Line No. (Applies-to Doc. Line No.) |
|
1..n |
Purch. Rcpt. Line | Attached to Line No. (Attached to Line No.) |
|
1..n |