JC_RFP_Transaction_HIST_LINES (JC30001L)

azurecurveProductsWennSoft Products (131)3rd PartyJC_RFP_Transaction_HIST_LINES (JC30001L)

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_LINES

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString1817
2DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
3SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
4WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
5Cost_Code_Number_Alias SearchCost Code Number AliasSTR350String3635
6GROSAMNT SearchGross AmountDLR11_$S2Currency1014
7TAXABLE SearchTaxableCB_TaxableBoolean20
8TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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'].TAXSCHID
9TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency1017
10RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
11CIS_Amount SearchCIS AmountDLR11_$S2Currency1014
12CITB_Amount SearchCITB AmountDLR11_$S2Currency1014
13TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
14TXENGCLD SearchTax Engine CalledYNBoolean20
azurecurveProductsWennSoft Products (131)3rd PartyJC_RFP_Transaction_HIST_LINES (JC30001L)

Leave a Reply

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