Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC30001L
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: JC_RFP_Transaction_HIST_LINES
Physical Name: JC30001L
Technical Name: JC_RFP_Transaction_HIST_LINESSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VCHNUMWK 
Voucher Number - WORK STR17_LBAU String 17 2 DOCTYPE Document Type DDL_Document_Type Integer 0 3 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 4 WS_Job_Number WS Job Number STR17_LBAU String 17 5 Cost_Code_Number_Alias Cost Code Number Alias STR350 String 35 6 GROSAMNT Gross Amount DLR11_$S2 Currency 14 7 TAXABLE Taxable CB_Taxable Boolean 0 8 TAXSCHID Tax Schedule ID STR15_Tax_Schedule_ID String 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['JC_RFP_Transaction_HIST_LINES'].TAXSCHID AS 'JC_RFP_Transaction_HIST_LINES-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
JC30001L AS ['JC_RFP_Transaction_HIST_LINES']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['JC_RFP_Transaction_HIST_LINES'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID9 TRDISAMT Trade Discount Amount DLR17_RBS0_UTR$ Currency 17 10 RETNAGAM Retainage Amount DLR17_RBS0_UTR$ Currency 17 11 CIS_Amount CIS Amount DLR11_$S2 Currency 14 12 CITB_Amount CITB Amount DLR11_$S2 Currency 14 13 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 14 TXENGCLD Tax Engine Called YN Boolean 0