Appendix - Audited Fields

Appendix - Audited Fields

The audit log module will record changes to only the following data tables/fields:

Supplier Account

PLSupplierAccount
Reference
Name
ShortName
Balance
CreditLimit
SYSCurrencyID
SYSCurrency
SYSExchangeRateTypeDbKey
SYSExchangeRateType
SYSCountryCodeDbKey
SYSCountryCode
PLFactorHouseDbKey
PLFactorHouse
DefaultSYSTaxRateDbKey
DefaultSYSTaxRate
TaxRegistrationCode
MonthsToKeepTransactions
OrderPriority
DefaultNominalAccountNumber
DefaultNominalCostCentre
DefaultNominalDepartment
SYSAccountTypeDbKey
SYSAccountType
PLPaymentGroupDbKey
PLPaymentGroup
EarlySettlementDiscountPercent
EarlySettlementDiscountDays
PaymentTermsDays
SYSPaymentTermsBasisDbKey
SYSPaymentTermsBasis
OnHold
PendingNotificationDocumentsValue
DateOfLastTransaction
EuroReference
EuroCreationDate
UseTransactionEMail
SYSCreditBureauDbKey
SYSCreditBureau
SYSCreditPositionDbKey
SYSCreditPosition
TradingTerms
CreditReference
AccountOpened
LastCreditReview
NextCreditReview
ApplicationDate
DateReceived
TermsAgreed
OpLock
DateTimeCreated
SpareText1
SpareText2
SpareText3
SpareNumber1
SpareNumber2
SpareNumber3
SpareDate1
SpareDate2
SpareDate3
SpareBit1
SpareBit2
SpareBit3
MainTelephoneAreaCode
MainTelephoneCountryCode
MainTelephoneSubscriberNumber
MainFaxAreaCode
MainFaxCountryCode
MainFaxSubscriberNumber
MainWebsite
CBDirectDebitTrans
PCAnalysisFieldValues
PLAccountMemos
PLAllocationHeaders
PLHistoricalSupplierTrans
PLPendSupplierBatchTrans
PLPendSupplierTrans
PLPostedSupplierTrans
PLProposedPayments
PLSupplierAnalysisHeadValues
PLSupplierAttachments
PLSupplierBanks
PLSupplierContacts
PLSupplierDocuments
PLSupplierFactorHouses
PLSupplierLocations
PLSupplierPeriodValues
PLSupplierYearValues
POPInvCredDisputes
POPOrderReturns
POPOrderReturnArchs
POPToReorderWarehouses
StockItemSuppliers
TEMSupplierMappings
TEMSuppProdMappings
TSClaimSheets
TSHumanResources
SupplierPaymentGroup
FactorHouse
SupplierFactorHouse
Attachments
SupplierBanks
AnalysisHeadingValues
EuroTrader
SupplierMemos
SupplierDocumentTerms
StandingOrdersAndDirectDebits
PendingBatchItems
Contacts
DefaultTraderContact
DefaultContact
SourceNominalCode
MainAddress
TradingAccount
CreditInfo
CountryCode
DefaultTaxCode
ContactNumbers
DocumentTypes
CheckBalancesHelper
MainTelephone
MainFax
EMails
URLs
SetModificationDate
PaymentGroup
PostedPurchaseAccountEntries
ProposedSmallAmountWriteOffEntries
NonQueriedEntries
PendingPurchaseEntries
ArchivedPurchaseEntries
PostedEntries
PendingEntries
ArchivedEntries
AllocationSessions
TradingAccountPeriodBalances
AgedBalances
Currency
SYSCreditPositionForCreditInfo
SYSCreditBureauForCreditInfo
TraderCreditMemoNote

Supplier Bank Address

Address Line 1
Address Line 2
Address Line 3
Address Line 4
Postcode
Website

Supplier Bank Details

Sort Code
Account Number
Account Name
Bank Payment reference

Customer Account

