|
|
ALCGROSS FILE
Allocation Gross
Contains information on gross receipts by allocation level within a company.
This information is used to process the hours worked shortfall allocation, and
also provides controls for entered gross receipts that use the individual
gross receipts method of shortfall allocation.
REFERENCED BY
TP115 TP120
UPDATED BY
TP10.1 TP100 TP105 TP125 TP20.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGR-COMPANY Numeric 4 TP10.1 TP125
Element: Company Hr Contains the company number. TP20.3
AGR-ALLOC-METHOD Alpha 1 TP10.1 TP125
Element: Allocation MetContains the value that determines the TP20.3
allocation method used for the
allocation level. Valid values are:
G = Individual Gross Receipts.
H = Hours Worked.
AGR-PROCESS-LEVEL Alpha 5 TP10.1 TP125
Element: Process Lev HrContains the process level the pay is TP20.3
associated with for allocation.
AGR-DEPARTMENT Alpha 5 TP10.1 TP125
Element: Department Contains the department the pay is TP20.3
associated with for allocation.
AGR-SHIFT Numeric 1 TP10.1 TP125
Element: Shift Contains the shift number the pay is TP20.3
associated with for allocation.
1 = First shift
2 = Second shift
3 = Third shift
4 = Fourth shift
5 = Fifth Shift
6 = Sixth Shift
7 = Seventh Shift
8 = Eighth Shift
9 = Ninth Shift
AGR-RECORD-DATE Numeric 8 (yyyymmdd) TP10.1 TP125
Element: Record Date Contains the record date of the TP20.3
transaction.
AGR-CHRG-TIPS Signed 11.2 TP10.1 TP20.3
Element: Chrg Tips Contains the total charged tips for the
record date.
AGR-CHRG-RCPT Signed 11.2 TP10.1 TP20.3
Element: Chrg Rcpt Contains the total charged receipts,
other than non-allocable receipts for
the record date.
AGR-SERV-CHRG Signed 11.2 TP10.1 TP20.3
Element: Service ChargeContains the total service charges of
less than ten percent paid as wages to
employees for the record date.
AGR-RCPT Signed 11.2 TP10.1 TP20.3
Element: Rcpt Contains the allocation level gross
receipts for the record date.
AGR-STATUS Numeric 1 TP10.1 TP100
Element: Status Contains the transaction status. Valid TP125 TP20.3
values are:
0 = Current year not used in
calculation.
1 = Released.
2 = Current year not maintained.
3 = Current year maintained.
6 = Previous year not maintained.
9 = Year end close performed.
AGR-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
AGR-CURR-ND Numeric 1
Account Currency Represents the number of decimals
Code defined for the currency of the object.
ALCGROSS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGRSET1 COMPANY TP10.1 TP100
ALLOC-METHOD TP105 TP115
PROCESS-LEVEL TP120 TP125
DEPARTMENT TP20.1 TP20.3
SHIFT
RECORD-DATE
ALCGROSS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
AGR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
AGR-COMPANY -> DPT-COMPANY
AGR-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
AGR-DEPARTMENT -> DPT-DEPARTMENT
Process Level PRSYSTEM Required
AGR-COMPANY -> PRS-COMPANY
AGR-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Tp Control TIPCTL Required
AGR-COMPANY -> TPC-COMPANY
AGR-PROCESS-LEVEL -> TPC-PROCESS-LEVEL
AGR-DEPARTMENT -> TPC-DEPARTMENT
AGR-SHIFT -> TPC-SHIFT
AGR-RECORD-DATE -> TPC-RECORD-DATE
Tpparam TPPARAM Required
AGR-COMPANY -> TPP-COMPANY
AGR-PROCESS-LEVEL -> TPP-PROCESS-LEVEL
AGR-DEPARTMENT -> TPP-DEPARTMENT
AGR-SHIFT -> TPP-SHIFT
ALCGROSS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Tip Pay TIPPAY Delete Restricted
AGR-COMPANY -> TIP-COMPANY
AGR-PROCESS-LEVEL -> TIP-TIP-PROC-LEV
AGR-DEPARTMENT -> TIP-TIP-DEPART
AGR-SHIFT -> TIP-SHIFT
TIP-EMPLOYEE
TIP-WRK-END-DATE
TIP-SEQ-NBR
|
