|
|
ALCSUMM FILE
Allocation Summary
Contains the year-to-date totals of each allocation level's gross receipts,
reported tips, shortfall, direct and indirect tips, and the number of
employees processed in each allocation level. The information in this file is
created by TP100 (Shortfall Allocation Calculation) and can be printed using
TP230 (Year End Allocation Summary Report).
REFERENCED BY
TP230 TP231 TP40.1
UPDATED BY
TP100 TP105
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASM-COMPANY Numeric 4 TP100
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.
ASM-PROCESS-LEVEL Alpha 5 TP100
Element: Process Lev HrContains the process level the pay is
associated with for allocation.
ASM-DEPARTMENT Alpha 5 TP100
Element: Department Contains the department the pay is
associated with for allocation.
ASM-SHIFT Numeric 1 TP100
Element: Shift Contains the shift number the
allocation is associated with.
ASM-PAYROLL-YEAR Numeric 4 TP100
Element: Current PayrolContains the payroll year the in which
the allocation was taken.
ASM-STATUS Numeric 1 TP100
Element: Status Contains the transaction status. Valid
values are:
2 = Open.
9 = Year end close performed.
ASM-LST-CALC-DATE Numeric 8 (yyyymmdd) TP100
Element: Lst Calc Date Contains the system date that defaults
when you run TP100 (Shortfall Allocation
Calculation).
ASM-ALLOC-PCT Signed 7.3 TP100
Element: Allocation PerContains the allocation percent for the
allocation method.
ASM-YTD-RCPT Signed 13.2 TP100
Year-to-date Contains the year-to-date receipts.
Receipts
ASM-YTD-RPT-TIPS Signed 13.2
Year-to-date Contains the year-to-date reported tips.
Reported Tips
ASM-YTD-SF-ALLOC Signed 13.2 TP100
Year-to-date Contains the year-to-date shortfall
Shortfall Alloc allocation.
ASM-YTD-IND-TIPS Signed 13.2 TP100
Element: Ytd Ind Tips Contains the year-to-date indirect tips.
ASM-YTD-CHRG-TIPS Signed 13.2 TP100
Element: Ytd Chrg Tips Contains the year-to-date charged tips.
ASM-YTD-CHRG-RCPT Signed 13.2 TP100
Element: Ytd Chrg Rcpt Contains the year-to-date charged
receipts.
ASM-YTD-SERV-CHRG Numeric 13.2 TP100
Element: Ytd Serv Chrg Contains the year-to-date service
charges.
ASM-NBR-DIR-EMP Numeric 8 TP100
Element: Nbr Dir Emp Contains the number of directly tipped
employees.
ASM-NBR-IND-EMP Numeric 8 TP100
Element: Nbr Ind Emp Contains the number of indirectly
tipped employees.
ASM-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
ASM-CURR-ND Numeric 1
Account Currency Represents the number of decimals
Code defined for the currency of the object.
ALCSUMM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASMSET1 COMPANY TP100 TP105
PROCESS-LEVEL TP230 TP231
DEPARTMENT TP40.1
SHIFT
PAYROLL-YEAR
ALCSUMM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
ASM-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
ASM-COMPANY -> DPT-COMPANY
ASM-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
ASM-DEPARTMENT -> DPT-DEPARTMENT
Process Level PRSYSTEM Required
ASM-COMPANY -> PRS-COMPANY
ASM-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Tpparam TPPARAM Required
ASM-COMPANY -> TPP-COMPANY
ASM-PROCESS-LEVEL -> TPP-PROCESS-LEVEL
ASM-DEPARTMENT -> TPP-DEPARTMENT
ASM-SHIFT -> TPP-SHIFT
ALCSUMM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Alc Gross ALCGROSS Delete Restricted
ASM-COMPANY -> AGR-COMPANY
TPP-ALLOC-METHOD -> AGR-ALLOC-METHOD
ASM-PROCESS-LEVEL -> AGR-PROCESS-LEVEL
ASM-DEPARTMENT -> AGR-DEPARTMENT
ASM-SHIFT -> AGR-SHIFT
AGR-RECORD-DATE
Emp Summ EMPSUMM Delete Restricted
ASM-COMPANY -> ESM-COMPANY
ASM-PROCESS-LEVEL -> ESM-PROCESS-LEVEL
ASM-DEPARTMENT -> ESM-DEPARTMENT
ASM-SHIFT -> ESM-SHIFT
ESM-EMPLOYEE
ESM-PAYROLL-YEAR
ESM-LST-CALC-DATE
Tip Control TIPCTL Delete Restricted
ASM-COMPANY -> TPC-COMPANY
ASM-PROCESS-LEVEL -> TPC-PROCESS-LEVEL
ASM-DEPARTMENT -> TPC-DEPARTMENT
ASM-SHIFT -> TPC-SHIFT
TPC-RECORD-DATE
Tip Pay TIPPAY Delete Restricted
ASM-COMPANY -> TIP-COMPANY
ASM-PROCESS-LEVEL -> TIP-TIP-PROC-LEV
ASM-DEPARTMENT -> TIP-TIP-DEPART
ASM-SHIFT -> TIP-SHIFT
TIP-EMPLOYEE
TIP-WRK-END-DATE
TIP-SEQ-NBR
|
