Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC90700
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_Inv_TRX_Level_Batch_VIEW
Physical Name: JC90700
Technical Name: JC_Inv_TRX_Level_Batch_VIEWSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BACHNUMB 
Batch Number STR15_LBAU String 15 2 RMDNUMWK RM Document Number-WORK STR17_LBAU String 17 3 Document_Source Document Source STR3 String 3 4 Job_TRX_Number Job TRX Number STR20 String 20 5 Cost_Element Cost Element INT3_RB0_U Integer 3 6 Cost_Code_Number_1 Cost Code Number:CC_Phase STR6_CC_Phase String 6 7 Cost_Code_Number_2 Cost Code Number:CC_Step STR6_CC_Steps String 6 8 Cost_Code_Number_3 Cost Code Number:CC_Detail STR6_CC_Detail String 6 9 Cost_Code_Number_4 Cost Code Number:CC_Component STR6_CC_Component String 6 10 LNSEQNBR Line SEQ Number Sequence_Number Currency 19 11 WS_Job_Number WS Job Number STR17_LBAU String 17 12 Project_Number WS Project Number STR170 String 17 13 Cost_Element_Desc Cost Element Description STR15 String 15 14 Cost_Code_Description Cost Code Description STR30 String 30 15 TRXQTY TRX QTY DLR17_QTY_RBS0_STR Currency 17 16 Current_Bill Current Bill DLR14_TS Currency 14 17 Apply_Transaction Apply Transaction CB Boolean 0 18 BCHSOURC Batch Source STR15 String 15 19 GLPOSTDT GL Posting Date DT Date 8 20 Profit_Type_Number Profit Type Number INT2 Integer 2 21 Profit_Amount Profit Amount DLR14_TS Currency 14 22 EMPLOYID Employee ID STR15_Employee_ID String 15 23 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['JC_Inv_TRX_Level_Batch_VIEW'].VENDORID AS 'JC_Inv_TRX_Level_Batch_VIEW-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
JC90700 AS ['JC_Inv_TRX_Level_Batch_VIEW']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['JC_Inv_TRX_Level_Batch_VIEW'].VENDORID = ['PM Vendor Master File'].VENDORID24 ITEMNMBR Item Number STR30_Item_Number String 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['JC_Inv_TRX_Level_Batch_VIEW'].ITEMNMBR AS 'JC_Inv_TRX_Level_Batch_VIEW-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
JC90700 AS ['JC_Inv_TRX_Level_Batch_VIEW']
INNER JOIN
IV00101 AS ['Item Master']
ON
['JC_Inv_TRX_Level_Batch_VIEW'].ITEMNMBR = ['Item Master'].ITEMNMBR