LG_CSTRANS

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Çek / Senet Hareketi Logical Ref. Check / P. Note Transaction Logical Reference
DATE_ Longint 4 4 Tarih Date
CSREF Longint 4 8 Çek / Senet Kartı Ref. Check / P. Note Card Reference
ROLLREF Longint 4 12 Fiş ref. Slip Reference
TRCODE Integer 2 16 Hareket türü Transaction Type
ACCOUNTED Byte 1 18 Muhasebeleştirildi Posted to General Ledger
DEVIR Byte 1 19 Devir Carrying Over
STATUS Byte 1 20 Durumu Status
CARDMD Byte 1 21 Kart Modül Numarası ; 1-4 Cari Hesap (5);5-8 Banka Hesabı (7) Card Module Number ;1-4 Account Receivable / Payable (5);5-8 Bank Account (7)
CARDREF Longint 4 22 Kart Referansı Card Reference
STATNO Integer 2 26 Statü numarası Status Number
LINENO_ Integer 2 28 Fişin hangi satır numarası Which Line Number of Slip
ACCREF Longint 4 30 Genel Muhasebe Hesabı Ref. General Ledger Account Reference
COSTREF Longint 4 34 Masraf Merkezi Ref. Overhead Pool Reference
CRSACCREF Longint 4 38 Kapanmış Hesabın Genel Muhasebe Hesabı Ref. General Ledger Account Reference of Closed Account
CRSCOSTREF Longint 4 42 Kapanmış Hesap Masraf Merkezi Ref. Overhead Pool Reference of Closed Account
FROMCASH Byte 1 46 Kasadan Processed from Safe Deposit
CANCELLED Byte 1 47 İptal Edilmiş Cancelled
LINEEXCTYP Integer 2 48 Döviz Türü (Satır) F. Currency Type (Line)
OPSTAT Integer 2 50 Hareket durumu Transaction Status

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
2 3 737   CSREF L_CSCARD LOGICALREF one-to-one  
2 3 737   ROLLREF L_CSROLL LOGICALREF one-to-one  
2 3 737   ACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 737   COSTREF L_EMCENTER LOGICALREF one-to-one  
2 3 737   CRSACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 737   CRSCOSTREF L_EMCENTER LOGICALREF one-to-one  
2 3 737   CARDREF L_CLCARD LOGICALREF one-to-one TRCODE=01, 02, 03, 04, 09, 10, 11, 12
2 3 737   CARDREF L_BANKACC LOGICALREF one-to-one TRCODE=05, 06, 07, 08,

Indexler

Level Product ID Index Name Attributes Segment No Segment Field Sense
2 3 Index1 Unique + Not Null 1 LOGICALREF Ascending
2 3 Index2 Duplicate + Not Null 1 CSREF Ascending
2 3 Index2 Duplicate + Not Null 2 STATNO Ascending
2 3 Index3 Duplicate + Not Null 1 ROLLREF Ascending
2 3 Index3 Duplicate + Not Null 2 LINENO_ Ascending
2 3 Index4 Duplicate + Not Null 1 DATE_ Ascending

>