My Treasury Table Descriptions hand book (I have big hands)

Treasury - XTR_A_PARTY_INFO	Created from Entity XTR PARTY by ORACLE on 06-MAY-93
Column Name	Descritpion
ADDRESS_2	Postal address line 2.
P_ADDRESS_1	Physical address line 1.
P_ADDRESS_2	Physical address line 2.
P_ADDRESS_3	Physical address line 3.
P_ADDRESS_4	Physical address line 4.
RISK_PARTY	Indicates if the party is a risk party. Valid values are: Y (is a risk party) or N (not a risk party).
SETTLEMENT_DEFAULT_CATEGORY	Settlement default category. Foreign key to XTR_SETTLEMENT_CATEGORIES.
ADDRESS_3	Postal address line 3.
SHORT_NAME	Short name of the party.
STATE_CODE	State identifier. Free text.
SWIFT_ID
TAX_CATEGORY	Tax category idnetifier. Foreign key to XTR_TAX_CATEGORIES.
TAX_EXEMPTION_CODE	Tax exemption identifier. Free text.
TAX_NUMBER
TITLE_DESCRIPTION	Title description. Free text.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
VALUER_YN	Indicates if the party is a valuer. Valid values are: Y (is a valuer) or N (not a valuer).
ADDRESS_4	Postal address line 4.
FX_CPARTY
MM_CPARTY
LEGAL_ENTITY_ID
ADDRESS_5	Postal address line 5.
SUSPENSE_CCID
CONVERSION_TYPE
SET_OF_BOOKS_ID
CHART_OF_ACCOUNTS_ID
ADDRESS_6	Postal address line 6.
ADVISOR_YN	Indicates if the party is an advisor. Valid values are: Y (is an advisor) or N (not an advisor).
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
BRANCH_SUBSIDIARY_CODE
BRANCH_SUBSIDIARY_YN
BROKER
BROKERAGE_CATEGORY	Brokerage category identifier. Foreign key to XTR_BROKERAGE_CATEGORIES.
CLIENT_ADVICE	Indicates if confirmation advice letter is required for the party's confirmation actions. Valid values are: Y (requried) or N (not requried).
CLIENT_AGENT1	Name of the party's solicitor.
ACCOUNT_MANAGER
CLIENT_AGENT2	Name of the party's accountant.
CLIENT_AGENT3	Name of any other agent of the party.
CLIENT_GROUPING	Client group identifier. Foreign key to XTR_PARTY_GROUPS.
CLIENT_YN	Indicates if the party is a client. Valid values are: Y (is a client) or N (not a client).
COMMENTS	Additional note.
CONFO_ACTION_CODE
CONFO_GROUP_CODE	Confirmation group identifer. Composite key to XTR_CONFIRMATION_ACTIONS.
CONTACT_NAME
COUNTRY_CODE	Country identifier. Foreign key to XTR_COUNTRY_CODES.
ACCOUNT_STATUS
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CROSS_REF_TO_OTHER_PARTY
DEFAULT_ADDRESS_DETAILS
DEFAULT_COMPANY
DEPOSIT_REF
EMAIL_ADDRESS	Party's email address.
FAX_NUMBER	Party's fax number.
FULL_NAME	Full name of the party.
FX_MATCH_ID
ADDRESS_1	Name of addressee.
INTERNAL_PTY
PAGER_NUMBER
PARTY_CATEGORY
PARTY_CODE
PARTY_GROUP
PARTY_TYPE
PHONE_NUMBER	Party's contact phone number.
PI_CONSTANT

Treasury - XTR_BOND_ISSUES	Bond issues information
Column Name	Descritpion
BOND_OR_DEBENTURE_ISSUE	Not currently used
CALC_ROUNDING	Number that specifies how many digits will be carried over during mid-step calculations.
PRICING_MODEL	Specifies the pricing model used by this deal. Derived from the CODE column of the XTR_PRICE_MODELS table. All deals will have a pricing model.
MARKET_DATA_SET	Specifies the market data set used by the pricing model.
MARGIN	Specifies the margin for revaluation. This column is relevant for Bonds, Bond Options, Discounted Securities and Wholesale Term Money.
CALC_TYPE	Coupon interest calculation type
ATTRIBUTE_CATEGORY	For Descriptive Flexfield
ATTRIBUTE1	Descriptive Flexfield
ATTRIBUTE2	Descriptive Flexfield
ATTRIBUTE3	Descriptive Flexfield
COUPON_RATE	Coupon rate
ATTRIBUTE4	Descriptive Flexfield
ATTRIBUTE5	Descriptive Flexfield
ATTRIBUTE6	Descriptive Flexfield
ATTRIBUTE7	Descriptive Flexfield
COUPON_TYPE	Not currently used
ATTRIBUTE8	Descriptive Flexfield
ATTRIBUTE9	Descriptive Flexfield
ATTRIBUTE10	Descriptive Flexfield
ATTRIBUTE11	Descriptive Flexfield
CREATED_BY	User who created this record
ATTRIBUTE12	Descriptive Flexfield
ATTRIBUTE13	Descriptive Flexfield
ATTRIBUTE14	Descriptive Flexfield
ATTRIBUTE15	Descriptive Flexfield
CREATED_ON	Date this record was created
ROUNDING_TYPE	Not currently used
DAY_COUNT_TYPE	Not currently used
BENCHMARK_RATE	Benchmark rate
FLOAT_MARGIN	Margin used for Floating Rate bond
CURRENCY	Currency code
RATE_FIXING_DAY	Rate Fixing Day for Flaoting Rate Bond
MATURE_SETTLEMENT_BASIS	Business day convention for maturity dates
CALLABLE_FLAG	Y/N flag to denote if bond issue is callable
DESCRIPTION	Bond issue description
FIRST_COUPON_DATE	First coupon date to calculate cashflows from
ISSUER	Bond issuer
MATURITY_DATE	Date when the deal matures or when an action is required
NO_OF_COUPONS_PER_YEAR	Number of coupons per year for the bond issue
RIC_CODE	Reference rate from current rates
RISK_GROUP	Product type
UPDATED_BY	User who last updated this record
AUDIT_INDICATOR	Not currently used
UPDATED_ON	Date this record was last updated
YEAR_BASIS	No longer used
YEAR_CALC_TYPE	Day count basis which defines the way in which interest accrues
ACCRUED_INT_YEAR_CALC_BASIS	Day count basis which defines the way in which interest accrues over time
FORCE_MONTH_END_COUPONS	Flag to indicate if the coupon dates are to be forced to the last calendar date of the month (Y), or not (N)
AUTHORISED	Flag to indicate if the bond issue is authorized for use (Y), or not (N)
COMMENCE_DATE	Start date of the bond issue (dated date is the market term)
LAST_COUPON_DATE	Last coupon date of the bond issue
SETTLEMENT_BASIS	Method used to adjust coupon dates if they do not fall on a business day (valid values are Modified Following, Modified Previous (MP), Previous (P), and Null)
SECURITY_ID	Bond issue unique identifier issued by the government (for example, CUSSIP)
BOND_ISSUE_CODE	User-defined identifier for the bond issue
PRICE_ROUNDING	Number of decimal places used for price calculation
YIELD_ROUNDING	Number of decimal places used for yield calculation
PRICE_ROUND_TYPE	Flag to indicate whether price information should be rounded(R) or truncated(T) to the specified number of digits.
YIELD_ROUND_TYPE	Flag to indicate whether yield information should be rounded(R) or truncated(T) to the specified number of digits.

Treasury - XTR_AUTH_TYPE_SUBTYPE_PROD	Created from Entity XTR AUTH TYPE SUBTYPE PROD by ORACLE on 27-JAN-95
Column Name	Descritpion
USER_NAME	Code for Treasury users
VALIDATION_AUTHORIZED	Determines if the user has authority to validate deals of deal type, deal subtype and product type combinations
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
DEAL_SUBTYPE	Code for deal executions permissible within a deal type
DEAL_TYPE	Code for high level deals
PRODUCT_TYPE	Code for products used in a deal type

Treasury - XTR_A_PRODUCT_TYPES	Created from Entity XTR DEAL SUB-TYPE by ORACLE on 26-OCT-94
Column Name	Descritpion
CPARTY_ADVICE
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
PRODUCT_AUTH
PRODUCT_DESC
AUDIT_DATE_STORED	Date on which this record is audited.
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
REVAL_CROSS_REF
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
CREATED_BY
CREATED_ON
AUDIT_INDICATOR
CALC_BASIS
CLIENT_ADVICE	Indicates if confirmation advice letter is required for the client. Valid values are: Y (requried) or N (not requried).

Treasury - XTR_A_COUNTERPARTY_LIMITS	Created from Entity XTR COUNTERPARTY LIMIT by ORACLE on 06-MAY-93
Column Name	Descritpion
COMMITMENT_FEE_PERCENT
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
AUDIT_DATE_STORED	Date on which this record is audited.
CROSS_ALLOCATION_GROUP_CODE
EXPIRY_DATE	Expiry date of this limit.
FREQUENCY
INITIAL_FEE_DATE
LIMIT_AMOUNT	Total amount allowed for this limit.
LIMIT_CODE	Limit code identifier. Composite key to XTR_COMPANY_LIMITS.
LIMIT_TYPE	Limit type identifier. Limit type of the limit code. Limit code is foreign key to XTR_LIMIT_TYPES.
SEQUENCE_NUMBER
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
AUDIT_INDICATOR
UTILISATION_CALC_BASIS
UTILISATION_FEE_PERCENT
UTILISED_AMOUNT	Utilised amount calculated using limit weighting.
UTILIZATION_STRUCTURE_BASIS
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
BENCHMARK_REF

