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 TypeLength
1PONUMWRK SearchPurchase_Order_Number_WORK_STRSTR20_LBAUString20
2PURORDLINSEQ SearchPurchase_Order_Line_Sequence_DOLDLR17_RBS0_STRCurrency17
3SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString17
4LNSEQNBR SearchLine SEQ NumberSequence_NumberCurrency19
5DATE1 SearchDateDT6Date6
6ATYALLOC SearchQTY AllocatedDLR17_QTY_RBS0_UTRCurrency17
7QTYREMAI SearchQTY RemainingDLR17_QTY_RBS0_UTRCurrency17
8USERID SearchUser IDSTR15_User_IDString15
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_NumberString30
azurecurveProductsWennSoft Products (131)PurchasingPO_OPEN_LINE_SOP_Reserved (PO20204)

Leave a Reply

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