Table: Company Profile

Table: CSCOM
View: CS0001
Record Length: 1778

Flags: A R 

Keys: 1

Title Flags Fields
Company Profile Database ID ORGID

Fields: 50

Field Type Title Presentation
ORGID String*6 Database ID Mask: %-6N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CONAME String*60 Name
ADDR01 String*60 Address
ADDR02 String*60 Address Line 2
ADDR03 String*60 Address Line 3
ADDR04 String*60 Address Line 4
CITY String*30 City
STATE String*30 State/Province
POSTAL String*20 Zip/Postal Code Mask: %-20C
COUNTRY String*30 Country
LOCTYPE String*6 Location Type
LOCCODE String*30 Location Code
PHONEFMT Boolean Format Phone Number
PHONE String*30 Telephone Mask: %-30c
FAX String*30 Fax Number Mask: %-30c
CONTACT String*60 Contact
CNTRYCODE String*6 Country Code
BRANCH String*6 Branch
PERDFSC Integer Number of Fiscal Periods List:2 entries
12 = 12
13 = 13
QTR4PERD Integer Quarter with 4 Periods List:4 entries
1 = 1
2 = 2
3 = 3
4 = 4
HOMECUR String*3 Functional Currency Mask: %-3N
MULTICURSW Boolean Multicurrency List:2 entries
0 = No
1 = Yes
RATETYPE String*2 Default Rate Type Mask: %-2N
WARNDAYS Integer Warning Date Range
EUROCURSW Boolean Euro
REPORTCUR String*3 Reporting Currency Mask: %-3N
HNDLCKFSC Integer Locked Fiscal Period List:3 entries
0 = None
1 = Warning
2 = Error
HNDINAACCT Integer Inactive G/L Account List:3 entries
0 = None
1 = Warning
2 = Error
HNDNEXACCT Integer Non-existent G/L Account List:3 entries
0 = None
1 = Warning
2 = Error
GNLSSMTHD Integer Gain/Loss Accounting Method List:2 entries
1 = Realized and Unrealized Gain/Loss
2 = Recognized Gain/Loss
TAXNBR String*20 Tax Number
LEGALNAME String*60 Legal Name
BRN String*30 Business Registration Number
EMAILHOST String*50 E-mail Host
EMAILUSER String*50 E-mail Username
EMAILPSWD Binary*100 E-mail Password
EMAILPORT Integer E-mail Port
EMAILSSL Boolean E-mail SSL Flag
EMAILADDR String*50 E-mail From Address
USESMTP Boolean Use SMTP
CCADDR String*250 E-mail Cc Address
BCCADDR String*250 E-mail Bcc Address
SFPAORG Binary*240 Payments Acceptance Organization
SFPACOMP Binary*32 Payments Acceptance Company
SFPACNTRY Integer Payments Acceptance Country List:41 entries
0 = None
1 = Australia
2 = Bahrain
3 = Botswana
4 = Canada
5 = Cayman Islands
6 = China
7 = Colombia
8 = Costa Rica
9 = Dominican Republic
10 = El Salvador
11 = Guadeloupe and dependencies
12 = Guatemala
13 = Honduras
14 = Hong Kong
15 = India
16 = Indonesia
17 = Jamaica
18 = Jordan
19 = Kenya
20 = Kuwait
21 = Malaysia
22 = Martinique
23 = Mauritius
24 = Mexico
25 = Mozambique
26 = New Zealand
27 = Nicaragua
28 = Oman
29 = Panama
30 = Philippines
31 = Qatar
32 = Saudi Arabia
33 = Senegal
34 = Singapore
35 = South Africa
36 = South Korea
37 = Thailand
38 = The Bahamas
39 = United Arab Emirates
40 = United States of America
EMAILMTHD Integer E-mail Send Method List:2 entries
0 = Basic Authentication SMTP
1 = Microsoft Graph

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).