Таблица: PL01 - «Suppliers» («Поставщики»)
Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
PL01001 | VSTRING | 10 | SupplierCode | Да |
PL01002 | VSTRING | 35 | SupplierName | |
PL01003 | VSTRING | 35 | AddressLine1 | |
PL01004 | VSTRING | 35 | AddressLine2 | |
PL01005 | VSTRING | 35 | AddressLine3 | |
PL01006 | VSTRING | 20 | Reference | |
PL01007 | VSTRING | 4 | Category | |
PL01008 | VSTRING | 20 | TelephonNo | |
PL01009 | VSTRING | 10 | TelexNo | |
PL01010 | VSTRING | 20 | TelefaxNo | |
PL01011 | VSTRING | 10 | CusomerCod | |
PL01012 | STRING | 2 | WayOfPayment | |
PL01013 | VSTRING | 15 | PostalGiroAC | |
PL01014 | VSTRING | 15 | BankGiroAC | |
PL01015 | VSTRING | 25 | BankAccNo | |
PL01016 | VSTRING | 25 | BankOffice | |
PL01017 | VSTRING | 12 | SWIFTAddress | |
PL01018 | VSTRING | 3 | CountryCode | |
PL01019 | VSTRING | 25 | InvoicingCompany | |
PL01020 | VSTRING | 5 | InterLatePayment | |
PL01021 | VSTRING | 50 | AccString | |
PL01022 | VSTRING | 8 | WithHoldTaxCode | |
PL01023 | VSTRING | 8 | DistrictTaxCode | |
PL01024 | VSTRING | 8 | Spare | |
PL01025 | VSTRING | 15 | TaxCode | |
PL01026 | VSTRING | 2 | CurrencyCode | |
PL01027 | VSTRING | 1 | LanguageCode | |
PL01028 | VSTRING | 2 | PaymentTerm | |
PL01029 | VSTRING | 2 | DeliveryTerm | |
PL01030 | VSTRING | 2 | DeliveryWay | |
PL01031 | VSTRING | 20 | Balance | |
PL01032 | VSTRING | 20 | PurchPreYear | |
PL01033 | VSTRING | 20 | PurchaseYTD | |
PL01034 | VSTRING | 20 | PurchPeriod | |
PL01035 | DATE | 8 | LastInvDate | |
PL01036 | DATE | 8 | LastPaymDate | |
PL01037 | VSTRING | 25 | InternNote1 | |
PL01038 | VSTRING | 25 | InternNote2 | |
PL01039 | VSTRING | 1 | PaymentPriority | |
PL01040 | VSTRING | 10 | ScalaCusCode | |
PL01041 | VSTRING | 35 | AlphaSrchKey | |
PL01042 | VSTRING | 10 | ZipCode | |
PL01043 | VSTRING | 12 | DefNomLedAC | |
PL01044 | VSTRING | 1 | PaymentBlock | |
PL01045 | VSTRING | 20 | PurchNextYTD | |
PL01046 | VSTRING | 20 | PurchNextPer | |
PL01047 | VSTRING | 1 | ImportSupCod | |
PL01048 | VSTRING | 16 | FiscalCode | |
PL01049 | VSTRING | 10 | BankCode | |
PL01050 | VSTRING | 1 | OrganizaType | |
PL01051 | VSTRING | 1 | IncOnTaxRep | |
PL01052 | VSTRING | 1 | DeductiOfTax | |
PL01053 | VSTRING | 35 | AddressLine4 | |
PL01054 | VSTRING | 1 | CshMetSalTax | |
PL01055 | VSTRING | 35 | DelivAddrNo | |
PL01056 | VSTRING | 2 | VATCode1 | |
PL01057 | VSTRING | 2 | AutoAccCode | |
PL01058 | VSTRING | 2 | ApplicaCode3 | |
PL01059 | VSTRING | 5 | WithHoldTaxRate | |
PL01060 | VSTRING | 50 | CompleteName | |
PL01061 | VSTRING | 5 | InvestmenFee | |
PL01062 | VSTRING | 1 | Reporting | |
PL01063 | VSTRING | 3 | RepCode | |
PL01064 | VSTRING | 1 | ABCCode | |
PL01065 | VSTRING | 12 | PaymInAdvance | |
PL01066 | SWITCH | 1 | LckSuppForOrders | |
PL01067 | SWITCH | 1 | EDIContractSwitch | |
PL01068 | VSTRING | 1 | MergeInvoice | |
PL01069 | STRING | 4 | BillingCode | |
PL01070 | STRING | 1 | DueDateMeth | |
PL01071 | STRING | 1 | TaxRoundMeth | |
PL01072 | STRING | 1 | AccountType | |
PL01073 | STRING | 1 | TransferFee | |
PL01074 | VSTRING | 45 | ReceiversName | |
PL01075 | VSTRING | 15 | AutopaySupCode | |
PL01076 | VSTRING | 10 | BankBranchCode | |
PL01077 | VSTRING | 45 | DepositorName |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Purchase Ledger (Книга Закупок) | Suppliers (Поставщики)