Purchasing Requisition Work (POP10200)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPurchasing Requisition Work (POP10200)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Requisition Work
Physical Name: POP10200
Technical Name: popRequisition

Group Display Name: Purchasing Requisition Transactions
Group Technical Name: Purchasing Requisition Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1POPRequisitionNumber SearchPOP Requisition NumberSTR17_POP_NumberString1817
2Requisition_Note_Index SearchRequisition Note IndexDLR14Currency1014
3RequisitionDescription SearchRequisition DescriptionSTR60String6260
4RequisitionStatus SearchRequisition StatusDDL_Requisition_StatusInteger20
5COMMNTID SearchComment IDSTR15_Comment_IDString1615
Key to the Comment Master (SY04200).

Click to show/hide

SELECT
       ['Purchasing Requisition Work'].COMMNTID AS 'Purchasing Requisition Work-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       POP10200 AS ['Purchasing Requisition Work']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Purchasing Requisition Work'].COMMNTID = ['Comment Master'].COMMNTID
6Comment_Note_Index SearchComment Note IndexDLR14Currency1014
7DOCDATE SearchDocument DateDTDate48
8REQDATE SearchRequired DateDATE_LDate40
9REQSTDBY SearchRequested BySTR20_LBString2220
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Purchasing Requisition Work'].REQSTDBY AS 'Purchasing Requisition Work-Requested By'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       POP10200 AS ['Purchasing Requisition Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Purchasing Requisition Work'].REQSTDBY = ['Users Master'].USERID
10PRSTADCD SearchPrimary Shipto Address CodeSTR15_LBAUString1615
11CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
12CONTACT SearchContactSTR60String6260
13ADDRESS1 SearchAddress 1STR60String6260
14ADDRESS2 SearchAddress 2STR60String6260
15ADDRESS3 SearchAddress 3STR60String6260
16CITY SearchCitySTR35String3635
17STATE SearchStateSTR30_StateString3029
18ZIPCODE SearchZip CodeSTR10String1210
19CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Purchasing Requisition Work'].CCode AS 'Purchasing Requisition Work-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       POP10200 AS ['Purchasing Requisition Work']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Purchasing Requisition Work'].CCode = ['VAT Country Code MSTR'].CCode
20COUNTRY SearchCountrySTR60String6260
21PHONE1 SearchPhone 1Phone_NumberString2214
22PHONE2 SearchPhone 2Phone_NumberString2214
23PHONE3 SearchPhone 3Phone_Number3String2214
24FAX SearchFaxSTR14_FAXString2214
25DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
26CREATDDT SearchCreated DateDTDate48
27MODIFDT SearchModified DateDTDate48
28USER2ENT SearchUser To EnterSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Purchasing Requisition Work'].USER2ENT AS 'Purchasing Requisition Work-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       POP10200 AS ['Purchasing Requisition Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Purchasing Requisition Work'].USER2ENT = ['Users Master'].USERID
29Flags SearchFlagsINT1Integer21
30Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
31DomainUserName SearchDomain User NameSTR255String256255
32USERDEF1 SearchUser Defined 1STR20String2220
33USERDEF2 SearchUser Defined 2STR20String2220
34DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
35DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPurchasing Requisition Work (POP10200)

Leave a Reply

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