| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | HEAD_OS_GUID | Globally Unique Identifier | varbinary | 16 | 0 | | | | |
| 3 | FGET_ID | Natural Number | int | 10 | 0 | | | | Allow NULL? |
| 4 | C_GID | Char 20 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | BRANCHING | Natural Number | int | 10 | 0 | | | | Allow NULL? |
| 6 | GFORM | Transaction Form | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | GDETAIL | Transaction Form - Detail Information | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | KATEKZ | Indicator for spot and forward transactions | char | 1 | 0 | | | | Allow NULL? |
| 9 | AGGRKZ | Indicator for aggregated transactions | char | 1 | 0 | | | | Allow NULL? |
| 10 | DBLFZ | Start of Term | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | DELFZ | End of Term/End of Period of Notice | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | SFGTYP | Buy/Sell | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | SNOTTYPE | Quotation type for option, future, security etc. | char | 1 | 0 | | | | Allow NULL? |
| 14 | SNOMWHR | Currency of Nominal Amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 15 | BNOMINAL | Nominal amount | decimal | 17 | 2 | | | | |
| 16 | ASTUECK | Number of units for unit-quoted securities | decimal | 15 | 5 | | | | |
| 17 | WGSCHFT1 | Currency of Outgoing Side | nvarchar | 5 | 0 | | | | Allow NULL? |
| 18 | WGSCHFT2 | Currency of Incoming Side | nvarchar | 5 | 0 | | | | Allow NULL? |
| 19 | BNOMI1 | Nominal amount of outgoing side | decimal | 17 | 2 | | | | |
| 20 | BNOMI2 | Nominal amount of incoming side | decimal | 17 | 2 | | | | |
| 21 | BSALDO | Residual balance of a contract (account) | decimal | 17 | 2 | | | | |
| 22 | DEFSZ | Date of fixed period end | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | RANL | Security | nvarchar | 13 | 0 | | | | Allow NULL? |
| 24 | RHANDPL | Exchange | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | CTY_ID | Commodity ID | nvarchar | 18 | 0 | | | | Allow NULL? |
| 26 | QUOTSRC | Quotation Source | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | CTY_QUANTITY | Quantity | decimal | 13 | 3 | | | | |
| 28 | CTY_UOM | Unit of Measure for the Commodity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | CSPREAD | Credit Spread | decimal | 10 | 7 | | | | |
| 30 | CSPREAD_FWD | Credit Spread | decimal | 10 | 7 | | | | |
| 31 | DVTRAB | Loan - Date of Commitment by Lender | nvarchar | 8 | 0 | | | | Allow NULL? |
