JC_Application_Payment_TEMP (JC50201)

azurecurveProductsWennSoft Products (131)3rd PartyJC_Application_Payment_TEMP (JC50201)

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

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

Display Name: JC_Application_Payment_TEMP
Physical Name: JC50201
Technical Name: JC_Application_Payment_TEMP

Group Display Name: Job Cost
Group Technical Name: Job Cost

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString17
2WS_Job_Name SearchWS Job NameSTR30String30
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['JC_Application_Payment_TEMP'].CUSTNMBR AS 'JC_Application_Payment_TEMP-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       JC50201 AS ['JC_Application_Payment_TEMP']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['JC_Application_Payment_TEMP'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
4RMDNUMWK SearchRM Document Number-WORKSTR17_LBAUString17
5RMDTYPAL SearchRM Document Type-AllINT2Integer2
Document Type records the type of document.

Click to show/hide the Document Types


0	Balance Carried Forward
1	Sales / Invoice
2	Scheduled Payments
3	Debit Memo
4	Finance Charge
5	Service Repairs
6	Warranties
7	Credit Memo
8	Returns
9	Payments
6WS_Application_Number SearchWS Application NumberSTR51String5
7Printed_Date SearchPrinted DateDATEDate6
8Schedule_Start_Date SearchSchedule Start DateDATEDate6
9JC_Contract_Number SearchJC Contract NumberSTR15String15
10Orig_Contract_Amount SearchOriginal Contract AmountDLR19_TSCurrency19
11Change_Orders_TTD SearchChange Orders TTDDLR19_TSCurrency19
12Expected_Contract SearchExpected ContractDLR19_TSCurrency19
13Completed_Stored SearchCompleted StoredDLR19_TSCurrency19
14Retention_Pct SearchRetention %DLR14_TSCurrency14
15RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency17
16Stored_Materials SearchStored MaterialsDLR14_TSCurrency14
17Total_Retention SearchTotal RetentionDLR19_TSCurrency19
18Total_Earned SearchTotal EarnedDLR19_TSCurrency19
19Net_Billed_TTD SearchNet Billed TTDDLR14_TSCurrency14
20DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
21Prev_Chg_Ord_Add SearchPrevious Change Order AddDLR19_TSCurrency19
22Prev_Chg_Ord_Ded SearchPrevious Change Order DeductionDLR19_$S2Currency19
23Curr_Month_Chg_Ord_Add SearchCurrent Month Change Order AddDLR19_TSCurrency19
24Curr_Month_Chg_Ord_Ded SearchCurrent Month Change Order DeductionDLR19_$S2Currency19
25CMPANYID SearchCompany IDINT5Integer4
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['JC_Application_Payment_TEMP'].CMPANYID AS 'JC_Application_Payment_TEMP-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       JC50201 AS ['JC_Application_Payment_TEMP']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['JC_Application_Payment_TEMP'].CMPANYID = ['Company Master'].CMPANYID
26PORDNMBR SearchPurchase Order NumberPurchase Order NumberString20
azurecurveProductsWennSoft Products (131)3rd PartyJC_Application_Payment_TEMP (JC50201)

Leave a Reply

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