One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «System Utilities/Office Automation»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SY24 — General Code File

Таблица: 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 50 0 50 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      

Навигация: