Previous icon

Next icon

luPortalPaymentPlans lookup table

Description

The luPortalPaymentPlans lookup table is used to:

Example

Lookup Table Maintenance - Finance (luPortalPaymentPlans, part 1)

Lookup Table Maintenance - Finance (luPortalPaymentPlans, part 2)

Lookup Table Maintenance - Finance (luPortalPaymentPlans, part 3)

Fields

Fields

Description

PaymentPlanSeq

Unique ID assigned to the payment plan option.

ActiveFlag

Select to enable the currently selected payment plan.

Note: Payment plans with this field selected will only be visible between the PublishStart and PublishStop dates.

Instalments

Number of instalments for the payment plan.

Description

Description provided with the payment plan. This description is displayed on the Portal Payment Plans page.

SchoolAdminister
Discount

Discount percentage if the debtor selects to have the school administer payments.

UserAdminister
Discount

Discount percentage if the debtor selects to administer payments themselves.

PublishStart

Sets the date from which the plan will be available for selection on the portal.

PublishStop

Sets the date after which the plan will no longer be available for selection on the portal.

InstalmentStart
Date

Sets the date of the first instalment.

InstalmentStop
Date

Sets the date of the final payment for plans with multiple instalments.

SortOrder

Order that the payment plans are listed on the Payment Plans page.

FileYear

File year specified for the payment plan.

ParentPayment
OptionsSeq

Links a new payment plan to an older payment plan.

FrequencyCode

A code representing the instalment frequency.

See luDebtorInstalmentFrequency lookup table.

DefaultFlag

Select to set the current payment plan as default when the payment plans are first displayed.

School
Administered
ReviewMessage

Contains the review message if the school is administering payments.

See Creating review messages.

Important: This field must be completed to allow the processing of payment plans.

SelfAdministered
ReviewMessage

Contains the debtor's review message if self-administering is enabled.

See Creating review messages.

Important: This field must be completed to allow the processing of payment plans.

ModifiedDate

Date and time the lookup table entry was last modified.

ModifiedUser

User that last modified the lookup table entry.

Last modified: 8/04/2015 3:40:12 PM

See Also

Maintaining finance lookup tables

luAssetCategory lookup table

luBankCashflowGroup lookup table

luCreditorSupplierCategory lookup table

luCurrency lookup table

luDebtorArrangement lookup table

luDebtorAutoTuition lookup table

luDebtorCashPrepaidGeneralLedger lookup table

luDebtorConcessionType lookup table

luDebtorFeeCategory lookup table

luDebtorInstalmentFrequency lookup table

luDebtorStatementGroup lookup table

luDebtorSubLedger lookup table

luDebtorVoluntaryContributionOverride lookup table

luDeliveryPoint lookup table

luFund lookup table

luGeneralLedgerBudgetForecastPercents lookup table

luGeneralLedgerClassification lookup table

luGeneralLedgerFinanceReport lookup table

luGeneralLedgerHeadingLevel lookup table

luGeneralLedgerRcptAllocations lookup table

luGovernmentReturnCategory lookup table

luItemKitComponents lookup table

luItemUnitOfMeasurement lookup table

luPayrollCategory lookup table

luPayrollChangeReportColumn

luPayrollCodeType lookup table

luPayrollEmployeeLeaveApplicationStatus lookup table

luPayrollEmployeeStatus lookup table

luPayrollLeave lookup table

luPayrollLeaveAward lookup table

luPayrollLeaveSubCategory lookup table

luPayrollPayFrequency lookup table

luPayrollSuperannuationColumns lookup table

luPayrollSuperannuationFund lookup table

luPayrollSuperannuationList lookup table

luPayrollTaxationRate lookup table

luPayrollTerminationReason lookup table

luPurchaseOrderAuthorisationStatus lookup table

luPurchaseOrderUrgency lookup table

luSalesCashDrawer lookup table

luSalesCustomerDisplayUnit lookup table

luTax lookup table

luTaxClassification lookup table

luWestpacResponses lookup table

luWestpacSummaryCodes lookup table

© 2015 Synergetic Management Systems. Published 5 March 2015.

Top of page