MYPTReport

MYOB.AdvancedLive.Objects.AP.DACScreenMYPT3000Release 2025.2

No summary is documented for this DAC in the release source.

89 of 89 fields

	Field Name	Type	Display Name	Foreign Key
	`ABN`	`nvarchar(11)`	ABN	-
Description:No description available
	`ACN`	`nvarchar(9)`	ACN	-
Description:No description available
	`ARBN`	`nvarchar(9)`	ARBN	-
Description:No description available
	`ApprovalDate`	`datetime`	Approval Date	-
Description:No description available
	`ApproverEmail`	`nvarchar(400)`	Approver's Email	-
Description:No description available
	`ApproverFirstName`	`nvarchar(400)`	Approver's First Name	-
Description:No description available
	`ApproverLastName`	`nvarchar(400)`	Approver's Last Name	-
Description:No description available
	`ApproverPhoneNumber`	`nvarchar(50)`	Approver's Phone Number	-
Description:No description available
	`ApproverPosition`	`nvarchar(400)`	Approver's Position	-
Description:No description available
	`AveragePaymentTimeDays`	`decimal`	Average Payment Time	-
Description:No description available
	`BenefitsOfSupplyChainFinanceArrangements`	`nvarchar(1000)`	Benefits Of Supply Chain Finance Arrangements	-
Description:No description available
	`BusinessIndustryCode`	`nvarchar(5)`	Business Industry Code	-
Description:No description available
	`BusinessName`	`nvarchar(400)`	Business Name	-
Description:No description available
	`ChangeLongestActualPaymentPeriod`Default Navigation	`int`	Changes To Longest Actual Payment Period	Terms
Description:No description available
	`ChangeShortestActualPaymentPeriod`Default Navigation	`int`	Change Shortest Actual Payment Period	Terms
Description:No description available
	`ChangesToStandardPaymentPeriod`Default Navigation	`int`	Changes To Standard Payment Period	Terms
Description:No description available
	`ControllingCorporationABN`	`nvarchar(11)`	Controlling Corporation ABN	-
Description:No description available
	`ControllingCorporationACN`	`nvarchar(9)`	Controlling Corporation ACN	-
Description:No description available
	`ControllingCorporationName`	`nvarchar(400)`	Controlling Corporation Name	-
Description:No description available
	`DetailChangeLongestActualPaymentPeriod`	`nvarchar(1000)`	Details On Changes To Longest Actual Payment Period	-
Description:No description available
	`DetailChangeShortestActualPaymentPeriod`	`nvarchar(1000)`	Detail Change Shortest Actual Payment Period	-
Description:No description available
	`DetailEntitesBelowReportingThreshold`	`nvarchar(1000)`	Details About Entities Below Reporting Threshold	-
Description:No description available
	`DetailOfChangeInAccountingPeriod`	`datetime`	Detail Of Change In Accounting Period	-
Description:No description available
	`DetailOfChangeInBusinessName`	`nvarchar(1000)`	Detail Of Change In Business Name	-
Description:No description available
	`DetailsOfChangesToStandardPaymentPeriod`	`nvarchar(1000)`	Details Of Changes To Standard Payment Period	-
Description:No description available
	`ExpectedMaximumPaymentTermDays`Default Navigation	`int`	Expected Payment Term Range - Maximum (Next Period)	Terms
Description:No description available
	`ExpectedMinimumPaymentTermDays`Default Navigation	`int`	Expected Payment Term Range - Minimum (Next Period)	Terms
Description:No description available
	`ExpectedMostCommonPaymentTermDays`Default Navigation	`int`	Expected Most Common Payment Term (Next Period)	Terms
Description:No description available
	`FeesChargedDuringProcurement`	`bit`	Procurement Fees Charged?	-
Description:No description available
	`FileID`	`uniqueidentifier`		-
Description:No description available
	`GeneratedDate`	`datetime`		-
Description:No description available
	`HasPaymentRegulations`	`bit`	Legal Or Voluntary Payment Rules?	-
Description:No description available
	`HeadEntityABN`	`nvarchar(11)`	Head Entity ABN	-
Description:No description available
	`HeadEntityACN`	`nvarchar(9)`	Head Entity ACN	-
Description:No description available
	`HeadEntityName`	`nvarchar(400)`	Head Entity Name	-
Description:No description available
	`Id`	`int`		-
Description:No description available
	`InitialOrganizationID`Nonexistent in DB	`int?`		-
Description:No description available
	`InvoicePracticesAndArrangements`	`nvarchar(1000)`	Invoice Practices And Arrangements	-
Description:No description available
	`LongestActualStandardPaymentPeriod`Default Navigation	`int`	Longest Actual Standard Payment Period	Terms
Description:No description available
	`MedianPaymentTimeDays`	`decimal`	Median Payment Time	-
Description:No description available
	`MostCommonPaymentTermDays`	`int`	Most Common Payment Term	-
Description:No description available
	`MostCommonPaymentTermMaxDays`	`int`	Range of Most Common Payment Terms - maximum	-
Description:No description available
	`MostCommonPaymentTermMinDays`	`int`	Range Of Most Common Payment Terms - minimum	-
Description:No description available
	`NumberInvoicesPaidBetween21And30Days`	`decimal`	Proportion Of Invoices Paid Between 21 And 30 Days (%)	-
Description:No description available
	`NumberInvoicesPaidBetween31And60Days`	`decimal`	Proportion Of Invoices Paid Between 31 And 60 Days (%)	-
Description:No description available
	`NumberInvoicesPaidBetween31And60DaysForSBTCP`	`decimal`	Invoices Paid Between 31-60 Days (%)	-
Description:No description available
	`NumberInvoicesPaidBetween61And90Days`	`decimal`	Proportion Of Invoices Paid Between 61 And 90 Days (%)	-
