| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PERNR | Personnel number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | FIRMA | PAISY: Company | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | EXPNR | PAISY: Export Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | INFTY | Infotype | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | SUBTY | Subtype | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | OBJPS | Object Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | LGART | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | SFLNR | PAISY: Sequence Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | SRTZA | Indicator: Status of record | char | 1 | 0 | | | | Allow NULL? |
| 14 | AEDTM | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | ZFPER | First payment period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | ZWECK | Purpose of Bank Transfers | nvarchar | 40 | 0 | | | | Allow NULL? |
| 19 | VBAFM | Type of investment/asset for capital formation | char | 1 | 0 | | | | Allow NULL? |
| 20 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | ZANZL | Number for determining further payment dates | decimal | 3 | 0 | | | | |
| 22 | BANKL | Bank Keys | nvarchar | 15 | 0 | | | | Allow NULL? |
| 23 | BANKN | Bank account number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 24 | KVBKL | Contribution Scale | nvarchar | 6 | 0 | | | | Allow NULL? |
| 25 | SELKV | Indicator Self-Payer HI | char | 1 | 0 | | | | Allow NULL? |
| 26 | BETRG | Amount | decimal | 9 | 2 | | | | |
| 27 | ANZHL | Number | decimal | 7 | 2 | | | | |
| 28 | VSPRA | Insurance premium | decimal | 9 | 2 | | | | |
| 29 | DVBLZ | Bank number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 30 | DVKTO | Bank account number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 31 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | EMFTX | Payee Text | nvarchar | 40 | 0 | | | | Allow NULL? |
| 33 | BNKNA | PAISY: 1501 Bank Name | nvarchar | 25 | 0 | | | | Allow NULL? |
| 34 | BNKLZ | PAISY: 1502 Bank Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | BNKNT | PAISY: 1503 Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 36 | VTGNR | PAISY: 1521 Contract No./Reference No./Resolution No. | nvarchar | 25 | 0 | | | | Allow NULL? |
| 37 | AINST | PAISY: 1505 Investment Institution/Payment Creditor | nvarchar | 25 | 0 | | | | Allow NULL? |
| 38 | AUSLZ | PAISY: Foreign Payment | nvarchar | 3 | 0 | | | | Allow NULL? |
| 39 | AUSKZ | PAISY: Selection Indicator | char | 1 | 0 | | | | Allow NULL? |
| 40 | GRPKY | PAISY: Compensation Group Key (Wage/Salary Group) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | SPROZ | PAISY: 1512 Percentage for Garnishments | decimal | 4 | 2 | | | | |
| 42 | RRSTP | PAISY: 1522 Retroactive Accounting Limit (Garnishment) | char | 1 | 0 | | | | Allow NULL? |
| 43 | PFDAT | PAISY: 1560 Notification Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | PFUHR | PAISY: 1571 Symbolic Time | char | 1 | 0 | | | | Allow NULL? |
| 45 | LIMIT | PAISY: 1561 Total Amount (Limit) | decimal | 9 | 2 | | | | |
| 46 | UNBER | PAISY: 1565 Maintenance Beneficiaries | char | 1 | 0 | | | | Allow NULL? |
| 47 | ANZKD | Number of Children | decimal | 3 | 0 | | | | |
| 48 | LSTKT | PAISY: 1574 Garnishment for Employment Tax Card | char | 1 | 0 | | | | Allow NULL? |
| 49 | RUECK | PAISY: 1562 Arrears for Maintenance Garnishments | decimal | 7 | 2 | | | | |
| 50 | MAXRT | PAISY: 1563 Maximum Monthly Installment | decimal | 5 | 2 | | | | |
| 51 | VERNT | PAISY: 1564 Remaining Net | decimal | 7 | 2 | | | | |
| 52 | STRBR | PAISY: Control of Gross Garnishment | char | 1 | 0 | | | | Allow NULL? |
| 53 | MARKZ | PAISY: 1572 Indicator for Garnishable Overtime | char | 1 | 0 | | | | Allow NULL? |
| 54 | WEIKZ | PAISY: 1573 Indicator for Holiday Bonus Garnishment | char | 1 | 0 | | | | Allow NULL? |
| 55 | VABKY | PAISY: Processing Key for Child Allowance | char | 1 | 0 | | | | Allow NULL? |
| 56 | TXTKZ | PAISY: 1520 Text Indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 57 | UZEIT | System Time | nvarchar | 6 | 0 | | | | Allow NULL? |
