TABLE DETAIL REFERENCE: CustomerReward
(POS VERSION)
| FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
|---|---|---|---|---|---|---|---|---|---|
| ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | Yes |
| 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 | |
| AccountBalance | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| AccountLimit | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| AmountPastDue | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| CompanyName | 12 | VARCHAR | 48 | True | False | False | False | %s | |
| CustomerDiscPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| CustomerDiscType | 12 | VARCHAR | 10 | True | False | False | False | None PriceLevel Percentage | |
| CustomerType | 12 | VARCHAR | 15 | True | False | False | False | %s | |
| CustomerID | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| DefaultShipAddress | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| 12 | VARCHAR | 99 | True | False | False | False | %s | ||
| FirstName | 12 | VARCHAR | 30 | True | False | False | False | %s | |
| FullName | 12 | VARCHAR | 200 | True | False | False | False | %s | |
| IsAcceptingChecks | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| IsNoShipToBilling | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| IsOkToEMail | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| IsRewardsMember | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| IsUsingChargeAccount | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| IsUsingWithQB | -7 | BIT | 1 | True | False | False | False | 1 0 true false | |
| LastName | 12 | VARCHAR | 30 | True | False | False | True | %s | |
| LastSale | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| Notes | 12 | VARCHAR | 245 | True | False | False | False | %s | |
| Phone | 12 | VARCHAR | 40 | True | False | False | False | %s | |
| Phone2 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
| Phone3 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
| Phone4 | 12 | VARCHAR | 40 | True | False | False | False | %s | |
| PriceLevelNumber | 12 | VARCHAR | 1 | True | False | False | False | 1 2 3 4 | |
| Salutation | 12 | VARCHAR | 15 | True | False | False | False | %s | |
| StoreExchangeStatus | 12 | VARCHAR | 12 | True | False | False | False | Modified Sent Acknowledged | |
| TaxCategory | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| WebNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | |
| BillAddressCity | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| BillAddressCountry | 12 | VARCHAR | 31 | True | False | False | False | %s | |
| BillAddressPostalCode | 12 | VARCHAR | 13 | True | False | False | False | %s | |
| BillAddressState | 12 | VARCHAR | 21 | True | False | False | False | %s | |
| BillAddressStreet | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| BillAddressStreet2 | 12 | VARCHAR | 41 | True | False | False | False | %s | |
| RewardSeqNo | 4 | INTEGER | 4 | True | False | False | False | SeqNo | |
| RewardAmount | 3 | DECIMAL | 16 | True | False | False | False | %8.5f | |
| RewardPercent | 3 | DECIMAL | 13 | True | False | False | False | %8.2f | |
| RewardEarnedDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| RewardMatureDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| RewardExpirationDate | 9 | DATE | 6 | True | False | False | False | CCCC-MM-DD | |
| RewardStatus | 12 | VARCHAR | 10 | True | False | False | False | Available Removed | |
| FQPrimaryKey | 12 | VARCHAR | 110 | True | False | False | False | FQPrimaryKey | |
| CustomFieldOther | 12 | VARCHAR | 30 | True | False | False | False | %s | |
| CustomFieldSalesLocation | 12 | VARCHAR | 30 | True | True | True | False | %s | |
| CustomFieldSerial | 12 | VARCHAR | 30 | True | True | True | False | %s | |
| CustomFieldSerial1 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
| CustomFieldSerial2 | 12 | VARCHAR | 30 | True | True | True | False | %s |