На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Системные Утилиты/Автом. Офиса»/List of tables of module «System Utilities/Office Autom.»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table SY24 — General Code File

Таблица / Table: SY24 — «General Code File». Маска имени таблицы / Table name mask: «SY24%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
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 Да / Yes
SY24002 NVARCHAR VSTRING 35 0 35 Key Key   2 Да / Yes
SY24003 NVARCHAR VSTRING 60 0 60 TextDescription Description      
SY24004 NVARCHAR VSTRING 18 0 18 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 5      
SY24007 NVARCHAR VSTRING 10 0 10 CodeDepFld4 Code Dependent Field 6      
SY24008 NVARCHAR VSTRING 50 0 50 CodeDepFld5 Code Dependent Field 5      
SY24009 NVARCHAR VSTRING 50 0 50 CodeDepFld6 Code Dependent Field 6      
SY24010 NVARCHAR VSTRING 50 0 50 CodeDepFld7 Code Dependent Field 7      
SY24011 NVARCHAR VSTRING 50 0 50 CodeDepFld8 Code Dependent Field 8      
SY24012 NVARCHAR VSTRING 50 0 50 CodeDepFld9 Code Dependent Field 9      
SY24013 NVARCHAR VSTRING 50 0 50 CodeDepFld10 Code Dependent Field 10      
SY24014 NVARCHAR VSTRING 50 0 50 CodeDepFld11 Code Dependent Field 11      
SY24015 NVARCHAR VSTRING 50 0 50 CodeDepFld12 Code Dependent Field 12      
SY24016 NVARCHAR VSTRING 50 0 50 CodeDepFld13 Code Dependent Field 13      
SY24017 NVARCHAR ACCSTR 120 0 120 AccountingString Accounting String      

Навигация / Navigation: