Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: PC14 - «Order Line Del.». Маска имени таблицы: «PC14%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PC14001 | NCHAR | STRING | 10 | 0 | 10 | OrderNo | 1 | Да | ||
PC14002 | NCHAR | STRING | 6 | 0 | 6 | LineNo | 2 | Да | ||
PC14003 | NCHAR | STRING | 6 | 0 | 6 | StructLineNo | 3 | Да | ||
PC14004 | NCHAR | STRING | 4 | 0 | 4 | AutSubStrLNo | 4 | Да | ||
PC14005 | NVARCHAR | VSTRING | 12 | 0 | 12 | BatchNumber | ||||
PC14006 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyInvoiced | ||||
PC14007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyDelivered | ||||
PC14008 | DATETIME | DATE | 0 | 0 | 8 | DelivDateAct | ||||
PC14009 | NVARCHAR | VSTRING | 20 | 0 | 20 | DelivNoteNo | ||||
PC14010 | NUMERIC | MONEY | 28 | 8 | 20 | UnitCostPric | ||||
PC14011 | NVARCHAR | VSTRING | 6 | 0 | 6 | BinNo | ||||
PC14012 | INT | INTEGER | 0 | 0 | 1 | LockStatus09 | ||||
PC14013 | NVARCHAR | VSTRING | 20 | 0 | 20 | SearchField | ||||
PC14014 | DATETIME | DATE | 0 | 0 | 8 | DateReceived | ||||
PC14015 | DATETIME | DATE | 0 | 0 | 8 | DateManufact | ||||
PC14016 | DATETIME | DATE | 0 | 0 | 8 | DatBestBefor | ||||
PC14017 | DATETIME | DATE | 0 | 0 | 8 | DateShipBef | ||||
PC14018 | NVARCHAR | VSTRING | 20 | 0 | 20 | SupplBatchID | ||||
PC14019 | NVARCHAR | VSTRING | 20 | 0 | 20 | UserDefFld1 | ||||
PC14020 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefFld2 | ||||
PC14021 | NVARCHAR | VSTRING | 10 | 0 | 10 | UserDefFld3 | ||||
PC14022 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserDefFld4 | ||||
PC14023 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserDefFld5 | ||||
PC14024 | NVARCHAR | VSTRING | 4 | 0 | 4 | UserDefFld6 | ||||
PC14025 | NVARCHAR | VSTRING | 4 | 0 | 4 | UserDefFld7 | ||||
PC14026 | NVARCHAR | VSTRING | 2 | 0 | 2 | UserDefFld8 | ||||
PC14027 | NVARCHAR | VSTRING | 2 | 0 | 2 | UserDefFld9 | ||||
PC14028 | NVARCHAR | VSTRING | 1 | 0 | 1 | UserDefFld10 | ||||
PC14029 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | NetWeight | ||||
PC14030 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | GrossWeight | ||||
PC14031 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Volume | ||||
PC14032 | DATETIME | DATE | 0 | 0 | 8 | DelDateRequ | ||||
PC14033 | DATETIME | DATE | 0 | 0 | 8 | DelDateCommi | ||||
PC14034 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | DelDatExRate | ||||
PC14035 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyDelivSc | ||||
PC14036 | DATETIME | DATE | 0 | 0 | 8 | DelDatBackOr | ||||
PC14037 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | PurchSurchar | ||||
PC14038 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Discount | ||||
PC14039 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyInvcedPC | ||||
PC14040 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyDelTimePC | ||||
PC14041 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyDelTimeSC | ||||
PC14042 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyInvTimePC | ||||
PC14043 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyInvTimeSC | ||||
PC14044 | INT | INTEGER | 0 | 0 | 1 | BatchDelExis | ||||
PC14045 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | DlvryDateExchgRate2 | ||||
PC14046 | NCHAR | STRING | 3 | 0 | 3 | DlvryDateExchgAlgtm | ||||
PC14047 | INT | INTEGER | 0 | 0 | 2 | CurrencyCode | ||||
PC14048 | NVARCHAR | VSTRING | 10 | 0 | 10 | AutoDelNoteNo | ||||
PC14049 | NCHAR | STRING | 12 | 0 | 12 | OriginalBatchId | ||||
PC14050 | NCHAR | STRING | 2 | 0 | 2 | QCCategory | ||||
PC14051 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | PotencyFactor | ||||
PC14052 | DATETIME | DATE | 0 | 0 | 8 | DateOfExpiry | ||||
PC14053 | NCHAR | STRING | 25 | 0 | 25 | Customs Despatch Note Number | ||||
PC14054 | DATETIME | DATE | 0 | 0 | 8 | Date Imported | ||||
PC14055 | NCHAR | STRING | 3 | 0 | 3 | Country of Origin | ||||
PC14056 | NCHAR | STRING | 10 | 0 | 10 | Customs Office Code | ||||
PC14057 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Rejected quantity | Rejected quantity | |||
PC14058 | NVARCHAR | VSTRING | 4 | 0 | 4 | Rejection Code | Rejection Code | |||
PC14059 | NVARCHAR | VSTRING | 12 | 0 | 12 | Temperature | Temperature | |||
PC14060 | NVARCHAR | VSTRING | 12 | 0 | 12 | Humidity | Humidity | |||
PC14061 | NVARCHAR | VSTRING | 12 | 0 | 12 | User def. 1 | User def. 1 | |||
PC14062 | NVARCHAR | VSTRING | 12 | 0 | 12 | User def. 2 | User def. 2 | |||
PC14063 | NVARCHAR | VSTRING | 12 | 0 | 12 | User def. 3 | User def. 3 | |||
PC14064 | NVARCHAR | VSTRING | 12 | 0 | 12 | User def. 4 | User def. 4 | |||
PC14065 | NVARCHAR | VSTRING | 12 | 0 | 12 | User def. 5 | User def. 5 | |||
PC14066 | NCHAR | STRING | 4 | 0 | 4 | DestinationCode | DestinationCode |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Order | Order Line Del.