| 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 | OS_GUID | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | No | | OS_GUID | |
| 3 | COMPANY_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 4 | POS_CHG_ID | CFM: TRS Business Transaction ID | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | TPM_TRANSACTION_ID_TRS | Allow NULL? |
| 5 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | TPM_COM_VAL_CLASS | Allow NULL? |
| 6 | POSITION_DATE | Position Value Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TPM_POSITION_DATE | Allow NULL? |
| 7 | TRD_TRANSACTION | Identifier of the Distributor Business Transaction | varbinary | 16 | 0 | RAW | | Yes | | TPM_BUSTRANSID | |
| 8 | STORNO_FLAG | Reversal Flag Securities Account Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | TPM_SAT_REV_FLAG | Allow NULL? |
| 9 | DOCUMENT_DATE | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 10 | POSITION_OID | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | Yes | | OS_GUID | |
| 11 | POSITION_CLS | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | Yes | | OS_GUID | |
| 12 | USER_DATA_CLS | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | Yes | | OS_GUID | |
| 13 | USER_DATA_OID | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | Yes | | OS_GUID | |
| 14 | USER_DATA_S_CLS | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | Yes | | OS_GUID | |
| 15 | USER_DATA_S_OID | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | Yes | | OS_GUID | |