FinanceConfig


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SynergyOneHomeDatabase varchar 100 ('dbo.')
EntityName varchar 60 ('')
GLProfitControl varchar 15 ('')
GLDebtorControl varchar 15 ('')
GLCreditorControl varchar 15 ('')
GLYearEndDate datetime 16,3 (getdate())
GLReportingMonthEndDate datetime 16,3 (getdate())
GLInterCompanyControl varchar 15 ('')
DebtorInstalmentsNumber tinyint 1 ((0))
AssetsInstalCode char 1 ('')
EnrolDepositsInstalCode char 1 ('')
DefaultBankCode varchar 15 ('')
BankingConfig.BankCode FK_FinanceConfig_BankingConfig R
Address1 varchar 40 ('')
Address2 varchar 40 ('')
Suburb varchar 40 ('')
State varchar 5 ('')
PostCode varchar 5 ('')
ACN varchar 9 ('')
ARBFlag bit 1 ((0))
Phone varchar 15 ('')
Fax varchar 15 ('')
Email varchar 50 ('')
TaxFlag bit 1 ((0))
TaxExemption varchar 9 ('')
DebtorReceiptPrintFlag bit 1 ((0))
DebtorReceiptsNumber tinyint 1 ((0))
DebtorAgeDays1 smallint 2 ((0))
DebtorAgeDays2 smallint 2 ((0))
DebtorAgeDays3 smallint 2 ((0))
DebtorAgeDays4 smallint 2 ((0))
DebtorAgeDays5 smallint 2 ((0))
DebtorStatementReportSuffix varchar 10 ('')
CreditorSkipInvoiceDescFlag bit 1 ((0))
CreditorRAInvoiceDesc varchar 5 ('INV')
CreditorRACreditDesc varchar 5 ('CNO')
CreditorPostingDefaultDueDate char 1 ('')
CreditorPostingDueDateOride char 1 ('')
CreditorCheque2ndCopy bit 1 ((1))
PayrollYearEndDate datetime 16,3 √ null
PayrollGLClearing varchar 15 ('')
PayrollGLTaxClearing varchar 15 ('')
PayrollGLEFTClearing varchar 15 ('')
PayrollBankCode varchar 15 ('')
PayrollLeaveLoadTaxFreeLimit money 21,4 ((0))
PayrollMinMonthlyEarnSuper money 21,4 ((0))
PayrollGCGroupNumber int 4 ((0))
PayrollGCMnemonic varchar 5 ('')
PayrollGCAuthorisedPerson varchar 50 ('')
PayrollGCContact varchar 50 ('')
PayrollGCContactPhone varchar 15 ('')
PayrollGCContactFax varchar 15 ('')
DebtorAgeMethod varchar 1 ('S')
DebtorReceiptPrintCompanyFlag bit 1 ((0))
FinanceDataStructureVersion smallint 2 ((0))
GLAuditedToDate datetime 16,3 √ null
GLReportingGLYear int 4 ((0))
AssetWrittenDownDate datetime 16,3 √ null
AssetLastDepreciationDate datetime 16,3 √ null
DebtorInstalmentsFrequency varchar 15 ('')
GLDebtorInstUnearnedControl varchar 15 ('')
DebtorContributionAddTotalFlag bit 1 ((1))
DebtorPrintInstalmentsOnceFlag bit 1 ((0))
GLTaxOnIncomeControl varchar 15 ('')
GLTaxOnExpenseControl varchar 15 ('')
GLTaxControl varchar 15 ('')
GLTaxWithheldControl varchar 15 ('')
ABN varchar 11 ('')
ABNDivision smallint 2 ((0))
CharityRegistrationNumber varchar 11 ('')
WithholdingTaxPercentage decimal 8,3 √ ((0))
AutoTaxCalcEnabledFlag bit 1 ((0))
PayrollGCSupplierReference varchar 16 ('')
DebtorAgeMeasurement char 1 ('D')
LastBASDate datetime 16,3 √ null
GLDefaultGLYear int 4 ((0))
DebtorInstalCreateTransFlag bit 1 ((1))
GLAllowBlankTaxCodeFlag bit 1 ((1))
DebtorDupStatementActiveFlag bit 1 ((0))
CreditorEmailRASenderName varchar 100 ('')
CreditorEmailRASenderEmail varchar 100 ('')
CreditorEmailRALayout varchar 2147483647 √ null
CreditorPurchOrdInvRcvItemFlag bit 1 ((0))
DebtorInstalmentsDay tinyint 1 ((0))
GLAssetsIntegratedFlag bit 1 ((0))
GLEnrolDepositsIntegratedFlag bit 1 ((0))
PayrollNormDefaultFirstFlag bit 1 ((0))
CreditorInvShowRcvdItemsFlag bit 1 ((0))
CreditorEmailRACCEmail varchar 100 ('')
GLAllowModifyClosedPostingFlag bit 1 ((1))
CreditorCopyInvDescAutoOKFlag bit 1 ((0))
DebtorShowReceiptsOnInvFlag bit 1 ((0))
DefaultStatementMethod varchar 1 ('S')
CreditorInvPromptPayChequeFlag bit 1 ((0))
BPAYCheckFormula varchar 10 ('')
BPAYMinLengthID int 4 ((6))
PayrollCurrPayAutoLeaveCreate varchar 1 ('A')
BPAYMinLengthStudentID int 4 ((6))
GLCOAMaxLength tinyint 1 ((0))
GLCostCentreMaxLength tinyint 1 ((0))
GLCodeAutoCreateSeparator varchar 1 ('')
GLDescAutoCreateSeparator varchar 3 ('')
GLCodeAutoCreateCOAFirstFlag bit 1 ((1))
DebtorClassChargeUseInstalFlag bit 1 ((0))
DebtorAutoTuitVarChargeFlag bit 1 ((0))
DebtorDefaultReferenceType varchar 3 ('')
CreditorFaxNtfyShowAccCredited bit 1 ((1))
DebtorOverdueLetterMinBalance money 21,4 ((0))
DebtorOverdueLetterBalApplcAll bit 1 ((1))
DebtorOverdueLetterDays1 tinyint 1 ((0))
DebtorOverdueLetterDays2 tinyint 1 ((0))
DebtorOverdueLetterDays3 tinyint 1 ((0))
DebtorOverdueLetterDays4 tinyint 1 ((0))
DebtorOverdueLetterDays5 tinyint 1 ((0))
DebtorOverdueLetterRefDate datetime 16,3 √ null
PayrollLoadCalcOnHolPayFlag bit 1 ((1))
GLBalanceSheetStartsAt varchar 15 ('')
GLLastRestructureYear int 4 ((0))
AssetAutoCreateJournalDepnFlag bit 1 ((0))
AssetAutoCreateJournalSaleFlag bit 1 ((0))
EnrolDepositsCreateRepayeeNote varchar 255 ('')
PayrollEncryptedFlag bit 1 ((0))
PayrollEncryptedDate datetime 16,3 √ null
PayrollEncryptedBy1 varchar 50 ('')
PayrollEncryptedBy2 varchar 50 ('')
PayrollEncryptedHash varchar 40 ('')
PayrollEncryptedChangeRequestBy varchar 50 ('')
PayrollEncryptedChangeRequestDate datetime 16,3 √ null
PayrollEncryptedChangeRequestEncryptFlag bit 1 ((0))
PayrollEncryptedChangeRequestHash varchar 40 ('')
DebtorTransferToDatabaseCode varchar 15 ('')
DebtorTransferFeeCode varchar 15 ('')
CreditorABNSuppliedDefaultFlag bit 1 ((0))
DebtorConcessionOverrideFlag bit 1 ((0))
PayrollPeriodsAdjustSplitAmountFlag bit 1 ((0))
DebtorBillingPeriods tinyint 1 ((0))
DebtorAutoAllocateChargesFlag bit 1 ((1))
DebtorDiscountBaseTaxInclusiveFlag bit 1 ((1))
PayrollATOLodgementRef varchar 20 ('')
DebtorAccrualAccountingFlag bit 1 ((1))
DebtorShowActiveArrangementsFlag bit 1 ((0))
DebtorArchiveDeleteFlag bit 1 ((0))
CreditorPostingControlJournalDetailFlag bit 1 ((0))
GLPostingControlJournalDetailFlag bit 1 ((0))
GLMinAllocationAmountIDRequired money 21,4 ((0))
DebtorReceiptMinAllocationAmountIDRequired money 21,4 ((0))
DebtorSubLedgerActiveFlag bit 1 ((0))
DebtorReferenceUseStudentGivenFlag bit 1 ((0))
CreditorDebtorIntegrationEnabledFlag bit 1 ((1))
GLCreditorDebtorSuspense varchar 15 ('')
DebtorBulkAddMandatoryCampusFlag bit 1 ((0))
PayrollDefaultPayslipNotifyMethod varchar 2 ('P')
PayrollPayslipArchivePath varchar 150 ('')
PayrollPayslipArchiveDatabaseFlag bit 1 ((0))
DebtorStatementArchivePath varchar 255 ('')
TaxInvoiceArchivePath varchar 255 ('')
DebtorOverdueChargesDailyInterestFlag bit 1 ((0))
PayrollEFTPostingDateOffset int 4 ((0))
DebtorClosedOffDate datetime 16,3 √ null
GLDebtorCashEOYUnpaid varchar 15 ('')
AssetsInsuranceNotifyThreshold money 21,4 √ null
AssetsInsuranceNotifyMessage varchar 100 ('')
AssetGLRangeMin varchar 15 ('')
AssetGLRangeMax varchar 15 ('')
AssetGLRangeType varchar 3 ('GL')
AssetCreateThreshold money 21,4 √ null
GLTaxAppropriationControl varchar 15 ('')
PayrollPAYGEmpdupeSeq int 4 ((1))
ForeignCurrencyEnabledFlag bit 1 ((0))
DebtorReceiptPrintExpiredCreditCardDateFlag bit 1 ((0))
ForeignCurrencyExchangeRateMultiplyFlag bit 1 ((1))
PayrollGCEmailFrom varchar 100 ('')
PayrollGCEmailSubject varchar 255 ('')
PayrollGCEmailBody varchar 1000 ('')
DebtorBillingWeeks tinyint 1 ((52))
DebtorStatementDefaultNotifyMethod varchar 2 ('P')
DebtorStatementEmailFromName varchar 100 ('')
DebtorStatementEmailFrom varchar 100 ('')
DebtorStatementEmailSubject varchar 255 ('')
DebtorStatementEmailBody varchar 1000 ('')
DebtorStatementEmailType int 4 ((0))
DebtorStatementBCC varchar 100 ('')
DebtorReceiptEntryShowBalanceFlag bit 1 ((0))
DebtorReceiptEntryCopyBalanceFlag bit 1 ((0))
DebtorStatementStoringEnabledFlag bit 1 ((0))
CreateBASJournalFlag bit 1 ((1))
PayrollHRLinkStartDateFlag bit 1 ((1))
PayrollHRLinkCategoryFlag bit 1 ((1))
PayrollHRLinkAwardFlag bit 1 ((1))
PayrollHRLinkFTEFlag bit 1 ((1))
PayrollLeaveReturnDateIsLastDayFlag bit 1 ((1))
DebtorReceiptChequeUseBSBAccountFlag bit 1 ((0))
PrintedPayslipCreatePDF bit 1 ((1))
PayrollHRLinkPayCodeFlag bit 1 ((1))
DebtorFeesEnrolDepositsIntegratedFlag bit 1 ((0))
PayrollDiscrepanyAllowCustomCheckFlag bit 1 ((0))
PayrollDiscrepanyCheckMissingPayDetailsFlag bit 1 ((0))
PayrollDiscrepanyCheckStaffOnPayrollFlag bit 1 ((0))
PayrollDiscrepanyCheckSuperDetailsFlag bit 1 ((0))
PayrollDiscrepanyCheckSuperAgeFlag bit 1 ((0))
PayrollDiscrepanySuperMaximumAge tinyint 1 ((0))
PayrollUseEventsFlag bit 1 ((1))
AssetDefaultPurchaseDateToPostingDateFlag bit 1 ((0))
SplitPayslipUsingHiddenDelimiterFlag bit 1 ((0))
DebtorReceiptDetailChequeFlag bit 1 ((0))
DebtorReceiptDetailEFTFlag bit 1 ((0))
IRDScheduleUsePaymentAvailableDateFlag bit 1 ((0))
PayrollTimesheetImportProRataFlag bit 1 ((1))
PayrollSuperExportPhoneLeadingQuoteFlag bit 1 ((0))
PayrollDiscepanciesCustomCheck varchar 4000 ('')
GLBankRecMaxMultiMatch int 4 ((3))
MaxPagesPerPayslip int 4 ((1))
PayrollGLSuperContributionTaxClearing varchar 15 ('')
DebtorChargesAllowAllocateToStatementFlag bit 1 ((0))
GLBudgetPeriodOrderFlag bit 1 ((1))
EnrolDepositsApplicationImportReceiptCreateFlag bit 1 ((0))
EnrolDepositsApplicationImportReceiptBankCode varchar 15 ('')
EnrolDepositsApplicationImportReceiptPostingDescription varchar 60 ('')
AssetGLRangeExcludeCSV varchar 255 ('')
DefaultCreditorBankCode varchar 15 √ null
BankingConfig.BankCode FK_FinanceConfig_DefaultCreditorBankCode R
DefaultDebtorBankCode varchar 15 √ null
BankingConfig.BankCode FK_FinanceConfig_DefaultDebtorBankCode R
PayrollAllowTaxFileNumberSearch bit 1 ((0))
GLAdjustClosedPostingsJournalsFlag bit 1 ((0))
BPAYBillerCode varchar 30 ('')
PayrollHRLinkPayCodeMode varchar 1 ('A')
GLReverseJournalDateChangeClosedPostingsFlag bit 1 ((0))
DebtorIncludeGLReceiptsInReceiptGridFlag bit 1 ((1))
DebtorGLReceiptsDefaultDescription varchar 50 ('Receipt')
PayrollFBTExemptType varchar 1 ('')
FinanceConfigSeq int identity 4 √ null
CountryCode varchar 15 ('')
PayrollGovernmentSendBMS varchar 200 ('')
PayrollGovernmentSendWPN varchar 30 ('')
PayrollGovernmentSendAgentNumber varchar 30 ('')
PayrollGovernmentSendAgentABN varchar 11 ('')
PayrollGovernmentSendAgentContactName varchar 50 ('')
PayrollGovernmentSendAgentContactEmail varchar 100 ('')
PayrollGovernmentSendAgentContactPhone varchar 15 ('')
PayrollProcessOTEFlag bit 1 ((0))
PayrollGovernmentSendEnabledFlag bit 1 ((0))
PayrollGovernmentSendTestFlag bit 1 ((0))
PayrollLeaveCalcBasedOn char 1 ('P')
PayrollSuperCalcBasedOn char 1 ('P')

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_FinanceConfig Primary key Asc FinanceConfigSeq

Relationships

Close relationships within degrees of separation