| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BAREA | Benefit area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | RMINA | Benefit minimum contribution to flexible spending account | decimal | 13 | 2 | | | | |
| 7 | RMAXA | Benefit maximum contribution to flexible spending account | decimal | 13 | 2 | | | | |
| 8 | GRCDA | Benefit end of grace period: day | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | GRCMO | Benefit end of grace period: Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | REMIN | Benefit minimum reimbursement amount | decimal | 13 | 2 | | | | |
| 11 | REWTY | Benefit reimbursement wage type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | REIND | Benefit reimbursement indicator | char | 1 | 0 | | | | Allow NULL? |
| 13 | ERCON | Benefit Employer Flexible Spending Account Contribution | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | PLYRD | Benefit day of plan year begin flexible spending accounts | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | PLYRM | Benefit month of plan year begin flexible spending accounts | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | HSARE | Benefit HSA Plan-Relevant Indicator | char | 1 | 0 | | | | Allow NULL? |
| 17 | GRCRD | Benefit End of Current Year Grace Period: Day | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | GRCRM | Benefit End of Current Year Grace Period: Month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | HCFSA | Health Care FSA Plan Indicator | char | 1 | 0 | | | | Allow NULL? |
| 20 | RMBPR | Priority for Reimbursements - Account Balance of Current Yr | char | 1 | 0 | | | | Allow NULL? |
| 21 | CAROV | Indicator: Carryover Allowed | char | 1 | 0 | | | | Allow NULL? |