Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PR38 - «Project Invoice History Details File». Маска имени таблицы: «PR38%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR38001 | NVARCHAR | VSTRING | 12 | 0 | 12 | ProjectNo | Project Number | 1 | Да | |
PR38002 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubProject | Sub-Project Invoice | Only used when invoicing is done on sub-project level | 2 | Да |
PR38003 | DATETIME | DATE | 0 | 0 | 8 | InvoiceDate | Invoice Date | 3 | Да | |
PR38004 | NVARCHAR | VSTRING | 15 | 0 | 15 | InvoiceNo | Invoice Number | 4 | Да | |
PR38005 | NVARCHAR | VSTRING | 2 | 0 | 2 | SequenceNo | Sequence Number | 6 | Да | |
PR38006 | NVARCHAR | VSTRING | 46 | 0 | 46 | InvSortCode | Invoice Sort Key | 7 | Да | |
PR38007 | NVARCHAR | VSTRING | 10 | 0 | 10 | Manager | Resource Code Manager | |||
PR38008 | NVARCHAR | VSTRING | 6 | 0 | 6 | SubProjTrans | Sub-Project Transaction | |||
PR38009 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityLine | Activity Line Number | |||
PR38010 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivStruLin | Activity Sub-line Number | |||
PR38011 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | |||
PR38012 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceCode | Resource Code | |||
PR38013 | NVARCHAR | VSTRING | 6 | 0 | 6 | TransactLine | Transaction Line Number | |||
PR38014 | NUMERIC | MONEY | 28 | 8 | 20 | PropInvAmoun | Invoice Line Amount | |||
PR38015 | NUMERIC | MONEY | 28 | 8 | 20 | PriceToInvo | Unit Price to Invoice (Project Currency) | |||
PR38016 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | HoursQty | Quantity/Hours to Invoice | |||
PR38017 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Markup | Mark-up % | |||
PR38018 | NUMERIC | MONEY | 28 | 8 | 20 | PrcFromFixPr | Distributed Price from Fixed Price | |||
PR38019 | NVARCHAR | VSTRING | 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 |
||
PR38020 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityCode | Activity Code | |||
PR38021 | NVARCHAR | VSTRING | 4 | 0 | 4 | LinNoInvPlan | Line Number on Invoice Plan | |||
PR38022 | NVARCHAR | VSTRING | 1 | 0 | 1 | InvTrigger | Selected for Invoice | |||
PR38023 | NVARCHAR | VSTRING | 1 | 0 | 1 | InclFixedPrc | Included in Fixed Price | |||
PR38024 | NCHAR | STRING | 15 | 0 | 15 | CreditforInvoiceNo | Invoice Number to be Credited | |||
PR38025 | NCHAR | STRING | 10 | 0 | 10 | CustCodeInv | Customer Code Invoice | |||
PR38026 | NCHAR | STRING | 2 | 0 | 2 | LineType | Line Type | Either an activity type 0-9 or 50 for details of deduction of advance amounts on invoices. | 5 | Да |
PR38027 | NVARCHAR | VSTRING | 15 | 0 | 15 | InitialInvoiceNumber | Initial Invoice Number | |||
PR38028 | NCHAR | STRING | 6 | 0 | 6 | TAXCode | VAT Code | |||
PR38029 | NUMERIC | MONEY | 28 | 8 | 20 | TAXAmount | VAT Amount (Project Currency) | |||
PR38030 | NVARCHAR | VSTRING | 10 | 0 | 10 | OperationType | Operation Type | |||
PR38031 | NVARCHAR | VSTRING | 10 | 0 | 10 | FinancialOperationCode | Financial Operation Code |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Project Management | Project Invoice History Details