|
|
TIPCTL FILE
Tip Control
Contains the control totals of the individual gross receipts entries that are
used as a comparison to the allocation level gross receipts input. This file
is created when gross receipts are entered in TP20.1 (Gross Receipts by
Allocation Level).
UPDATED BY
TP100 TP105 TP20.1 TP20.2 TP20.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPC-COMPANY Numeric 4 TP20.1 TP20.2
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
TPC-PROCESS-LEVEL Alpha 5 TP20.1 TP20.2
Element: Process Lev HrContains the process level the pay is
associated with for allocation.
TPC-DEPARTMENT Alpha 5 TP20.1 TP20.2
Element: Department Contains the department the pay is
associated with for allocation.
TPC-SHIFT Numeric 1 TP20.1 TP20.2
Element: Shift Contains the shift number the
allocation is associated with.
TPC-RECORD-DATE Numeric 8 (yyyymmdd) TP20.1 TP20.2
Element: Record Date Contains the record date of the
transaction.
TPC-RCPT Signed 11.2 TP20.1 TP20.2
Element: Rcpt Contains the total employee gross
receipts for this allocation level and
date.
TPC-STATUS Numeric 1 TP100 TP20.1
Element: Status Contains the status of a given TP20.2 TP20.3
transaction. Valid values are:
0 = Open.
1 = Released.
9 = Year end close performed.
TPC-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
TPC-CURR-ND Numeric 1
Account Currency Represents the number of decimals
Code defined for the currency of the object.
TIPCTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPCSET1 COMPANY TP100 TP105
PROCESS-LEVEL TP20.1 TP20.2
DEPARTMENT TP20.3
SHIFT
RECORD-DATE
TIPCTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TPC-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When TPC-DEPARTMENT != Spaces
TPC-COMPANY -> DPT-COMPANY
TPC-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
TPC-DEPARTMENT -> DPT-DEPARTMENT
Process Level PRSYSTEM Required
TPC-COMPANY -> PRS-COMPANY
TPC-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
|
