| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | ACTIVE | Table entry is active (A) or in suspense (S) | char | 1 | 0 | CHAR | (N' ') | No | | ICL_ACTIVE | Allow NULL? |
| 3 | CLAIM | Number of Claim | nvarchar | 17 | 0 | CHAR | (N' ') | No | ICLCLAIM | ICL_CLAIM | Allow NULL? |
| 4 | PARTNER | Supplier | nvarchar | 10 | 0 | CHAR | (N' ') | No | ICLPART | ICL_SUPPL | Allow NULL? |
| 5 | ROLE | Participant Role Key | nvarchar | 4 | 0 | CHAR | (N' ') | No | TICL301 | ICL_ROLE | Allow NULL? |
| 6 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | DEC | ((0)) | No | | ICL_CHANGEUTC1 | |
| 7 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | ICL_CHANGEDBY | Allow NULL? |
| 8 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_RECSTATUS | Allow NULL? |
| 9 | RCODE | External Services Management: Reason for Manual Entry | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TICL086 | ICL_RC_CHANGE | Allow NULL? |
| 10 | XAUTO | Vendor Determined by System | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_SUPPL_AUTO | Allow NULL? |
| 11 | ADDRNUMBER | Address Reference with Assignment | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ICL_ADDRREF | Allow NULL? |
| 12 | PTYPE | Transaction Type in Procurement Process | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TICL123 | ICL_PTYPE | Allow NULL? |
| 13 | REF_LOCCAT | Reference Location for External Services | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ICL_EXTSVCS_REFCAT | Allow NULL? |
| 14 | PDREF | Reference to Purchasing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ICL_PDREF | Allow NULL? |
| 15 | INSTRUCT_DETAILS | Order Details | nvarchar | 65 | 0 | CHAR | (N' ') | Yes | | ICL_INSTRUCTION_DETAILS | Allow NULL? |
| 16 | XMANUAL | Manual Selection | char | 1 | 0 | CHAR | (N' ') | Yes | | ICL_XMANUAL | Allow NULL? |
| 17 | INSTR_TYPE | Order Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ICL_INSTRUCTION_TYPE | Allow NULL? |
| 18 | INSTR_DATE | Date on Which Order Was Placed with Service Provider | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ICL_INSTRUCTION_DATE | Allow NULL? |
