Table 5818 Detailed Matched Order Line in 28
- App
- Base Application
- Namespace
- Microsoft.Inventory.Tracking
Versions171819202122232425262728latest
Source29
Fields, 27
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Line No. | Integer | - |
| 2 | Type | Enum Purchase Line Type | - |
| 3 | No. | Code[20] | - |
| 4 | Description | Text[100] | - |
| 5 | Description 2 | Text[50] | - |
| 6 | Quantity | Decimal | - |
| 7 | Qty. Rcd. Not Invoiced | Decimal | - |
| 8 | Qty. to Invoice | Decimal | - |
| 9 | Qty. to Invoice (Base) | Decimal | - |
| 10 | Qty. Invoiced | Decimal | - |
| 11 | Qty. Invoiced (Base) | Decimal | - |
| 50 | Receipt on Invoice | Boolean | - |
| 100 | Order No. | Code[20] | - |
| 101 | Order Line No. | Integer | - |
| 200 | Receipt/Shipment No. | Code[20] | - |
| 201 | Receipt/Shipment Line No. | Integer | - |
| 220 | Your Reference | Text[35] | - |
| 221 | Vendor Order No. | Code[35] | - |
| 222 | Vendor Shipment No. | Code[35] | - |
| 223 | Vendor Invoice No. | Code[35] | - |
| 224 | Vendor Cr. Memo No. | Code[35] | - |
| 1000 | Indentation | Integer | - |
| 1001 | HasSubLines | Boolean | - |
| 1002 | Line | Text[250] | - |
| 1003 | Document Line SystemId | Guid | - |
| 1004 | Matched Order Line SystemId | Guid | - |
| 1005 | Matched Rcpt./Shpt. Line SysId | Guid | - |
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Line No., Order No., Order Line No., Receipt/Shipment No., Receipt/Shipment Line No. | - |