| 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 | DAS301 | Data Collection Point for EDI Message Transmission | nvarchar | 10 | 0 | CHAR | (N' ') | No | NC301P | ISH_DAS301 | Allow NULL? |
| 4 | EDIPROC | IS-HCM: EDI Procedure | nvarchar | 5 | 0 | CHAR | (N' ') | No | TNC301G0 | N_EDIPROC | Allow NULL? |
| 5 | NINOUTSIGN | IS-HCM: Outbound - Inbound Message(s) Indicator | char | 1 | 0 | CHAR | (N' ') | No | | NINOUTSIGN | Allow NULL? |
| 6 | LF301M | IS-HCM: Seq. File Number (Data Cllct. Point-Specific) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ISH_LF301M | Allow NULL? |
| 7 | PATH301 | IS-HCM: Absolute Path of EDI File Without File Name | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | N301PATH | Allow NULL? |
| 8 | CODEPAGE | SAP Character Set ID | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TCP00 | CPCODEPAGE | Allow NULL? |
| 9 | SPECHARS | IS-HCM: Special Characters Agreed (Standard-Dependent) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | SPECHARS | Allow NULL? |
| 10 | CODEKEY | IS-HCM: Agreed Encryption Key for EDI | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | NCODEKEY | Allow NULL? |
| 11 | COMPR | IS-HCM: Compression Method | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NCOMPR | Allow NULL? |
| 12 | FILEDT | IS-HCM: Date (Last) EDI File Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | N301FILEDT | Allow NULL? |
| 13 | FILEZT | IS-HCM: Creation time of the (last) §301 file | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | N301FILETM | Allow NULL? |
| 14 | FILESZMAX | IS-HCM: Maximum Size Permitted for EDI File in KB | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | N301FILESZ | Allow NULL? |
| 15 | STAND | IS-HCM: Communications Standard | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TNCST | CMSTD | Allow NULL? |
| 16 | STVER | IS-HCM: Version of Communication Standard | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TNCST | STDVER | Allow NULL? |
| 17 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 18 | UPTIM | IS-H: Time Data Record was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_UPTIM | Allow NULL? |
| 19 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 20 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 21 | ERTIM | IS-H: Time when Data Record Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_ERTIM | Allow NULL? |
| 22 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 23 | SENDDAYS | IS-HCM: Days for Data Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | SENDDAYS | Allow NULL? |
| 24 | SENDTIME | IS-HCM: Start time of data transfer | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | N301SNDBTM | Allow NULL? |
| 25 | CALID | IS-HCM: §301 calendar ID for automatic dispatch control | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | N301SNDCAL | Allow NULL? |
| 26 | TECHADR | IS-H: Technical Address of Sender or Receiver | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | N_TECHADR | Allow NULL? |
| 27 | ADRTYPE | IS-H EDI: Address Type to Further Classify Technical Address | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | N_EDIADRTY | Allow NULL? |
| 28 | SIGNAT | IS-H: Digital Signature | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_SIGNAT | Allow NULL? |
| 29 | CRYPTO | IS-H: Coding Method | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_CRYPTO | Allow NULL? |
| 30 | MSGSZMAX | IS-H HCM: Max. Size Permitted for EDI Message in KB | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | N301MSGSZ | Allow NULL? |
| 31 | LF301Y | DALEUV Data Transfer Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_LF301Y | Allow NULL? |
