| 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 | T000 | MANDT | Allow NULL? |
| 2 | PERNR | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | PA0003 | PERSNO | Allow NULL? |
| 3 | SUBTY | Subtype | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SUBTY | Allow NULL? |
| 4 | OBJPS | Object Identification | nvarchar | 2 | 0 | CHAR | (N' ') | No | | OBJPS | Allow NULL? |
| 5 | SPRPS | Lock Indicator for HR Master Data Record | char | 1 | 0 | CHAR | (N' ') | No | | SPRPS | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDA | Allow NULL? |
| 8 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | NUMC | (N'000') | No | | SEQNR | Allow NULL? |
| 9 | AEDTM | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 10 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 11 | HISTO | Historical Record Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | HISTO | Allow NULL? |
| 12 | ITXEX | Text Exists for Infotype | char | 1 | 0 | CHAR | (N' ') | Yes | | ITXEX | Allow NULL? |
| 13 | REFEX | Reference Fields Exist (Primary/Secondary Costs) | char | 1 | 0 | CHAR | (N' ') | Yes | | PRFEX | Allow NULL? |
| 14 | ORDEX | Confirmation Fields Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | ORDEX | Allow NULL? |
| 15 | ITBLD | Infotype Screen Control | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ITBLD | Allow NULL? |
| 16 | PREAS | Reason for Changing Master Data | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T530E | PREAS | Allow NULL? |
| 17 | FLAG1 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 18 | FLAG2 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 19 | FLAG3 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 20 | FLAG4 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 21 | RESE1 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUSED2 | Allow NULL? |
| 22 | RESE2 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUSED2 | Allow NULL? |
| 23 | GRPVL | Grouping Value for Personnel Assignments | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PCCE_GPVAL | Allow NULL? |
| 24 | IONUM | Case Number (Internal) for Garnishment Order | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P_IONUMR | Allow NULL? |
| 25 | JURIS | Code for jurisdiction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T53G0 | P_JURISD | Allow NULL? |
| 26 | GCATE | Code for Garnishment Category | char | 1 | 0 | CHAR | (N' ') | Yes | T53G1 | P_GCATG | Allow NULL? |
| 27 | DFPRI | Priority of Order for Garnishment | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P_DFPRO | Allow NULL? |
| 28 | GFCOD | Service Charge Rule | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | P_GFCODE | Allow NULL? |
| 29 | PRITY1 | Transfer Priority | char | 1 | 0 | CHAR | (N' ') | Yes | | P_PRITY | Allow NULL? |
| 30 | PRITY2 | Transfer Priority | char | 1 | 0 | CHAR | (N' ') | Yes | | P_PRITY | Allow NULL? |
| 31 | PRITY3 | Transfer Priority | char | 1 | 0 | CHAR | (N' ') | Yes | | P_PRITY | Allow NULL? |
| 32 | UENBN1 | Missing Transfer Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P_UEBNO | Allow NULL? |
| 33 | UENBN2 | Missing Transfer Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P_UEBNO | Allow NULL? |
| 34 | UENBN3 | Missing Transfer Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P_UEBNO | Allow NULL? |
| 35 | SKENN1 | Transfer of Main Claim | char | 1 | 0 | CHAR | (N' ') | Yes | | P_SKENN | Allow NULL? |
| 36 | SKENN2 | Transfer of Main Claim | char | 1 | 0 | CHAR | (N' ') | Yes | | P_SKENN | Allow NULL? |
| 37 | SKENN3 | Transfer of Main Claim | char | 1 | 0 | CHAR | (N' ') | Yes | | P_SKENN | Allow NULL? |
| 38 | KKENN1 | Transfer of Costs | char | 1 | 0 | CHAR | (N' ') | Yes | | P_KKENN | Allow NULL? |
| 39 | KKENN2 | Transfer of Costs | char | 1 | 0 | CHAR | (N' ') | Yes | | P_KKENN | Allow NULL? |
| 40 | KKENN3 | Transfer of Costs | char | 1 | 0 | CHAR | (N' ') | Yes | | P_KKENN | Allow NULL? |
| 41 | SBETR1 | Transfer Amount Main Claim | decimal | 8 | 2 | CURR | ((0)) | Yes | | P_SBETR | |
| 42 | SBETR2 | Transfer Amount Main Claim | decimal | 8 | 2 | CURR | ((0)) | Yes | | P_SBETR | |
| 43 | SBETR3 | Transfer Amount Main Claim | decimal | 8 | 2 | CURR | ((0)) | Yes | | P_SBETR | |
| 44 | KBETR1 | Transfer Amout Costs | decimal | 8 | 2 | CURR | ((0)) | Yes | | P_KBETR | |
| 45 | KBETR2 | Transfer Amout Costs | decimal | 8 | 2 | CURR | ((0)) | Yes | | P_KBETR | |
| 46 | KBETR3 | Transfer Amout Costs | decimal | 8 | 2 | CURR | ((0)) | Yes | | P_KBETR | |
| 47 | SPROZ1 | Transfer Percentage Main Claim | decimal | 4 | 0 | DEC | ((0)) | Yes | | P_SPROZ | |
| 48 | SPROZ2 | Transfer Percentage Main Claim | decimal | 4 | 0 | DEC | ((0)) | Yes | | P_SPROZ | |
| 49 | SPROZ3 | Transfer Percentage Main Claim | decimal | 4 | 0 | DEC | ((0)) | Yes | | P_SPROZ | |
| 50 | KPROZ1 | Transfer Percentage Costs | decimal | 4 | 0 | DEC | ((0)) | Yes | | P_KPROZ | |
| 51 | KPROZ2 | Transfer Percentage Costs | decimal | 4 | 0 | DEC | ((0)) | Yes | | P_KPROZ | |
| 52 | KPROZ3 | Transfer Percentage Costs | decimal | 4 | 0 | DEC | ((0)) | Yes | | P_KPROZ | |
| 53 | CRETY | HR payee type | char | 1 | 0 | CHAR | (N' ') | Yes | | CRETY | Allow NULL? |
| 54 | CRENR | HR payee number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | T51RH | CRENR | Allow NULL? |
| 55 | LIFNR1 | Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | P_LIFNR | Allow NULL? |
| 56 | LIFNR2 | Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | P_LIFNR | Allow NULL? |
| 57 | LIFNR3 | Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | P_LIFNR | Allow NULL? |
| 58 | AGCOD | Code for Garnishment Agency | char | 1 | 0 | CHAR | (N' ') | Yes | | P_AGYCD | Allow NULL? |
| 59 | LIFSG1 | Vendor subgroup | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ACSUB | Allow NULL? |
| 60 | LIFSG2 | Vendor subgroup | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ACSUB | Allow NULL? |
| 61 | LIFSG3 | Vendor subgroup | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ACSUB | Allow NULL? |
| 62 | RULNR | Remittance Rule | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | T51RK | P_IOREM | Allow NULL? |
| 63 | IOSCI | Single cheque indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | P_IOSCI | Allow NULL? |
| 64 | IOPAY | Make Check Payable to Plaintiff | char | 1 | 0 | CHAR | (N' ') | Yes | | P_IOPAY | Allow NULL? |
| 65 | IOANM | Agency Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P_IOANM | Allow NULL? |
| 66 | IOAST | Agency Street | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | P_IOAST | Allow NULL? |
| 67 | IOAPC | Agency Postal Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P_IOAPC | Allow NULL? |
| 68 | IOAPR | Agency Province | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | P_IOAPR | Allow NULL? |
| 69 | IOACO | Agency Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | P_IOACO | Allow NULL? |
| 70 | IOAPH | Agency Coutry | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | P_IOAPH | Allow NULL? |
| 71 | IOPLN1 | Plaintiff 1 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P_IOPLN | Allow NULL? |
| 72 | IOPLN2 | Plaintiff 1 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P_IOPLN | Allow NULL? |
| 73 | IOPLN3 | Plaintiff 1 | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P_IOPLN | Allow NULL? |
| 74 | EMFSL1 | Payee Key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | P_EMFSL | Allow NULL? |
| 75 | EMFSL2 | Payee Key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | P_EMFSL | Allow NULL? |
| 76 | EMFSL3 | Payee Key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | P_EMFSL | Allow NULL? |
| 77 | EMFTX1 | Payee Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | EMFTX | Allow NULL? |
| 78 | EMFTX2 | Payee Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | EMFTX | Allow NULL? |
| 79 | EMFTX3 | Payee Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | EMFTX | Allow NULL? |
| 80 | STRAS | Payee Street | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | P_STRAS | Allow NULL? |
| 81 | BKPLZ1 | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BKPLZ | Allow NULL? |
| 82 | BKPLZ2 | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BKPLZ | Allow NULL? |
| 83 | BKPLZ3 | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BKPLZ | Allow NULL? |
| 84 | BKORT1 | City | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ORT01 | Allow NULL? |
| 85 | BKORT2 | City | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ORT01 | Allow NULL? |
| 86 | BKORT3 | City | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ORT01 | Allow NULL? |
| 87 | BANKS1 | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | BANKS | Allow NULL? |
| 88 | BANKS2 | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | BANKS | Allow NULL? |
| 89 | BANKS3 | Bank country key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | BANKS | Allow NULL? |
| 90 | BANKL1 | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKK | Allow NULL? |
| 91 | BANKL2 | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKK | Allow NULL? |
| 92 | BANKL3 | Bank Keys | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | BANKK | Allow NULL? |
| 93 | BANKN1 | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | BANKN | Allow NULL? |
| 94 | BANKN2 | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | BANKN | Allow NULL? |
| 95 | BANKN3 | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | BANKN | Allow NULL? |
| 96 | ZLSCH1 | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | PCODE | Allow NULL? |
| 97 | ZLSCH2 | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | PCODE | Allow NULL? |
| 98 | ZLSCH3 | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | PCODE | Allow NULL? |
| 99 | ZWECK1 | Purpose of Bank Transfers | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DZWECK | Allow NULL? |
| 100 | ZWECK2 | Purpose of Bank Transfers | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DZWECK | Allow NULL? |
| 101 | ZWECK3 | Purpose of Bank Transfers | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | DZWECK | Allow NULL? |
| 102 | AGKEM | Unit Service Charge | char | 1 | 0 | CHAR | (N' ') | Yes | | P_AGKEM | Allow NULL? |
| 103 | AGKPZ | Percentage Service Charge | decimal | 4 | 0 | DEC | ((0)) | Yes | | P_AGKPZ | |
| 104 | AGKBT | Amount for Service Charge | decimal | 9 | 2 | CURR | ((0)) | Yes | | P_AGKBT | |
| 105 | AGKHB | Maximum Amount | decimal | 9 | 2 | CURR | ((0)) | Yes | | P_AGKHB | |
| 106 | AGKMB | Minimum Amount for Service Charge | decimal | 9 | 2 | CURR | ((0)) | Yes | | P_AGKMB | |
| 107 | AGKMU | Minimum Transfer | decimal | 9 | 2 | CURR | ((0)) | Yes | | P_AGKMU | |
| 108 | AGUEB | Transfer Number | char | 1 | 0 | CHAR | (N' ') | Yes | | P_AGUEB | Allow NULL? |
| 109 | AGEIN | Type of Withholding | char | 1 | 0 | CHAR | (N' ') | Yes | | P_AGEIN | Allow NULL? |
| 110 | IOCN1 | Case Number 1 | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | P_IOCN1 | Allow NULL? |
| 111 | IOCN2 | Case Number 2 | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | P_IOCN2 | Allow NULL? |
| 112 | IOCTD | Court Order Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P_IOCTD | Allow NULL? |
| 113 | IORCD | Received Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P_IORCD | Allow NULL? |
| 114 | IORHR | Received Hour | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P_IORHR | Allow NULL? |
| 115 | IORLD | Release Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P_IORLD | Allow NULL? |
| 116 | IOSTS | Garnishment Order Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P_IOSTS | Allow NULL? |
| 117 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
