| 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 | OS_GUID | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | No | | OS_GUID | |
| 3 | CC_TYPE | Commodity Curve Type | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | JBC_CCURVE_TYPE | TB_CTY_CURVE_TYPE | Allow NULL? |
| 4 | COMMODITY_ID | Commodity ID | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | TRCOT_CTY_MASTER | TRCO_COMM_ID | Allow NULL? |
| 5 | CCURVE_CAT | Commodity Curve Category | char | 1 | 0 | NUMC | (N'0') | Yes | | TAN_CCURVE_CAT | Allow NULL? |
| 6 | CCURVE_RATE_TYPE | Commodity Curve Rate Type | char | 1 | 0 | NUMC | (N'0') | Yes | | TAN_CC_RATE_TYPE | Allow NULL? |
| 7 | CTY_CURR_UNIT | Currency Unit for Commodity | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TZUNI | TCR_CTY_CURRUNIT | Allow NULL? |
| 8 | CTY_UOM | Unit of Measure for the Commodity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | TPM_CTY_UOM | Allow NULL? |
| 9 | INTERPOL_PROC | Interpolation Category | char | 1 | 0 | NUMC | (N'0') | Yes | | TAN_INTERPOL_CAT | Allow NULL? |
| 10 | READ_PROC | Market Price Read Procedure | char | 1 | 0 | NUMC | (N'0') | Yes | | TAN_READ_PROC_CAT | Allow NULL? |
| 11 | MAXDAYS | Maximal Number of Days for Readback | decimal | 3 | 0 | DEC | ((0)) | Yes | | TAN_CC_MAXAGE | |
| 12 | EXTRAPOL_PROC | Extrapolation Category | char | 1 | 0 | NUMC | (N'0') | Yes | | TAN_EXTRAPOL_CAT | Allow NULL? |
| 13 | INCLUDE_SPOT | Include Spot Price as Beginning Value of the Curve | char | 1 | 0 | CHAR | (N' ') | Yes | | TAN_INCLUDE_SPOT | Allow NULL? |
| 14 | CTY_QUOT_TYPE | Commodity Quotation Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TRCOCC_QUOTTYPE | TCR_CTY_QUOTTYPE | Allow NULL? |
| 15 | SPOT_PRICE_TYPE | Rate/Price Type - Treasury Instruments | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TI_KURSART | Allow NULL? |
| 16 | ISSUER | Issuer of the Commodity | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TPM_CTY_ISSUER | Allow NULL? |
| 17 | EXCHANGE | Exchange | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TWH01 | VVRHANDPL | Allow NULL? |
| 18 | PRICE_TYPE | Rate/Price Type - Treasury Instruments | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | TI_KURSART | Allow NULL? |
| 19 | EXPIRY_DT_LOGIC | Futures Expiry Date Logic | char | 1 | 0 | NUMC | (N'0') | Yes | | TAN_EXPIRY_DT_CAT | Allow NULL? |
| 20 | PROVIDER | Provider of Commodity Market Data | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCRC_CTY_PROVIDR | TCR_CTY_PROVIDER | Allow NULL? |
| 21 | FWD_QUOT_TYPE | Commodity Quotation Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TRCOCC_QUOTTYPE | TCR_CTY_QUOTTYPE | Allow NULL? |
| 22 | DCSID | Derivative Contract Specification ID | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | TBA_DCSID | Allow NULL? |
| 23 | MIC | Market Identifier Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TBA_MIC | Allow NULL? |
| 24 | PRICE_DET_OVERL_PER_ID | Price Determination Methods for Overlapping Periods | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | TCCT_PD_OVLPER | TAN_PRDET_OVERLAPPING_PER_ID | Allow NULL? |
| 25 | ENTERED_BY | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_CRUSER | Allow NULL? |
| 26 | ENTERED_DATE | Entered On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DCRDAT | Allow NULL? |
| 27 | ENTERED_TIME | Entry Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_TCRTIM | Allow NULL? |
| 28 | CHANGED_BY | Last Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_UPUSER | Allow NULL? |
| 29 | CHANGED_DATE | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_DUPDAT | Allow NULL? |
| 30 | CHANGED_TIME | Time changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_TUPTIM | Allow NULL? |
