ActualLedger

Ledger Actual  represents actual amounts by account within ledger within company or business area.  Actual amounts may be generated in a source application and then loaded to a specific ledger within the enterprise general ledger or budget application.

See http://www.openapplications.org/oagis/9.

Element information

Content

• Sequence [1..1]
  1. LedgerID [0..1]    Identifies the financial ledger to be used when updating balances
  2. DocumentDateTime [0..1]    The date that document was created within the system of record.
  3. AccountingDate [0..1]    Identifies the date, accounting period and financial year. It is also known as the effective or post date
  from group LedgerEntryContent
  Sequence [0..1]
  from group LedgerAmountGroup
  Sequence [0..1]
  1. Amount [0..1]    The monetary value of the object in which the amount is associated
  2. TaxBaseAmount [0..1]    This is the Amount for the associated object expressed in the ledger or base currency
  3. FunctionalAmount [0..1]    The monetary value of the object to which the FunctionalAmount is associated, expressed in the ledger or base currency
  4. TaxBaseFunctionalAmount [0..1]    This is the Tax Amount for the associated object expressed in the ledger or base currency
  5. ExchangeRate [0..1]    ** deprecated in favor of CurrencyExchangeRate ** ExchangeRate is the conversion from one one currency to another currency Identifing the conversion factor and the source in which it was obtained, the date in which the conversion factor was set, and the effective period in which it is to be used.
  6. CurrencyExchangeRate [0..1]    Identifies the exchange rate between two currencies. For the transaction in which this is associated.
  1. GLAccount [0..1]    Is the GLAccount for the associated document and component.
  2. ProjectReference [0..1]    Identifies a project that is associated with the given component.
  3. Item [0..1]    A product or substance that is bought, sold, manufactured, delivered, or is somehow handled in similar business processes. It is the identifier of a "thing".SYNONYMS Material Part Resource Stock Keeping Unit (SKU)
  4. Quantity [0..1]    Identifies the quantity of the item that was specified on the source transaction
  5. EnterpriseUnit [0..1]    Identifies the agiven portion of an organization. Some commonly defined Units are identified here. These units are typically used to track financial data in reporting systems within an organization. Similar to Business Units, Organizational Units are only relevant within an enterprise
  6. Employee [0..1]    Employee information
  7. EntryCreator [0..1]    Is the user enterprise-wide identifier. It is also known as the user code.
  4. GLDestinationEntityID [0..1]    If a value is specified for this and the value is different from the GLSourceEntity, it indicates that the entry is an inter-company transaction
  5. SourceDocumentReference [0..1]    This is the link that ties back to a sub ledger transaction entry ID. It is the identifier of an original/ source transaction or document. The type indicates the type of document i.e. PurchaseOrder, Invoice, Receipt, Credit Memo, Voucher etc. For example, it could be the receipt or the summarized inventory activity. This is the singular field that refers to an audit record. Together with the Sender information, this is part of the referencing system, which will enable drill back audit trail functionality.
  6. ReasonCode [0..1]    Identifies the reason for an activity
  7. TransactionAnalysisCode [0..1]    Is a segmenting code used to analyze accounting transactions. It is commonly used in project accounting applications.
  8. UserArea [0..1]    Allows the user of OAGIS to extend the specification in order to provide additional information that is not captured in OAGIS.This is done by defining the additional information in XML Schema and referencing the new schema in the xml instance document through the use of namespaces. Once this is done the additional information defined there can be carried in the BOD XML instance document.The Open Applications Group will make best efforts to quickly consider all proposed submissions.The USERAREA is always the last element in all components, except where the component has been extended inline.

Attributes

None

Used in

• Type GetActualLedgerDataAreaType (Element DataArea)
• Type GetListActualLedgerDataAreaType (Element DataArea)
• Type ListActualLedgerDataAreaType (Element DataArea)
• Type LoadActualLedgerDataAreaType (Element DataArea)
• Type OAGIS9NounsType (Element OAGIS9Nouns)
• Type ShowActualLedgerDataAreaType (Element DataArea)

Sample instance

