| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | P_PERNR | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | HRPY_RGDIR | CDSEQ | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | HRDCT_ROWID | Allow NULL? |
| 5 | BTZNR | Assignment of Transfers | varbinary | 1 | 0 | RAW | | Yes | | BTZNR | |
| 6 | LGART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | LGART | Allow NULL? |
| 7 | BETRG | HR Payroll: Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | MAXBT | |
| 8 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | DZLSCH | Allow NULL? |
| 9 | EMFTX | Payee Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | EMFTX | Allow NULL? |
| 10 | BKPLZ | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTLZ | Allow NULL? |
| 11 | BKORT | City | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ORT01 | Allow NULL? |
| 12 | BANKS | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 13 | BANKL | Bank number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKL | Allow NULL? |
| 14 | BANKN | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | BANKN | Allow NULL? |
| 15 | EMFSL | Payee key for bank transfers | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | EMFSL | Allow NULL? |
| 16 | ZWECK | Purpose of Bank Transfers | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DZWECK | Allow NULL? |
| 17 | VBAFM | Type of investment/asset for capital formation | char | 1 | 0 | CHAR | (N' ') | Yes | * | VBAFM | Allow NULL? |
| 18 | DTADT | Transfer date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DTADT_D | Allow NULL? |
| 19 | DTATI | Transfer time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | DATTI | Allow NULL? |
| 20 | DTAID | Transfer identification | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | DTATX | Allow NULL? |
| 21 | BTTYP | PBS Transfer Type | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | P09_BTTYP | Allow NULL? |
| 22 | PSKTO | Account Number of Bank Account At Post Office | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | PSKTO | Allow NULL? |
| 23 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 24 | STRAS | House number and street | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | STRAS | Allow NULL? |
| 25 | BKONT | Bank Control Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BKONT | Allow NULL? |
| 26 | FBETR | HR Payroll: Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | MAXBT | |
| 27 | STATE | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 28 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | ESRNR | Allow NULL? |
| 29 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | CHAR | (N' ') | Yes | | ESRRE | Allow NULL? |
| 30 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ESRPZ | Allow NULL? |
| 31 | BKREF | Reference specifications for bank details | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BKREF | Allow NULL? |
| 32 | CTRNS | Coll. Bank Transfer Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | HRPAY00_COLDME_CTRNS | Allow NULL? |
| 33 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | CHAR | (N' ') | Yes | | IBAN | Allow NULL? |
| 34 | CRDID | Creditor Identification Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | HRPAY00_SEPA_CRDID | Allow NULL? |
| 35 | MNDID | SEPA Mandate: Unique Reference to Mandate per Creditor | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | HRPAY00_SEPA_MNDID | Allow NULL? |
| 36 | DD_DUEDATE_SEPA | Requested Date for Collection of the SEPA Direct Debit | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | HRDME_DD_DUEDATE_SEPA | Allow NULL? |
