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

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PN01 — Promissory Notes Parameters

Таблица / Table: PN01 — «PN01 Parameters». Маска имени таблицы / Table name mask: «PN01%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PN01001 NCHAR STRING 4 0 4 CompCodYeInd Company Year   1 Да / Yes
PN01002 NCHAR STRING 2 0 2 NoOfPortfoli (obsolete)      
PN01003 NCHAR STRING 6 0 6 StaStamDutPr State Stamp Duty %      
PN01004 NCHAR STRING 9 0 9 StaStamDutAm State Stamp Duty Amount      
PN01005 NCHAR STRING 3 0 3 TCodCusFldRef Tax Code Customer Field Reference      
PN01006 NCHAR STRING 3 0 3 TCodCusFldLen Tax Code Customer Field Length      
PN01007 NCHAR STRING 3 0 3 TOffCustFldRef Tax office Customer File Field Reference      
PN01008 NCHAR STRING 3 0 3 TOffCustFldLen Tax office Customer File Field Length      
PN01009 NCHAR STRING 3 0 3 TCodSupFldRef Tax Code Supplier File Field Reference      
PN01010 NCHAR STRING 3 0 3 TCodSupFldLen Tax Code Supplier File Field Length      
PN01011 NCHAR STRING 3 0 3 TOffSupFldRef Tax Office Supplier File Field Reference      
PN01012 NCHAR STRING 3 0 3 TOffSupFldLen Tax Office Supplier File Field Length      
PN01013 NCHAR STRING 1 0 1 Spare (obsolete)      
PN01014 NCHAR STRING 1 0 1 Spare (obsolete)      
PN01015 NCHAR STRING 1 0 1 Spare (obsolete)      
PN01016 NCHAR STRING 2 0 2 RecInpDefStat Receive from Customer Default Operation      
PN01017 NCHAR STRING 2 0 2 RecOutDefStat Endorsement to Supplier Default Operation      
PN01018 NCHAR STRING 2 0 2 PayableDefStatus Own Issue Default Operation      
PN01019 NCHAR STRING 3 0 3 GracePeriLengt Grace Period      
PN01020 NCHAR STRING 1 0 1 GracePerUnit Grace Period Unit 0 — Days

1 — Calendar periods
   
PN01021 NCHAR STRING 3 0 3 AcceptPerLen Acceptance Period      
PN01022 NCHAR STRING 1 0 1 AcceptPerUnit Acceptance Period Unit 0 — Days

1 — Calendar periods
   
PN01023 NCHAR STRING 3 0 3 ProtestPerLen Protest Period      
PN01024 NCHAR STRING 1 0 1 ProtestPerUnt Protest Period Unit 0 — Days

1 — Calendar periods
   
PN01025 NCHAR STRING 3 0 3 ContLiabPerLen Contingent Liability Margin Period      
PN01026 NCHAR STRING 1 0 1 ContLiabPerUnt Contingent Liability Margin Period Unit 0 — Days

1 — Calendar periods
   
PN01027 NCHAR STRING 2 0 2 StdMonthDay The Standard Month in Days      
PN01028 NCHAR STRING 1 0 1 Spare (obsolete)      
PN01029 NCHAR STRING 1 0 1 Spare (obsolete)      
PN01030 NCHAR STRING 1 0 1 Spare (obsolete)      
PN01031 NCHAR STRING 1 0 1 Spare (obsolete)      
PN01032 NCHAR SWITCH 1 0 1 IntegrWithPL Integrated With Purchase Ledger      
PN01033 NCHAR SWITCH 1 0 1 IntegrWithSL Integrated With Sales Ledger      
PN01034 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PN01035 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PN01036 NCHAR SWITCH 1 0 1 WghtAveDueDt Weighted Average Due Date      
PN01037 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PN01038 NCHAR SWITCH 1 0 1 CheckUniqSN (obsolete)      
PN01039 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PN01040 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PN01041 NCHAR SWITCH 1 0 1 Spare (obsolete)      
PN01042 NCHAR STRING 2 0 2 ShiftSunday Shift Days for Sunday      
PN01043 NCHAR STRING 2 0 2 ShiftMonday Shift Days for Monday      
PN01044 NCHAR STRING 2 0 2 ShiftTuesday Shift Days for Tuesday      
PN01045 NCHAR STRING 2 0 2 ShiftWednesday Shift Days for Wednesday      
PN01046 NCHAR STRING 2 0 2 ShiftThursday Shift Days for Thursday      
PN01047 NCHAR STRING 2 0 2 ShiftFriday Shift Days for Friday      
PN01048 NCHAR STRING 2 0 2 ShiftSaturday Shift Days for Saturday      
PN01049 NCHAR STRING 10 0 10 SettleBankCode Settlement Bank Code      
PN01050 NCHAR STRING 2 0 2 StdPortfolioCR Default Portfolio for Receivable Cheques      
PN01051 NCHAR STRING 2 0 2 StdPortfolioNR Default Portfolio for Payable Cheques      
PN01052 NCHAR STRING 2 0 2 StdPortfolioCP Default Portfolio for Receivables Notes      
PN01053 NCHAR STRING 2 0 2 StdPortfolioNP Default Portfolio for Payable Notes      

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