Data Table for Vendor Cash Flows

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.