Таблица: 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 15 0 15 TAXCode 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 JuridicalType Legal Entity Type      
PL01086 NVARCHAR VSTRING 18 0 18 TaxId Tax ID      
PL01087 NVARCHAR VSTRING 20 0 20 IESTCode IEST Code      
PL01088 NVARCHAR VSTRING 20 0 20 IMCode IM Code      
PL01089 NVARCHAR VSTRING 20 0 20 IECode IE Code      
PL01090 NVARCHAR VSTRING 10 0 10 SuppType Supplier Type      
PL01091 NVARCHAR VSTRING 10 0 10 BusinessType Business Type      
PL01092 NVARCHAR VSTRING 1 0 1 IsBranch Is Branch      
PL01093 NVARCHAR VSTRING 10 0 10 CityCode City Code      
PL01094 NCHAR STRING 2 0 2 CreditWayofPayment        

Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Purchase Ledger | Suppliers