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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PN08001 NCHAR STRING 2 0 2 TransactCode Transaction Code   1 Да
PN08002 NVARCHAR VSTRING 25 0 25 TransactName Transaction Name      
PN08003 NVARCHAR VSTRING 25 0 25 TransactDes1 Transaction Description Line 1      
PN08004 NVARCHAR VSTRING 25 0 25 TransactDes2 Transaction Description Line 2      
PN08005 NVARCHAR VSTRING 25 0 25 TransactText Transaction Text      
PN08006 NCHAR STRING 2 0 2 InitialStat1 Initial Status 1      
PN08007 NCHAR STRING 2 0 2 InitialStat2 Initial Status 2      
PN08008 NCHAR STRING 2 0 2 InitialStat3 Initial Status 3      
PN08009 NCHAR STRING 2 0 2 Final_Status Final Status      
PN08010 NCHAR STRING 7 0 7 PortfContAcc Portfolio Account Fraction      
PN08011 NCHAR STRING 7 0 7 StampDutyAccount Stamp Duty Account Fraction      
PN08012 NCHAR STRING 7 0 7 CollecFeeAcc Collection Fee Account Fraction      
PN08013 NCHAR STRING 7 0 7 DepositAccnt Deposit Account Fraction      
PN08014 NCHAR STRING 7 0 7 ProtestAccnt Protest Account Fraction      
PN08015 NCHAR STRING 7 0 7 BankAccount Bank Account Fraction      
PN08016 NCHAR STRING 1 0 1 SetExRatProf Settlement Exchange Rate Profit      
PN08017 NCHAR STRING 1 0 1 SetExRatLoss Settlement Exchange Rate Loss      
PN08018 NCHAR STRING 12 0 12 OtherAccNo Other Account Number      
PN08019 NCHAR STRING 7 0 7 OtherAccount Other Account Fraction      
PN08020 NCHAR STRING 1 0 1 InpuOutpSign Input/Output Sign 0 - Internal
1 - Input
2 - Output
   
PN08021 NCHAR STRING 1 0 1 SettlmntFlag Settlement PN/PDC      
PN08022 NCHAR STRING 1 0 1 Type Type 0 - Undefined
1 - Reception
2 - Collection
3 - Return from supplier
4 - Protest
5 - Internal portfolio
6 - Returned to customer with reversal of payment
7 - Lost note
8 - Jumped note
9 - Returned from supplier with reversal of payment
   

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Promissory Notes | Operations