| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | OS_GUID | Object Identity in Database Format | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | PARTITION_CAT | Category of Group of Distributor Flow Partitions | tinyint | 3 | 0 | | | | |
| 4 | FLOW_NUMBER | Number of a Distributor Flow | int | 10 | 0 | | | | Allow NULL? |
| 5 | PARTITION_NUMBER | Number of Partition in SLD | int | 10 | 0 | | | | Allow NULL? |
| 6 | DIS_FLOWTYPE | Update Type | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ALLOC_NMBR | Assignment Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 8 | COMPANY_CODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | VALUATION_AREA | Valuation Area | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | PRODUCT_TYPE | Product Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | TRANSACTION_TYPE | Financial Transaction Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | COM_VAL_CLASS | General Valuation Class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | VALUATION_CLASS | Valuation Class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | SECURITY_ID | Security ID Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 15 | SECURITY_ACCOUNT | Securities Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | ACCOUNT_GROUP | Securities Account Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | PORTFOLIO | Portfolio | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | TRADER | Trader | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | LOANS_CONTRACT | Contract Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 20 | DEAL_NUMBER | Financial Transaction | nvarchar | 13 | 0 | | | | Allow NULL? |
| 21 | FUND | Fund | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | GRANT_NBR | Grant | nvarchar | 20 | 0 | | | | Allow NULL? |
| 23 | POSITION_ACCOUNT | Futures Account for Listed Options and Futures | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | LOT_ID | Identifier of the Lot | varbinary | 16 | 0 | | | | |
| 25 | FLAG_LONG_SHORT | Indicator: Long or Short Position | char | 1 | 0 | | | | Allow NULL? |
| 26 | EXTERNAL_ACCOUNT | External Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | DIFF_CURRENCY | Currency as Differentiation Term | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | UNITS | Units | decimal | 22 | 6 | | | | |
| 29 | NOMINAL_CURR | Nominal Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 30 | NOMINAL_AMT | Nominal Amount | decimal | 21 | 2 | | | | |
| 31 | NOMINAL_ORG_AMT | Original Nominal Amount in Position Currency | decimal | 21 | 2 | | | | |
| 32 | POSITION_CURR | Position Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | POSITION_AMT | Amount (Position Currency) | decimal | 21 | 2 | | | | |
| 34 | POSAMT_IDX_CLEAN | Amount in Position Currency Index-Clean | decimal | 21 | 2 | | | | |
| 35 | QUANT_CAT | Position Change Category: Quantity | nvarchar | 4 | 0 | | | | Allow NULL? |
| 36 | ACTIVE_PASSIVE | Indicator: Assets/Liabilities Position | char | 1 | 0 | | | | Allow NULL? |
| 37 | LOCAL_CURR | Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 38 | LOCAL_AMT | Amount (Local Currency) | decimal | 21 | 2 | | | | |
| 39 | VALUATION_CURR | Valuation Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 40 | VALUATION_AMT | Amount in Valuation Currency | decimal | 21 | 2 | | | | |
| 41 | TRL_POS_MAN_CAT | Position Change Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 42 | FIXED_AA_REF | Account Assignment Reference of Position Management | nvarchar | 12 | 0 | | | | Allow NULL? |
| 43 | SOURCETARGET_FLG | Indicator: Source or Target of a Flow | char | 1 | 0 | | | | Allow NULL? |
| 44 | TRANSFER_GROUP | Group of Flows from a Source or Target | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | LOT_CREATION | Lot Creation Category | char | 1 | 0 | | | | Allow NULL? |
| 46 | AMOUNT_FACTOR | Value Coefficient | float | 15 | 16 | | | | |
| 47 | PAYMENT_CURR | Payment Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 48 | PAYMENT_AMT | Payment Amount | decimal | 21 | 2 | | | | |
| 49 | SIGN | Direction of flow | char | 1 | 0 | | | | Allow NULL? |
| 50 | HOUSE_BANK | Short key for own house bank | nvarchar | 5 | 0 | | | | Allow NULL? |
| 51 | HOUSE_BANK_ACC | Short key for house bank account | nvarchar | 5 | 0 | | | | Allow NULL? |
| 52 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | DUE_DATE | Due Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 54 | RPBANK | Partner bank details | nvarchar | 4 | 0 | | | | Allow NULL? |
| 55 | RPZAHL | Payer/payee | nvarchar | 10 | 0 | | | | Allow NULL? |
| 56 | SZART | Payment transaction | char | 1 | 0 | | | | Allow NULL? |
| 57 | ZLSCH | Payment Method | char | 1 | 0 | | | | Allow NULL? |
| 58 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | | | | Allow NULL? |
| 59 | SPAYRQ | Payment request allowed | char | 1 | 0 | | | | Allow NULL? |
| 60 | SPRSNG | Individual payment required | char | 1 | 0 | | | | Allow NULL? |
| 61 | SPRGRD | Determine grouping definition | char | 1 | 0 | | | | Allow NULL? |
| 62 | SCSPAY | Same direction necessary for joint payment? | char | 1 | 0 | | | | Allow NULL? |
| 63 | ZWELS | List of the Payment Methods to be Considered | nvarchar | 10 | 0 | | | | Allow NULL? |
| 64 | PAYGR | Grouping Field for Automatic Payments | nvarchar | 20 | 0 | | | | Allow NULL? |
| 65 | CALCULATION_DATE | Calculation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 66 | CALC_DATE_INCL | Inclusive indicator for beginning and end of a period | char | 1 | 0 | | | | Allow NULL? |
| 67 | COUPON_DATE | Date of the Next Coupon | nvarchar | 8 | 0 | | | | Allow NULL? |
| 68 | COUPON_SIGN | Coupon ID for Interest and Accrued Interest Calculation | char | 1 | 0 | | | | Allow NULL? |
| 69 | CALC_BEGIN | Start of Calculation Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 70 | CALC_END | End of Calculation Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 71 | EFF_INT_RATE_U | For Calculation of Amortization Amts (SAC) for Used EffInR | decimal | 10 | 7 | | | | |
| 72 | SCHED_EFF_RATE | Key for Redemption Schedule that Explains Effect. Int. Rate | int | 10 | 0 | | | | Allow NULL? |
| 73 | EFF_INT_RATE_N | Valid Effective Interest Rate for the Next Amortization | decimal | 10 | 7 | | | | |
| 74 | SCHED_FIX | Key for Fixed Redemption Schedule | int | 10 | 0 | | | | Allow NULL? |
| 75 | LANDL | Supplying Country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 76 | LZBKZ | State Central Bank Indicator | nvarchar | 3 | 0 | | | | Allow NULL? |
| 77 | RPCODE | Repetitive Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 78 | RP_TEXT | Reference Text for Repetitive Code | nvarchar | 50 | 0 | | | | Allow NULL? |
| 79 | RFHAZU | Transaction activity | nvarchar | 5 | 0 | | | | Allow NULL? |
| 80 | NORDEXT | External Reference | nvarchar | 16 | 0 | | | | Allow NULL? |
| 81 | SFGZUSTT | Transaction Activity Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 82 | BBASIS | Calculation base amount | decimal | 13 | 2 | | | | |
| 83 | PA_COMPANY_ID | Company ID of trading partner | nvarchar | 6 | 0 | | | | Allow NULL? |
| 84 | ORIGIN_DATE | Treasury Ledger Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 85 | HINSTR_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | | | Allow NULL? |
| 86 | HITEM_OID | Object Identity in Database Format | nvarchar | 32 | 0 | | | | Allow NULL? |
| 87 | PAR_USAGE | Parameter Usage | char | 1 | 0 | | | | Allow NULL? |
