1.Functional Description
1.1Purpose
This business function is used to create DBA Cache History during the Pre-Payroll phase of the Pay Cycle.
1.2Setup Notes and Prerequisites
1.3Special Logic
This section should be used when additional logic is used in the Business Function for application specific functionality or exceptional situations.
2.Technical Specifications
2.1Parameters:
Data Item Data Structure Description I/ORequiredNotes
PID Check Control Cache NameIY
PID1 Check Control Cache NameIY
AN8 Address Number IY
Payroll Month IY
Payroll Year IY
Payroll Quarter Beg MonthIY
Payroll Quarter End MonthIY
Calendar Month IY
Calendar Year IY
Calendar Quarter Beg MonthIY
Calendar Quarter End MonthIY
PID2 Timecard Cache Name IY
PAYD Payroll ID IY
Payment Year IY
HMCO Home Company IY
2.2Related Tables
Table Table Description
F06145Calendar Month DBA Summary History
F06146Payroll Month DBA Summary History
F069116Transaction Parameters File
F0709DBA Transaction Detail
2.3Related Business Functions
Source NameFunction Name
B070003Initialize/End Pre-Payroll Caches
2.4Processing
This business function processes the Check Control Number cache. For the first check control number read, it retrieves Calendar Payroll Month History,
DBA Transaction Detail and Payment Year DBA History, if the Payroll Year is different from the Payment Year.
D0700013 - DS for Create DBA Cache History
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szCheckControlCache | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
szDBACache | PID1 | char | OPT | NONE |
Program ID - 01 | ||||
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnPayrollMonth | HMO | MATH_NUMERIC | OPT | NONE |
The number of the month in which the history files were updated. | ||||
mnPayrollYear | YR | MATH_NUMERIC | OPT | NONE |
The calendar year for this calendar. | ||||
mnPayrollQuarterBeginMonth | PNF | MATH_NUMERIC | OPT | NONE |
This period number allows you to specify a default financial reporting date different from the actual accounting period. Because financial
| ||||
mnPayrollQuarterEndMonth | PN | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
mnCalendarMonth | MADD | MATH_NUMERIC | OPT | NONE |
The number of months to add to or subtract from the date specified in the Based on Date field (DABS) to determine the discount due date or
| ||||
mnCalendarYear | YRO | MATH_NUMERIC | OPT | NONE |
The calender year. | ||||
mnCalendarQuarterBeginMonth | PNC | MATH_NUMERIC | OPT | NONE |
A number (from 1 to 14) that identifies the current accounting period . The system uses this number to generate error messages, such as
| ||||
mnCalendarQuarterEndMonth | PNK | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants file (F0010) and the
| ||||
szTimecardCache | PID2 | char | OPT | NONE |
Program ID - 02 | ||||
szPayrollID | PAYD | char | OPT | NONE |
A code that identifies a group of employees for whom you are processing payroll. Use this ID to process each step of the payroll
| ||||
mnPaymentYear | YR | MATH_NUMERIC | OPT | NONE |
The calendar year for this calendar. | ||||
szCompanyHome | HMCO | char | OPT | NONE |
The company number where the employee records generally reside. | ||||
jdDatePayCheck | CKDT | JDEDATE | OPT | NONE |
The date associated with the various types of net pay instructions. This date relates to a payroll check, an interim payment, a bank
| ||||
jdDatePayPeriodEnding_PPED | PPED | JDEDATE | OPT | NONE |
The last day of a processing period (pay period, month, quarter or year). | ||||
cProcInterims | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cMergeInterims | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cRetrievePDBAHistorySysFlag | PHIST | char | OPT | NONE |
A value that specifies how the system retrieves PDBA history during payroll processing. You can set up the system to retrieve employee
| ||||
cTaxCalcMethod | FICM | char | OPT | NONE |
A code that specifies the tax method that the Vertex payroll-tax calculation system uses to calculate certain taxes. The codes are defined in
| ||||
cBypassVoidwithSpecialTaxes | BPVD | char | OPT | NONE |
A code that indicates whether you want to bypass or process voided payments if those payments contain special taxes. Valid values
| ||||
jdDateBeginningEffective | EFTB | JDEDATE | OPT | NONE |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
| ||||
jdDateEndingEffective | EFTE | JDEDATE | OPT | NONE |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
| ||||
szCountryForPayroll | CCPR | char | OPT | NONE |
A user defined code list 00/CN that indicates the country in which the employee resides. |
B0700003 Create PrePayroll Caches | ||||
N0700470 Four-digit Year to Two-digit Year |
F0607 Wage Attachment Ledger File | ||||
F06116 Employee Transaction Detail File | ||||
F06145 Calendar Month DBA Summary History File | ||||
F06146 Employee Transaction History Summary | ||||
F069086 Payroll Corporate Tax Identification | ||||
F069116 Payroll Transaction Constants | ||||
F0709 Deduction/Benefit/Accrual Ledger File |