At the moment, only the net payable figure is retrievable.
Surely we should be able to pull up other information related to an obligation period.
All fields in the following 3 database tables are a must:
itb_VATPeriodInformation
,[ClientNo]
,[VATPeriodId]
,[DateDueOrReceived]
,[AmountDue]
,[AmountReceived]
,[AmountOutstanding]
,[ClientType]
itb_VATLiabilities
,[VATPeriodId]
,[VATDueInPeriodOnSalesAndOtherOutputs]
,[VATDueInPeriodOnAcquisitonsFromOtherEC]
,[TotalVATDue]
,[VATReclaimedInThisPeriodOnPurchasesAndOtherInputs]
,[NetVATToBePaidToHMRCOrReclaimed]
,[TotalValueOfSalesAndAllOtherOutputsExcludingVAT]
,[TotalValueOfPurchasesAndAllOtherInputsExcludingVAT]
,[TotalValueOfSuppliesOfGoodsAndRelatedCostsToEC]
,[TotalValueOfAllAcquisitionsOfGoodsToEC]
,[DataEntryComplete]
,[LatestReturnProduced]
,[ReturnSentToClientForSignature]
,[SignedReturnReceivedFromClient]
,[ReturnSentToHMRC]
,[AcknowledgementReceivedFromHMRC]
,[ProcessingDate]
,[PaymentIndicator]
,[ChargeRefNumber]
,[FormBundleNumber]
,[ErrorCode]
,[SubmittedByStaffId]
,[DataOrigin]
itb_VATPeriods
,[ClientNo]
,[StartDate]
,[EndDate]
,[DueDate]
,[PeriodKey]
,[ReceivedDate]
,[VATPeriodStatus]
,[ClientType]
Louis Evangelou
