Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
OnlinePaymentOptionLevelThreeSeq | int identity | 4 | √ | null |
|
|
||||
Description | nvarchar | 400 | ('') |
|
|
|||||
Amount | money | 21,4 | ((0)) |
|
|
|||||
GLCode | varchar | 15 | ('') |
|
|
|||||
GLSubAllocationCode | varchar | 15 | ('') |
|
|
|||||
FundCode | varchar | 15 | ('') |
|
|
|||||
AppealCode | varchar | 10 | ('') |
|
|
|||||
StartPublishDate | datetime | 16,3 | √ | null |
|
|
||||
EndPublishDate | datetime | 16,3 | √ | null |
|
|
||||
OnlinePaymentOptionLevelTwoSeq | int | 4 | ((0)) |
|
|
|||||
AllowUserToChangeAmountFlag | bit | 1 | ((0)) |
|
|
|||||
NotifyStaffID | int | 4 | √ | null |
|
|
||||
NotifyEmailAddress | varchar | 100 | ('') |
|
|
|||||
SortOrder | int | 4 | ((0)) |
|
|
|||||
TaxCode | varchar | 5 | ('') |
|
|
|||||
OverrideTaxPercentage | decimal | 8,4 | √ | null |
|
|
Table contained -1 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_OnlinePaymentOptionLevelThree_OnlinePaymentOptionLevelThreeSeq | Primary key | Asc | OnlinePaymentOptionLevelThreeSeq |