Labor Code MSTR (LC010014)

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

Product: Manufacturing (346)
Series:

Display Name: Labor Code MSTR
Physical Name: LC010014
Technical Name: Labor_Code_MSTR

Group Display Name: Manufacturing WIP
Group Technical Name: Manufacturing WIP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1LABORCODE_I SearchLabor CodeStringSTR1010
2CHANGEDATE_I SearchChange DateDateDT8
3LABCODEDESC_I SearchLabor Code DescriptionStringSTR_3030
4USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Labor Code MSTR'].USERID AS 'Labor Code MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       LC010014 AS ['Labor Code MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Labor Code MSTR'].USERID = ['Users Master'].USERID
5LABCODEPAYCODESEL_I SearchLabor Code PayCode SelectIntegerGB0
6PAYCODERATE1_I SearchPay Code Rate 1StringSTR6_Payroll_Code6
7PAYCODERATE2_I SearchPay Code Rate 2StringSTR6_Payroll_Code6
8PAYCODERATE3_I SearchPay Code Rate 3StringSTR6_Payroll_Code6
9NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Labor Code MSTR'].NOTEINDX AS 'Labor Code MSTR-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       LC010014 AS ['Labor Code MSTR']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Labor Code MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
10LC_Labor_Applied SearchLC Labor Applied AccountLong IntegerLI_1414
11LC_Fixed_Overhead SearchLC Fixed Overhead AccountLong IntegerLI_1414
12LC_Variable_Overhead SearchLC Variable Overhead AccountLong IntegerLI_1414
13COST_I SearchCostCurrencyDLR17_RBSO_UTR$17
14HOURPIECE1_I SearchHour Piece1IntegerDDL_Hour_Piece0
15EFFECTIVEDATE_I SearchEffective Date0DateDT8
16FIXAMTORPCT_I SearchFixed Amount or PercentIntegerGB0
17Fixed_Overhead_Amount SearchFixed Overhead AmountCurrencyDLR17_RBS0_UTR$17
18FIXOHDPCT_I SearchFixed Overhead PercentLong IntegerINTXXX.XXXXX%8
19FIXOHDEFFDATE_I SearchFixed Overhead Effective DateDateDT8
20VARAMTORPCT_I SearchVariable Amount or PercentIntegerGB0
21Variable_Overhead_Amount SearchVariable Overhead AmountCurrencyDLR17_RBS0_UTR$17
22VAROHDPCT_I SearchVariable Overhead PercentLong IntegerINTXXX.XXXXX%8
23VAROHDEFFDATE_I SearchVariable Overhead Effective DateDateDT8
24PENDINGCOST_I SearchPending CostCurrencyDLR17_RBSO_UTR$17
25PENDINGHOURPIECE_I SearchPending Hour PieceIntegerDDL_Hour_Piece0
26PENDEFFDATE_I SearchPending Effective DateDateDT8
27PENDFIXAMTORPCT_I SearchPending Fixed Amount or PercentIntegerGB0
28PENDFIXOHDAMT_I SearchPending Fixed Overhead AmountCurrencyDLR17_RBSO_UTR$17
29PENDFIXOHDPCT_I SearchPending Fixed Overhead PercentLong IntegerINTXXX.XXXXX%8
30PENDFIXOHDEFFDATE_I SearchPending Fixed Overhead Effective DateDateDT8
31PENDVARAMTORPCT_I SearchPending Variable Amount or PercentIntegerGB0
32PENDVAROHDAMT_I SearchPending Variable Overhead AmountCurrencyDLR17_RBSO_UTR$17
33PENDVAROHDPCT_I SearchPending Variable Overhead PercentLong IntegerINTXXX.XXXXX%8
34PENDVAROHDEFFDATE_I SearchPending Variable Overhead Effective DateDateDT8
35USELABORCODE SearchcbxUseLaborCodeBooleanCB_UseLaborCode0

Leave a Reply

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