| 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 | CODSRA_UUID | Correspondence object: Security Rate Adjustment UUID | varbinary | 16 | 0 | RAW | | No | | FTR_CODSRAID | |
| 3 | CODMD_UUID | Correspondence Object Deal's main data UUID | varbinary | 16 | 0 | RAW | | Yes | | FTR_CODMDID | |
| 4 | COMPANYCODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 5 | DEAL_NUMBER | Position-Generating Financial Transaction | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | VTBFHA | FTI_POSRFHA | Allow NULL? |
| 6 | BEARER_CAT | Security Price Adjustment Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_SPA_BEARER_CAT | Allow NULL? |
| 7 | BEARER_ID | Security Price Adjustment Bearer ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | TB_SPA_BEARER_ID | Allow NULL? |
| 8 | CASHFLOW_ID | Cash flow ID | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | TB_SPA_CASHFLOW_ID | Allow NULL? |
| 9 | IRA_DATE | Security Price Fixing Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_SPA_DATE | Allow NULL? |
| 10 | SECURITIES_ID | Security ID Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | * | VVRANLW | Allow NULL? |
| 11 | RHANDPL | Exchange | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VVRHANDPL | Allow NULL? |
| 12 | SKURSART | Rate/Price Type - Treasury Instruments | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TI_KURSART | Allow NULL? |
| 13 | SECURITIES_PRICE | Price of Unit- or Percentage-Quoted Security | decimal | 15 | 6 | DEC | ((0)) | Yes | | VVPKTKUR | |
| 14 | SECURITIES_WAERS | Quotation currency (which prices are in) | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | VVNOTWAERS | Allow NULL? |
| 15 | REGI_STATE | Status of Security Price Adjustment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_SPA_REGISTRATION_STATE | Allow NULL? |
| 16 | TERM_FROM | Start of Security Price Adjustment Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_SPA_TERM_FROM | Allow NULL? |
| 17 | IRA_TRIGGER | Security Price Adjustment Trigger | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_SPA_TRIGGER | Allow NULL? |
| 18 | FIXER_NAME | Employee ID of Person Fixing Security Price | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_SPA_FIXER_NAME | Allow NULL? |
| 19 | FIXING_DATE | System Date of Security Price Adjustment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_SPA_FIXING_DATE | Allow NULL? |
| 20 | FIXING_TIME | System Time of Security Price Adjustment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_SPA_FIXING_TIME | Allow NULL? |
| 21 | ACTIVITY_STATE | Activity Status of Security Price Adjustment Registration | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_SPA_ACTIVITY_STATE | Allow NULL? |
