Hi,
I am struggling to incorporate a logic to read the line 18 and 19.
Test file looks something like this :-
"00016"7"15/06/2015"08/06/2015"19/07/2015"Miss Claire Alvarez"P/2287"Mrs Helen Collins"NONE"22875" 3556.62" 0.00" 482.70" 3073.92"Miss Claire Alvarez"" "00018"5"19/07/2015"P/158807""Charge" 0.00"06/07/2015" 0.00" 0.00" 733.00" 1392.07"2"0" 366.50"N255558"A31885"517880"158807"""""" "00019"5"06/07/2015"P/158807"21"Defer Fees" 658.00"SETF"N255558"A31885"517880"158807""
The existing schema looks something like this :-
<?xml version="1.0" encoding="UTF-8" ?> <xsd:schema targetNamespace="http://www.oneoracle.com/ARInvoices" xmlns:tns="http://www.oneoracle.com/ARInvoices" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd" elementFormDefault="qualified" attributeFormDefault="unqualified" nxsd:version="NXSD" nxsd:stream="chars" nxsd:encoding="ASCII"> <xsd:annotation> <xsd:documentation xml:lang="en"> This schema defines the objects to read and validate Swift AR file from Havering Council. </xsd:documentation> </xsd:annotation> <xsd:element name="Swift_AR"> <xsd:complexType> <xsd:sequence> <xsd:element name="Header" type="tns:HeaderType" minOccurs="0" maxOccurs="1" nxsd:lookFor="1" nxsd:lookAhead="7" nxsd:scanLength="1"/> <xsd:element name="Invoices" type="tns:ARInvoicesType" minOccurs="0" maxOccurs="unbounded" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="ARInvoice" type="tns:ARInvoicesType"/> <xsd:complexType name="HeaderType"> <xsd:sequence> <xsd:element name="BatchHeader" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<"/> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<"/> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<"/> <xsd:element name="BatchNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="NoOfInvoices" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="TotalValueForFile" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DiscFileName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DateCreated" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="TransactionTotal" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Undefined" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" minOccurs="0" /> </xsd:sequence> </xsd:complexType> <xsd:complexType name="ARInvoicesType"> <xsd:sequence> <xsd:element name="InvoiceHeader" minOccurs="1" nxsd:lookFor="2" nxsd:lookAhead="7" nxsd:scanLength="1" > <xsd:complexType> <xsd:sequence> <xsd:element name="DebtorHeader" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="SystemDate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtorId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="PeriodStart" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="PeriodEnd" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="OpeningBalance" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Fees" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Charges" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Receipts" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Adjustments" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Interest" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClosingBalance" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="TotalAccuredDebt" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtToAccrue" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DeferredFees" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="AgreedReceipts" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtorName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClientId" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="PersonInvName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Address" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="InvoiceNo" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ProviderName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="AdjToAccruedDebt" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtorReference" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="InvoiceIdentifier" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClientName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <!--xsd:element name="Undefined" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="LineNumber" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /--> <xsd:element name="Undefined" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" minOccurs="0" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="InvoiceItems3" nxsd:lookFor="3" minOccurs="0" maxOccurs="unbounded" nxsd:lookAhead="7" nxsd:scanLength="1" > <xsd:complexType> <xsd:sequence> <xsd:element name="Receipts" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ReceiptDate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtorId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ReceiptId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Text" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Amount" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Code" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ReceiptNumber" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DivisionOfService" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="CostCentre" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Subjective" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClientId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" minOccurs="0" /> </xsd:sequence> </xsd:complexType> </xsd:element> <!--xsd:element name="InvoiceItems4" nxsd:lookFor="4" minOccurs="0" maxOccurs="unbounded" nxsd:lookAhead="7" nxsd:scanLength="1" > <xsd:complexType> <xsd:sequence> <xsd:element name="InterestHeader" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="InterestToDate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" minOccurs="0" /> <xsd:element name="DebtorId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" minOccurs="0" /> <xsd:element name="InterestId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Text" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Amount" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DivisionOfService" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="CostCentre" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Subjective" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="InterestFrom" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="InterestRate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="NumberOfWeeks" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="NumberOfDays" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClientID" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" minOccurs="0" /> </xsd:sequence> </xsd:complexType> </xsd:element--> <!--xsd:choice minOccurs="1" maxOccurs="unbounded" nxsd:choiceCondition="terminated" nxsd:terminatedBy="""> <xsd:element name="InvoiceItems5" nxsd:conditionValue="(== Charge)"--> <xsd:element name="InvoiceItems5" nxsd:lookFor="5" minOccurs="0" maxOccurs="unbounded" nxsd:lookAhead="7" nxsd:scanLength="1"> <xsd:complexType> <xsd:sequence> <xsd:element name="ChargesHeader" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<"/> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="ChargeToDate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtorId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ChargeId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Charge" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Amount" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ChargeFromDate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="AssessCharge" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="OpenAccrueDebt" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtToAccrue" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClosingAccrueDebt" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="NumberOfWeeks" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="NumberOfNights" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="AssessedDebtToAccrue" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DivisionOfService" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="CostCentre" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Subjective" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClientId" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="C21" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="C22" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="C23" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="C24" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="C25" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" /> </xsd:sequence> </xsd:complexType> </xsd:element> <!--xsd:element name="InvoiceItems8" nxsd:conditionValue="(== Defer Fees)"--> <xsd:element name="InvoiceItems8" nxsd:lookFor="Defer Fees" minOccurs="0" maxOccurs="unbounded" nxsd:lookAhead="32" nxsd:scanLength="1"> <xsd:complexType> <xsd:sequence> <xsd:element name="DeferFeesHeader" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<"/> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="FeeDate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtorId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="FeeId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DeferFees" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Amount" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Code" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DivisionOfService" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="CostCentre" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Subjective" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClientId" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="D15" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" /> </xsd:sequence> </xsd:complexType> </xsd:element> <!--/xsd:choice--> <xsd:element name="InvoiceItems4" nxsd:lookFor="4" minOccurs="0" maxOccurs="unbounded" nxsd:lookAhead="7" nxsd:scanLength="1" > <xsd:complexType> <xsd:sequence> <xsd:element name="InterestHeader" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<"/> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="InterestToDate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" minOccurs="0" /> <xsd:element name="DebtorId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" minOccurs="0" /> <xsd:element name="InterestId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Text" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Amount" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DivisionOfService" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="CostCentre" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Subjective" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="InterestFrom" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="InterestRate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="NumberOfWeeks" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="NumberOfDays" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClientID" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" minOccurs="0" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="InvoiceItems6" nxsd:lookFor="6" minOccurs="0" maxOccurs="unbounded" nxsd:lookAhead="7" nxsd:scanLength="1" > <xsd:complexType> <xsd:sequence> <xsd:element name="AdjHeader" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<"/> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="AdjustmentTo" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtorId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="AdjustmentId" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Text" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Amount" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Reason" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="AdjustmentFrom" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="AdjToAccruedDebt" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DivisionOfService" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="CostCentre" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Subjective" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClientId" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="C16" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="InvoiceItems7" nxsd:lookFor="7" minOccurs="0" maxOccurs="unbounded" nxsd:lookAhead="7" nxsd:scanLength="1" > <xsd:complexType> <xsd:sequence> <xsd:element name="InvoiceFooter" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<"/> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" /> <xsd:element name="SysDate" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="PeriodStart" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="PeriodEnd" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtorName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DebtorId" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="PersonInvName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Address" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="InvoiceNo" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClosingBalance" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="CreditTotal" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ChargeTotal" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="OpeningBalance" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="ClientName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="C17" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" /> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="FileFooter" nxsd:lookFor="0" minOccurs="0" maxOccurs="unbounded" nxsd:lookAhead="7" nxsd:scanLength="1" > <xsd:complexType> <xsd:sequence> <xsd:element name="Blank" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="SequenceNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="RecordType" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="LBH" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="EndOfFile" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="FileName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="C6" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="BatchHeader" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="SequenceNo2" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="RecordType2" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="BatchNo" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="NoOfInvoices" type="xsd:integer" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="TotalValueForFile" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DiscFileName" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="DateCreated" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="TransactionTotal" type="xsd:decimal" nxsd:style="terminated" nxsd:terminatedBy=""" nxsd:quotedBy="<" minOccurs="0" /> <xsd:element name="Undefined" type="xsd:string" nxsd:style="terminated" nxsd:terminatedBy="${eol}" nxsd:quotedBy="<" minOccurs="0" /> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:schema>
I tried to use choiceCondition and conditionValue thing but its not rendering the expected output. The recordType 5 has 2 different schema, one has charge and the other has defer fees text in it. That is the only unique value between the two same recordTypes.
Let me know incase you need more information from my side to help
This is a high priority task so a quick response will be highly appreciated.
Regards, Amit
Ads