Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
LSTUSRED | Last User to Edit |
String | 16 | View | |
CREATDDT | Created Date |
Date | 4 | View | |
MODIFDT | Modified Date |
Date | 4 | View | |
CMPANYID | Company ID |
Integer | 2 | View | |
CMPNYNAM | Company Name |
String | 66 | View | |
TAXEXMT1 | Tax Exempt 1 |
String | 26 | View | |
TAXEXMT2 | Tax Exempt 2 |
String | 26 | View | |
TAXREGTN | Tax Registration |
String | 26 | View | |
COPTXSCH | Company Purchases Tax Schedule |
String | 16 | View | |
COSTXSCH | Company Sales Tax Schedule |
String | 16 | View | |
LOCATNNM | Location Name |
String | 32 | View | |
ADRCNTCT | Address Contact |
String | 62 | View | |
ADDRESS1 | Address 1 |
String | 62 | View | |
ADDRESS2 | Address 2 |
String | 62 | View | |
ADDRESS3 | Address 3 |
String | 62 | View | |
CITY | City |
String | 36 | View | |
COUNTY | County |
String | 62 | View | |
STATE | State |
String | 30 | View | |
ZIPCODE | Zip Code |
String | 12 | View | |
PHONE1 | Phone 1 |
String | 22 | View | |
PHONE2 | Phone 2 |
String | 22 | View | |
PHONE3 | Phone 3 |
String | 22 | View | |
FAXNUMBR | Fax Number |
String | 22 | View | |
USESCRTY | Use Security |
Boolean | 2 | View | |
UDCOSTR1 | User Defined Company String 1 |
String | 32 | View | |
UDCOSTR2 | User Defined Company String 2 |
String | 32 | View | |
CMPCNTRY | Company Country |
String | 62 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
PPSFRNUM | PPS File/Reconciliation Number |
String | 26 | View | |
PPSTAXRT | PPS Tax Rate |
Integer | 2 | View | |
PPSVNDID | PPS Vendor ID |
String | 16 | View | |
VATMODE | VAT Mode |
Boolean | 2 | View | |
LOCATNID | Location ID |
String | 16 | View | |
INTERID | Intercompany ID |
String | 6 | View | |
ACSEGSEP | Account Segment Seperator |
String | 2 | View | |
SECOPTS | Security Options |
Long Integer | 4 | View | |
DisplayRegisteredPalette | DisplayRegisteredPalettes |
Boolean | 2 | View | |
Company_Options | Company Options |
Long Integer | 4 | View | |
Vets100CompanyNumber | Vets 100 Company Number |
String | 22 | View | |
TYPEOFBUSINESS | Type of Business |
String | 32 | View | |
DUNS_Number | DUNS Number |
String | 22 | View | |
SICNUMBER | SIC Number |
String | 16 | View | |
GOVCRPID | Governmental Corporate ID |
String | 32 | View | |
BRNCHNMBR | Branch Number |
String | 22 | View | |
DFLTTXDTLID | Default Tax Detail ID |
String | 16 | View | |
PurchasesTaxDetailID | Purchases Tax Detail ID |
String | 16 | View | |
CCode | Country Code |
String | 8 | View | |
IVTRFDOCFMT | IvTrfDocFormat |
Integer | 2 | View | |
WORKFLOWENABLED | Workflow Enabled |
Boolean | 2 | View | |
CrmCredentialsMethod | CrmCredentialsMethod |
Integer | 2 | View | |
CrmOrganizationName | CrmOrganizationName |
String | 256 | View | |
CrmServiceUrl | CrmServiceUrl |
String | 256 | View |