Таблица | Table: PL19 - «Standard Suppliers». Маска имени таблицы | Table Name Mask: «PL19%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision 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 10 0 10 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 Account_Preliminary_Cost Account Unauthorized Invoice      
PL19083 INT INTEGER 0 0 9 Calendar_Collection_Reference 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        
PL19095 NCHAR STRING 6 0 6 LTM Group 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        
PL19100 NVARCHAR VSTRING 2 0 2 Bundesland        
PL19101 NVARCHAR VSTRING 6 0 6 StatManner        
PL19102 NVARCHAR VSTRING 2 0 2 CurrIdentNumber        
PL19103 NVARCHAR VSTRING 2 0 2 ECDepartment        
PL19104 NVARCHAR VSTRING 2 0 2 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 Region Code Region Code GEO unit    
PL19114 NVARCHAR VSTRING 10 0 10 State/Province Code State/Province Code GEO unit    
PL19115 NVARCHAR VSTRING 10 0 10 County Code County Code GEO unit    
PL19116 INT INTEGER 0 0 1 Currency for DS Currency for DS      
PL19117 NVARCHAR VSTRING 200 0 200 Email address 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 50 0 50 Ext. User defined field 1 Ext. User defined field 1      
PL19122 NVARCHAR VSTRING 50 0 50 Ext. User defined field 2 Ext. User defined field 2      
PL19123 NVARCHAR VSTRING 50 0 50 Ext. User defined field 3 Ext. User defined field 3      
PL19124 NVARCHAR VSTRING 50 0 50 Ext. User defined field 4 Ext. User defined field 4      
PL19125 NVARCHAR VSTRING 50 0 50 Ext. User defined field 5 Ext. User defined field 5      
PL19126 NVARCHAR VSTRING 50 0 50 Ext. User defined field 6 Ext. User defined field 6      
PL19127 NVARCHAR VSTRING 50 0 50 Ext. User defined field 7 Ext. User defined field 7      
PL19128 NVARCHAR VSTRING 50 0 50 Ext. User defined field 8 Ext. User defined field 8      
PL19129 NVARCHAR VSTRING 50 0 50 Ext. User defined field 9 Ext. User defined field 9      
PL19130 NVARCHAR VSTRING 50 0 50 Ext. User defined field 10 Ext. User defined field 10      
PL19131 NVARCHAR VSTRING 50 0 50 Ext. User defined field 11 Ext. User defined field 11      
PL19132 NVARCHAR VSTRING 50 0 50 Ext. User defined field 12 Ext. User defined field 12      
PL19133 NVARCHAR VSTRING 50 0 50 Ext. User defined field 13 Ext. User defined field 13      
PL19134 NVARCHAR VSTRING 50 0 50 Ext. User defined field 14 Ext. User defined field 14      
PL19135 NVARCHAR VSTRING 50 0 50 Ext. User defined field 15 Ext. User defined field 15      
PL19136 NVARCHAR VSTRING 50 0 50 Ext. User defined field 16 Ext. User defined field 16      
PL19137 NVARCHAR VSTRING 50 0 50 Ext. User defined field 17 Ext. User defined field 17      
PL19138 NVARCHAR VSTRING 50 0 50 Ext. User defined field 18 Ext. User defined field 18      
PL19139 NVARCHAR VSTRING 50 0 50 Ext. User defined field 19 Ext. User defined field 19      
PL19140 NVARCHAR VSTRING 50 0 50 Ext. User defined field 20 Ext. User defined field 20      
PL19141 NVARCHAR VSTRING 11 0 11 BIC BIC      
PL19142 NVARCHAR VSTRING 30 0 30 Blocking Flags Blocking Flags      
PL19143 NVARCHAR VSTRING 35 0 35 Commodity code Commodity code      

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Purchase Ledger | Suppliers Templates