Purchasing Requisition History (POP30200)

azurecurveProductsMicrosoft Dynamics GP (0)PurchasingPurchasing Requisition History (POP30200)

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

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Requisition History
Physical Name: POP30200
Technical Name: popRequisitionHist

Group Display Name: Purchasing Requisition History
Group Technical Name: Purchasing Requisition History

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 History'].COMMNTID AS 'Purchasing Requisition History-Comment ID'
       ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
       POP30200 AS ['Purchasing Requisition History']
INNER JOIN
       SY04200 AS ['Comment Master']
              ON
                     ['Purchasing Requisition History'].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 History'].REQSTDBY AS 'Purchasing Requisition History-Requested By'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       POP30200 AS ['Purchasing Requisition History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Purchasing Requisition History'].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 History'].CCode AS 'Purchasing Requisition History-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       POP30200 AS ['Purchasing Requisition History']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Purchasing Requisition History'].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 History'].USER2ENT AS 'Purchasing Requisition History-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       POP30200 AS ['Purchasing Requisition History']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Purchasing Requisition History'].USER2ENT = ['Users Master'].USERID
29Flags SearchFlagsINT1Integer1
30VOIDED SearchVoidedCBBoolean0
31Workflow_Status SearchWorkflow StatusWorkflow StatusInteger0
32DomainUserName SearchDomain User NameSTR255String255
33USERDEF1 SearchUser Defined 1STR20String20
34USERDEF2 SearchUser Defined 2STR20String20
35DEX_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.
36DEX_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 History (POP30200)

Leave a Reply

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