ICJC_Revenue_Expense_Code (ICJC0006)

azurecurveProductsManufacturing (346)3rd PartyICJC_Revenue_Expense_Code (ICJC0006)

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

Product: Manufacturing (346)
Series:

Display Name: ICJC_Revenue_Expense_Code
Physical Name: ICJC0006
Technical Name: ICJC_Revenue_Expense_Code

Group Display Name: Manufacturing Job Costing
Group Technical Name: Manufacturing Job Costing

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1REVENUEEXPENSECODE_I SearchRevenue/Expense CodeStringSTR2020
2REVEXPCODEDESCR_I SearchRev/Exp Code DescrStringSTR255255
3MFGNOTEINDEX_I SearchMFG Note IndexCurrencyDLR1414
4CHANGEDATE_I SearchChange DateDateDT8
5USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ICJC_Revenue_Expense_Code'].USERID AS 'ICJC_Revenue_Expense_Code-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       ICJC0006 AS ['ICJC_Revenue_Expense_Code']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ICJC_Revenue_Expense_Code'].USERID = ['Users Master'].USERID
6BOOLEANFLAG_I SearchBoolean FlagBooleanBoolean_Flag0
azurecurveProductsManufacturing (346)3rd PartyICJC_Revenue_Expense_Code (ICJC0006)

Leave a Reply

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