Treasury - XTR_DEALS	Information for all financial instrument deals except exposure transactions
Column Name	Descritpion
ACCRUED_INTEREST_PRICE	Accrued interest of the bond
CURRENCY	Currency code
CURRENCY_BUY	Currency code of buy amount
CURRENCY_SELL	Currency code of sell amount
DEALER_CODE	Code for Treasury users
DEAL_DATE	Date the deal is made
DEAL_LINKING_CODE	Code to identify the group of linked deals
DEAL_NO	Unique number assigned to each deal
DEAL_SUBTYPE	Code to sub-categorize deals within each deal type
DEAL_TYPE	Code to identify a deal or instrument type
DISCOUNT	Flag to indicate if the interest rate is of discount (Y) or yield basis (N)
ACTION_STATUS	Not currently used
DRAWER_CODE	Drawer code (party in a discounted securities deal who is responsible for paying if the acceptor and endorser defaults on the payment)
DRAWER_NAME	Drawer name
DUAL_AUTHORISATION_BY	Login name of user who created the deal (only applies if the Treasury system parameter, DUAL_AUTHORISE, is set to Y)
DUAL_AUTHORISATION_ON	Date the user created the deal (only applies if the Treasury system parameter, DUAL_AUTHORISE, is set to Y)
ENDORSER_CODE	Endorser code (party in a discounted securities deal who is responsible for paying the negotiable instruments if the acceptor defaults on the payment)
ENDORSER_NAME	Endorser name
ENTER_INTO_SWAP	Reference number for an interest rate swap
EXCHANGE_CODE	Not currently used
EXERCISE	Flag to indicate if an option has been exercised (Y), or not (N)
EXPIRY_DATE	Price at which the security underlying the options contract may be bought or sold
ARCHIVE_BY	Not currently used
EXTERNAL_COMMENTS	External comments
EXTERNAL_CPARTY_NO	External reference
FACE_VALUE_AMOUNT	Amount that the issuer agrees to pay at maturity date
FACE_VALUE_HCE_AMOUNT	Face value in reporting currency equivalent
FIRST_REVAL	Not currently used
FIXED_OR_FLOATING_RATE	Code to indicate if the interest rate is fixed (FIXED) or floating (FLOAT)
FIXED_TERM_MY	Code to identify the term of the fixed interest rate period (M for month, or Y for year)
FORWARD_HCE_AMOUNT	Amount difference in reporting currency equivalent between the buy and sell amounts in a forward foregin echange deal
FRA_DESCRIPTION	Not currently used
FREQUENCY	Payment frequency
ARCHIVE_DATE	Not currently used
FXD_DEAL_NO	Deal number of the first part of a foreign exchange swap deal
FXO_DEAL_NO	Deal number of the foreign exchange option deal from which this deal was generated
FX_COVER_CROSS_REF	Deal number of the bond that was partially sold
FX_PD_DEAL_NO	Number of the deal from which deal was pre-delivered
FX_REVALUED_ON_DATE	Date the foreign exchange deal was valued
FX_RO_DEAL_NO	Number of the deal from which this foreign exchange deal was rolled over
FX_SUBSIDIARY_BALANCE_AMOUNT	Not currently used
FX_WHOLESALE_REF	Number of the parent deal for this subsidiary foreign exchange deal
INSERT_FOR_CASHFLOW	Flag to indicate if the cashflow row of a foreign exchange option is to be inserted into XTR_DEAL_DATE_AMOUNTS table (Y), or not (N)
INTEREST_AMOUNT	Interest amount
ATTACHMENT_EXISTS	Not currently used
INTEREST_CUTOFF	Not currently used
INTEREST_HCE_AMOUNT	Interest amount in reporting currency equivalent
INTEREST_RATE	Agreed upon rate expressed as a percentage per annum
INTERNAL_TICKET_NO	Internal reference
INT_SWAP_REF	Unique reference for interest rate swap deals
KNOCK_EXECUTED_BY	Treasury user who executed the foreign exchange knock option
KNOCK_EXECUTED_ON	Date the foreign exchange knock option is executed
KNOCK_INSERT_TYPE	Not currently used
KNOCK_LEVEL	Knock rate
KNOCK_TYPE	Flag to indicate if the foreign exchange option deal is an knock in (I), knock out (O), or standard (null) option type
ACCEPTOR_CODE	Acceptor code (party in a discounted securities deal who is responsible for the payment at maturity)
AUDIT_INDICATOR	Not currently used
LIMIT_AMOUNT	Maximum amount allowed by the limit
LIMIT_CODE	Code for user-defined limits imposed on deals and transactions
MARGIN	Not currently used
MATURITY_ACCOUNT_NO	Company account for the face value settlement for discounted securities deals
MATURITY_AMOUNT	Amount that the issuer agrees to pay at the maturity date
MATURITY_BALANCE_AMOUNT	Face value balance of discounted securities deals
MATURITY_BALANCE_HCE_AMOUNT	Face value balance in reporting currency equivalent
MATURITY_DATE	Date the deal matures or an action is required
MATURITY_HCE_AMOUNT	Maturity amount in reporting currency equivalent
NEXT_COUPON_DATE	Maturity amount in reporting currency equivalent
BASE_DATE	Deal date
NI_DEAL_NO	Not currently used
NI_PROFIT_LOSS	Profit or loss amount for discounted securities deals
NO_OF_DAYS	Number of days used to calculate interest
OPTION_AMOUNT	Not currently used
OPTION_COMMENCEMENT	Date the option can start to be exercised
OPTION_HCE_AMOUNT	Not currently used
OPTION_POINTS	Break even rate for an option deal (the rate at which the premium is recovered)
OPTION_TYPE	Code to indicate whether the option is American (AMERICAN) or European (EUROPEAN)
PAYMENT_FREQ	Payment frequency for retail and wholesale term money deals
PAYMENT_SCHEDULE_CODE	Payment schedule code
BASE_RATE	Spot rate from which points are added or subtracted to produce the forward rate
PI_AMOUNT_DUE	Total amount of principal and interest for retail term money deals
PORTFOLIO_AMOUNT	Portfolio amount
PORTFOLIO_CODE	Code for grouping deals under a single portfolio
PREMIUM_ACCOUNT_NO	Code for grouping deals under a single portfolio
PREMIUM_ACTION	Premium action code
PREMIUM_AMOUNT	Option premium amount
PREMIUM_AMOUNT_TYPE	Not currently used
PREMIUM_CURRENCY	Currency code of the option premium
PREMIUM_DATE	Date the option premium is paid or received
BKGE_SETTLED_REFERENCE	Brokerage settlement reference number (all transactions with the same reference number were settled together in one settle action)
PREMIUM_HCE_AMOUNT	Premium in reporting currency equivalent
PREMIUM_NO_OF_DAYS	Not currently used
PRINCIPAL_SETTLED_BY	Client settlement action code (C for Clearing Account, D for Direct To Counterparty, or A for Account)
PRINTED_CPARTY_ADVICE	Not currently used
PRINTED_YN	Flag to indicate if the confirmation letter is printed (Y), or not (N)
PRODUCT_TYPE	Code for products used in a deal type
QUICK_INPUT	Flag to indicate if the deal is generated from a quick input deal (Y), or not (N)
RATE_BASIS	Source for interest rate quotes (for example, LIBOR)
REF_CCY	Base currency code
RENEG_DATE	Not currently used
RISKPARTY_CODE	Code to identify the risk party
BOND_ISSUE	Bond or Stock issue code
RISKPARTY_LIMIT_CODE	Limit code against the risk party
SECURITY_NAME	Security name
SELL_ACCOUNT_NO	Company account that serves as the source of the settlement in the sell currency of a foreign exchange deal
SELL_AMOUNT	Amount in the sell currency of a foreign exchange deal
SELL_HCE_AMOUNT	Amount in the sell currency of a foreign exchange deal in reporting currency equivalent
SETTLE_ACCOUNT_NO	Company account used for the settlement funds on deal exercise or settlement
SETTLE_ACTION	Code to identify the settlement action
SETTLE_AMOUNT	Amount settled
SETTLE_AMOUNT_TYPE	Not currently used
SETTLE_DATE	Settlement date
BOND_PROFIT_LOSS	Profit or loss of a bond type deal
SETTLE_DUAL_AUTHORISATION_BY	User who authorized the deal settlement
SETTLE_DUAL_AUTHORISATION_ON	Date the deal settlement is authorized
SETTLE_HCE_AMOUNT	Settlement amount in reporting currency equivalent
SETTLE_NO_OF_DAYS	Not currently used
SETTLE_RATE	Current market rate on which settlement funds are calculated on deal exercise or settlement
SPOT_RATE_ON_VALUATION	Not currently used
START_ACCOUNT_NO	Company settlement account number for short term money deals
START_AMOUNT	Amount to be settled on the start date for discounted securities deals
START_DATE	Date the deal starts
START_HCE_AMOUNT	Consideration value in reporting currency equivalent
BOND_RENEG_DATE	Date the bond deal was resold
STATUS_CODE	Code for the execution status of deals and transactions
SWAP_DEPO_ADJUSTMENT	Not currently used
SWAP_DEPO_FLAG	Not currently used
SWAP_DEPO_INT_RATE	Not currently used
SWAP_DEPO_TOTAL_RECEIPT	Not currently used
SWAP_REF	Number (or swap reference) of the bond (or interest rate swap) generated by exercising the option
SYNTHETIC_PRINTED_YN	Not currently used
TAX_AMOUNT	Tax amount
TAX_AMOUNT_HCE	Tax amount in reporting currency equivalent
TAX_CODE	Code to indentify the tax
BOND_RESALE_DATE	Not currently used
TAX_RATE	Withholding tax rate
TAX_SETTLED_REFERENCE	Reference number of the tax settlement of the deal
TERM_MY	Not currently used
TOTAL_PRICE	Full market value of a bond, including accrued interest, expressed as a percentage of its face value
TRANSACTION_CROSS_REF	Not currently used
TRANSACTION_NO	Unique reference number assigned to a transaction
TRANSACTION_RATE	Foreign exchange rate
UPDATED_BY	User who last updated this record
UPDATED_ON	Date this record was last updated
VALUE_DATE	Date the foreign exchange deal takes place
YEAR_BASIS	Number of days in a year to use in calculate interest (for example, 360 and 365)
YEAR_CALC_TYPE	Day count basis which defines the way in which interest accrues over time
YIELD_AMOUNT	Interest amount
YIELD_HCE_AMOUNT	Interest amount in reporting currency equivalent
RATE_FIXING_DATE	Date the deal rate changes from fixed to floating
SECURITY_ID	Bond issue unique identifier issued by the government (for example, CUSSIP)
EXERCISE_PRICE	Price at which the security underlying the options contract may be bought or sold
BROKER	Code to identify the broker
KNOCK_EXECUTE_DATE	The effective date on which the knock is executed
PRICING_MODEL	Specifies the pricing model used by this deal. Derived from the CODE column of the XTR_PRICE_MODELS table. All deals will have a pricing model.
MARKET_DATA_SET	Specifies the market data set used by the pricing model.
INITIAL_FAIR_VALUE	Stores the calculated initial fair value
ACCEPTOR_NAME	Acceptor name
BROKERAGE_AMOUNT	Fee paid to a broker to execute a trade
EXCHANGE_RATE_ONE	This exchange rate is mandatory for all single and double currency deal types.
EXCHANGE_RATE_TWO	This exchange rate is used for double currency deal types.
FIRST_REVAL_BATCH_ID	Denotes the number of the first revaluation batch that this rollover transaction belongs to.
LAST_REVAL_BATCH_ID	The batch id in which the realized gain/loss of the deal/transaction was calculated.
BROKERAGE_AMOUNT_HCE	Brokerage amount in reporting currency equivalent
ATTRIBUTE_CATEGORY	For Descriptive Flexfield
ATTRIBUTE1	Descriptive Flexfield
ATTRIBUTE2	Descriptive Flexfield
ATTRIBUTE3	Descriptive Flexfield
BROKERAGE_CODE	Brokerage code
ATTRIBUTE4	Descriptive Flexfield
ATTRIBUTE5	Descriptive Flexfield
ATTRIBUTE6	Descriptive Flexfield
ATTRIBUTE7	Descriptive Flexfield
BOND_SALE_DATE	Date a bond deal is sold
ATTRIBUTE8	Descriptive Flexfield
ATTRIBUTE9	Descriptive Flexfield
BROKERAGE_CURRENCY	Currency code of brokerage amount
ATTRIBUTE10	Descriptive Flexfield
ATTRIBUTE11	Descriptive Flexfield
BROKERAGE_RATE	Rate that a company charges a counterparty or that a counterparty pays to a company for brokered deals
ATTRIBUTE12	Descriptive Flexfield
ATTRIBUTE13	Descriptive Flexfield
ATTRIBUTE14	Descriptive Flexfield
ATTRIBUTE15	Descriptive Flexfield
BUY_ACCOUNT_NO	Company account that serves as the receiver of the settlement in the buy currency of a foreign exchange deal
PROFIT_LOSS	Realized gain/loss of the original FX deal, if the deal is rollover or predelivered.
FX_RO_PD_RATE	The transaction rate of the rollover/predelivered deal.
FX_M1_DEAL_NO	The deal number of the new rollover/predelivery deal for multiple deals that are rolled/predelivered into a single deal.
EXTERNAL_DEAL_ID	This stores the external unique primary identifier for each deal.
BUY_AMOUNT	Amount in the buy currency of a foreign exchange deal
REQUEST_ID	Keeps track of the concurrent request during which this row was created or updated.
PROGRAM_APPLICATION_ID	With PROGRAM_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_ID	With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_UPDATE_DATE	Stores the data on which the concurrent program
BUY_HCE_AMOUNT	Buy amount in reporting currency equivalent
FORCE_MONTH_END	ndicates whether a start date of 28, 29, 30 was forced for a month end for subsequent records or not.
QUANTITY	Not currently used
REMAINING_QUANTITY	Not currently used
CALC_BASIS	Method of calculating interest (for example, discount basis or yield basis)
ROUNDING_TYPE	Not currently used
SETTLE_ROUNDING_TYPE	Not currently used
SETTLE_DAY_COUNT_TYPE	Not currently used
ORIGINAL_AMOUNT	Not currently used
CAPITAL_PRICE	Dirty price of the bond (full market value of the bond issue minus the accrued interest, expressed as a percentage of the issue?s face value)
DAY_COUNT_TYPE	Not currently used
INCOME_TAX_CODE	Not currently used
INCOME_TAX_RATE	Not currently used
PREPAID_INTEREST	Identify whether it is prepaid interest deal
ACCRUAL_FROM	Not currently used
CAP_OR_FLOOR	Type of option Call (C) or Put (P)
INCOME_TAX_AMOUNT	Income Tax Amount.
INCOME_TAX_SETTLED_REF	Income Tax Settled Reference.
CPARTY_ACCOUNT_NO	Counterparty bank account number
MATURE_SETTLEMENT_BASIS	Business day convention for maturity dates
CLIENT_ADVICE	Not currently used
PAYMENT_SETTLEMENT_BASIS	Business day convention for interest due on dates.
BUY_ACCT_USE_ID	Company account for the receiver of the settlement in the buy currency of a foreign exchange deal
SELL_ACCT_USE_ID	Company account for the source of the settlement in the sell currency of a foreign exchange deal
MATURITY_ACCT_USE_ID	Company account for the face value settlement for discounted securities deal
CLIENT_CODE	Type of option (C for Call or P for Put)
PREMIUM_ACCT_USE_ID	Company account used for premiums
SETTLE_ACCT_USE_ID	Company account used for the settlement funds on deal exercise or settlement
START_ACCT_USE_ID	Company settlement account ID for short term money deals
CPARTY_ACCT_USE_ID	Counterparty account ID
CLIENT_REF	Client account reference
CLIENT_ACCOUNT_NO	Client bank account number
CLIENT_ACCT_USE_ID	Client account ID
COMMENCE_DATE	Not currently used
COMMENTS	Internal comments
COMPANY_CODE	Company code
CONTRACT_COMMISSION	Not currently used
CONTRACT_FEES	Not currently used
CONTRACT_NOS	Not currently used
ACCRUAL_TO	Not currently used
CONTRACT_RATE	Not currently used
COUPON_ACTION	Code to identify coupon action
COUPON_RATE	Interest rate that the issuer agrees to pay the investor
CPARTY_ADVICE	Not currently used
CPARTY_CODE	Counterparty code
CPARTY_REF	Counterparty account reference code
CREATED_BY	User who created this record
CREATED_ON	Date this record was created
CTY_CCY	Contra currency in a foreign exchange currency quote
CUM_COUPON_DATE	Upcoming coupon date

Treasury - XTR_DEAL_CONTACTS	Created on 28-MAR-96
Column Name	Descritpion
EMAIL_ADDRESS
FAX_NUMBER
PARTY_CODE
PHONE_NUMBER
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
CONTACT_NAME
TELEX_NUMBER
TITLE_DESCRIPTION
CURRENCY
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.

Treasury - XTR_A_REVALUATION_RATES	Created on 01-FEB-95
Column Name	Descritpion
CURRENCYB
DAY_MTH
ENTERED_BY
ENTERED_ON
NUMBER_OF_DAYS
AUDIT_DATE_STORED	Date on which this record is audited.
PERIOD_FROM
PERIOD_REF1
PERIOD_REF2
PERIOD_TO
RATE_DATE
REVAL_PRODUCT_TYPE	Obsolete
REVAL_RATE
REVAL_SUBTYPE	Obsolete
REVAL_TYPE
UNIQUE_REF_NUM
AUDIT_INDICATOR
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
VOLATILITY_OR_RATE
CREATED_BY
CREATED_ON
BATCH_ID	Identifier that groups events into one process flow
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
BID	The bid rate
BID_OVERWRITE	The overwrite bid rate
ASK	The ask rate
ASK_OVERWRITE	The overwrite ask rate
CURRENCYA
DAY_COUNT_BASIS	The day count basis

Treasury - XTR_A_BANK_ACCOUNTS	Created from Entity XTR BANK ACCOUNT by ORACLE on 06-MAY-93
Column Name	Descritpion
BANK_CODE	Bank identifier.
YEAR_CALC_TYPE
CASHPOOL_ID	Physical cashpool ID
BANK_NAME	Name of the bank.
BANK_SHORT_CODE
CASHFLOWS_TO_CURRENT_DATE
CREATED_BY	User who created this record.
ACCOUNT_NUMBER	Settlement account number.
CREATED_ON	User who created this record.
CURRENCY
CURRENT_CASHFLOW_DATE
DEFAULT_ACCT
DIRECT_DEBIT_AUTHORITY
EFT_SCRIPT_NAME
EFT_SCRIPT_OUTPUT_PATH
CODE_COMBINATION_ID
GL_COMPANY_CODE
INTEREST_CALCULATION_BASIS
AUDIT_DATE_STORED	Date on which this record is audited.
INTEREST_RATE
INTERNAL_PTY
LOCATION
LIMIT_CODE
OPENING_BALANCE
OPENING_BAL_HCE
PARTY_CODE
PARTY_TYPE
AUDIT_INDICATOR
PORTFOLIO_CODE
PRIMARY_SETTLEMENT_METHOD
PARTY_PRIN_CCID
PARTY_INT_CCID
PROJECTED_BALANCE
PROJECTED_BALANCE_DATE
PROJECTED_BALANCE_UPDATED_ON
SETOFF
SETOFF_ACCOUNT_YN
SETOFF_COMPANY
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
STATEMENT_DATE
STREET
SUB_ACCOUNT_AT
SUB_ACCOUNT_NUMBER
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
DOMICILED_CURRENCY

Treasury - XTR_DATE_AMOUNT_TYPES	Information on date, amount type combinations for deal types
Column Name	Descritpion
CASHFLOW_REPORT	Not currently used
DATE_TYPE	Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates)
DEAL_TYPE	Code for high level deals
MATURITY_REPORT	Flag to indicate if the date amount type will be included in maturity reports (Y), or not (N)
PAY_RECEIVE_REPORT	Not currently used
AMOUNT_TYPE	Code that identifies the purpose of the amounts for a deal type

Treasury - XTR_BANK_BAL_INTERFACE	The XTR_BANK_BAL_INTERFACE table contains specific bank account balance information that will be uploaded into Oracle Treasury
Column Name	Descritpion
COMPANY_CODE	Company code
TRANSFER_SUCCEEDED	Flag to indicate if a balance transfer is successful (Y), or not (N)
ACCOUNT_NO	Alpha-numeric reference to financial accounts of Treasury parties for settlement purposes
AMOUNT_ADJ	Adjustment balance amount corresponding to the adjustment balance amount of bank balances.
AMOUNT_CFLOW	Cashflow balance amount corresponding to the cashflow balance amount of bank balances.
ONE_DAY_FLOAT	1-day float bank balance
TWO_DAY_FLOAT	2-day float bank balance
AMOUNT	Balance amount
BANK_ACCT_USE_ID	ID reference to financial accounts of Treasury parties for settlement purposes
BALANCE_DATE	Balance date

Treasury - XTR_ACCRUAL_AMORTISE_SETUP	Created from Entity XTR END OF MONTH ADJ by ORACLE on 16-APR-96
Column Name	Descritpion
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
FROM_DATE_TYPE
METHOD
PORTFOLIO
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
ACCRUE_AMORTISE
TO_DATE_TYPE
AMOUNT_TYPE	Identifies the purpose of the amount. For example, 'PREMIUM', 'FEE', 'SETTLE'. Composite key to XTR_AMOUNT_TYPES.
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.

Treasury - XTR_A_SETTLEMENT_CATEGORIES	Created on 27-JAN-95
Column Name	Descritpion
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR
DESCRIPTION
SETTLEMENT_CATEGORY

Treasury - XTR_A_PRO_PARAM	Created by ORACLE on 20-FEB-95
Column Name	Descritpion
PARAM_TYPE
PARAM_VALUE	Value of the parameter.
UNIQUE_REF_NUM	Parameter identifier. Unique key to XTR_PRO_PARAMS.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
AUDIT_DATE_STORED	Date on which this record is audited.
CREATED_BY
CREATED_ON
AUDIT_INDICATOR
DESCRIPTION	Description of the parameter.
PARAM_NAME	Parameter name.

Treasury - XTR_A_DEAL_ORDERS	Created from Entity XTR DEALS by ORACLE on 28-NOV-94
Column Name	Descritpion
CCY_A_AMOUNT
CCY_B_AMOUNT
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CONFIRMED_BY_DEALER
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.
ABOVE_OR_BELOW_LEVEL	Indicates if Order Rate is above or below the Current Market Rate. The Order Rate cannot be equal to Current Market Rate. Valid values are: ABOVE, BELOW.
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CROSS_REF
DEALER_COMPANY
DEALER_CPARTY
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
DETAILS_OF_ORDER
GROUP_ACTION
MARKET_RATE_WHEN_ENTERED	Current Market Rate for this deal type, deal subtype and product type combination.
ADVICE_GROUP
ORDER_CCY_A
ORDER_CCY_B
ORDER_DELIVERY_DATE
ORDER_GROUP
ORDER_RATE	Order Rate for this deal type, deal subtype and product type combination.
ORDER_TYPE
PLACED_ON
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
RIC_CODE
SOURCE
AUDIT_DATE_STORED	Date on which this record is audited.
STATUS_CODE
UNIQUE_REF_NUM	Deal order identifier. Unique key to XTR_DEAL_ORDERS.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
VALID_UNTIL
AUDIT_INDICATOR

