Таблица: SC07 - «Stock Transactions». Маска имени таблицы: «SC07%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SC07001 NCHAR STRING 2 0 2 TransactType Transaction Type 00 = Incoming goods
01 = Outgoing goods
02 = Stock taking difference
03 = Cost (allocated to items in stock)
04 = Warehouse movements (between different warehouses)
05 = Price difference (difference between standard cost and purchase price)
06 = Costs items (not used from version 4 of Scala)
07 = Non-allocated cost
08 = Cost adjustment
09 = Bin movement (within one warehouse)
10 = Unallocated cost (used for cost allocated to items that has already been issued)
   
SC07002 DATETIME DATE 0 0 8 TransactDate Transaction Date      
SC07003 NVARCHAR VSTRING 35 0 35 StockCode Stock Item Code      
SC07004 NUMERIC X_NUMERIC 20 8 12 Qty Quantity      
SC07005 NUMERIC MONEY 28 8 20 TransfPrice1 Cost Price (Local Currency)      
SC07006 NVARCHAR VSTRING 10 0 10 Reference Reference      
SC07007 NCHAR STRING 10 0 10 OrderNumber Order Number      
SC07008 NVARCHAR VSTRING 2 0 2 CostType Cost Type      
SC07009 NVARCHAR VSTRING 6 0 6 WarehouseNo Warehouse      
SC07010 NUMERIC MONEY 28 8 20 SellingPrice Selling Price (Local Currency)      
SC07011 NCHAR STRING 2 0 2 AccountCode Accounting Code      
SC07012 NVARCHAR ACCSTR 50 0 50 AccCodString Accounting String      
SC07013 BINARY BINSTRING 1 0 1 TransaSource Transaction Source 0 - Purchase Order
1 - Sales Order
2 - Service Order
4 - Stock Control
5 - Stock Control (Import of stock received transactions)
6 - Stock Control (Import of stock issued transactions)
7 - Stock Control (Movement of asset to stock)
8 - Stock Control (Movement of stock to assets)
A - Work Order
B - Work Order
K - Work Order
L - Work Order
R - Requisition
P - Point of Sales
   
SC07014 NVARCHAR VSTRING 10 0 10 Spare (obsolete)      
SC07015 NVARCHAR VSTRING 20 0 20 DelDocument Delivery Document      
SC07016 NCHAR SWITCH 1 0 1 Flag1GLUpdat General Ledger Updated      
SC07017 NCHAR SWITCH 1 0 1 Flag2GLUpdat General Ledger Update Option      
SC07018 NCHAR SWITCH 1 0 1 Flag3GLUpdat Delivery Document Status      
SC07019 DATETIME DATE 0 0 8 GLTransaDate General Ledger Transaction Date      
SC07020 NCHAR STRING 6 0 6 GLTransactNo General Ledger Transaction Number      
SC07021 NVARCHAR VSTRING 12 0 12 FIFOBatchID Batch ID This is the current batch id of the batch used for the transaction, batch id can change for a batch when its moved between location and it's used to identify each instance of a batch. The original batch number is stored in column SC07029.    
SC07022 NCHAR STRING 8 0 8 SearchIndex Search Key Running counter automatically increased with 1 for each transaction line. Used as primary key for the table. 1 Да
SC07023 NVARCHAR VSTRING 2 0 2 FASB52CurrCo Currency Code FASB52      
SC07024 NUMERIC MONEY 28 8 20 FASB52ExcRat FASB52 Exchange Rate      
SC07025 NCHAR SWITCH 1 0 1 FASB52UpdFlg FASB52 Updated      
SC07026 NVARCHAR VSTRING 6 0 6 BinNumber Bin      
SC07027 NVARCHAR VSTRING 6 0 6 WarehForStoc Contra Warehouse for Movements      
SC07028 NUMERIC MONEY 28 8 20 TransfPrice2 Cost Price (Alternative Currency)      
SC07029 NVARCHAR VSTRING 12 0 12 OrigBatchID Batch Number This is the actual batch number assigned to the batch when it was received into stock, it will not change when it's moved (partially or whole) to another location.    
SC07030 NVARCHAR VSTRING 12 0 12 ParentBatcID Parent Batch ID Used for tracing batches that are moved, should identify the parent batch by it's batch id.    
SC07031 NVARCHAR VSTRING 12 0 12 ChildBatchID Child Batch ID Used for tracing batches that are moved, should identify the child batch by it's batch id.    
SC07032 NVARCHAR VSTRING 6 0 6 BinNoForStoc Contra Bin for Movements      
SC07033 NUMERIC X_NUMERIC 11 8 3 MovementLev Movement Level Used for batch tracing to keeping track of the order batches have been moved, it's value is increased each time a batch is moved.    
SC07034 NVARCHAR VSTRING 1 0 1 DeliTranType Delivery Transaction Type      
SC07035 DATETIME DATE 0 0 8 TransactDate Date Created      
SC07036 NCHAR STRING 6 0 6 Time_ Time Created      
SC07037 NVARCHAR VSTRING 8 0 8 UserID Created By      
SC07038 NVARCHAR VSTRING 27 0 27 Contract Contract      
SC07039 NCHAR STRING 1 0 1 StatusFlag1 Status Flag 1      
SC07040 NCHAR STRING 1 0 1 StatusFlag2 Status Flag 2      
SC07041 NCHAR STRING 1 0 1 StatusFlag3 Status Flag 3      
SC07042 NCHAR STRING 1 0 1 StatusFlag4 Status Flag 4      
SC07043 NCHAR STRING 1 0 1 StatusFlag5 Status Flag 5      
SC07044 NUMERIC X_NUMERIC 18 8 10 FASB52ExchgRate2 (obsolete)      
SC07045 NCHAR STRING 3 0 3 FASB52ExchgAlgtm (obsolete)      
SC07046 NCHAR SWITCH 1 0 1 EDIContractSwitch EDI-Contract      
SC07047 NCHAR STRING 2 0 2 QcCategory Quality Control Category      
SC07048 NCHAR STRING 20 0 20 BoxId Box ID      
SC07049 NVARCHAR VSTRING 1 0 1 Valuation Model Valuation Model      
SC07050 NVARCHAR VSTRING 1 0 1 Valuation Model for CC Valuation Model for Alternative Currency      
SC07051 NVARCHAR VSTRING 2 0 2 Parent Company Code Parent Company Code      
SC07052 NVARCHAR VSTRING 2 0 2 Child Company Code Child Company Code      
SC07053 NVARCHAR VSTRING 20 0 20 Supplier Batch ID Supplier Batch ID      
SC07054 NVARCHAR VSTRING 10 0 10 Picking list number Picking list number      
SC07055 NVARCHAR VSTRING 64 0 64 Note Note      
SC07056 NVARCHAR VSTRING 15 0 15 InvoiceNo InvoiceNo      
SC07057 NVARCHAR VSTRING 1 0 1 Issuer/Receiver Type Issuer/Receiver Type      
SC07058 NVARCHAR VSTRING 10 0 10 Issuer/Receiver Code Issuer/Receiver Code (Supplier or Customer Code)      
SC07059 NVARCHAR VSTRING 12 0 12 WO Received Batch Number WO Received Batch Number      

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Stock Control | Stock Transactions