TABLE DETAIL REFERENCE: ItemGroupLine
(Online VERSION)
| ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
| EditSequence | 12 | VARCHAR | 10 | True | False | False | False | %s | |
| Name | 12 | VARCHAR | 100 | True | False | False | False | %s | |
| FullName | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| IsActive | -7 | BIT | 1 | True | False | False | False |
1
0
true
false
| |
| Sku | 12 | VARCHAR | 100 | True | False | False | False | %s | |
| Type | 12 | VARCHAR | 1000 | True | False | False | False | %s | |
| ItemDesc | 12 | VARCHAR | 4000 | True | False | False | False | %s | |
| IsTaxable | -7 | BIT | 1 | True | False | False | False |
1
0
true
false
| |
| UnitPrice | 3 | DECIMAL | 18 | True | False | False | False | %10.7f | |
| PurchaseCost | 3 | DECIMAL | 15 | True | False | False | False | %10.6f | |
| IsPrintGroupedItems | -7 | BIT | 1 | True | False | False | False |
1
0
true
false
| |
| ItemGroupLineSeqNo | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| ItemGroupLineItemRefListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| ItemGroupLineItemRefFullName | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| ItemGroupLineQuantity | 3 | DECIMAL | 15 | True | False | False | False | %10.7f | |
| ItemGroupLineItemType | 12 | VARCHAR | 36 | True | False | False | False | %s | |
| FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