Treasury - XTR_A_DEALER_LIMITS	Created by ORACLE on 25-JUL-96
Column Name	Descritpion
CREATED_ON	Date on which this record is created.
DEALER_CODE	Dealer identifier. Foreign key to XTR_DEALER_CODES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
LIMIT_AMOUNT	Total amount allowed for this limit.
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
AUDIT_DATE_STORED	Date on which this record is audited.
SINGLE_DEAL_LIMIT_AMOUNT	Maximum amount allowed on each deal by this dealer.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
UTILISED_AMOUNT	Utilised amount calculated using limit weighting.
AUDIT_INDICATOR
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
CREATED_BY	User who created this record.

Treasury - XTR_ARCHIVE_SETUP	Created by ORACLE on 02-JUN-95
Column Name	Descritpion
ARCHIVE_FREQ_WEEKS
LAST_ARCHIVE_DATE
OLDER_THAN_MONTHS
TABLE_NAME

Treasury - XTR_ARCHIVE_ERROR_LOG	Created by ORACLE on 02-JUN-95
Column Name	Descritpion
NOTE
TABLE_NAME
DATE_OF_ARCHIVE
DATE_OF_ERROR
ERROR_NUMBER
ERROR_TEXT

Treasury - XTR_ARCHIVE_DETAILS	Created by ORACLE on 02-JUN-95
Column Name	Descritpion
TABLE_NAME
ARCHIVE_BY	User who archived this record.
ARCHIVE_DATE	Date on which this record is archived.
ARCHIVE_WHEN_ROWS_EXCEED
CURRENT_NOS_ROWS

Treasury - XTR_DEALER_CODES	Treasury users information
Column Name	Descritpion
DEALER_CODE	Code for Treasury users
DEALER_USER_NAME	Name for Treasury users
USER_ID	Treasury user identifier
UPDATED_BY	User who last updated this record
UPDATED_ON	Date this record was last updated
AUDIT_INDICATOR	Not currently used
CREATED_BY	User who created this record
CREATED_ON	Date this record was created
ALLOW_OVERRIDE	Not currently used

Treasury - XTR_DATA_FEED_CODES	Created by ORACLE on 30-MAY-96
Column Name	Descritpion
LAST_FEED_UPDATE
MOVEMENT_INDICATOR
PRICE_DESCRIPTION
RATE_ALERT_EXISTS
REF_CCY_CODE_A
ASK_PRICE
REF_CCY_CODE_B
RIC_CODE
SELECTED_FOR_MONITORING
SOURCE
SPREAD_BASIS
WHOLESALE_RETAIL_RATE
REF_NUMBER
BID_PRICE
EXTERNAL_REF_CODE	Market data code defined by the feed source
DDE_CONVERSATION_CODE
LAST_ARCHIVE_TIME

Treasury - XTR_BUY_SELL_COMBINATIONS	Buy and sell currency combination information
Column Name	Descritpion
CURRENCY_SECOND	Contra currency in a foreign exchange currency quote
CURRENCY_SELL	Currency code for sell amount
LATEST_CROSS_DATE	Most recent currency combination cross date
LATEST_CROSS_RATE	Most recent currency combination cross rate
UPDATED_BY	User who last updated this record
AUDIT_INDICATOR	Not currently used
UPDATED_ON	Date this record was last updated
CREATED_BY	User who created this record
CREATED_ON	Date this record was created
AUTHORISED	Flag to indicate if the buy, sell currency combination is authorized for use (Y), or not (N)
CURRENCY_BUY	Currency code for buy amount
CURRENCY_FIRST	Base currency

Treasury - XTR_A_JOURNALS	Created from Entity XTR JOURNALS by ORACLE on 11-MAY-94
Column Name	Descritpion
CANCELLED_IN_GL
COMMENTS	Additional note.
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CREDIT_AMOUNT
CURRENCY
DEAL_NUMBER	Deal identifier. Foreign key to XTR_DEALS.
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
DEBIT_AMOUNT
CODE_COMBINATION_ID
GL_TRANSFER_DATE
JNL_REVERSAL_IND
AMOUNT_TYPE	Identifies the purpose of the amount. For example, 'PREMIUM', 'FEE', 'SETTLE'. Composite key to XTR_AMOUNT_TYPES.
JOURNAL_DATE
PORTFOLIO_CODE
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
TRANSACTION_NUMBER
TRANSFER_TO_EXTERNAL_GL
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
SET_OF_BOOKS_ID
AUDIT_DATE_STORED	Date on which this record is audited.
SUSPENSE_GL
ACCOUNTED_DR
ACCOUNTED_CR
GL_SL_LINK_ID
AUDIT_INDICATOR
SETTLEMENT_NUMBER

Treasury - XTR_DEAL_TYPES	Deal type information
Column Name	Descritpion
USER_DEAL_TYPE	User-defined deal type code
FROM_DATE_TYPE	Not currently used
FX_MM_EXP_FLAG	Flag to indicate if the deal type is Foreign Exchange (FX), Money Market (MM) or Exposures (EXP)
METHOD	Not currently used
NAME	Deal type description
ACCRUE_AMORTISE	Not currently used
TO_DATE_TYPE	Not currently used
SEEDED_DESCRIPTION	Pre-defined deal type description
UPDATED_BY	User who last updated this record
AMOUNT_TYPE	Code that identifies the purpose of the amounts for a deal type
AUTHORISED	Flag to indicate if the deal type is authorized for use (Y), or not (N)
DEAL_TYPE	Code for high level deals

Treasury - XTR_BANK_ACCOUNTS	Bank account information
Column Name	Descritpion
BANK_SHORT_CODE	Bank short code
ATTRIBUTE_CATEGORY	For Descriptive Flexfield
ATTRIBUTE1	Descriptive Flexfield
ATTRIBUTE2	Descriptive Flexfield
ATTRIBUTE3	Descriptive Flexfield
CASHFLOWS_TO_CURRENT_DATE	Not currently used
ATTRIBUTE4	Descriptive Flexfield
ATTRIBUTE5	Descriptive Flexfield
ATTRIBUTE6	Descriptive Flexfield
ATTRIBUTE7	Descriptive Flexfield
CREATED_BY	User who created this record
ATTRIBUTE8	Descriptive Flexfield
ATTRIBUTE9	Descriptive Flexfield
ATTRIBUTE10	Descriptive Flexfield
ATTRIBUTE11	Descriptive Flexfield
CREATED_ON	Date this record was created
ATTRIBUTE12	Descriptive Flexfield
ATTRIBUTE13	Descriptive Flexfield
ATTRIBUTE14	Descriptive Flexfield
ATTRIBUTE15	Descriptive Flexfield
CURRENCY	Currency code
AP_BANK_ACCOUNT_ID	No longer used
ROUNDING_TYPE	Method used to round the calculated interest amount. R or NULL - Round, T - Truncate, U - Round Up
DAY_COUNT_TYPE	Method used to calculate number of days for calculating interest. NULL - Current Logic, F - First Day type, L - Last Day type, B - Both Days type
PRICING_MODEL	Bank Account pricing model
ACCOUNT_NUMBER	Alpha-numeric reference to financial accounts of Treasury parties
CURRENT_CASHFLOW_DATE	Not currently used
LEGAL_ACCOUNT_NAME	Legal account name
TARGET_BALANCE	No longer used
CASHFLOW_DISPLAY_ORDER	No longer used
DUMMY_BANK_ACCOUNT_ID	No longer used
DEFAULT_ACCT	Flag to indicate if the account is the default account (Y), or not (N)
BANK_BRANCH_ID	Stores the origin bank ID.
BANK_ACCT_USE_ID	Stores the cross-reference AP bank account ID
MAX_TARGET_BALANCE	No longer used
CASHPOOL_MIN_PAYMENT_AMT	Minimum payment amount
DIRECT_DEBIT_AUTHORITY	Flag to indicate whether the company has direct debit authority to this account (Y), or not (N)
CASHPOOL_MIN_RECEIPT_AMT	Minimum receipt amount
CASHPOOL_ROUND_FACTOR	Rounding factor
CASHPOOL_ROUND_RULE	Rounding rule
CASHPOOL_ID	Physical cashpool ID
EFT_SCRIPT_NAME	Settlement script
CE_BANK_ACCOUNT_ID	Bank Balance Id
IBAN
EFT_SCRIPT_OUTPUT_PATH	EFT script output path
CODE_COMBINATION_ID	Unique key for identifying GL account references
GL_COMPANY_CODE	General Ledger company code
INTEREST_CALCULATION_BASIS	Interest calculation basis (STEP or FLAT)
INTEREST_RATE	Interest rate
INTERNAL_PTY	Flag to indicate if the party is an internal party (Y), or not (N)
AUDIT_INDICATOR	Not currently used
LOCATION	Bank location
LIMIT_CODE	Code for user-defined limits imposed on deals and transactions
OPENING_BALANCE	Opening balance
OPENING_BAL_HCE	Opening balance in reporting currency equivalent
PARTY_CODE	Party code
AUTHORISED	Flag to indicate if the bank account is authorized for use (Y), or not (N)
PARTY_PRIN_CCID	No longer used. Code combination identifier of the general ledger account used to account for the principal cash flows of an intercompany account
PARTY_INT_CCID	No longer used. Code combination identifier of the general ledger account used to account for the interest cash flows of an intercompany account
BANK_CODE	Bank code
PARTY_TYPE	Flag to indicate if the party is a company (C) or counterparty (CP)
PORTFOLIO_CODE	Code for grouping deals under a single portfolio
PRIMARY_SETTLEMENT_METHOD	Not currently used
PROJECTED_BALANCE	Projected balance of bank account based on future recorded cashflows
PROJECTED_BALANCE_DATE	Projected balance date
PROJECTED_BALANCE_UPDATED_ON	Date the projected balance was last updated
SETOFF	Setoff code of the nominal account
SETOFF_ACCOUNT_YN	Flag to indicate if the account is a nominal account (Y), or not (null)
SETOFF_COMPANY	Party code of the nominal account associated with this setoff account
STATEMENT_DATE	Statement date
STREET	Street name
BANK_NAME	Bank name
SUB_ACCOUNT_AT	Not currently used
SUB_ACCOUNT_NUMBER	Not currently used
UPDATED_BY	User who last updated this record
UPDATED_ON	Date this record was last updated
DOMICILED_CURRENCY	National currency in which the bank can make settlements (only applies to euro currency accounts)
YEAR_CALC_TYPE	Day count basis which defines the way in which interest accrues over time
SWIFT_ID	Bank transit identifier

Treasury - XTR_AUTH_CCY_COMBINATIONS	Currency combination information including whether a combination is authorised for use
Column Name	Descritpion
CURRENCY_QUOTE_FIRST	Base currency
CURRENCY_QUOTE_SECOND	Contra currency in a foreign exchange currency quote
FX_SEQ_NO	No longer used
LAST_TRANSACTION_CHANGED	Date the transaction was last changed
UPDATED_BY	User who last updated this record
AUDIT_INDICATOR	Not currently used
UPDATED_ON	Date this record was last updated
FORWARD_POINT_FACTOR	The exponent for basis points in forward point entry.
AUTHORISED	Flag to indicate if the currency combination is authorized for use (Y), or not (N)
CREATED_BY	User who created this record
CREATED_ON	Date this record was created

Treasury - XTR_ARCHIVE_HISTORY	Created by ORACLE on 02-JUN-95
Column Name	Descritpion
NUM_RECORDS_ARCHIVED
OLDER_THAN_MONTHS
RECORDS_LEFT_IN_TABLE
TABLE_NAME
DATE_OF_ARCHIVE
MAX_EXTENTS
NOTE
NUM_EXTENTS_BEFORE

Treasury - XTR_A_PARTY_DEFAULTS	Created from Entity XTR PARTY by ORACLE on 17-NOV-94
Column Name	Descritpion
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
DEFAULT_TYPE
DFLT_INTEREST_ACTION
DFLT_PRINCIPAL_ACTION
AUDIT_DATE_STORED	Date on which this record is audited.
FREQ_INTEREST_SETTLED
INTEREST_SETTLED_BY
PARTY_CODE
PRINCIPAL_SETTLED_BY
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
SETTLEMENT_DEFAULT_CATEGORY	Settlement default category. Foreign key to XTR_SETTLEMENT_CATEGORIES.
TAX_CATEGORY	Tax category idnetifier. Foreign key to XTR_TAX_CATEGORIES.
TAX_REFERENCE
TRANSACTION_NUMBER
UPDATED_BY	Last updated user.
AUDIT_INDICATOR
UPDATED_ON	Last updated date.
CREATED_BY
CREATED_ON
BROKERAGE_CATEGORY	Brokerage category identifier. Foreign key to XTR_BROKERAGE_CATEGORIES.
BROKERAGE_REFERENCE

Treasury - XTR_DEAL_STATUSES	Deal status information
Column Name	Descritpion
STATUS_CODE	Code for the execution status of deals and transactions
USER_STATUS_CODE	User-defined deal status code
AUTO_USER_SET	Flag to indicate the status is set automatically (A) or manully by user (U)
UPDATEABLE	Flag to indicate whether the status is updateable (Y), or not (N)
SEEDED_DESCRIPTION	Pre-defined status description
UPDATED_BY	User who last updated this record
DEAL_TYPE	Code for high level deals
DESCRIPTION	Status description

Treasury - XTR_CURRENCY_CROSS_RATES	Created from Entity XTR CURRENCY CROSS RATE by ORACLE on 06-MAY-93
Column Name	Descritpion
CURRENCY_SECOND
OFFER_RATE
RATE_DATE
ARCHIVE_BY	User who archived this record.
ARCHIVE_DATE	Date on which this record is archived.
BID_RATE
CURRENCY_FIRST

Treasury - XTR_A_EXPOSURE_TYPES	Created from Entity XTR EXPOSURE TYPE by ORACLE on 06-MAY-93
Column Name	Descritpion
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
EXPOSURE_TYPE
FREQUENCY
CODE_COMBINATION_ID
LAST_DOWNLOAD_DATE
AUDIT_DATE_STORED	Date on which this record is audited.
NAME
TAX_BROKERAGE_TYPE
TAX_OR_BROKERAGE
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
CREATED_BY
AUDIT_INDICATOR
CREATED_ON
BALANCE_SHEET_EXPOSURE

Treasury - XTR_DEALER_LIMITS	Dealer limits information including limit amounts
Column Name	Descritpion
DEALER_CODE	Code for Treasury users
DEAL_TYPE	Code for high level deals
LIMIT_AMOUNT	Not currently used
PRODUCT_TYPE	Code for products used in a deal type
SINGLE_DEAL_LIMIT_AMOUNT	Maximum amount a dealer is allowed for each deal for a deal type, product type combination
AUDIT_INDICATOR	Not currently used
UPDATED_ON	Date this record was last updated
UTILISED_AMOUNT	Total amount that deal transactions have applied to the limit
UPDATED_BY	User who last updated this record
AUTHORISED	Flag to indicatethat indicates if the limit is authorized (Y), or not (N)
CREATED_BY	User who created this record
CREATED_ON	Date this record was created

Treasury - XTR_CONFIRMATION_ACTIONS	Deal confirmation action information required for a deal type
Column Name	Descritpion
GROUP_DESC	Confirmation action group description
ACTION_TYPE	Deal action type
CONFO_ACTION_GROUP	Confirmation action group
CONFO_REQD	Flag to indicate if confirmation is required for the deal action (Y), or not (N)
DEAL_TYPE	Code for high lev

Treasury - XTR_A_TAX_BROKERAGE_SETUP	Created on 27-JAN-95
Column Name	Descritpion
DESCRIPTION
NOMINAL_ANNUAL_TAX_BREAK
PAYEE
RATE_GROUP
REFERENCE_CODE
AUDIT_DATE_STORED	Date on which this record is audited.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
DEAL_TYPE
AUTHORISED
CREATED_BY
AUDIT_INDICATOR
CREATED_ON
CALC_TYPE
DEDUCTION_TYPE

