Appendix - Database Table Layouts
These database table file lists are provided for reporting purposes.
Table: SiBespokeType (module configuration settings)
- SiBespokeTypeID [float]
- TypeKey [varchar]
- Description [varchar]
- SpareText1 [text]
- SpareText2 [text]
- SpareText3 [text]
- SpareNumber1 [float]
- SpareNumber2 [float]
- SpareNumber3 [float]
- DeletedByUserId [varchar]
- DeletedDateTime [datetime]
- LastUpdatedByUserId [varchar]
- LastUpdatedDateTime [datetime]
Table: SiconCISSupplier
- SiconCISSupplierID [float]
- PLSupplierAccountID [float]
- IsSubcontractor [bit]
- RateSiBespokeTypeID [float]
- UTR [varchar]
- VerificationNo [varchar]
- NINO [varchar]
- CRN [varchar]
- ContEmpRefNo [varchar] (not used/obsolete, do not use for reporting)
- SpareText1 [varchar]
- SpareText2 [varchar]
- SpareText3 [varchar]
- SpareText4 [varchar]
- SpareText5 [varchar]
- SpareNumber1 [decimal]
- SpareNumber2 [decimal]
- SpareNumber3 [decimal]
- SpareNumber4 [decimal]
- SpareNumber5 [decimal]
- SpareDateTime1 [datetime]
- SpareDateTime2 [datetime]
- SpareDateTime3 [datetime]
- SpareDateTime4 [datetime]
- SpareDateTime5 [datetime]
- SpareMemo1 [text]
- LastUpdatedByUserId [varchar]
- LastUpdatedDateTime [datetime]
Table: SiconCISAudit
- SiconCISAuditID [float]
- PLSupplierAccountID [float]
- INV_URN [bigint]
- INV_TransactionDate [datetime]
- INV_TransactionReference [varchar]
- INV_SecondReference [varchar]
- INV_NetValue [decimal]
- INV_TaxValue [decimal]
- INV_CISApplicableValue [decimal]
- CRN_URN [bigint]
- CRN_TransactionDate [datetime]
- CRN_TransactionReference [varchar]
- CRN_SecondReference [varchar]
- CRN_NetValue [decimal]
- CRN_TaxValue [decimal]
- SiconCISSupplierID [float]
- SupplierReference [varchar]
- SupplierUTR [varchar]
- SupplierVerificationNo [varchar]
- SupplierNINO [varchar]
- SupplierCRN [varchar]
- SupplierContEmpRefNo [varchar]
- RatePercentage [decimal]
- RateDescription [varchar]
- RateNLNominalAccountID [float]
- SpareText1 [varchar]
- SpareText2 [varchar]
- SpareText3 [varchar]
- SpareText4 [varchar]
- SpareText5 [varchar]
- SpareNumber1 [decimal]
- SpareNumber2 [decimal]
- SpareNumber3 [decimal]
- SpareNumber4 [decimal]
- SpareNumber5 [decimal]
- SpareDateTime1 [datetime]
- SpareDateTime2 [datetime]
- SpareDateTime3 [datetime]
- SpareDateTime4 [datetime]
- SpareDateTime5 [datetime]
- SpareMemo1 [text]
- PostedDate [datetime]
- SYSAccountingPeriodID [bigint]
- DeletedByUserId [varchar]
- DeletedDateTime [datetime]
- LastUpdatedByUserId [varchar]
- LastUpdatedDateTime [datetime]
