Treasury - PA



Inbound General Ledger Journal InterfaceGLIJ01 User GuideTreasury ERP ProjectINT 054Pennsylvania treasuryRM G-22 Finance BuildingHarrisburg, PA 17120-0018 03/19/2014Document Information and Revision HistoryVersionDateRevision Notes1.01/15/2012Initial Version1.11/24/2012Updated to include document type and line number.1.22/6/2013Added Appendix C which includes additional source system codes.2.03/27/2013Modified chartfield names and included new chartfield – ‘FiscalYear’.Modified root element name.Changed ReceiptDate element to EffectiveDate.Changed TransactionDescription element to not required.Added new elements JournalSource and BatchId at the header level and BankCode at the line level.Set all the elements under SupportingDocument node to be required. Changed TR (Transmittal of Revenue) to RT (Revenue Transmittal) in descriptions.Changed BatchId length from 30 to 14 characters.2.15/16/2013Additional Doc Types added to Appendix A and B. Clarified definition of ‘appropriation’2.26/27/2013Clarified definition of ‘Account’2.36/27/2013Clarified definition of ‘FiscalYear’3.008/21/2013Appendix C – New source system ‘COS’ Commission On Sentencing3.108/21/2013Appendix A – Added new document types ‘VT’, ‘PT’ and ‘OT’4.010/16/2013Appendix A – Added new document type ‘SH’ and replaced ‘VT’ with ‘VR’4.110/16/2013Batch ID description updated5.011/20/2013Appendix A – Removed Source System, ADG “Auditor General” and AGA “Auditor General Allocation Payments.6.001/14/2014Added Appendix D – Interface Validation EditsAppendix A – New Source System “GWL” Great West Life7.002/26/2014Appendix A – Added new document types ‘AW’ and ‘AY’Table of Contents TOC \o "1-3" Document Information and Revision History PAGEREF _Toc377468548 \h 2Interface Overview PAGEREF _Toc377468549 \h 4Interface Guidance PAGEREF _Toc377468550 \h 4Interfacing using Files PAGEREF _Toc377468551 \h 4Interface using Web Services PAGEREF _Toc377468552 \h 5Schema Locations PAGEREF _Toc377468553 \h 5Request Message PAGEREF _Toc377468554 \h 6Sample Request Message PAGEREF _Toc377468555 \h 6Request Detail Node information PAGEREF _Toc377468556 \h 8Acknowledgement Message PAGEREF _Toc377468557 \h 14Sample Acknowledgement Message PAGEREF _Toc377468558 \h 14Response Detail Node information PAGEREF _Toc377468559 \h 15Appendices PAGEREF _Toc377468560 \h 21Appendix A: IES Document Type codes PAGEREF _Toc377468561 \h 21Appendix B: Non IES Document Type codes PAGEREF _Toc377468562 \h 23Appendix C: Source System Codes PAGEREF _Toc377468563 \h 24Appendix D: Interface Validation Edits PAGEREF _Toc377468564 \h 25Interface OverviewThe purpose of this interface is to create journal entries in the PA Treasury system for transactions such as Revenue Transmittals ( revenues that are not sent through AR), Adjustment Memos (correcting revenue postings), EAs (Expenditure Adjustments), Refund of expenditures and Fund transfers. These transactions should be a balanced journal entry, meaning the total debits should equal the total credits. The required information can be transmitted as either an XML file or a webservice call. After the file or message is received and processed, an acknowledgement is sent back with information on transactions received, processed, and rejected. The acknowledgement also includes error messages for rejected transactions that can be used to review and correct the data for resubmission.Interface Guidance Interfacing using FilesFile naming conventions: Each file name needs to be unique. Name should be in XXXXXXSRC<FREEFORM>YYYYMMDDHHMMSSmmm.xml format XXXXXX – The first 6 characters represent the interface name i.e. GLIJ01SRC – The next 3 characters represent the source system code i.e. IES.<FREEFORM> - Free form text, sender can add any value they wish.? Leave blank if not in use.? Length of field can be from 0-10 alphanumeric characters. YYYYMMDD - The date of the transmission in YYYYMMDD format i.e. 20120101.HHMMSS - The time of day when the transmission occurred; it’s a military time format i.e. 162412 for 4:24:12 PM.mmm - This is the milliseconds of the time when the transmission occurred.? This is an optional field..xml – This is the file extension.?????? Example File Names: ??? GLIJ01IES20130101081235.xml – Minimum required in a file name.GLIJ01IES20130101081235123.xml – Includes millisecond.GLIJ01IESFFEX20130101081235123.xml – Includes freeform and milliseconds.Interface using Web ServicesWebservice format:??????? SOAP XMLWebservice limitations:? Additional documentation will be provided concerning the maximum number of chartfield values that can be included on a web service message. Test WSDL:Treasury will provide this to agencies that need to develop against a test instance of this interface.Production WSDL:T.B.D.Schema LocationsRequest:Schema xsd can be found in the collaboration SharePoint portal.Response: Schema xsd can be found in the collaboration SharePoint portal.Request MessageThe request message is used to transmit journal entries to the Pennsylvania Treasury. It is formatted as an XML document and may be submitted via web service or as a XML file via file transfer. All request documents consist of a single document header containing control information and one or more journal entry request data modules consisting of the data elements necessary for creating journal entries. Each journal entry data element sent must be identified by a unique trace id.Sample Request Message<?xml version="1.0"?><GLIJ01Request xmlns=""> <DocumentHeader> <Control class="R"> <InterfaceIdentifier>GLIJ01</InterfaceIdentifier> <SourceSystemCode>IES</SourceSystemCode> <DocumentIdentifier>GLIJ01IES20131230131258</DocumentIdentifier> <DocumentDateTime>2013-12-31T15:07:38.687500-05:00</DocumentDateTime> <ControlCount>1</ControlCount> <ControlAmount>12094.00</ControlAmount> </Control> </DocumentHeader> <InboundJournalEntry> <Header class="R"> <TraceId>JRNL123</TraceId> <EffectiveDate>2014-01-15</EffectiveDate> <DocumentType>EA</DocumentType><JournalSource>EA</JournalSource><BatchId>BATCH00001</BatchId> <Line class="R"> <LineNumber>1</LineNumber> <Fund>001</Fund> <Department>099</Department> <Appropriation>10648</Appropriation> <FiscalYear>2013</FiscalYear> <Account>1300000</Account> <TransactionAmount>12094.00</TransactionAmount> <TransactionDescription>Adjustment</TransactionDescription> <AccountingReference>0056723</AccountingReference> <BankCode>0834</BankCode> <SupportingDocument class="R"> <DocumentNumber>1</DocumentNumber> <Description>Supporting Image</Description> <Type>PO</Type> <Format>IMG</Format> <URL>; </SupportingDocument> </Line> <Line class="R"> <LineNumber>2</LineNumber> <Fund>002</Fund> <Department>012</Department> <Appropriation>10487</Appropriation> <FiscalYear>2013</FiscalYear> <Account>1400000</Account> <TransactionAmount>-12094.00</TransactionAmount> <TransactionDescription>Offset Entry</TransactionDescription> </Line> </Header> </InboundJournalEntry></GLIJ01Request> Request Detail Node informationNode NameGLIJ01RequestParent NodeMin Occur1Max Occurs1DescriptionRoot node of the XML document.Element NameData TypeSizeFormatRequired?DescriptionDocumentHeaderElementYThis is our standard inbound request header that must be present once on every inbound interface document.InboundJournalEntryElementYThis transaction element contains the inbound journal entries data.Node NameDocumentHeaderParent NodeGLIJ01RequestMin Occur1Max Occurs1DescriptionThe DocumentHeader module contains control and detail information for the interface document. There will be one DocumentHeader module per interface document.Element NameData TypeSizeFormatRequired?DescriptionControlElementYThe Control element holds control data for the document, including element counts and amountsNode NameControlParent NodeDocumentHeaderMin Occur1Max Occurs1DescriptionProvides control information for the document, including: the system transmitting the document, a unique identifier for the document in the source system and the number of new journal entry transaction requests in the document.Attribute NameData TypeSizeFormatRequired?DescriptionclassString1UppercaseYValue must always be “R” Element NameData TypeSizeFormatRequired?DescriptionInterfaceIdentifierString6YValue must always be “GLIJ01”.SourceSystemCodeString3YThe three-character abbreviation of the transmitting system. Value will be provided by Treasury. See Appendix C for currently defined Source System Codes.DocumentIdentifierString36NUnique identifier used by the source system to identify the interface document. This value will be echoed back in the acknowledgement response.DocumentDateTimeStringNDate and time when the request was transmitted. DocumentDateTime is a datetime. If this value is not populated then the system will default date and time to the time Treasury loads the data.Format is 2008-10-31T15:07:38.6875000-05:00ControlCountInteger10NTotal count of all InboundJournalEntry elements .ControlAmountDecimal2823.3NThe sum of all positive TransactionAmount Values.Node NameInboundJournalEntryParent NodeGLIJ01RequestMin Occur1Max OccursUnboundedDescriptionContainer for all inbound journal entries being reported.Element NameData TypeSizeFormatRequired?DescriptionHeaderElementThe header record element for a Journal entryNode NameHeaderParent NodeInboundJournalEntryMin Occur1Max Occurs1DescriptionThe Header record element. Each journal entry adheres to a header and line hierarchy. This describes information contained in the header. There can be only one header per journal.Attribute NameData TypeSizeFormatRequired?DescriptionClassString1UppercaseYValue must always be “R” Element NameData TypeSizeFormatRequiredDescriptionTraceIdString36MixedYTraceId is a string that must uniquely identify each InboundJournalEntry sent to PA Treasury for a source system. If there are errors while processing the transactions, the TraceId will enable the agency to identify the transaction on the response to be able to resolve the error and re-submit the transaction for processing.EffectiveDateDate10YYYY-MM-DDYDate for which transactions are to be recorded in PA Treasury general ledger system. For Revenue transactions the date is when agency expects the money in the bank(or the date immediately following the date they know money is in the bank). Ex. – Agency is told on Monday, Dec. 17 of money being wired to the bank on Friday, Dec. 21 – the Receipt date in the file is Dec. 21.?DocumentTypeString2UppercaseYThe document type identifies the business transaction to be posted. Refer to Appendix A and Appendix B for listings of valid values.JournalSourceString3UppercaseYPossible values are TV for Transfer Vouchers, RT for Revenue Transmittal, RE for Refund of Expenditures, EA for Expenditure Adjustment and AM for Adjustment Memos.BatchIdString14MixedNThe 14 digit BatchID is mandatory for: 1) all payroll payment requests from non-IES systems; 2) all journal entries with a Document Type PT (payroll transfer); and, 3) all payment requests from non-IES systems (i.e. Promise) for which Treasury receives detailed payment information and summary entries are posted in SAP.? The BatchID will serve three purposes: 1) Enable Treasury to match payroll net pay payment requests to related payroll transfers to restricted receipt accounts; 2) Enable IES to post appropriate cash entries; 3)?? Assist in reconciling SAP to Treasury.It should consist of a leading zero (0) + the two (2) digit ‘SAP’ business area + an eleven (11) digit unique number.? These elements should be concatenated.? The number should not be reused for payment requests with the exception of payroll.? For payroll journal entries the BatchID should match the BatchID of the related payroll payments.EX: 02100000001001??? Department of Public WelfareLineElementNJournal entry detail line element.Node NameLineParent NodeHeaderMin Occur1Max Occurs99999DescriptionJournal entry detail line.Attribute NameData TypeSizeFormatRequired?DescriptionClassString1UppercaseYValue must always be “R” Element NameData TypeSizeFormatRequiredDescriptionLineNumberString10YUnique identifier for each journal line. Number sequentially starting with 1 up to a maximum value of 99999.FundString3UppercaseYRepresents a grouping of funds established in Funds Management, to enable accounting and reporting to be done by activity or objective in accordance with laws, special regulations, restrictions, or limitations. Example:????????? 001DepartmentString3UppercaseYA Commonwealth agency or department. It is a 3 character string made up of business area and leading zeroes.AppropriationString7UppercaseYRepresents the lowest level source of funding required for budgeting and monitoring.? The appropriation values sent to Treasury should be the first 5 characters of the SAP Fund.? Positions 6-7 of the SAP Fund, which represents the Fiscal Year, should be recorded in the Fiscal Year element.? Positions 8-10 are not used by Treasury.? The field length of the appropriation is 7 to support future growth if deemed necessary.FiscalYearString4UppercaseYFiscal year to which the transaction belongs. For ledgers 40,50, and 60, this field should be 0000.AccountString7UppercaseYClassifies the nature of a transaction. This represents the SAP Commitment Item. For Non-SAP Agencies, map your GL Account to the SAP Commitment Item.TransactionAmountDecimal2823.3YTransaction amount can be positive or negative. Postive amounts will be debits. Negative amounts will be credits.TransactionDescriptionString30MixedNDescription of the transaction.AccountingReferenceString10MixedNThis value represents an accounting document number which is directly related to the payment requisition. (i.e., credit memo document number which reduces the amount to be paid).BankCodeString4UppercaseNBank code is a means of identifying the bank account and modality of a revenue transaction and should only be used with revenue transactions received from IES.SupportingDocumentElementNDocumentation supporting the associated entry for Fiscal Review.Node NameSupportingDocumentParent NodeLineMin Occur0Max Occurs999DescriptionDocumentation supporting the associated entry for Fiscal Review.Attribute NameData TypeSizeFormatRequired?DescriptionClassString1UppercaseYValue must always be “R” Element NameData TypeSizeFormatRequiredDescriptionDocumentNumberString10YUnique identifier for each detail record. Number sequentially starting with 1 up to a maximum value of 999. DescriptionString254MixedYUse to provide explanatory information or additional detail for the specified document.TypeString2UppercaseYIdentifies the content type of the file referenced by the URL. Listof valid types:PO - Purchase OrderCN – ContractIV – InvoiceGR - GrantNew types may be added upon coordination with and approvalfrom Treasury.FormatString3UppercaseYIdentifies the format of the file referenced by the URL. Supportedvalues are: XML – XML documentIMG - Scanned Image or link to agency-hosted document.New formats may be added upon coordination with and approval from Treasury.VerificationValueString40MixedNA 40-character value representing the “digest” result of encryptingthe entirety of the file residing at the location specified in the URLfield using the SHA1 algorithm.The SHA1 algorithm is described in IETF RFC 3174, “US SecureHash Algorithm 1”. This algorithm will be used to verify thecontents of the file have not been tampered with whenever the file is accessed from a Treasury application.URLString254MixedYURL referencing the file providing documentation that supportsthe entry. The URL passed to Treasury must include the full specification of the file path as Treasury willuse the URL directly with no customizations applied.Acknowledgement MessageTreasury Integration Framework automatically responds to the request with an acknowledgement message. The acknowledgement is an XML document containing information on the loading status of request data in the initiating message. Detailed validation messages facilitate correcting invalid data on requests for resubmission.The acknowledgement is returned as a synchronous response when the interface is accessed via its web service integration point and as a file, email message, or both when accessed via its file integration point.Sample Acknowledgement Message<?xml version="1.0"?><Acknowledgement xmlns=""> <DocumentHeader> <Control class="R"> <InterfaceIdentifier>GLIJ01</InterfaceIdentifier> <SourceSystemCode>PAT</SourceSystemCode> <DocumentIdentifier>GLIJ01PAT20140101100000</DocumentIdentifier> <DocumentDateTime>2014-01-01T10:00:38.687500-05:00</DocumentDateTime> <ResponseCode>001A</ResponseCode> <ReceiveCount>1</ReceiveCount> <ErrorCount>0</ErrorCount> <AcceptCount>1</AcceptCount> <RejectCount>0</RejectCount> <RequestDocumentIdentifier>GLIJ01IES20131230131258</RequestDocumentIdentifier> <RequestDateTime>2013-12-31T15:07:38.687500-05:00</RequestDateTime> <RequestSystemCode>IES</RequestSystemCode> <RequestFilename>GLIJ01IES20131230131258.xml</RequestFilename> <Message class="R"> <MessageNumber>10000</MessageNumber> <MessageSet>11</MessageSet> <Severity>M</Severity> <Text>File Load Successful</Text> </Message> </Control> </DocumentHeader> <DataModule> <Reference class="R"> <TraceId>JRNL123</TraceId> <ErrorFlag>N</ErrorFlag> <SystemReferenceOne>00012345</SystemReferenceOne> </Reference> </DataModule><DataModule> <Reference class="R"> <TraceId>JRNL123</TraceId> <ErrorFlag>N</ErrorFlag> <SystemReferenceOne>00012345</SystemReferenceOne> <SystemReferenceTwo>2</SystemReferenceTwo> </Reference> </DataModule> </Acknowledgement>Response Detail Node informationNode NameAcknowledgementParent NodeMin Occur1Max Occurs1DescriptionRoot node of the XML document.Attribute NameData TypeSizeFormatRequired?DescriptionElement NameData TypeSizeFormatRequired?DescriptionDocumentHeaderElementYOur standard response header for inbound interfaces.DataModuleElementNDetailed error messages on each transaction.Node NameDocumentHeaderParent NodeAcknowledgementMin Occur1Max Occurs1DescriptionStandard header response for inbound interfaces.Attribute NameData TypeSizeFormatRequired?DescriptionElement NameData TypeSizeFormatRequired?DescriptionControlElementYIncludes counts of transactions received, processed and rejected.Node NameControlParent NodeDocumentHeaderMin Occur1Max Occurs1DescriptionThe Control node includes counts of transactions received, processed and rejected.Attribute NameData TypeSizeFormatRequired?DescriptionclassString1UppercaseYValue must always be “R” Element NameData TypeSizeFormatRequired?DescriptionInterfaceIdentifierString6YAlways will be “GLIJ01”SourceSystemCodeString3YThe three-character abbreviation of the transmitting organization/agency. This will usually be PAT, for PA Treasury. DocumentIdentifierString36YIdentifier to uniquely identify this acknowledgement.DocumentDateTimeStringYDate and time when the response is transmitted. DocumentDateTime is a datetime.ResponseCodeString4YA four character alphanumeric code indicating the overall processing of request data.Valid Values :001A All Data Accepted001E Processing Error001R Some Data Rejected001X All Data RejectedReceiveCountInteger10YIdentifies number of InboundJournalEntry elements received.ErrorCountInteger10YIdentifies number of InboundJournalEntry elements that had errors.AcceptCountInteger10YIdentifies number of InboundJournalEntry elements that were accepted and processed.RejectCountInteger10YIdentifies number of InboundJournalEntry elements that were rejected due to data errors.RequestDocumentIdentifierString36NThis is the original DocumentIdentifier that was sent on the inbound interface request. Value will be included if it was sent on the inbound request.RequestDateTimeStringNDate and time from the original request. The date time will be the same as the inbound DocumentHeader DocumentDateTime.RequestSystemCodeString30NThe three-character abbreviation of the transmitting system. The value will be same as the value of SourceSystemCode under Control element from the request.RequestFilenameString80NName of original file processed. It will be blank when the interface is accessed via web service.MessageElementNStandard response message with information about processing results.Node NameMessageParent NodeControlMin Occur0Max OccursUnboundDescriptionStandard response message for inbound interfaces. This will include messages related to processing the request. Attribute NameData TypeSizeFormatRequired?DescriptionclassString1UppercaseYValue must always be “R” Element NameData TypeSizeFormatRequired?DescriptionMessageNumberInteger5YThis is a PA Treasury generated error message subset number.MessageSetInteger5YThis is a PA Treasury generated error message set number.SeverityString1YSeverity of message. Values are:E – Error: the issue identified in the referenced data element will prevent the entire request from being processed.M – Message: the message is informational only.W – Warning: the issue with the referenced data element will not prevent the request from being processed.TextString254YText description of the message.Node NameDataModuleParent NodeAcknowledgementMin Occur0Max OccursUnboundedDescriptionDataModule includes messages related to transaction processing.Attribute NameData TypeSizeFormatRequired?DescriptionElement NameData TypeSizeFormatRequired?DescriptionReferenceElementYReferences identifying data sent on the inbound request for each transaction that was processed and related messages.Node NameReferenceParent NodeDataModuleMin Occur1Max Occurs1DescriptionReferences identifying data sent on the inbound request for each transaction that was processed and related messages.Attribute NameData TypeSizeFormatRequired?DescriptionClassString1UppercaseYValue must always be “R” Element NameData TypeSizeFormatRequired?DescriptionTraceIdString36YTraceId sent on the inbound request for each transaction that was processed.TraceIdTwoString36YNot Implemented.ErrorFlagString1YShows if there was an error in the transaction, Valid values are “Y” and “N”. If there ia an error associated with the TraceId the value will be passed as “Y”SystemReferenceOneString20NValue of Journal ID generated in PA Treasury system for TraceId field SystemReferenceTwoString20NNot implemented on this interface.SystemReferenceThreeInteger20NNot implemented on this interface.SystemReferenceFourInteger20NNot implemented on this interface.ValidationMessageElementNStandard transactional data message response for inbound interfaces.Node NameValidationMessageParent NodeReferenceMin Occur0Max OccursUnboundedDescriptionValidataionMessage includes all errors, warnings and messages for elements within the transaction.Attribute NameData TypeSizeFormatRequired?DescriptionClassString1UppercaseYValue must always be “R” Element NameData TypeSizeFormatRequired?DescriptionMessageNumberInteger5NThis is a PA Treasury generated error message sub-set number.MessageSetInteger5NThis is a PA Treasury generated error message set number.SeverityString1NSeverity of message. Values are:E – Error: the issue identified in the referenced data element will prevent the transaction from being processed.M – Message: the message is informational only.W – Warning: the issue with the referenced data element will not prevent the transaction from being processed.TextString254NText description of the warning, error or message.RecordNameString30YName of the node that contains the element for which the ValidationMessage was generated.RecordReferenceOneString10NNot implemented for this interface.RecordReferenceTwoString10NNot implemented for this interface.RecordReferenceThreeString10NNot implemented for this interface.FieldNameString30YName of the element for which the ValidationMessage was generated.FieldValueString254NInput value received on the element.AppendicesAppendix A: IES Document Type codesSAP DOC TYPEDESCRIPTIONPURPOSE OR TRIGGERZDVendor Adjustment InvoiceUsed to record debit offset entry for subrecipient payments posted by Interface or Conversion program where payment is a positive amount. AMAdjustment MemoAccounting adjustment moving revenues from one account, fund, appropriation, cost center, etc. to another. AMs are used to adjust existing revenues, not for recording new revenues.EAExpense AdjustmentAccounting adjustment moving expenditures/expenses from one account, fund, appropriation, cost center, etc. to another. EAs are used to adjust existing expenditures, not for recording new expenditures.EBExp Adj - Work CompUsed to reclass Work Comp (Act 534 and Heart & Lung) expenses from a general restricted receipt account back to the employees' agency. ZOPayroll Default Cost Center Correction & Leave Payout EA Used for journal entries that will manually correct payroll posting made to the payroll default cost center and fund. These corrections will be an expense to expense postingWFProduction Order CostingUsed for recording consumption of materials in the Sign Shop production orders. Used for recording inventory produced in the Sign Shop production order. GTStatutory TransferSeparate document type used for Statutory Transfers which require the Governor's designee's signature.SPSAP TV Credit RevenuePost inter- and intra- agency transfers crediting a Revenue commitment item.LBPCard InterfaceAutomated transaction to distribute Purchasing Card amounts billed to the correct agency and funding source..LTTravel Card InterfaceAutomated transaction to distribute Purchasing Card amounts billed to the correct agency and funding source. RTRevenue TransmittalReceipt of Revenue.RERefund of ExpenditureEntry to record refunds of expenditures which offset previously recorded expenditures.WA Goods IssueMovement of Inventory from an inventory account to an expense Transfer VoucherTransfer of funds between appropriations or funds. Transfers can be statutorily required or be based on management decision.ZX Payroll Expense AdjustmentEntry to record payroll expenses.VR Vendor ExpendituresTo record expenditures for individual payments processed in Non-IES sub-systemsPT Payroll TransfersPayroll Transfers for Non-IES systemsOT Other TransfersOther Transfers for Non-IES systemsSHAuthorized Advancement Account Balance Appropriation AdjustmentTo roll forward the authorized advancement account balance from one appropriation to anotherAWAdvancement Account Close DecAdvancement Account – Close or Decrease Authorized Balance without Remittance. Close an advancement account or decrease the authorized balance of an existing account when funds are pulled from the account by Treasury and refunded to the Commonwealth.AYAdvancement Account Close DecAdvancement Account – Close or Decrease Authorized Balance with Remittance. Close an advancement account or decrease the authorized balance of an existing account when a check is written from the account by Treasury and refunded to the Commonwealth.Appendix B: Non IES Document Type codesSAP DOC TYPEDESCRIPTIONPURPOSE OR TRIGGERAMAdjustment MemoAccounting adjustment moving revenues from one account, fund, appropriation, cost center, etc. to another. AMs are used to adjust existing revenues not for recording new revenues.RERefund of ExpenditureEntry to record refunds of expenditures which offset previously recorded Transfer of fundsTransfer of funds between appropriations or funds.. Transfers can be statutorily required or based on agency management decision.EAExpense Adjustment. Accounting adjustment moving expenditures/expenses from one account, fund, appropriation, cost center, etc. to another. EAs are used to adjust existing expenditures/expenses, not to for recording new expenditures/expenses. RT Revenue TransmittalReceipt of cash recorded as revenue.Appendix C: Source System CodesSource SystemCodeSource System DescriptionATPAutomobile Theft Prevention AuthorityBDDLabor and Industry BDD Travel ReimbursementsBFRLiquid FuelsCOSCommission On SentencingEDUEducationGPFTreasury FinancialsGPPTreasury PayrollGWLGreat West LifeHIPHIPP (DPW)ICFIntergovernmental Cooperative Authority (financials)ICPIntergovernmental Cooperative Authority (payroll)IESIntegrated Enterprise Systems (formerly the SAP source system)IFPInsurance Fraud Prevention AuthorityLCBLiquor Control BoardLDFLDPC Financials LDPLDPC Payroll LIHLIHEAP (DPW)PHEPennsylvania Higher Education AgencyPMEPMERS AnnuitantsPROPROMISe (DPW)PSEPSERS AnnuitantsREVRevenueSERSERS AnnuitantsSWISWIFTAPTuition Account ProgramTSCThaddeus Steven College of TechnologyUCDUnemployment CompensationUCPUnclaimed PropertyUJS AOPC/UJS WCPWorkers CompensationAppendix D: Interface Validation EditsNodeElementMessageSetMessageNumberSeverityTextSchema Validation Messages - occur in the DocumentHeader.Control.Message node:VariousVarious2400027205ErrorLine %1 Col %2: Invalid root node [%3]VariousVarious2400027206ErrorLine %1 Col %2: Invalid child element [%3] for parent element [%4]VariousVarious2400027207ErrorLine %1 Col %2: Incorrect end tag [%3] for element [%4]VariousVarious2400027208ErrorLine %1 Col %2: Node element cannot take a value [%3]VariousVarious2400027209ErrorLine %1 Col %2: Element [%3] value exceeds maximum length [%4]VariousVarious2400027210ErrorLine %1 Col %2: Element [%3] invalid date value [%4]VariousVarious2400027211ErrorLine %1 Col %2: Element [%3] invalid datetime value [%4]VariousVarious2400027212ErrorLine %1 Col %2: Element [%3] invalid numeric value [%4]VariousVarious2400027213ErrorLine %1 Col %2: Element [%3] missing or invalid class attribute.VariousVarious2400027214ErrorLine %1 Col %2: Element [%3] unescaped special character [%4]VariousVarious2400027220ErrorLine %1 Col %2: Element [%3] occurence [%4] exceeds maximum allowed [%5]VariousVarious2400027221ErrorLine %1 Col %2: Node [%3] Element [%4] occurences [%5] less than min allowed [%6]??????Document Controls Validation Messages - occur in the DocumentHeader.Control.Message node:ControlControlAmount240051001ErrorInvalid ControlCount [%1] - not equal to the count of InboundJournalEntry elements [%2]ControlControlCount240051002ErrorInvalid ControlAmount [%1] - not equal to the sum of all positive TransactionAmount values [%2]ControlSourceSystemCode240051003ErrorInvalid or inactive SourceSystemCode [%1]??????Data Validation Messages - occur in the DataModule.Reference.ValidationMessage node:HeaderBatchId2400510009ErrorMissing BatchId - required for DocumentType of TVHeaderDocumentType2400011005ErrorMissing Required valueHeaderDocumentType2400510008ErrorInvalid DocumentType - not valid for source systemHeaderEffectiveDate2400011005ErrorMissing Required valueHeaderEffectiveDate2400510004ErrorInvalid EffectiveDateHeaderEffectiveDate2400510005ErrorInvalid EffectiveDate - not in Open PeriodHeaderJournalSource2400011005ErrorMissing Required valueHeaderTraceId2400510001ErrorMissing TraceIdHeaderTraceId2400510002ErrorInvalid TraceId - duplicate valueHeaderTraceId2400510003ErrorInvalid JournalEntry - minimum of two lines are requiredHeaderTraceId2400510006ErrorInvalid JournalEntry - not balancedLineAccount2400011001ErrorInvalid valueLineAccount2400512002ErrorInvalid AccountLineAccount2400011005ErrorMissing Required valueLineAppropriation2400011005ErrorMissing Required valueLineAppropriation2400011001ErrorInvalid valueLineDepartment2400011005ErrorMissing Required valueLineDepartment2400011001ErrorInvalid valueLineDepartment2400512003ErrorInvalid Department - source system does not have access to this departmentLineFiscalYear2400011005ErrorMissing Required valueLineFiscalYear2400011001ErrorInvalid valueLineFund2400011001ErrorInvalid valueLineFund2400011005ErrorMissing Required valueLineTransactionAmount2400011005ErrorMissing Required valueSupportingDocumentFormat2400011002ErrorInvalid Translate valueSupportingDocumentType2400011002ErrorInvalid Translate value ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download