Treasury - XTR_A_REVALUATION_DETAILS	Created on 01-FEB-95
Column Name	Descritpion
CONTRACT_CODE
REVALUATION_DETAILS_ID	Unique identifier for the table
SWAP_REF	A reference for swaps
COMPLETE_FLAG	Indicates if the deal contains components or cash flows that are not priced but necessary. For the first phase, a completion means that fair value is not null. Y=Complete. N=Incomplete.
OVERWRITE_TYPE	Indicates the form of the overwrite value
OVERWRITE_VALUE	Specifies the overwrite value amount. Depending on the OVERWRITE_TYPE set, this field can mean interest rate, FX rate, fair value or the price of a deal.
CROSS_REF_TO_POSTING
OVERWRITE_REASON	Reason for overwrite
FAIR_VALUE	The calculated fair value of the deal in the revaluation currency
CURRENCYA
REALIZED_FLAG	Specifies if the amount recorded in this record is realized or unrealized. Y=Realized. N=Unrealized.
ACCOUNT_NO	Stores the CA Account Number
CURRENCYB
CUMM_GAIN_LOSS_AMOUNT	The cumulative unrealized gain/loss amount of the deal, in the revaluation currency.
CURR_GAIN_LOSS_AMOUNT	The gain/loss amount of the cash flow due to change in currency exchange rates.
SOB_FV_GAIN_LOSS_AMOUNT	The fair value gain/loss amount in Set of Books currency
SOB_FAIR_VALUE_AMOUNT	The fair value of the deal/transaction in the Set of Books currency
CURRENCY_INDICATOR
REVAL_CURR_FV_AMOUNT	The original calculated fair value of the deal/transaction in the revaluation currency, as calculated by the concurrent process before any overwriting. Internal use column
CTR_CURR_SOB_CURR_FWD_RATE	This is the contra currency to set of books currency forward rate
EXCHANGE_RATE_ONE	This exchange rate is mandatory for all single and double currency deal types. If no rates are found, the default value will be 0
EXCHANGE_RATE_TWO	This exchange rate is used for double currency deal types
DEAL_NO	Deal identifier. Foreign key to XTR_DEALS.
NI_DISC_AMOUNT	Stores the previous batch's NI discount amount
AMOUNT_TYPE	Amount type
ACTION_CODE
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
EFFECTIVE_DATE
EFFECTIVE_DAYS
ENTERED_BY
ENTERED_ON
FACE_VALUE
FXO_SELL_REF_AMOUNT
FX_REVAL_PRINCIPAL_BAL
PERIOD_FROM
AUDIT_DATE_STORED	Date on which this record is audited.
PERIOD_TO
PORTFOLIO_CODE
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
RATE_ERROR
REALISED_PL
REVAL_CCY
REVAL_HCE_AMOUNT
REVAL_RATE
REVAL_VALUE
TRANSACTION_NO
AUDIT_INDICATOR
TRANSACTION_PERIOD
TRANSACTION_RATE
UNIQUE_REF_NUM
UNREALISED_PL
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
YEAR_BASIS
CREATED_BY
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CREATED_ON
AUTHORIZE_JOURNAL_CREATION
JOURNAL_CREATED
BATCH_ID	Identifier that groups events into one process flow

Treasury - XTR_A_EXPOSURE_TRANSACTIONS	Created from Entity XTR EXPOSURE TRANSACTION by ORACLE on 06-MAY-93
Column Name	Descritpion
AMOUNT_TYPE	Identifies the purpose of the amount. For example, 'PREMIUM', 'FEE', 'SETTLE'. Composite key to XTR_AMOUNT_TYPES.
ARCHIVE_BY	User who archived this record.
ARCHIVE_DATE	Date on which this record is archived.
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR
ACCOUNT_NO	Settlement account number.
AVG_RATE
BALANCE
BENEFICIARY_CODE	Beneficiary identifier. Foreign key to XTR_PARTIES_V.
COMMENTS	Additional note.
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CONTRA_NZD_AMOUNT
COVERED_BY_FX_CONTRACT
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.
CPARTY_REF
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
ACTION_CODE
CURRENCY
DEAL_STATUS
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
ESTIMATE_AMOUNT
ESTIMATE_DATE
EXPOSURE_TYPE
FIS_FOB
INTERMEDIARY_BANK_DETAILS
NZD_AMOUNT
AMOUNT
PAYMENT_AMOUNT
PAYMENT_STATUS
PORTFOLIO_CODE
PROFIT_LOSS
PURCHASING_MODULE
SELECT_ACTION
SELECT_REFERENCE
SETTLE_ACTION_REQD
STATUS_CODE
SUBSIDIARY_REF
AMOUNT_HCE
TAX_BROKERAGE_TYPE
THIRDPARTY_CODE
TRANSACTION_NUMBER
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
VALUE_DATE
WHOLESALE_REFERENCE

Treasury - XTR_A_BOND_ISSUES	Created from Entity XTR BOND ISSUE by ORACLE on 06-MAY-93
Column Name	Descritpion
BOND_ISSUE_CODE
CALC_ROUNDING	Number that specifies how many digits will be carried over during mid-step calculations.
PRICING_MODEL	Specifies the pricing model used by this deal. Derived from the CODE column of the XTR_PRICE_MODELS table. All deals will have a pricing model.
MARKET_DATA_SET	Specifies the market data set used by the pricing model
MARGIN	Specifies the margin for revaluation. This column is relevant for Bonds, Bond Options, Discounted Securities and Wholesale Term Money.
BOND_OR_DEBENTURE_ISSUE
ATTRIBUTE_CATEGORY	For Descriptive Flexfield
ATTRIBUTE1	Descriptive Flexfield
ATTRIBUTE2	Descriptive Flexfield
ATTRIBUTE3	Descriptive Flexfield
CALC_TYPE
ATTRIBUTE4	Descriptive Flexfield
ATTRIBUTE5	Descriptive Flexfield
ATTRIBUTE6	Descriptive Flexfield
ATTRIBUTE7	Descriptive Flexfield
COUPON_RATE
ATTRIBUTE8	Descriptive Flexfield
ATTRIBUTE9	Descriptive Flexfield
ATTRIBUTE10	Descriptive Flexfield
ATTRIBUTE11	Descriptive Flexfield
COUPON_TYPE
ATTRIBUTE12	Descriptive Flexfield
ATTRIBUTE13	Descriptive Flexfield
ATTRIBUTE14	Descriptive Flexfield
ATTRIBUTE15	Descriptive Flexfield
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CURRENCY
DESCRIPTION
FIRST_COUPON_DATE
ISSUER
MATURITY_DATE
NO_OF_COUPONS_PER_YEAR
RIC_CODE
RISK_GROUP
AUDIT_DATE_STORED	Date on which this record is audited.
UPDATED_BY
UPDATED_ON
YEAR_BASIS
YEAR_CALC_TYPE
ACCRUED_INT_YEAR_CALC_BASIS
FORCE_MONTH_END_COUPONS
AUDIT_INDICATOR
COMMENCE_DATE
LAST_COUPON_DATE
SETTLEMENT_BASIS
SECURITY_ID
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
PRICE_ROUNDING
YIELD_ROUNDING
PRICE_ROUND_TYPE	Flag to indicate whether price information should be rounded(R) or truncated(T) to the specified number of digits.
YIELD_ROUND_TYPE	Flag to indicate whether yield information should be rounded(R) or truncated(T) to the specified number of digits.

Treasury - XTR_COST_OF_FUNDS	Daily summarized amount and average rate information of Treasury deals
Column Name	Descritpion
COMPANY_CODE	Company code
CONTRA_CCY	Contra currency in a foreign exchange currency quote
CREATED_ON	Date this record was created
CURRENCY	Currency code
CURRENCY_COMBINATION	Currency quotations which combine a base and a contra currency
ACCOUNT_NO	Alpha-numeric reference to financial accounts of Treasury parties
DEAL_SUBTYPE	Code for deal executions permissible within a deal type
DEAL_TYPE	Code for high level deals
GROSS_PRINCIPAL	Gross principal amount
HCE_GROSS_PRINCIPAL	Gross principal in reporting currency equivalent
HCE_INTEREST	Interest amount in reporting currency equivalent
INTEREST	Interest amount
NO_OF_DAYS	Not currently used
NO_OF_DEALS	Number of deals
PARTY_CODE	Party code
PORTFOLIO_CODE	Code for grouping deals under a single portfolio
AS_AT_DATE	As of date
PRODUCT_TYPE	Code for products used in a deal type
WEIGHTED_AVG_PRINCIPAL	Gross principal of face value amount times transaction rate
AVG_BASE_RATE	Average base currency exchange rate
BASE_WEIGHTED_AVG_PRINCIPAL	Gross principal of face value amount times base rate
GROSS_BASE_AMOUNT	sum of absolute value of base currency amount
AVG_INTEREST_RATE	Average interest rate
GROSS_CONTRA_TRANS_AMOUNT	sum of absolute value of contra currency amount in terms of transactions rate
GROSS_CONTRA_SPOT_AMOUNT	sum of absolute value of contra currency amount in terms of spot rate
COMMENCE_DATE	Not currently used

Treasury - XTR_BOND_COUPON_DATES	Coupon dates for bond issues
Column Name	Descritpion
RATE	Coupon rate
DUE_DATE	Coupon due date
BOND_ISSUE_CODE	Reference to a bond issue
START_DATE	Coupon start date
RATE_UPDATE_ON	The last date on which coupon rate is updated
COUPON_DATE	Date that a coupon is paid or received
RATE_FIXING_DATE	Rate fixing date

Treasury - XTR_AMOUNT_TYPES	Amount type information
Column Name	Descritpion
DEAL_TYPE	Code for high level deals
SEEDED_DESCRIPTION	Pre-defined amount type description
AMOUNT_NAME	Amount type name
JOURNAL_USE	Flag to indicate whether you can create journal with the amount type (Y), or not (N)
UPDATED_BY	User who last updated this record
AMOUNT_TYPE	Code that identifies the purpose of the amounts for a deal type
USER_AMOUNT_TYPE	User-defined amount type code

Treasury - XTR_A_PORTFOLIOS	Created from Entity XTR PORTFOLIO by ORACLE on 06-MAY-93
Column Name	Descritpion
BROKERAGE_FREQ
CMF_YN
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
DEFAULT_PORTFOLIO
EXTERNAL_DEFAULT_PORTFOLIO
EXTERNAL_PARTY
EXTERNAL_PORTFOLIO
INTEREST_FREQ
LAST_BROKERAGE_SETTLEMENT
LAST_INTEREST_SETTLEMENT
NAME
PHYSICAL_PORTFOLIO_ACCT
PORTFOLIO
UPDATED_BY	Last updated user.
AS_PRINCIPAL
UPDATED_ON	Last updated date.
CREATED_BY
CREATED_ON
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR

Treasury - XTR_A_DEALS	Created from Entity XTR DEAL by ORACLE on 06-MAY-93
Column Name	Descritpion
ACCRUED_INTEREST_PRICE
CUM_COUPON_DATE
CURRENCY
CURRENCY_BUY
CURRENCY_SELL
DEALER_CODE	Dealer identifier. Foreign key to XTR_DEALER_CODES.
DEAL_DATE
DEAL_LINKING_CODE
DEAL_NO	Deal identifier. Foreign key to XTR_DEALS.
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
ACTION_STATUS
DISCOUNT
DRAWER_CODE
DRAWER_NAME
DUAL_AUTHORISATION_BY	User who dual authorised this record.
DUAL_AUTHORISATION_ON	Date on which this record is dual authorised.
ENDORSER_CODE
ENDORSER_NAME
ENTER_INTO_SWAP
EXCHANGE_CODE
EXERCISE	Indicates if the FX Option is exercised. Valid values are: Y (exercised) or N (not exercised).
ARCHIVE_BY	User who archived this record.
EXPIRY_DATE
EXTERNAL_COMMENTS
EXTERNAL_CPARTY_NO
FACE_VALUE_AMOUNT
FACE_VALUE_HCE_AMOUNT
FIRST_REVAL
FIXED_OR_FLOATING_RATE
FIXED_TERM_MY
FORWARD_HCE_AMOUNT
ARCHIVE_DATE	Date on which this record is archived.
FRA_DESCRIPTION
FREQUENCY
FXD_DEAL_NO
FXO_DEAL_NO
FX_COVER_CROSS_REF
FX_PD_DEAL_NO
FX_REVALUED_ON_DATE
FX_RO_DEAL_NO
FX_SUBSIDIARY_BALANCE_AMOUNT
FX_WHOLESALE_REF
AUDIT_DATE_STORED	Date on which this record is audited.
INSERT_FOR_CASHFLOW
INTEREST_AMOUNT
INTEREST_CUTOFF
INTEREST_HCE_AMOUNT
INTEREST_RATE
INTERNAL_TICKET_NO
INT_SWAP_REF
KNOCK_EXECUTED_BY	User who executed the knock option.
KNOCK_EXECUTED_ON	Date on which knock option is executed.
KNOCK_INSERT_TYPE	Knock In type. Valid values are: D (Diary Notes) or N (Normal Expiry Notes). ???
ACCEPTOR_CODE	Acceptor identifier. The counterparty or company accepting the deal. Foreign key to XTR_PARTIES_V. ???
AUDIT_INDICATOR
KNOCK_LEVEL	Knock rate.
KNOCK_TYPE	Knock option. Valid values are: I (Knock In) or O (Knock Out).
LIMIT_AMOUNT
LIMIT_CODE	Limit code identifier. Composite key to XTR_COMPANY_LIMITS.
MARGIN
MATURITY_ACCOUNT_NO
MATURITY_AMOUNT
MATURITY_BALANCE_AMOUNT
MATURITY_BALANCE_HCE_AMOUNT
MATURITY_DATE
ATTACHMENT_EXISTS	Indicates if any document is attached to this record. Valid values are: Y (document attached) or N (no document attached).
MATURITY_HCE_AMOUNT
NEXT_COUPON_DATE
NI_DEAL_NO
NI_PROFIT_LOSS
NO_OF_DAYS
OPTION_AMOUNT
OPTION_COMMENCEMENT
OPTION_HCE_AMOUNT
OPTION_POINTS
OPTION_TYPE
BASE_DATE
PAYMENT_FREQ
PAYMENT_SCHEDULE_CODE
PI_AMOUNT_DUE
PORTFOLIO_AMOUNT
PORTFOLIO_CODE
PREMIUM_ACCOUNT_NO
PREMIUM_ACTION
PREMIUM_AMOUNT
PREMIUM_AMOUNT_TYPE
PREMIUM_CURRENCY
BASE_RATE
PREMIUM_DATE
PREMIUM_HCE_AMOUNT
PREMIUM_NO_OF_DAYS
PRINCIPAL_SETTLED_BY
PRINTED_CPARTY_ADVICE
PRINTED_YN
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
QUICK_INPUT
RATE_BASIS
REF_CCY
BKGE_SETTLED_REFERENCE
RENEG_DATE
RISKPARTY_CODE
RISKPARTY_LIMIT_CODE
SECURITY_NAME
SELL_ACCOUNT_NO
SELL_AMOUNT
SELL_HCE_AMOUNT
SETTLE_ACCOUNT_NO
SETTLE_ACTION
BOND_ISSUE
SETTLE_AMOUNT
SETTLE_AMOUNT_TYPE
SETTLE_DATE
SETTLE_DUAL_AUTHORISATION_BY
SETTLE_DUAL_AUTHORISATION_ON
SETTLE_HCE_AMOUNT
SETTLE_NO_OF_DAYS
SETTLE_RATE
SPOT_RATE_ON_VALUATION
START_ACCOUNT_NO
BOND_PROFIT_LOSS
START_AMOUNT
START_DATE
START_HCE_AMOUNT
STATUS_CODE	Deal status. For example, 'CURRENT', 'EXERCISED', 'EXPIRIED'.
SWAP_DEPO_ADJUSTMENT
SWAP_DEPO_FLAG
SWAP_DEPO_INT_RATE
SWAP_DEPO_TOTAL_RECEIPT
SWAP_REF
SYNTHETIC_PRINTED_YN
BOND_RENEG_DATE
TAX_AMOUNT
TAX_AMOUNT_HCE
TAX_CODE
TAX_RATE
TAX_SETTLED_REFERENCE
TERM_MY
TOTAL_PRICE
TRANSACTION_CROSS_REF
TRANSACTION_NO
TRANSACTION_RATE
BOND_RESALE_DATE
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
VALUE_DATE
YEAR_BASIS
YEAR_CALC_TYPE
YIELD_AMOUNT
YIELD_HCE_AMOUNT
RATE_FIXING_DATE
BOND_SALE_DATE
SECURITY_ID
EXERCISE_PRICE
PRICING_MODEL	Specifies the pricing model used by this deal. Derived from the CODE column of the XTR_PRICE_MODELS table. All deals will have a pricing model.
MARKET_DATA_SET	Specifies the market data set used by the pricing model.
ACCEPTOR_NAME	Name of the acceptor of the deal. The counterparty or company accepting the deal. ???
BROKER
INITIAL_FAIR_VALUE	Stores the calculated initial fair value
EXCHANGE_RATE_ONE	This exchange rate is mandatory for all single and double currency deal types.
EXCHANGE_RATE_TWO	This exchange rate is used for double currency deal types.
FIRST_REVAL_BATCH_ID	Denotes the number of the first revaluation batch that this rollover transaction belongs to.
BROKERAGE_AMOUNT
LAST_REVAL_BATCH_ID	The batch id in which the realized gain/loss of the deal/transaction was calculated.
ATTRIBUTE_CATEGORY	For Descriptive Flexfield
ATTRIBUTE1	Descriptive Flexfield
ATTRIBUTE2	Descriptive Flexfield
BROKERAGE_AMOUNT_HCE
ATTRIBUTE3	Descriptive Flexfield
ATTRIBUTE4	Descriptive Flexfield
ATTRIBUTE5	Descriptive Flexfield
ATTRIBUTE6	Descriptive Flexfield
BROKERAGE_CODE
ATTRIBUTE7	Descriptive Flexfield
ATTRIBUTE8	Descriptive Flexfield
ATTRIBUTE9	Descriptive Flexfield
ATTRIBUTE10	Descriptive Flexfield
BROKERAGE_CURRENCY
ATTRIBUTE11	Descriptive Flexfield
ATTRIBUTE12	Descriptive Flexfield
ATTRIBUTE13	Descriptive Flexfield
ATTRIBUTE14	Descriptive Flexfield
BROKERAGE_RATE
ATTRIBUTE15	Descriptive Flexfield
PROFIT_LOSS	Realized gain/loss of the original FX deal,if the deal is rolledover or predelivered
FX_RO_PD_RATE	The transaction rate of the rolledover/predelivered deal
FX_M1_DEAL_NO	The deal number of the new rollover/predelivery deal for multiple deals that are rolled/predelivered into a single deal.
BUY_ACCOUNT_NO
PREPAID_INTEREST	Identify whether it is a prepaid interest deal
DAY_COUNT_TYPE	Method used to calculate number of days for calculating interest.
SETTLE_DAY_COUNT_TYPE	Method used to calculate number of days for calculating interest.
ROUNDING_TYPE	Method used to round the calculated interest.
BUY_AMOUNT	Buy amount.
SETTLE_ROUNDING_TYPE	Method used to round the calculated interest.
BUY_HCE_AMOUNT	Buy amount in home currency.
CALC_BASIS
ACCRUAL_FROM	Start date of accrual.
CAPITAL_PRICE
CAP_OR_FLOOR
CLIENT_ADVICE	Indicates if confirmation advice letter is required for the client. Valid values are: Y (requried) or N (not requried).
CLIENT_CODE	Client identifier. Foreign key to XTR_PARTIES_V.
CLIENT_REF
COMMENCE_DATE
COMMENTS	Additional note for knock in option.
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CONTRACT_COMMISSION
CONTRACT_FEES
ACCRUAL_TO	End date of accrual.
CONTRACT_NOS
CONTRACT_RATE
COUPON_ACTION
COUPON_RATE
CPARTY_ADVICE
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.
CPARTY_REF
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CTY_CCY

Treasury - XTR_DEDUCTION_CALCS	Pre-defined deduction calculation methods for setting up tax and brokerage schedules
Column Name	Descritpion
DEAL_TYPE	Code for high level deals
AMOUNT_TYPE	Code that identifies the purpose of the amounts for a deal type
CALC_BASIS	Basis on which the deduction is calculated
CALC_TYPE	Calculation type
DESCRIPTION	Deduction calculation description

Treasury - XTR_DEAL_LINKING
Column Name	Descritpion
DEAL_LINKING_CODE
DESCRIPTION

Treasury - XTR_A_ROLLOVER_TRANSACTIONS	Created from Entity XTR DEAL TRANSACTION by ORACLE on 06-MAY-93
Column Name	Descritpion
ACCUM_INTEREST	Accumulated interest. ???
ENDORSER_CODE
ENDORSER_NAME
EXPECTED_BALANCE_BF
EXPECTED_BALANCE_OUT
EXTERNAL_COMMENTS
EXTERNAL_CPARTY_NO
FID_TAX
FID_TAX_HCE
INTEREST
ACCUM_INTEREST_BF	Accumulated interest brought forward. ???
INTEREST_FREQ
INTEREST_HCE
INTEREST_RATE
INTEREST_SETTLED
INTEREST_SETTLEMENT_TYPE
INTERNAL_TICKET_NO
ISSUER_ADVICE
LIMIT_CODE	Limit code identifier. Composite key to XTR_COMPANY_LIMITS.
MATURITY_DATE
NI_PROFIT_LOSS
ACCUM_INTEREST_BF_HCE	Accumulated interest brought forward in home currency. ???
NI_PROFIT_LOSS_HCE
NI_RENEG_DATE
NO_OF_DAYS
OLD_PRODUCT_TYPE
PARCEL_SPLIT_NO
PARENT_PARTY
PI_AMOUNT_DUE
PI_AMOUNT_RECEIVED
PORTFOLIO_CODE
ACCUM_INTEREST_HCE	Accumulated interest in home currency. ???
PRINCIPAL_ACCOUNT_NO
PRINCIPAL_ACTION
PRINCIPAL_ADJUST_HCE
PRINCIPAL_AMOUNT_TYPE
PRINTED_CPARTY_ADVICE
PRINTED_REDEMPTION_YN
PRINTED_YN
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
QUICK_INPUT
ACCUM_INT_ACCOUNT_NO	Settlement account number for accumulated interest. ???
RATE_EFFECTIVE_CREATED
RENEG_ONLY_LETTER
REPAY_AMOUNT
REPAY_AMOUNT_HCE
SECURITY_TYPE
SETTLEMENT_TYPE
SETTLE_DATE
SETTLE_TERM_INTEREST
START_DATE
STATUS_CODE	Deal status. For example, 'CURRENT', 'EXERCISED', 'EXPIRIED'.
ACCEPTOR_CODE	Acceptor identifier. The counterparty or company accepting the deal. Foreign key to XTR_PARTIES_V. ???
ACCUM_INT_ACTION
TAX_AMOUNT
TAX_AMOUNT_HCE
TAX_CODE
TAX_RATE
TAX_SETTLED_REFERENCE
TRANSACTION_NUMBER	Rollover transaction identifier. Composite key to XTR_ROLLOVER_TRANSACTIONS.
TRANS_CLOSEOUT_NO
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
YEAR_BASIS
YEAR_CALC_TYPE
ACCUM_INT_AMOUNT_TYPE
ACTION_STATUS
ADJUSTED_BALANCE
PRINCIPAL_ADJUST
RATE_FIXING_DATE
ARCHIVE_BY	User who archived this record.
ARCHIVE_DATE	Date on which this record is archived.
ATTACHMENT_EXISTS	Indicates if any document is attached to this record. Valid values are: Y (document attached) or N (no document attached).
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR
BALANCE_OUT
ACCEPTOR_NAME	Name of the acceptor of the deal. The counterparty or company accepting the deal. ???
BALANCE_OUT_BF
BALANCE_OUT_BF_HCE
BALANCE_OUT_HCE
BAL_OS_ACCOUNT_NO
BKGE_SETTLED_REFERENCE
BROKERAGE_AMOUNT
BROKERAGE_AMOUNT_HCE
BROKERAGE_CODE
BROKERAGE_RATE
CLIENT_ADVICE	Indicates if confirmation advice letter is required for the client. Valid values are: Y (requried) or N (not requried).
ACCRUAL_FROM	Start date of accrual.
CLIENT_CODE	Client identifier. Foreign key to XTR_PARTIES_V.
COMMENTS	Additional note.
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CPARTY_ADVICE
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CROSS_REF_TO_TRANS
CURRENCY
DATE_RECEIVED
ACCRUAL_TO	End date of accrual.
DEALER_CODE	Dealer identifier. Foreign key to XTR_DEALER_CODES.
DEAL_DATE
DEAL_LINKING_CODE
DEAL_NUMBER	Deal identifier. Foreign key to XTR_DEALS.
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
DRAWER_CODE
DRAWER_NAME
DUAL_AUTHORISATION_BY	User who dual authorised this record.
DUAL_AUTHORISATION_ON	Date on which this record is dual authorised.

Treasury - XTR_A_MASTER_CURRENCIES	Created from Entity XTR MASTER CURRENCY by ORACLE on 06-MAY-93
Column Name	Descritpion
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CURRENCY
CURRENT_SPOT_RATE
DIVIDE_OR_MULTIPLY
AUDIT_DATE_STORED	Date on which this record is audited.
FX_SEQ_NO
HCE_RATE	Home currency rate.
IR_SEQ_NO
LAST_TRANSACTION_CHANGED
MAXIMUM_BAND
MAX_DAYS_CONTRACT
MINIMUM_BAND
NAME
NET_FX_EXPOSURE	Total exposure amount allowed for this currency.
RATE_DATE
AUDIT_INDICATOR
ROUNDING_FACTOR
SPOT_DATE
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
USD_BASE_CURR_BID_RATE
USD_BASE_CURR_OFFER_RATE
USD_QUOTED_SPOT
UTILISED_AMOUNT	Utilised amount calculated using limit weighting.
YEAR_BASIS
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
IG_YEAR_BASIS
CALCULATE_HOLS_YEARS

Treasury - XTR_A_BUY_SELL_COMBINATIONS	Created from Entity XTR BUY SELL COMBINATION by ORACLE on 27-MAY-93
Column Name	Descritpion
CURRENCY_FIRST
CURRENCY_SECOND
CURRENCY_SELL
LATEST_CROSS_DATE
LATEST_CROSS_RATE
AUDIT_DATE_STORED	Date on which this record is audited.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
CREATED_BY
CREATED_ON
AUDIT_INDICATOR
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
CURRENCY_BUY

Treasury - XTR_A_BANK_BALANCES	Created by ORACLE on 17-DEC-93
Column Name	Descritpion
AUDIT_INDICATOR
BALANCE_ADJUSTMENT
BALANCE_CFLOW	Cashflow balance.
BALANCE_DATE
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
ACCOUNT_NUMBER	Settlement account number.
INTEREST
INTEREST_RATE
INTEREST_SETTLED
INTEREST_SETTLED_HCE
NO_OF_DAYS
SETOFF
STATEMENT_BALANCE
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
ACCUM_INT_BFWD	Accumulated interest brought forward. ???
LIMIT_CODE
CREATED_BY
CREATED_ON
ACCRUAL_INTEREST	Running accumulated interest
ACCUM_INT_CFWD	Accumulated interest carried forward. ???
AUDIT_DATE_STORED	Date on which this record is audited.

Treasury - XTR_DATE_TYPES	Date types information
Column Name	Descritpion
DEAL_TYPE	Code for high level deals
SEEDED_DESCRIPTION	Pre-defined date type description
DATE_NAME	User-defined date type description
JOURNAL_USE	Flag to indicate if the date type can be used to define journal structures (pre-defined as Y or N)
UPDATED_BY	User who last updated this record
DATE_TYPE	Date type tied to specific deal types (for example, accrual, maturity, start, and dealt date)
USER_DATE_TYPE	User-defined date type code

Treasury - XTR_AMOUNT_ACTIONS	Amount action information
Column Name	Descritpion
DEAL_TYPE	Code for high level deals
DESCRIPTION	User-defined amount action description
SEEDED_DESCRIPTION	Pre-defined amount action description
ACTION_CODE	Code for actions involved in executing deals
UPDATED_BY	User who last updated this record
USER_ACTION_CODE	User-defined action code
AMOUNT_TYPE	Code that identifies the purpose of the amounts for a deal type

Treasury - XTR_A_TAX_CATEGORIES	Created on 27-JAN-95
Column Name	Descritpion
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR
DESCRIPTION
TAX_CATEGORY	Tax category idnetifier. Unique key to this table.

Treasury - XTR_A_STANDING_INSTRUCTIONS	Created on 27-JAN-95
Column Name	Descritpion
BANK_CODE	Bank identifier.
CPARTY_REF
CURRENCY
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
ACCOUNT_NO	Settlement account number.
PARTY_CODE
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
UNIQUE_REF_NUM
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
CREATED_BY
CREATED_ON
AMOUNT_TYPE	Identifies the purpose of the amount. For example, 'PREMIUM', 'FEE', 'SETTLE'. Composite key to XTR_AMOUNT_TYPES.
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR

Treasury - XTR_DEAL_ORDERS	Created from Entity XTR DEALS by ORACLE on 28-NOV-94
Column Name	Descritpion
CCY_B_AMOUNT
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CONFIRMED_BY_DEALER
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.
CREATED_BY	User who created this record.
ABOVE_OR_BELOW_LEVEL	Indicates if Order Rate is above or below the Current Market Rate. The Order Rate cannot be equal to Current Market Rate. Valid values are: ABOVE, BELOW.
CREATED_ON	Date on which this record is created.
CROSS_REF
DEALER_COMPANY
DEALER_CPARTY
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
DETAILS_OF_ORDER
GROUP_ACTION
MARKET_RATE_WHEN_ENTERED	Current Market Rate for this deal type, deal subtype and product type combination.
ORDER_CCY_A
ADVICE_GROUP
ORDER_CCY_B
ORDER_DELIVERY_DATE
ORDER_GROUP
ORDER_RATE	Order Rate for this deal type, deal subtype and product type combination.
ORDER_TYPE
PLACED_ON
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
RIC_CODE
SOURCE
STATUS_CODE
AUDIT_INDICATOR
UNIQUE_REF_NUM	Deal order identifier from generated sequence XTR_NETOFF_NOS_S. Unique identitier to this table.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
VALID_UNTIL
CCY_A_AMOUNT

Treasury - XTR_DEAL_CONFO_TYPES	Deal confirmation types used in confirmation letter templates
Column Name	Descritpion
CONFO_TYPE	Deal confirmation action type
DEAL_TYPE	Code for high level deals
DESCRIPTION	Deal action description

Treasury - XTR_CUM_DIST_CALCS	Created on 03-DEC-93
Column Name	Descritpion
MKT_EXP
PROBABILITY
DEVIATION
EXPT
INT_DAYS
LAN

Treasury - XTR_CONFIRMATION_DETAILS	Confirmation letter details
Column Name	Descritpion
COMPANY_CODE	Company code
CONFIRMATION_VALIDATED_BY	User who validated the confirmation
CONFIRMATION_VALIDATED_ON	Date the confirmation is validated
CONFO_PARTY_CODE	Confirmation party code
CONFO_VALIDATION_BOTH	Flag to indicates if an action requires just validation (V) or both validation and a confirmation letter (B)
ACTION_TYPE	Deal confirmation action type
CPARTY_CODE	Counterparty code
CURRENCY	Currency code
DATE_ACTION_INITIATED	Date the action was initiated
DEAL_NO	Unique number assigned to each deal
DEAL_SUBTYPE	Code for deal executions permissible within a deal type
DEAL_TYPE	Code for high level deals
DEAL_UPDATED_YN	Flag to indicate if deal is updated (Y), or not (N)
FILE_NAME	Not currently used
INITIALLY_PRINTED_ON	Date the confirmation letter is first printed
PARTY_CONFO_CHECKED	Flag to indicate if party confirmation is checked (Y) or not (N)
AMOUNT	Transaction amount
PARTY_CONFO_CHECKED_BY	User who checked the party confirmation
PARTY_CONFO_CHECKED_ON	Date the party confirmation was checked
PARTY_CONFO_FILE_NAME	Not currently used
REPRINTED_ON	Date the confirmation letter is reprinted
REPRINT_REQUESTED_BY	User who requested the reprint of a confirmation letter
SETTLE_DATE	Settle date
STATUS_CODE	Status code
TRANSACTION_NO	Unique reference number assigned to a transaction
AMOUNT_TYPE	Code that identifies the purpose of the amounts for a deal type
CLIENT_CODE	Client for which the deal is made

Treasury - XTR_AUDIT_COLUMNS	Created by ORACLE on 27-MAY-96
Column Name	Descritpion
P_KEY_YN
TABLE_COLUMN
COLUMN_TITLE
AUDIT_YN	Indicates if this column is to be audited Valid values are: Y (to audit) or N (not to audit).
COLUMN_TYPE
EVENT

Treasury - XTR_ACCOUNT_DEBIT_AUTHS	Created by ORACLE on 14-FEB-97
Column Name	Descritpion
BANK_ACCT_USE_ID
COMPANY_ACCOUNT_NO
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.

Treasury - XTR_A_GL_REFERENCES	Created from Entity XTR GL REFERENCE by ORACLE on 06-MAY-93
Column Name	Descritpion
CODE_COMBINATION_ID
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
AUDIT_DATE_STORED	Date on which this record is audited.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
AUDIT_INDICATOR
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.

Treasury - XTR_DEAL_DATE_AMOUNTS	Deal transaction information grouped by date type, amount type, and amount action
Column Name	Descritpion
ACTION_COMPLETED	Not currently used
JOURNAL_CREATED	No longer used.
LIMIT_CODE	Code for user-defined limits imposed on deals and transactions
LIMIT_PARTY	Party against which limits are checked
MULTIPLE_REFERENCE_NUMBER	Original settlement number which indicates where this split settlement comes from
MULTIPLE_SETTLEMENTS	Flag to indicate if the settlement is split into more than one company or one bank account (Y), or not (N)
NETOFF_GROUP_FLAG	Flag to indicate the method of settlement groupings (Netoff (N), Sum (S), None (O), and Not Set (T))
NETOFF_NUMBER	Unique reference number assigned to a netting group
PORTFOLIO_CODE	Code for grouping deals under a single portfolio
PRINTED_MATURITY_YN	Not currently used
PRODUCT_TYPE	Code for products used in a deal type
ACTUAL_SETTLEMENT_DATE	Settlement date
QUICK_INPUT	Flag to indicate if the deal is generaged from a quick input deal (Y), or not (N)
RECONCILED_DAYS_ADJUST	Days adjusted for bank statement reconciliation
RECONCILED_PASS_CODE	Set of selection criteria used for reconciliation
RECONCILED_REFERENCE	Reference number to the statement line against which this transaction is reconciled
SERIAL_REFERENCE	Internal reference
SETTLE	Flag to indicate if the settlement has been authorized (Y), or not (N)
SETTLEMENT_ACTIONED	Flag to indicate if the settlement has been processed (Y), or not (N)
SETTLEMENT_ACTIONED_FILE	Not currently used
SETTLEMENT_AUTHORISED_BY	Treasury user who authorized the settlement
SETTLEMENT_NUMBER	Unique reference number assigned to a settlement
AMOUNT	Transaction amount
SETTLEMENT_PARTY	Not currently used
STATUS_CODE	Code for the execution status of deals and transactions
TRANSACTION_DATE	Date the transaction is made
TRANSACTION_NUMBER	Unique reference number assigned to a transaction
TRANSACTION_RATE	Transaction rate
TRANS_MTS	Flag to indicate if user has selected EFT (Electronic Funds Transfer) as method of payment for settlement (Y), or not (N)
UPDATED_BY	User who last updated this record
UPDATED_ON	Date this record was last updated
ORIGINAL_SETTLEMENT_CURRENCY	Not currently used
AMOUNT_DATE	Date the deal finishes and is paid off, or date the principal amount of a note, draft, acceptance, bond, short term or other debt instrument becomes due and payable.
ORIGINAL_SETTLEMENT_AMOUNT	Not currently used
COMPANY_HCE_AMOUNT	Not currently used
CREATED_BY	User who created this record
CREATED_ON	Date this record was created
AMOUNT_TYPE	Code that identifies the purpose of the amounts for a deal type
BATCH_ID	Identifier that groups events into one process flow.
DEAL_DATE_AMOUNT_ID	Unique reference number assigned to each deal date amount.
COMPANY_ACCT_USE_ID	Settlement account ID
CPARTY_ACCT_USE_ID	Counterparty account ID
ACCOUNT_NO	Settlement account number
ARCHIVE_BY	Not currently used
BENEFECIARY_ACCT_USE_ID	Settlement beneficiary party account ID
ARCHIVE_DATE	Not currently used
ATTACHMENT_EXISTS	Not currently used
AUDIT_INDICATOR	Not currently used
AUTHORISED	Not currently used
BALANCE_SHEET_EXPOSURE	Flag indicates if the exposure type is in balance sheet (Y), or not (N)
BENEFICIARY_ACCOUNT_NO	Settlement beneficiary party account number
BENEFICIARY_PARTY	Settlement beneficiary party
CASHFLOW_AMOUNT	Cash flow amount
CHQ_REQD	Flag to indicate if user selects check as method of payment for settlement (Y), or not (N)
ACCRUAL_FROM	Not currently used
CLIENT_BROKER_CLRACCT	Flag to indicate if the client has settled with the counteryparty via the company clearing account (Y), or not (N)
CLIENT_CODE	Client for which the deal is made
COMMENCE_DATE	Date the deal can start to be exercised
COMMENTS	Settlement comments
COMPANY_CODE	Company code
CONTRACT_CODE	Not currently used
CPARTY_ACCOUNT_NO	Alpha-numeric reference of counterparty financial account
CPARTY_CODE	Counterparty code
CURRENCY	Currency code
CURRENCY_COMBINATION	Currency quotations which combine a base and a contra currency
ACCRUAL_TO	Not currently used
DATE_TYPE	Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates)
DEALER_CODE	Code for Treasury users
DEAL_NUMBER	Unique number assigned to each deal
DEAL_ORDERS	Not currently used
DEAL_SUBTYPE	Code for deal executions permissible within a deal type
DEAL_TYPE	Code for high level deals
DIARY_CREATED_BY	Not currently used
DIARY_NOTE	Not currently used
DIRECT_DEBIT	Flag to indicate if user selects direct debit as method of payment for settlement (Y), or not (N)
DUAL_AUTHORISATION_BY	Login name of user who created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y
ACTION_CODE	Code for actions involved in executing deals
DUAL_AUTHORISATION_ON	Date on which the user created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y
EXPOSURE_REF_DATE	Not currently used
EXP_SETTLE_REQD	Flag to indicate if Treasury user wants to automatically initiate a payment for the exposure (Y), or not (N)
EXTERNAL_COMMENTS	Not currently used
FIRST_ACCRUAL	Not currently used
FRA_DESCRIPTION	Not currently used
GENERAL_OR_PRIVATE_ACCESS	Not currently used
CODE_COMBINATION_ID	Unique key for identifying GL account references
GOOD_VALUE_CLAIM	Not currently used
HCE_AMOUNT	Amount in reporting currency equivalent

Treasury - XTR_COUNTRY_COMPANY_LIMITS	Sovereign limits information including limit and utilization amounts
Column Name	Descritpion
CREATED_BY	User who created this record
CREATED_ON	Date this record was created
LIMIT_AMOUNT	Maximum amount allowed by the limit
UPDATED_BY	User who last updated this record
UPDATED_ON	Date this record was last updated
UTILISED_AMOUNT	Total amount that deal transactions have applied to the limit
AUDIT_INDICATOR	Not currently used
AUTHORISED	Flag to indicate if the limit is authorized (Y), or not (N)
COMPANY_CODE	Company code
COUNTRY_CODE	Country code

Treasury - XTR_AUDIT_MODULE_ACCESS	Created by ORACLE on 06-MAR-97
Column Name	Descritpion
ACCESSED_BY	User who has access to this module.
ACCESSED_ON	Date on which this module is accessed.
MODULE_NOS

Treasury - XTR_A_TAX_BROKERAGE_RATES	Created by ORACLE on 13-MAR-95
Column Name	Descritpion
FLAT_AMOUNT
INTEREST_RATE
MAX_AMT
MIN_AMT
RATE_GROUP
AUDIT_DATE_STORED	Date on which this record is audited.
REF_TYPE
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
CREATED_BY
CREATED_ON
AUDIT_INDICATOR
CMF_BROKERAGE_RATE
EFFECTIVE_FROM

Treasury - XTR_A_RATE_SETS	Created on 01-FEB-95
Column Name	Descritpion
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
EFFECTIVE_FROM
FIXED_FLOATING
HIGH_RANGE
AUDIT_DATE_STORED	Date on which this record is audited.
INTEREST_PERIOD
LOW_RANGE
MARGIN
NO_OF_DAYS
PI_CONSTANT
POSTED
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
RATE
RATE_EFFECTIVE_CREATED
RESET_BASIS
AUDIT_INDICATOR
TERM
UNIQUE_REF_NUM
UPDATED_BY
UPDATED_ON	Last updated date.
UPDATE_EXISTING_DEALS
CREATED_BY
CREATED_ON
CLIENT_GROUPING	Client group identifier. Foreign key to XTR_PARTY_GROUPS.
CONCURRENT_REQUEST
CURRENCY

Treasury - XTR_A_COMPANY_LIMITS	Created from Entity XTR COMPANY LIMIT by ORACLE on 06-MAY-93
Column Name	Descritpion
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
LIMIT_AMOUNT	Total amount allowed for this limit.
LIMIT_CODE	Limit code identifier. Unique for this company.
LIMIT_TYPE	Limit type identifier. Foreign key to XTR_LIMIT_TYPES.
AUDIT_DATE_STORED	Date on which this record is audited.
NAME	Name of this limit.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
UTILISED_AMOUNT	Utilised amount calculated using limit weighting.
AUDIT_INDICATOR
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.

Treasury - XTR_BROKERAGE_CATEGORIES	Alpha-numeric reference to financial accounts of Treasury parties.
Column Name	Descritpion
BROKERAGE_CATEGORY	Brokerage category
DESCRIPTION	Brokerage category description

Treasury - XTR_BILL_BOND_ISSUES	Bill and bond issue serial numbers and information about the deals to which they are assigned
Column Name	Descritpion
DUE_DATE	Not currently used
ISSUE_DATE	Not currently used
NI_OR_BOND	Code to indicate if the issue number is for a bill (NI) or bond (BOND)
PARCEL_SPLIT_NO	Not currently used
SERIAL_NUMBER	Serial number used for bond or bill issues
AMOUNT	Transaction amount
STATUS	Code for the execution status of the issue
TRANSACTION_NUMBER	Transaction Number
BANK_ID	Bank ID for the issue number
BANK_CODE	Bank code for the issue number
CURRENCY	Currency code
DEAL_NUMBER	Unique number assigned to each deal

Treasury - XTR_A_JOURNAL_ENTRY_ACTIONS	Created from Entity XTR JOURNAL ENTRY ACTION by ORACLE on 06-MAY-93
Column Name	Descritpion
COMMENTS	Additional note.
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CREDIT_OR_DEBIT
ACTION_CODE
DATE_TYPE	Identifies the purpose of the date. For example, 'DEALT', 'EXPIRY', 'MATURE'. Composite key to XTR_DATE_TYPES.
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
GET_GL_FROM_DEAL
CODE_COMBINATION_ID
GET_PRIN_CCID_FROM_DEAL
PARTY_GL
PORTFOLIO_CODE
GET_INT_CCID_FROM_DEAL
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
UPDATED_BY	Last updated user.
AMOUNT_TYPE	Identifies the purpose of the amount. For example, 'PREMIUM', 'FEE', 'SETTLE'. Composite key to XTR_AMOUNT_TYPES.
UPDATED_ON	Last updated date.
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR

Treasury - XTR_A_DEALER_CODES	Created by ORACLE on 06-MAY-95
Column Name	Descritpion
DEALER_CODE	Dealer identifier. Unique key of this table.
DEALER_USER_NAME
USER_ID
AUDIT_DATE_STORED	Date on which this record is audited.
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
CREATED_BY
AUDIT_INDICATOR
CREATED_ON
ALLOW_OVERRIDE	Not currently used

Treasury - XTR_COUNTERPARTY_LIMITS	Counterparty limits information including limit and utilization amounts
Column Name	Descritpion
COMPANY_CODE	Company code
ATTRIBUTE11	Descriptive flexfield segment column
ATTRIBUTE12	Descriptive flexfield segment column
ATTRIBUTE13	Descriptive flexfield segment column
ATTRIBUTE14	Descriptive flexfield segment column
CPARTY_CODE	Counterparty code
ATTRIBUTE15	Descriptive flexfield segment column
CREATED_BY	User who created this record
CREATED_ON	Date this record was created
CROSS_ALLOCATION_GROUP_CODE	Not currently used
AUDIT_INDICATOR	Not currently used
EXPIRY_DATE	Expiration date for the limit
FREQUENCY	Not currently used
INITIAL_FEE_DATE	Not currently used
LIMIT_AMOUNT	Maximum amount allowed by the limit
LIMIT_CODE	Code for user-defined limits imposed on deals and transactions
LIMIT_TYPE	Limit type code (tied to one of four limit categories)
SEQUENCE_NUMBER	Not currently used
UPDATED_BY	User who last updated this record
UPDATED_ON	Date this record was last updated
UTILISATION_CALC_BASIS	Not currently used
UTILISATION_FEE_PERCENT	Not currently used
AUTHORISED	Flag to indicate if the limit is authorized (Y), or not (N)
UTILISED_AMOUNT	Total amount that deal transactions have applied to the limit
UTILIZATION_STRUCTURE_BASIS	Not currently used
ATTRIBUTE_CATEGORY	Contains descriptive flexfield context value
ATTRIBUTE1	Descriptive flexfield segment column
ATTRIBUTE2	Descriptive flexfield segment column
BENCHMARK_REF	Not currently used
ATTRIBUTE3	Descriptive flexfield segment column
ATTRIBUTE4	Descriptive flexfield segment column
ATTRIBUTE5	Descriptive flexfield segment column
ATTRIBUTE6	Descriptive flexfield segment column
COMMITMENT_FEE_PERCENT	Not currently used
ATTRIBUTE7	Descriptive flexfield segment column
ATTRIBUTE8	Descriptive flexfield segment column
ATTRIBUTE9	Descriptive flexfield segment column
ATTRIBUTE10	Descriptive flexfield segment column

Treasury - XTR_COMPANY_LIMITS	Company limits information including limit and utilization amounts
Column Name	Descritpion
CREATED_ON	Date this record was created
ATTRIBUTE15	Descriptive flexfield segment column
LIMIT_AMOUNT	Maximum amount allowed by the limit
LIMIT_CODE	Code for user-defined limits imposed on deals and transactions
LIMIT_TYPE	Limit type code (tied to one of four limit categories)
NAME	Limit name
AUDIT_INDICATOR	Not currently used
UPDATED_BY	User who last updated this record
UPDATED_ON	Date this record was last updated
UTILISED_AMOUNT	Total amount that deal transactions have applied to the limit
ATTRIBUTE_CATEGORY	Contains descriptive flexfield context value
ATTRIBUTE1	Descriptive flexfield segment column
ATTRIBUTE2	Descriptive flexfield segment column
AUTHORISED	Flag to indicate if the limit is authorized (Y), or not (N)
ATTRIBUTE3	Descriptive flexfield segment column
ATTRIBUTE4	Descriptive flexfield segment column
ATTRIBUTE5	Descriptive flexfield segment column
ATTRIBUTE6	Descriptive flexfield segment column
COMPANY_CODE	Company code
ATTRIBUTE7	Descriptive flexfield segment column
ATTRIBUTE8	Descriptive flexfield segment column
ATTRIBUTE9	Descriptive flexfield segment column
ATTRIBUTE10	Descriptive flexfield segment column
CREATED_BY	User who created this record
ATTRIBUTE11	Descriptive flexfield segment column
ATTRIBUTE12	Descriptive flexfield segment column
ATTRIBUTE13	Descriptive flexfield segment column
ATTRIBUTE14	Descriptive flexfield segment column

Treasury - XTR_COMPANY_AUTHORITIES	User access authorities of companies
Column Name	Descritpion
COMPANY_AUTHORISED_FOR_INPUT	Flag to indicate if the dealer has access to the company (Y), or not (N)
DEALER_CODE	Code for Treasury users
PARTY_CODE	Company code

