JC_RFP_Transaction_WORK_LINES (JC10001L)

azurecurveProductsWennSoft Products (131)3rd PartyJC_RFP_Transaction_WORK_LINES (JC10001L)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/JC10001L

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: JC_RFP_Transaction_WORK_LINES
Physical Name: JC10001L
Technical Name: JC_RFP_Transaction_WORK_LINES

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1VCHNUMWK SearchVoucher Number - WORKSTR17_LBAUString17
2DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
3SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
4WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
5Cost_Code_Number_Alias SearchCost Code Number AliasSTR350String35
6GROSAMNT SearchGross AmountDLR11_$S2Currency14
7TAXABLE SearchTaxableCB_TaxableBoolean0
8TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['JC_RFP_Transaction_WORK_LINES'].TAXSCHID AS 'JC_RFP_Transaction_WORK_LINES-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       JC10001L AS ['JC_RFP_Transaction_WORK_LINES']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['JC_RFP_Transaction_WORK_LINES'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
9TRDISAMT SearchTrade Discount AmountDLR17_RBS0_UTR$Currency17
10RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency17
11CIS_Amount SearchCIS AmountDLR11_$S2Currency14
12CITB_Amount SearchCITB AmountDLR11_$S2Currency14
13TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
14TXENGCLD SearchTax Engine CalledYNBoolean0
azurecurveProductsWennSoft Products (131)3rd PartyJC_RFP_Transaction_WORK_LINES (JC10001L)

Leave a Reply

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