Таблица: PL19 - «Standard Suppliers». Маска имени таблицы: «PL19%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PL19001 | NCHAR | STRING | 10 | 0 | 10 | SupplierCode | Supplier Template Code | 1 | Да | |
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 | CentSalesTaxRegNo | Central Sales Tax Registration Number | Central Sales Tax Registration Number |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Purchase Ledger | Suppliers Templates