Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY01500
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Company Master Group Display Name: Company Master
Physical Name: SY01500
Technical Name: HRSY_Company_MSTR
Group Technical Name: Company Master
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
---|---|---|---|---|---|---|
1 | LSTUSRED ![]() | Last User to Edit | STR15 | String | 16 | 15 |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Company Master'].LSTUSRED AS 'Company Master-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SY01500 AS ['Company Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Company Master'].LSTUSRED = ['Users Master'].USERID | ||||||
2 | CREATDDT ![]() | Created Date | DT | Date | 4 | 8 |
3 | MODIFDT ![]() | Modified Date | DT | Date | 4 | 8 |
4 | CMPANYID ![]() | Company ID | INT5 | Integer | 2 | 4 |
5 | CMPNYNAM ![]() | Company Name | STR64_Company_Name | String | 66 | 64 |
6 | TAXEXMT1 ![]() | Tax Exempt 1 | STR25 | String | 26 | 25 |
7 | TAXEXMT2 ![]() | Tax Exempt 2 | STR25 | String | 26 | 25 |
8 | TAXREGTN ![]() | Tax Registration | STR25 | String | 26 | 25 |
9 | COPTXSCH ![]() | Company Purchases Tax Schedule | STR15_LBAU | String | 16 | 15 |
10 | COSTXSCH ![]() | Company Sales Tax Schedule | STR15_LBAU | String | 16 | 15 |
11 | LOCATNNM ![]() | Location Name | STR30 | String | 32 | 30 |
12 | ADRCNTCT ![]() | Address Contact | STR60 | String | 62 | 60 |
13 | ADDRESS1 ![]() | Address 1 | STR60 | String | 62 | 60 |
14 | ADDRESS2 ![]() | Address 2 | STR60 | String | 62 | 60 |
15 | ADDRESS3 ![]() | Address 3 | STR60 | String | 62 | 60 |
16 | CITY ![]() | City | STR35 | String | 36 | 35 |
17 | COUNTY ![]() | County | STR60 | String | 62 | 60 |
18 | STATE ![]() | State | STR30_State | String | 30 | 29 |
19 | ZIPCODE ![]() | Zip Code | STR10 | String | 12 | 10 |
20 | PHONE1 ![]() | Phone 1 | Phone_Number | String | 22 | 14 |
21 | PHONE2 ![]() | Phone 2 | Phone_Number | String | 22 | 14 |
22 | PHONE3 ![]() | Phone 3 | Phone_Number3 | String | 22 | 14 |
23 | FAXNUMBR ![]() | Fax Number | STR14_FAX | String | 22 | 14 |
24 | USESCRTY ![]() | Use Security | CB_Security | Boolean | 2 | 0 |
25 | UDCOSTR1 ![]() | User Defined Company String 1 | STR30 | String | 32 | 30 |
26 | UDCOSTR2 ![]() | User Defined Company String 2 | STR30 | String | 32 | 30 |
27 | CMPCNTRY ![]() | Company Country | STR60 | String | 62 | 60 |
28 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 10 | 14 |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Company Master'].NOTEINDX AS 'Company Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SY01500 AS ['Company Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Company Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
29 | PPSFRNUM ![]() | PPS File/Reconciliation Number | STR25 | String | 26 | 25 |
30 | PPSTAXRT ![]() | PPS Tax Rate | INT5_%2 | Integer | 2 | 5 |
31 | PPSVNDID ![]() | PPS Vendor ID | STR_15_Vendor_ID | String | 16 | 15 |
32 | VATMODE ![]() | VAT Mode | CB_VAT_Mode | Boolean | 2 | 0 |
33 | LOCATNID ![]() | Location ID | STR15_Location_ID | String | 16 | 15 |
34 | INTERID ![]() | Intercompany ID | STR5_IC_ID | String | 6 | 5 |
35 | ACSEGSEP ![]() | Account Segment Seperator | STR1 | String | 2 | 1 |
36 | SECOPTS ![]() | Security Options | ML_Security_Options | Long Integer | 4 | 0 |
37 | DisplayRegisteredPalette ![]() | DisplayRegisteredPalettes | YN | Boolean | 2 | 0 |
38 | Company_Options ![]() | Company Options | ML_Company_Options | Long Integer | 4 | 0 |
39 | Vets100CompanyNumber ![]() | Vets 100 Company Number | STR20 | String | 22 | 20 |
40 | TYPEOFBUSINESS ![]() | Type of Business | STR30 | String | 32 | 30 |
41 | DUNS_Number ![]() | DUNS Number | STR20 | String | 22 | 20 |
42 | SICNUMBER ![]() | SIC Number | STR15 | String | 16 | 15 |
43 | GOVCRPID ![]() | Governmental Corporate ID | STR30_Gov_Corp_ID | String | 32 | 30 |
44 | BRNCHNMBR ![]() | Branch Number | STR20 | String | 22 | 20 |
45 | DFLTTXDTLID ![]() | Default Tax Detail ID | STR15_Tax_Detail_ID | String | 16 | 15 |
46 | PurchasesTaxDetailID ![]() | Purchases Tax Detail ID | STR15_Tax_Detail_ID | String | 16 | 15 |
47 | CCode ![]() | Country Code | STR6_VAT | String | 8 | 6 |
Key to the VAT Country Code MSTR (VAT10001).
Click to show/hideSELECT
['Company Master'].CCode AS 'Company Master-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
SY01500 AS ['Company Master']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Company Master'].CCode = ['VAT Country Code MSTR'].CCode | ||||||
48 | IVTRFDOCFMT ![]() | IvTrfDocFormat | DDL | Integer | 2 | 0 |
49 | Offline_User ![]() | Offline User | User_ID | String | 16 | 15 |
50 | WORKFLOWENABLED ![]() | Workflow Enabled | CB_WorkflowEnabled | Boolean | 2 | 0 |
51 | CrmCredentialsMethod ![]() | CrmCredentialsMethod | CrmCredentialsMethod | Integer | 2 | 0 |
52 | CrmOrganizationName ![]() | CrmOrganizationName | STR255 | String | 256 | 255 |
53 | CrmServiceUrl ![]() | CrmServiceUrl | STR255 | String | 256 | 255 |
54 | EnableGLReporting ![]() | Enable GL Reporting for MR | CB_EnableGLReporting | Boolean | 2 | 0 |
55 | EnableAAReporting ![]() | Enable AA Reporting for MR | CB_Enable_AA_Reporting | Boolean | 2 | 0 |
56 | UseDateEffectiveTax ![]() | Use Date Effective Tax | CB | Boolean | 2 | 0 |
57 | DateToUse ![]() | Date To Use | DDL | Integer | 2 | 0 |
58 | DEX_ROW_ID ![]() | int | int | 10 | 10 | |
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. |