paymentview


Columns

Column Type Size Nulls Auto Default Children Parents Comments
posTransactionId INT 10 0
amount DECIMAL 28,9 √ null
customerName VARCHAR 41 null
dateTime DATETIME 26 √ null
soNum VARCHAR 25 null
postedStatus VARCHAR 15 null
methodName VARCHAR 31 √ null
postTypeId INT 10 null
customerId INT 10 0
customer.id Implied Constraint R
postStatusId INT 10 null
paymentMethodId INT 10 0
paymentmethod.id Implied Constraint R

Relationships

View Definition


Possibly Referenced Tables/Views