BN66.1 | PR140 | PR189 | PR195 | PR197 | PR80.1 |
PR80.4 | PR89.1 | PRAT.1 | PR141 | PR139 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
CEI-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||||
CEI-PAYROLL-YEAR Element: Payroll Year | Numeric 4 |
|
||||||||||
CEI-EMPLOYEE Element: Employee | Numeric 9 |
|
||||||||||
CEI-PRD-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) |
|
||||||||||
CEI-INV-GROUP Element: Inv Group | Alpha 1 1 = Section 10 2 = Section 24 3 = Section 16 4 = Section 80C 5 = Section VI-A |
|
||||||||||
CEI-INV-CODE Element: Sec Code | Alpha 10 |
|
||||||||||
CEI-PRD-END-DATE Element: End Date | Numeric 8 (yyyymmdd) |
|
||||||||||
CEI-INV-PROP-AMT Element: Amount Ytd | Signed 13.2 |
|
||||||||||
CEI-INV-ACT-AMT Element: Amount Ytd | Signed 13.2 |
|
||||||||||
CEI-PROC-STATUS Element: Flag | Alpha 1 P = Pending C = Closed |
|
||||||||||
CEI-SEQ-NBR Element: Seq Nbr | Numeric 4 |
|
||||||||||
CEI-APPROVE-FLG Element: Approve Flg | Alpha 1 Y = Yes N = No |
|
||||||||||
CEI-REQUEST-AMT Element: Request Amt | Signed 13.2 |
|
||||||||||
CEI-APPROVED-AMT Element: Approved Amt | Signed 13.2 |
|
||||||||||
CEI-USER-FLAG Element: Flag Num | Numeric 1 0 = No 1 = Yes |
|
||||||||||
CEI-CREATE-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||||||||
CEI-CREATE-DATE Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||||||||
CEI-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) |
|
||||||||||
CEI-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||||||||
CEI-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) |
|
||||||||||
CEI-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CEISET1 |
COMPANY PAYROLL-YEAR EMPLOYEE PRD-START-DATE* INV-GROUP INV-CODE SEQ-NBR |
|
| ||||||||||||||||
CEISET2 |
COMPANY PAYROLL-YEAR EMPLOYEE PRD-START-DATE* INV-GROUP INV-CODE SEQ-NBR* |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Investment | C6INVEST |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Pay Period | C6PRDDTL |
|
All trademarks and registered trademarks are the property of their
respective owners.