APR Transaction Import WORK (APR10100)

azurecurveProductsHRM Solution Series (1911)PayrollAPR Transaction Import WORK (APR10100)

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

Product: HRM Solution Series (1911)
Series:

Display Name: APR Transaction Import WORK
Physical Name: APR10100
Technical Name: APR_Trx_Import_WORK

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1COMPTRNM SearchComputer TRX NumberLong IntegerLI8_U08
2BACHNUMB SearchBatch NumberStringSTR15_LBAU15
3EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
4COMPTRTP SearchComputer TRX TypeIntegerDDL_TRX_Type0
5UPRTRXCD SearchUPR TRX CodeStringSTR6_Payroll_Code6
6TRXBEGDT SearchTRX Beginning DateDateDT8
7TRXENDDT SearchTRX Ending DateDateDT8
8TRXHRUNT SearchTRX Hours/UnitsLong IntegerLI6_S26
9DAYSWRDK SearchDays WorkedLong IntegerLI6_S26
10WKSWRKD SearchWeeks WorkedLong IntegerLI6_S26
11INTERID SearchIntercompany IDStringSTR5_IC_ID5
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['APR Transaction Import WORK'].INTERID AS 'APR Transaction Import WORK-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       APR10100 AS ['APR Transaction Import WORK']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['APR Transaction Import WORK'].INTERID = ['Company Master'].INTERID
12DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
13JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
14LOCATNID SearchLocation IDStringSTR15_Location_ID15
15SHFTCODE SearchShift CodeStringSTR6_Payroll_Code6
16STATECD SearchState CodeStringSTR2_State_Code2
17SUTASTAT SearchSuta StateStringSTR2_State_Code2
18PAYRTAMT SearchPay Rate AmountCurrencyDLR11_$S214
19APR_Import_Group SearchAPR Import GroupStringSTR15_LBAU15
azurecurveProductsHRM Solution Series (1911)PayrollAPR Transaction Import WORK (APR10100)

Leave a Reply

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