SLCustomerAccount
Reference
Name
ShortName
Balance
CreditLimit
SYSCurrencyID
SYSCurrency
SYSExchangeRateTypeDbKey
SYSExchangeRateType
SYSCountryCodeDbKey
SYSCountryCode
DefaultSYSTaxRateDbKey
DefaultSYSTaxRate
TaxRegistrationCode
MonthsToKeepTransactions
OrderPriority
SLFinanceChargeDbKey
SLFinanceCharge
DefaultNominalAccountNumber
DefaultNominalCostCentre
DefaultNominalDepartment
SYSAccountTypeDbKey
SYSAccountType
EarlySettlementDiscountPercent
EarlySettlementDiscountDays
PaymentTermsDays
SYSPaymentTermsBasisDbKey
SYSPaymentTermsBasis
UseConsolidatedBilling
LineDiscountPercent
InvoiceDiscountPercent
SLAssociatedOfficeTypeDbKey
OfficeType
AssociatedHeadOfficeAccountDbKey
AssociatedHeadOfficeAccount
ProduceStatementsForCustomer
CustomerDiscountGroupID
CustomerDiscountGroup
PriceBandID
PriceBand
OrderValueDiscountID
OrderValueDiscount
OnHold
PendingNotificationDocumentsValue
DateOfLastTransaction
EuroReference
EuroCreationDate
UseTransactionEMail
DateFinanceChargeLastRun
SYSCreditBureauDbKey
SYSCreditBureau
SYSCreditPositionDbKey
SYSCreditPosition
TradingTerms
CreditReference
AverageTimeToPay
AccountOpened
LastCreditReview
NextCreditReview
ApplicationDate
DateReceived
TermsAgreed
UseTaxCodeAsDefault
OpLock
DateTimeCreated
AvgTimeToPayDateLastUpdated
SpareText1
SpareText2
SpareText3
SpareNumber1
SpareNumber2
SpareNumber3
SpareDate1
SpareDate2
SpareDate3
SpareBit1
SpareBit2
SpareBit3
DUNSCode
MainTelephoneAreaCode
MainTelephoneCountryCode
MainTelephoneSubscriberNumber
MainFaxAreaCode
MainFaxCountryCode
MainFaxSubscriberNumber
MainWebsite
CBDirectDebitTrans
CustDeliveryAddresss
INVInvoiceCredits
PCAnalysisFieldValues
SLAccountMemos
SLAllocationHeaders
Customers
SLCustomerAccountAttachments
SLCustomerAnalysisHeadValues
SLCustomerCardReferences
SLCustomerContacts
SLCustomerDocuments
SLCustomerLocations
SLCustomerPeriodValues
SLCustomerYearValues
SLHistoricalCustomerTrans
SLPendCustomerBatchTrans
SLPendCustomerTrans
SLPostedCustomerTrans
SOPInvoiceCredits
SOPInvoiceCreditArchs
SOPOrderReturns
SOPOrderReturnArchs
SOPSettings
SOPSettings_CashOrderAccountID
TEMCustomerMappings
TEMCustProdMappings
FinanceCharge
CustomerStatementSettings
CustomerDocumentTerms
AnalysisHeadingValues
Attachments
EuroTrader
CustomerMemos
StandingOrdersAndDirectDebits
PendingBatchItems
Contacts
DefaultTraderContact
DefaultContact
CustomerCardReferences
SourceNominalCode
MainAddress
TradingAccount
CreditInfo
CountryCode
DefaultTaxCode
ContactNumbers
DocumentTypes
CheckBalancesHelper
MainTelephone
MainFax
EMails
URLs
SetModificationDate
PostedSalesAccountEntries
PendingSalesEntries
ArchivedSalesEntries
ProposedBadDebtProvisionCorrectionEntries
ProposedSmallAmountWriteOffEntries
NonQueriedEntries
PostedEntries
PendingEntries
ArchivedEntries
AllocationSessions
TradingAccountPeriodBalances
AgedBalances
Currency
SYSCreditPositionForCreditInfo
SYSCreditBureauForCreditInfo
TraderCreditMemoNote
Branches
StatementDocument
HeadOfficeTrader
StatementLayoutType
InvoiceDocument
CreditNoteDocument
OrderDocument

Sales Orders

