Таблица: PA17 - «PA17 Payroll Trans». Маска имени таблицы: «PA17%cc%yy»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
PA17001 | NUMERIC | NUMBER | 20 | 0 | 8 | Reccounter | Record Counter | |||
PA17002 | NCHAR | STRING | 6 | 0 | 6 | Transactno | Transaction Number | 1 | Да | |
PA17003 | NCHAR | STRING | 5 | 0 | 5 | Linenumber | Line Number | 2 | Да | |
PA17004 | DATETIME | DATE | 0 | 0 | 8 | Trandate | Transaction Date | |||
PA17005 | NCHAR | SWITCH | 1 | 0 | 1 | Flag | Primary Line Currency | Used for currency/quantity accounting transactions to specify what the primary currency was for the transaction line:
0 - Normal transaction line in local currency, no foreign amount or quantity is specified. 1 - Only foreign amount or quantity is specified, no local amount exist for the transaction line. 2 - Foreign amount or quantity is specified for the transaction line but the local currency amount is the primary amount. 3 - Foreign amount is specified and was the primary amount when the transaction line was entered. (Foreign amounts and quantity is booked on statistical accounts and column PA17009 and PA17010 is used for specifying the accounting string and amount) |
||
PA17006 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accstring | Accounting String | |||
PA17007 | NUMERIC | MONEY | 28 | 8 | 20 | Amountlcu | Amount (Local Currency) | |||
PA17008 | INT | INTEGER | 0 | 0 | 2 | Currcode | Currency Code Line | |||
PA17009 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Accstringocu | Accounting String (Line Currency) | |||
PA17010 | NUMERIC | MONEY | 28 | 8 | 20 | Amountocu | Amount (Line Currency) | |||
PA17011 | NVARCHAR | VSTRING | 25 | 0 | 25 | Trantext | Transaction Line Text | |||
PA17012 | NCHAR | STRING | 10 | 0 | 10 | Code1 | Employee Code | 3 | Да | |
PA17013 | NVARCHAR | VSTRING | 23 | 0 | 23 | Code2 | Transaction Code 2 | |||
PA17014 | NCHAR | STRING | 6 | 0 | 6 | Code3 | Wage Type | |||
PA17015 | NCHAR | STRING | 2 | 0 | 2 | Code4 | Transaction Code 4 | |||
PA17016 | NVARCHAR | VSTRING | 35 | 0 | 35 | Code5 | Transaction Code 5 | |||
PA17017 | NCHAR | STRING | 8 | 0 | 8 | Code6 | Transaction Code 6 | |||
PA17018 | NCHAR | STRING | 1 | 0 | 1 | Tag1 | Transaction Tag 1 | |||
PA17019 | NCHAR | STRING | 1 | 0 | 1 | Tag2 | Transaction Tag 2 | |||
PA17020 | NCHAR | STRING | 1 | 0 | 1 | Tag3 | Transaction Tag 3 | |||
PA17021 | NCHAR | STRING | 1 | 0 | 1 | Tranlinetype | Line Type | |||
PA17022 | NCHAR | STRING | 1 | 0 | 1 | Tranlinesign | Amount Sign | 0 - Normal Sign (+ debit, - credit)
1 - Reversed Sign (+ credit, - debit) |
||
PA17023 | NUMERIC | NUMBER | 20 | 0 | 1 | Noofdecimals | Number of Decimals | |||
PA17024 | NCHAR | STRING | 5 | 0 | 5 | Linkcode | In Closing Period | |||
PA17025 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | Quantity | Quantity | |||
PA17026 | INT | INTEGER | 0 | 0 | 4 | Unitcode | Unit Code | |||
PA17027 | NUMERIC | MONEY | 28 | 8 | 20 | Amountccu | Amount (Alternative Currency) | |||
PA17028 | NCHAR | STRING | 13 | 0 | 13 | Contraacc | Contra Account | |||
PA17029 | NUMERIC | NUMBER | 20 | 0 | 6 | Journalno | Journal Number | |||
PA17030 | NCHAR | STRING | 6 | 0 | 6 | Plreference | PL Reference | |||
PA17031 | NCHAR | STRING | 6 | 0 | 6 | Subprojcode | Sub-Project Number | |||
PA17032 | NCHAR | STRING | 6 | 0 | 6 | Activitycode | Activity Code | |||
PA17033 | NCHAR | STRING | 8 | 0 | 8 | Usridentby | Entered By | |||
PA17034 | DATETIME | DATE | 0 | 0 | 8 | Dateofentry | Date Entered | |||
PA17035 | NCHAR | STRING | 8 | 0 | 8 | Usridupdby | Updated By | |||
PA17036 | DATETIME | DATE | 0 | 0 | 8 | Dateofupd | Date Updated | |||
PA17037 | NVARCHAR | VSTRING | 25 | 0 | 25 | Trantxtocu | Transaction Text (Line Currency) | |||
PA17038 | NVARCHAR | ACCSTR | 50 | 0 | 50 | Secondaccstr | Accounting String Second | |||
PA17039 | NCHAR | STRING | 8 | 0 | 8 | Usridprnby | Printed By | |||
PA17040 | DATETIME | DATE | 0 | 0 | 8 | Dateofprn | Date Printed |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Payroll | Payroll Journal