PO_OPEN_LINE_SOP_Reserved (PO20204)

azurecurveProductsWennSoft Products (131)PurchasingPO_OPEN_LINE_SOP_Reserved (PO20204)

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

Product: WennSoft Products (131)
Series: Purchasing

Display Name: PO_OPEN_LINE_SOP_Reserved
Physical Name: PO20204
Technical Name: PO_OPEN_LINE_SOP_Reserved

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PONUMWRK SearchPurchase_Order_Number_WORK_STRSTR20_LBAUString2220
2PURORDLINSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency1017
3SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
4LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency1019
5DATE1 SearchDateDT6Date46
6ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency1017
7QTYREMAI SearchQTY RemainingDLR17_QTY_RBS0_UTRCurrency1017
8USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PO_OPEN_LINE_SOP_Reserved'].USERID AS 'PO_OPEN_LINE_SOP_Reserved-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PO20204 AS ['PO_OPEN_LINE_SOP_Reserved']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PO_OPEN_LINE_SOP_Reserved'].USERID = ['Users Master'].USERID
9ITMNUM SearchItem_Number_STRSTR30_Item_NumberString3230
azurecurveProductsWennSoft Products (131)PurchasingPO_OPEN_LINE_SOP_Reserved (PO20204)

Leave a Reply

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