AssociatedCredits
AssociatedInvoices
CanFullPaymentBeMade
CanPartPaymentBeMade
PaymentDeclared
PaymentUndeclared
DeclaredPaymentRemaining
OriginalPaymentValue
OriginalPaymentMethod
OnlinePaymentValueVariance
ThrowSingleBatchError
TaxSummary
AlwaysRecalculateOrderLines
AbsSubtotalDiscountValue
DocumentToBaseCurrencyRate
DocumentDiscountValue
DiscountOrSurchargeType
PaymentDetails
OrderConversionSummary
AnalysisCodes
CurrencyCoordinator
TaxOnlyDocument
CardEntryLinks
CardEntries
PricingCustomer
LinesReadyToPrint
SOPOrderReturn
DocumentTypeDbKey
DocumentType
DocumentDate
DocumentStatus
DocumentPrintStatus
CustomerDocumentNo
Customer
CustomerType
RequestedDeliveryDate
PromisedDeliveryDate
WarehouseDbKey
Warehouse
CurrencyDbKey
Currency
ExchangeRate
UseInvoiceAddress
PaymentWithOrder
PaymentTypeDbKey
PaymentType
PaymentValue
PaymentReference
PaymentBankAccountDbKey
PaymentBankAccount
PaymentNominalAccountRef
PaymentNominalCostCentre
PaymentNominalDepartment
PaymentNominalCodeDbKey
PaymentNominalCode
PaymentInvoiced
SettlementDiscPercent
SettlementDiscountDays
DocumentDiscountPercent
DocumentCreatedBy
Priority
AnalysisCode1
AnalysisCode2
AnalysisCode3
AnalysisCode4
AnalysisCode5
AnalysisCode6
IntrastatStatus
SourceTypeDbKey
SourceType
SourceDocumentNo
ArePricesTaxInclusive
ReadyForInvoicePrint
DocumentDueDate
PaymentMethodDbKey
PaymentMethod
BOMDetailsOnDespatchNote
PaymentMethodName
OpLock
DateTimeCreated
SpareText1
SpareText2
SpareText3
SpareNumber3
SpareDate1
SpareDate2
SpareDate3
SpareBit1
SpareBit2
SpareBit3
ExternalReference
InvoicePaymentImmediately
CRMReference
CRMAccount
POPToReorderSOPLines
CancelledLines
SOPDespatchReceipts
SOPDocDelAddresss
SOPInvoiceCreditLines
SOPOrderProfitAnalysiss
Lines
SOPPayments
RepeatOrderSchedule

TEMMessageOrders

Cancelled Sales Orders

Cancelled Order record created

Sales Order Lines

HasLineBeenDespatched
PricingItems
AllocationEvent
ToAllocateQuantityMode
LineQuantityMode
ActualAllocatedQuantity
RetainManualPrices
PricingStockItem
SingleBatchTraceableItemID
SOPWarehouseAllocationCoordinator
SOPWarehouseAllocationCoordinatorOriginalPrivate
AnalysisCodes
OriginalStockQuantity
IsArchived
HasPOPOrder
InitialValueFlag
IsLineDeletable
AllocationStatus
NominalSpecification
UOMConverter
IsNewOrderLine
SOPOrderReturnLine
SOPOrderReturnDbKey
SOPOrderReturn
LineTypeDbKey
LineType
ItemCode
UseDescription
ItemDescription
LineQuantity
UnitSellingPrice
UnitSellPriceOverridden
UnitDiscountPercent
UnitDiscountValue
DiscountPercentSpecified
UnitDiscountOverridden
SellingUnitMultiple
PricingUnitMultiple
TaxCodeDbKey
TaxCode
NominalAccountRef
NominalCostCentre
NominalDepartment
RequestedDeliveryDate
PromisedDeliveryDate
AnalysisCode1
AnalysisCode2
AnalysisCode3
AnalysisCode4
AnalysisCode5
AnalysisCode6
ShowOnCustomerDocs
ApplyOrderValueDiscount
RepeatOrderPricesFixed
DespatchReceiptQuantity
InvoiceCreditQuantity
PricingUnitDescription
SellingUnitDescription
POPOrderReturnLineDbKey
POPOrderReturnLine
BackToBackStatusDbKey
BackToBackStatus
AdditionalChargeInvoiced
IsLocked
ReadyForInvoicePrint
PostedInvoiceCreditQty
StockItemTypeDbKey
StockItemType
TraceAvailForDespatch
CostPrice
BOMDetailsOnDespatchNote
TEMMessage
TEMmessageLineNo
SellingUnitWeight
ShowOnDespatchNote
TraceableType
ConfirmationIntentTypeDbKey
ConfirmationIntentType
DespatchNoteComment
PickingListComment
ShowOnPickingListTypeDbKey
ShowOnPickingListType
SOPOrderFulfilmentMethodDbKey
SOPOrderFulfilmentMethod
QuantityReserved
OpLock
DateTimeCreated
SpareText1
SpareText2
SpareText3
SpareNumber1
SpareNumber2
SpareNumber3
SpareDate1
SpareDate2
SpareDate3
SpareBit1
SpareBit2
SpareBit3
IncludeInMRP
LineUnitPrecision
StockUnitPrecision
StockUnitLineQuantity
StockUnitAllocatedQuantity
StockUnitDespatchReceiptQuantity
StockUnitInvoiceCreditQuantity
StockUnitPostedInvoiceCreditQty
StockUnitAvailableForDespatch
StockUnitMultiple
POPToReorderSOPLines
SOPAllocationLines
DespatchReceiptLines
InvoiceCreditLines
SOPOrdCommentForDspNtes
SOPOrderLineProfitAnalysiss
StandardItemLink
Logging SiSOPOrderReturnLine Records...
Logging analysis price

Cancelled Sales Order Lines

Cancelled lines recorded

Stock Item

