| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MASSN | Action Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | MASSG | Reason for Action | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | TRANF | Transfer | char | 1 | 0 | | | | Allow NULL? |
| 7 | CAGEM | Movement code for General Register of Employed and Unempl. | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | FGTSR | FGTS movement reference code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | PRENO | Number of notice days | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | FGTFL | FGTS fine percentage upon termination | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | SCBON | Christmas allowance payment eligibility | char | 1 | 0 | | | | Allow NULL? |
| 12 | SVACT | Leave payment eligibility upon termination | char | 1 | 0 | | | | Allow NULL? |
| 13 | FL479 | Fine referring to article 479 of LLC | char | 1 | 0 | | | | Allow NULL? |
| 14 | PPRFL | Profits and Results Sharing eligibility upon termination | char | 1 | 0 | | | | Allow NULL? |
| 15 | F479V | Fine referring to article 479 of LLC for leave | char | 1 | 0 | | | | Allow NULL? |
| 16 | F479X | Fine referring to article 479 of LLC for Christmas allowance | char | 1 | 0 | | | | Allow NULL? |
| 17 | AVPWO | Indicator of working notice period | char | 1 | 0 | | | | Allow NULL? |
| 18 | NRAIS | SIAL movement code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | SAQUE | Reference code for FGTS withdrawal | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | RSNHN | Fire reason | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | HMNTS | Movement code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | AVPAD | Do not add notice period days | char | 1 | 0 | | | | Allow NULL? |
| 23 | EFD_MOV_TYPE | eSocial code | nvarchar | 3 | 0 | | | | Allow NULL? |