Таблица: PR33 - «Project Automatic Account Coding Schedule». Маска имени таблицы: «PR33%cc%yy»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR33001 | NCHAR | STRING | 2 | 0 | 2 | CustAccCode | Accounting Code Customer | 1 | Да | |
PR33002 | NCHAR | STRING | 2 | 0 | 2 | ProjAccCode | Accounting Code Project | 2 | Да | |
PR33003 | NCHAR | STRING | 2 | 0 | 2 | ActAccCode | Accounting Code Activity | 3 | Да | |
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 | Да |
PR33005 | NCHAR | STRING | 1 | 0 | 1 | ResourceCode | Resource Type | 0 -. Internal human resource
1 - Resource group 2 - External resource 3 - Internal machine resource |
5 | Да |
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 | Да |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Project Automatic Account Coding Schedule