Shipping History Line Hist (IS010201)

azurecurveProductsManufacturing (346)3rd PartyShipping History Line Hist (IS010201)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/IS010201

Product: Manufacturing (346)
Series:

Display Name: Shipping History Line Hist
Physical Name: IS010201
Technical Name: IC_SOP_LINE_HIST_Ship

Group Display Name: Manufacturing SOP
Group Technical Name: Manufacturing SOP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
2SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
3LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
4CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
5DATE1 SearchDateDateDT66
6DTSEQNUM SearchDate SEQ NumberCurrencySequence_Number19
7TIME1 SearchTimeTimeTM66
8QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
9SOSHIPPINGWEIGHT_I SearchSO Shipping WeightLong IntegerLI6_RBS2_UT6
10SHIPPINGUOFM_I SearchShipping U Of MIntegerDDL_Shipping_UofM0
11UPSZONE SearchUPS ZoneStringSTR33
12SOQTYPACKAGES_I SearchSO Qty PackagesCurrencyDLR17_QTY_RBS0_STR17
13SOBOLNUMBER_I SearchSO BOL NumberStringSTR2525
14MFGNOTEINDEX_I SearchMFG Note IndexCurrencyDLR1414
15USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Shipping History Line Hist'].USERID AS 'Shipping History Line Hist-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       IS010201 AS ['Shipping History Line Hist']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Shipping History Line Hist'].USERID = ['Users Master'].USERID
16SHIPMTHD SearchShipping MethodStringSTR15_Shipping_Method15
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Shipping History Line Hist'].SHIPMTHD AS 'Shipping History Line Hist-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       IS010201 AS ['Shipping History Line Hist']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Shipping History Line Hist'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
17SOPFOB_I SearchSOP_FOBStringSTR1515
18QTY_In_Variable_U_Of_M SearchQTY In Variable U Of MCurrencyDLR17_QTY_RBS0_STR17
19Variable_U_Of_M SearchVariable U Of MStringU_Of_M8
20Backout_Extended_Price SearchBackout Extended PriceCurrencyDLR17_RBS0_STR$17
21Tracking_Number SearchTracking NumberStringSTR4040
azurecurveProductsManufacturing (346)3rd PartyShipping History Line Hist (IS010201)

Leave a Reply

Your email address will not be published. Required fields are marked *