3.7 Finance

A set of objects to support the transfer of financial information representing, and not an accounting package. The assumption is that SIF is required only to exchange information about individual transactions (e.g. purchase orders, invoices, receipts, journals), and that reporting will be done out of existing applications—although those reports may be based on the transactional information received through SIF

3.7.1 ChargedLocationInfo

ChargedLocationInfo represents a location in a school system. It can be used to associate accounts and purchase orders with particular schools or other cost centres.

SIF_Events are reported for this object.

ChargedLocationInfo
Figure 3.7.1-1: ChargedLocationInfo ChargedLocationInfo RefId LocationType SiteCategory Name Description LocalId StateProvinceId ParentChargedLocationInfoRefId SchoolInfoRefId AddressList PhoneNumberList LocalCodeList SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharPrivacy RatingDescriptionType
 ChargedLocationInfo Low

ChargedLocationInfo represents a location in a school system. It can be used to associate accounts and purchase orders with particular schools or other cost centres.

 
 
@
key
RefIdMLow

The SIF unique identifier for the location.

 
RefIdType
 LocationTypeMLow

Defines whether the location is a school or a non-school location.

 
values:
School
NonSchool
 SiteCategoryMLow

Specific site category.

Examples
Prep Site
Satellite
Central Kitchen
Warehouse
Storage
Central Office
Other

xs:normalizedString
 NameMLow

Text name of the location.

 
xs:normalizedString
 DescriptionOLow

Description about the location.

 
xs:normalizedString
 LocalIdOLow

The locally-assigned identifier for this location.

 
LocalIdType
 StateProvinceIdOLow

The state-assigned identifier for this location.

 
StateProvinceIdType
 ParentChargedLocationInfoRefIdOLow

A ChargedLocationInfo instance could be related to another ChargedLocationInfo. This element will help create that relation.

 
IdRefType
 SchoolInfoRefIdOLow

The RefId of a corresponding SchoolInfo object.

 
IdRefType
 AddressListOLow

This element has the ChargedLocationInfo address information.

 
AddressListType
 PhoneNumberListOLow

The location's phone numbers.

 
PhoneNumberListType
 LocalCodeListOHigh LocalCodeListType
 SIF_MetadataOLow SIF_MetadataType
 SIF_ExtendedElementsOLow SIF_ExtendedElementsType
Table 3.7.1-1: ChargedLocationInfo
<ChargedLocationInfo RefId="D3E34B35-9D75-101A-8C3D-00AA001A1652"> <LocationType>School</LocationType> <SiteCategory>Other</SiteCategory> <Name>Lincoln High School</Name> <LocalId>2343LHS</LocalId> </ChargedLocationInfo>
Example 3.7.1-1: ChargedLocation

3.7.2 Debtor

This object is used to capture general information about debtors.

SIF_Events are reported for this object.

Debtor
Figure 3.7.2-1: Debtor Debtor RefId BilledEntity SIF_RefObject AddressList BillingName BillingNote Discount LocalCodeList SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharPrivacy RatingDescriptionType
 Debtor High

This object is used to capture general information about debtors.

 
 
@
key
RefIdMHigh

Debtor Id.

 
RefIdType
 BilledEntityMHigh

Id of the entity referred to by this object (e.g., student, employee, organization).

 
IdRefType
@SIF_RefObjectMHigh

SIF object referenced by BilledEntity.

 
values:
StudentPersonal
StudentContactPersonal
StaffPersonal
VendorInfo
 AddressListOHigh

Addresses of the debtor to be used for billing. These addresses override any addresses found in the Billed Entity.

 
AddressListType
 BillingNameOHigh

Name of the entity to be used for billing (e.g. company name rather than individual name).

 
xs:normalizedString
 BillingNoteOHigh

Note about billing requirements.

 
xs:normalizedString
 DiscountOHigh

Any discount amount applicable to this debtor (e.g. family discount for scholarship, number of children enrolled). Is a percentage.

 
xs:normalizedString
 LocalCodeListOHigh LocalCodeListType
 SIF_MetadataOHigh SIF_MetadataType
 SIF_ExtendedElementsOHigh SIF_ExtendedElementsType
