| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CMPANYID | Company ID |
Integer | 2 | View | |
| WINDLIVEID | Windows Live ID |
String | 256 | View | |
| WINLIVEPASSWORD | Windows Live Password |
String | 52 | View | |
| COMMERCEACCTNUM | Commerce Account Number |
String | 52 | View | |
| COMMERCEORG | Commerce Organization |
String | 52 | View | |
| ECOMMORDID | Ecommerce Order ID |
String | 16 | View | |
| ECOMMINVID | Ecommerce Invoice ID |
String | 16 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| DOCID | Document ID |
String | 16 | View | |
| OCSACTIVE | Activate Online Commerce Service |
Boolean | 2 | View | |
| PSACTIVE | Activate Payment Service |
Boolean | 2 | View | |
| PMTSERVCID | Payment Service Service ID |
String | 52 | View | |
| CARDNAME | Card Name |
String | 16 | View | |
| VoidAVSAuthorization | Void AVS Authorization |
Boolean | 2 | View | |
| VerifyAVSUsing | Verify AVS Using |
Integer | 2 | View | |
| ONLINECERTIFICATE | Online Certificate |
Text | 2 | View |