View: Company Profile

RotoID: CS0001
Table: CSCOM
Protocol: Flat
DLL:CSCOM

Keys: 1

Title Fields
Company Profile Database ID ORGID

Fields: 50

Field Index Type Title Attributes Presentation
ORGID 1 String*6 Database ID E A K R  Mask: %-6N
CONAME 2 String*60 Name E A 
ADDR01 3 String*60 Address E A 
ADDR02 4 String*60 Address Line 2 E A 
ADDR03 5 String*60 Address Line 3 E A 
ADDR04 6 String*60 Address Line 4 E A 
CITY 7 String*30 City E A 
STATE 8 String*30 State/Province E A 
POSTAL 9 String*20 Zip/Postal Code E A  Mask: %-20C
COUNTRY 10 String*30 Country E A 
LOCTYPE 11 String*6 Location Type E A 
LOCCODE 12 String*30 Location Code E A 
PHONEFMT 13 Boolean Format Phone Number E A 
PHONE 14 String*30 Telephone E A P  Mask: %-30c
FAX 15 String*30 Fax Number E A P  Mask: %-30c
CONTACT 16 String*60 Contact E A 
CNTRYCODE 17 String*6 Country Code E A 
BRANCH 18 String*6 Branch E A 
PERDFSC 19 Integer Number of Fiscal Periods E A  List:2 entries
12 = 12
13 = 13
QTR4PERD 20 Integer Quarter with 4 Periods E A  List:4 entries
1 = 1
2 = 2
3 = 3
4 = 4
HOMECUR 21 String*3 Functional Currency A X  Mask: %-3N
MULTICURSW 22 Boolean Multicurrency E A X  List:2 entries
0 = No
1 = Yes
RATETYPE 23 String*2 Default Rate Type E A  Mask: %-2N
WARNDAYS 24 Integer Warning Date Range E A 
EUROCURSW 50 Boolean Euro A X 
REPORTCUR 51 String*3 Reporting Currency A X  Mask: %-3N
HNDLCKFSC 52 Integer Locked Fiscal Period E A  List:3 entries
0 = None
1 = Warning
2 = Error
HNDINAACCT 53 Integer Inactive G/L Account E A  List:3 entries
0 = None
1 = Warning
2 = Error
HNDNEXACCT 54 Integer Non-existent G/L Account E A  List:3 entries
0 = None
1 = Warning
2 = Error
GNLSSMTHD 55 Integer Gain/Loss Accounting Method A X  List:2 entries
1 = Realized and Unrealized Gain/Loss
2 = Recognized Gain/Loss
TAXNBR 56 String*20 Tax Number E A 
LEGALNAME 57 String*60 Legal Name E A 
BRN 58 String*30 Business Registration Number E A 
EMAILHOST 59 String*50 E-mail Host E A 
EMAILUSER 60 String*50 E-mail Username E A 
EMAILPSWD 61 Binary*100 E-mail Password A X 
EMAILPORT 62 Integer E-mail Port E A 
EMAILSSL 63 Boolean E-mail SSL Flag E A 
EMAILADDR 64 String*50 E-mail From Address E A 
USESMTP 65 Boolean Use SMTP E A 
CCADDR 66 String*250 E-mail Cc Address E A 
BCCADDR 67 String*250 E-mail Bcc Address E A 
SFPAORG 68 Binary*240 Payments Acceptance Organization E A 
SFPACOMP 69 Binary*32 Payments Acceptance Company E A 
SFPACNTRY 70 Integer Payments Acceptance Country E A  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 71 Integer E-mail Send Method E A  List:2 entries
0 = Basic Authentication SMTP
1 = Microsoft Graph
USEREPSWD 100 String*96 User Input E-mail Password E A 
ISRDS 101 Boolean Is RDS A 
CNTRY 102 String*3 Alpha-3 Country Code E A 
SUBDOMAIN 103 String*100 Web Address Subdomain E A 

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).