Table 3.7.2-1: Debtor
<Debtor RefId="B5739375-800A-C4CC-6385-0BB2754114AA"> <BilledEntity SIF_RefObject="StudentContactPersonal">8B231144-301C-4D3B-95D4-8BB74C866AE1</BilledEntity> <AddressList> <Address Type="0123" Role="2382"> <Street> <Line1>23 E. 43rd St.</Line1> </Street> <City>Chicago</City> <StateProvince>IL</StateProvince> <Country>8104</Country> <PostalCode>60611</PostalCode> </Address> </AddressList> <BillingName>Flintstone Family Trust</BillingName> <BillingNote>Do not invoice under parent's real name.</BillingNote> <Discount>10.0</Discount> </Debtor>
Example 3.7.2-1: Debtor

3.7.3 FinancialAccount

This object communicates information about a financial account.

SIF_Events are reported for this object.

FinancialAccount
Figure 3.7.3-1: FinancialAccount FinancialAccount RefId ParentAccountRefId ChargedLocationInfoRefId AccountNumber Name Description ClassType CreationDate CreationTime LocalCodeList SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharPrivacy RatingDescriptionType
 FinancialAccount High

This object communicates information about a financial account.

 
 
@
key
RefIdMHigh

GUID that identifies this financial account.

 
RefIdType
 ParentAccountRefIdOHigh

Identifier of a parent account of the account. Can be used to construct a hierarchical tree of nesting accounts, e.g. "Revenue" -- "Revenue-Grant" -- "Revenue-Grant-Commonwealth".

 
IdRefType
 ChargedLocationInfoRefIdOHigh

Location associated with the account

 
IdRefType
 AccountNumberMHigh

Account number used for ledger.

 
xs:normalizedString
 NameMHigh

Name of the account.

 
xs:normalizedString
 DescriptionOHigh

Description of the account.

 
xs:normalizedString
 ClassTypeMHigh

The class of the account

 
values:
Asset
Liability
Revenue
Expense
 CreationDateMHigh

Account creation date.

 
xs:date
 CreationTimeMHigh

Account creation time.

 
xs:time
 LocalCodeListOHigh LocalCodeListType
 SIF_MetadataOHigh SIF_MetadataType
 SIF_ExtendedElementsOHigh SIF_ExtendedElementsType
Table 3.7.3-1: FinancialAccount
<FinancialAccount RefId="EEC8FC12-8D2C-4EE3-94A8-6C5395024EDE"> <AccountNumber>9990001</AccountNumber> <Name>Purchased Foods</Name> <Description>Purchased Foods</Description> <ClassType>Asset</ClassType> <CreationDate>2003-01-01</CreationDate> <CreationTime>04:32:23-08:00</CreationTime> </FinancialAccount>
Example 3.7.3-1: FinancialAccount

3.7.4 Invoice

This object contains an amount to be invoiced to an outside entity (typically a creditor or debtor). This object can include school fees. The object is also used for payments to an outside entity (using debit amounts), where those payments are not for goods and services (PurchaseOrder object): e.g. credit notes, reimbursements, rebates.

SIF_Events are reported for this object.

Invoice
Figure 3.7.4-1: Invoice Invoice RefId InvoicedEntity SIF_RefObject FormNumber BillingDate TransactionDescription BilledAmount Ledger ChargedLocationInfoRefId NetAmount TaxRate TaxType TaxAmount CreatedBy ApprovedBy ItemDetail DueDate FinancialAccountRefIdList AccountingPeriod RelatedPurchaseOrderRefId PurchasingItems Voluntary LocalCodeList SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharPrivacy RatingDescriptionType
 Invoice High

This object contains an amount to be invoiced to an outside entity (typically a creditor or debtor). This object can include school fees. The object is also used for payments to an outside entity (using debit amounts), where those payments are not for goods and services (PurchaseOrder object): e.g. credit notes, reimbursements, rebates.

 
 
@
key
RefIdMLow

GUID for this transaction. The application that owns this object is responsible for generating this unique Id.

 
RefIdType
 InvoicedEntityMHigh

Id of the entity being billed for this billing activity.

 
IdRefType
@SIF_RefObjectMHigh

RefId of SIF object referenced by Invoiced Entity.

 
values:
Debtor
PurchaseOrder
 FormNumberOHigh

Invoice number assigned locally by the system issuing the invoice.

 
LocalIdType
 BillingDateMHigh

Date of the transaction.

 
xs:date
 TransactionDescriptionMHigh

Description of the transaction.

 
xs:normalizedString
 BilledAmountMHigh

Gross amount to be billed, including any tax. Can be credit (e.g. for family credit notes, reimbursements, rebates).

 
DebitOrCreditAmountType
 LedgerMHigh

The associated ledger for this transaction

 
values:
Creditor
Family
Sundry
 ChargedLocationInfoRefIdOHigh

Id of the location billed for this billing activity.

 
IdRefType
 NetAmountOHigh

Net amount billed, excluding any tax. Should be BilledAmount minus TaxAmount.

 
MonetaryAmountType
 TaxRateOHigh

Rate of tax included in the billed amount.

 
xs:decimal
 TaxTypeOHigh

Tax type (e.g. G11 vs NP6)

 
xs:normalizedString
 TaxAmountOHigh

Amount of tax included in the billed amount

 
MonetaryAmountType
 CreatedByOLow

Authority or person who created the invoice

 
xs:normalizedString
 ApprovedByOLow

Authority or person who approved the invoice

 
xs:normalizedString
 ItemDetailOHigh

Details of items invoiced (free text)

 
xs:normalizedString
 DueDateOHigh

Due date for payment.

 
xs:date
 FinancialAccountRefIdListOHigh

List of RefIds of the Associated Financial Accounts.

 
FinancialAccountRefIdListType
 AccountingPeriodOLow

The accounting period against which the transaction is billed.

 
LocalIdType
 RelatedPurchaseOrderRefIdOHigh

An invoice purchase order related to this invoice (e.g. an invoice raised for the delivery of goods on a purchase order).

 
IdRefType
 PurchasingItemsOHigh

Listing of line items from original purchase order. Included to indicate any variation between the items, item cost, or item quantity ordered, and what has been delivered.

 
PurchasingItemsType
 VoluntaryOHigh

Whether the billing is voluntary (applies to some school fees).

 
AUCodeSetsYesOrNoCategoryType
 LocalCodeListOHigh LocalCodeListType
 SIF_MetadataOHigh SIF_MetadataType
 SIF_ExtendedElementsOHigh SIF_ExtendedElementsType
Table 3.7.4-1: Invoice
<Invoice RefId="CA123458-47DE-A974-63FE-B238759FD123"> <InvoicedEntity SIF_RefObject="Debtor">BA497254-965F-DA48-965A-BCE4589EA421</InvoicedEntity> <BillingDate>1999-10-12</BillingDate> <TransactionDescription>Activity Fees</TransactionDescription> <BilledAmount Type="Debit" Currency="AUD">50.00</BilledAmount> <Ledger>Family</Ledger> <TaxRate>10.0</TaxRate> <TaxAmount Currency="AUD">5.00</TaxAmount> <CreatedBy>Peter Rabbit</CreatedBy> <ApprovedBy>Fred Flintstone</ApprovedBy> <ItemDetail>5 Widgets</ItemDetail> <FinancialAccountRefIdList> <FinancialAccountRefId>AE109F1A-C2DE-41E4-9DF5-C418F3DF18A8</FinancialAccountRefId> </FinancialAccountRefIdList> <AccountingPeriod>200004</AccountingPeriod> </Invoice>
Example 3.7.4-1: Invoice

3.7.5 Journal

This object is used to adjust balances between accounts. It is typically used to correct chart of account coding errors (e.g. created invoices for parents against the maths chart of account code when it should have been English).

SIF_Events are reported for this object.

