Data Table for Vendor Cash Flows
- Former user (Deleted)
- Kinga Huszno
- Natalie Gesin (Deactivated)
Â
Tag # - Tag Name | Required/Optional | Data Type | Value/Description of Field |
|---|---|---|---|
1432 - Asset ID Type | OPTIONAL | CHAR | Used to identify the type of primary asset id (i.e. cusip, isin, etc.). |
14 - Asset ID | REQUIRED | CHAR | A unique identification number assigned by CUSIP, an inter-industry security coding service for each security. |
961 - Issue Name | OPTIONAL | CHAR | Issue name. |
1439 - Pool Number | OPTIONAL | CHAR | Linked to security master 'pool number'. |
68 - Issue Date | OPTIONAL | DATE (99) | The date a security was originally issued. |
38 - Maturity Date | OPTIONAL | DATE (99)  | The date the final principal payment on a debt instrument is due. |
11043 - Inactive Flag | OPTIONAL | CHAR | Used to identify whether a security is inactive. |
10 - Asset id | REQUIRED | CHAR  | Asset identifier - internal number assigned to each asset. |
3931 - Processing Security Type |  OPTIONAL | CHAR | identifies the processing security type that would be used in exception processing. |
963 - Remaining Balance WV | Â OPTIONAL | DEC (2)Â | Work variable, user defined. |
964 - Principal Flow Payments WV |  OPTIONAL | DEC (2) | Work variable, user defined. |
1109 - Effective Date | Â REQUIRED | DATE (99)Â Â | The effective date of the transaction |
11757 - Original Balance | REQUIRED | MONEYB (2) | Short Dividend Income for the entity used in SEC Yield. |
11758 - Current Balance | REQUIRED | MONEYB (2)  | Short Dividend Income for class level used in SEC Yield. |
11759 - Effective Cash Flow Coupon |  OPTIONAL | DEC (6) | The effective coupon rate used for the calculation of vendor calculated Interest component. |
11760 - Cash Flow Type | REQUIREDÂ | CHARÂ | Cash flow type. |
11761 - Requested Speed Type | REQUIREDÂ | CHARÂ | Requested speed. |
11762 Requested Speed Value |  OPTIONAL | DEC (6) | The speed value of the vendor requested Speed Value. |
11763 - Flow Date | REQUIRED | DATE (99) | The date of the interest or principal cash flow payment. |
11764 - Principal Flow | REQUIRED  | DEC (6) | The amount of total principal expected on the cash flow date. |
11765 - Interest Flow | REQUIRED | DEC (6) | The amount of total Interest expected on the cash flow date. |
11766 - Total Principal and Interest | OPTIONAL | DEC (6) | The amount of total principal and Interest expected for the entire security on the cash flow date. |
11767 - Remaining Balance | REQUIRED | DEC (6) | The amount of total principal remaining after the principal payment. |
1293 - Journal Entry Type | OPTIONAL | CHARÂ | Journal entry type. |
614 - Release Status | OPTIONAL | CHAR | The release status of the SRM record. This should be either 1, 2, or 3. |
1168 - Source Number |  OPTIONAL | INTEGER | The number assigned to the source of the data. |
2303 - Effective Date From Scrub | OPTIONAL | DATE (99) | Effective date from scrub. |
944 - Update Source | OPTIONAL | CHAR | The source or userid of the entity that last updated the table. |
98 - Source System | OPTIONAL | CHAR | The originating source system identifier. |
95 - Partition | OPTIONAL | INTEGER | The partition of a database where a position resides. |
55 - Event Type | OPTIONAL | CHAR | The business intent of the event. Used as the primary determinant in the accounting plan identification process. |
Â