Description:No description available
	`NumberInvoicesPaidBetween91And120Days`	`decimal`	Proportion Of Invoices Paid Between 91 And 120 Days (%)	-
Description:No description available
	`NumberInvoicesPaidInMoreThan120Days`	`decimal`	Proportion Of Invoices Paid In More Than 120 Days (%)	-
Description:No description available
	`NumberInvoicesPaidOver60DaysForSBTCP`	`decimal`	Invoices Paid Over 60 Days (%)	-
Description:No description available
	`NumberInvoicesPaidWithin20DaysOfReceipt`	`decimal`	Proportion of Invoices Paid Within 20 Days of Receipt (%)	-
Description:No description available
	`NumberInvoicesPaidWithin30DaysForSBTCP`	`decimal`	Invoices Paid Within 30 Days (%)	-
Description:No description available
	`OrganizationID`Default Navigation	`int`	Company	Organization
Description:No description available
	`OtherOrganizationIDs`Default Navigation	`nvarchar(4000)`	Other Companies	Organization
Description:No description available
	`PaymentTime80thPercentileDays`	`int`	80th Percentile Payment Time	-
Description:No description available
	`PaymentTime95thPercentileDays`	`int`	95th Percentile Payment Time	-
Description:No description available
	`PeppolEnabledPaymentPercent`	`decimal`	% Of Peppol Enabled Small Business Procurement	-
Description:No description available
	`PracticesAndArrangementsForLodgingTender`	`nvarchar(1000)`	Practices And Arrangements For Lodging Tender	-
Description:No description available
	`PracticesAndArrangementsToAcceptInvoice`	`nvarchar(1000)`	Practices And Arrangements To Accept Invoice	-
Description:No description available
	`PrincipalGoverningBodyDescription`	`nvarchar(1000)`	Principal Governing Body Description	-
Description:No description available
	`PrincipalGoverningBodyName`	`nvarchar(400)`	Principal Governing Body Name	-
Description:No description available
	`ReceivableTermsComparison`	`char(7)`	Receivable Terms Compared To Most Common Payment Term	-
Description:No description available
	`ReportComments`	`nvarchar(1000)`	Report Comments	-
Description:No description available
	`ReportingPeriodEndDate`	`datetime`	Reporting Period End Date	-
Description:No description available
	`ReportingPeriodStartDate`	`datetime`	Reporting Period Start Date	-
Description:No description available
	`RequirementToUseSupplyChainFinance`	`nvarchar(1000)`	Requirement To Use Supply Chain Finance	-
Description:No description available
	`ResponsibleMemberDeclaration`	`datetime`	Responsible Member Declaration	-
Description:No description available
	`ShortestActualStandardPaymentPeriod`Default Navigation	`int`	Shortest Actual Standard Payment Period	Terms
Description:No description available
	`Show2025Form`Nonexistent in DB	`bool?`		-
Description:No description available
	`ShowOldForm`Nonexistent in DB	`bool?`		-
Description:No description available
	`SmallBusinessPaymentsWithinTermsPercent`	`decimal`	% Of Small Business Payments Made On Time	-
Description:No description available
	`StandardPaymentPeriodInCalendarDays`Default Navigation	`int`	Standard Payment Period In Calendar Days	Terms
Description:No description available
	`SubmitterEmail`	`nvarchar(400)`	Submitter's Email	-
Description:No description available
	`SubmitterFirstName`	`nvarchar(400)`	Submitter's First Name	-
Description:No description available
	`SubmitterLastName`	`nvarchar(400)`	Submitter's Last Name	-
Description:No description available
	`SubmitterPhoneNumber`	`nvarchar(50)`	Submitter' Phone Number	-
Description:No description available
	`SubmitterPosition`	`nvarchar(400)`	Submitter' Position	-
Description:No description available
	`SupplyChainFinanceArrangements`	`nvarchar(1000)`	Supply Chain Finance Arrangements	-
Description:No description available
	`SupplyChainFinanceArrangementsOffered`	`bit`	Supply Chain Finance Offered?	-
Description:No description available
	`TotalNumberSupplyChainFinanceArrangement`	`decimal`	Total Number Of Invoices with Supply Chain Finance Arrangements (%)	-
Description:No description available
	`TotalValueOfSmallBusinessProcurement`	`decimal`	Total Value Of Small Business Procurement (%)	-
Description:No description available
	`TotalValueOfSmallBusinessProcurement2025`	`decimal`	Total Value Of Small Business Procurement	-
Description:No description available
	`TotalValueSupplyChainFinanceArrangements`	`decimal`	Total Value Of Invoices With Supply Chain Finance Arrangements (%)	-
Description:No description available
	`ValueInvoicesPaidBetween21And30Days`	`decimal`	Value Proportion Of Invoices Paid Between 21 And 30 Days (%)	-
Description:No description available
	`ValueInvoicesPaidBetween31And60Days`	`decimal`	Value Proportion Of Invoices Paid Between 31 And 60 Days (%)	-
Description:No description available
	`ValueInvoicesPaidBetween61And90Days`	`decimal`	Value Proportion Of Invoices Paid Between 61 And 90 Days (%)	-
Description:No description available
	`ValueInvoicesPaidBetween91And120Days`	`decimal`	Value Proportion Of Invoices Paid Between 91 And 120 Days (%)	-
Description:No description available
	`ValueInvoicesPaidInMoreThan120Days`	`decimal`	Value Proportion Of Invoices Paid In More Than 120 Days (%)	-
Description:No description available
	`ValueInvoicesPaidWithin20Days`	`decimal`	Value Proportion Of Invoices Paid Within 20 Days (%)	-
Description:No description available