One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список таблиц модуля /List of tables of module «General Ledger»

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table GLC8 — Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance

Таблица / Table: GLC8 — «Statement- or Debit/Credit Notification Entry Detail Transaction Structured Remittance». Маска имени таблицы / Table name mask: «GLC8%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
GLC8001 NCHAR STRING 35 0 35 MessageID Message ID   1 Да / Yes
GLC8002 NCHAR STRING 4 0 4 PageNo Page Number   2 Да / Yes
GLC8003 NCHAR STRING 35 0 35 StatementNotifID Statement/Notification ID   3 Да / Yes
GLC8004 NCHAR STRING 35 0 35 EntryID Entry ID   4 Да / Yes
GLC8005 NCHAR STRING 6 0 6 EntryDetail Entry detail No   5 Да / Yes
GLC8006 NCHAR STRING 6 0 6 TransNo Transaction No   6 Да / Yes
GLC8007 NCHAR STRING 6 0 6 RemittanceNo Remittance No   7 Да / Yes
GLC8008 NVARCHAR VSTRING 35 0 35 DocRef Document Reference      
GLC8009 NCHAR STRING 4 0 4 DocRefType Document Reference Type      
GLC8010 NUMERIC MONEY 28 8 20 RemittanceAmnt Remittance Amount      
GLC8011 NCHAR STRING 3 0 3 CurrencyRA Currency      
GLC8012 NUMERIC MONEY 28 8 20 CreditNoteAmnt Credit Note Amount      
GLC8013 NCHAR STRING 3 0 3 CurrencyCNA Currency      
GLC8014 NVARCHAR VSTRING 35 0 35 CreditorRef Creditor Reference      
GLC8015 NCHAR STRING 4 0 4 CreditorRefType Creditor Reference Type      
GLC8016 NVARCHAR VSTRING 140 0 140 RemittanceInfo1 Remittance Info 1      
GLC8017 NVARCHAR VSTRING 140 0 140 RemittanceInfo2 Remittance Info 2      
GLC8018 NVARCHAR VSTRING 140 0 140 RemittanceInfo3 Remittance Info 3      
GLC8019 NCHAR STRING 1 0 1 ProcessingStatus Processing status      
GLC8020 NCHAR STRING 1 0 1 CreatedFromUnstruct Created from unstructured      
GLC8021 NVARCHAR VSTRING 38 0 38 LinkToGLC7 GUID — link to GLC7      
GLC8022 NVARCHAR VSTRING 38 0 38 ReferenceGUID Reference GUID      
GLC8023 NCHAR STRING 2 0 2 PaymentModule Payment Module (PL, SL)      
GLC8024 NVARCHAR VSTRING 10 0 10 SuppCustCode Supplier-/Customer Code      
GLC8025 NVARCHAR VSTRING 50 0 50 InvoiceNo Invoice Number      
GLC8026 INT INTEGER 0 0 3 InstalmentNo Instalment Number      
GLC8027 NCHAR STRING 1 0 1 LinkStatus Link status      
GLC8028 NVARCHAR VSTRING 12 0 12 GLAccBank GL Account (Bank)      
GLC8029 NVARCHAR VSTRING 9 0 9 TransNo Transaction Number      
GLC8030 NUMERIC MONEY 28 8 20 OrigRemittanceAmnt Original Remittance Amount      
GLC8031 NVARCHAR VSTRING 6 0 6 OrigRemittanceNo Reference to the original structured remittance      
GLC8032 NVARCHAR VSTRING 12 0 12 GLCurrAcc Statistical GL Currency Account      
GLC8033 NUMERIC MONEY 28 8 20 RemittanceAmntLCU Remittance Amount LCU      
GLC8034 NCHAR SWITCH 1 0 1 UsePrepaymentAcc Use Prepayment Account      

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