Treasury - XTR_A_INTERGROUP_TRANSFERS	Created from Entity XTR INTERGROUP FUNDING by ORACLE on 13-JUL-94
Column Name	Descritpion
AUDIT_INDICATOR
BALANCE_BF	Balance brought forward.
BALANCE_BF_HCE	Balance brought forward in home currency.
BALANCE_OUT
BALANCE_OUT_HCE
ACCT_REF
COMMENTS	Additional note.
COMPANY_ACCOUNT_NO
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CURRENCY
DEAL_NUMBER	Deal identifier. Foreign key to XTR_DEALS.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
INTEREST
INTEREST_HCE
ACCUM_INTEREST_BF	Accumulated interest brought forward. ???
INTEREST_RATE
INTEREST_SETTLED
INTEREST_SETTLED_HCE
LIMIT_CODE	Limit code identifier. Composite key to XTR_COMPANY_LIMITS.
NO_OF_DAYS
PARTY_ACCOUNT_NO
PARTY_CODE
PORTFOLIO
PRINCIPAL_ACTION
PRINCIPAL_ADJUST
ACCUM_INTEREST_BF_HCE	Accumulated interest brought forward in home currency. ???
PRINCIPAL_ADJUST_HCE
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
SETTLE_DATE
TRANSACTION_NUMBER
TRANSFER_DATE
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
ACCRUAL_INTEREST	Running accumulated interest
AUDIT_DATE_STORED	Date on which this record is audited.
DAY_COUNT_TYPE
ROUNDING_TYPE

Treasury - XTR_A_DEAL_DATE_AMOUNTS	Created from Entity XTR_DEAL_DATE_AMOUNT by ORACLE on 06-MAY-93
Column Name	Descritpion
ACTION_COMPLETED
JOURNAL_CREATED
LIMIT_CODE	Limit code identifier. Composite key to XTR_COMPANY_LIMITS.
LIMIT_PARTY
MULTIPLE_REFERENCE_NUMBER
MULTIPLE_SETTLEMENTS
NETOFF_GROUP_FLAG
NETOFF_NUMBER
PORTFOLIO_CODE
PRINTED_MATURITY_YN
PRODUCT_TYPE	Deal product type identifier. Composite key to XTR_PRODUCT_TYPES.
ACTUAL_SETTLEMENT_DATE	Date of actual settlement.
QUICK_INPUT
RECONCILED_DAYS_ADJUST
RECONCILED_PASS_CODE
RECONCILED_REFERENCE
SERIAL_REFERENCE
SETTLE
SETTLEMENT_ACTIONED
SETTLEMENT_ACTIONED_FILE
SETTLEMENT_AUTHORISED_BY
SETTLEMENT_NUMBER
AMOUNT
SETTLEMENT_PARTY
STATUS_CODE	Deal status. For example, 'CURRENT', 'EXERCISED', 'EXPIRIED'.
TRANSACTION_DATE
TRANSACTION_NUMBER	Rollover transaction identifier. Composite key to XTR_ROLLOVER_TRANSACTIONS.
TRANSACTION_RATE
TRANS_MTS
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
ORIGINAL_SETTLEMENT_CURRENCY
AMOUNT_DATE
ORIGINAL_SETTLEMENT_AMOUNT
COMPANY_HCE_AMOUNT
CREATED_BY
CREATED_ON
AMOUNT_TYPE	Identifies the purpose of the amount. For example, 'PREMIUM', 'FEE', 'SETTLE'. Composite key to XTR_AMOUNT_TYPES.
ACCOUNT_NO	Settlement account number.
ARCHIVE_BY	User who archived this record.
ARCHIVE_DATE	Date on which this record is archived.
ATTACHMENT_EXISTS	Indicates if any document is attached to this record. Valid values are: Y (document attached) or N (no document attached).
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
BALANCE_SHEET_EXPOSURE
BENEFICIARY_ACCOUNT_NO
BENEFICIARY_PARTY
CASHFLOW_AMOUNT
ACCRUAL_FROM	Start date of accrual.
CHQ_REQD
CLIENT_BROKER_CLRACCT
CLIENT_CODE	Client identifier. Foreign key to XTR_PARTIES_V.
COMMENCE_DATE
COMMENTS	Additional note.
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CONTRACT_CODE
CPARTY_ACCOUNT_NO
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.
CURRENCY
ACCRUAL_TO	End date of accrual.
CURRENCY_COMBINATION
DATE_TYPE	Identifies the purpose of the date. For example, 'DEALT', 'EXPIRY', 'MATURE'. Composite key to XTR_DATE_TYPES.
DEALER_CODE	Dealer identifier. Foreign key to XTR_DEALER_CODES.
DEAL_NUMBER	Deal identifier. Foreign key to XTR_DEALS.
DEAL_ORDERS
DEAL_SUBTYPE	Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES.
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
DIARY_CREATED_BY
DIARY_NOTE
DIRECT_DEBIT
DUAL_AUTHORISATION_BY	User who dual authorised this record.
ACTION_CODE
DUAL_AUTHORISATION_ON	Date on which this record is dual authorised.
EXPOSURE_REF_DATE
EXP_SETTLE_REQD
EXTERNAL_COMMENTS
FIRST_ACCRUAL
FRA_DESCRIPTION
GENERAL_OR_PRIVATE_ACCESS
CODE_COMBINATION_ID
GOOD_VALUE_CLAIM
HCE_AMOUNT	Amount in home currency.

Treasury - XTR_DEAL_SUBTYPES	Deal subtype information
Column Name	Descritpion
DEAL_TYPE	Code for high level deals
LIMIT_WEIGHTING	Percentage of a deal's face value considered as risk
NAME	Deal subtype name
AUTHORISED	Flag to indicate if the deal subtype is authorized for use (Y), or not (N)
PRICE_ROUNDING	Not currently used
TOLERANCE	Tolerence level (as a percentage)
YIELD_ROUNDING	Not currently used
SEEDED_DESCRIPTION	Pre-defined deal subtype description
DEAL_SUBTYPE	Code for deal executions permissible within a deal type
UPDATED_BY	User who last updated this record
USER_DEAL_SUBTYPE	User-defined deal subtype code

Treasury - XTR_BANK_BALANCES	Daily bank balance information
Column Name	Descritpion
BALANCE_ADJUSTMENT	Amount required to adjust the bank statement balance for bank errors (the difference between the interest calculation balance and the statement balance)
BANK_ACCT_USE_ID	ID reference to financial accounts of Treasury parties
CE_BANK_ACCOUNT_BALANCE_ID	Bank Balance Id
BALANCE_CFLOW	Cash flow balance which reflects counterparty errors and bank errors
BALANCE_DATE	Balance date
COMPANY_CODE	Company code
INTEREST	Interest amount
ACCOUNT_NUMBER	Alpha-numeric reference to financial accounts of Treasury parties
INTEREST_RATE	Interest rate at which a deal or transaction is executed
INTEREST_SETTLED	Interest settlement
INTEREST_SETTLED_HCE	Interest settlement in reporting currency equivalent
NO_OF_DAYS	Number of days since the last balance date
SETOFF	Setoff code of the notional account to which the bank account balance belongs
STATEMENT_BALANCE	Statement balance
UPDATED_BY	User who last updated this record
UPDATED_ON	Date this record was last updated
LIMIT_CODE	Code for user-defined limits imposed on deals and transactions
ACCUM_INT_BFWD	Accumulated interest on previous balance date
CREATED_BY	User who created this record
CREATED_ON	Date this record was created
ACCRUAL_INTEREST	Running accumulated interest on current balance date
FIRST_BATCH_ID	First batch id. Identifier that groups events into one process flow.
ACCUM_INT_CFWD	Accumulated interest on current balance date
LAST_BATCH_ID	Last batch id. Identifier that groups events into one process flow.
EXCHANGE_RATE	Exchange rate.
AVERAGE_EXCHANGE_RATE	Average exchange rate.
ROUNDING_TYPE	Not currently used
AUDIT_INDICATOR	Not currently used
DAY_COUNT_TYPE	Not currently used
ORIGINAL_AMOUNT	Not currently used
ONE_DAY_FLOAT	1-day float bank balance
TWO_DAY_FLOAT	2-day float bank balance

Treasury - XTR_AUDIT_SUMMARY	Created from Entity XTR AUDIT_SUMMARY by ORACLE on 06-MAY-95
Column Name	Descritpion
NAME_OF_COLUMN_CHANGED
NEW_VALUE
NON_TRANSACTION_REF
OLD_VALUE
REFERENCE_CODE
AUDIT_RECORDS_FROM
TABLE_NAME
TRANSACTION_REF
UPDATED_BY_USER	Last updated user.
UPDATED_ON_DATE	Last updated date.
ACTION_CODE
AUDIT_REQUEST_ID
AUDIT_RECORDS_TO
AUDIT_REQUESTED_BY
AUDIT_REQUESTED_ON

Treasury - XTR_ACCRLS_AMORT	Accrual amounts for deal transactions
Column Name	Descritpion
TRANS_NO	Unique reference number assigned to a transaction
TRANSFERED_ON	Not currently used
REVERSAL_DATE	Date accrual is reversed
PERIOD_FROM	Start date of accrual period
CREATED_ON	Date this record was created
CREATED_BY	User who created this record
ACCRLS_AMOUNT_BAL	Running balance of the accrual amount for the deal and transaction
EFFECTIVE_CALCULATED_VALUE	Running balance of the discounted amount for the accrual period for the deal and transaction
AUTHORIZE_JOURNAL_CREATION	No longer used.
JOURNAL_CREATED	No longer used.
PERIOD_TO	End date of accrual period
BATCH_ID	Identifier that groups events into one process flow.
CALC_FACE_VALUE	Calc face value
EFFINT_ACCRLS_AMOUNT_BAL	Effint accruals amort balance.
COMPANY_CODE	Company code
DEAL_TYPE	Code for high level deals
DEAL_SUBTYPE	Code for deal executions permissible within a deal type
CPARTY_CODE	Counterparty code
CURRENCY	Currency code
DEAL_NO	Unique number assigned to each deal
PRODUCT_TYPE	Code for products used in a deal type
PORTFOLIO_CODE	Code for grouping deals under a single portfolio
AMOUNT_TYPE	Amount type used in accruals
ACTION_CODE	Code for actions involved in executing deals
TRANSACTION_AMOUNT	Transaction amount used to calculate the accrual amount
ACTUAL_START_DATE	Start date used in accrual calculations
ACTUAL_MATURITY_DATE	Maturity date used in accrual calculations
INTEREST_RATE	Interest rate at which a deal or transaction is executed
NO_OF_DAYS	Number of days used to calculate interest
YEAR_BASIS	Number of days in a year used in calculations
ACCRLS_AMOUNT	Accrual amount
FIRST_ACCRUAL_INDIC	Flag to indicate if this is the first accrual or amortization for this deal (Y), or not (N)

Treasury - XTR_AUDIT_GROUPS
Column Name	Descritpion
EVENT
CREATED_ON
CREATED_BY
UPDATED_ON
UPDATED_BY
GROUP_CODE

Treasury - XTR_ACCEPTED_BIDS	Created by ORACLE on 13-SEP-95
Column Name	Descritpion
ACCEPTOR_CODE	Acceptor identifier. The counterparty or company accepting the deal. Foreign key to XTR_PARTIES_V. ???
DEAL_CREATED
DISCOUNT_AMOUNT
DRAWER_CODE
ISSUE_NO
LIMIT_CODE	Limit code identifier. Composite key to XTR_COMPANY_LIMITS.
NOS_PARCELS
PARCEL_SIZE
RATE_BID
AMOUNT_ALLOCATED
BIDS_REF
COMPANY_ACCOUNT
COMPANY_CODE	Company identifier. Foreign key to XTR_PARTIES_V.
CPARTY_ACCT_REF
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.

Treasury - XTR_A_BANK_SETTLEMENT_CODES	Created on 21-SEP-94
Column Name	Descritpion
BANK_NUMBER
BRANCH_NAME
BRANCH_NUMBER
CURRENCY
AUDIT_DATE_STORED	Date on which this record is audited.
AUDIT_INDICATOR
BANK_CODE	Bank identifier.
BANK_NAME	Name of the bank.

Treasury - XTR_A_FUTURES	Created from Entity XTR FUTURES by ORACLE on 16-JUN-95
Column Name	Descritpion
AUTHORISED	Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
CALCULATION_TYPE
CONTRACT_CODE
CONTRACT_CONFO
CONTRACT_DAYS
APR_YN
CONTRACT_DESCRIPTION
CONTRACT_YEARS
CONTRA_CURRENCY
COUPONS_PER_YEAR
COUPON_RATE
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
CURRENCY
DEC_YN
DELIVERABLE
AUDIT_DATE_STORED	Date on which this record is audited.
EX_CODE
FEB_YN
FINANCIAL_CONTRACT
JAN_YN
JUL_YN
JUN_YN
MAR_YN
MAY_YN
NOV_YN
OCT_YN
AUDIT_INDICATOR
PRICING_BASIS
ROUNDING_FACTOR
SEP_YN
SETTLEMENT_ADJUSTMENT
TERMINATION_DATE
TERMINATION_DAY
TERMINATION_WEEK
TICK_VALUE
TOTAL_COUPONS
UNIT_SIZE
AUG_YN
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
YEAR_BASIS

Treasury - XTR_A_FUTURES_FEES	Created from Entity XTR FUTURES by ORACLE on 16-JUN-95
Column Name	Descritpion
CONTRACT_ID
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
DEPOSIT
MAX_CONTRACTS
AUDIT_DATE_STORED	Date on which this record is audited.
MIN_CONTRACTS
OTHER_FEES
SELL_FEES
UPDATED_BY	Last updated user.
UPDATED_ON	Last updated date.
AUDIT_INDICATOR
BUY_FEES
COMMISSION

Treasury - XTR_A_FUTURES_MARGIN_DETAILS	Created from Entity XTR FUTURES by ORACLE on 16-JUN-95
Column Name	Descritpion
CONTRACT_ID
CREATED_BY	User who created this record.
CREATED_ON	Date on which this record is created.
EX_CODE
UPDATED_BY	Last updated user.
AUDIT_DATE_STORED	Date on which this record is audited.
UPDATED_ON	Last updated date.
AUDIT_INDICATOR
BROKER_CODE
CONTRACT_CODE

Treasury - XTR_BIDS_RECD	Created on 23-NOV-94
Column Name	Descritpion
ISSUE_NO
RATE_BID
AMOUNT_ALLOCATED
AMOUNT_BID
BIDS_REF
CPARTY_CODE	Counterparty identifier. Foreign key to XTR_PARTIES_V.

Treasury - XTR_CONFIRMATION_SETUP	Created by ORACLE on 06-JUL-96
Column Name	Descritpion
CONFO_GROUP_CODE	Confirmation group identifer. Composite key to XTR_CONFIRMATION_ACTIONS.
FAX
GROUP_DESC
POST
SWIFT
DEAL_OR_SETTLEMENT
DEAL_TYPE	Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM.
EMAIL

Treasury - XTR_DDE_FEED_LOCKS	Created by ORACLE on 20-NOV-96
Column Name	Descritpion
DUMMY

Treasury - XTR_AVG_RATES_RESULTS
Column Name	Descritpion
P_I
PERIOD
DATE_FROM
DATE_TO
COMPANY_CODE
DEAL_TYPE
PRODUCT_TYPE
PORTFOLIO_CODE
UNIQUE_ID
CPARTY_CODE
CURRENCY
CURRENCY_COMBINATION
PRINCIPAL
INTEREST
AVERAGE_CONTRACT_RATE
AVERAGE_SPOT_RATE
MINIMUM_RATE
MAXIMUM_RATE
NUM_DEALS

Treasury - XTR_DEAL_OVERWRITE_TYPES	This table will store overwrite types that are allowed for each deal type.
Column Name	Descritpion
DEAL_OVERWRITE_TYPE_ID	Unique identifier for each row of deal overwrite type.
DEAL_TYPE	Denotes the deal type associated with this overwrite type.
CODE	Code that represents the deal overwrite type. If the value is null, then there is no overwrite type associated with this deal type.
AUTHORIZED	Specifies if the overwrite type is authorized for use by deals with the associated deal types. An unauthorized overwrite type cannot be assigned to new deals but will remains as a reference to existing deals.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.

