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

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
PL01001 NCHAR STRING 10 0 10 SupplierCode Supplier Code   1 Да
PL01002 NVARCHAR VSTRING 35 0 35 SupplierName Supplier Name      
PL01003 NVARCHAR VSTRING 35 0 35 AddressLine1 Address Line 1      
PL01004 NVARCHAR VSTRING 35 0 35 AddressLine2 Address Line 2      
PL01005 NVARCHAR VSTRING 35 0 35 AddressLine3 Address Line 3      
PL01006 NVARCHAR VSTRING 20 0 20 Reference Reference      
PL01007 NVARCHAR VSTRING 4 0 4 Category Supplier Category      
PL01008 NVARCHAR VSTRING 20 0 20 TelephoneNo Telephone Number      
PL01009 NVARCHAR VSTRING 10 0 10 TelexNo Telex Number      
PL01010 NVARCHAR VSTRING 20 0 20 TelefaxNo Telefax Number      
PL01011 NVARCHAR VSTRING 10 0 10 CustomerCode Customer Code at Supplier      
PL01012 NCHAR STRING 2 0 2 WayofPayment Payment Method      
PL01013 NVARCHAR VSTRING 15 0 15 BankAccountNoPostalGiro Bank Account Postal Giro      
PL01014 NVARCHAR VSTRING 15 0 15 BankGiroAcc Bank Account Bank Giro      
PL01015 NVARCHAR VSTRING 34 0 34 BankAccountNo Bank Account Number      
PL01016 NVARCHAR VSTRING 25 0 25 BankOffice Bank Office      
PL01017 NVARCHAR VSTRING 12 0 12 AddressSWIFT Bank SWIFT Address      
PL01018 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      
PL01019 NVARCHAR VSTRING 25 0 25 CompanyInvoicing Factoring Company Name      
PL01020 NVARCHAR VSTRING 5 0 5 InterestLatePayment Interest Rate Late Payment      
PL01021 NVARCHAR VSTRING 50 0 50 AccountString Accounting String      
PL01022 NVARCHAR VSTRING 8 0 8 WithHoldingTAXCode Withholding Tax Code      
PL01023 NVARCHAR VSTRING 8 0 8 DistrictTAXCode Tax District      
PL01024 NVARCHAR VSTRING 8 0 8 Spare (obsolete)      
PL01025 NVARCHAR VSTRING 20 0 20 TaxRegNo Tax Registration Number      
PL01026 NVARCHAR VSTRING 2 0 2 CurrencyCode Currency Code      
PL01027 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
PL01028 NVARCHAR VSTRING 2 0 2 PaymentTerms Payment Terms      
PL01029 NVARCHAR VSTRING 2 0 2 DeliveryTerms Delivery Terms      
PL01030 NVARCHAR VSTRING 2 0 2 WayofDelivery Delivery Method      
PL01031 NVARCHAR VSTRING 20 0 20 Balance Balance      
PL01032 NVARCHAR VSTRING 20 0 20 AmountPurchasePreviosYear Purchases Previous Year      
PL01033 NVARCHAR VSTRING 20 0 20 AmountPurchaseYTD Purchases YTD      
PL01034 NVARCHAR VSTRING 20 0 20 AmountPurchasePeriod Purchases Period      
PL01035 DATETIME DATE 0 0 8 LatestInvoiceDate Last Invoice Date      
PL01036 DATETIME DATE 0 0 8 LatestPaymentDate Last Payment Date      
PL01037 NVARCHAR VSTRING 25 0 25 NoteInternal1 Remark Line 1      
PL01038 NVARCHAR VSTRING 25 0 25 NoteInternal2 Remark Line 2      
PL01039 NVARCHAR VSTRING 1 0 1 PaymentPriority Payment Priority      
PL01040 NVARCHAR VSTRING 10 0 10 ScalaCustomerCode Customer Code (Scala)      
PL01041 NVARCHAR VSTRING 35 0 35 AlphaSearchKey Supplier Search Key      
PL01042 NVARCHAR VSTRING 10 0 10 ZipCode Zip Code      
PL01043 NVARCHAR VSTRING 12 0 12 AccountDefault Standard Cost Account      
PL01044 NVARCHAR VSTRING 1 0 1 PaymentBlockFlag Payment Block      
PL01045 NVARCHAR VSTRING 20 0 20 AmountPurchaseNextYTD Purchases Next YTD      
PL01046 NVARCHAR VSTRING 20 0 20 AmountPurchaseNextPeriod Purchases Next Period      
PL01047 NVARCHAR VSTRING 1 0 1 SupplierImportCode Import Supplier      
PL01048 NVARCHAR VSTRING 16 0 16 FiscalCode Company Registration Number      
PL01049 NVARCHAR VSTRING 10 0 10 BankCode Bank Code      
PL01050 NVARCHAR VSTRING 1 0 1 OrganizationType Organization Type      
PL01051 NVARCHAR VSTRING 1 0 1 FlagIncludeOnTAXReport Include in Tax Reports      
PL01052 NVARCHAR VSTRING 1 0 1 FlagDeductionOfTAX Deduction of Tax      
PL01053 NVARCHAR VSTRING 35 0 35 AddressLine4 Address Line 4      
PL01054 NVARCHAR VSTRING 1 0 1 FlagCashMethod Use Cash Method for Tax      
PL01055 NVARCHAR VSTRING 35 0 35 DeliveryAddressEDI EDI-Delivery Address Number      
PL01056 NVARCHAR VSTRING 2 0 2 TAXCode1 Vat Code      
PL01057 NVARCHAR VSTRING 2 0 2 AutoAccountCode Accounting Code      
PL01058 NVARCHAR VSTRING 2 0 2 ApplicationCode3 (obsolete)      
PL01059 NVARCHAR VSTRING 5 0 5 WithHoldingTAXRate With-holding Tax Rate      
PL01060 NVARCHAR VSTRING 50 0 50 CompleteName Complete Name      
PL01061 NVARCHAR VSTRING 5 0 5 InvestmentFeePercent Investment Fee %      
PL01062 NVARCHAR VSTRING 1 0 1 ReportingFlag 1099-Reporting      
PL01063 NVARCHAR VSTRING 3 0 3 ReportCode 1099-Reporting Code      
PL01064 NVARCHAR VSTRING 1 0 1 ABCCode ABC Code      
PL01065 NVARCHAR VSTRING 12 0 12 PaymentInAdvance Account for Advance Payments      
PL01066 NCHAR SWITCH 1 0 1 LockSupplierForOrdersFlag Locked for New Order      
PL01067 NCHAR SWITCH 1 0 1 EDIContractFlag Electronic Partner      
PL01068 NVARCHAR VSTRING 1 0 1 InvoiceMergeFlag Merge Invoice      
PL01069 NCHAR STRING 4 0 4 BillingCode Billing Terms      
PL01070 NCHAR STRING 1 0 1 DateDueMethodFlag Due Date Shift Method      
PL01071 NCHAR STRING 1 0 1 TAXRoundingMethod Tax Rounding Method 0 - Standard Scala rounding
1 - Round-up to the nearest integer in currency
2 - Round-down to the nearest integer in currency
3 - Normal rounding
   
