Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC11526
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC Contract Payment Distribution WORK OPEN
Physical Name: JC11526
Technical Name: JC_CP_Distribution_WORK_OPENSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID 
Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['JC Contract Payment Distribution WORK OPEN'].VENDORID AS 'JC Contract Payment Distribution WORK OPEN-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
JC11526 AS ['JC Contract Payment Distribution WORK OPEN']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['JC Contract Payment Distribution WORK OPEN'].VENDORID = ['PM Vendor Master File'].VENDORID2 CONTNBR Contract Number STR11 String 11 3 CONTCONBR Contract Change Order Number STR11 String 11 4 VCHRNMBR Voucher Number STR20_LBAU String 20 5 DSTSQNUM Distribution Sequence Number Long Int Long Integer 8 6 CNTRLTYP Control Type INT1 Integer 1 7 APTVCHNM Apply To Voucher Number STR20_LBAU String 20 8 SPCLDIST Specialized Distribution INT4 Integer 4 9 WS_Job_Number WS Job Number STR17_LBAU String 17 10 Cost_Element Cost Element INT3_RB0_U Integer 3 11 Cost_Code_Number_1 Cost Code Number:CC_Phase STR6_CC_Phase String 6 12 Cost_Code_Number_2 Cost Code Number:CC_Step STR6_CC_Steps String 6 13 Cost_Code_Number_3 Cost Code Number:CC_Detail STR6_CC_Detail String 6 14 Cost_Code_Number_4 Cost Code Number:CC_Component STR6_CC_Component String 6 15 WS_Cost_Code WS Cost Code LI8_U0 Long Integer 8 16 WS_Other_Cost_Sub_Code WS Other Cost Sub Code LI8_U0 Long Integer 8 17 Schedule_Line_SEQ_Number Schedule Line SEQ Number Sequence_Number Currency 19 18 Product_Indicator Product Indicator DDL_Product_Indicator Integer 0 19 Retention_Pct Retention % DLR14_TS Currency 14 20 Retention_Released Retention Released DLR19_TS Currency 19 21 Retention_Withheld Retention Withheld DLR14_TS Currency 14 22 Retention_Paid Retention Paid DLR19_TS Currency 19 23 Cost_Code_Actual_Units Cost Code Actual Units DLR14_TS Currency 14 24 Cost_Code_Released Cost Code Released DLR19_TS Currency 19 25 Cost_Code_Paid Cost Code Paid DLR19_TS Currency 19 26 MODIFDT Modified Date DT Date 8 27 Modified_Time Modified Time TM6 Time 6 28 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['JC Contract Payment Distribution WORK OPEN'].MDFUSRID AS 'JC Contract Payment Distribution WORK OPEN-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
JC11526 AS ['JC Contract Payment Distribution WORK OPEN']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['JC Contract Payment Distribution WORK OPEN'].MDFUSRID = ['Users Master'].USERID