| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TYPE | N4DS result type (internal) | varbinary | 1 | 0 | | | | |
| 3 | RUNID | Result ID (execution ID) | varbinary | 4 | 0 | | | | |
| 4 | DECLNR | Declaration number (order number) | varbinary | 2 | 0 | | | | |
| 5 | SEQN2 | Sequence number for Totals groupping | varbinary | 2 | 0 | | | | |
| 6 | ACERN | DADS-U: Period end reason code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | ACNIC | NIC | nvarchar | 5 | 0 | | | | Allow NULL? |
| 8 | ACSRN | DADS-U: Period start reason code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | DENAT | Nature of declaration | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | DESIR | SIREN number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 11 | DETYP | Declaration type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | REACT | Compulsory work accident risk scheme indicator | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | REEXT | Alsace-Moselle extension code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | REMAL | Compulsory illness risk scheme indicator | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | REVIE | Compulsory pension plan code (employer part) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | SIPOP | Employment population code of employee or agent | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | SPEMP | Original statutory employment code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | SSCDC | Work contract law indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | SSCNC | DADS-U: Work contract code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | SSCSA | DADS-U: Employee AGIRC-ARRCO group status indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | SSCSC | DADS-U: Employee category status code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | DAQFIELD | Forms: Field | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | AMTTYP | Qualifier (amount type) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | AMOUNT | HR Payroll: Amount | decimal | 15 | 2 | | | | |
| 25 | GRPKEY | key for Totals groupping (employee groups) | varbinary | 2 | 0 | | | | |