Journal
Figure 3.7.5-1: Journal Journal RefId DebitFinancialAccountRefId CreditFinancialAccountRefId OriginatingTransactionRefId SIF_RefObject Amount GSTCodeOriginal GSTCodeReplacement Note CreatedDate ApprovedDate CreatedBy ApprovedBy LocalCodeList SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharPrivacy RatingDescriptionType
 Journal High

This object is used to adjust balances between accounts. It is typically used to correct chart of account coding errors (e.g. created invoices for parents against the maths chart of account code when it should have been English).

 
 
@
key
RefIdMHigh

Journal Id.

 
RefIdType
 DebitFinancialAccountRefIdMHigh

RefId of account to debit.

 
IdRefType
 CreditFinancialAccountRefIdMHigh

RefId of account to credit.

 
IdRefType
 OriginatingTransactionRefIdOHigh

RefId of the originating transaction which requires adjustment. This could be an Invoice, PaymentReceipt or PurchaseOrder.

 
IdRefType
@SIF_RefObjectMHigh values:
Invoice
PaymentReceipt
PurchaseOrder
 AmountMHigh

Amount to transfer between the two accounts.

 
MonetaryAmountType
 GSTCodeOriginalOHigh

Original GST code for journal transfer (if required).

 
xs:normalizedString
 GSTCodeReplacementOHigh

Replacement GST code for journal transfer (if required).

 
xs:normalizedString
 NoteOHigh

Note about the journal.

 
xs:normalizedString
 CreatedDateOLow

Date on which journal was created.

 
xs:date
 ApprovedDateOLow

Date on which journal was approved.

 
xs:date
 CreatedByOLow

Authority or person who created the journal.

 
xs:normalizedString
 ApprovedByOLow

Authority or person who approved the journal.

 
xs:normalizedString
 LocalCodeListOHigh LocalCodeListType
 SIF_MetadataOHigh SIF_MetadataType
 SIF_ExtendedElementsOHigh SIF_ExtendedElementsType
Table 3.7.5-1: Journal
<Journal RefId="B5739375-800A-C4CC-6385-0BB2754114AA"> <DebitFinancialAccountRefId>8B231144-301C-4D3B-95D4-8BB74C866AE1</DebitFinancialAccountRefId> <CreditFinancialAccountRefId>B7A34E56-1C97-345C-0A4E-11BB112B2753</CreditFinancialAccountRefId> <Amount Currency="AUD">7.00</Amount> <CreatedDate>2015-02-01</CreatedDate> <CreatedBy>Fred Flintstone</CreatedBy> </Journal>
Example 3.7.5-1: Journal

3.7.6 PaymentReceipt

This object complements the Invoice object, and contains information about the payment of an Invoice object.

SIF_Events are reported for this object.

PaymentReceipt
Figure 3.7.6-1: PaymentReceipt PaymentReceipt RefId TransactionType InvoiceRefId VendorInfoRefId DebtorRefId ChargedLocationInfoRefId TransactionDate TransactionAmount ReceivedTransactionId FinancialAccountRefIdList TransactionDescription TaxRate TaxAmount TransactionMethod ChequeNumber TransactionNote AccountingPeriod LocalCodeList SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharPrivacy RatingDescriptionType
 PaymentReceipt High

This object complements the Invoice object, and contains information about the payment of an Invoice object.

 
 
@
key
RefIdMHigh

GUID for this payment or receipt. The application that owns this object is responsible for generating this unique Id.

 
RefIdType
 TransactionTypeMHigh

Type of transaction.

 
values:
GL receipt
GL payment
Creditor receipt
Creditor payment
Debtor receipt
Debtor payment
 InvoiceRefIdOHigh

A pointer back to the Invoice object corresponding to this payment. Is omitted for general ledger transactions, creditor receipts and debtor payments.

 
IdRefType
 VendorInfoRefIdOHigh

A pointer back to the vendor associated with the Invoice object, if applicable.

 
IdRefType
 DebtorRefIdOHigh

A pointer back to the debtor associated with the Invoice object, if applicable.

 
IdRefType
 ChargedLocationInfoRefIdOHigh

