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 TypeLength
1POPRequisitionNumber SearchPOP Requisition NumberSTR17_POP_NumberString17
2Requisition_Note_Index SearchRequisition Note IndexDLR14Currency14
3RequisitionDescription SearchRequisition DescriptionSTR60String60
4RequisitionStatus SearchRequisition StatusDDL_Requisition_StatusInteger0
5COMMNTID SearchComment IDSTR15_Comment_IDString15
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 IndexDLR14Currency14
7DOCDATE SearchDocument DateDTDate8
8REQDATE SearchRequired DateDATE_LDate0
9REQSTDBY SearchRequested BySTR20_LBString20
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_LBAUString15
11CMPNYNAM SearchCompany NameSTR64_Company_NameString64
12CONTACT SearchContactSTR60String60
13ADDRESS1 SearchAddress 1STR60String60
14ADDRESS2 SearchAddress 2STR60String60
15ADDRESS3 SearchAddress 3STR60String60
16CITY SearchCitySTR35String35
17STATE SearchStateSTR30_StateString29
18ZIPCODE SearchZip CodeSTR10String10
19CCode SearchCountry CodeSTR6_VATString6
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 SearchCountrySTR60String60
21PHONE1 SearchPhone 1Phone_NumberString14
22PHONE2 SearchPhone 2Phone_NumberString14
23PHONE3 SearchPhone 3Phone_Number3String14
24FAX SearchFaxSTR14_FAXString14
25DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
26CREATDDT SearchCreated DateDTDate8
27MODIFDT SearchModified DateDTDate8
28USER2ENT SearchUser To EnterSTR15_User_IDString15
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 SearchFlagsINT1Integer1
30Workflow_Status SearchWorkflow StatusWorkflow StatusInteger0
31DomainUserName SearchDomain User NameSTR255String255
32USERDEF1 SearchUser Defined 1STR20String20
33USERDEF2 SearchUser Defined 2STR20String20
34DEX_ROW_TS Searchdatetimedatetime3
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 Searchintint10

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 *