Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PL50 - «Supplier Payment Proposal Header». Маска имени таблицы: «PL50%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PL50001 | NVARCHAR | VSTRING | 6 | 0 | 6 | PaymPropNo | Payment Proposal Number | 1 | Да | |
PL50002 | NVARCHAR | VSTRING | 8 | 0 | 8 | UserIdOwner | User | |||
PL50003 | NUMERIC | MONEY | 28 | 8 | 20 | TransferAmount | Transfer Amount (Local Currency) | |||
PL50004 | NUMERIC | MONEY | 28 | 8 | 20 | Discount | Discount (Local Currency) | |||
PL50005 | DATETIME | DATE | 0 | 0 | 8 | CreationDate | Date Created | |||
PL50006 | DATETIME | DATE | 0 | 0 | 8 | ApprovalDate | Date Approved | |||
PL50007 | DATETIME | DATE | 0 | 0 | 8 | FirstPrintDate | Date First Printed | |||
PL50008 | DATETIME | DATE | 0 | 0 | 8 | ReprintDate | Date Reprinted | |||
PL50009 | DATETIME | DATE | 0 | 0 | 8 | LatestCollectDate | Last Collection Date | |||
PL50010 | NUMERIC | MONEY | 28 | 8 | 20 | AmPaidPaymCurr | Amount (Payment Currency) | |||
PL50011 | NUMERIC | MONEY | 28 | 8 | 20 | DiscPaymCurr | Discount (Payment Currency) | |||
PL50012 | NCHAR | STRING | 2 | 0 | 2 | PaymCurrCode | Currency Code Payment | |||
PL50013 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchRate1 | Currency Exchange Rate 1 | |||
PL50014 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ExchRate2 | Currency Exchange Rate 2 | |||
PL50015 | NCHAR | STRING | 3 | 0 | 3 | ExchAlg | Currency Exchange Algorithm | |||
PL50016 | DATETIME | DATE | 0 | 0 | 8 | UpToInvDueDate | Up-to Invoice Due Date | |||
PL50017 | DATETIME | DATE | 0 | 0 | 8 | PaymBookingDate | Payment Date | |||
PL50018 | NCHAR | STRING | 2 | 0 | 2 | PaymentWay | Payment Method | |||
PL50019 | NCHAR | STRING | 2 | 0 | 2 | AltPaymentWay | Alternative Payment Method | |||
PL50020 | NCHAR | STRING | 3 | 0 | 3 | MinCurrCode | Minimum Currency Code | |||
PL50021 | NCHAR | STRING | 3 | 0 | 3 | MaxCurrCode | Maximum Currency Code | |||
PL50022 | NCHAR | STRING | 10 | 0 | 10 | MinCustCode | Minimum Supplier Code | |||
PL50023 | NCHAR | STRING | 10 | 0 | 10 | MaxCustCode | Maximum Supplier Code | |||
PL50024 | NCHAR | STRING | 4 | 0 | 4 | MinCatCode | Minimum Category | |||
PL50025 | NCHAR | STRING | 4 | 0 | 4 | MaxCatCode | Maximum Category | |||
PL50026 | NVARCHAR | VSTRING | 1 | 0 | 1 | OtherPaymCurrFlag | Other Payment Currency | |||
PL50027 | NCHAR | STRING | 3 | 0 | 3 | PaymCurrCode | Currency Code Payment | |||
PL50028 | DATETIME | DATE | 0 | 0 | 8 | CNoteDueDate | Due Date for Credit Amount | |||
PL50029 | INT | INTEGER | 0 | 0 | 1 | DiscUsageFlag | Discount Usage | |||
PL50030 | NVARCHAR | ACCSTR | 50 | 0 | 50 | MinAccString | Accounting String Minimum | |||
PL50031 | NVARCHAR | ACCSTR | 50 | 0 | 50 | MaxAccString | Accounting String Maximum | |||
PL50032 | DATETIME | DATE | 0 | 0 | 8 | PaymNotesPrintedDate | Date Payment Note Printed |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Purchase Ledger | Payment Proposal Header