Таблица: SL12 - «Customer Payment Proposal Header». Маска имени таблицы: «SL12%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
SL12001 NVARCHAR VSTRING 6 0 6 PaymPropNo Payment Proposal Number   1 Да
SL12002 NVARCHAR VSTRING 8 0 8 UserIdOwner Owner      
SL12003 NUMERIC MONEY 28 8 20 TransferAmount Transfer Amount (Local Currency)      
SL12004 NUMERIC MONEY 28 8 20 Discount Discount (Local Currency)      
SL12005 DATETIME DATE 0 0 8 CreationDate Date Created      
SL12006 DATETIME DATE 0 0 8 ApprovalDate Date Approved      
SL12007 DATETIME DATE 0 0 8 FirstPrintDate Date First Printed      
SL12008 DATETIME DATE 0 0 8 ReprintDate Date Re-printed      
SL12009 DATETIME DATE 0 0 8 LatestCollectDate Last Collection Date      
SL12010 NUMERIC MONEY 28 8 20 AmPaidPaymCurr Amount Paid (Payment Currency)      
SL12011 NUMERIC MONEY 28 8 20 DiscPaymCurr Discount Amount (Payment Currency)      
SL12012 NCHAR STRING 2 0 2 CodePaymCurr Currency Code Payment      
SL12013 NUMERIC X_NUMERIC 18 8 10 ExchRate1 Exchange Rate 1      
SL12014 NUMERIC X_NUMERIC 18 8 10 ExchRate2 Exchange Rate 2      
SL12015 NCHAR STRING 3 0 3 ExchAlg Exchange Algorithm      
SL12016 DATETIME DATE 0 0 8 UpToInvDueDate Up to Invoice Due Date      
SL12017 DATETIME DATE 0 0 8 PaymBookingDate Payment Date      
SL12018 NCHAR STRING 2 0 2 PaymentWay Payment way      
SL12019 NCHAR STRING 2 0 2 AltPaymentWay Alternative Payment Way      
SL12020 NCHAR STRING 3 0 3 MinCurrCode Minimum Currency Code      
SL12021 NCHAR STRING 3 0 3 MaxCurrCode Maximum Currency Code      
SL12022 NCHAR STRING 10 0 10 MinCustCode Minimum Customer Code      
SL12023 NCHAR STRING 10 0 10 MaxCustCode Maximum Customer Code      
SL12024 NCHAR STRING 4 0 4 MinCatCode Minimum Category Code      
SL12025 NCHAR STRING 4 0 4 MaxCatCode Maximum Category Code      
SL12026 NVARCHAR VSTRING 1 0 1 OtherPaymCurrFlag Other Payment Currency      
SL12027 NCHAR STRING 3 0 3 PaymCurrCode Currency Code Payment      
SL12028 DATETIME DATE 0 0 8 CNoteDueDate Credit Note due date to be included      
SL12029 INT INTEGER 0 0 1 DiscUsageFlag Discount Usage      
SL12030 NVARCHAR ACCSTR 50 0 50 MinAccString Minimum Accounting Dimensions      
SL12031 NVARCHAR ACCSTR 50 0 50 MaxAccString Maximum Accounting Dimensions      
SL12032 DATETIME DATE 0 0 8 PaymNotesPrintedDate Date Payment Notices Printed      
SL12033 NCHAR STRING 2 0 2 CrBankCode Creditor Bank Code      
SL12034 NCHAR STRING 1 0 1 ShowPLBalance Show PL Balance      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Sales Ledger | Customer Payment Proposal Header