Таблица: PCD1 - «Customs Declaration Header». Маска имени таблицы: «PCD1%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PCD1001 | NVARCHAR | VSTRING | 10 | 0 | 10 | BrokerSupplierCode | Broker Supplier Code | 1 | Да | |
PCD1002 | NVARCHAR | VSTRING | 25 | 0 | 25 | CustomsDeclarationNumber | Customs Declaration Number | 2 | Да | |
PCD1003 | NVARCHAR | VSTRING | 25 | 0 | 25 | ElectronicInvoiceNumber | Electronic Invoice Number | |||
PCD1004 | NVARCHAR | VSTRING | 10 | 0 | 10 | SupplierCode | Supplier Code | |||
PCD1005 | NCHAR | STRING | 1 | 0 | 1 | Status | Status | |||
PCD1006 | NVARCHAR | VSTRING | 50 | 0 | 50 | FiscalKeyInvoice | Fiscal Key for Invoice | |||
PCD1007 | DATETIME | DATE | 0 | 0 | 8 | DateFKReceived | Date Fiscal Key received | |||
PCD1008 | DATETIME | DATE | 0 | 0 | 8 | DateOfEntry | Date of Entry | |||
PCD1009 | NCHAR | STRING | 1 | 0 | 1 | Closed | Closed | |||
PCD1010 | NVARCHAR | VSTRING | 25 | 0 | 25 | BrokerInvoiceNumber | Broker Invoice Number | |||
PCD1011 | NVARCHAR | VSTRING | 30 | 0 | 30 | PlaceOfClearance | Place of Clearance | |||
PCD1012 | NCHAR | STRING | 2 | 0 | 2 | StateOfClearance | State of Clearance | |||
PCD1013 | DATETIME | DATE | 0 | 0 | 8 | ClearanceDate | Clearance Date | |||
PCD1014 | NCHAR | STRING | 10 | 0 | 10 | ExporterCode | Exporter Code | |||
PCD1015 | NCHAR | STRING | 10 | 0 | 10 | FiscalKeyRequestNumber | Fiscal Key Request Number | |||
PCD1016 | NUMERIC | MONEY | 28 | 8 | 20 | FixedTaxAmount1 | Fixed Tax Amount 1 | |||
PCD1017 | NUMERIC | MONEY | 28 | 8 | 20 | FixedTaxAmount2 | Fixed Tax Amount 2 | |||
PCD1018 | NUMERIC | MONEY | 28 | 8 | 20 | FixedTaxAmount3 | Fixed Tax Amount 3 | |||
PCD1019 | NUMERIC | MONEY | 28 | 8 | 20 | FixedTaxAmount4 | Fixed Tax Amount 4 | |||
PCD1020 | NUMERIC | MONEY | 28 | 8 | 20 | FixedTaxAmount5 | Fixed Tax Amount 5 | |||
PCD1021 | INT | INTEGER | 0 | 0 | 1 | AdditionalInvoiceFlag | Additional Invoice Flag | 3 | Да | |
PCD1022 | DATETIME | DATE | 0 | 0 | 8 | EInvoiceDate | E-Invoice Date | |||
PCD1023 | INT | INTEGER | 0 | 0 | 2 | CurrencyCode | Currency Code | |||
PCD1024 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | ExchangeRate | Exchange Rate | |||
PCD1025 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchangeRate2 | Exchange Rate 2 | |||
PCD1026 | NCHAR | STRING | 3 | 0 | 3 | ExchAlg | Exchange Algorithm |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Purchase Order | Customs Declaration Header