Table 111 Sales Shipment Line in 19
- App
- Base Application
Fields, 101Keys, 7Procedures, 17Events, 15
Versions171819202122232425262728latest
Source29
Fields, 101
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 2 | Sell-to Customer No. | Code[20] | - | ||||
| 3 | Document No. | Code[20] | - | ||||
| 4 | Line No. | Integer | - | ||||
| 5 | Type | Enum Sales Line Type | - | ||||
| 6 | No. | Code[20] | - | ||||
| 7 | Location Code | Code[10] | - | ||||
| 8 | Posting Group | Code[20] | - | ||||
| 10 | Shipment Date | Date | - | ||||
| 11 | Description | Text[100] | - | ||||
| 12 | Description 2 | Text[50] | - | ||||
| 13 | Unit of Measure | Text[50] | - | ||||
| 15 | Quantity | Decimal | - | ||||
| 22 | Unit Price | Decimal | - | ||||
| 23 | Unit Cost (LCY) | Decimal | - | ||||
| 25 | VAT % | Decimal | - | ||||
| 27 | Line Discount % | Decimal | - | ||||
| 32 | Allow Invoice Disc. | Boolean | - | ||||
| 34 | Gross Weight | Decimal | - | ||||
| 35 | Net Weight | Decimal | - | ||||
| 36 | Units per Parcel | Decimal | - | ||||
| 37 | Unit Volume | Decimal | - | ||||
| 38 | Appl.-to Item Entry | Integer | - | ||||
| 39 | Item Shpt. Entry No. | Integer | - | ||||
| 40 | Shortcut Dimension 1 Code | Code[20] | - | ||||
| 41 | Shortcut Dimension 2 Code | Code[20] | - | ||||
| 42 | Customer Price Group | Code[10] | - | ||||
| 45 | Job No. | Code[20] | - | ||||
| 52 | Work Type Code | Code[10] | - | ||||
| 58 | Qty. Shipped Not Invoiced | Decimal | - | ||||
| 61 | Quantity Invoiced | Decimal | - | ||||
| 65 | Order No. | Code[20] | - | ||||
| 66 | Order Line No. | Integer | - | ||||
| 68 | Bill-to Customer No. | Code[20] | - | ||||
| 71 | Purchase Order No. | Code[20] | - | ||||
| 72 | Purch. Order Line No. | Integer | - | ||||
| 73 | Drop Shipment | Boolean | - | ||||
| 74 | Gen. Bus. Posting Group | Code[20] | - | ||||
| 75 | Gen. Prod. Posting Group | Code[20] | - | ||||
| 77 | VAT Calculation Type | Enum Tax Calculation Type | - | ||||
| 78 | Transaction Type | Code[10] | - | ||||
| 79 | Transport Method | Code[10] | - | ||||
| 80 | Attached to Line No. | Integer | - | ||||
| 81 | Exit Point | Code[10] | - | ||||
| 82 | Area | Code[10] | - | ||||
| 83 | Transaction Specification | Code[10] | - | ||||
| 85 | Tax Area Code | Code[20] | - | ||||
| 86 | Tax Liable | Boolean | - | ||||
| 87 | Tax Group Code | Code[20] | - | ||||
| 89 | VAT Bus. Posting Group | Code[20] | - | ||||
| 90 | VAT Prod. Posting Group | Code[20] | - | ||||
| 91 | Currency Code | Code[10] | - | ||||
| 97 | Blanket Order No. | Code[20] | - | ||||
| 98 | Blanket Order Line No. | Integer | - | ||||
| 99 | VAT Base Amount | Decimal | - | ||||
| 100 | Unit Cost | Decimal | - | ||||
| 107 | IC Partner Ref. Type | Enum IC Partner Reference Type | - | ||||
| 108 | IC Partner Reference | Code[20] | - | ||||
| 131 | Posting Date | Date | - | ||||
| 138 | IC Item Reference No. | Code[50] | - | ||||
| 480 | Dimension Set ID | Integer | - | ||||
| 826 | Authorized for Credit Card | Boolean | - | ||||
| 1001 | Job Task No. | Code[20] | - | ||||
| 1002 | Job Contract Entry No. | Integer | - | ||||
| 5402 | Variant Code | Code[10] | - | ||||
| 5403 | Bin Code | Code[20] | - | ||||
| 5404 | Qty. per Unit of Measure | Decimal | - | ||||
| 5407 | Unit of Measure Code | Code[10] | - | ||||
| 5415 | Quantity (Base) | Decimal | - | ||||
| 5461 | Qty. Invoiced (Base) | Decimal | - | ||||
| 5600 | FA Posting Date | Date | - | ||||
| 5602 | Depreciation Book Code | Code[10] | - | ||||
| 5605 | Depr. until FA Posting Date | Boolean | - | ||||
| 5612 | Duplicate in Depreciation Book | Code[10] | - | ||||
| 5613 | Use Duplication List | Boolean | - | ||||
| 5700 | Responsibility Center | Code[10] | - | ||||
| 5705 | Cross-Reference No. | Code[20] | Pending 17.0 | ||||
| Cross-Reference replaced by Item Reference feature. | |||||||
| 5706 | Unit of Measure (Cross Ref.) | Code[10] | Pending 17.0 | ||||
| Cross-Reference replaced by Item Reference feature. | |||||||
| 5707 | Cross-Reference Type | Option | Pending 17.0 | ||||
| Cross-Reference replaced by Item Reference feature. | |||||||
| 5708 | Cross-Reference Type No. | Code[30] | Pending 17.0 | ||||
| Cross-Reference replaced by Item Reference feature. | |||||||
| 5709 | Item Category Code | Code[20] | - | ||||
| 5710 | Nonstock | Boolean | - | ||||
| 5711 | Purchasing Code | Code[10] | - | ||||
| 5712 | Product Group Code | Code[10] | Removed 15.0 | ||||
| Product Groups became first level children of Item Categories. | |||||||
| 5725 | Item Reference No. | Code[50] | - | ||||
| 5726 | Item Reference Unit of Measure | Code[10] | - | ||||
| 5727 | Item Reference Type | Enum Item Reference Type | - | ||||
| 5728 | Item Reference Type No. | Code[30] | - | ||||
| 5790 | Requested Delivery Date | Date | - | ||||
| 5791 | Promised Delivery Date | Date | - | ||||
| 5792 | Shipping Time | DateFormula | - | ||||
| 5793 | Outbound Whse. Handling Time | DateFormula | - | ||||
| 5794 | Planned Delivery Date | Date | - | ||||
| 5795 | Planned Shipment Date | Date | - | ||||
| 5811 | Appl.-from Item Entry | Integer | - | ||||
| 5812 | Item Charge Base Amount | Decimal | - | ||||
| 5817 | Correction | Boolean | - | ||||
| 6608 | Return Reason Code | Code[10] | - | ||||
| 7000 | Price Calculation Method | Enum Price Calculation Method | - | ||||
| 7001 | Allow Line Disc. | Boolean | - | ||||
| 7002 | Customer Disc. Group | Code[20] | - | ||||
| 8000 | Document Id | Guid | - | ||||
Keys, 7
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Document No., Line No. | - |
| Key2 | Order No., Order Line No., Posting Date | - |
| Key3 | Blanket Order No., Blanket Order Line No. | - |
| Key4 | Item Shpt. Entry No. | - |
| Key5 | Sell-to Customer No. | - |
| Key6 | Bill-to Customer No. | - |
| Key7 | Document Id | - |
Procedures, 17
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| GetCurrencyCode | () | Code[10] | public | - |
| ShowDimensions | () | public | - | |
| ShowItemTrackingLines | () | public | - | |
| InsertInvLineFromShptLine | (var Record Sales Line) | public | - | |
| GetSalesInvLines | (var Record Sales Invoice Line) | public | - | |
| CalcShippedSaleNotReturned | (var Decimal, var Decimal, Boolean) | public | - | |
| FilterPstdDocLnItemLedgEntries | (var Record Item Ledger Entry) | public | - | |
| ShowItemSalesInvLines | () | public | - | |
| ShowLineComments | () | public | - | |
| ShowAsmToOrder | () | public | - | |
| ShowShortcutDimCode | (var Code[20]) | public | - | |
| AsmToShipmentExists | (var Record Posted Assembly Header) | Boolean | public | - |
| InitFromSalesLine | (Record Sales Shipment Header, Record Sales Line) | public | - | |
| FormatType | () | Text | public | - |
| GetCaptionClass | (Integer) | Text[80] | public | - |
| HasTypeToFillMandatoryFields | () | Boolean | public | - |
| UpdateReferencedIds | () | public | - |
Events, 15
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterClearSalesLineValues | (var Record Sales Shipment Line, var Record Sales Line) | - |
| Integration event | OnAfterDescriptionSalesLineInsert | (var Record Sales Line, Record Sales Shipment Line, var Integer) | - |
| Integration event | OnAfterInitFromSalesLine | (Record Sales Shipment Header, Record Sales Line, var Record Sales Shipment Line) | - |
| Integration event | OnBeforeCalcShippedSaleNotReturned | (var Record Sales Shipment Line, var Decimal, var Decimal, Boolean, var Boolean) | - |
| Integration event | OnBeforeInsertInvLineFromShptLine | (var Record Sales Shipment Line, var Record Sales Line, Record Sales Line, var Boolean) | - |
| Integration event | OnBeforeCodeInsertInvLineFromShptLine | (var Record Sales Shipment Line, var Record Sales Line, var Boolean) | - |
| Integration event | OnInsertInvLineFromShptLineOnAfterAssignDescription | (var Record Sales Shipment Line, var Record Sales Line) | - |
| Integration event | OnInsertInvLineFromShptLineOnAfterCalcQuantities | (var Record Sales Line, Record Sales Line) | - |
| Integration event | OnInsertInvLineFromShptLineOnAfterUpdatePrepaymentsAmounts | (var Record Sales Line, var Record Sales Line, var Record Sales Shipment Line) | - |
| Integration event | OnInsertInvLineFromShptLineOnBeforeValidateQuantity | (Record Sales Shipment Line, var Record Sales Line, var Boolean) | - |
| Integration event | OnInsertInvLineFromShptLineOnBeforeInsertDescriptionLine | (Record Sales Shipment Line, var Record Sales Line, Record Sales Line, var Record Sales Header, var Integer) | - |
| Integration event | OnInsertInvLineFromShptLineOnAfterValidateInvDiscountAmount | (var Record Sales Line, Record Sales Line, Record Sales Shipment Line, Record Sales Header) | - |
| Integration event | OnAfterInsertInvLineFromShptLine | (var Record Sales Line, Record Sales Line, var Integer, Record Sales Shipment Line) | - |
| Integration event | OnBeforeInsertInvLineFromShptLineBeforeInsertTextLine | (var Record Sales Shipment Line, var Record Sales Line, var Integer, var Boolean, Record Sales Line, Record Sales Header) | - |
| Integration event | OnInsertInvLineFromShptLineOnAfterInsertAllLines | (Record Sales Shipment Line, var Record Sales Line) | - |