One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Purchase Ledger»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table PL01 — Suppliers

Таблица / Table: PL01 — «Suppliers». Маска имени таблицы / Table name mask: «PL01%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PL01001 NCHAR STRING 10 0 10 SupplierCode Supplier Code   1 Да / Yes
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 Fax Number      
PL01011 NVARCHAR VSTRING 20 0 20 CustomerCode Customer Code at Supplier      
PL01012 NCHAR STRING 2 0 2 WayofPayment Payment Method (Invoices)      
PL01013 NVARCHAR VSTRING 15 0 15 BankAccountNoPostalGiro Postal Giro A/C      
PL01014 NVARCHAR VSTRING 15 0 15 BankGiroAcc Bank Giro Number      
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      
PL01020 NUMERIC X_NUMERIC 13 8 5 InterestLatePayment Interest Rate Late Payment      
PL01021 NVARCHAR ACCSTR 120 0 120 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 Spare      
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 Code      
PL01028 NVARCHAR VSTRING 2 0 2 PaymentTerms Payment Term      
PL01029 NVARCHAR VSTRING 2 0 2 DeliveryTerms Delivery Term      
PL01030 NVARCHAR VSTRING 2 0 2 WayofDelivery Delivery Method      
PL01031 NUMERIC MONEY 28 8 20 Balance Balance      
PL01032 NUMERIC MONEY 28 8 20 AmountPurchasePreviosYear Purchase Previous Year      
PL01033 NUMERIC MONEY 28 8 20 AmountPurchaseYTD Purchase YTD      
PL01034 NUMERIC MONEY 28 8 20 AmountPurchasePeriod Purchase 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 (iScala)      
PL01041 NVARCHAR VSTRING 35 0 35 AlphaSearchKey Search Name      
PL01042 NVARCHAR VSTRING 10 0 10 ZipCode Post Code      
PL01043 NVARCHAR VSTRING 12 0 12 AccountDefault Standard Cost Account      
PL01044 NVARCHAR VSTRING 1 0 1 PaymentBlockFlag Payment Block      
PL01045 NUMERIC MONEY 28 8 20 AmountPurchaseNextYTD Purchase Next year      
PL01046 NUMERIC MONEY 28 8 20 AmountPurchaseNextPeriod Purchase 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 Local Tax Code      
PL01057 NVARCHAR VSTRING 2 0 2 AutoAccountCode Accounting Code      
PL01058 NVARCHAR VSTRING 2 0 2 ApplicationCode3 Application code 3      
PL01059 NUMERIC X_NUMERIC 13 8 5 WithHoldingTAXRate Withholding Tax Rate      
PL01060 NVARCHAR VSTRING 200 0 200 CompleteName Complete Name      
PL01061 NUMERIC X_NUMERIC 13 8 5 InvestmentFeePercent Investment Fee Percent      
PL01062 NVARCHAR VSTRING 1 0 1 ReportingFlag 1099-Reporting      
PL01063 NVARCHAR VSTRING 8 0 8 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 Code      
PL01070 NCHAR STRING 1 0 1 DateDueMethodFlag Date Shifting 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 Autopayments      
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 Tax Type      
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 Financial Operation Code      
PL01093 NVARCHAR VSTRING 10 0 10 CityCode City Code (Brazil)      
PL01094 NCHAR STRING 2 0 2 CreditWayofPayment Payment Method (Credit Notes)      
PL01095 NCHAR STRING 6 0 6 LTMGroup LTM Group Code      
PL01096 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse Code      
PL01097 NCHAR STRING 2 0 2 TaxIDType ID Type      
PL01098 NCHAR STRING 2 0 2 ResponsibilityType Tax Responsibility Type      
PL01099 NVARCHAR VSTRING 4 0 4 Harbour Harbour      
PL01100 NVARCHAR VSTRING 2 0 2 Bundesland Bundesland      
PL01101 NVARCHAR VSTRING 6 0 6 StatManner Statistical Manner Code      
PL01102 NVARCHAR VSTRING 2 0 2 CurrIdentNumber Currency ID Number      
PL01103 NVARCHAR VSTRING 2 0 2 ECDepartment EC Department Code      
PL01104 NVARCHAR VSTRING 2 0 2 Regime Regime Code      
PL01105 INT INTEGER 0 0 2 FixPaymentDay1 Fixed Payment Day 1      
PL01106 INT INTEGER 0 0 2 FixPaymentDay2 Fixed Payment Day 2      
PL01107 INT INTEGER 0 0 2 FixPaymentDay3 Fixed Payment Day 3      
PL01108 INT INTEGER 0 0 2 PaymntExcludMonth Month excluded from payment      
PL01109 DATETIME DATE 0 0 8 OriginDate Origin Date This field should contain the origin date for supplier.    
PL01110 NVARCHAR VSTRING 25 0 25 ExcContrCode Excise Control Code Excise Control Code    
PL01111 NVARCHAR VSTRING 25 0 25 ExcRegNo Excise Registration Number Excise Registration Number    
PL01112 NVARCHAR VSTRING 25 0 25 ExciseDivision Excise Division Excise Division    
PL01113 NVARCHAR VSTRING 10 0 10 RegionCode Region Code GEO unit    
PL01114 NVARCHAR VSTRING 10 0 10 StateProvinceCode State/Province Code GEO unit    
PL01115 NVARCHAR VSTRING 10 0 10 CountyCode County Code GEO unit    
PL01116 INT INTEGER 0 0 1 CurrencyforDS Currency on Drop shipment order      
PL01117 NVARCHAR VSTRING 200 0 200 EmailAddress Email Address      
PL01118 NVARCHAR VSTRING 35 0 35 AddressLine5 Address Line 5      
PL01119 NVARCHAR VSTRING 35 0 35 AddressLine6 Address Line 6      
PL01120 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
PL01121 NVARCHAR VSTRING 150 0 150 ExtUserDefFld1 Extended User defined 1      
PL01122 NVARCHAR VSTRING 150 0 150 ExtUserDefFld2 Extended User defined 2      
PL01123 NVARCHAR VSTRING 150 0 150 ExtUserDefFld3 Extended User defined 3      
PL01124 NVARCHAR VSTRING 150 0 150 ExtUserDefFld4 Extended User defined 4      
PL01125 NVARCHAR VSTRING 150 0 150 ExtUserDefFld5 Extended User defined 5      
PL01126 NVARCHAR VSTRING 150 0 150 ExtUserDefFld6 Extended User defined 6      
PL01127 NVARCHAR VSTRING 150 0 150 ExtUserDefFld7 Extended User defined 7      
PL01128 NVARCHAR VSTRING 150 0 150 ExtUserDefFld8 Extended User defined 8      
PL01129 NVARCHAR VSTRING 150 0 150 ExtUserDefFld9 Extended User defined 9      
PL01130 NVARCHAR VSTRING 150 0 150 ExtUserDefFld10 Extended User defined 10      
PL01131 NVARCHAR VSTRING 150 0 150 ExtUserDefFld11 Extended User defined 11      
PL01132 NVARCHAR VSTRING 150 0 150 ExtUserDefFld12 Extended User defined 12      
PL01133 NVARCHAR VSTRING 150 0 150 ExtUserDefFld13 Extended User defined 13      
PL01134 NVARCHAR VSTRING 150 0 150 ExtUserDefFld14 Extended User defined 14      
PL01135 NVARCHAR VSTRING 150 0 150 ExtUserDefFld15 Extended User defined 15      
PL01136 NVARCHAR VSTRING 150 0 150 ExtUserDefFld16 Extended User defined 16      
PL01137 NVARCHAR VSTRING 150 0 150 ExtUserDefFld17 Extended User defined 17      
PL01138 NVARCHAR VSTRING 150 0 150 ExtUserDefFld18 Extended User defined 18      
PL01139 NVARCHAR VSTRING 150 0 150 ExtUserDefFld19 Extended User defined 19      
PL01140 NVARCHAR VSTRING 150 0 150 ExtUserDefFld20 Extended User defined 20      
PL01141 NVARCHAR VSTRING 11 0 11 BIC BIC      
PL01142 NVARCHAR VSTRING 30 0 30 BlockingFlags Blocking Flags      
PL01143 NVARCHAR VSTRING 35 0 35 CommodityCode Commodity Code      
PL01144 NCHAR STRING 1 0 1 ChargesCode Charges Code      
PL01145 NVARCHAR VSTRING 10 0 10 SUFARMA SUFARMA      
PL01146 NCHAR STRING 1 0 1 GovernmentTableNum Government Table Number      
PL01147 NVARCHAR VSTRING 12 0 12 SpesometroForms Include in Spesometro Form      
PL01148 NCHAR STRING 1 0 1 SummaryDoc Summary Document      
PL01149 NCHAR STRING 2 0 2 PO3Subtypedeb Sub Type (Invoices)      
PL01150 NCHAR STRING 2 0 2 PO3Subtypecre Sub Type (Credit Notes)      
PL01151 NCHAR STRING 10 0 10 MainSupplCode Main Supplier Code      
PL01152 NVARCHAR VSTRING 4 0 4 ChargeBearer Charge Bearer      
PL01153 NCHAR SWITCH 1 0 1 SplitPayment Split Payment      
PL01154 NVARCHAR VSTRING 34 0 34 TaxBankAcc Tax Bank Account      
PL01155 NCHAR SWITCH 1 0 1 Anonymized Anonymized      

Навигация / Navigation: