Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Document Type (Document Type) | Option | [Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order] | |
| 2 | Buy-from Vendor No. (Buy-from Vendor No.) | Code20 |
|
|
| 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 |
|
|
| 7 | Location Code (Location Code) | Code10 |
|
|
| 8 | Posting Group (Posting Group) | Code10 |
|
|
| 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) | ||
| 16 | Outstanding Quantity (Outstanding Quantity) | Decimal (0:5) | ||
| 17 | Qty. to Invoice (Qty. to Invoice) | Decimal (0:5) | ||
| 18 | Qty. to Receive (Qty. to Receive) | Decimal (0:5) | AccessByPermission: TableData 120=R | |
| 22 | Direct Unit Cost (Direct Unit Cost) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Direct Unit Cost")) AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
|
| 23 | Unit Cost (LCY) (Unit Cost (LCY)) | Decimal | AutoFormatType: 2 | |
| 25 | VAT % (VAT %) | Decimal (0:5) | ||
| 26 | Quantity Disc. % (Quantity Disc. %) | Decimal (0:5) | MaxValue: 100 | |
| 27 | Line Discount % (Line Discount %) | Decimal (0:5) | MaxValue: 100 | |
| 28 | Line Discount Amount (Line Discount Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 29 | Amount (Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 30 | Amount Including VAT (Amount Including VAT) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 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 | |
| 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) | ||
| 57 | Outstanding Amount (Outstanding Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 58 | Qty. Rcd. Not Invoiced (Qty. Rcd. Not Invoiced) | Decimal (0:5) | ||
| 59 | Amt. Rcd. Not Invoiced (Amt. Rcd. Not Invoiced) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 60 | Quantity Received (Quantity Received) | Decimal (0:5) | AccessByPermission: TableData 120=R | |
| 61 | Quantity Invoiced (Quantity Invoiced) | Decimal (0:5) | ||
| 63 | Receipt No. (Receipt No.) | Code20 | ||
| 64 | Receipt Line No. (Receipt Line No.) | Integer | ||
| 67 | Profit % (Profit %) | Decimal (0:5) | ||
| 68 | Pay-to Vendor No. (Pay-to Vendor No.) | Code20 |
|
|
| 69 | Inv. Discount Amount (Inv. Discount Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 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 |
|
|
| 73 | Drop Shipment (Drop Shipment) | Boolean | AccessByPermission: TableData 223=R | |
| 74 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code10 |
|
|
| 75 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
|
| 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 |
|
Editable: No |
| 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) | Code10 |
|
|
| 88 | Use Tax (Use Tax) | Boolean | ||
| 89 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code10 |
|
|
| 90 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code10 |
|
|
| 91 | Currency Code (Currency Code) | Code10 |
|
|
| 92 | Outstanding Amount (LCY) (Outstanding Amount (LCY)) | Decimal | AutoFormatType: 1 | |
| 93 | Amt. Rcd. Not Invoiced (LCY) (Amt. Rcd. Not Invoiced (LCY)) | Decimal | AutoFormatType: 1 | |
| 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: "Currency Code" |
|
| 100 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
|
| 101 | System-Created Entry (System-Created Entry) | Boolean | ||
| 103 | Line Amount (Line Amount) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Line Amount")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 104 | VAT Difference (VAT Difference) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 105 | Inv. Disc. Amount to Invoice (Inv. Disc. Amount to Invoice) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 106 | VAT Identifier (VAT Identifier) | Code10 | ||
| 107 | IC Partner Ref. Type (IC Partner Ref. Type) | Option | [ ,G/L Account,Item,,,Charge (Item),Cross Reference,Common Item No.,Vendor Item No.] | |
| 108 | IC Partner Reference (IC Partner Reference) | Code20 | ||
| 109 | Prepayment % (Prepayment %) | Decimal (0:5) | MaxValue: 100 | |
| 110 | Prepmt. Line Amount (Prepmt. Line Amount) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt. Line Amount")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 111 | Prepmt. Amt. Inv. (Prepmt. Amt. Inv.) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt. Amt. Inv.")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
| 112 | Prepmt. Amt. Incl. VAT (Prepmt. Amt. Incl. VAT) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
| 113 | Prepayment Amount (Prepayment Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
| 114 | Prepmt. VAT Base Amt. (Prepmt. VAT Base Amt.) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
| 115 | Prepayment VAT % (Prepayment VAT %) | Decimal (0:5) | Editable: No | |
| 116 | Prepmt. VAT Calc. Type (Prepmt. VAT Calc. Type) | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | Editable: No |
| 117 | Prepayment VAT Identifier (Prepayment VAT Identifier) | Code10 | Editable: No | |
| 118 | Prepayment Tax Area Code (Prepayment Tax Area Code) | Code20 |
|
|
| 119 | Prepayment Tax Liable (Prepayment Tax Liable) | Boolean | ||
| 120 | Prepayment Tax Group Code (Prepayment Tax Group Code) | Code10 |
|
|
| 121 | Prepmt Amt to Deduct (Prepmt Amt to Deduct) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt Amt to Deduct")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 122 | Prepmt Amt Deducted (Prepmt Amt Deducted) | Decimal | CaptionClass: GetCaptionClass(FIELDNO("Prepmt Amt Deducted")) AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
| 123 | Prepayment Line (Prepayment Line) | Boolean | Editable: No | |
| 124 | Prepmt. Amount Inv. Incl. VAT (Prepmt. Amount Inv. Incl. VAT) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
| 130 | IC Partner Code (IC Partner Code) | Code20 |
|
|
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 1700 | Deferral Code (Deferral Code) | Code10 |
|
|
| 1702 | Returns Deferral Start Date (Returns Deferral Start Date) | Date | ||
| 5047 | Version No. (Version No.) | Integer | ||
| 5048 | Doc. No. Occurrence (Doc. No. Occurrence) | Integer | ||
| 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) | InitValue: 1 | |
| 5407 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
| 5415 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
| 5416 | Outstanding Qty. (Base) (Outstanding Qty. (Base)) | Decimal (0:5) | ||
| 5417 | Qty. to Invoice (Base) (Qty. to Invoice (Base)) | Decimal (0:5) | ||
| 5418 | Qty. to Receive (Base) (Qty. to Receive (Base)) | Decimal (0:5) | ||
| 5458 | Qty. Rcd. Not Invoiced (Base) (Qty. Rcd. Not Invoiced (Base)) | Decimal (0:5) | ||
| 5460 | Qty. Received (Base) (Qty. Received (Base)) | Decimal (0:5) | ||
| 5461 | Qty. Invoiced (Base) (Qty. Invoiced (Base)) | Decimal (0:5) | ||
| 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) | Code10 |
|
|
| 5710 | Nonstock (Nonstock) | Boolean | ||
| 5711 | Purchasing Code (Purchasing Code) | Code10 |
|
|
| 5712 | Product Group Code (Product Group Code) | Code10 |
|
|
| 5713 | Special Order (Special Order) | Boolean | ||
| 5714 | Special Order Sales No. (Special Order Sales No.) | Code20 |
|
|
| 5715 | Special Order Sales Line No. (Special Order Sales Line No.) | Integer |
|
|
| 5752 | Completely Received (Completely Received) | Boolean | ||
| 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 | |
| 5800 | Allow Item Charge Assignment (Allow Item Charge Assignment) | Boolean | InitValue: Yes AccessByPermission: TableData 5800=R |
|
| 5803 | Return Qty. to Ship (Return Qty. to Ship) | Decimal (0:5) | ||
| 5804 | Return Qty. to Ship (Base) (Return Qty. to Ship (Base)) | Decimal (0:5) | ||
| 5805 | Return Qty. Shipped Not Invd. (Return Qty. Shipped Not Invd.) | Decimal (0:5) | ||
| 5806 | Ret. Qty. Shpd Not Invd.(Base) (Ret. Qty. Shpd Not Invd.(Base)) | Decimal (0:5) | ||
| 5807 | Return Shpd. Not Invd. (Return Shpd. Not Invd.) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
| 5808 | Return Shpd. Not Invd. (LCY) (Return Shpd. Not Invd. (LCY)) | Decimal | AutoFormatType: 1 | |
| 5809 | Return Qty. Shipped (Return Qty. Shipped) | Decimal (0:5) | ||
| 5810 | Return Qty. Shipped (Base) (Return Qty. Shipped (Base)) | Decimal (0:5) | ||
| 6600 | Return Shipment No. (Return Shipment No.) | Code20 | ||
| 6601 | Return Shipment Line No. (Return Shipment Line No.) | Integer | 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 |
|
|
| 99000753 | Finished (Finished) | Boolean | ||
| 99000754 | Prod. Order Line No. (Prod. Order Line No.) | Integer |
|
|
| 99000755 | Overhead Rate (Overhead Rate) | Decimal (0:5) | ||
| 99000756 | MPS Order (MPS Order) | Boolean | ||
| 99000757 | Planning Flexibility (Planning Flexibility) | Option | [Unlimited,None] | |
| 99000758 | Safety Lead Time (Safety Lead Time) | DateFormula | ||
| 99000759 | Routing Reference No. (Routing Reference No.) | Integer |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Document Type,Document No.,Doc. No. Occurrence,Version No.,Line No. (Document Type,Document No.,Doc. No. Occurrence,Version No.,Line No.) | SumIndexFields: Amount,Amount Including VAT | Clustered: Yes |
| 1 | Document Type,Document No.,Line No.,Doc. No. Occurrence,Version No. (Document Type,Document No.,Line No.,Doc. No. Occurrence,Version No.) | ||
| 2 | Buy-from Vendor No. (Buy-from Vendor No.) | ||
| 3 | Pay-to Vendor No. (Pay-to 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 |
| Currency Code (Currency Code) | Currency | Code (Code) |
|
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 |
| 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 |
| IC Partner Code (IC Partner Code) | IC Partner | 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 |
| 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 |
| Product Group Code (Product Group Code) | Product Group | Code (Code) |
|
1..n |
| Blanket Order No. (Blanket Order No.) | Purchase Header | No. (No.) |
|
1..n |
| Document No. (Document No.) | Purchase Header Archive | No. (No.) |
|
1..n |
| Blanket Order Line No. (Blanket Order Line No.) | Purchase Line | Line No. (Line No.) |
|
1..n |
| Attached to Line No. (Attached to Line No.) | Purchase Line Archive | Line No. (Line No.) |
|
1..n |
| Purchasing Code (Purchasing Code) | Purchasing | Code (Code) |
|
1..n |
| No. (No.) | Resource | No. (No.) |
|
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 |
| Special Order Sales No. (Special Order Sales No.) | Sales Header | No. (No.) |
|
1..n |
| Special Order Sales Line No. (Special Order Sales Line No.) | Sales Line | Line No. (Line No.) |
|
1..n |
| No. (No.) | Standard Text | Code (Code) |
|
1..n |
| Prepayment Tax Area Code (Prepayment Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
| Prepayment Tax Group Code (Prepayment 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 | ||
|---|---|---|---|
| Purchase Line Archive | Attached to Line No. (Attached to Line No.) |
|
1..n |