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 |