Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 2 | Sell-to Customer No. | Code20 |
|
Editable: No |
| 3 | Document No. | Code20 |
|
|
| 4 | Line No. | Integer | ||
| 5 | Type | Option | [ ,G/L Account,Item,Resource,Fixed Asset,Charge (Item)] | |
| 6 | No. | Code20 | CaptionClass: GetCaptionClass(FIELDNO("No."))
|
|
| 7 | Location Code | Code10 |
|
|
| 8 | Posting Group | Code20 |
|
Editable: No |
| 10 | Shipment Date | Date | ||
| 11 | Description | Text50 | ||
| 12 | Description 2 | Text50 | ||
| 13 | Unit of Measure | Text10 | ||
| 15 | Quantity | Decimal (0:5) | ||
| 22 | Unit Price | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Unit Price")) AutoFormatType: 2 AutoFormatExpr: GetCurrencyCode |
|
| 23 | Unit Cost (LCY) | Decimal | AutoFormatType: 2 | |
| 25 | VAT % | Decimal (0:5) | Editable: No | |
| 27 | Line Discount % | Decimal (0:5) | MaxValue: 100 | |
| 28 | Line Discount Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
| 29 | Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
| 30 | Amount Including VAT | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
| 32 | Allow Invoice Disc. | Boolean | InitValue: Yes | |
| 34 | Gross Weight | Decimal (0:5) | ||
| 35 | Net Weight | Decimal (0:5) | ||
| 36 | Units per Parcel | Decimal (0:5) | ||
| 37 | Unit Volume | Decimal (0:5) | ||
| 38 | Appl.-to Item Entry | Integer | AccessByPermission: TableData 27=R | |
| 40 | Shortcut Dimension 1 Code | Code20 | CaptionClass: '1,2,1'
|
|
| 41 | Shortcut Dimension 2 Code | Code20 | CaptionClass: '1,2,2'
|
|
| 42 | Customer Price Group | Code10 |
|
|
| 45 | Job No. | Code20 |
|
|
| 52 | Work Type Code | Code10 |
|
|
| 63 | Shipment No. | Code20 | Editable: No | |
| 64 | Shipment Line No. | Integer | Editable: No | |
| 68 | Bill-to Customer No. | Code20 |
|
Editable: No |
| 69 | Inv. Discount Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
| 73 | Drop Shipment | Boolean | AccessByPermission: TableData 223=R | |
| 74 | Gen. Bus. Posting Group | Code20 |
|
|
| 75 | Gen. Prod. Posting Group | Code20 |
|
|
| 77 | VAT Calculation Type | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | |
| 78 | Transaction Type | Code10 |
|
|
| 79 | Transport Method | Code10 |
|
|
| 80 | Attached to Line No. | Integer |
|
|
| 81 | Exit Point | Code10 |
|
|
| 82 | Area | Code10 |
|
|
| 83 | Transaction Specification | Code10 |
|
|
| 84 | Tax Category | Code10 | ||
| 85 | Tax Area Code | Code20 |
|
|
| 86 | Tax Liable | Boolean | ||
| 87 | Tax Group Code | Code20 |
|
|
| 88 | VAT Clause Code | Code20 |
|
|
| 89 | VAT Bus. Posting Group | Code20 |
|
|
| 90 | VAT Prod. Posting Group | Code20 |
|
|
| 97 | Blanket Order No. | Code20 |
|
|
| 98 | Blanket Order Line No. | Integer |
|
|
| 99 | VAT Base Amount | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
Editable: No |
| 100 | Unit Cost | Decimal | AutoFormatType: 2 AutoFormatExpr: GetCurrencyCode |
Editable: No |
| 101 | System-Created Entry | Boolean | Editable: No | |
| 103 | Line Amount | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Line Amount")) AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
| 104 | VAT Difference | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
| 106 | VAT Identifier | Code20 | Editable: No | |
| 107 | IC Partner Ref. Type | Option | [ ,G/L Account,Item,,,Charge (Item),Cross reference,Common Item No.] | |
| 108 | IC Partner Reference | Code20 | ||
| 123 | Prepayment Line | Boolean | Editable: No | |
| 130 | IC Partner Code | Code20 |
|
|
| 131 | Posting Date | Date | ||
| 180 | Line Discount Calculation | Option | [None,%,Amount] | |
| 480 | Dimension Set ID | Integer |
|
Editable: No |
| 1001 | Job Task No. | Code20 |
|
Editable: No |
| 1002 | Job Contract Entry No. | Integer | Editable: No | |
| 1700 | Deferral Code | Code10 |
|
|
| 5402 | Variant Code | Code10 |
|
|
| 5403 | Bin Code | Code20 |
|
|
| 5404 | Qty. per Unit of Measure | Decimal (0:5) | Editable: No | |
| 5407 | Unit of Measure Code | Code10 |
|
|
| 5415 | Quantity (Base) | Decimal (0:5) | ||
| 5600 | FA Posting Date | Date | ||
| 5602 | Depreciation Book Code | Code10 |
|
|
| 5605 | Depr. until FA Posting Date | Boolean | ||
| 5612 | Duplicate in Depreciation Book | Code10 |
|
|
| 5613 | Use Duplication List | Boolean | ||
| 5700 | Responsibility Center | Code10 |
|
|
| 5705 | Cross-Reference No. | Code20 | AccessByPermission: TableData 5717=R | |
| 5706 | Unit of Measure (Cross Ref.) | Code10 |
|
|
| 5707 | Cross-Reference Type | Option | [ ,Customer,Vendor,Bar Code] | |
| 5708 | Cross-Reference Type No. | Code30 | ||
| 5709 | Item Category Code | Code20 |
|
|
| 5710 | Nonstock | Boolean | ||
| 5711 | Purchasing Code | Code10 |
|
|
| 5712 | Product Group Code | Code10 |
|
|
| 5811 | Appl.-from Item Entry | Integer | AccessByPermission: TableData 27=R | |
| 6608 | Return Reason Code | Code10 |
|
|
| 7001 | Allow Line Disc. | Boolean | InitValue: Yes | |
| 7002 | Customer Disc. Group | Code20 |
|
|
| 7004 | Price description | Text80 |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Document No.,Line No. | SumIndexFields: Amount,Amount Including VAT | Clustered: Yes MaintainSIFTIndex: No |
| 1 | Blanket Order No.,Blanket Order Line No. | ||
| 2 | Sell-to Customer No. | ||
| 3 | Sell-to Customer No.,Type,Document No. | MaintainSQLIndex: No | |
| 4 | Shipment No.,Shipment Line No. | ||
| 5 | Job Contract Entry No. | ||
| 6 | Bill-to Customer No. |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Area | Area | Code |
|
1..n |
| Bin Code | Bin | Code |
|
1..n |
| Bill-to Customer No. | Customer | No. |
|
1..n |
| Customer Disc. Group | Customer Discount Group | Code |
|
1..n |
| Customer Price Group | Customer Price Group | Code |
|
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 |
| Exit Point | Entry/Exit Point | Code |
|
1..n |
| Posting Group | FA Posting Group | Code |
|
1..n |
| No. | Fixed Asset | No. |
|
1..n |
| No. | G/L Account | No. |
|
1..n |
| Gen. Bus. Posting Group | Gen. Business Posting Group | Code |
|
1..n |
| Gen. Prod. Posting Group | Gen. Product Posting Group | Code |
|
1..n |
| IC Partner Code | IC Partner | Code |
|
1..n |
| Posting Group | Inventory Posting Group | Code |
|
1..n |
| No. | Item | No. |
|
1..n |
| Item Category Code | Item Category | Code |
|
1..n |
| No. | Item Charge | No. |
|
1..n |
| Unit of Measure (Cross Ref.) | Item Unit of Measure | Code |
|
1..n |
| Variant Code | Item Variant | Code |
|
1..n |
| Job No. | Job | No. |
|
1..n |
| Job Task No. | Job Task | Job Task No. |
|
1..n |
| Location Code | Location |
|
1..n | |
| Purchasing Code | Purchasing | Code |
|
1..n |
| No. | Resource | No. |
|
1..n |
| Responsibility Center | Responsibility Center | Code |
|
1..n |
| Return Reason Code | Return Reason | Code |
|
1..n |
| Blanket Order No. | Sales Header | No. |
|
1..n |
| Document No. | Sales Invoice Header | No. |
|
1..n |
| Attached to Line No. | Sales Invoice Line | Line No. |
|
1..n |
| Blanket Order Line No. | Sales Line | Line No. |
|
1..n |
| Tax Area Code | Tax Area | Code |
|
1..n |
| Tax Group Code | Tax Group | Code |
|
1..n |
| Transaction Specification | Transaction Specification | Code |
|
1..n |
| Transaction Type | Transaction Type | Code |
|
1..n |
| Transport Method | Transport Method | Code |
|
1..n |
| Unit of Measure Code | Unit of Measure | Code |
|
1..n |
| VAT Bus. Posting Group | VAT Business Posting Group | Code |
|
1..n |
| VAT Clause Code | VAT Clause | Code |
|
1..n |
| VAT Prod. Posting Group | VAT Product Posting Group | Code |
|
1..n |
| Work Type Code | Work Type | Code |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Sales Invoice Line | Attached to Line No. |
|
1..n |