Schema ASTExportToGL_V.1.0.xsd

schema location:  ASTExportToGL_V.1.0.xsd
attribute form default:  unqualified

element form default:

  qualified
 
Elements  Complex types 
ActivityExport  TotalsBase 

Note:

    Group = Client
    Account= investment account
    Activity Group= Highest summary level (e.g. income)
    Activity Type=  Tier 2 summary level (e.g. interest income, dividends)
    Activity=  Transaction level detail

      Two files are transmitted, one for current period and one with Cancel/Corrects of prior period

element ActivityExport/GeneralLedger/Groups/Group

diagram
properties
isRef 0
content complex
children FoundationName ProviderName StartDate EndDate AsOfDate Accounts

element ActivityExport/GeneralLedger/Groups/Group/FoundationName
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
CFNJ | CFGA | etc.


element ActivityExport
diagram
properties
content complex
children Version File GeneralLedger

element ActivityExport/Version
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
1.0

element ActivityExport/File
diagram
properties
isRef 0
content complex
children ID Type CreatedDate

element ActivityExport/File/ID
diagram
properties
isRef 0
annotation
documentation 
Unique Identifier for File (Nor Applicable for UNAUDITED FileType)

element ActivityExport/File/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
UNAUDITED | AUDITED | CORRECTION

element ActivityExport/File/CreatedDate
diagram
type xs:dateTime
properties
isRef 0
content simple
annotation
documentation 
ccyy-mm-dd hh:mm:ss

element ActivityExport/GeneralLedger
diagram
properties
isRef 0
content complex
children Groups

element ActivityExport/GeneralLedger/Groups
diagram
properties
isRef 0
content complex
children Group
element ActivityExport/GeneralLedger/Groups/Group/ProviderName
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
AST (static value)

element ActivityExport/GeneralLedger/Groups/Group/StartDate
diagram
type xs:date
properties
isRef 0
content simple
annotation
documentation 
ccyy-mm-dd

element ActivityExport/GeneralLedger/Groups/Group/EndDate
diagram
type xs:date
properties
isRef 0
content simple
annotation
documentation 
ccyy-mm-dd

element ActivityExport/GeneralLedger/Groups/Group/AsOfDate
diagram
type xs:date
properties
isRef 0
content simple
annotation
documentation 
ccyy-mm-dd

element ActivityExport/GeneralLedger/Groups/Group/Accounts
diagram
properties
isRef 0
content complex
children Account

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account
diagram
properties
isRef 0
content complex
children Type ProviderID AccountName CustodianID CustodianName ActivityGroups
annotation
documentation 
CORRECTION files without any cancel/correct tranactions (no deltas from previous periods) will not contain any account information.

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
"Pool" | 'Foundation" | etc.

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ProviderID
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
(AST Account Number) "cfga0001" | etc.

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/AccountName
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
"CFNJ - Samson Family DAF" | etc.

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/CustodianID
diagram
type xs:string
properties
isRef 0
content simple
nillable 0
annotation
documentation 
(Broker/Bank Account Number)

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/CustodianName
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
"Wells Fargo" | etc.

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups
diagram
properties
isRef 0
content complex
children ActivityGroup

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup
diagram
properties
isRef 0
content complex
children Type Totals ActivityTypes

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Net Cash Flow | Income | Capitol Changes | Fees and Expenses

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/Totals
diagram
type TotalsBase
properties
isRef 0
content complex
children Amount AmountOnCost CostBasis Units Price

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes
diagram
properties
isRef 0
content complex
children ActivityType

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType
diagram
properties
isRef 0
content complex
children Type Totals Activities

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Deposits | Withdrawals | Intrest | Dividends | Accrued Interest | Realized Gain/Loss | etc.

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Totals
diagram
type TotalsBase
properties
isRef 0
content complex
children Amount AmountOnCost CostBasis Units Price

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities
diagram
properties
isRef 0
content complex
children Activity

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity
diagram
properties
isRef 0
content complex
children Type TransactionID ProviderID CustodianID Date PostDate RecordDef Totals Asset

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
TranCode | Holding

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/TransactionID
diagram
type xs:float
properties
isRef 0
content simple
annotation
documentation 
(source's unique identifier)

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/ProviderID
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
AST Account Number

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/CustodianID
diagram
type xs:string
properties
isRef 0
content simple
nillable 0
annotation
documentation 
Broker/Bank Account Number.

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Date
diagram
type xs:date
properties
isRef 0
content simple
annotation
documentation 
ccyy-mm-dd

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/PostDate
diagram
type xs:date
properties
isRef 0
content simple
annotation
documentation 
ccyy-mm-dd

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/RecordDef
diagram
properties
isRef 0
annotation
documentation 
(undecided datatype/usage)

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Totals
diagram
type TotalsBase
properties
isRef 0
content complex
children Amount AmountOnCost CostBasis Units Price

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Asset
diagram
properties
isRef 0
content complex
children Type Class Name Symbol Term

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Asset/Type
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Mutual Fund | Common Stock

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Asset/Class
diagram
type xs:string
properties
isRef 0
content simple

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Asset/Name
diagram
type xs:string
properties
isRef 0
content simple

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Asset/Symbol
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Cusip | Ticker | Symbol

element ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Asset/Term
diagram
type xs:string
properties
isRef 0
content simple
annotation
documentation 
Short | Long           (Realized Gain/Loss)

complexType TotalsBase
diagram
children Amount AmountOnCost CostBasis Units Price
used by
elements ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/Totals ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Totals ActivityExport/GeneralLedger/Groups/Group/Accounts/Account/ActivityGroups/ActivityGroup/ActivityTypes/ActivityType/Activities/Activity/Totals

element TotalsBase/Amount
diagram
type xs:decimal
properties
isRef 0
content simple
annotation
documentation 
Default Amount (Realized/Unrealized Gain/Loss = "AmountOnMarket")

element TotalsBase/AmountOnCost
diagram
type xs:decimal
properties
isRef 0
content simple
annotation
documentation 
For Realized/Unrealized Gain/Loss

element TotalsBase/CostBasis
diagram
type xs:decimal
properties
isRef 0
content simple
annotation
documentation 
Only for Positions

element TotalsBase/Units
diagram
type xs:double
properties
isRef 0
content simple
annotation
documentation 
Only for Positions

element TotalsBase/Price
diagram
type xs:decimal
properties
isRef 0
content simple
annotation
documentation 
Only for Positions


XML Schema documentation generated with XMLSpy Schema Editor http://www.altova.com/xmlspy