PL01072 NCHAR STRING 1 0 1 AccountType Account Type Only used for payment method J1 (Japan):
1 - Saving account.
2 - Checking account.
3 - Deposit at notice.
4 - Time deposit.
5 - Special deposit.
6 - Deposit for tax payment.
7 - Foreign currency deposit.
   
PL01073 NCHAR STRING 1 0 1 TransferFeeFlag Transfer Fee Option Only used for payment method J1 (Japan):
1 - From payer's account
2 - From payment amount
   
PL01074 NVARCHAR VSTRING 45 0 45 ReceiverName Receivers Name      
PL01075 NVARCHAR VSTRING 15 0 15 SupplierCodeforAutopayment Additional Supplier Code for Automatic Payments      
PL01076 NVARCHAR VSTRING 10 0 10 BankBranchCode Bank Branch Code      
PL01077 NVARCHAR VSTRING 45 0 45 DepositorName Depositor Account Name      
PL01078 NVARCHAR VSTRING 25 0 25 GlobalID Global Supplier ID      
PL01079 INT INTEGER 0 0 1 DraftSupplierFlag Draft Supplier      
PL01080 INT INTEGER 0 0 1 IBANActivationFlag IBAN Activation      
PL01081 NCHAR STRING 1 0 1 SupplierType Supplier Type      
PL01082 NCHAR STRING 12 0 12 AccountForUnauthorizedInvoice Account Unauthorized Invoice      
PL01083 INT INTEGER 0 0 9 CalendarCollectionReference Calendar Collection      
PL01084 NCHAR STRING 6 0 6 TaxLiabilityCode Tax Liability Code      
PL01085 NVARCHAR VSTRING 10 0 10 EntityType Legal Entity Type      
PL01086 NVARCHAR VSTRING 18 0 18 Spare Spare      
PL01087 NVARCHAR VSTRING 20 0 20 SubstRegNo Substitution Registration Number      
PL01088 NVARCHAR VSTRING 20 0 20 MunicRegNo Municipal Registration Number      
PL01089 NVARCHAR VSTRING 20 0 20 StateRegNo State Registration Number      
PL01090 NVARCHAR VSTRING 10 0 10 SuppActivType Supplier Activity Type      
PL01091 NVARCHAR VSTRING 10 0 10 OperationType Operation Type      
PL01092 NVARCHAR VSTRING 10 0 10 FinOperationCode Fin Operation Code      
PL01093 NVARCHAR VSTRING 10 0 10 CityCode City Code      
PL01094 NCHAR STRING 2 0 2 CreditWayofPayment        
PL01095 NCHAR STRING 6 0 6 LTM Group LTM Group      
PL01096 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse Code      
PL01097 NCHAR STRING 2 0 2 TaxIDType TaxIDType      
PL01098 NCHAR STRING 2 0 2 ResponsibilityType ResponsibilityType      
PL01099 NVARCHAR VSTRING 4 0 4 Harbour        
PL01100 NVARCHAR VSTRING 2 0 2 Bundesland        
PL01101 NVARCHAR VSTRING 6 0 6 StatManner        
PL01102 NVARCHAR VSTRING 2 0 2 CurrIdentNumber        
PL01103 NVARCHAR VSTRING 2 0 2 ECDepartment        
PL01104 NVARCHAR VSTRING 2 0 2 Regime        

Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Purchase Ledger | Suppliers