Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| POSPRODUCT_ID | int | 4 | √ | null |
|
|
The POS product ID if this is a point of sale transaction |
|
| PRODUCT_NAME | varchar | 100 | √ | null |
|
|
The POS product name if this is a point of sale transaction |
|
| RECEIPT_NUMBER | nvarchar | 8000 | √ | null |
|
|
The receipt number that the transaction belongs to |
|
| TRANSACTION_ID | int | 4 | √ | null |
|
|
Transaction ID |
|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
ID of the customer who is the participant of the transaction |
|
| COMPANY_ID | int | 4 | √ | null |
|
|
ID of the company who is the owner of the transaction if applicable |
|
| CREATION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Date and time that the transaction was created |
|
| CREATION_DATE_ONLY | date | 20 | √ | null |
|
|
Date that the transaction was created (date only) |
|
| QUESTION_COLUMNS_BUILT_DYNAMICALLY | varchar | 500 | √ | null |
|
|
Columns for each custom question will be dynamically generated |