<ActualLedger>
   <LedgerID>normalizedString</LedgerID>
   <DocumentDateTime>2000-01-01</DocumentDateTime>
   <AccountingDate>
      <PeriodID>normalizedString</PeriodID>
      <PostDateTime>2000-01-01</PostDateTime>
      <Year>1999</Year>
      <Name>string</Name>
      <EffectiveTimePeriod>
         <InclusiveIndicator>true</InclusiveIndicator>
         <StartDateTime>2000-01-01</StartDateTime>
         <Duration>P1Y2M3DT10H</Duration>
      </EffectiveTimePeriod>
      <UserArea>
         <!--any element-->
      </UserArea>
   </AccountingDate>
   <Amount currencyID="AED">1.0</Amount>
   <TaxBaseAmount currencyID="AED">1.0</TaxBaseAmount>
   <FunctionalAmount currencyID="AED">1.0</FunctionalAmount>
   <TaxBaseFunctionalAmount currencyID="AED">1.0</TaxBaseFunctionalAmount>
   <ExchangeRate>
      <SourceCurrencyCode>AED</SourceCurrencyCode>
      <SourceUnitBaseNumeric>1.0</SourceUnitBaseNumeric>
      <TargetCurrencyCode>AED</TargetCurrencyCode>
      <TargetUnitBaseNumeric>1.0</TargetUnitBaseNumeric>
      <RateNumeric>1.0</RateNumeric>
      <SetDateTime>2000-01-01</SetDateTime>
      <SourceID>normalizedString</SourceID>
      <EffectiveTimePeriod>
         <InclusiveIndicator>true</InclusiveIndicator>
         <StartDateTime>2000-01-01</StartDateTime>
         <Duration>P1Y2M3DT10H</Duration>
      </EffectiveTimePeriod>
      <UserArea>
         <!--any element-->
      </UserArea>
   </ExchangeRate>
   <CurrencyExchangeRate>
      <SourceCurrencyCode>AED</SourceCurrencyCode>
      <SourceUnitBaseNumeric>1.0</SourceUnitBaseNumeric>
      <TargetCurrencyCode>AED</TargetCurrencyCode>
      <TargetUnitBaseNumeric>1.0</TargetUnitBaseNumeric>
      <RateNumeric>1.0</RateNumeric>
      <SetDateTime>2000-01-01</SetDateTime>
      <SourceID>normalizedString</SourceID>
      <EffectiveTimePeriod>
         <InclusiveIndicator>true</InclusiveIndicator>
         <StartDateTime>2000-01-01</StartDateTime>
         <Duration>P1Y2M3DT10H</Duration>
      </EffectiveTimePeriod>
      <UserArea>
         <!--any element-->
      </UserArea>
   </CurrencyExchangeRate>
   <GLAccount>
      <GLNominalAccount>normalizedString</GLNominalAccount>
      <GLElement>
         <Element>string</Element>
      </GLElement>
      <UserArea>
         <!--any element-->
      </UserArea>
   </GLAccount>
   <ProjectReference>
      <ID>normalizedString</ID>
      <ResourceCodes>
         <Code>normalizedString</Code>
      </ResourceCodes>
      <Description>string</Description>
      <Amount currencyID="AED">1.0</Amount>
      <Location>
         <ID>normalizedString</ID>
         <Name>string</Name>
         <Directions>string</Directions>
         <Coordinate>...
         </Coordinate>
         <Address>...
         </Address>
         <Description>string</Description>
         <Note>string</Note>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Location>
      <TimePeriod>
         <InclusiveIndicator>true</InclusiveIndicator>
         <StartDateTime>2000-01-01</StartDateTime>
         <Duration>P1Y2M3DT10H</Duration>
      </TimePeriod>
      <ActivityID>normalizedString</ActivityID>
      <UserArea>
         <!--any element-->
      </UserArea>
   </ProjectReference>
   <Item>
      <ItemID>
         <ID>normalizedString</ID>
         <RevisionID>normalizedString</RevisionID>
         <VariationID>normalizedString</VariationID>
      </ItemID>
      <CustomerItemID>
         <ID>normalizedString</ID>
         <RevisionID>normalizedString</RevisionID>
         <VariationID>normalizedString</VariationID>
      </CustomerItemID>
      <ManufacturerItemID>
         <ID>normalizedString</ID>
         <RevisionID>normalizedString</RevisionID>
         <VariationID>normalizedString</VariationID>
      </ManufacturerItemID>
      <SupplierItemID>
         <ID>normalizedString</ID>
         <RevisionID>normalizedString</RevisionID>
         <VariationID>normalizedString</VariationID>
      </SupplierItemID>
      <UPCID>normalizedString</UPCID>
      <EPCID>normalizedString</EPCID>
      <ServiceIndicator>true</ServiceIndicator>
      <Description>string</Description>
      <Note>string</Note>
      <Classification>
         <Codes>
         </Codes>
         <Description>string</Description>
         <Note>string</Note>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Classification>
      <Specification>
         <ID>normalizedString</ID>
         <Property>...
         </Property>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Specification>
      <HazardousMaterial>
         <ID>normalizedString</ID>
         <MFAGID>normalizedString</MFAGID>
         <TechnicalName>string</TechnicalName>
         <PlacardEndorsement>string</PlacardEndorsement>
         <PlacardNotation>string</PlacardNotation>
         <MarinePollutionLevelCode>normalizedString</MarinePollutionLevelCode>
         <ToxicityZoneCode>normalizedString</ToxicityZoneCode>
         <Temperature unitCode="normalizedString">1.0</Temperature>
         <FlashpointTemperature unitCode="normalizedString">1.0</FlashpointTemperature>
         <PrimaryEntryRoute>string</PrimaryEntryRoute>
         <Description>string</Description>
         <EmergencyContact>...
         </EmergencyContact>
         <UserArea>
            <!--any element-->
         </UserArea>
      </HazardousMaterial>
      <Packaging>
         <ID>normalizedString</ID>
         <Description>string</Description>
         <Note>string</Note>
         <Type>normalizedString</Type>
         <Dimensions>...
         </Dimensions>
         <UPCPackagingLevelCode>normalizedString</UPCPackagingLevelCode>
         <PerPackageQuantity>1.0</PerPackageQuantity>
         <CapacityPerPackageQuantity>1.0</CapacityPerPackageQuantity>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Packaging>
      <CountryOfOriginCode>normalizedString</CountryOfOriginCode>
      <RFID>normalizedString</RFID>
      <SerialNumber>normalizedString</SerialNumber>
      <Lot>
         <LotIDs>...
         </LotIDs>
         <EffectiveTimePeriod>...
         </EffectiveTimePeriod>
         <Quantity>1.0</Quantity>
         <SerialNumber>normalizedString</SerialNumber>
         <RFID>normalizedString</RFID>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Lot>
      <UserArea>
         <!--any element-->
      </UserArea>
   </Item>
   <Quantity>1.0</Quantity>
   <EnterpriseUnit>
      <CostCenterID>normalizedString</CostCenterID>
      <ProfitCenterID>normalizedString</ProfitCenterID>
      <GLEntityID>normalizedString</GLEntityID>
      <GLElement>
         <Element>string</Element>
      </GLElement>
      <UserArea>
         <!--any element-->
      </UserArea>
   </EnterpriseUnit>
   <Employee>
      <ID>normalizedString</ID>
      <Name>string</Name>
      <Description>string</Description>
      <GenderCode>Male</GenderCode>
      <MaritalStatusCode>Divorced</MaritalStatusCode>
      <BirthDateTime>2000-01-01</BirthDateTime>
      <DeathDateTime>2000-01-01</DeathDateTime>
      <AgeMeasure unitCode="normalizedString">1.0</AgeMeasure>
      <LanguageCode>normalizedString</LanguageCode>
      <NationalityCountryCode>normalizedString</NationalityCountryCode>
      <Address>
         <ID>normalizedString</ID>
         <FormatCode>normalizedString</FormatCode>
         <AttentionOfName>string</AttentionOfName>
         <CareOfName>string</CareOfName>
         <AddressLine>string</AddressLine>
         <CitySubDivisionName>string</CitySubDivisionName>
         <CityName>string</CityName>
         <CountrySubDivisionCode>normalizedString</CountrySubDivisionCode>
         <CountryCode>normalizedString</CountryCode>
         <PostalCode>normalizedString</PostalCode>
         <Status>...
         </Status>
         <Preference>...
         </Preference>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Address>
      <Communication>
         <ChannelCode>normalizedString</ChannelCode>
         <UseCode>normalizedString</UseCode>
         <CountryDialing>string</CountryDialing>
         <AreaDialing>string</AreaDialing>
         <DialNumber>string</DialNumber>
         <Extension>string</Extension>
         <Access>string</Access>
         <Preference>...
         </Preference>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Communication>
      <JobTitle>string</JobTitle>
      <JobCode>normalizedString</JobCode>
      <Responsibility>string</Responsibility>
      <DepartmentID>normalizedString</DepartmentID>
      <CategoryCodes>
         <Code>normalizedString</Code>
      </CategoryCodes>
      <CategoryClassification>
         <Codes>
         </Codes>
         <Description>string</Description>
         <Note>string</Note>
         <UserArea>
            <!--any element-->
         </UserArea>
      </CategoryClassification>
      <Qualification>
         <Code>normalizedString</Code>
         <QualificationDateTime>2000-01-01</QualificationDateTime>
         <Description>string</Description>
         <Note>string</Note>
         <EffectiveTimePeriod>...
         </EffectiveTimePeriod>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Qualification>
      <Skill>
         <Code>normalizedString</Code>
         <Name>string</Name>
         <CompetencyCode>normalizedString</CompetencyCode>
         <LastUsedDateTime>2000-01-01</LastUsedDateTime>
         <TrainingDateTime>2000-01-01</TrainingDateTime>
         <EffectiveTimePeriod>...
         </EffectiveTimePeriod>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Skill>
      <Status>
         <Code>normalizedString</Code>
         <Description>string</Description>
         <EffectiveDateTime>2000-01-01</EffectiveDateTime>
         <ReasonCode>normalizedString</ReasonCode>
         <Reason>string</Reason>
         <TimePeriod>...
         </TimePeriod>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Status>
      <Classification>
         <Codes>
         </Codes>
         <Description>string</Description>
         <Note>string</Note>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Classification>
      <UserArea>
         <!--any element-->
      </UserArea>
   </Employee>
   <EntryCreator>
      <ID>normalizedString</ID>
      <GroupID>normalizedString</GroupID>
      <UserAccount>
         <SystemID>normalizedString</SystemID>
         <AccountID>normalizedString</AccountID>
         <AccountType>normalizedString</AccountType>
         <UserAuthorization>...
         </UserAuthorization>
         <UserArea>
            <!--any element-->
         </UserArea>
      </UserAccount>
      <UserArea>
         <!--any element-->
      </UserArea>
   </EntryCreator>
   <GLDestinationEntityID>normalizedString</GLDestinationEntityID>
   <SourceDocumentReference>
      <DocumentID>
         <ID>normalizedString</ID>
         <RevisionID>normalizedString</RevisionID>
         <VariationID>normalizedString</VariationID>
      </DocumentID>
      <AlternateDocumentID>
         <ID>normalizedString</ID>
         <RevisionID>normalizedString</RevisionID>
         <VariationID>normalizedString</VariationID>
      </AlternateDocumentID>
      <DocumentDateTime>2000-01-01</DocumentDateTime>
      <Description>string</Description>
      <Note>string</Note>
      <StatusCode>normalizedString</StatusCode>
      <Status>
         <Code>normalizedString</Code>
         <Description>string</Description>
         <EffectiveDateTime>2000-01-01</EffectiveDateTime>
         <ReasonCode>normalizedString</ReasonCode>
         <Reason>string</Reason>
         <TimePeriod>...
         </TimePeriod>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Status>
      <LineNumber>normalizedString</LineNumber>
      <ItemIDs>
         <ItemID>...
         </ItemID>
         <CustomerItemID>...
         </CustomerItemID>
         <ManufacturerItemID>...
         </ManufacturerItemID>
         <SupplierItemID>...
         </SupplierItemID>
         <UPCID>normalizedString</UPCID>
         <EPCID>normalizedString</EPCID>
      </ItemIDs>
      <Facility>
         <IDs>...
         </IDs>
         <Name>string</Name>
         <Description>string</Description>
         <Note>string</Note>
         <Address>...
         </Address>
         <Coordinate>...
         </Coordinate>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Facility>
      <SerializedLot>
         <ItemQuantity>1.0</ItemQuantity>
         <Lot>...
         </Lot>
         <Disposition>...
         </Disposition>
         <SerialNumber>normalizedString</SerialNumber>
         <ParentSerialNumber>normalizedString</ParentSerialNumber>
         <Description>string</Description>
         <Note>string</Note>
         <UserArea>
            <!--any element-->
         </UserArea>
      </SerializedLot>
      <SalesOrderReference>
         <DocumentID>...
         </DocumentID>
         <AlternateDocumentID>...
         </AlternateDocumentID>
         <DocumentDateTime>2000-01-01</DocumentDateTime>
         <Description>string</Description>
         <Note>string</Note>
         <StatusCode>normalizedString</StatusCode>
         <Status>...
         </Status>
         <ReleaseNumber>normalizedString</ReleaseNumber>
         <LineNumber>normalizedString</LineNumber>
         <ScheduleLineNumber>normalizedString</ScheduleLineNumber>
         <SubLineNumber>normalizedString</SubLineNumber>
         <UserArea>
            <!--any element-->
         </UserArea>
      </SalesOrderReference>
      <PurchaseOrderReference>
         <DocumentID>...
         </DocumentID>
         <AlternateDocumentID>...
         </AlternateDocumentID>
         <DocumentDateTime>2000-01-01</DocumentDateTime>
         <Description>string</Description>
         <Note>string</Note>
         <StatusCode>normalizedString</StatusCode>
         <Status>...
         </Status>
         <ReleaseNumber>normalizedString</ReleaseNumber>
         <LineNumber>normalizedString</LineNumber>
         <ScheduleLineNumber>normalizedString</ScheduleLineNumber>
         <SubLineNumber>normalizedString</SubLineNumber>
         <UserArea>
            <!--any element-->
         </UserArea>
      </PurchaseOrderReference>
      <GroupName>string</GroupName>
      <SequenceCode>normalizedString</SequenceCode>
      <StepID>normalizedString</StepID>
      <StepType>normalizedString</StepType>
      <IssuingParty>
         <PartyIDs>...
         </PartyIDs>
         <AccountID>normalizedString</AccountID>
         <Name>string</Name>
         <Location>...
         </Location>
         <Contact>...
         </Contact>
         <UserArea>
            <!--any element-->
         </UserArea>
      </IssuingParty>
      <OperationReference>
         <DocumentID>...
         </DocumentID>
         <AlternateDocumentID>...
         </AlternateDocumentID>
         <DocumentDateTime>2000-01-01</DocumentDateTime>
         <Description>string</Description>
         <Note>string</Note>
         <StatusCode>normalizedString</StatusCode>
         <Status>...
         </Status>
         <GroupName>string</GroupName>
         <SequenceCode>normalizedString</SequenceCode>
         <StepID>normalizedString</StepID>
         <StepType>normalizedString</StepType>
         <UserArea>
            <!--any element-->
         </UserArea>
      </OperationReference>
      <ReleaseNumber>normalizedString</ReleaseNumber>
      <ScheduleLineNumber>normalizedString</ScheduleLineNumber>
      <SubLineNumber>normalizedString</SubLineNumber>
      <ShipUnitReference>
         <ID>normalizedString</ID>
         <SealID>normalizedString</SealID>
         <Type>normalizedString</Type>
         <FreightItemID>normalizedString</FreightItemID>
         <ShippingTrackingID>normalizedString</ShippingTrackingID>
         <UserArea>
            <!--any element-->
         </UserArea>
      </ShipUnitReference>
      <EffectiveTimePeriod>
         <InclusiveIndicator>true</InclusiveIndicator>
         <StartDateTime>2000-01-01</StartDateTime>
         <Duration>P1Y2M3DT10H</Duration>
      </EffectiveTimePeriod>
      <Item>
         <ItemID>...
         </ItemID>
         <CustomerItemID>...
         </CustomerItemID>
         <ManufacturerItemID>...
         </ManufacturerItemID>
         <SupplierItemID>...
         </SupplierItemID>
         <UPCID>normalizedString</UPCID>
         <EPCID>normalizedString</EPCID>
         <ServiceIndicator>true</ServiceIndicator>
         <Description>string</Description>
         <Note>string</Note>
         <Classification>...
         </Classification>
         <Specification>...
         </Specification>
         <HazardousMaterial>...
         </HazardousMaterial>
         <Packaging>...
         </Packaging>
         <CountryOfOriginCode>normalizedString</CountryOfOriginCode>
         <RFID>normalizedString</RFID>
         <SerialNumber>normalizedString</SerialNumber>
         <Lot>...
         </Lot>
         <UserArea>
            <!--any element-->
         </UserArea>
      </Item>
      <ID>normalizedString</ID>
      <SealID>normalizedString</SealID>
      <Type>normalizedString</Type>
      <FreightItemID>normalizedString</FreightItemID>
      <ShippingTrackingID>normalizedString</ShippingTrackingID>
      <Quantity>1.0</Quantity>
      <UserArea>
         <!--any element-->
      </UserArea>
   </SourceDocumentReference>
   <ReasonCode>normalizedString</ReasonCode>
   <TransactionAnalysisCode>normalizedString</TransactionAnalysisCode>
   <UserArea>
      <!--any element-->
   </UserArea>
</ActualLedger>