WS_PO_Retention_TEMP (WSPORET1)

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

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: WS_PO_Retention_TEMP
Physical Name: WSPORET1
Technical Name: WS_PO_Retention_TEMP

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
       ['WS_PO_Retention_TEMP'].USERID AS 'WS_PO_Retention_TEMP-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       WSPORET1 AS ['WS_PO_Retention_TEMP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['WS_PO_Retention_TEMP'].USERID = ['Users Master'].USERID
2WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
3Divisions SearchDivisionsSTR15_LBAUString1615
4VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['WS_PO_Retention_TEMP'].VENDORID AS 'WS_PO_Retention_TEMP-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       WSPORET1 AS ['WS_PO_Retention_TEMP']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['WS_PO_Retention_TEMP'].VENDORID = ['PM Vendor Master File'].VENDORID
5Cost_Code_Alias SearchCost Code AliasSTR26String2826
6RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer410
7Retention_Amount_TTD SearchRetention Amount TTDDLR14_TSCurrency1014
8Retention_Pct SearchRetention %DLR14_TSCurrency1014
9RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
10EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency1017
11RETAINTX SearchRetainage Tax AmountDLR19_RBS0_STR$Currency1019

Leave a Reply

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