| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | CNTR1 | SI split | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | LISTU | Join Labor Insurance? | char | 1 | 0 | | | | Allow NULL? |
| 9 | LICAT | LI Insured Amount Class | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | INAMT | Insured amount from | decimal | 13 | 2 | | | | |
| 11 | INCUR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | ERPAY | Employer Pays All the Premium Required | char | 1 | 0 | | | | Allow NULL? |
| 13 | DISAB | Subsidy type | char | 1 | 0 | | | | Allow NULL? |
| 14 | SSIPE | Subsidy percentage | decimal | 7 | 2 | | | | |
| 15 | BRCOD | Business Branch Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | IDNUM | Identity Number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 17 | LIDAY | 2-Digit Numeric Value | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | SIREP | LI/NHI identification number source flag | char | 1 | 0 | | | | Allow NULL? |
| 19 | UNEMS | Exception Indicator for Employment Insurance | char | 1 | 0 | | | | Allow NULL? |
| 20 | OCUST | Exception Indicator for Ordinary Injury Insurance | char | 1 | 0 | | | | Allow NULL? |
| 21 | LIEXP | LI exempt by law | char | 1 | 0 | | | | Allow NULL? |
| 22 | EIEXP | EI exempt by law | char | 1 | 0 | | | | Allow NULL? |
| 23 | ERLIE | Taiwan Labour Insurance exempt for employer | char | 1 | 0 | | | | Allow NULL? |
| 24 | EREIE | Taiwan Employment Insurance Exempt for Employer | char | 1 | 0 | | | | Allow NULL? |
| 25 | EEEIE | Taiwan Employment Insurance Exempt for Employee | char | 1 | 0 | | | | Allow NULL? |
| 26 | EROCE | Taiwan LI Occupation Injury Premium Exempt for Employer | char | 1 | 0 | | | | Allow NULL? |
| 27 | ERDFE | Taiwan Deferred Wage Fund Exempt for Employer | char | 1 | 0 | | | | Allow NULL? |
| 28 | FRTWS | Foreigner Eligible for Employment Insurance | char | 1 | 0 | | | | Allow NULL? |