Treasury - XTR_BATCHES	This table stores the fundamental information for each batch process.
Column Name	Descritpion
BATCH_ID	Unique identifier for each row of batch data.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
BATCH_TYPE	Not currently used
REQUEST_ID	Identifies the concurrent request that produced the concurrent program.
COMPANY_CODE	Specifies which company this batch data belongs to.
PERIOD_START	The start period of the batch.
PERIOD_END	The end period of the batch.
GL_GROUP_ID	Records the GL group ID if this record which has been transferred to the GL_INTERFACE table.
UPGRADE_BATCH	This is used to differentiate pre-upgrade batches from post-upgrade batches. Pre-upgrade batches are viewed only batches in Revaluation, Accruals and Journals forms. Valid values : Y for pre-upgrade batches. N or null for post-upgrade ba
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.

Treasury - XTR_BATCH_EVENTS	This table will store the information for each event within a parent batch process.
Column Name	Descritpion
BATCH_EVENT_ID	Unique identifier for each event within each batch process.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
BATCH_ID	Identifier that groups events into one process flow.
EVENT_CODE	Identifies the event.
AUTHORIZED	Specifies if the event has been authorized and ready for the next step in the process. Y=Authorized. N=Not Authorized. E=Error
AUTHORIZED_BY	The user that authorized the event.
AUTHORIZED_ON	The date on which the event was authorized.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.

Treasury - XTR_COMPANY_PARAMETERS	This table will store transactional parameters specific to each company.
Column Name	Descritpion
COMPANY_PARAMETER_ID	Unique identifier for each row of company parameter data.
LAST_UPDATE_LOGIN	Standard Who Column.
COMPANY_CODE	Specifies which company this data belongs to.
PARAMETER_CODE	A code that identifies the parameter value.
PARAMETER_VALUE_CODE	A code that identifies the parameter value.
PARAMETER_VALUE	The parameter value. This column is used when the parameters are not seeded but are entered by the user, e.g. Subscriber FX Match ID.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.

Treasury - XTR_BOND_ALLOC_DETAILS	For realized gain/loss from bond resale
Column Name	Descritpion
BOND_ALLOC_DETAIL_ID	Unique identifier for each row of this table
BACK_END_BROKERAGE	Brokerage amount allocated to face value being resold from the resale deal.
FRONT_END_PREM_DISC	Premium or discount amount from the original buy deal allocated to face value being resold. positive amount = premium negative amount = discount.
BACK_END_PREM_DISC	Premium or discount amount from the resale deal allocated to the face value being resold. positive amount = premium negative amount = discount.
BACK_END_INTEREST	Interest amount from the resale deal allocated to the face value being resold.
CROSS_REF_DEAL_DATE	Deal date of the resale deal.
CROSS_REF_START_DATE	Start date of the resale deal.
CROSS_REF_CLEAN_PX	Clean price of the resale deal.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
BATCH_ID	Batch id of revaluation batch in which the gain/loss amount was recognized.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
AVG_RATE_LAST_PROCESSED	The date of the latest average rate that has been processed for a bond resale deal.
DEAL_NO	Deal number from which resale amount came from.
CROSS_REF_NO	Resale deal number.
FACE_VALUE	Resale face value.
INITIAL_FAIR_VALUE	Initial fair value allocated to the resold face.
AMC_REAL_GAIN_LOSS	Realized gain/loss of resale calculated based on the amortized cost basis method, with consideration for front and back-end transaction costs, dependant on company parameter 'Include Transaction Costs' setting.
MTM_REAL_GAIN_LOSS	Realized gain/loss of resale calculated based on the mark-to-market method, with consideration for front and back-end transaction costs, dependant on company parameter 'Include Transaction Costs' setting.
FRONT_END_BROKERAGE	Brokerage amount allocated to face value being resold from the original buy deal.

Treasury - XTR_A_COMPANY_PARAMETERS	This table is used to audit Xtr_Company_Parameters
Column Name	Descritpion
COMPANY_PARAMETER_ID	Unique identifier for each row of company parameter data.
LAST_UPDATE_LOGIN	Standard Who Column.
AUDIT_DATE_STORED	Audit Column
COMPANY_CODE	Specifies which company this data belongs to.
PARAMETER_CODE	A code that identifies the parameter value.
PARAMETER_VALUE_CODE	A code that identifies the parameter value.
PARAMETER_VALUE	The parameter value. This column is used when the parameters are not seeded but are entered by the user, e.g. Subscriber FX Match ID.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.

Treasury - XTR_DEALS_INTERFACE	The XTR_DEALS_INTERFACE table contains deal information that will be imported into Oracle Treasury
Column Name	Descritpion
EXTERNAL_DEAL_ID	This stores the external unique primary identifier for each deal.
BROKERAGE_CURRENCY	Currency code of brokerage amount.
ACCOUNT_NO_A	First account number.
ACCOUNT_NO_B	Second account number.
CLIENT_CODE	Client code.
COMMENTS	Internal comments.
COMPANY_CODE	Company code.
CPARTY_CODE	Counterparty code. This column is also used to store THIRDPARTY_CODE for EXP deals.
CPARTY_REF	Counterparty account reference code.
CURRENCY_A	First currency.
CURRENCY_B	Second currency.
DEAL_TYPE	Code to identify a deal or instrument type.
DEALER_CODE	Code for Treasury users.
DEAL_LINKING_CODE	Code to identify the group of linked deals.
DEAL_SUBTYPE	Code to sub-categorize deals within each deal type.
EXTERNAL_COMMENTS	External comments.
EXTERNAL_CPARTY_NO	External reference.
INTERNAL_TICKET_NO	Internal reference.
LIMIT_CODE	Code for user-defined limits imposed on deals and transactions.
PORTFOLIO_CODE	Code for grouping deals under a single portfolio.
PRODUCT_TYPE	Code for products used in a deal type.
STATUS_CODE	Code for the execution status of deals and transactions.
CREATED_BY	Standard WHO column
AMOUNT_A	First amount.
AMOUNT_B	Second amount.
AMOUNT_C	Third amount.
RATE_A	First rate.
RATE_B	Second rate.
RATE_C	Third rate.
DATE_A	First date.
DATE_B	Second date.
NO_OF_DAYS	Number of days used to calculate interest.
ACTION_CODE	Amount action.
CREATION_DATE	Standard WHO column
AMOUNT_TYPE	Amount type.
AMOUNT_HCE	Reporting currency amount.
EXPOSURE_TYPE	Exposure type.
SETTLE_ACTION_REQD	Flag that indicates whether Treasury to settle the transaction.
BANK_CODE_FROM	Stores the origin bank code.
BANK_CODE_TO	Stores the destination bank code.
MARKET_DATA_SET	Market Data Set.
PRICING_MODEL	Pricing Model.
OVERRIDE_LIMIT	Override Limit Flag 'Y' or NULL = override, 'N' = do not override limit, limit is flagged as error.
DUAL_AUTHORIZATION_BY	Validator.
LAST_UPDATE_DATE	Standard WHO column
DUAL_AUTHORIZATION_ON	Date of deal validation.
ATTRIBUTE_CATEGORY	Category for Descriptive Flexfields.
ATTRIBUTE1	Flexfield.
ATTRIBUTE2	Flexfield.
ATTRIBUTE3	Flexfield.
ATTRIBUTE4	Flexfield.
ATTRIBUTE5	Flexfield.
ATTRIBUTE6	Flexfield.
ATTRIBUTE7	Flexfield.
ATTRIBUTE8	Flexfield.
LAST_UPDATED_BY	Standard WHO column
ATTRIBUTE9	Flexfield.
ATTRIBUTE10	Flexfield.
ATTRIBUTE11	Flexfield.
ATTRIBUTE12	Flexfield.
ATTRIBUTE13	Flexfield.
ATTRIBUTE14	Flexfield.
ATTRIBUTE15	Flexfield.
LIMIT_CODE_B	The user-defined invest limit types assigned to the deals and transactions.
MIRROR_PORTFOLIO_CODE	Portfolio code for the mirror transaction.
MIRROR_PRODUCT_TYPE	Product type for the mirror transaction.
MIRROR_LIMIT_CODE_INVEST	Investment limit code for the mirror
MIRROR_LIMIT_CODE_FUND	Funding limit code for the mirror.
ROUNDING_TYPE	Not currently used
DAY_COUNT_TYPE	Not currently used
LAST_UPDATE_LOGIN	Standard WHO column
ORIGINAL_AMOUNT	Not currently used
YEAR_CALC_TYPE	Field for year calculation type. See documentation for more details
DATE_C	Generic field for holding dates. See documentation for field field mappings for each deal type
BASIS_TYPE	Field for holding calculation basis. See documentation for more details
SECURITY_ID	Field for holding security id. See documentation for more details
ACCEPTOR_CODE	Field for holding risk party acceptor code. See documentation for more details
DRAWER_CODE	Field for holding risk party drawer code. See documentation for more details
ENDORSER_CODE	Field for holding risk party endorser code. See documentation for more details
SCHEDULE_A	Generic field for holding schedule codes. See documentation for field mappings for each deal type
SCHEDULE_B	Generic field for holding schedule codes. See documentation for field mappings for each deal type
OPTION_A	Generic field for holding options. See documentation for field mappings for each deal type
MIRROR_PRICING_MODEL	Mirror pricing model
FROM_BANK_BRANCH_ID	Stores the origin bank ID.
TO_BANK_BRANCH_ID	Stores the destination bank ID.
COMPANY_ACCT_A_USE_ID	First account ID
COMPANY_ACCT_B_USE_ID	Second account ID
CPARTY_ACCT_USE_ID	Counterparty account ID
CPARTY_ACCOUNT_NO	Counterparty bank account number
MIRROR_DEAL_LINKING_CODE	Code to identify the group of linked deals
MIRROR_DEALER_CODE	Code for Treasury users
LOAD_STATUS_CODE	Flag that denotes the transfer status of the deal in this record. 'NEW' or null = New deal. 'UPDATED' = Updated Deal. 'ERROR' = Error deal. 'SUBMIT' = Submitted Deal. 'DEAL_TYPE_ERROR' = for non-supported deal type for transfer 'DUPLIC
EXTERNAL_SOURCE	The source of the transactions
VALIDATION_FLAG	Flag for validation
SETTLEMENT_FLAG	Flag for settlement
BROKERAGE_CODE	Brokerage code.

Treasury - XTR_CALL_DETAILS	This table is used for storing call informaion of callable bond issues
Column Name	Descritpion
CALL_DETAILS_ID	Unique ID for each table row
LAST_UPDATED_BY	Standard Who columns
LAST_UPDATE_DATE	Standard Who columns
LAST_UPDATE_LOGIN	Standard Who columns
BOND_ISSUE_CODE	Bond issue code
NOTIFICATION_DATE	Latest date that bond investors must be notified about possible call
END_DATE	Expiration of the call for an American option
CALL_DATE	Date when the bond issue is called
PRICE	Strike price at the time of the call
COMMENTS	User-defined comments
CREATED_BY	Standard Who columns
CREATION_DATE	Standard Who columns

Treasury - XTR_DEAL_RETRO_TESTS	Stores deal level retrospective effectiveness test and measurement details.
Column Name	Descritpion
DEAL_RETRO_TEST_ID	Identifier for the retrospective test results at the deal level.
PROGRAM_LOGIN_ID	Identifies the Oracle Applications Concurrent Program Login ID.
PROGRAM_APPLICATION_ID	Identifies the Oracle Application that spawned the concurrent program.
REQUEST_ID	Identifies the concurrent request instance that spawned the concurrent program.
DEAL_NUMBER	Deal Identifier
AMOUNT_TYPE	Indicates whether the gain/loss amounts are fair value gain/losses (UNREAL) or currency gain/losses (CCYUNRL).
EFF_PRD_GAIN_LOSS_AMT	Sum of effective period gains or losses for all the instruments assigned to the hedge in the set of books currency.
INEFF_PRD_GAIN_LOSS_AMT	Sum of ineffective period gains or losses for all the instruments assigned to the hedge in the set of books currency.
EXCLUDED_PRD_GAIN_LOSS_AMT	Amount that is excluded from the percentage effective calculation in the set of books currency.
RECLASS_GAIN_LOSS_AMT	Reclassification gain or loss amount for the hedge.
EFF_CUM_GAIN_LOSS_AMT	Cumulative effective gains or losses for all the instruments assigned to the hedge since the inception of the hedge in set of books currency.
BATCH_ID	Batch Identifier
INEFF_CUM_GAIN_LOSS_AMT	Cumulative ineffective gains or losses for all the instruments assigned to the hedge since the inception of the hedge in the set of books currency.
EXCLUDED_CUM_GAIN_LOSS_AMT	Cumulative amount that is excluded from the percentage effective calculation since the inception of the hedge in the set of books currency.
HEDGE_RETRO_TEST_ID	Identifier for the retrospective test results at the hedge level.
RESULT_DATE	Indicates the latest revaluation date.
HEDGE_ATTRIBUTE_ID	Hedge attribute identifier
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns
PROGRAM_ID	Identifies the concurrent program.

Treasury - XTR_CASHPOOL_ATTRIBUTES	This table stores information related to Treasury Cashpool Deal Attributes Setup.
Column Name	Descritpion
CASHPOOL_ATTRIBUTE_ID	Cashpool company attribute identifier
FUND_LIMIT_CODE	Cashpool company Intercompany Funding funding limit
INVEST_LIMIT_CODE	Cashpool company Intercompany Funding investment limit
PARTY_CODE	Cashpool Intercompany Funding intercompany code
PARTY_PORTFOLIO	Cashpool intercompany portfolio
PARTY_PRODUCT_TYPE	Cashpool intercompany product type
PARTY_PRICING_MODEL	Cashpool Intercompany Funding intercompany pricing model
PARTY_FUND_LIMIT_CODE	Cashpool intercompany funding limit
PARTY_INVEST_LIMIT_CODE	Cashpool intercompany investment limit
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CASHPOOL_ID	Physical cashpool ID
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
IAC_PORTFOLIO	Cashpool company Inter-Account Transfer portfolio
IAC_PRODUCT_TYPE	Cashpool company Inter-Account Transfer product type
PORTFOLIO	Cashpool company Intercompany Funding portfolio
PRODUCT_TYPE	Cashpool company Intercompany Funding product type
ROUNDING_TYPE	Cashpool company Intercompany Funding interest rounding type
DAY_COUNT_TYPE	Cashpool company Intercompany Funding day count for interest calculation
PRICING_MODEL	Cashpool company Intercompany Funding pricing model

Treasury - XTR_CFLOW_REQUEST_DETAILS	Update Settlement Accounts Request Details.
Column Name	Descritpion
CASHFLOW_REQUEST_DETAILS_ID	Identifier of the Update Settlement Account Concurrent Request.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
STARTING_CFLOW_DATE	Starting Cash Flow Date parameter from the concurrent request.
ENDING_CFLOW_DATE	Ending Cash Flow Date parameter from the
INCLUDE_JOURNALIZED_FLAG	Include Journalized Flag parameter from the concurrent request.
REQUEST_ID	Request ID of the Concurrent program that created this row.
PARTY_CODE	Party Code parameter from the Concurrent Request.
ACCOUNT_NO_FROM	Current Bank Account parameter from the request.
ACCOUNT_NO_TO	New Bank Account parameter from the request.
DEAL_TYPE	Deal Type parameter from the request.
DEAL_NUMBER_FROM	Deal Number From parameter from the request.
DEAL_NUMBER_TO	Deal Number To parameter from the request.
CREATED_BY	Standard Who Column.

Treasury - XTR_CFLOW_UPDATED_RECORDS	This table stores details of the records that were updated by the Update Settlement Accounts program.
Column Name	Descritpion
CASHFLOW_REQUEST_DETAILS_ID	Identifier of the Update Settlement Account Concurrent Request
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
AMOUNT_DATE	The amount date of the cashflow.
AMOUNT_TYPE	Code that identifies the purpose of the amounts for a Deal Type.
CASHFLOW_AMOUNT	Cashflow Amount.
DEAL_TYPE	Deal Type of the updated Cashflow record.
DEAL_NUMBER	Deal Number of the updated Cashflow Record.
TRANSACTION_NUMBER	Transaction Number of the updated Cashflow Record.
UPDATED_FLAG	Flag to indicate whether this record was updated or not.
MESSAGE_NAME	Message code to indicate why the record was not updated.