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 TypeLength
1USERID SearchUser IDSTR15_User_IDString15
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_LBAUString17
3Divisions SearchDivisionsSTR15_LBAUString15
4VENDORID SearchVendor IDSTR_15_Vendor_IDString15
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 AliasSTR26String26
6RCPTLNNM SearchReceipt Line NumberLI_Sequence_NumberLong Integer10
7Retention_Amount_TTD SearchRetention Amount TTDDLR14_TSCurrency14
8Retention_Pct SearchRetention %DLR14_TSCurrency14
9RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency17
10EXTDCOST SearchExtended CostDLR17_RBS0_UTR$Currency17
11RETAINTX SearchRetainage Tax AmountDLR19_RBS0_STR$Currency19

Leave a Reply

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