| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ACTIVE | Table entry is active (A) or in suspense (S) | char | 1 | 0 | | | | Allow NULL? |
| 3 | CLAIM | Number of Claim | nvarchar | 17 | 0 | | | | Allow NULL? |
| 4 | FUND_HDR_ID | Object GUID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 5 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | | | | |
| 6 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | | | | Allow NULL? |
| 8 | FUND_HDR_NUM | Fund Calculation Internal Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | TOTALFUNDVALUE | Total Fund Value Determined | decimal | 15 | 2 | | | | |
| 10 | TOTSURRENDVALUE | Surrender Value from Fund Settlement | decimal | 15 | 2 | | | | |
| 11 | VALUESETTINGBASE | Base Date for Value Date | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | VALUESETTBASE_DT | Value Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | VALUEDATE | Value Date on Account of Beneficiary/Payee | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | CALCBASEDONDISTR | Calculation Based on Distribution | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | TOTGROSSDRAWAM | Total Gross Withdrawal Amount | decimal | 15 | 2 | | | | |
| 16 | TOTGROSSDRAWPCT | Total Gross Withdrawal in Percent | decimal | 6 | 3 | | | | |
| 17 | TOTTRANSCHARGE | Total Transaction Charges | decimal | 15 | 2 | | | | |
| 18 | TRANSCHARGERATE | Transaction Charge Rate in Percent | decimal | 6 | 3 | | | | |
| 19 | TOTALFUNDCHARGE | Total Fund-Dependent Charges | decimal | 15 | 2 | | | | |
| 20 | TOTALREVDEDUCT | Total Reversal Deduction Fund Settlement | decimal | 15 | 2 | | | | |
| 21 | TOTNETWITHDRAWAM | Total Net Withdrawal Amount | decimal | 15 | 2 | | | | |
| 22 | WITHDRAWAMPRETAX | Total Withdrawal Amount Before Tax | decimal | 15 | 2 | | | | |
| 23 | WITHDRAWVARIANCE | Withdrawal Variance | decimal | 15 | 2 | | | | |
| 24 | TRANSCHARGEMIN | Minimum Transaction Charge | decimal | 15 | 2 | | | | |
| 25 | TRANSCHARGEMAX | Maximum Transaction Charge | decimal | 15 | 2 | | | | |
| 26 | FUNDCURR | Fund Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 27 | ORDERGENID | ID Fund Order Generation | nvarchar | 22 | 0 | | | | Allow NULL? |
| 28 | FUNDVALUEAVAIL | All Fund Prices Are Available | char | 1 | 0 | | | | Allow NULL? |
| 29 | CHARGECAT | Charge Type for Fund Transactions | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | VALUESETBASE_PM | Base Date for Value Date | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | VALSETBASE_DT_PM | Value Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | TTRANSCHARGE_PM | Total Transaction Charges | decimal | 15 | 2 | | | | |
| 33 | TCHARGERATE_PM | Transaction Charge Rate in Percent | decimal | 6 | 3 | | | | |
| 34 | FUNDVAL_MODIFIED | Entry Changed Manually by User | char | 1 | 0 | | | | Allow NULL? |
