Таблица: PL19 - «Supplier Standard» («Стандартные Поставщики»)
Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
PL19001 | VSTRING | 10 | SupplierCode | Да |
PL19002 | VSTRING | 35 | SupplierName | |
PL19003 | VSTRING | 35 | AddressLine1 | |
PL19004 | VSTRING | 35 | AddressLine2 | |
PL19005 | VSTRING | 35 | AddressLine3 | |
PL19006 | VSTRING | 20 | Reference | |
PL19007 | VSTRING | 4 | Category | |
PL19008 | VSTRING | 20 | TelephonNo | |
PL19009 | VSTRING | 10 | TelexNo | |
PL19010 | VSTRING | 20 | TelefaxNo | |
PL19011 | VSTRING | 10 | CusomerCod | |
PL19012 | STRING | 2 | WayOfPayment | |
PL19013 | VSTRING | 15 | PostalGiroAC | |
PL19014 | VSTRING | 15 | BankGiroAC | |
PL19015 | VSTRING | 25 | BankAccNo | |
PL19016 | VSTRING | 25 | BankOffice | |
PL19017 | VSTRING | 12 | SWIFTAddress | |
PL19018 | VSTRING | 3 | CountryCode | |
PL19019 | VSTRING | 25 | InvoicingCompany | |
PL19020 | X_NUMERIC | 5 | InterLatePayment | |
PL19021 | VSTRING | 50 | AccString | |
PL19022 | VSTRING | 8 | WithHoldTaxCode | |
PL19023 | VSTRING | 8 | DistrictTaxCode | |
PL19024 | VSTRING | 8 | Spare | |
PL19025 | STRING | 15 | TaxCode | |
PL19026 | STRING | 2 | CurrencyCode | |
PL19027 | STRING | 1 | LanguageCode | |
PL19028 | STRING | 2 | PaymentTerm | |
PL19029 | STRING | 2 | DeliveryTerm | |
PL19030 | STRING | 2 | DeliveryWay | |
PL19031 | MONEY | 20 | Balance | |
PL19032 | MONEY | 20 | PurchPreYear | |
PL19033 | MONEY | 20 | PurchaseYTD | |
PL19034 | MONEY | 20 | PurchPeriod | |
PL19035 | DATE | 8 | LastInvDate | |
PL19036 | DATE | 8 | LastPaymDate | |
PL19037 | VSTRING | 25 | InternNote1 | |
PL19038 | VSTRING | 25 | InternNote2 | |
PL19039 | STRING | 1 | PaymentPriority | |
PL19040 | VSTRING | 10 | ScalaCusCode | |
PL19041 | VSTRING | 35 | AlphaSrchKey | |
PL19042 | VSTRING | 10 | ZipCode | |
PL19043 | VSTRING | 12 | DefNomLedAC | |
PL19044 | STRING | 1 | PaymentBlock | |
PL19045 | MONEY | 20 | PurchNextYTD | |
PL19046 | MONEY | 20 | PurchNextPer | |
PL19047 | STRING | 1 | ImportSupCod | |
PL19048 | VSTRING | 16 | FiscalCode | |
PL19049 | VSTRING | 10 | BankCode | |
PL19050 | STRING | 1 | OrganizaType | |
PL19051 | STRING | 1 | IncOnTaxRep | |
PL19052 | STRING | 1 | DeductiOfTax | |
PL19053 | VSTRING | 35 | AddressLine4 | |
PL19054 | STRING | 1 | CshMetSalTax | |
PL19055 | VSTRING | 35 | DelivAddrNo | |
PL19056 | STRING | 2 | VATCode1 | |
PL19057 | VSTRING | 2 | AutoAccCode | |
PL19058 | VSTRING | 2 | ApplicaCode3 | |
PL19059 | X_NUMERIC | 5 | WithHoldTaxRate | |
PL19060 | VSTRING | 50 | CompleteName | |
PL19061 | STRING | 5 | InvestmenFee | |
PL19062 | VSTRING | 1 | Reporting | |
PL19063 | VSTRING | 3 | RepCode | |
PL19064 | VSTRING | 1 | ABCCode | |
PL19065 | VSTRING | 12 | PaymInAdvance | |
PL19066 | SWITCH | 1 | LckSuppForOrders | |
PL19067 | SWITCH | 1 | EDIContractSwitch | |
PL19068 | VSTRING | 1 | MergeInvoice | |
PL19069 | STRING | 4 | BillingCode | |
PL19070 | STRING | 1 | DueDateMeth | |
PL19071 | STRING | 1 | TaxRoundMeth | |
PL19072 | STRING | 1 | AccountType | |
PL19073 | STRING | 1 | TransferFee | |
PL19074 | VSTRING | 45 | ReceiversName | |
PL19075 | VSTRING | 15 | AutopaySupCode | |
PL19076 | VSTRING | 10 | BankBranchCode | |
PL19077 | VSTRING | 45 | DepositorName |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Purchase Ledger (Книга Закупок) | Supplier Standard (Стандартные Поставщики)