D0700370 - Add records to DBA Detail Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnPayDeductBenAccType | PDBA | MATH_NUMERIC | REQ | INPUT |
A code that defines the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are
| ||||
mnPayrollTransactionNo | PRTR | MATH_NUMERIC | REQ | INPUT |
A unique number that the system assigns to each timecard. You can use this field in the Time Entry By Job program to retrieve a specific
| ||||
mnMonthWorked | DTEM | MATH_NUMERIC | REQ | INPUT |
A two-digit number that specifies the applicable month. If you leave this field blank, the program uses the system date. | ||||
mnAmount | GPA | MATH_NUMERIC | OPT | NONE |
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor
| ||||
mnArrearageAmount | ARRA | MATH_NUMERIC | OPT | NONE |
The amount of the deduction that is being or has been reduced because the employee did not receive wages that could cover the payroll
| ||||
mnHoursWorked | PHRW | MATH_NUMERIC | OPT | NONE |
The number of hours associated with each transaction. | ||||
mnPiecesUnits | PCUN | MATH_NUMERIC | OPT | NONE |
The number of pieces for piecework or any other unit of measure you want to track for this employee. Examples are: recording miles driven
| ||||
szDBADetailCache | PID1 | char | OPT | NONE |
Program ID - 01 | ||||
mnCheckControlNumber | CKCN | MATH_NUMERIC | REQ | INPUT |
A number used to group all payroll transactions for each payment or individual interim payment. This number is carried into the accounting
| ||||
jdDateWorked | DWK | JDEDATE | OPT | NONE |
The date used as the actual work date or pay-period ending date. | ||||
szBusinessUnitDBAAllocation | MCUG | char | OPT | NONE |
This field will come from one of two sources:
1. Direct entry of a business unit on the One-Time-Override screen; or
2. When the system
| ||||
mnWorkState | WST | MATH_NUMERIC | OPT | NONE |
Vertex state code identifying the state where the employee works. REQUIRED. | ||||
mnWorkCounty | WCNT | MATH_NUMERIC | OPT | NONE |
Vertex county code identifying where the employee works. Zero fill if you do not need to calculate county taxes. | ||||
mnWorkCity | WCTY | MATH_NUMERIC | OPT | NONE |
Vertex city code identifying the city where the employee works. Zero fill if you do not need to calculate city taxes. | ||||
szUnionCode_UN | UN | char | OPT | NONE |
A user defined code (06/UN) that represents the union or plan in which the employee or group of employees work or participate. | ||||
szJobCode_JBCD | JBCD | char | OPT | NONE |
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and
| ||||
szJobStep_JBST | JBST | char | OPT | NONE |
A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job
| ||||
szWorkersCompInsurCode_WCMP | WCMP | char | OPT | NONE |
A user defined code (00/W) that represents a workers' compensation insurance (WCI) code. This code should correspond to the
| ||||
cFloatCode_WET | WET | char | OPT | NONE |
A code that specifies any special circumstances associated with the workers compensation insurance (WCI) code, resulting in multiple
| ||||
cF0709WrittenFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
B0700003 Create PrePayroll Caches |
None |