Id of the location billed for this transaction.

 
IdRefType
 TransactionDateMHigh

Date transaction was made.

 
xs:date
 TransactionAmountMHigh

Amount received.

 
DebitOrCreditAmountType
 ReceivedTransactionIdMHigh

Memo transaction Id from other vendor software.

 
xs:normalizedString
 FinancialAccountRefIdListOHigh

 

FinancialAccountRefIdListType
 TransactionDescriptionOHigh

Description of the transaction.

 
xs:normalizedString
 TaxRateOHigh

Rate of tax included in the billed amount.

 
xs:decimal
 TaxAmountOHigh

Amount of tax included in the billed amount.

 
MonetaryAmountType
 TransactionMethodOHigh

Method through which transaction was made (e.g. cash, credit card). If a receipt is made using two receipt methods (e.g. $20 in cash and $80 on credit), two PaymentReceipt objects are expected to be created, rather than a single object with mixed receipt method.

 
xs:normalizedString
 ChequeNumberOHigh

The cheque number issued, if paying creditors by cheque.

 
xs:normalizedString
 TransactionNoteOHigh

Note about the receipt or payment.

 
xs:normalizedString
 AccountingPeriodOHigh

The accounting period against which the transaction is billed.

 
LocalIdType
 LocalCodeListOHigh LocalCodeListType
 SIF_MetadataOHigh SIF_MetadataType
 SIF_ExtendedElementsOHigh SIF_ExtendedElementsType
Table 3.7.6-1: PaymentReceipt
<PaymentReceipt RefId="EDF4985A-BC34-58FE-DA75-493AB3812345"> <TransactionType>GL payment</TransactionType> <InvoiceRefId>CA123458-47DE-A974-63FE-B238759FD123</InvoiceRefId> <TransactionDate>1999-10-20</TransactionDate> <TransactionAmount Currency="AUD" Type="Debit">50.00</TransactionAmount> <ReceivedTransactionId>XYZZY</ReceivedTransactionId> <FinancialAccountRefIdList> <FinancialAccountRefId>ED12345F-DA84-9727-5BC2-8AA349DD3721</FinancialAccountRefId> </FinancialAccountRefIdList> </PaymentReceipt>
Example 3.7.6-1: PaymentReceipt

3.7.7 PurchaseOrder

This object provides information down to the line item level for purchase orders.

SIF_Events are reported for this object.

PurchaseOrder
Figure 3.7.7-1: PurchaseOrder PurchaseOrder RefId FormNumber VendorInfoRefId ChargedLocationInfoRefId EmployeePersonalRefId PurchasingItems CreationDate TaxRate TaxAmount TotalAmount UpdateDate FullyDelivered OriginalPurchaseOrderRefId LocalCodeList SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharPrivacy RatingDescriptionType
 PurchaseOrder Low

This object provides information down to the line item level for purchase orders.

 
 
@
key
RefIdMLow

Transaction GUID for this purchasing activity. The application that owns this object and is responsible for generating this unique Id.

 
RefIdType
 FormNumberMLow

Purchase order number.

 
xs:normalizedString
 VendorInfoRefIdMLow

This object references the VendorInfo object being billed.

 
IdRefType
 ChargedLocationInfoRefIdOLow

The location Id for this purchasing activity.

 
IdRefType
 EmployeePersonalRefIdOLow

The employee Id for the originator of this purchasing activity.

 
IdRefType
 PurchasingItemsMLow

 

PurchasingItemsType
 CreationDateOLow

Date on which purchase order was created.

 
xs:date
 TaxRateOLow

Rate of tax included in the billed amount.

 
xs:decimal
 TaxAmountOLow

Amount of tax included in the billed amount.

 
MonetaryAmountType
 TotalAmountOLow

Total amount billed.

 
MonetaryAmountType
 UpdateDateOLow

Date on which the object was last updated.

 
xs:date
 FullyDeliveredOLow

Flag that order has been fully delivered.

 
AUCodeSetsYesOrNoCategoryType
 OriginalPurchaseOrderRefIdOLow

