Таблица: SY24 - «General Code File». Маска имени таблицы: «SY24%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
SY24001 | NVARCHAR | VSTRING | 2 | 0 | 2 | CodeType | Code Type | Identifies the type of code:
Code - Description (Module(s) : Length) A1 - Communication channel (SY : 2) A2 - IBAN (SY : 2) A3 - Common address (SY : 2) A4 - Common address sub-type (SY : 2) A5 - Address entries (SY : 2) AA - Journal codes (GL : 6) AB - Cash books (GL : 6) AT - Tier (GL : 2) AX - Cash office (GL : 8) AY - Reason codes (GL : 2) AZ - Compound Category (GL : 2) A0 - Asset group (GL : 10) AF - Category A (GL : 4) AG - Category B (GL : 4) AH - Location (GL : 15) AI - Engineer (GL : 25) AJ - Disposal code (GL : 4) A6 - User defined field 1 (GL : 15) A7 - User defined field 2 (GL : 10) A8 - User defined field 3 (GL : 10) A9 - User defined field 4 (GL : 5) AC - Insurance company (GL : 25) AD - Insurance category (GL : 20) AE - Business transaction code (GL : 3) AK - Hospitality simulation transactions (GL : 2) BA - Post codes (SL : 10) BB - Categories (SL : 4) BC - Districts (SL : 2) BD - Advertising areas (SL : 2) BE - Area codes (SL : 4) BF - Trade codes (SL : 5) BG - Discount codes (SL : 2) BH - Accrual codes (SL : 2) BI - Commission codes (SL : 2) BJ - Bank codes (SL : 10) BK - Salesmen (SL/ST/PR : 3) BL - Field engineers (SL : 4) BM - Country codes (SL : 3) BN - Statistical codes (SC : 13) BO - Export codes (SL : 1) BP - Payment codes (SL : 2) BQ - Accounting code customer (SL : 2) BT - Billing terms (SL/PL : 4) BS - Document type (SL/PL : 3) BV - Jurisdiction code (SY/SL/PL : 2) CA - Post codes (PL : 10) CB - Categories (PL : 4) CC - Country codes (PL : 3) CD - Bank codes (PL : 10) CE - Sales tax codes (PL : 2) CF - Central bank codes (PL : 2) CG - Authorization codes (PL : 5) CH - Organization codes (PL : 1) CI - Accounting code supplier (PL : 2) CJ - Supplier type (PL : 1) DA - Purchaser (MP/PC/SC : 3) DC - Document codes (SY : 1) EA - Skill codes (HR/SM : 3) EB - Engineer categories (HR/SM : 4) EC - Price codes (HR/SM/PR : 2) ED - Order status (SM : 2) EE - Weighted priorities (OR/PR/SM : 1) EF - Order priorities (OR/PR/SM : 1) EG - Analysis codes (SM : 15) EH - Issue status (SM : 6) EI - Return status (SM : 6) EJ - Work schedule codes (HR/SM/PR : 6) E1 - Error code (SM : 8) (Code EK replaced with E1) EL - Error type (SM : 2) EM - Error category (SM : 4) EN - Status (SM : 2) EO - Note category (SM : 2) EP - Key word (SM : 15) EQ - Note code (SM : 2) ER - Price calculation profile (SM : 10) EX - Service order accounting codes order (SM : 2) EY - Service order accounting codes activ (SM : 2) EZ - Service contract accounting codes (SM : 2 E0 - Type of days (SM : 1) E2 - Customer priority codes (SL : 1) F0 - Accounting code PUR (AM : 2) F1 - Accounting code TAX (AM : 2) F2 - Accounting code PLA (AM : 2) F3 - Accounting code SAL (AM : 2) F4 - Accounting code SCR (AM : 2) F5 - Accounting code REV (AM : 2) F6 - Accounting code ETX (AM : 2) F7 - Accounting code FUS (AM : 2) F8 - Accounting code ICT (AM : 2) F9 - Accounting code PLP (AM : 2) FA - Accounting code ACT (AM : 2) FB - Accounting code OLD (AM : 2) FC - Accounting code TRA (AM : 2) FD - Accounting code STO (AM : 2) FE - Accounting code REA (AM : 2) FF - Accounting code SFA (AM : 2) (FF - FP - Reserved for Asset Transaction Accounting codes) (F* - Reserved for Asset Management module) IA - Query queues (SC : 1) IB - Product groups (SC : 4) IC - Article status (SC : 1) ID - Discount codes (SC : 2) IE - Accounting codes (SC : 2) IF - Maintenance codes (SC : 1) IG - Service levels (SC : 1) IH - Service priority (SC : 1) II - Product categories (SC : 10) IJ - Budget types (SC : 2) IK - Extended product group (SC : 20) IL - Price list (SC/PR/OR/PC : 2) IM - Batch status codes (SC : 1) IN - Cost types (SC : 2) IQ - User defined field 1 (SC : 10) IR - User defined field 2 (SC : 10) IS - User defined field 3 (SC : 8) IT - User defined field 4 (SC : 6) IU - User defined field 5 (SC : 4) IV - User defined field 6 (SC : 4) IW - User defined field 7 (SC : 2) IX - User defined field 8 (SC : 2) IY - User defined field 9 (SC : 2) IZ - User defined field 10 (SC : 2) I1 - Cycle counting reason (SC : 4) I2 - Storage type (SC : 1) I3 - Bin type (SC : 3) I4 - Bin location rule type (SC : 4) GA - Serial number Standard transaction types (SC : 1) GB - Serial number Incident Codes (SC : 4) GC - Serial number Priority Codes (SC : 4) GD - Serial number Action Codes (SC : 4) GE - Serial number Status Codes (SC : 4) GH - QC Category (SC : 2) GF - Serial number User transaction types (SC : 3) HA - Cancellation code (OR : 4) MR - Customer request type (MA : 2) PA - Profession codes (PA : 4, HR/PR/SM : 6) PB - Education codes (PA : ) PC - Categories (PA : ) PD - Departments (PA : 5, HR/PR/SM : 15) PE - Community codes 1 (PA : 2) PF - Community codes 2 (PA : 2) PG - Community codes 3 (PA : 2) PH - Work places (PA : 5) PI - Person categories (PA : 1) PJ - Labour agreement areas (PA : 5) PK - Statistical codes 1 (PA : 1) PL - Statistical codes 2 (PA : 1) PM - Statistical codes 3 (PA : 1) PN - Statistical codes 4 (PA : 1) PO - Statistical codes 5 (PA : 1) PP - Statistical codes 6 (PA : 1) PQ - Vacation codes (PA : 4) PV - History categories (PA : 2) QA - Direct invoicing (DI : 2) R0 - User Field 1 (PR : 20) R1 - User Field 2 (PR : 10) R2 - User Field 3 (PR : 10) R3 - User Field 4 (PR : 8) R4 - User Field 5 (PR : 8) R5 - User Field 6 (PR : 4) R6 - User Field 7 (PR : 4) R7 - User Field 8 (PR : 2) R8 - User Field 9 (PR : 2) R9 - User Field 10 (PR : 1) RA - User DB Defined 1 (PR : 1-35) RB - User DB Defined 2 (PR : 1-35) RC - User DB Defined 3 (PR : 1-35) RD - User DB Defined 4 (PR : 1-35) RE - User DB Defined 5 (PR : 1-35) RF - User DB Defined 6 (PR : 1-35) RG - User DB Defined 7 (PR : 1-35) RH - User DB Defined 8 (PR : 1-35) RI - User DB Defined 9 (PR : 1-35) RJ - User DB Defined 10 (PR : 1-35) RK - (reserved) (PR : ) RL - Project category (PR : 4) RM - Project type (PR : 2) RN - Project status (PR : 1) (not used) RO - Project report codes (PR : 8) RP - Project budget codes (PR : 2) RQ - Project Text Group Description (PR : 1) RR - Project User Def Desc (PR : 1) RS - Accounting Codes Project (PR : 2) RT - Accounting codes Activity (PR : 2) RU - Activity cost category (PR : 1) RV - Activity gategory (PR : 10) RW - Project discount code (PR : 2) RX - Activity discount code (PR : 2) RY - Invoice sort code (PR : 2) RZ - (reserved) (PR : ) S* - (reserved) (PR : ) SB - IBAN Bank types (SY : 2) SE - IBAN Account entry (SY : 1) SF - IBAN Section filling (SY : 1) SG - IBAN Layout groups (SY : 1) ST - IBAN Section type (SY : 1) SV - IBAN Validation rule (SY : 3) TD - District codes (PL : 10) SA - Layout codes (GL : 11) WT - Withholding tax codes (PL : 4) X0 - Printer groups (SY : 2) Y0 - Header batch field 1 (SC/PC/OR/MP : 1) Y1 - Header batch field 2 (SC/PC/OR/MP : 1) Y2 - Header batch field 3 (SC/PC/OR/MP : 1) Y3 - Header batch field 4 (SC/PC/OR/MP : 1) Y4 - Header batch field 5 (SC/PC/OR/MP : 1) Y5 - Header batch field 6 (SC/PC/OR/MP : 1) Y6 - Header batch field 7 (SC/PC/OR/MP : 1) Y7 - Header batch field 8 (SC/PC/OR/MP : 1) Y8 - Header batch field 9 (SC/PC/OR/MP : 1) Y9 - Header batch field 10 (SC/PC/OR/MP : 1) YA - Batch user field 1 (SC/PC/OR/MP : 20) YB - Batch user field 2 (SC/PC/OR/MP : 10) YC - Batch user field 3 (SC/PC/OR/MP : 10) YD - Batch user field 4 (SC/PC/OR/MP : 8) YE - Batch user field 5 (SC/PC/OR/MP : 8) YF - Batch user field 6 (SC/PC/OR/MP : 4) YG - Batch user field 7 (SC/PC/OR/MP : 4) YH - Batch user field 8 (SC/PC/OR/MP : 2) YI - Batch user field 9 (SC/PC/OR/MP : 2) YJ - Batch user field 10 (SC/PC/OR/MP : 1) Z2 - Operation Code (SY/SL/PL : 10) Z3 - Cust/Supp Activity (SY/SL/PL : 10) Z4 - Invoice Type (SY/SL/PL : 10) Z5 - Brazilian Regions (SY/SL/PL : 10) Z6 - City Codes (SY/SL/PL : 10) Z7 - State Codes (SY/SL/PL : 10) Z8 - (reserved) Z9 - Taxable Situation (SY/SL/PL : 10) ZA - Type of Legal Entities (SY/SL/PL : 10) ZB - Service Codes (SY/SL/PL : 10) ZC - Tax Accounting Codes (SY/SL/PL : 1) V* - Reserved for VBA projects (all codes starting with V) W* - Reserved for VBA projects (all codes starting with W except for WT) |
1 | Да |
SY24002 | NVARCHAR | VSTRING | 35 | 0 | 35 | Key | Key | 2 | Да | |
SY24003 | NVARCHAR | VSTRING | 25 | 0 | 25 | TextDescription | Description | |||
SY24004 | NVARCHAR | VSTRING | 12 | 0 | 12 | CodeDepFld1 | Code Dependent Field 1 | |||
SY24005 | NVARCHAR | VSTRING | 6 | 0 | 6 | CodeDepFld2 | Code Dependent Field 2 | |||
SY24006 | NVARCHAR | VSTRING | 8 | 0 | 8 | CodeDepFld3 | Code Dependent Field 3 | |||
SY24007 | NVARCHAR | VSTRING | 10 | 0 | 10 | CodeDepFld4 | Code Dependent Field 4 | |||
SY24008 | NVARCHAR | VSTRING | 35 | 0 | 35 | CodeDepFld5 | Code Dependent Field 5 | |||
SY24009 | NVARCHAR | VSTRING | 35 | 0 | 35 | CodeDepFld6 | Code Dependent Field 6 | |||
SY24010 | NVARCHAR | VSTRING | 35 | 0 | 35 | CodeDepFld7 | Code Dependent Field 7 | |||
SY24011 | NVARCHAR | VSTRING | 35 | 0 | 35 | CodeDepFld8 | Code Dependent Field 8 |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | System Utilities/Office Autom. | General Code File