ReleaseUpdateDB60_Payroll.updatePayrollPayStatement Upgrade Script [AX 2012]
Updated: June 15, 2012
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
|
Class |
ReleaseUpdateDB60_Payroll |
|
Method |
updatePayrollPayStatement |
|
Description |
Inserts records into the PayrollPayStatement table from the PrlEmployeePayElementsTransPosted table. |
|
From Table: PRLEmployeePayElementsTransPosted |
To Table: PayrollPayStatement |
|---|---|
|
Worker |
Worker |
|
PaymMode |
PaymentMethodType |
|
VoidPost |
IsReversed |
|
PaymentDate |
PaymentDate |
|
RunType |
PaymentType |
|
SalaryExpenseJournalId |
PaymentJournalBatchNum |
|
From Table: PRLEmployeePayElementsTrans |
To Table: PayrollPayStatement |
|---|---|
|
Amount |
GrossAccountingCurrencyAmount |
|
Amount |
NetAccountingCurrencyAmount |
|
From Table: DEL_PRLPayrollPeriod |
To Table: PayrollPayStatement |
|---|---|
|
RecId |
PayPeriod |
|
From Table: PRLEmployeePayElementsTransPosted |
To Table: DocuRef |
|---|---|
|
txt |
Notes |
|
PayElementDate |
createdDateTime |
|
From Table: PRLEmployeePayElementsTrans |
To Table: DocuRef |
|---|---|
|
DataAreaId |
RefCompanyId |
|
From Table: PayrollPayStatement |
To Table: DocuRef |
|---|---|
|
RecId |
RefRecId |
|
TableId |
RefTableId |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).