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