PO_User_MSTR (PO50101)

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

Product: WennSoft Products (131)
Series: Purchasing

Display Name: PO_User_MSTR
Physical Name: PO50101
Technical Name: PO_User_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PO_User_MSTR'].USERID AS 'PO_User_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PO50101 AS ['PO_User_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PO_User_MSTR'].USERID = ['Users Master'].USERID
2PO_User_Escalation_Group SearchPO_User_Escalation_Group_ID_STRSTR15_Escalation_IDString1615
3PO_User_Email_Addr_STR SearchPO_User_Email_Addr_STRSTR50String5250
4PO_Enter_Req_Indicator_I SearchPO_Enter_Req_Indicator_INTCBBoolean20
5PO_Enter_Orders_Indicato SearchPO_Enter_Orders_Indicator_INTCBBoolean20
6PO_Approve_Orders_Indica SearchPO_Approve_Orders_Indicator_INTCBBoolean20
7PO_Enter_Req_Start_Date_ SearchPO_Enter_Req_Start_Date_DATEDATE_LDate40
8PO_Enter_Req_End_Date_DA SearchPO_Enter_Req_End_Date_DATEDATE_LDate40
9PO_Enter_Orders_Start_Da SearchPO_Enter_Orders_Start_DateDATE_LDate40
10PO_Enter_Orders_End_Date SearchPO_Enter_Orders_End_Date_DATEDATE_LDate40
11PO_Approve_Orders_Start_ SearchPO_Approve_Orders_Start_DATEDATE_LDate40
12PO_Approve_Orders_End_DA SearchPO_Approve_Orders_End_DATEDATE_LDate40
13PO_Requisition_Limit_Val SearchPO_Requisition_Limit_Value_DOLDollar19Currency1019
14PO_Purch_Ord_Approv_Limi SearchPO_Purch_Ord_Approv_Limit_Val_DOLDollar19Currency1019
15PO_Order_Limit_Value SearchPO_Order_Limit_Value_DOLDollar19Currency1019
16RECSTAT SearchReceivings_Status_CBCB_Receivings_StatusBoolean20
17INVGDS SearchInvoice_Goods_Status_CBInvoice_Goods_Status_CBBoolean20
18PO_Approve_Over_Commitme SearchPO_Approve_Over_Commitments_CBPO_Approve_Over_Commitments_CBBoolean20

Leave a Reply

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