One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «System Utilities/Office Automation»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица SYDN — Signed Document

Таблица: SYDN — «Signed Document». Маска имени таблицы: «SYDN%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SYDN001 NCHAR STRING 2 0 2 DocType Document Type   1 Да
SYDN002 INT INTEGER 0 0 4 FiscalYear Fiscal Year   2 Да
SYDN003 NCHAR STRING 60 0 60 DocNumber Document Number   3 Да
SYDN004 NCHAR STRING 2 0 2 Module Module      
SYDN005 INT INTEGER 0 0 1 Type Type      
SYDN006 INT INTEGER 0 0 2 Status Status      
SYDN007 NVARCHAR VSTRING 6 0 6 DocIssuer Document Issuer      
SYDN008 NVARCHAR VSTRING 10 0 10 CustSuppCode Customer/Supplier Code      
SYDN009 DATETIME X_DATETIME 0 0 17 StatusDateTime Status Date/Time      
SYDN010 NCHAR STRING 1 0 1 MoveStatus Move Status      
SYDN011 NVARCHAR VSTRING 8 0 8 StatusChangedBy User – last status change      
SYDN012 NVARCHAR VSTRING 200 0 200 DigitalSign Digital Signature      
SYDN013 NVARCHAR VSTRING 100 0 100 SerNumKey Serial Number of Key      
SYDN014 NVARCHAR VSTRING 300 0 300 OrigString Original String      
SYDN015 DATETIME X_DATETIME 0 0 17 CreateDateTime Document Creation Date and Time      
SYDN016 DATETIME X_DATETIME 0 0 17 SystemDateTime System Date/Time      
SYDN017 DATETIME X_DATETIME 0 0 17 MoveStartDateTime Movement Start date/time      
SYDN018 DATETIME X_DATETIME 0 0 17 MoveEndDateTime Movement End date/time      
SYDN019 NVARCHAR VSTRING 8 0 8 CreatedBy User – document created by      
SYDN020 NCHAR STRING 2 0 2 MovementType Movement Type      
SYDN021 NVARCHAR VSTRING 10 0 10 OrderNum Order Number      
SYDN022 INT INTEGER 0 0 7 SequenceNum Sequence Number      
SYDN023 NVARCHAR VSTRING 200 0 200 IdentCode Identification Code      
SYDN024 NVARCHAR VSTRING 200 0 200 MsgForReject Message for reject      
SYDN025 NVARCHAR VSTRING 35 0 35 ShipToAddr1 Ship To-Address 1      
SYDN026 NVARCHAR VSTRING 35 0 35 ShipToAddr2 Ship To-Address 2      
SYDN027 NVARCHAR VSTRING 35 0 35 ShipToAddr3 Ship To-Address 3      
SYDN028 NVARCHAR VSTRING 35 0 35 ShipToAddr4 Ship To-Address 4      
SYDN029 NVARCHAR VSTRING 35 0 35 ShipToAddr5 Ship To-Address 5      
SYDN030 NVARCHAR VSTRING 35 0 35 ShipToAddr6 Ship To-Address 6      
SYDN031 NVARCHAR VSTRING 35 0 35 ShipToAddr7 Ship To-Address 7      
SYDN032 NVARCHAR VSTRING 10 0 10 ShipToZIP Ship To-ZIP code      
SYDN033 NVARCHAR VSTRING 10 0 10 ShipToCity Ship To-City Code      
SYDN034 NCHAR STRING 3 0 3 ShipToCountry Ship To-Country Code      
SYDN035 NVARCHAR VSTRING 35 0 35 ShipFromAddr1 Ship From-Address 1      
SYDN036 NVARCHAR VSTRING 35 0 35 ShipFromAddr2 Ship From-Address 2      
SYDN037 NVARCHAR VSTRING 35 0 35 ShipFromAddr3 Ship From-Address 3      
SYDN038 NVARCHAR VSTRING 35 0 35 ShipFromAddr4 Ship From-Address 4      
SYDN039 NVARCHAR VSTRING 35 0 35 ShipFromAddr5 Ship From-Address 5      
SYDN040 NVARCHAR VSTRING 35 0 35 ShipFromAddr6 Ship From-Address 6      
SYDN041 NVARCHAR VSTRING 35 0 35 ShipFromAddr7 Ship From-Address 7      
SYDN042 NVARCHAR VSTRING 10 0 10 ShipFromZIP Ship From-ZIP code      
SYDN043 NVARCHAR VSTRING 10 0 10 ShipFromCity Ship From-City Code      
SYDN044 NCHAR STRING 3 0 3 ShipFromCountry Ship From-Country Code      
SYDN045 NVARCHAR VSTRING 25 0 25 InvoiceNum Invoice Number      
SYDN046 NVARCHAR VSTRING 50 0 50 Reason Reason      
SYDN047 INT INTEGER 0 0 2 Period Period      
SYDN048 NVARCHAR VSTRING 70 0 70 TransactionID Transaction ID      
SYDN049 INT INTEGER 0 0 2 CurrCodeOCU Currency Code OCU      
SYDN050 NUMERIC X_NUMERIC 28 8 20 TaxPayableLCU Tax Payable LCU      
SYDN051 NUMERIC X_NUMERIC 28 8 20 TaxPayableOCU Tax Payable OCU      
SYDN052 NUMERIC X_NUMERIC 28 8 20 NetTotalLCU Net Total LCU      
SYDN053 NUMERIC X_NUMERIC 28 8 20 NetTotalOCU Net Total OCU      
SYDN054 NUMERIC X_NUMERIC 28 8 20 GrossTotalLCU Gross Total LCU      
SYDN055 NUMERIC X_NUMERIC 28 8 20 GrossTotalOCU Gross Total OCU      

Навигация: