T

For accounting and cash balancing purposes

Date of Transaction/Posting Date

is used. If the tax effective date is different from the accounting date, use this field. An example of this is an accrued interest payment. For accounting purposes, the payment of interest is recorded according to the date of the transaction. For tax purposes, you may select to apply the interest payment to next year's return, not the current one. This field would be utilized to show a date within the following year's tax year, which would result in the tax consequences being shifted from this year to the next. For Purchase transactions, this date should match the acquired date on the Sale/Lot record.

Eight-digit code that identifies the trust account's tax officer. Leading blanks and zeros will be truncated. Example:

002

will be loaded as

2

;

0A

will be loaded as

A

;

__2

will be loaded as

2

. If you want to use 1041 Tax Return preparer information from Client Information Options, this code needs to match exactly to what was entered on that form.

Social Security number or employee identification number formatted exactly as it is to appear on reports.

The Social Security Number (SSN) or Employee Identification Number (EIN) of the beneficiary or recipient, formatted exactly as it is to appear on reports. Since this field is defined as a character field,

Applied For

can be bridged in this field. Since the

Taxpayer Id of Beneficiary

is the key to the beneficiary table, a trust account containing two or more beneficiaries, where the id is unknown, and

Applied For

is bridged, the ONESOURCE Trust Tax Load program will check the

Beneficiary Name

field to avoid overlaying 1 beneficiary on top of another. When the

Taxpayer Id

is finally bridged to ONESOURCE Trust Tax, the ONESOURCE Trust Tax Load program will again use the

Beneficiary Name

field to find the appropriate beneficiary to update.

Date of execution of a transaction. This isn't the settlement date.

Dollar amount of the transaction.

Every transaction is assigned during the load process an OTT Tax Code and transaction type. This table is maintained both at the trust accounting vendor level and Product Access Number to accommodate the unique requirements of each institution.

Tran Type	Description
6	Receipt in Kind
7	Dividend Reinvestment
8	Savings Deposit
9	Savings Withdrawal
10	Purchase Asset
20	Asset sale – (Cost Unknown)
25	Distribution in Kind
62	Adjust Federal Tax Cost
63	Adjust State Tax Cost
64	Adjust Book Value
65	Adjust Shares
69	Stock Dividend – No Odds
80	Stock Dividend – Cash in Lieu of Fractions
90	Rights Received
95	Rights Exchanged
100	Capital Gains Distribution
110	Liability Payments Received
210	Cash Disbursement
300	Purchase of Accrued Interest
301	Sale of Accrued Interest
310	Asset Income
311	Mineral Royalty
312	Depletion
315	Common Fund Distribution of Income
316	Mutual Fund
330	Cash Receipt
350	Periodic Miscellaneous Fee
375	Interest Left on Deposit
400	Added Transaction from Change System
410	Adjust Tax Code
500	Miscellaneous Adjust Tax Code and Stand-Alone Explanation Trans (Tran Type 1)
621	Asset Sale - No Gain/Loss
999	Commission Income

An abbreviated code assigned by ONESOURCE Trust Tax identifying a trust accounting system or vendor.

Unique number to help identify vendor clients. This field is required if used for split logic.

Number assigned by the trust accounting system when it is posted to the system.

If the current transaction is reversing or amending a previously posted transaction, this field contains the trust accounting system transaction number of the original transaction.

Trust accounting system codes that classify transactions by class or type (cash receipt, cash disbursement, asset sale, receipt in kind, etc.). Used by some trust accounting systems to identify common trust fund distributions and mutual fund distributions for purposes of matching cash distributions to the record types 7C and 7F.

There are requirements in several states to print the county of residence on the state income tax return. If this field is not completed and you process one of these states, the county of residence will need to be entered using the ONESOURCE Trust Tax software. Don’t confuse this field with county information necessary to prepare the PA School District report.

The value of the Lot identifier on the Trust Accounting System. At minimum, it needs to be unique for a specific account number/CUSIP (Asset ID) combination. It doesn’t require uniqueness across the entire account or PAN. This value is used to look up the affected lot for reference, research, matching security movements for identical tax lots, maintaining account/CUSIP (Asset ID) portfolio positions, and bridging back cost basis adjustments.

A number assigned by the TAV to designate the asset's security type and is informational only. Trust Tax User can use the ONESOURCE Trust Tax Security Type Mapping feature to translate this number to a description when viewing assets from a register.

Trust accounting system codes used to further classify income and expense transactions for tax accounting purposes. Used by some trust accounting systems to identify common trust fund distributions and mutual fund distributions for purposes of matching cash distributions to the applicable factors on record types 7C and 7F.

Description of "Trust System Transaction Type". If present, it is used as the 1st line of the transaction explanation on the ONESOURCE Trust Tax Software worksheet and tax return supporting statements.

Trust accounting system code, which may further sub-divide "Trust System Transaction Type". When present, these values are loaded to the ONESOURCE Trust Tax database. However, they are not used in any calculations, nor are they printed on any reports. They may be used to filter register queries.

Is used for State K1 Processing when the Type of Beneficiary is required. This will also be used to identify S-Corp's that will require a 1099-B for covered securities acquired after 2011.

Blank = No update from bridge
0 = N/A
1 = Estate/Trust
2 = Qualified Exempt organization (Corporation)
3 = Partnership
4 = C Corporation
5 = S Corporation
6 = Other
7 = Individual
8 = Estate
9 = Qualified exempt org. (trust)
A = LLC (Partnership)
B = LLC (C Corporation)
C = LLC (S Corporation)