Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ISCVTLNE
Product: Manufacturing (346)
Series:
Display Name: Manufacturing SOP to Dynamics SOP Convert Log Line Group Display Name: Manufacturing SOP
Physical Name: ISCVTLNE
Technical Name: IC_SOP_Convert_LOG_LINE
Group Technical Name: Manufacturing SOP
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | SALESORDERNUMBER_I | Sales Order Number | String | STR17_IV_Document_Number | 17 | |
2 | SOLINEITEM_I | SO Line Item | Integer | INT3 | 3 | |
3 | SOBLANKETLINEITEM_I | SO Blanket Line Item | Integer | INT4_U0 | 4 | |
4 | DONECB_I | done_cb | Boolean | CB_Done | 0 | |
5 | SOP_LINE_Error_Convert1 | SOP LINE Error Convert1 | Long Integer | ML_SOP_LINE_Error_Convert1 | 0 | |
6 | SOPNUMBE | SOP Number | String | STR20_SOP_Number | 17 | |
7 | SOPTYPE | SOP Type | Integer | DDL_SOP_Type | 0 | |
8 | LNITMSEQ | Line Item Sequence | Long Integer | LI_Sequence_Number | 10 | |
9 | CMPNTSEQ | Component Sequence | Long Integer | LI_Sequence_Number | 10 | |
10 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Manufacturing SOP to Dynamics SOP Convert Log Line'].ITEMNMBR AS 'Manufacturing SOP to Dynamics SOP Convert Log Line-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ISCVTLNE AS ['Manufacturing SOP to Dynamics SOP Convert Log Line']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Manufacturing SOP to Dynamics SOP Convert Log Line'].ITEMNMBR = ['Item Master'].ITEMNMBR |