Таблица: PCR5 - «Requisition History Lines». Маска имени таблицы: «PCR5%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PCR5001 | NVARCHAR | VSTRING | 10 | 0 | 10 | RequisitionHeaderNo | Requisition Number | 1 | Да | |
PCR5002 | NVARCHAR | VSTRING | 4 | 0 | 4 | RequisitionLineNo | Requisition Line Number | 2 | Да | |
PCR5003 | NVARCHAR | VSTRING | 1 | 0 | 1 | ReqType | Requisition Type | 0 - Undefined
1 - Normal purchase order 2 - Stock transfer 3 - Direct delivery 4 - Commissary item 5 - Stock issue |
||
PCR5004 | NVARCHAR | VSTRING | 6 | 0 | 6 | DepartmentCode | Department Code | |||
PCR5005 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
PCR5006 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
PCR5007 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
PCR5008 | NVARCHAR | VSTRING | 25 | 0 | 25 | StockDescription1 | Stock Item Description | |||
PCR5009 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QuantityOrdered | Quantity Ordered | |||
PCR5010 | NUMERIC | MONEY | 28 | 8 | 20 | Price | Unit Price | |||
PCR5011 | NVARCHAR | VSTRING | 1 | 0 | 1 | AuthorizationStatus | Authorization Status | 0 - Not authorized
1 - Authorized 2 - Rejected |
||
PCR5012 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserEnterAuthStatus | Last Authorized By | |||
PCR5013 | NVARCHAR | VSTRING | 50 | 0 | 50 | AccString | Accounting String | |||
PCR5014 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserPrintRqsnLine | Printed By | |||
PCR5015 | DATETIME | DATE | 0 | 0 | 8 | RequisitionDate | Requisition Date | |||
PCR5016 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserRQSNEnter | Created/Updated By | |||
PCR5017 | NVARCHAR | VSTRING | 4 | 0 | 4 | LinkedRqsnLine | Linked Requisition Line Number | |||
PCR5018 | NVARCHAR | VSTRING | 1 | 0 | 1 | AccStrManualChange | Accounting String Manually Changed | |||
PCR5019 | NVARCHAR | VSTRING | 6 | 0 | 6 | ToWarehouse | To Warehouse | |||
PCR5020 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyIssued | Issued (Delivered) Quantity | |||
PCR5021 | NVARCHAR | VSTRING | 10 | 0 | 10 | PurchaseOrderNo | Purchase Order Number | |||
PCR5022 | NVARCHAR | VSTRING | 6 | 0 | 6 | PurchaseOrderLineNo | Purchase Order Line Number | |||
PCR5023 | NVARCHAR | VSTRING | 6 | 0 | 6 | PurchaseOrderSubLineNo | Purchase Order Sub-line Number | |||
PCR5024 | DATETIME | DATE | 0 | 0 | 8 | IssueReceiptDate | Issue/Receipt Date | |||
PCR5025 | NVARCHAR | VSTRING | 1 | 0 | 1 | RequisitionLineStatus | Requisition Line Status | |||
PCR5026 | DATETIME | DATE | 0 | 0 | 8 | ConversionDeletionDate | Conversion/Deletion Date | |||
PCR5027 | NCHAR | SWITCH | 1 | 0 | 1 | NonregisteredItem | Non-Stock Item | |||
PCR5028 | INT | INTEGER | 0 | 0 | 4 | UnitCode | Unit Code | |||
PCR5029 | NVARCHAR | VSTRING | 2 | 0 | 2 | CurrencyCode | Currency Code | |||
PCR5030 | DATETIME | DATE | 0 | 0 | 8 | RequiredDeliveryDate | Required Delivery Date | |||
PCR5031 | NVARCHAR | VSTRING | 25 | 0 | 25 | StockDescription2 | Stock Description 2 | |||
PCR5032 | NUMERIC | X_NUMERIC | 26 | 8 | 18 | UnitConversionFactor | Unit Conversion Factor | |||
PCR5033 | NCHAR | STRING | 1 | 0 | 1 | SuppManualChange | Was Supplier manually changed? | |||
PCR5034 | NCHAR | STRING | 1 | 0 | 1 | PriceManualChange | Was Price manually changed? | |||
PCR5035 | NCHAR | STRING | 10 | 0 | 10 | PickListID | Picking List Id | |||
PCR5036 | NVARCHAR | VSTRING | 6 | 0 | 6 | FromBin | From Bin | |||
PCR5037 | NVARCHAR | VSTRING | 6 | 0 | 6 | ToBin | To Bin | |||
PCR5038 | INT | INTEGER | 0 | 0 | 1 | PickingStatus | Picking Status | 0 – Not Processed
1 - Request Created 2 – Printed 3 – Started 4 – Closed |
||
PCR5039 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Spare | Spare | |||
PCR5040 | NCHAR | STRING | 10 | 0 | 10 | OrReference | OR Reference | Link requisitions released from MRP or SRP to demand | ||
PCR5041 | NCHAR | STRING | 14 | 0 | 14 | OrLineRef | OR Line Ref | Link requisitions released from MRP or SRP to demand | ||
PCR5042 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef1 | Extended User-Defined Field 1 | |||
PCR5043 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef2 | Extended User-Defined Field 2 | |||
PCR5044 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef3 | Extended User-Defined Field 3 | |||
PCR5045 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef4 | Extended User-Defined Field 4 | |||
PCR5046 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef5 | Extended User-Defined Field 5 | |||
PCR5047 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef6 | Extended User-Defined Field 6 | |||
PCR5048 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef7 | Extended User-Defined Field 7 | |||
PCR5049 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef8 | Extended User-Defined Field 8 | |||
PCR5050 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef9 | Extended User-Defined Field 9 | |||
PCR5051 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef10 | Extended User-Defined Field 10 | |||
PCR5052 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef11 | Extended User-Defined Field 11 | |||
PCR5053 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef12 | Extended User-Defined Field 12 | |||
PCR5054 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef13 | Extended User-Defined Field 13 | |||
PCR5055 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef14 | Extended User-Defined Field 14 | |||
PCR5056 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef15 | Extended User-Defined Field 15 | |||
PCR5057 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef16 | Extended User-Defined Field 16 | |||
PCR5058 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef17 | Extended User-Defined Field 17 | |||
PCR5059 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef18 | Extended User-Defined Field 18 | |||
PCR5060 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef19 | Extended User-Defined Field 19 | |||
PCR5061 | NVARCHAR | VSTRING | 50 | 0 | 50 | ExUserDef20 | Extended User-Defined Field 20 |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Order | Requisition History Lines