Table 79 Company Information

Base Application, Microsoft.Foundation.Company

78 fields

IdNameTypeVersions
1Primary KeyCode[10]17-29
2NameText[100]17-29
3Name 2Text[50]17-29
4AddressText[100]17-29
5Address 2Text[50]17-29
6CityText[30]17-29
7Phone No.Text[30]17-29
8Phone No. 2Text[30]17-29
9Telex No.Text[30]17-29
10Fax No.Text[30]17-29
11Giro No.Text[20]17-29
12Bank NameText[100]17-29
13Bank Branch No.Text[20]17-29
14Bank Account No.Text[30]17-29
15Payment Routing No.Text[20]17-29
17Customs Permit No.Text[10]17-29
18Customs Permit DateDate17-29
19VAT Registration No.Text[20]17-29
20Registration No.Text[20]17-29
21Telex Answer BackText[20]17-29
22Ship-to NameText[100]17-29
23Ship-to Name 2Text[50]17-29
24Ship-to AddressText[100]17-29
25Ship-to Address 2Text[50]17-29
26Ship-to CityText[30]17-29
27Ship-to ContactText[100]17-29
28Location CodeCode[10]17-29
29PictureBlob17-29
30Post CodeCode[20]17-29
31CountyText[30]17-29
32Ship-to Post CodeCode[20]17-29
33Ship-to CountyText[30]17-29
34E-MailText[80]17-29
35Home PageText[255]17-29changed in 27
36Country/Region CodeCode[10]17-29
37Ship-to Country/Region CodeCode[10]17-29
38IBANCode[50]17-29
39SWIFT CodeCode[20]17-29
40Industrial ClassificationText[30]17-29
46System IndicatorOption17-29
47Custom System Indicator TextText[250]17-29
48System Indicator StyleOption17-29
50Allow Blank Payment Info.Boolean17-29
51Contact PersonText[50]17-29
52Ship-to Phone No.Text[30]new in 25
90GLNCode[13]17-29
92EORI NumberText[40]17-29
95Use GLN in Electronic DocumentBoolean17-29
96Picture - Last Mod. Date TimeDateTime17-29
98Last Modified Date TimeDateTime17-29
99Created DateTimeDateTime17-29
100Demo CompanyBoolean17-29
200Alternative Language CodeCode[10]17-29
201Default Language CodeCode[10]new in 28
300Brand Color ValueCode[10]17-29
301Brand Color CodeCode[20]17-29
5700Responsibility CenterCode[10]17-29
5791Check-Avail. Period Calc.DateFormula17-29
5792Check-Avail. Time BucketEnum "Analysis Period Type"17-29changed in 20
7600Base Calendar CodeCode[10]17-29
7601Cal. Convergence Time FrameDateFormula17-29
10005Ship-to UPS ZoneCode[2]17-29
10006UPS Shipper IDText[15]17-29
10010Tax Area CodeCode[20]17-29
10015Tax Exemption No.Text[30]17-29
10016Federal ID No.Text[30]17-29
10017QST Registration No.Text[20]17-29
10021Provincial Tax Area CodeCode[20]17-29
10022Software Identification CodeCode[10]17-29
10023RFC No.Code[12]17-29
Removed, tag 25.0, obsolete since 21.4: Replaced with RFC Number
10024CURP No.Code[18]17-29
10025State InscriptionText[30]17-29
10026Tax SchemeText[250]17-29
14021RFC NumberText[30]new in 21
27000SAT Tax Regime ClassificationCode[10]17-29
27001SAT Postal CodeCode[10]17-29
27002SCT Permission TypeCode[10]new in 19
Removed, tag 25.0, obsolete since 21.0: Moved to Fixed Asset table
27003SCT Permission NumberCode[20]new in 19
Removed, tag 25.0, obsolete since 21.0: Moved to Fixed Asset table