One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PL19 — Suppliers Templates

Таблица / Table: PL19 — «Standard Suppliers». Маска имени таблицы / Table name mask: «PL19%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PL19001 NCHAR STRING 10 0 10 SupplierCode Supplier Template Code   1 Да / Yes
PL19002 NVARCHAR VSTRING 35 0 35 SupplierName Supplier Name      
PL19003 NVARCHAR VSTRING 35 0 35 AddressLine1 Address Line 1      
PL19004 NVARCHAR VSTRING 35 0 35 AddressLine2 Address Line 2      
PL19005 NVARCHAR VSTRING 35 0 35 AddressLine3 Address Line 3      
PL19006 NVARCHAR VSTRING 20 0 20 Reference Reference      
PL19007 NVARCHAR VSTRING 4 0 4 Category Supplier Category      
PL19008 NVARCHAR VSTRING 20 0 20 TelephonNo Telephone Number      
PL19009 NVARCHAR VSTRING 10 0 10 TelexNo Telex Number      
PL19010 NVARCHAR VSTRING 20 0 20 TelefaxNo Telefax Number      
PL19011 NVARCHAR VSTRING 20 0 20 CusomerCod Customer Code at Supplier      
PL19012 NCHAR STRING 2 0 2 WayOfPayment Payment Method      
PL19013 NVARCHAR VSTRING 15 0 15 PostalGiroAC Bank Account Postal Giro      
PL19014 NVARCHAR VSTRING 15 0 15 BankGiroAC Bank Account Bank Giro      
PL19015 NVARCHAR VSTRING 34 0 34 BankAccNo Bank Account Number      
PL19016 NVARCHAR VSTRING 25 0 25 BankOffice Bank Office      
PL19017 NVARCHAR VSTRING 12 0 12 SWIFTAddress Bank SWIFT Address      
PL19018 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      
PL19019 NVARCHAR VSTRING 25 0 25 InvoicingCompany Factoring Company Name      
PL19020 NVARCHAR VSTRING 5 0 5 InterLatePayment Interest Rate Late Payment      
PL19021 NVARCHAR VSTRING 50 0 50 AccString Accounting String      
PL19022 NVARCHAR VSTRING 8 0 8 WithHoldTaxCode Withholding Tax Code      
PL19023 NVARCHAR VSTRING 8 0 8 DistrictTaxCode Tax District      
PL19024 NVARCHAR VSTRING 8 0 8 Spare (obsolete)      
PL19025 NVARCHAR VSTRING 20 0 20 TaxRegNo Tax Registration Number      
PL19026 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
PL19027 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
PL19028 NVARCHAR VSTRING 2 0 2 PaymentTerm Payment Terms      
PL19029 NVARCHAR VSTRING 2 0 2 DeliveryTerm Delivery Terms      
PL19030 NVARCHAR VSTRING 2 0 2 DeliveryWay Delivery Method      
PL19031 NVARCHAR VSTRING 20 0 20 Balance Balance      
PL19032 NVARCHAR VSTRING 20 0 20 PurchPreYear Purchases Previous Year      
PL19033 NVARCHAR VSTRING 20 0 20 PurchaseYTD Purchases YTD      
PL19034 NVARCHAR VSTRING 20 0 20 PurchPeriod Purchases Period      
PL19035 DATETIME DATE 0 0 8 LastInvDate Last Invoice Date      
PL19036 DATETIME DATE 0 0 8 LastPaymDate Last Payment Date      
PL19037 NVARCHAR VSTRING 25 0 25 InternNote1 Remark Line 1      
PL19038 NVARCHAR VSTRING 25 0 25 InternNote2 Remark Line 2      
PL19039 NVARCHAR VSTRING 1 0 1 PaymentPriority Payment Priority      
PL19040 NVARCHAR VSTRING 10 0 10 ScalaCusCode Customer Code (Scala)      
PL19041 NVARCHAR VSTRING 35 0 35 AlphaSrchKey Supplier Search Key      
PL19042 NVARCHAR VSTRING 10 0 10 ZipCode Zip Code      
PL19043 NVARCHAR VSTRING 12 0 12 DefNomLedAC Standard Cost Account      
PL19044 NVARCHAR VSTRING 1 0 1 PaymentBlock Payment Block      
PL19045 NVARCHAR VSTRING 20 0 20 PurchNextYTD Purchases Next YTD      
PL19046 NVARCHAR VSTRING 20 0 20 PurchNextPer Purchases Next Period      
PL19047 NVARCHAR VSTRING 1 0 1 ImportSupCod Import Supplier      
PL19048 NVARCHAR VSTRING 16 0 16 FiscalCode Company Registration Number      
PL19049 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
PL19050 NVARCHAR VSTRING 1 0 1 OrganizaType Organization Type      
PL19051 NVARCHAR VSTRING 1 0 1 IncOnTaxRep Include in Tax Reports      
PL19052 NVARCHAR VSTRING 1 0 1 DeductiOfTax Deduction of Tax      
PL19053 NVARCHAR VSTRING 35 0 35 AddressLine4 Address Line 4      
PL19054 NVARCHAR VSTRING 1 0 1 CshMetSalTax Use Cash Method for Tax      
PL19055 NVARCHAR VSTRING 35 0 35 DelivAddrNo EDI-Delivery Address Number      
PL19056 NVARCHAR VSTRING 2 0 2 VATCode1 Vat Code      
PL19057 NVARCHAR VSTRING 2 0 2 AutoAccCode Accounting Code      
PL19058 NVARCHAR VSTRING 2 0 2 ApplicaCode3 (obsolete)      
PL19059 NVARCHAR VSTRING 5 0 5 WithHoldTaxRate With-holding Tax Rate      
PL19060 NVARCHAR VSTRING 200 0 200 CompleteName Complete Name      
PL19061 NVARCHAR VSTRING 5 0 5 InvestmenFee Investment Fee %      
PL19062 NVARCHAR VSTRING 1 0 1 Reporting 1099-Reporting      
PL19063 NVARCHAR VSTRING 8 0 8 RepCode 1099-Reporting Code      
PL19064 NVARCHAR VSTRING 1 0 1 ABCCode ABC Code      
PL19065 NVARCHAR VSTRING 12 0 12 PaymInAdvance Account for Advance Payments      
PL19066 NCHAR SWITCH 1 0 1 LckSuppForOrders Locked for New Order      
PL19067 NCHAR SWITCH 1 0 1 EDIContractSwitch Electronic Partner      
PL19068 NVARCHAR VSTRING 1 0 1 MergeInvoice Merge Invoice      
PL19069 NCHAR STRING 4 0 4 BillingCode Billing Terms      
PL19070 NCHAR STRING 1 0 1 DueDateMeth Due Date Shift Method      
PL19071 NCHAR STRING 1 0 1 TaxRoundMeth Tax Rounding Method      
PL19072 NCHAR STRING 1 0 1 AccountType Account Type      
PL19073 NCHAR STRING 1 0 1 TransferFee Transfer Fee      
PL19074 NVARCHAR VSTRING 45 0 45 ReceiversName Receivers Name      
PL19075 NVARCHAR VSTRING 15 0 15 AutopaySupCode Additional Supplier Code for Automatic Payments      
PL19076 NVARCHAR VSTRING 10 0 10 BankBranchCode Bank Branch Code      
PL19077 NVARCHAR VSTRING 45 0 45 DepositorName Depositor Account Name      
PL19078 NVARCHAR VSTRING 25 0 25 GlobalID Global Supplier ID      
PL19079 INT INTEGER 0 0 1 DraftSpplier Draft Supplier      
PL19080 INT INTEGER 0 0 1 IBANactivation IBAN Activation      
PL19081 NCHAR STRING 1 0 1 SupplierType Supplier Type      
PL19082 NCHAR STRING 12 0 12 AccountPreliminaryCost Account Unauthorized Invoice      
PL19083 INT INTEGER 0 0 9 CalendarColRef Calendar Collection      
PL19084 NCHAR STRING 6 0 6 TaxLiabilityCode Tax Liability Code      
PL19085 NVARCHAR VSTRING 10 0 10 EntityType EntityType      
PL19086 NVARCHAR VSTRING 18 0 18 Spare Spare      
PL19087 NVARCHAR VSTRING 20 0 20 SubstRegNo Substitution Registration Number      
PL19088 NVARCHAR VSTRING 20 0 20 MunicRegNo Municipal Registration Number      
PL19089 NVARCHAR VSTRING 20 0 20 StateRegNo State Registration Number      
PL19090 NVARCHAR VSTRING 10 0 10 SuppActivType Supplier Activity Type      
PL19091 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
PL19092 NVARCHAR VSTRING 10 0 10 FinOperationCode Financial Operation Code      
PL19093 NVARCHAR VSTRING 10 0 10 CityCode City Code      
PL19094 NCHAR STRING 2 0 2 CreditWayofPayment CreditWayofPayment      
PL19095 NCHAR STRING 6 0 6 LTMGroup LTM Group      
PL19096 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse code      
PL19097 NCHAR STRING 2 0 2 TaxIDType TaxIDType      
PL19098 NCHAR STRING 2 0 2 ResponsibilityType ResponsibilityType      
PL19099 NVARCHAR VSTRING 4 0 4 Harbour Harbour      
PL19100 NVARCHAR VSTRING 2 0 2 Bundesland Bundesland      
PL19101 NVARCHAR VSTRING 6 0 6 StatManner StatManner      
PL19102 NVARCHAR VSTRING 2 0 2 CurrIdentNumber CurrIdentNumber      
PL19103 NVARCHAR VSTRING 2 0 2 ECDepartment ECDepartment      
PL19104 NVARCHAR VSTRING 2 0 2 Regime Regime      
PL19105 INT INTEGER 0 0 2 FixPaymentDay1 FixPaymentDay1      
PL19106 INT INTEGER 0 0 2 FixPaymentDay2 FixPaymentDay2      
PL19107 INT INTEGER 0 0 2 FixPaymentDay3 FixPaymentDay3      
PL19108 INT INTEGER 0 0 2 PaymntExcludMonth PaymntExcludMonth      
PL19109 DATETIME DATE 0 0 8 OriginDate Origin Date This field should contain the origin date for supplier.    
PL19110 NVARCHAR VSTRING 25 0 25 ExcContrCode Excise Control Code Excise Control Code    
PL19111 NVARCHAR VSTRING 25 0 25 ExcRegNo Excise Registration Number Excise Registration Number    
PL19112 NVARCHAR VSTRING 25 0 25 ExciseDivision Excise Division Excise Division    
PL19113 NVARCHAR VSTRING 10 0 10 RegionCode Region Code GEO unit    
PL19114 NVARCHAR VSTRING 10 0 10 StateProvinceCode State/Province Code GEO unit    
PL19115 NVARCHAR VSTRING 10 0 10 CountyCode County Code GEO unit    
PL19116 INT INTEGER 0 0 1 CurrencyforDS Currency for DS      
PL19117 NVARCHAR VSTRING 200 0 200 EmailAddress Email address      
PL19118 NVARCHAR VSTRING 35 0 35 AddressLine5 Address Line 5      
PL19119 NVARCHAR VSTRING 35 0 35 AddressLine6 Address Line 6      
PL19120 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
PL19121 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 Ext. User defined field 1      
PL19122 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Ext. User defined field 2      
PL19123 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Ext. User defined field 3      
PL19124 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Ext. User defined field 4      
PL19125 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Ext. User defined field 5      
PL19126 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Ext. User defined field 6      
PL19127 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Ext. User defined field 7      
PL19128 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Ext. User defined field 8      
PL19129 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Ext. User defined field 9      
PL19130 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Ext. User defined field 10      
PL19131 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Ext. User defined field 11      
PL19132 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Ext. User defined field 12      
PL19133 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Ext. User defined field 13      
PL19134 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Ext. User defined field 14      
PL19135 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Ext. User defined field 15      
PL19136 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Ext. User defined field 16      
PL19137 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Ext. User defined field 17      
PL19138 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Ext. User defined field 18      
PL19139 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Ext. User defined field 19      
PL19140 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Ext. User defined field 20      
PL19141 NVARCHAR VSTRING 11 0 11 BIC BIC      
PL19142 NVARCHAR VSTRING 30 0 30 BlockingFlags Blocking Flags      
PL19143 NVARCHAR VSTRING 35 0 35 CommodityCode Commodity code      
PL19144 NCHAR STRING 1 0 1 ChargesCode Charges code      
PL19145 NVARCHAR VSTRING 10 0 10 SUFARMA SUFARMA      
PL19146 NCHAR STRING 1 0 1 GovernmentTableNum Government Table number      
PL19147 NVARCHAR VSTRING 12 0 12 SpesometroForms Spesometro Forms      
PL19148 NCHAR STRING 1 0 1 SummaryDoc Summary Document      
PL19149 NCHAR STRING 2 0 2 PO3Subtypedeb PO3 Sub type deb      
PL19150 NCHAR STRING 2 0 2 PO3Subtypecre PO3 Sub type cre      
PL19151 NCHAR STRING 10 0 10 MainSupplCode Main Supplier Code      
PL19152 NVARCHAR VSTRING 4 0 4 ChargeBearer Charge Bearer      

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