...
Name | Mandatory? | Format | Sample | Introduced in Version | Description |
|---|---|---|---|---|---|
Date/Time | Yes | MM/DD/YYYY HH:MM:SS |
| All | Date and time of the locate in Eastern time. If time is unknown, specify as 00:00:00. |
Account | Yes | CHAR(20) |
| All | Name of the account (PropReports Account Id). Anything after the first 20 characters will be ignored. |
Offset Account | No | CHAR(20) |
| All | Optionally, name of the opposite account for the locate fee being charged. If there is no fee, this field will be ignored. |
Qty | Yes | DECIMAL(18, 8) UNSIGNED |
| All | Number of shares located. |
Symbol | Yes | CHAR(48) |
| All | Ticker symbol of the instrument being located. Please follow the symbol naming convention. |
| Columns below are optional and can be in any order. | |||||
| Category | No | CHAR(20) | P/L | 1.5.96.13 | If the locate has a fee, this is the name of an adjustment category to use. Enter a category currently defined in PropReports or one of: Software, Quotes,Interest, Dividend, Cash In/Out and Stock Locate. Leaving blank or entering an unknown category will default to Fee: Stock Locate. |
Cost | No | DECIMAL(15, 4) UNSIGNED |
| All | Total fee associated with this locate. Both positive and negative values will be processed as a fee (there is no way to post a credit). |
| Cost Per Share | No | DECIMAL(18, 8) UNSIGNED | 0.25 | All | Per share fee associated with this locate. Please specify either Cost or Cost Per Share column but not both. |
| Locate Id | No | CHAR(25) | ABC-123 | All | An external id associated with this locate. Locate Ids are not case-sensitive. |
| Source | No | CHAR(32) | Sterling | 1.5.95.50 | Source of the data being uploaded (see list of source names). If the column is not present, the source defaults to Generic. |
...