Original purchase order that this purchase order updates (e.g. to cancel line items).

 
IdRefType
 LocalCodeListOHigh LocalCodeListType
 SIF_MetadataOLow SIF_MetadataType
 SIF_ExtendedElementsOLow SIF_ExtendedElementsType
Table 3.7.7-1: PurchaseOrder
<PurchaseOrder RefId="ED12345F-DA84-9727-5BC2-8AA349DD3721"> <FormNumber>00342</FormNumber> <VendorInfoRefId>BD12345F-DA84-9727-5BC2-8AA349DD3723</VendorInfoRefId> <ChargedLocationInfoRefId>ED12345F-DA84-9727-5BC2-8AA349DD3722</ChargedLocationInfoRefId> <EmployeePersonalRefId>AD12345F-DA84-9727-5BC2-8AA349DD3721</EmployeePersonalRefId> <PurchasingItems> <PurchasingItem> <ItemNumber>154486</ItemNumber> <ItemDescription>Floor Wax</ItemDescription> <Quantity>10</Quantity> <UnitCost Currency="AUD">7.00</UnitCost> <ExpenseAccounts> <ExpenseAccount> <AccountCode>10-1100-610</AccountCode> <Amount Currency="AUD">70.00</Amount> </ExpenseAccount> </ExpenseAccounts> </PurchasingItem> </PurchasingItems> </PurchaseOrder>
Example 3.7.7-1: PurchaseOrder

3.7.8 VendorInfo

This object contains basic vendor information (commonly known as creditors).

SIF_Events are reported for this object.

VendorInfo
Figure 3.7.8-1: VendorInfo VendorInfo RefId Name ContactInfo CustomerId ABN RegisteredForGST PaymentTerms BPay BSB AccountNumber AccountName LocalCodeList SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharPrivacy RatingDescriptionType
 VendorInfo Low

This object contains basic vendor information (commonly known as creditors).

 
 
@
key
RefIdMLow

Vendor Id.

 
RefIdType
 NameMLow

Name of the vendor.

 
xs:normalizedString
 ContactInfoOLow

Contact information.

 
ContactInfoType
 CustomerIdOLow

Account number or other Id.

 
xs:normalizedString
 ABNOLow

Australian Business Number.

 
xs:normalizedString
 RegisteredForGSTOLow

The vendor is registered to collect GST.

 
AUCodeSetsYesOrNoCategoryType
 PaymentTermsOLow

The vendors payment terms (typically expressed as number of days e.g. 14 days).

 
xs:normalizedString
 BPayOLow

BPay Id.

 
xs:normalizedString
 BSBOLow

Vendor's BSB number.

 
xs:normalizedString
 AccountNumberOLow

Vendor's account number.

 
xs:normalizedString
 AccountNameOLow

Vendor's account name.

 
xs:normalizedString
 LocalCodeListOHigh LocalCodeListType
 SIF_MetadataOLow SIF_MetadataType
 SIF_ExtendedElementsOLow SIF_ExtendedElementsType
Table 3.7.8-1: VendorInfo
<VendorInfo RefId="AB3647C5-6865-4CF4-5678-DD34EF564E22"> <Name>ABC School Supply</Name> <ContactInfo> <Name Type="LGL"> <FamilyName>Brown</FamilyName> <GivenName>James</GivenName> </Name> <Address Type="0123" Role="2382"> <Street> <Line1>23 E. 43rd St.</Line1> </Street> <City>Chicago</City> <StateProvince>IL</StateProvince> <Country>8104</Country> <PostalCode>60611</PostalCode> </Address> <EmailList> <Email Type="01">jdr@ABC.com</Email> </EmailList> <PhoneNumberList> <PhoneNumber Type="0096"> <Number>(312) 555-1234</Number> </PhoneNumber> </PhoneNumberList> </ContactInfo> <CustomerId>0023556</CustomerId> <ABN>56402325367</ABN> <RegisteredForGST>Y</RegisteredForGST> </VendorInfo>
Example 3.7.8-1: VendorInfo

Valid XHTML 1.0 Transitional