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 TypeSQL DB LengthKeyable Length
1WS_Job_Number SearchWS Job NumberSTR17_LBAUString1817
2WS_Job_Name SearchWS Job NameSTR30String3230
3CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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_LBAUString1817
5RMDTYPAL SearchRM Document Type-AllINT2Integer22
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 NumberSTR51String65
7Printed_Date SearchPrinted DateDATEDate46
8Schedule_Start_Date SearchSchedule Start DateDATEDate46
9JC_Contract_Number SearchJC Contract NumberSTR15String1615
10Orig_Contract_Amount SearchOriginal Contract AmountDLR19_TSCurrency1019
11Change_Orders_TTD SearchChange Orders TTDDLR19_TSCurrency1019
12Expected_Contract SearchExpected ContractDLR19_TSCurrency1019
13Completed_Stored SearchCompleted StoredDLR19_TSCurrency1019
14Retention_Pct SearchRetention %DLR14_TSCurrency1014
15RETNAGAM SearchRetainage AmountDLR17_RBS0_UTR$Currency1017
16Stored_Materials SearchStored MaterialsDLR14_TSCurrency1014
17Total_Retention SearchTotal RetentionDLR19_TSCurrency1019
18Total_Earned SearchTotal EarnedDLR19_TSCurrency1019
19Net_Billed_TTD SearchNet Billed TTDDLR14_TSCurrency1014
20DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
21Prev_Chg_Ord_Add SearchPrevious Change Order AddDLR19_TSCurrency1019
22Prev_Chg_Ord_Ded SearchPrevious Change Order DeductionDLR19_$S2Currency1019
23Curr_Month_Chg_Ord_Add SearchCurrent Month Change Order AddDLR19_TSCurrency1019
24Curr_Month_Chg_Ord_Ded SearchCurrent Month Change Order DeductionDLR19_$S2Currency1019
25CMPANYID SearchCompany IDINT5Integer24
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 NumberString2220
azurecurveProductsWennSoft Products (131)3rd PartyJC_Application_Payment_TEMP (JC50201)

Leave a Reply

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