| 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 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | OPBEL_KK | Allow NULL? |
| 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OPUPK_KK | Allow NULL? |
| 4 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPW_KK | Allow NULL? |
| 5 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | OPUPZ_KK | Allow NULL? |
| 6 | PAYBL | Document Number of Payment | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | IST_PAYBL | Allow NULL? |
| 7 | ORIGIN | Origin of Telco Service | char | 1 | 0 | CHAR | (N' ') | Yes | | IST_ORIGIN | Allow NULL? |
| 8 | LOCK_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 9 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 10 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 11 | MAHNV | Dunning Procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MAHNV_KK | Allow NULL? |
| 12 | MAHNS | Dunning Level | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | MAHNS_KK | Allow NULL? |
| 13 | MSTYP | Dunning Level Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MSTYP_KK | Allow NULL? |
| 14 | VKONT | Contract Account Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONT_KK | Allow NULL? |
| 15 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 16 | ADD_REFOBJID | Additional Reference Object ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | IST_ADD_REFOBJID | Allow NULL? |
| 17 | ADD_REFOBJ | Additional Reference Object | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | IST_ADD_REFOBJ | Allow NULL? |
| 18 | OBJECT_ID | Additional Reference Object | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | IST_ADD_REFOBJ | Allow NULL? |
| 19 | GROUP_ID | Group ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | IST_GROUP_ID | Allow NULL? |
| 20 | SERVICE | Type of Service | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | IST_SERVICE | Allow NULL? |
| 21 | ORIGIN_EVAL | Evaluation of Origin for Reconnection | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | IST_ORIGIN_EVALUATION | Allow NULL? |
| 22 | TRANS_STATUS | Send Status for a Telco Service | char | 1 | 0 | CHAR | (N' ') | Yes | | IST_TRANSFER | Allow NULL? |
| 23 | CREA_TIME | Generation Time for (Re)Disconnection Proposal | decimal | 15 | 0 | DEC | ((0)) | Yes | | IST_CREA_TIME | |