LandedCostsPercentage
LandedCostsPerItem
IsInUseByBOM
AlwaysCheckBOMUse
MemoNotes
PreferredSupplier
IsItemOnOrder
CheckedOrders
OriginalTraceableType
LandedCostsValueInitialised
DefaultedRecordNumbersFlag
NotifyBOM
AlreadyInactive
CopiedBinItem
Item
Code
Name
ProductGroupDbKey
ProductGroup
Description
UseDescriptionOnDocs
TaxCodeDbKey
TaxCode
StandardCost
SOPItemPrice
StockItemStatusDbKey
StockItemStatus
Manufacturer
PartNumber
StocktakeCyclePeriod
CommodityCode
Weight
SuppressNetMass
StockUnitName
BaseUnitName
StockMultOfBaseUnit
Barcode
StdCostVarianceLastReset
AverageBuyingPrice
TraceableTypeDbKey
TraceableType
SaleFromSingleBatch
AllowDuplicateNumbers
UsesAlternativeRef
UsesSellByDate
UsesUseByDate
RecordNosOnGoodsReceived
LastArchivedUpTo
FreeStockQuantity
BOMItemTypeDbKey
BOMItemType
SOPOrderFulfilmentMethodDbKey
SOPOrderFulfilmentMethod
DefaultDespatchNoteComment
DefaultPickingListComment
QuantityReserved
LastTraceArchivedUpTo
OpLock
DateTimeCreated
LandedCostsTypeDbKey
LandedCostsType
LandedCostsValue
SpareText1
SpareText2
SpareText3
SpareNumber1
SpareNumber2
SpareNumber3
SpareDate1
SpareDate2
SpareDate3
SpareBit1
SpareBit2
SpareBit3
AllowSalesOrder
STKAutoGenerateOptionTypeDbKey
STKAutoGenerateOptionType
AutoGeneratePrefix
AutoGenerateNextNumber
STKLabelPrintingOptionTypeDbKey
STKLabelPrintingOptionType
STKFulfilmentSequenceTypeDbKey
STKFulfilmentSequenceType
ShelfLife
STKShelfLifeTypeDbKey
STKShelfLifeType
AllowOutOfDate
STKAutoGenerateSeparatorDbKey
STKAutoGenerateSeparator
AutoGeneratePadding
CountryOfOriginDbKey
CountryOfOrigin
UsesSupplementaryUnit
SupplementaryUnitConversionRatio
UsesRCV
IsWEEEItem
IncludeNosOnCountSheets
AlternativeItems
AlternativeItems_ItemAlternativeID
Locations
Boms
BOMAllocComponents
BOMAllocComponents_StockItemID
BOMAllocFinishedItems
BOMBuildComponents
BOMBuildFinishedItems
BOMLines
PCAnalysisFieldValues
POPStandardItemLinks
POPStandardItemLinkArchs
POPToReorderItems
SOPPreReceiptAllocs
SOPStandardItemLinks
SOPStandardItemLinkArchs
StandardCostVariances
StockItemAttachments
Discounts
StockItemMemos
StockItemNominalCodes
StockItemPeriodBalances
StockItemPrices
StockItemSearchCatVals
Suppliers
StockItemUnits
UnitUoMTypes
StockPreReceiptAllocs
TEMCustProdMappings
TEMSuppProdMappings
TraceableItems
TraceableItemArchs
TransactionArchives
TransactionHistories
Warehouses
BaseUnitOfMeasure
StockUnitOfMeasure
IsDeletable
Holding
IsCompleteItem
IsSOPProduct
Attachments

Stock Item Supplier (changes made via the Amend Stock Item Details screen)

LandedCostsPercentage
LandedCostsPerItem
CurrencyCoordinator
BaseCurrency
SupplierToBaseCurrencyRate
StockItemSupplier
ItemDbKey
Item
SupplierDbKey
Supplier
SupplierStockCode
LeadTime
LeadTimeUnitDbKey
LeadTimeUnit
UsualOrderQuantity
MinimumOrderQuantity
Preferred
DateLastOrder
LastBuyingPrice
LastOrderQuantity
OrderQuantityYTD
OrderValueYTD
QuantityOnOrder
LastBaseBuyingPrice
CataloguePrice
CataloguePriceDate
OpLock
DateTimeCreated
ListPrice
ListBasePrice
DateListPriceChanged
ListPriceExpiryDate
DefaultPricingSourceTypeDbKey
DefaultPricingSourceType
LandedCostsTypeDbKey
LandedCostsType
LandedCostsValue
ReorderMultipleQty
CountryOfOriginDbKey
CountryOfOrigin

Software

Hardware & Networks

Sicon Products

Sage Awards - 2009