На один уровень вверх / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PC22 — Received Invoices — Header

Таблица / Table: PC22 — «Invoice Header». Маска имени таблицы / Table name mask: «PC22%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PC22001 NCHAR STRING 25 0 25 InvNum Invoice Number   2 Да / Yes
PC22002 DATETIME DATE 0 0 8 InvDate Invoice Date      
PC22003 DATETIME DATE 0 0 8 EntryDate Date Entered      
PC22004 INT INTEGER 0 0 2 InvMatchStatus Invoice Match Status 0 — Loaded with Error

1 — Loaded

2 — Matched with Error

3 — Matched with Warning

4 — Matched		    
PC22005 NCHAR STRING 10 0 10 SuppCode Supplier Code   1 Да / Yes
PC22006 NVARCHAR VSTRING 35 0 35 SuppName Supplier Name      
PC22007 NCHAR STRING 3 0 3 InvCurr Invoice Currency      
PC22008 NUMERIC MONEY 28 8 20 InvAmnt Invoice Amount      
PC22009 DATETIME DATE 0 0 8 DueDate Due Date      
PC22010 INT INTEGER 0 0 2 PmntTermCode Payment Terms      
PC22011 NVARCHAR VSTRING 50 0 50 PmntTermDescr Payment Terms Description      
PC22012 INT INTEGER 0 0 2 TransMethCode Delivery Terms      
PC22013 NVARCHAR VSTRING 50 0 50 TransMethDescr Delivery Terms Description      
PC22014 INT INTEGER 0 0 2 DelMethCode Delivery Method      
PC22015 NVARCHAR VSTRING 50 0 50 DelMethDescr Description Delivery Method      
PC22016 NCHAR STRING 3 0 3 BankCodeCentral Central Bank Code      
PC22017 NVARCHAR VSTRING 40 0 40 PaymentReferenceComment Payment Reference      
PC22018 NVARCHAR VSTRING 8 0 8 WithholdingTaxCode Withholding Tax Code      
PC22019 NUMERIC MONEY 28 8 20 AmountWithholdingTax Withholding Tax Amount      
PC22020 NUMERIC X_NUMERIC 13 8 5 WithholdingTaxPercent Withholding Tax %      
PC22021 DATETIME DATE 0 0 8 DateBookEntry Book-Entry Date      
PC22022 NCHAR STRING 2 0 2 BankCodeSupplier Bank Code Supplier      
PC22023 NCHAR STRING 2 0 2 PaymentWay Payment Method      
PC22024 NCHAR STRING 1 0 1 FlagPaymentBlock Blocked for Payment      
PC22025 NCHAR STRING 5 0 5 AuthorizationCode Authorization Code      
PC22026 NVARCHAR VSTRING 15 0 15 TextComment Text      
PC22027 NCHAR STRING 1 0 1 PaymentPriority Payment Priority      
PC22028 DATETIME DATE 0 0 8 DateStatusAssigned Date Status Assigned      
PC22029 NVARCHAR VSTRING 50 0 50 Remark Remark      
PC22030 NVARCHAR VSTRING 8 0 8 UserID User      
PC22031 NVARCHAR VSTRING 15 0 15 TaxRegNo Tax Registration Number      
PC22032 INT INTEGER 0 0 1 ECVATStatus EC VAT Status      
PC22033 INT INTEGER 0 0 1 InvPLUpdateStatus Invoice Update Status 0 — Not updated

5 — Updated as Unauthorized

6 — Updated		    
PC22034 NCHAR STRING 6 0 6 TaxLiability Tax Liability      
PC22035 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
PC22036 NVARCHAR VSTRING 10 0 10 FinOperationCode Fin Operation Code      
PC22037 NUMERIC MONEY 28 8 20 NetInvAmntOCU Net Invoice Amount in OCU      
PC22038 INT INTEGER 0 0 3 PaymentBlockReason Payment Block Reason      
PC22039 NVARCHAR VSTRING 25 0 25 ReferenceNumber Reference Number      
PC22040 NUMERIC MONEY 28 8 20 WHTaxBase Withholding Tax Base      
PC22041 NUMERIC MONEY 28 8 20 AmountWithholdingTaxOCU Withholding Tax Amount OCU      
PC22042 NCHAR STRING 4 0 4 WHTaxAmountXMLFlag WH Tax Amount XML Flag      
PC22043 NUMERIC X_NUMERIC 18 8 10 ExchangeRate Exchange Rate      
PC22044 NVARCHAR VSTRING 3 0 3 DocumentType Document Type      
PC22045 NVARCHAR VSTRING 150 0 150 ExtUserdefined1 Ext. User defined 1      
PC22046 NVARCHAR VSTRING 150 0 150 ExtUserdefined2 Ext. User defined 2      
PC22047 NVARCHAR VSTRING 150 0 150 ExtUserdefined3 Ext. User defined 3      
PC22048 NVARCHAR VSTRING 150 0 150 ExtUserdefined4 Ext. User defined 4      
PC22049 NVARCHAR VSTRING 150 0 150 ExtUserdefined5 Ext. User defined 5      
PC22050 NVARCHAR VSTRING 150 0 150 ExtUserdefined6 Ext. User defined 6      
PC22051 NVARCHAR VSTRING 150 0 150 ExtUserdefined7 Ext. User defined 7      
PC22052 NVARCHAR VSTRING 150 0 150 ExtUserdefined8 Ext. User defined 8      
PC22053 NVARCHAR VSTRING 150 0 150 ExtUserdefined9 Ext. User defined 9      
PC22054 NVARCHAR VSTRING 150 0 150 ExtUserdefined10 Ext. User defined 10      
PC22055 NVARCHAR VSTRING 150 0 150 ExtUserdefined11 Ext. User defined 11      
PC22056 NVARCHAR VSTRING 150 0 150 ExtUserdefined12 Ext. User defined 12      
PC22057 NVARCHAR VSTRING 150 0 150 ExtUserdefined13 Ext. User defined 13      
PC22058 NVARCHAR VSTRING 150 0 150 ExtUserdefined14 Ext. User defined 14      
PC22059 NVARCHAR VSTRING 150 0 150 ExtUserdefined15 Ext. User defined 15      
PC22060 NVARCHAR VSTRING 150 0 150 ExtUserdefined16 Ext. User defined 16      
PC22061 NVARCHAR VSTRING 150 0 150 ExtUserdefined17 Ext. User defined 17      
PC22062 NVARCHAR VSTRING 150 0 150 ExtUserdefined18 Ext. User defined 18      
PC22063 NVARCHAR VSTRING 150 0 150 ExtUserdefined19 Ext. User defined 19      
PC22064 NVARCHAR VSTRING 150 0 150 ExtUserdefined20 Ext. User defined 20      
PC22065 NVARCHAR VSTRING 35 0 35 OrigInv Original invoice number      
PC22066 NCHAR STRING 1 0 1 CorrNum Corrective Number      
PC22067 DATETIME DATE 0 0 8 TaxDate TaxDate Date for VAT to make separate transaction (Belgium VAT rules)    
PC22068 NCHAR STRING 2 0 2 PO3Subtype PO3 Sub type      

Навигация / Navigation: