| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | CHAR | (N' ') | No | TNC301G0 | N_EDIPROC | Allow NULL? |
| 4 | LASTENRIN | IS-HCM: EDI - Last external file number (inbound) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | NLASTNRIN | Allow NULL? |
| 5 | LASTDNRIN | IS-H: File Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | ISH_LF301D | Allow NULL? |
| 6 | LASTENROUT | IS-HCM: EDI - Last file number (outbound) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | NLASTNROUT | Allow NULL? |
| 7 | LASTDNROUT | IS-H: File Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | ISH_LF301D | Allow NULL? |
| 8 | QNTDIGSIN | IS-HCM: EDI - Number of Digits Used for File No. (Inbound) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | NQNTDIGSIN | Allow NULL? |
| 9 | QNTDIGSOUT | IS-HCM: EDI - Number of Digits Used for File No. (Outbound) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | NQNTDIGSOU | Allow NULL? |
| 10 | PRAEFIXIN | IS-HCM: EDI - file prefix inbound | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PRAEFIXIN | Allow NULL? |
| 11 | PRAEFIXOUT | IS-HCM: EDI - file prefix outbound | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PRAEFIXOUT | Allow NULL? |
| 12 | POSTFIXIN | IS-HCM: EDI - file postfix inbound | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | POSTFIXIN | Allow NULL? |
| 13 | POSTFIXOUT | IS-HCM: EDI - file postfix outbound | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | POSTFIXOUT | Allow NULL? |
| 14 | ONEDIRKZ | IS-HCM: EDI - Directory Logic | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OUTIN1 | Allow NULL? |
| 15 | DIRIN | IS-HCM: EDI Inbound Directory | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | DIRIN | Allow NULL? |
| 16 | DIROUT | IS-HCM: EDI Outbound Directory | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | DIROUT | Allow NULL? |
| 17 | GAPWIDTH | IS-H: Search Range | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NGAPWIDTH | Allow NULL? |
| 18 | RFNAMEOUT | IS-H: Remote Function (Module) Name (on Target Host) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RFNAMEOUT | Allow NULL? |
| 19 | RFCDEST | IS-HCM: Logical Destination for Remote Function Call | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | RFCDES | ISHRFCDEST | Allow NULL? |
| 20 | R3FILEKZ | IS-H: Indicator - Use Logical File Name/Path | char | 1 | 0 | CHAR | (N' ') | Yes | | R3FILEKZ | Allow NULL? |
| 21 | R3FILEIN | IS-H: Logical file name (inbound) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | FILENAMECI | R3FILEIN | Allow NULL? |
| 22 | R3FILEOUT | IS-H: Logical file name (outbound) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | FILENAMECI | R3FILEOUT | Allow NULL? |
| 23 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 24 | UPTIM | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_UPTIM | Allow NULL? |
| 25 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 26 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 27 | ERTIM | IS-H: Time when Data Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_ERTIM | Allow NULL? |
| 28 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 29 | DIFFPHYSSENDER | IS-H EDI: Alternative sender specif. for data transmission | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | NDIFFPHYSSENDER | Allow NULL? |
| 30 | OUTTRANSERR | IS-H: Indicator for Error in Outbound File Transfer | char | 1 | 0 | CHAR | (N' ') | No | | NOUTTRANSFERERROR | Allow NULL? |
