Таблица: PR46 - «Invoice Statistics Lines». Маска имени таблицы: «PR46%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PR46001 | NVARCHAR | VSTRING | 12 | 0 | 12 | Project_No | Project Number | 1 | Да | |
PR46002 | NVARCHAR | VSTRING | 15 | 0 | 15 | Invoice_No | Invoice Number | 2 | Да | |
PR46003 | NVARCHAR | VSTRING | 6 | 0 | 6 | Line_Number | Line Number | 3 | Да | |
PR46004 | NVARCHAR | VSTRING | 6 | 0 | 6 | Sub_Project | Sub-Project | |||
PR46005 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescrSubProj | Description Sub-Project | |||
PR46006 | NVARCHAR | VSTRING | 10 | 0 | 10 | ManagSubProj | Manager Sub-Project | |||
PR46007 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivityLine | Activity Line Number | |||
PR46008 | NVARCHAR | VSTRING | 6 | 0 | 6 | ActivStrLine | Activity Sub-line Number | |||
PR46009 | NVARCHAR | VSTRING | 6 | 0 | 6 | Activ_Code | Activity Code | |||
PR46010 | NVARCHAR | VSTRING | 1 | 0 | 1 | TypeOfActiv | 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 |
||
PR46011 | NVARCHAR | VSTRING | 35 | 0 | 35 | DescActiLine | Description Activity Line | |||
PR46012 | NVARCHAR | VSTRING | 10 | 0 | 10 | ManaActiLine | Manager Activity Line | |||
PR46013 | NVARCHAR | VSTRING | 1 | 0 | 1 | InclFixPrice | Is Included in Fixed Price | |||
PR46014 | NVARCHAR | VSTRING | 8 | 0 | 8 | ReportCode | Report Code Transaction | |||
PR46015 | NVARCHAR | VSTRING | 1 | 0 | 1 | LinkedModule | Linked Module | Only used for activity type 0 and 2:
0 - Purchase Order 1 - Sales Order |
||
PR46016 | NVARCHAR | VSTRING | 10 | 0 | 10 | LinkedOrdNo | Linked Order Number | |||
PR46017 | DATETIME | DATE | 0 | 0 | 8 | TransactDate | Transaction Date | |||
PR46018 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceCode | Resource Code | |||
PR46019 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | InvcdHrsQty | Invoiced Quantity/Hours | |||
PR46020 | NUMERIC | MONEY | 28 | 8 | 20 | InvoicePrice | Unit Price Invoiced (Project Currency) | |||
PR46021 | NUMERIC | MONEY | 28 | 8 | 20 | Cost | Unit Cost (Local Currency) | |||
PR46022 | NVARCHAR | VSTRING | 1 | 0 | 1 | ChargeCode | Charge Activity | 0 - Activity shall not be charged to customer but cost allocated to the project
1 - Activity will included when invoicing the project |
||
PR46023 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccounString | Accounting String | |||
PR46024 | NVARCHAR | VSTRING | 6 | 0 | 6 | VATcode | VAT Code | |||
PR46025 | NVARCHAR | VSTRING | 6 | 0 | 6 | LinkActiLine | Linked Activity Line Number | |||
PR46026 | NVARCHAR | VSTRING | 6 | 0 | 6 | LnkActStrLin | Linked Activity Sub-line Number | |||
PR46027 | NVARCHAR | VSTRING | 1 | 0 | 1 | DateType012 | Date Type | Time reported as per:
0 - Date 1 - Week 2 - Month |
||
PR46028 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ActuHrsQty | Actual Quantity/Hours | |||
PR46029 | NCHAR | STRING | 3 | 0 | 3 | TransactionNo_Act | Activity Transaction Line | |||
PR46030 | NCHAR | STRING | 10 | 0 | 10 | Customer_Code_Invoice | Customer Code Invoice |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Project Management | Invoice Statistics Lines