На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «Project Management»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table PR33 — Project Automatic Account Coding Schedule

Таблица / Table: PR33 — «Project Automatic Account Coding Schedule». Маска имени таблицы / Table name mask: «PR33%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PR33001 NCHAR STRING 2 0 2 CustAccCode Accounting Code Customer   1 Да / Yes
PR33002 NCHAR STRING 2 0 2 ProjAccCode Accounting Code Project   2 Да / Yes
PR33003 NCHAR STRING 2 0 2 ActAccCode Accounting Code Activity   3 Да / Yes
PR33004 NCHAR STRING 1 0 1 ActivityType Activity Type 0 — Cost Activity

1 — Time Activity

2 — Material Activity (Sales Order or Purchase Order)

5 — Linked Sales Order

6 — Linked Purchase Order

7 — Linked Service Order

8 — Linked Contract

9 — Linked Work Order		 4 Да / Yes
PR33005 NCHAR STRING 1 0 1 ResourceCode Resource Type 0 -. Internal human resource

1 — Resource group

2 — External resource

3 — Internal machine resource		 5 Да / Yes
PR33006 NVARCHAR VSTRING 12 0 12 Account1 Account Sales Income VAT Exempt      
PR33007 NVARCHAR VSTRING 12 0 12 Account2 Account Sales Income VAT 1      
PR33008 NVARCHAR VSTRING 12 0 12 Account3 Account Sales Income VAT 2      
PR33009 NVARCHAR VSTRING 12 0 12 Account4 Account Sales Income VAT 3-99      
PR33010 NVARCHAR VSTRING 12 0 12 Account5 Account Sales Income Export      
PR33011 NVARCHAR VSTRING 12 0 12 Account6 Account Sales Income Export EC      
PR33012 NVARCHAR VSTRING 12 0 12 Account7 Account Sales Income Internal      
PR33013 NVARCHAR VSTRING 12 0 12 Account8 Account WIP — Account      
PR33014 NVARCHAR VSTRING 12 0 12 Account9 Account Cost Contra Account      
PR33015 NVARCHAR VSTRING 12 0 12 Account10 Account Mark-up Contra Account      
PR33016 NVARCHAR VSTRING 12 0 12 Account11 Account Cost of Sales      
PR33017 NVARCHAR VSTRING 12 0 12 Account12 Account WIP — Contra Account      
PR33018 NVARCHAR VSTRING 12 0 12 Account13 Account WIP Mark-up Contra Account      
PR33019 NVARCHAR VSTRING 12 0 12 Account14 Account Income Overrun VAT Exempt/Internal Debiting On automatic accounting schedule on activity level it’s used for: Internal Debiting    
PR33020 NVARCHAR VSTRING 12 0 12 Account15 Account Income Overrun VAT 1/Internal Debiting Contra On automatic accounting schedule on activity level it’s used for: Internal Debiting Contra Account    
PR33021 NVARCHAR VSTRING 12 0 12 Account16 Account Income Overrun VAT 2/Internal Debiting Mark-up On automatic accounting schedule on activity level it’s used for: Internal Debiting Mark-up    
PR33022 NVARCHAR VSTRING 12 0 12 Account17 Account Income Overrun VAT 3-99 On automatic accounting schedule on activity level it’s used for: Cost quantity variance over run cost    
PR33023 NVARCHAR VSTRING 12 0 12 Account18 Account Income Overrun Export On automatic accounting schedule on activity level it’s used for: Cost quantity variance under run cost    
PR33024 NVARCHAR VSTRING 12 0 12 Account19 Account Income Overrun Export EC On automatic accounting schedule on activity level it’s used for: Cost price variance over run cost    
PR33025 NVARCHAR VSTRING 12 0 12 Account20 Account Income Overrun Internal On automatic accounting schedule on activity level it’s used for: Cost price variance under run cost    
PR33026 NVARCHAR VSTRING 12 0 12 Account21 Account Customer Advances On automatic accounting schedule on activity level it’s used for: Cost quantity and price variance over run cost    
PR33027 NVARCHAR VSTRING 12 0 12 Account22 Account Customer Retentions On automatic accounting schedule on activity level it’s used for: Cost quantity and price variance under run cost    
PR33028 NVARCHAR VSTRING 12 0 12 Account23 Account Internal Debiting      
PR33029 NVARCHAR VSTRING 12 0 12 Account24 Account Internal Debiting Contra      
PR33030 NVARCHAR VSTRING 12 0 12 Account25 Account Internal Debiting Mark-up      
PR33031 NVARCHAR VSTRING 12 0 12 Account26 Account Billings VAT Exempt      
PR33032 NVARCHAR VSTRING 12 0 12 Account27 Account Billings VAT 1      
PR33033 NVARCHAR VSTRING 12 0 12 Account28 Account Billings VAT 2      
PR33034 NVARCHAR VSTRING 12 0 12 Account29 Account Billings VAT 3-99      
PR33035 NVARCHAR VSTRING 12 0 12 Account30 Account Billings Export      
PR33036 NVARCHAR VSTRING 12 0 12 Account31 Account Billings Export EC      
PR33037 NVARCHAR VSTRING 12 0 12 Account32 Account Billings Internal      
PR33038 NVARCHAR VSTRING 12 0 12 Account33 (obsolete)      
PR33039 NVARCHAR VSTRING 12 0 12 Account34 (obsolete)      
PR33040 NVARCHAR VSTRING 12 0 12 Account35 (obsolete)      
PR33041 NVARCHAR VSTRING 12 0 12 Account36 (obsolete)      
PR33042 NVARCHAR VSTRING 12 0 12 Account37 (obsolete)      
PR33043 NVARCHAR VSTRING 12 0 12 Account38 (obsolete)      
PR33044 NVARCHAR VSTRING 12 0 12 Account39 (obsolete)      
PR33045 NVARCHAR VSTRING 12 0 12 Account40 (obsolete)      
PR33046 NVARCHAR VSTRING 2 0 2 ScheduleType Schedule Type   6 Да / Yes

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