Название Таблицы / Table Name | Описание Таблицы / Table Description | Поле / Field | Расширенный комментарий / Extended Comment | Тип данных / Data Type | Длина поля iScala 3.5/ iScala 3.5 Length | Точность iScala 3.5/ iScala 3.5 Precision | Длина поля iScala 2.2/ iScala 2.2 Length | Точность iScala 2.2/ iScala 2.2 Precision | Новое поле? / is a New Field? |
PL01 | Suppliers | PL01011 | Customer Code at Supplier | NVARCHAR | 20 | 10 | — | ||
PL01 | Suppliers | PL01021 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PL01 | Suppliers | PL01025 | Tax Registration Number | NVARCHAR | 20 | 15 | — | ||
PL01 | Suppliers | PL01060 | Complete Name | NVARCHAR | 200 | 50 | — | ||
PL01 | Suppliers | PL01063 | 1099-Reporting Code | NVARCHAR | 8 | 3 | — | ||
PL01 | Suppliers | PL01092 | Financial Operation Code | NVARCHAR | 10 | 1 | — | ||
PL01 | Suppliers | PL01095 | LTM Group Code | NCHAR | 6 | — | — | + | |
PL01 | Suppliers | PL01096 | Warehouse Code | NVARCHAR | 6 | — | — | + | |
PL01 | Suppliers | PL01097 | ID Type | NCHAR | 2 | — | — | + | |
PL01 | Suppliers | PL01098 | Tax Responsibility Type | NCHAR | 2 | — | — | + | |
PL01 | Suppliers | PL01099 | Harbour | NVARCHAR | 4 | — | — | + | |
PL01 | Suppliers | PL01100 | Bundesland | NVARCHAR | 2 | — | — | + | |
PL01 | Suppliers | PL01101 | Statistical Manner Code | NVARCHAR | 6 | — | — | + | |
PL01 | Suppliers | PL01102 | Currency ID Number | NVARCHAR | 2 | — | — | + | |
PL01 | Suppliers | PL01103 | EC Department Code | NVARCHAR | 2 | — | — | + | |
PL01 | Suppliers | PL01104 | Regime Code | NVARCHAR | 2 | — | — | + | |
PL01 | Suppliers | PL01105 | Fixed Payment Day 1 | INT | 2 | — | — | + | |
PL01 | Suppliers | PL01106 | Fixed Payment Day 2 | INT | 2 | — | — | + | |
PL01 | Suppliers | PL01107 | Fixed Payment Day 3 | INT | 2 | — | — | + | |
PL01 | Suppliers | PL01108 | Month excluded from payment | INT | 2 | — | — | + | |
PL01 | Suppliers | PL01109 | Origin Date | DATETIME | 8 | — | — | + | |
PL01 | Suppliers | PL01110 | Excise Control Code | NVARCHAR | 25 | — | — | + | |
PL01 | Suppliers | PL01111 | Excise Registration Number | NVARCHAR | 25 | — | — | + | |
PL01 | Suppliers | PL01112 | Excise Division | NVARCHAR | 25 | — | — | + | |
PL01 | Suppliers | PL01113 | Region Code | NVARCHAR | 10 | — | — | + | |
PL01 | Suppliers | PL01114 | State/Province Code | NVARCHAR | 10 | — | — | + | |
PL01 | Suppliers | PL01115 | County Code | NVARCHAR | 10 | — | — | + | |
PL01 | Suppliers | PL01116 | Currency on Drop shipment order | INT | 1 | — | — | + | |
PL01 | Suppliers | PL01117 | Email Address | NVARCHAR | 200 | — | — | + | |
PL01 | Suppliers | PL01118 | Address Line 5 | NVARCHAR | 35 | — | — | + | |
PL01 | Suppliers | PL01119 | Address Line 6 | NVARCHAR | 35 | — | — | + | |
PL01 | Suppliers | PL01120 | Address Line 7 | NVARCHAR | 35 | — | — | + | |
PL01 | Suppliers | PL01121 | Extended User defined 1 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01122 | Extended User defined 2 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01123 | Extended User defined 3 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01124 | Extended User defined 4 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01125 | Extended User defined 5 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01126 | Extended User defined 6 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01127 | Extended User defined 7 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01128 | Extended User defined 8 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01129 | Extended User defined 9 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01130 | Extended User defined 10 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01131 | Extended User defined 11 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01132 | Extended User defined 12 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01133 | Extended User defined 13 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01134 | Extended User defined 14 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01135 | Extended User defined 15 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01136 | Extended User defined 16 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01137 | Extended User defined 17 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01138 | Extended User defined 18 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01139 | Extended User defined 19 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01140 | Extended User defined 20 | NVARCHAR | 150 | — | — | + | |
PL01 | Suppliers | PL01141 | BIC | NVARCHAR | 11 | — | — | + | |
PL01 | Suppliers | PL01142 | Blocking Flags | NVARCHAR | 30 | — | — | + | |
PL01 | Suppliers | PL01143 | Commodity Code | NVARCHAR | 35 | — | — | + | |
PL01 | Suppliers | PL01144 | Charges Code | NCHAR | 1 | — | — | + | |
PL01 | Suppliers | PL01145 | SUFARMA | NVARCHAR | 10 | — | — | + | |
PL01 | Suppliers | PL01146 | Government Table Number | NCHAR | 1 | — | — | + | |
PL01 | Suppliers | PL01147 | Include in Spesometro Form | NVARCHAR | 12 | — | — | + | |
PL01 | Suppliers | PL01148 | Summary Document | NCHAR | 1 | — | — | + | |
PL01 | Suppliers | PL01149 | Sub Type (Invoices) | NCHAR | 2 | — | — | + | |
PL01 | Suppliers | PL01150 | Sub Type (Credit Notes) | NCHAR | 2 | — | — | + | |
PL01 | Suppliers | PL01151 | Main Supplier Code | NCHAR | 10 | — | — | + | |
PL01 | Suppliers | PL01152 | Charge Bearer | NVARCHAR | 4 | — | — | + | |
PL01 | Suppliers | PL01153 | Split Payment | NCHAR | 1 | — | — | + | |
PL01 | Suppliers | PL01154 | Tax Bank Account | NVARCHAR | 34 | — | — | + | |
PL01 | Suppliers | PL01155 | Anonymized | NCHAR | 1 | — | — | + | |
PL03 | Purchase Ledger | PL03002 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PL03 | Purchase Ledger | PL03003 | Transaction Number | NVARCHAR | 9 | 6 | — | ||
PL03 | Purchase Ledger | PL03017 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PL03 | Purchase Ledger | PL03018 | Transaction number invoice | NVARCHAR | 9 | 6 | — | ||
PL03 | Purchase Ledger | PL03024 | Commentary Text | NVARCHAR | 50 | 15 | — | ||
PL03 | Purchase Ledger | PL03035 | Withholding Tax Base | NUMERIC | 20 | 8 | 22 | — | |
PL03 | Purchase Ledger | PL03038 | Central Bank Code | NVARCHAR | 4 | 3 | — | ||
PL03 | Purchase Ledger | PL03040 | Internal Reference Number | NVARCHAR | 9 | 6 | — | ||
PL03 | Purchase Ledger | PL03047 | With-holding Tax Code | NVARCHAR | 8 | 3 | — | ||
PL03 | Purchase Ledger | PL03052 | 1099 Tax Code | NVARCHAR | 8 | 3 | — | ||
PL03 | Purchase Ledger | PL03066 | International Reference Number | NVARCHAR | 25 | 20 | — | ||
PL03 | Purchase Ledger | PL03076 | Original Invoice Number | NVARCHAR | 25 | 15 | — | ||
PL03 | Purchase Ledger | PL03078 | Original Transaction Number | NVARCHAR | 9 | 6 | — | ||
PL03 | Purchase Ledger | PL03079 | Document Type | NCHAR | 3 | 2 | — | ||
PL03 | Purchase Ledger | PL03087 | Invoice number | NVARCHAR | 25 | 15 | — | ||
PL03 | Purchase Ledger | PL03091 | Net Invoice Amount in Local Currency (Brazil) | NUMERIC | 20 | 8 | — | — | + |
PL03 | Purchase Ledger | PL03092 | Net Invoice Amount in Invoice Currency (Brazil) | NUMERIC | 20 | 8 | — | — | + |
PL03 | Purchase Ledger | PL03093 | Instalment | NCHAR | 1 | — | — | + | |
PL03 | Purchase Ledger | PL03094 | Document Issuer Code | NCHAR | 6 | — | — | + | |
PL03 | Purchase Ledger | PL03095 | External Issuer Code | NVARCHAR | 16 | — | — | + | |
PL03 | Purchase Ledger | PL03096 | Issuer Expiration Date | DATETIME | 8 | — | — | + | |
PL03 | Purchase Ledger | PL03097 | POS Machine | NCHAR | 1 | — | — | + | |
PL03 | Purchase Ledger | PL03098 | Tax Note Number | NVARCHAR | 6 | — | — | + | |
PL03 | Purchase Ledger | PL03099 | Tax Note Register Date | DATETIME | 8 | — | — | + | |
PL03 | Purchase Ledger | PL03100 | Due date definition | INT | 1 | — | — | + | |
PL03 | Purchase Ledger | PL03101 | Payment Term | NVARCHAR | 2 | — | — | + | |
PL03 | Purchase Ledger | PL03102 | Payment Tax Liability Code | NCHAR | 6 | — | — | + | |
PL03 | Purchase Ledger | PL03103 | Payment Block Reason Code | INT | 3 | — | — | + | |
PL03 | Purchase Ledger | PL03104 | Broker Supplier Code | NVARCHAR | 10 | — | — | + | |
PL03 | Purchase Ledger | PL03105 | Customs Declaration Number | NVARCHAR | 25 | — | — | + | |
PL03 | Purchase Ledger | PL03106 | Additional Invoice Flag | INT | 1 | — | — | + | |
PL03 | Purchase Ledger | PL03107 | Fiscal Key | NVARCHAR | 50 | — | — | + | |
PL03 | Purchase Ledger | PL03108 | Fiscal Key Protocol Number | NVARCHAR | 20 | — | — | + | |
PL03 | Purchase Ledger | PL03109 | Fiscal Key Protocol Date | DATETIME | 17 | — | — | + | |
PL03 | Purchase Ledger | PL03110 | Extended User defined 1 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03111 | Extended User defined 2 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03112 | Extended User defined 3 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03113 | Extended User defined 4 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03114 | Extended User defined 5 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03115 | Extended User defined 6 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03116 | Extended User defined 7 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03117 | Extended User defined 8 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03118 | Extended User defined 9 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03119 | Extended User defined 10 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03120 | Extended User defined 11 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03121 | Extended User defined 12 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03122 | Extended User defined 13 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03123 | Extended User defined 14 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03124 | Extended User defined 15 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03125 | Extended User defined 16 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03126 | Extended User defined 17 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03127 | Extended User defined 18 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03128 | Extended User defined 19 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03129 | Extended User defined 20 | NVARCHAR | 150 | — | — | + | |
PL03 | Purchase Ledger | PL03130 | Include in Spesometro form | NVARCHAR | 12 | — | — | + | |
PL03 | Purchase Ledger | PL03131 | Summary Document | NCHAR | 1 | — | — | + | |
PL03 | Purchase Ledger | PL03132 | Sub type | NCHAR | 2 | — | — | + | |
PL03 | Purchase Ledger | PL03133 | Adjustment Number (Cancelled Invoice) | NVARCHAR | 25 | — | — | + | |
PL03 | Purchase Ledger | PL03134 | Adjustment Date (Cancelled Invoice) | DATETIME | 8 | — | — | + | |
PL03 | Purchase Ledger | PL03135 | Adjustment Comment (Cancelled Invoice) | NVARCHAR | 50 | — | — | + | |
PL03 | Purchase Ledger | PL03136 | Adjustment Code (Cancelled invoice) | NCHAR | 2 | — | — | + | |
PL03 | Purchase Ledger | PL03137 | Public Procurement Code1 | NVARCHAR | 20 | — | — | + | |
PL03 | Purchase Ledger | PL03138 | Public Procurement Code2 | NVARCHAR | 20 | — | — | + | |
PL03 | Purchase Ledger | PL03139 | Tax discount flag | NCHAR | 1 | — | — | + | |
PL03 | Purchase Ledger | PL03140 | Tax Registration Country | NCHAR | 3 | — | — | + | |
PL04 | Invoice Journal | PL04001 | Record Counter | NUMERIC | 9 | 8 | — | ||
PL04 | Invoice Journal | PL04002 | Transaction Number | NCHAR | 9 | 6 | — | ||
PL04 | Invoice Journal | PL04003 | Line Number | NCHAR | 7 | 5 | — | ||
PL04 | Invoice Journal | PL04006 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PL04 | Invoice Journal | PL04009 | Accounting String Line Currency | NVARCHAR | 120 | 50 | — | ||
PL04 | Invoice Journal | PL04011 | Transaction Line Text | NVARCHAR | 100 | 25 | — | ||
PL04 | Invoice Journal | PL04013 | Invoice Number | NVARCHAR | 25 | 23 | — | ||
PL04 | Invoice Journal | PL04024 | In Closing Period | NCHAR | 8 | 5 | — | ||
PL04 | Invoice Journal | PL04026 | Unit Code | INT | 4 | 2 | — | ||
PL04 | Invoice Journal | PL04030 | Internal Reference Number | NCHAR | 9 | 6 | — | ||
PL04 | Invoice Journal | PL04037 | Transaction Text (Line Currency) | NVARCHAR | 100 | 25 | — | ||
PL04 | Invoice Journal | PL04038 | Source Company | NCHAR | 2 | — | — | + | |
PL04 | Invoice Journal | PL04039 | Printed By | NCHAR | 8 | — | — | + | |
PL04 | Invoice Journal | PL04040 | Date Printed | DATETIME | 8 | — | — | + | |
PL04 | Invoice Journal | PL04041 | PrintedStatus | NCHAR | 1 | — | — | + | |
PL04 | Invoice Journal | PL04042 | AAS code | NVARCHAR | 25 | — | — | + | |
PL05 | Payment Journal | PL05001 | Record Counter | NUMERIC | 9 | 8 | — | ||
PL05 | Payment Journal | PL05002 | Transact Number | NCHAR | 9 | 6 | — | ||
PL05 | Payment Journal | PL05003 | Line Number | NCHAR | 7 | 5 | — | ||
PL05 | Payment Journal | PL05006 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PL05 | Payment Journal | PL05009 | Accounting String (Line Currency) | NVARCHAR | 120 | 50 | — | ||
PL05 | Payment Journal | PL05011 | Transaction Line Text | NVARCHAR | 100 | 25 | — | ||
PL05 | Payment Journal | PL05013 | Invoice Number | NVARCHAR | 25 | 23 | — | ||
PL05 | Payment Journal | PL05024 | In Closing Period | NCHAR | 8 | 5 | — | ||
PL05 | Payment Journal | PL05026 | Unit Code | INT | 4 | 2 | — | ||
PL05 | Payment Journal | PL05030 | Internal Reference Number | NCHAR | 9 | 6 | — | ||
PL05 | Payment Journal | PL05037 | Transaction Text (Line Currency) | NVARCHAR | 100 | 25 | — | ||
PL05 | Payment Journal | PL05041 | Printed By | NCHAR | 8 | — | — | + | |
PL05 | Payment Journal | PL05042 | Date Printed | DATETIME | 8 | — | — | + | |
PL05 | Payment Journal | PL05043 | PrintedStatus | NCHAR | 1 | — | — | + | |
PL05 | Payment Journal | PL05044 | AAS code | NVARCHAR | 25 | — | — | + | |
PL05 | Payment Journal | PL05045 | TaxCode | NVARCHAR | 6 | — | — | + | |
PL07 | Payment Proposal | PL07002 | Invoice Number | NCHAR | 25 | 15 | — | ||
PL07 | Payment Proposal | PL07008 | 1099 Code | NCHAR | 8 | 3 | — | ||
PL07 | Payment Proposal | PL07018 | InstalmentNumber | INT | 3 | — | — | + | |
PL07 | Payment Proposal | PL07019 | Payment order number | NVARCHAR | 6 | — | — | + | |
PL07 | Payment Proposal | PL07020 | Cheque number | NVARCHAR | 6 | — | — | + | |
PL07 | Payment Proposal | PL07021 | Payment order approved | NCHAR | 1 | — | — | + | |
PL07 | Payment Proposal | PL07022 | Bank Account Number | NCHAR | 34 | — | — | + | |
PL07 | Payment Proposal | PL07023 | Spare | NCHAR | 30 | — | — | + | |
PL07 | Payment Proposal | PL07024 | Invoice Currency Code | NCHAR | 2 | — | — | + | |
PL07 | Payment Proposal | PL07025 | Bank Account Currency Code | NCHAR | 2 | — | — | + | |
PL07 | Payment Proposal | PL07026 | Payment ID | NCHAR | 10 | — | — | + | |
PL07 | Payment Proposal | PL07027 | Payment Tax Liability code | NCHAR | 6 | — | — | + | |
PL07 | Payment Proposal | PL07028 | Index field | NCHAR | 10 | — | — | + | |
PL07 | Payment Proposal | PL07029 | PO3 Sub type | NCHAR | 2 | — | — | + | |
PL07 | Payment Proposal | PL07030 | Instalment Type | INT | 1 | — | — | + | |
PL07 | Payment Proposal | PL07031 | Original instalment number | NCHAR | 3 | — | — | + | |
PL08 | Purchase Parameters | PL08006 | Info on Supplier Query | NUMERIC | 3 | 8 | 2 | 8 | — |
PL08 | Purchase Parameters | PL08041 | Print Tax Code and Base Amount | INT | 1 | — | — | + | |
PL08 | Purchase Parameters | PL08042 | Default Tax Code | NVARCHAR | 6 | — | — | + | |
PL08 | Purchase Parameters | PL08043 | Report Tax Codes | NVARCHAR | 50 | — | — | + | |
PL08 | Purchase Parameters | PL08044 | Renumbering of Unauthorized Invoice Switch | INT | 1 | — | — | + | |
PL08 | Purchase Parameters | PL08045 | Currency Exchange Rate Date | INT | 1 | — | — | + | |
PL08 | Purchase Parameters | PL08046 | Late Assignment Of Transaction Number | NCHAR | 1 | — | — | + | |
PL08 | Purchase Parameters | PL08047 | Default Supplier Life Cycle Status | NCHAR | 1 | — | — | + | |
PL08 | Purchase Parameters | PL08048 | Default Central Bank Code | NCHAR | 4 | — | — | + | |
PL09 | Automatic Accounting Table | PL09003 | Accounting code 1 | NCHAR | 2 | — | — | + | |
PL09 | Automatic Accounting Table | PL09004 | Accounting code 2 | NCHAR | 2 | — | — | + | |
PL09 | Automatic Accounting Table | PL09005 | Extra code | NCHAR | 2 | — | — | + | |
PL10 | Payment Ledger | PL10002 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PL10 | Payment Ledger | PL10003 | Line Number | NVARCHAR | 6 | 2 | — | ||
PL10 | Payment Ledger | PL10004 | Transaction Number | NVARCHAR | 9 | 6 | — | ||
PL10 | Payment Ledger | PL10010 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PL10 | Payment Ledger | PL10015 | Text | NVARCHAR | 25 | 15 | — | ||
PL10 | Payment Ledger | PL10016 | Check Number | NVARCHAR | 15 | 6 | — | ||
PL10 | Payment Ledger | PL10025 | Payment ID | NCHAR | 10 | — | — | + | |
PL10 | Payment Ledger | PL10026 | AAS code | NVARCHAR | 25 | — | — | + | |
PL10 | Payment Ledger | PL10027 | InvBankRef | NVARCHAR | 25 | — | — | + | |
PL10 | Payment Ledger | PL10028 | PO3 Sub type | NCHAR | 2 | — | — | + | |
PL10 | Payment Ledger | PL10029 | Payment Proposal | NCHAR | 10 | — | — | + | |
PL14 | Shipping Addresses | PL14015 | Country Code | NCHAR | 3 | — | — | + | |
PL14 | Shipping Addresses | PL14016 | Region Code | NVARCHAR | 10 | — | — | + | |
PL14 | Shipping Addresses | PL14017 | State/Province Code | NVARCHAR | 10 | — | — | + | |
PL14 | Shipping Addresses | PL14018 | County Code | NVARCHAR | 10 | — | — | + | |
PL14 | Shipping Addresses | PL14019 | Address Line 5 | NVARCHAR | 35 | — | — | + | |
PL14 | Shipping Addresses | PL14020 | Address Line 6 | NVARCHAR | 35 | — | — | + | |
PL14 | Shipping Addresses | PL14021 | Address Line 7 | NVARCHAR | 35 | — | — | + | |
PL15 | Payment Methods | PL15004 | Parameter 1 | NVARCHAR | 3 | 2 | — | ||
PL15 | Payment Methods | PL15011 | OutstandingItem | NCHAR | 1 | — | — | + | |
PL15 | Payment Methods | PL15012 | Parameter 6 | NCHAR | 3 | — | — | + | |
PL15 | Payment Methods | PL15013 | Parameter 7 | NCHAR | 3 | — | — | + | |
PL15 | Payment Methods | PL15014 | Parameter 8 | NCHAR | 3 | — | — | + | |
PL15 | Payment Methods | PL15015 | SEPA Sub Types | NVARCHAR | 20 | — | — | + | |
PL15 | Payment Methods | PL15016 | Parameter 10 | NCHAR | 3 | — | — | + | |
PL15 | Payment Methods | PL15017 | Parameter 11 | NCHAR | 3 | — | — | + | |
PL15 | Payment Methods | PL15018 | AAS for tax | INT | 3 | — | — | + | |
PL17 | VAT Transactions | PL17001 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PL17 | VAT Transactions | PL17005 | Line Number | NVARCHAR | 7 | 5 | — | ||
PL17 | VAT Transactions | PL17011 | Invoice Reference Number | NVARCHAR | 9 | 6 | — | ||
PL17 | VAT Transactions | PL17019 | Transaction Number | NVARCHAR | 9 | 6 | — | ||
PL17 | VAT Transactions | PL17023 | Document Type | NCHAR | 3 | 2 | — | ||
PL17 | VAT Transactions | PL17035 | Tax Exemption | NCHAR | 2 | 1 | — | ||
PL17 | VAT Transactions | PL17050 | InvoiceRefer | NVARCHAR | 25 | — | — | + | |
PL17 | VAT Transactions | PL17051 | Original Currency Code | NVARCHAR | 2 | — | — | + | |
PL17 | VAT Transactions | PL17052 | Base Amount (Original Currency) | NUMERIC | 20 | 8 | — | — | + |
PL17 | VAT Transactions | PL17053 | Tax Slip No | NVARCHAR | 15 | — | — | + | |
PL17 | VAT Transactions | PL17054 | Tax Slip Line | NVARCHAR | 6 | — | — | + | |
PL17 | VAT Transactions | PL17055 | Accounting Info | NVARCHAR | 120 | — | — | + | |
PL17 | VAT Transactions | PL17056 | Line Reference | NVARCHAR | 7 | — | — | + | |
PL17 | VAT Transactions | PL17057 | Financial Year | NVARCHAR | 4 | — | — | + | |
PL17 | VAT Transactions | PL17058 | Ref GL06 | NVARCHAR | 9 | — | — | + | |
PL17 | VAT Transactions | PL17059 | Direct from GL | NVARCHAR | 1 | — | — | + | |
PL17 | VAT Transactions | PL17060 | Issuer Code | NCHAR | 6 | — | — | + | |
PL17 | VAT Transactions | PL17061 | Order Line Number | NCHAR | 10 | — | — | + | |
PL17 | VAT Transactions | PL17062 | AAS code | NVARCHAR | 25 | — | — | + | |
PL17 | VAT Transactions | PL17063 | ThirdPartySupplier | NVARCHAR | 10 | — | — | + | |
PL17 | VAT Transactions | PL17064 | ProRataAmount | NUMERIC | 20 | 8 | — | — | + |
PL17 | VAT Transactions | PL17065 | Reference to SL Invoice | NVARCHAR | 25 | — | — | + | |
PL17 | VAT Transactions | PL17066 | Certificate Date | DATETIME | 8 | — | — | + | |
PL17 | VAT Transactions | PL17067 | Non Deductible Amount | NUMERIC | 20 | 8 | — | — | + |
PL17 | VAT Transactions | PL17068 | OrderSubLineNo | NVARCHAR | 6 | — | — | + | |
PL17 | VAT Transactions | PL17069 | Actual Tax Base | NUMERIC | 20 | 8 | — | — | + |
PL17 | VAT Transactions | PL17070 | Actual Tax Rate | NUMERIC | 12 | 8 | — | — | + |
PL17 | VAT Transactions | PL17071 | Destination Rate | NUMERIC | 8 | 8 | — | — | + |
PL17 | VAT Transactions | PL17072 | Cost Type | NCHAR | 2 | — | — | + | |
PL17 | VAT Transactions | PL17073 | HMRC Period Key | NVARCHAR | 4 | — | — | + | |
PL17 | VAT Transactions | PL17074 | Tax Registration Country | NCHAR | 3 | — | — | + | |
PL18 | W-holding Tax | PL18002 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PL18 | W-holding Tax | PL18003 | Transaction Number | NVARCHAR | 9 | 6 | — | ||
PL18 | W-holding Tax | PL18009 | With-holding Tax Code | NVARCHAR | 8 | 3 | — | ||
PL18 | W-holding Tax | PL18014 | Update Flag | NCHAR | 1 | — | — | + | |
PL18 | W-holding Tax | PL18015 | With-holding Tax Base amount (Local Currency) | NUMERIC | 20 | 8 | — | — | + |
PL18 | W-holding Tax | PL18016 | Instalment No | INT | 3 | — | — | + | |
PL19 | Standard Suppliers | PL19011 | Customer Code at Supplier | NVARCHAR | 20 | 10 | — | ||
PL19 | Standard Suppliers | PL19021 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PL19 | Standard Suppliers | PL19025 | Tax Registration Number | NVARCHAR | 20 | 15 | — | ||
PL19 | Standard Suppliers | PL19060 | Complete Name | NVARCHAR | 200 | 50 | — | ||
PL19 | Standard Suppliers | PL19063 | 1099-Reporting Code | NVARCHAR | 8 | 3 | — | ||
PL19 | Standard Suppliers | PL19092 | Financial Operation Code | NVARCHAR | 10 | 1 | — | ||
PL19 | Standard Suppliers | PL19095 | LTM Group | NCHAR | 6 | — | — | + | |
PL19 | Standard Suppliers | PL19096 | Warehouse code | NVARCHAR | 6 | — | — | + | |
PL19 | Standard Suppliers | PL19097 | TaxIDType | NCHAR | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19098 | ResponsibilityType | NCHAR | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19099 | Harbour | NVARCHAR | 4 | — | — | + | |
PL19 | Standard Suppliers | PL19100 | Bundesland | NVARCHAR | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19101 | StatManner | NVARCHAR | 6 | — | — | + | |
PL19 | Standard Suppliers | PL19102 | CurrIdentNumber | NVARCHAR | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19103 | ECDepartment | NVARCHAR | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19104 | Regime | NVARCHAR | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19105 | FixPaymentDay1 | INT | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19106 | FixPaymentDay2 | INT | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19107 | FixPaymentDay3 | INT | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19108 | PaymntExcludMonth | INT | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19109 | Origin Date | DATETIME | 8 | — | — | + | |
PL19 | Standard Suppliers | PL19110 | Excise Control Code | NVARCHAR | 25 | — | — | + | |
PL19 | Standard Suppliers | PL19111 | Excise Registration Number | NVARCHAR | 25 | — | — | + | |
PL19 | Standard Suppliers | PL19112 | Excise Division | NVARCHAR | 25 | — | — | + | |
PL19 | Standard Suppliers | PL19113 | Region Code | NVARCHAR | 10 | — | — | + | |
PL19 | Standard Suppliers | PL19114 | State/Province Code | NVARCHAR | 10 | — | — | + | |
PL19 | Standard Suppliers | PL19115 | County Code | NVARCHAR | 10 | — | — | + | |
PL19 | Standard Suppliers | PL19116 | Currency for DS | INT | 1 | — | — | + | |
PL19 | Standard Suppliers | PL19117 | Email address | NVARCHAR | 200 | — | — | + | |
PL19 | Standard Suppliers | PL19118 | Address Line 5 | NVARCHAR | 35 | — | — | + | |
PL19 | Standard Suppliers | PL19119 | Address Line 6 | NVARCHAR | 35 | — | — | + | |
PL19 | Standard Suppliers | PL19120 | Address Line 7 | NVARCHAR | 35 | — | — | + | |
PL19 | Standard Suppliers | PL19121 | Ext. User defined field 1 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19122 | Ext. User defined field 2 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19123 | Ext. User defined field 3 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19124 | Ext. User defined field 4 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19125 | Ext. User defined field 5 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19126 | Ext. User defined field 6 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19127 | Ext. User defined field 7 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19128 | Ext. User defined field 8 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19129 | Ext. User defined field 9 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19130 | Ext. User defined field 10 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19131 | Ext. User defined field 11 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19132 | Ext. User defined field 12 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19133 | Ext. User defined field 13 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19134 | Ext. User defined field 14 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19135 | Ext. User defined field 15 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19136 | Ext. User defined field 16 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19137 | Ext. User defined field 17 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19138 | Ext. User defined field 18 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19139 | Ext. User defined field 19 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19140 | Ext. User defined field 20 | NVARCHAR | 150 | — | — | + | |
PL19 | Standard Suppliers | PL19141 | BIC | NVARCHAR | 11 | — | — | + | |
PL19 | Standard Suppliers | PL19142 | Blocking Flags | NVARCHAR | 30 | — | — | + | |
PL19 | Standard Suppliers | PL19143 | Commodity code | NVARCHAR | 35 | — | — | + | |
PL19 | Standard Suppliers | PL19144 | Charges code | NCHAR | 1 | — | — | + | |
PL19 | Standard Suppliers | PL19145 | SUFARMA | NVARCHAR | 10 | — | — | + | |
PL19 | Standard Suppliers | PL19146 | Government Table number | NCHAR | 1 | — | — | + | |
PL19 | Standard Suppliers | PL19147 | Spesometro Forms | NVARCHAR | 12 | — | — | + | |
PL19 | Standard Suppliers | PL19148 | Summary Document | NCHAR | 1 | — | — | + | |
PL19 | Standard Suppliers | PL19149 | PO3 Sub type deb | NCHAR | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19150 | PO3 Sub type cre | NCHAR | 2 | — | — | + | |
PL19 | Standard Suppliers | PL19151 | Main Supplier Code | NCHAR | 10 | — | — | + | |
PL19 | Standard Suppliers | PL19152 | Charge Bearer | NVARCHAR | 4 | — | — | + | |
PL19 | Standard Suppliers | PL19153 | Split Payment | NCHAR | 1 | — | — | + | |
PL19 | Standard Suppliers | PL19154 | Tax Bank Account | NVARCHAR | 34 | — | — | + | |
PL19 | Standard Suppliers | PL19155 | Anonymized | NCHAR | 1 | — | — | + | |
PL21 | Purchase Ledger | PL21002 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PL21 | Purchase Ledger | PL21003 | Line Number | NVARCHAR | 6 | 2 | — | ||
PL21 | Purchase Ledger | PL21005 | Transact Number | NVARCHAR | 9 | 6 | — | ||
PL21 | Purchase Ledger | PL21010 | Check Number | NVARCHAR | 15 | 6 | — | ||
PL21 | Purchase Ledger | PL21031 | InstalmentNumber | INT | 3 | — | — | + | |
PL21 | Purchase Ledger | PL21032 | Reconciled | NCHAR | 1 | — | — | + | |
PL21 | Purchase Ledger | PL21033 | Payment Proposal | NCHAR | 10 | — | — | + | |
PL21 | Purchase Ledger | PL21034 | Payment Method | NCHAR | 2 | — | — | + | |
PL21 | Purchase Ledger | PL21035 | Voiding Status | INT | 1 | — | — | + | |
PL21 | Purchase Ledger | PL21036 | Accounting String | NVARCHAR | 120 | — | — | + | |
PL21 | Purchase Ledger | PL21037 | AAS Reference | NVARCHAR | 25 | — | — | + | |
PL21 | Purchase Ledger | PL21038 | Remittance Link | NVARCHAR | 38 | — | — | + | |
PL21 | Purchase Ledger | PL21039 | Prepayment Link | NVARCHAR | 30 | — | — | + | |
PL21 | Purchase Ledger | PL21040 | Link Type | NCHAR | 1 | — | — | + | |
PL21 | Purchase Ledger | PL21041 | Instalment Type | NUMERIC | 1 | — | — | + | |
PL21 | Purchase Ledger | PL21042 | Accounting String AP | NVARCHAR | 120 | — | — | + | |
PL22 | Payment Terms PL | PL22014 | Instalments | NCHAR | 1 | — | — | + | |
PL22 | Payment Terms PL | PL22015 | FixedPaymDays | NVARCHAR | 1 | — | — | + | |
PL22 | Payment Terms PL | PL22016 | FixedPaymentDay | NVARCHAR | 2 | — | — | + | |
PL22 | Payment Terms PL | PL22017 | PaymentMethod | NVARCHAR | 2 | — | — | + | |
PL22 | Payment Terms PL | PL22018 | DueDateDefinition | INT | 1 | — | — | + | |
PL22 | Payment Terms PL | PL22019 | Statistical factor | NUMERIC | 12 | 8 | — | — | + |
PL22 | Payment Terms PL | PL22020 | Min Coin Rounding | NCHAR | 1 | — | — | + | |
PL22 | Payment Terms PL | PL22021 | Cash Payment Flag | NCHAR | 1 | — | — | + | |
PL22 | Payment Terms PL | PL22022 | End Of Month Switch | NVARCHAR | 1 | — | — | + | |
PL22 | Payment Terms PL | PL22023 | Days After End Of Month | INT | 4 | — | — | + | |
PL24 | Tax details for prepayment | PL24001 | InvoiceNo | NVARCHAR | 25 | 15 | — | ||
PL24 | Tax details for prepayment | PL24011 | TransNo | NVARCHAR | 9 | 6 | — | ||
PL24 | Tax details for prepayment | PL24019 | TransactionNo/LineNo | NVARCHAR | 9 | 6 | — | ||
PL24 | Tax details for prepayment | PL24023 | DocumentType | NCHAR | 3 | 2 | — | ||
PL24 | Tax details for prepayment | PL24050 | InvoiceRefer | NVARCHAR | 25 | — | — | + | |
PL25 | Tax details for payment | PL25001 | InvoiceNo | NVARCHAR | 25 | 15 | — | ||
PL25 | Tax details for payment | PL25011 | TransNo | NVARCHAR | 9 | 6 | — | ||
PL25 | Tax details for payment | PL25019 | TransactionNo/LineNo | NVARCHAR | 9 | 6 | — | ||
PL25 | Tax details for payment | PL25023 | DocumentType | NCHAR | 3 | 2 | — | ||
PL25 | Tax details for payment | PL25050 | InvoiceRefer | NVARCHAR | 25 | — | — | + | |
PL30 | Check Register | PL30001 | Check Number | NVARCHAR | 15 | 6 | — | ||
PL30 | Check Register | PL30002 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PL30 | Check Register | PL30004 | Transaction Number | NVARCHAR | 9 | 6 | — | ||
PL30 | Check Register | PL30008 | AccountString | NVARCHAR | 120 | 12 | — | ||
PL30 | Check Register | PL30010 | Transaction Text | NVARCHAR | 100 | 25 | — | ||
PL30 | Check Register | PL30017 | Voided | NCHAR | 1 | — | — | + | |
PL30 | Check Register | PL30018 | Instalment Number | INT | 3 | — | — | + | |
PL30 | Check Register | PL30019 | Payment order number | NVARCHAR | 6 | — | — | + | |
PL30 | Check Register | PL30020 | Type | NVARCHAR | 1 | — | — | + | |
PL30 | Check Register | PL30021 | Bank Code | NVARCHAR | 10 | — | — | + | |
PL30 | Check Register | PL30022 | Cheque Number | NVARCHAR | 7 | — | — | + | |
PL30 | Check Register | PL30023 | Cheque Number Control Digit | NVARCHAR | 1 | — | — | + | |
PL30 | Check Register | PL30024 | Date Emission | DATETIME | 8 | — | — | + | |
PL30 | Check Register | PL30025 | Due Date | DATETIME | 8 | — | — | + | |
PL30 | Check Register | PL30026 | Printed | NVARCHAR | 1 | — | — | + | |
PL30 | Check Register | PL30027 | Cheque Series | NVARCHAR | 2 | — | — | + | |
PL30 | Check Register | PL30028 | AAS code | NVARCHAR | 25 | — | — | + | |
PL30 | Check Register | PL30029 | Partially Voided | NCHAR | 1 | — | — | + | |
PL30 | Check Register | PL30030 | Payment Proposal | NVARCHAR | 10 | — | — | + | |
PL32 | User defined parameters | PL32001 | PaymentMethod | NVARCHAR | 2 | — | — | + | |
PL32 | User defined parameters | PL32002 | ParameterNumber | NVARCHAR | 3 | — | — | + | |
PL32 | User defined parameters | PL32003 | Name | NVARCHAR | 25 | — | — | + | |
PL32 | User defined parameters | PL32004 | Label | NVARCHAR | 35 | — | — | + | |
PL32 | User defined parameters | PL32005 | Format | NVARCHAR | 1 | — | — | + | |
PL32 | User defined parameters | PL32006 | Length | NVARCHAR | 5 | — | — | + | |
PL32 | User defined parameters | PL32007 | Group | NVARCHAR | 2 | — | — | + | |
PL32 | User defined parameters | PL32008 | Code | NVARCHAR | 3 | — | — | + | |
PL32 | User defined parameters | PL32009 | Default | NVARCHAR | 255 | — | — | + | |
PL33 | Values for user defined parameters | PL33001 | PaymentMethod | NVARCHAR | 2 | — | — | + | |
PL33 | Values for user defined parameters | PL33002 | ParameterNumber | NVARCHAR | 3 | — | — | + | |
PL33 | Values for user defined parameters | PL33003 | Value | NVARCHAR | 255 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40001 | Order Number | NCHAR | 10 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40002 | Line Number | NCHAR | 6 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40003 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40004 | Prepayment Invoice Number | NVARCHAR | 25 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40005 | Allocated Amount PCU | NUMERIC | 20 | 8 | — | — | + |
PL40 | Prepayment Allocation Lines | PL40006 | Allocated Amount OCU | NUMERIC | 20 | 8 | — | — | + |
PL40 | Prepayment Allocation Lines | PL40007 | Payment Currency Code | INT | 2 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40008 | PCU Exchange Rate 1 | NUMERIC | 10 | 8 | — | — | + |
PL40 | Prepayment Allocation Lines | PL40009 | PCU Exchange Algorithm | NCHAR | 3 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40010 | PCU Exchange Rate 2 | NUMERIC | 10 | 8 | — | — | + |
PL40 | Prepayment Allocation Lines | PL40011 | Order Currency Code | INT | 2 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40012 | OCU Exchange Rate 1 | NUMERIC | 10 | 8 | — | — | + |
PL40 | Prepayment Allocation Lines | PL40013 | OCU Exchange Algorithm | NCHAR | 3 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40014 | OCU Exchange Rate 2 | NUMERIC | 10 | 8 | — | — | + |
PL40 | Prepayment Allocation Lines | PL40015 | Status | NCHAR | 1 | — | — | + | |
PL40 | Prepayment Allocation Lines | PL40016 | Remark | NVARCHAR | 40 | — | — | + | |
PL41 | Prepayment Tax Lines | PL41001 | Order Number | NCHAR | 10 | — | — | + | |
PL41 | Prepayment Tax Lines | PL41002 | Line Number | NCHAR | 6 | — | — | + | |
PL41 | Prepayment Tax Lines | PL41003 | Tax Base Line Number | NCHAR | 6 | — | — | + | |
PL41 | Prepayment Tax Lines | PL41004 | Order Line Number | NCHAR | 6 | — | — | + | |
PL41 | Prepayment Tax Lines | PL41005 | Tax Code | NCHAR | 6 | — | — | + | |
PL41 | Prepayment Tax Lines | PL41006 | Gross Tax Base PCU | NUMERIC | 20 | 8 | — | — | + |
PL41 | Prepayment Tax Lines | PL41007 | Net Tax Base PCU | NUMERIC | 20 | 8 | — | — | + |
PL41 | Prepayment Tax Lines | PL41008 | Tax Amount PCU | NUMERIC | 20 | 8 | — | — | + |
PL41 | Prepayment Tax Lines | PL41009 | Gross Tax Base LCU | NUMERIC | 20 | 8 | — | — | + |
PL41 | Prepayment Tax Lines | PL41010 | Net Tax Base LCU | NUMERIC | 20 | 8 | — | — | + |
PL41 | Prepayment Tax Lines | PL41011 | Tax Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PL43 | Prepayment Deductions | PL43001 | Order Number | NCHAR | 10 | — | — | + | |
PL43 | Prepayment Deductions | PL43002 | Line Number | NCHAR | 6 | — | — | + | |
PL43 | Prepayment Deductions | PL43003 | Tax Base Line Number | NCHAR | 6 | — | — | + | |
PL43 | Prepayment Deductions | PL43004 | Purchase Invoice Number | NVARCHAR | 25 | — | — | + | |
PL43 | Prepayment Deductions | PL43005 | Deducted Amount PCU | NUMERIC | 20 | 8 | — | — | + |
PL43 | Prepayment Deductions | PL43006 | Deducted Tax Amount PCU | NUMERIC | 20 | 8 | — | — | + |
PL43 | Prepayment Deductions | PL43007 | Deducted Amount ICU | NUMERIC | 20 | 8 | — | — | + |
PL43 | Prepayment Deductions | PL43008 | Deducted Tax Amount ICU | NUMERIC | 20 | 8 | — | — | + |
PL43 | Prepayment Deductions | PL43009 | Deducted Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PL43 | Prepayment Deductions | PL43010 | Deducted Tax Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PL44 | Prepayment Documents | PL44003 | Cheque Number | NVARCHAR | 15 | 6 | — | ||
PL44 | Prepayment Documents | PL44013 | (obsolete) | NVARCHAR | 120 | 50 | — | ||
PL44 | Prepayment Documents | PL44015 | Currency Conversion Text | NVARCHAR | 120 | 50 | — | ||
PL44 | Prepayment Documents | PL44017 | (obsolete) | NVARCHAR | 120 | 50 | — | ||
PL44 | Prepayment Documents | PL44019 | (obsolete) | NVARCHAR | 120 | 50 | — | ||
PL44 | Prepayment Documents | PL44021 | (obsolete) | NVARCHAR | 120 | 50 | — | ||
PL44 | Prepayment Documents | PL44025 | Document Layout | INT | 2 | 1 | — | ||
PL44 | Prepayment Documents | PL44033 | Address Line 5 | NVARCHAR | 35 | — | — | + | |
PL44 | Prepayment Documents | PL44034 | Address Line 6 | NVARCHAR | 35 | — | — | + | |
PL44 | Prepayment Documents | PL44035 | Address Line 7 | NVARCHAR | 35 | — | — | + | |
PL44 | Prepayment Documents | PL44036 | Country Code | NVARCHAR | 3 | — | — | + | |
PL45 | Extended Bank Info | PL45004 | External Bank Code | NVARCHAR | 11 | 10 | — | ||
PL45 | Extended Bank Info | PL45021 | Address Line 5 | NVARCHAR | 35 | — | — | + | |
PL45 | Extended Bank Info | PL45022 | Address Line 6 | NVARCHAR | 35 | — | — | + | |
PL45 | Extended Bank Info | PL45023 | Address Line 7 | NVARCHAR | 35 | — | — | + | |
PL45 | Extended Bank Info | PL45024 | Correspondent Address Line 5 | NVARCHAR | 35 | — | — | + | |
PL45 | Extended Bank Info | PL45025 | Correspondent Address Line 6 | NVARCHAR | 35 | — | — | + | |
PL45 | Extended Bank Info | PL45026 | Correspondent Address Line 7 | NVARCHAR | 35 | — | — | + | |
PL45 | Extended Bank Info | PL45027 | Country Code | NVARCHAR | 3 | — | — | + | |
PL45 | Extended Bank Info | PL45028 | Correspondent Country Code | NVARCHAR | 3 | — | — | + | |
PL45 | Extended Bank Info | PL45029 | SEPA Default | INT | 1 | — | — | + | |
PL45 | Extended Bank Info | PL45030 | Clearing System ID (BBAN) | NCHAR | 5 | — | — | + | |
PL45 | Extended Bank Info | PL45031 | Clearing Member ID (BBAN) | NVARCHAR | 35 | — | — | + | |
PL45 | Extended Bank Info | PL45032 | Correspondent Clearing System ID (BBAN) | NCHAR | 5 | — | — | + | |
PL45 | Extended Bank Info | PL45033 | Correspondent Clearing Member ID (BBAN) | NVARCHAR | 35 | — | — | + | |
PL45 | Extended Bank Info | PL45034 | Tax Bank Account | NVARCHAR | 34 | — | — | + | |
PL46 | Invoice OCR Payment Reference | PL46002 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PL50 | Supplier Payment Proposal Header | PL50030 | Accounting String Minimum | NVARCHAR | 120 | 50 | — | ||
PL50 | Supplier Payment Proposal Header | PL50031 | Accounting String Maximum | NVARCHAR | 120 | 50 | — | ||
PL51 | Purchase Ledger PN/PDC Payment Proposal | PL51002 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PL51 | Purchase Ledger PN/PDC Payment Proposal | PL51008 | With-holding Tax Code | NCHAR | 8 | 3 | — | ||
PL56 | Imported Executed Supplier Payments | PL56001 | Supplier Code | NCHAR | 10 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56002 | Invoice Number | NCHAR | 25 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56003 | Payment ID | NCHAR | 10 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56004 | Received Payment Date | NCHAR | 8 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56005 | Executed Payment Date | NCHAR | 8 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56006 | Supplier’s account | NCHAR | 35 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56007 | Reference | NCHAR | 25 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56008 | Amount | NUMERIC | 20 | 8 | — | — | + |
PL56 | Imported Executed Supplier Payments | PL56009 | Source of Import | INT | 2 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56010 | Currency Code | NCHAR | 3 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56011 | Status | INT | 1 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56012 | Blocked for reconciliation | INT | 1 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56013 | PO3 Sub type | NCHAR | 2 | — | — | + | |
PL56 | Imported Executed Supplier Payments | PL56014 | Proposal Number | NCHAR | 10 | — | — | + | |
PL88 | Check Printout | PL88001 | CheckNo | NVARCHAR | 15 | 6 | — | ||
PL88 | Check Printout | PL88003 | InvoiceNo | NVARCHAR | 25 | 15 | — | ||
PL88 | Check Printout | PL88005 | CheckNoAmChe | NVARCHAR | 15 | 6 | — | ||
PL88 | Check Printout | PL88006 | Instalment | INT | 3 | — | — | + | |
PL88 | Check Printout | PL88007 | Type | NVARCHAR | 1 | — | — | + | |
PL88 | Check Printout | PL88008 | Bank Code | NVARCHAR | 10 | — | — | + | |
PL88 | Check Printout | PL88009 | Cheque Number | NVARCHAR | 7 | — | — | + | |
PL88 | Check Printout | PL88010 | Cheque Number Control Digit | NVARCHAR | 1 | — | — | + | |
PL88 | Check Printout | PL88011 | Date Emission | DATETIME | 8 | — | — | + | |
PL88 | Check Printout | PL88012 | Printed | NVARCHAR | 1 | — | — | + | |
PL88 | Check Printout | PL88013 | Cheque Series | NVARCHAR | 2 | — | — | + | |
PL95 | Russian VAT wrk | PL95002 | LineNo | NCHAR | 8 | 4 | — | ||
PL95 | Russian VAT wrk | PL95004 | InvoiceNo | NVARCHAR | 25 | 15 | — | ||
PL96 | DueDate report | PL96003 | InvoiceNo | NCHAR | 25 | 15 | — | ||
PL96 | DueDate report | PL96005 | Instalment | INT | 3 | — | — | + | |
PL97 | Ledger Statement | PL97004 | TransactioNo | NVARCHAR | 9 | 6 | — | ||
PL97 | Ledger Statement | PL97005 | InvoiceNo | NVARCHAR | 25 | 15 | — | ||
PL98 | EC Tax Reports | PL98007 | Tax Code | NCHAR | 2 | — | — | + | |
PL98 | EC Tax Reports | PL98008 | Tax name | NVARCHAR | 10 | — | — | + | |
PLA1 | PL account exceptions | PLA1001 | Account | NVARCHAR | 25 | — | — | + | |
PLA1 | PL account exceptions | PLA1002 | Exception mark | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG001 | Configuration Number | NCHAR | 8 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG002 | Horizontal Scroll | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG003 | Frozen Columns | INT | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG004 | Ready for Payment FGRW | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG005 | Ready for Payment BGRW | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG006 | Ready for Payment FGRO | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG007 | Ready for Payment BGRO | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG008 | Ready for Payment FGRO+ | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG009 | Ready for Payment BGRO+ | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG010 | Blocked for Payment FGRW | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG011 | Blocked for Payment BGRW | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG012 | Blocked for Payment FGRO | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG013 | Blocked for Payment BGRO | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG014 | Blocked for Payment FGRO+ | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG015 | Blocked for Payment BGRO+ | INT | 10 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG016 | Unused Parameter 1 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG017 | Unused Parameter 2 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG018 | Unused Parameter 3 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG019 | Unused Parameter 4 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG020 | Unused Parameter 5 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG021 | Unused Parameter 6 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG022 | Unused Parameter 7 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG023 | Unused Parameter 8 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG024 | Unused Parameter 9 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG025 | Unused Parameter 10 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG026 | Unused Parameter 11 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG027 | Unused Parameter 12 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG028 | Unused Parameter 13 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG029 | Unused Parameter 14 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG030 | Unused Parameter 15 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG031 | Unused Parameter 16 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG032 | Unused Parameter 17 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG033 | Unused Parameter 18 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG034 | Unused Parameter 19 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG035 | Unused Parameter 20 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG036 | Unused Parameter 21 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG037 | Unused Parameter 22 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG038 | Unused Parameter 23 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG039 | Unused Parameter 24 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG040 | Unused Parameter 25 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG041 | Unused Parameter 26 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG042 | Unused Parameter 27 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG043 | Unused Parameter 28 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG044 | Unused Parameter 29 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG045 | Unused Parameter 30 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG046 | Unused Parameter 31 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG047 | Unused Parameter 32 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG048 | Unused Parameter 33 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG049 | Unused Parameter 34 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG050 | Unused Parameter 35 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG051 | Unused Parameter 36 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG052 | Unused Parameter 37 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG053 | Unused Parameter 38 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG054 | Unused Parameter 39 | NCHAR | 1 | — | — | + | |
PLAG | Payment Proposal MetaData info | PLAG055 | Unused Parameter 40 | NCHAR | 1 | — | — | + | |
PLB1 | Transportation Terms | PLB1001 | Transport company code | NVARCHAR | 10 | — | — | + | |
PLB1 | Transportation Terms | PLB1002 | City Code Destination | NVARCHAR | 10 | — | — | + | |
PLB1 | Transportation Terms | PLB1003 | Delivery time | NVARCHAR | 6 | — | — | + | |
PLB1 | Transportation Terms | PLB1004 | Freight amount | NUMERIC | 20 | 8 | — | — | + |
PLB1 | Transportation Terms | PLB1005 | Comment | NVARCHAR | 12 | — | — | + | |
PLB1 | Transportation Terms | PLB1006 | City Code Departure | NVARCHAR | 10 | — | — | + | |
PLB4 | Tax note description lines | PLB4001 | SupplierCode | NVARCHAR | 10 | — | — | + | |
PLB4 | Tax note description lines | PLB4002 | InvoiceNo | NVARCHAR | 25 | — | — | + | |
PLB4 | Tax note description lines | PLB4003 | SortOrder | INT | 3 | — | — | + | |
PLB4 | Tax note description lines | PLB4004 | TNDescriptionTxt | NVARCHAR | 80 | — | — | + | |
PLBT | Blocking Template | PLBT001 | Template ID | NVARCHAR | 4 | — | — | + | |
PLBT | Blocking Template | PLBT002 | Description | NVARCHAR | 25 | — | — | + | |
PLBT | Blocking Template | PLBT003 | Blocking Flags | NVARCHAR | 30 | — | — | + | |
PLC0 | Import information from customs certificates or invoices | PLC0001 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PLC0 | Import information from customs certificates or invoices | PLC0002 | Invoice No | NVARCHAR | 25 | — | — | + | |
PLC0 | Import information from customs certificates or invoices | PLC0003 | Customs Declar No | NVARCHAR | 25 | — | — | + | |
PLC0 | Import information from customs certificates or invoices | PLC0004 | Customs Inv/Certif No | NVARCHAR | 25 | — | — | + | |
PLC0 | Import information from customs certificates or invoices | PLC0005 | Customs Value | NUMERIC | 20 | 8 | — | — | + |
PLC0 | Import information from customs certificates or invoices | PLC0006 | Registr. No | NVARCHAR | 15 | — | — | + | |
PLC0 | Import information from customs certificates or invoices | PLC0007 | Date of Decision | DATETIME | 8 | — | — | + | |
PLDA | SEPA Debtor Accounts | PLDA001 | SEPA CRT Bank Template | NCHAR | 2 | — | — | + | |
PLDA | SEPA Debtor Accounts | PLDA002 | Sub-Type | NCHAR | 2 | — | — | + | |
PLDA | SEPA Debtor Accounts | PLDA003 | Currency | NCHAR | 2 | — | — | + | |
PLDA | SEPA Debtor Accounts | PLDA004 | Type of Account | INT | 2 | — | — | + | |
PLDA | SEPA Debtor Accounts | PLDA005 | Bank Account | NVARCHAR | 34 | — | — | + | |
PLDA | SEPA Debtor Accounts | PLDA006 | PM AAS Reference | INT | 1 | — | — | + | |
PLDA | SEPA Debtor Accounts | PLDA007 | GL Account | NVARCHAR | 120 | — | — | + | |
PLDA | SEPA Debtor Accounts | PLDA008 | Stat Account | NVARCHAR | 12 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0001 | Bank Code | NCHAR | 10 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0002 | Code Ordering Party | NVARCHAR | 15 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0003 | Detail Charge | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0004 | Date File Creation | DATETIME | 8 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0005 | Date Issue | DATETIME | 8 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0006 | CCC Organization Code | NVARCHAR | 4 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0007 | CCC Branch Code | NVARCHAR | 4 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0008 | CCC Account Number | NVARCHAR | 11 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0009 | CCC Control Digits | NVARCHAR | 2 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0010 | Name Ordering Party | NVARCHAR | 36 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0011 | Address Ordering Party | NVARCHAR | 36 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0012 | Location Ordering Party | NVARCHAR | 36 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0013 | Output File Path | NVARCHAR | 200 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0014 | Bank Charges | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0015 | Payment Type | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0016 | Crossed Cheque/Promissory Note | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0017 | By Post | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0018 | Order Promissory Notes | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0019 | Payment Ledger Entry | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0020 | Group Payments | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0021 | Cheque GL Account | NVARCHAR | 12 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0022 | Promissory Note GL Account | NVARCHAR | 12 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0023 | Transfer GL Account | NVARCHAR | 12 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0024 | Output Files Counter | NVARCHAR | 6 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0025 | NumberSuffix | NVARCHAR | 6 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0026 | ID Code Cheque | NVARCHAR | 4 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0027 | ID Control Cheque | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0028 | Initial Counter Cheque | NVARCHAR | 7 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0029 | Last Print Counter Cheque | NVARCHAR | 7 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0030 | Last Counter Cheque | NVARCHAR | 7 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0031 | ID Code Promissory Note | NVARCHAR | 4 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0032 | ID Control Promissory Note | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0033 | Initial Counter Promissory Note | NVARCHAR | 7 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0034 | Last Print Counter Promissory Note | NVARCHAR | 7 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0035 | Last Counter Promissory Note | NVARCHAR | 7 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0036 | Status | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0037 | IBAN ISO Country Code | NVARCHAR | 2 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0038 | IBAN Check Digits | NVARCHAR | 2 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0039 | Spare | NVARCHAR | 4 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0040 | Spare | NVARCHAR | 10 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0041 | Cheque Layout | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0042 | Counter Cheque | NVARCHAR | 4 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0043 | Counter Promissory Note | NVARCHAR | 4 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0044 | Series Cheque | NVARCHAR | 2 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0045 | Series Promissory Note | NVARCHAR | 2 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0046 | Delete Payments Over Limit | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0047 | ID Code Postal Giro | NVARCHAR | 4 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0048 | ID Control Postal Giro | NVARCHAR | 1 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0049 | Initial Counter Postal Giro | NVARCHAR | 7 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0050 | Last Print Counter Postal Giro | NVARCHAR | 7 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0051 | Last Counter Postal Giro | NVARCHAR | 7 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0052 | Series Postal Giro | NVARCHAR | 2 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0053 | Counter Postal Giro | NVARCHAR | 4 | — | — | + | |
PLE0 | Spain Payment Parameters | PLE0054 | Wages Limit | NUMERIC | 20 | 8 | — | — | + |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3003 | Main Invoice Number | NCHAR | 25 | 15 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3010 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3011 | Transaction Number | NVARCHAR | 9 | 6 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3025 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3026 | Transaction Number Invoice | NVARCHAR | 9 | 6 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3032 | Text | NVARCHAR | 50 | 15 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3048 | Internal Reference Number | NVARCHAR | 9 | 6 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3060 | 1099 Tax Code | NVARCHAR | 8 | 3 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3086 | Original Transaction Number | NVARCHAR | 9 | 6 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3087 | Document Type | NCHAR | 3 | 2 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3095 | Invoice Number | NVARCHAR | 25 | 15 | — | ||
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3097 | Cash Method | NCHAR | 1 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3098 | WithholdTaxOriCur | NUMERIC | 20 | 8 | — | — | + |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3099 | NetInvAmntLCU | NUMERIC | 20 | 8 | — | — | + |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3100 | NetInvAmntOCU | NUMERIC | 20 | 8 | — | — | + |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3101 | Instalments | NCHAR | 1 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3102 | IssuerCode | NCHAR | 6 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3103 | IssuerExtCode | NVARCHAR | 16 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3104 | IssuerExpDate | DATETIME | 8 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3105 | POSMachine | NCHAR | 1 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3106 | TaxNoteNo | NVARCHAR | 6 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3107 | TaxNoteRegDate | DATETIME | 8 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3108 | Due Date Definition | INT | 1 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3109 | PaymentTermsCode | NCHAR | 2 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3110 | PaymentTaxLiability | NCHAR | 6 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3111 | PaymentBlockReason | INT | 3 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3112 | Broker Supplier code | NVARCHAR | 10 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3113 | Customs Declaration Number | NVARCHAR | 25 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3114 | Additional Invoice Flag | INT | 1 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3115 | Fiscal Key | NVARCHAR | 50 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3116 | Fiscal Key Protocol No | NVARCHAR | 20 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3117 | Fiscal Key Protocol Date | DATETIME | 17 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3118 | Ext. User defined 1 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3119 | Ext. User defined 2 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3120 | Ext. User defined 3 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3121 | Ext. User defined 4 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3122 | Ext. User defined 5 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3123 | Ext. User defined 6 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3124 | Ext. User defined 7 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3125 | Ext. User defined 8 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3126 | Ext. User defined 9 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3127 | Ext. User defined 10 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3128 | Ext. User defined 11 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3129 | Ext. User defined 12 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3130 | Ext. User defined 13 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3131 | Ext. User defined 14 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3132 | Ext. User defined 15 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3133 | Ext. User defined 16 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3134 | Ext. User defined 17 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3135 | Ext. User defined 18 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3136 | Ext. User defined 19 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3137 | Ext. User defined 20 | NVARCHAR | 150 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3138 | Spesometro Forms | NVARCHAR | 12 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3139 | Summary Document | NCHAR | 1 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3140 | PO3 Sub type | NCHAR | 2 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3141 | Adjustment Number | NVARCHAR | 25 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3142 | Adjustment Date | DATETIME | 8 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3143 | Adjustment Comment | NVARCHAR | 50 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3144 | Adjustment Code | NCHAR | 2 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3145 | Public Procurement Code1 | NVARCHAR | 20 | — | — | + | |
PLH3 | Recharge Invoice Accounts Payable header master file | PLH3146 | Public Procurement Code2 | NVARCHAR | 20 | — | — | + | |
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4003 | Main Invoice Number | NCHAR | 25 | 15 | — | ||
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4005 | Line Number | NCHAR | 7 | 5 | — | ||
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4008 | Transaction Number | NCHAR | 9 | 6 | — | ||
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4011 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4014 | Accounting String (Line Currency) | NVARCHAR | 120 | 50 | — | ||
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4026 | In Closing Period | NCHAR | 8 | 5 | — | ||
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4028 | Unit Code | INT | 4 | 2 | — | ||
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4031 | Internal Reference Number | NCHAR | 9 | 6 | — | ||
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4034 | Entered By | NCHAR | 8 | 6 | — | ||
PLH4 | Recharge Invoice Accounts Payable transaction lines | PLH4038 | AAS code | NVARCHAR | 25 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5001 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5002 | Invoice No | NVARCHAR | 25 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5003 | Object No | NVARCHAR | 12 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5004 | Line No | NVARCHAR | 6 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5005 | Tax Line No | NVARCHAR | 3 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5006 | Source For Inv | NVARCHAR | 1 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5007 | Line Discount LCU | NUMERIC | 20 | 8 | — | — | + |
PLH5 | Purchase Invoice Line History | PLH5008 | Net Line Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PLH5 | Purchase Invoice Line History | PLH5009 | Tax Code | NVARCHAR | 6 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5010 | Tax Type | NVARCHAR | 6 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5011 | Tax Percentage | NVARCHAR | 6 | — | — | + | |
PLH5 | Purchase Invoice Line History | PLH5012 | Base Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PLH5 | Purchase Invoice Line History | PLH5013 | Tax Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PLH5 | Purchase Invoice Line History | PLH5014 | Fixed Exchange Rate | NUMERIC | 10 | 8 | — | — | + |
PLH5 | Purchase Invoice Line History | PLH5015 | Line Discount OCU | NUMERIC | 20 | 8 | — | — | + |
PLH5 | Purchase Invoice Line History | PLH5016 | Net Line Amount OCU | NUMERIC | 20 | 8 | — | — | + |
PLH5 | Purchase Invoice Line History | PLH5017 | Base Amount OCU | NUMERIC | 20 | 8 | — | — | + |
PLH5 | Purchase Invoice Line History | PLH5018 | Tax Amount OCU | NUMERIC | 20 | 8 | — | — | + |
PLH5 | Purchase Invoice Line History | PLH5019 | Invoice Currency Code | NVARCHAR | 3 | — | — | + | |
PLH6 | Inter-Company Transaction Entry | PLH6002 | Transaction Number | NCHAR | 9 | 6 | — | ||
PLH6 | Inter-Company Transaction Entry | PLH6009 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PLH6 | Inter-Company Transaction Entry | PLH6012 | Accounting String (Line Currency) | NVARCHAR | 120 | 50 | — | ||
PLH6 | Inter-Company Transaction Entry | PLH6024 | In Closing Period | NCHAR | 8 | 5 | — | ||
PLH6 | Inter-Company Transaction Entry | PLH6026 | Unit Code | INT | 4 | 2 | — | ||
PLH6 | Inter-Company Transaction Entry | PLH6029 | Internal Reference Number | NCHAR | 9 | 6 | — | ||
PLH6 | Inter-Company Transaction Entry | PLH6036 | Transaction Number | NCHAR | 9 | 6 | — | ||
PLH7 | Entities and Amounts for current invoice(Work) | PLH7010 | Spare | NCHAR | 25 | 20 | — | ||
PLHB | Recharge Invoice Parameters — Target Company | PLHB005 | Clearing Accounting String | NVARCHAR | 120 | 50 | — | ||
PLHB | Recharge Invoice Parameters — Target Company | PLHB011 | Service Fee Account | NVARCHAR | 120 | 50 | — | ||
PLHC | Work file for entering inter-company transactions | PLHC002 | Transaction Number | NCHAR | 9 | 6 | — | ||
PLHD | Recharge Invoice Tax amount | PLHD003 | Main Invoice Number | NCHAR | 25 | 15 | — | ||
PLHE | Recharge expense amounts | PLHE003 | Main Invoice Number | NCHAR | 25 | 15 | — | ||
PLHE | Recharge expense amounts | PLHE012 | Accounting String | NVARCHAR | 120 | 50 | — | ||
PLHE | Recharge expense amounts | PLHE013 | Accounting String 2 | NVARCHAR | 120 | 50 | — | ||
PLHF | Recharge Amounts | PLHF003 | Main Invoice Number | NCHAR | 25 | 15 | — | ||
PLI1 | Payment Term Instalments PL Header | PLI1001 | PaymentTerm | NVARCHAR | 2 | — | — | + | |
PLI1 | Payment Term Instalments PL Header | PLI1002 | InstallmentType | NVARCHAR | 1 | — | — | + | |
PLI1 | Payment Term Instalments PL Header | PLI1003 | NumberOfInstalments | INT | 3 | — | — | + | |
PLI1 | Payment Term Instalments PL Header | PLI1004 | Percentage | NCHAR | 1 | — | — | + | |
PLI1 | Payment Term Instalments PL Header | PLI1005 | Interval | INT | 3 | — | — | + | |
PLI1 | Payment Term Instalments PL Header | PLI1006 | UnitInterval | NCHAR | 1 | — | — | + | |
PLI1 | Payment Term Instalments PL Header | PLI1007 | UseTotalRounding | NCHAR | 1 | — | — | + | |
PLI1 | Payment Term Instalments PL Header | PLI1008 | PaymentMethodPerInstlmnts | NCHAR | 1 | — | — | + | |
PLI2 | Payment Term Instalments PL Lines | PLI2001 | PaymentTerm | NVARCHAR | 2 | — | — | + | |
PLI2 | Payment Term Instalments PL Lines | PLI2002 | InstallmentNumber | INT | 3 | — | — | + | |
PLI2 | Payment Term Instalments PL Lines | PLI2003 | DateCalculation | INT | 3 | — | — | + | |
PLI2 | Payment Term Instalments PL Lines | PLI2004 | Percentage% | NVARCHAR | 6 | — | — | + | |
PLI2 | Payment Term Instalments PL Lines | PLI2005 | PaymentMethod | NVARCHAR | 2 | — | — | + | |
PLI2 | Payment Term Instalments PL Lines | PLI2006 | Description | NVARCHAR | 25 | — | — | + | |
PLI3 | Payment Term Instalments PL | PLI3001 | SupplierCode | NVARCHAR | 10 | — | — | + | |
PLI3 | Payment Term Instalments PL | PLI3002 | InvoiceNo | NVARCHAR | 25 | — | — | + | |
PLI3 | Payment Term Instalments PL | PLI3003 | InstalmentNumber | INT | 3 | — | — | + | |
PLI3 | Payment Term Instalments PL | PLI3004 | DueDate | DATETIME | 8 | — | — | + | |
PLI3 | Payment Term Instalments PL | PLI3005 | InvAmoLocCur | NUMERIC | 20 | 8 | — | — | + |
PLI3 | Payment Term Instalments PL | PLI3006 | InvAmoOriCur | NUMERIC | 20 | 8 | — | — | + |
PLI3 | Payment Term Instalments PL | PLI3007 | PaidAmountLCU | NUMERIC | 20 | 8 | — | — | + |
PLI3 | Payment Term Instalments PL | PLI3008 | PaidAmountORG | NUMERIC | 20 | 8 | — | — | + |
PLI3 | Payment Term Instalments PL | PLI3009 | LastPaymentDate | DATETIME | 8 | — | — | + | |
PLI3 | Payment Term Instalments PL | PLI3010 | PaymentMethod | NVARCHAR | 2 | — | — | + | |
PLI3 | Payment Term Instalments PL | PLI3011 | Instalment Type | INT | 1 | — | — | + | |
PLI3 | Payment Term Instalments PL | PLI3012 | Original instalment number | NCHAR | 3 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN001 | Supplier Code | NCHAR | 10 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN002 | Invoice Number | NCHAR | 25 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN003 | Statistical Code | NVARCHAR | 14 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN004 | Amount LCU | NUMERIC | 20 | 8 | — | — | + |
PLIN | Invoice Based Intrastat PL | PLIN005 | Nature of Transaction | NCHAR | 2 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN006 | Purchase Order | NCHAR | 10 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN007 | Volume Net | NUMERIC | 10 | 8 | — | — | + |
PLIN | Invoice Based Intrastat PL | PLIN008 | Supplementary Units QTY or Description | NCHAR | 10 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN009 | Statistical Value | NUMERIC | 20 | 8 | — | — | + |
PLIN | Invoice Based Intrastat PL | PLIN010 | Regime | NCHAR | 2 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN011 | Transport Method | NCHAR | 2 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN012 | Country of Nature | NCHAR | 3 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN013 | Country of Origin | NCHAR | 3 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN014 | Country of Destination | NCHAR | 3 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN015 | Period Reference | NCHAR | 2 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN016 | Year Reference | NCHAR | 4 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN017 | Amount OCU | NUMERIC | 20 | 8 | — | — | + |
PLIN | Invoice Based Intrastat PL | PLIN018 | Original Currency Code | INT | 2 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN019 | Transaction Date | DATETIME | 8 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN020 | Line Number | INT | 3 | — | — | + | |
PLIN | Invoice Based Intrastat PL | PLIN021 | Tax Registration Country | NCHAR | 3 | — | — | + | |
PLL3 | Payment Proposal Retentions | PLL3002 | Invoice Number | NCHAR | 25 | 15 | — | ||
PLM0 | Mandate | PLM0001 | Mandate Reference | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0002 | Debtor Code | NVARCHAR | 10 | — | — | + | |
PLM0 | Mandate | PLM0003 | Debtor Name | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0004 | Debtor Address Line 1 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0005 | Debtor Address Line 2 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0006 | Debtor Address Line 3 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0007 | Debtor Address Line 4 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0008 | Debtor Address Line 5 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0009 | Debtor Address Line 6 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0010 | Debtor Address Line 7 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0011 | Debtor Country Code | NCHAR | 3 | — | — | + | |
PLM0 | Mandate | PLM0012 | Debtor Identification Code | NVARCHAR | 25 | — | — | + | |
PLM0 | Mandate | PLM0013 | Debtor Reference Name | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0014 | Debtor Identification of Reference Part | NVARCHAR | 25 | — | — | + | |
PLM0 | Mandate | PLM0015 | Debtor IBAN Account | NVARCHAR | 34 | — | — | + | |
PLM0 | Mandate | PLM0016 | Underlying Contract ID | NVARCHAR | 25 | — | — | + | |
PLM0 | Mandate | PLM0017 | Debtor Bank BIC Code | NVARCHAR | 15 | — | — | + | |
PLM0 | Mandate | PLM0018 | Creditor Identification Code | NVARCHAR | 25 | — | — | + | |
PLM0 | Mandate | PLM0019 | Creditor Name | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0020 | Creditor Reference Name | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0021 | Creditor Identification of Reference Part | NVARCHAR | 25 | — | — | + | |
PLM0 | Mandate | PLM0022 | Creditor Address line 1 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0023 | Creditor Address line 2 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0024 | Creditor Address line 3 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0025 | Creditor Address line 4 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0026 | Creditor Address line 5 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0027 | Creditor Address line 6 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0028 | Creditor Address line 7 | NVARCHAR | 35 | — | — | + | |
PLM0 | Mandate | PLM0029 | Creditor Country Code | NCHAR | 3 | — | — | + | |
PLM0 | Mandate | PLM0030 | Signed Place | NVARCHAR | 50 | — | — | + | |
PLM0 | Mandate | PLM0031 | Signed by | NVARCHAR | 100 | — | — | + | |
PLM0 | Mandate | PLM0032 | Signed Date | DATETIME | 8 | — | — | + | |
PLM0 | Mandate | PLM0033 | E-signature | NVARCHAR | 256 | — | — | + | |
PLM0 | Mandate | PLM0034 | Type of Payment | NCHAR | 1 | — | — | + | |
PLM0 | Mandate | PLM0035 | Valid from Date | DATETIME | 8 | — | — | + | |
PLM0 | Mandate | PLM0036 | Valid to Date | DATETIME | 8 | — | — | + | |
PLM0 | Mandate | PLM0037 | Record type | NCHAR | 1 | — | — | + | |
PLM0 | Mandate | PLM0038 | Special Comment 1 | NVARCHAR | 80 | — | — | + | |
PLM0 | Mandate | PLM0039 | Special Comment 2 | NVARCHAR | 80 | — | — | + | |
PLM0 | Mandate | PLM0040 | Special Comment 3 | NVARCHAR | 80 | — | — | + | |
PLM0 | Mandate | PLM0041 | Contract Description | NVARCHAR | 80 | — | — | + | |
PLM0 | Mandate | PLM0042 | Version number | NVARCHAR | 10 | — | — | + | |
PLM0 | Mandate | PLM0043 | Document Language | NCHAR | 3 | — | — | + | |
PLM0 | Mandate | PLM0044 | Proposal created by | NVARCHAR | 8 | — | — | + | |
PLM0 | Mandate | PLM0045 | Proposal created date | DATETIME | 8 | — | — | + | |
PLM0 | Mandate | PLM0046 | Proposal printed by | NVARCHAR | 8 | — | — | + | |
PLM0 | Mandate | PLM0047 | Proposal printed date | DATETIME | 8 | — | — | + | |
PLM0 | Mandate | PLM0048 | Mandate created by | NVARCHAR | 8 | — | — | + | |
PLM0 | Mandate | PLM0049 | Mandate created date | DATETIME | 8 | — | — | + | |
PLM0 | Mandate | PLM0050 | Mandate printed by | NVARCHAR | 8 | — | — | + | |
PLM0 | Mandate | PLM0051 | Mandate printed date | DATETIME | 8 | — | — | + | |
PLM0 | Mandate | PLM0052 | Priority | INT | 2 | — | — | + | |
PLM0 | Mandate | PLM0053 | Supplier | NVARCHAR | 10 | — | — | + | |
PLM0 | Mandate | PLM0054 | Debtor Post Code | NVARCHAR | 10 | — | — | + | |
PLM0 | Mandate | PLM0055 | Debtor City Code | NVARCHAR | 10 | — | — | + | |
PLM0 | Mandate | PLM0056 | Creditor Post Code | NVARCHAR | 10 | — | — | + | |
PLM0 | Mandate | PLM0057 | Creditor City Code | NVARCHAR | 10 | — | — | + | |
PLM0 | Mandate | PLM0058 | Creditor Bank Code | NCHAR | 2 | — | — | + | |
PLM5 | Bank Account Number for Currency Code | PLM5001 | Currency Code | NCHAR | 2 | — | — | + | |
PLM5 | Bank Account Number for Currency Code | PLM5002 | Bank Account Number | NCHAR | 34 | — | — | + | |
PLM5 | Bank Account Number for Currency Code | PLM5003 | Spare | NCHAR | 30 | — | — | + | |
PLM5 | Bank Account Number for Currency Code | PLM5004 | Text | NCHAR | 50 | — | — | + | |
PLMH | Mandate history | PLMH001 | Mandate Reference | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH002 | Debtor Code | NVARCHAR | 10 | — | — | + | |
PLMH | Mandate history | PLMH003 | Debtor name | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH004 | Debtor Address line 1 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH005 | Debtor Address line 2 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH006 | Debtor Address line 3 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH007 | Debtor Address line 4 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH008 | Debtor Address line 5 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH009 | Debtor Address line 6 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH010 | Debtor Address line 7 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH011 | Debtor Country Code | NCHAR | 3 | — | — | + | |
PLMH | Mandate history | PLMH012 | Debtor ID | NVARCHAR | 25 | — | — | + | |
PLMH | Mandate history | PLMH013 | Debtor Reference name | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH014 | Debtor Reference ID | NVARCHAR | 25 | — | — | + | |
PLMH | Mandate history | PLMH015 | Debtor IBAN account | NVARCHAR | 34 | — | — | + | |
PLMH | Mandate history | PLMH016 | Underlying Contract ID | NVARCHAR | 25 | — | — | + | |
PLMH | Mandate history | PLMH017 | Debtor Bank BIC code | NVARCHAR | 15 | — | — | + | |
PLMH | Mandate history | PLMH018 | Creditor ID | NVARCHAR | 25 | — | — | + | |
PLMH | Mandate history | PLMH019 | Creditor name | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH020 | Creditor Reference name | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH021 | Creditor Reference ID | NVARCHAR | 25 | — | — | + | |
PLMH | Mandate history | PLMH022 | Creditor Address line 1 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH023 | Creditor Address line 2 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH024 | Creditor Address line 3 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH025 | Creditor Address line 4 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH026 | Creditor Address line 5 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH027 | Creditor Address line 6 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH028 | Creditor Address line 7 | NVARCHAR | 35 | — | — | + | |
PLMH | Mandate history | PLMH029 | Creditor Country Code | NCHAR | 3 | — | — | + | |
PLMH | Mandate history | PLMH030 | Signed place | NVARCHAR | 50 | — | — | + | |
PLMH | Mandate history | PLMH031 | Signed by | NVARCHAR | 100 | — | — | + | |
PLMH | Mandate history | PLMH032 | Signed date | DATETIME | 8 | — | — | + | |
PLMH | Mandate history | PLMH033 | E-signature | NVARCHAR | 256 | — | — | + | |
PLMH | Mandate history | PLMH034 | Type of payment | NCHAR | 1 | — | — | + | |
PLMH | Mandate history | PLMH035 | Valid from date | DATETIME | 8 | — | — | + | |
PLMH | Mandate history | PLMH036 | Valid up to date | DATETIME | 8 | — | — | + | |
PLMH | Mandate history | PLMH037 | Record Type | NCHAR | 1 | — | — | + | |
PLMH | Mandate history | PLMH038 | Special Comment 1 | NVARCHAR | 80 | — | — | + | |
PLMH | Mandate history | PLMH039 | Special Comment 2 | NVARCHAR | 80 | — | — | + | |
PLMH | Mandate history | PLMH040 | Special Comment 3 | NVARCHAR | 80 | — | — | + | |
PLMH | Mandate history | PLMH041 | Contract description | NVARCHAR | 80 | — | — | + | |
PLMH | Mandate history | PLMH042 | Version Number | NVARCHAR | 10 | — | — | + | |
PLMH | Mandate history | PLMH043 | Document language | NCHAR | 3 | — | — | + | |
PLMH | Mandate history | PLMH044 | Proposal created by | NVARCHAR | 8 | — | — | + | |
PLMH | Mandate history | PLMH045 | Proposal created | DATETIME | 8 | — | — | + | |
PLMH | Mandate history | PLMH046 | Proposal printed by | NVARCHAR | 8 | — | — | + | |
PLMH | Mandate history | PLMH047 | Proposal printed | DATETIME | 8 | — | — | + | |
PLMH | Mandate history | PLMH048 | Mandate created by | NVARCHAR | 8 | — | — | + | |
PLMH | Mandate history | PLMH049 | Mandate created | DATETIME | 8 | — | — | + | |
PLMH | Mandate history | PLMH050 | Mandate printed by | NVARCHAR | 8 | — | — | + | |
PLMH | Mandate history | PLMH051 | Mandate printed | DATETIME | 8 | — | — | + | |
PLMH | Mandate history | PLMH052 | Priority | INT | 2 | — | — | + | |
PLMH | Mandate history | PLMH053 | Supplier | NVARCHAR | 10 | — | — | + | |
PLMH | Mandate history | PLMH054 | Debtor Zip-Code | NVARCHAR | 10 | — | — | + | |
PLMH | Mandate history | PLMH055 | Debtor City Code | NVARCHAR | 10 | — | — | + | |
PLMH | Mandate history | PLMH056 | Creditor Zip-Code | NVARCHAR | 10 | — | — | + | |
PLMH | Mandate history | PLMH057 | Creditor City Code | NVARCHAR | 10 | — | — | + | |
PLMH | Mandate history | PLMH058 | Reason code change | NCHAR | 2 | — | — | + | |
PLMH | Mandate history | PLMH059 | Mandate changed by | NVARCHAR | 8 | — | — | + | |
PLMH | Mandate history | PLMH060 | Mandate changed | DATETIME | 8 | — | — | + | |
PLMH | Mandate history | PLMH061 | Reason code delete | NCHAR | 2 | — | — | + | |
PLMH | Mandate history | PLMH062 | Mandate deleted by | NVARCHAR | 8 | — | — | + | |
PLMH | Mandate history | PLMH063 | Mandate deleted | DATETIME | 8 | — | — | + | |
PLMH | Mandate history | PLMH064 | Creditor Bank code | NCHAR | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU001 | P.K. | NCHAR | 10 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU002 | Due Date Adjust 1 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU003 | Due Date Adjust 2 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU004 | Due Date Adjust 3 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU005 | Due Date Adjust 4 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU006 | Due Date Adjust 5 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU007 | Due Date Adjust 6 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU008 | Due Date Adjust 7 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU009 | Due Date Adjust 8 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU010 | Due Date Adjust 9 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU011 | Due Date Adjust 10 | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU012 | Payment Date | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU013 | Max Amount | NUMERIC | 20 | 8 | — | — | + |
PLPU | Payment Proposal unique parameters | PLPU014 | Payment Method | NCHAR | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU015 | Alt. Payment Method | NCHAR | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU016 | Supplier min | NVARCHAR | 10 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU017 | Supplier max | NVARCHAR | 10 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU018 | Category min | NCHAR | 4 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU019 | Category max | NCHAR | 4 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU020 | Currency min | NCHAR | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU021 | Currency max | NCHAR | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU022 | accounting string | NVARCHAR | 120 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU023 | accounting string | NVARCHAR | 120 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU024 | Debit sum | NUMERIC | 20 | 8 | — | — | + |
PLPU | Payment Proposal unique parameters | PLPU025 | Selected Due Date | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU026 | Sunday Payment | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU027 | Saturday Payment | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU028 | Direct use of Credit | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU029 | No Pay Date 1 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU030 | No Pay Date 2 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU031 | No Pay Date 3 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU032 | No Pay Date 4 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU033 | No Pay Date 5 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU034 | No Pay Date 6 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU035 | No Pay Date 7 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU036 | No Pay Date 8 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU037 | No Pay Date 9 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU038 | No Pay Date 10 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU039 | No Pay Date 11 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU040 | No Pay Date 12 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU041 | No Pay Date 13 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU042 | No Pay Date 14 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU043 | No Pay Date 15 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU044 | No Pay Date 16 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU045 | No Pay Date 17 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU046 | No Pay Date 18 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU047 | No Pay Date 19 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU048 | No Pay Date 20 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU049 | No Pay Date 21 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU050 | No Pay Date 22 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU051 | No Pay Date 23 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU052 | No Pay Date 24 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU053 | No Pay Date 25 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU054 | No Pay Date 26 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU055 | No Pay Date 27 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU056 | No Pay Date 28 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU057 | No Pay Date 29 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU058 | No Pay Date 30 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU059 | No Pay Date 31 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU060 | No Pay Date 32 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU061 | No Pay Date 33 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU062 | No Pay Date 34 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU063 | No Pay Date 35 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU064 | No Pay Date 36 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU065 | No Pay Date 37 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU066 | No Pay Date 38 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU067 | No Pay Date 39 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU068 | No Pay Date 40 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU069 | No Pay Date 41 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU070 | No Pay Date 42 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU071 | No Pay Date 43 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU072 | No Pay Date 44 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU073 | No Pay Date 45 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU074 | No Pay Date 46 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU075 | No Pay Date 47 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU076 | No Pay Date 48 | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU077 | Use SL Credits | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU078 | Allow negative balance | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU079 | Credit sum | NUMERIC | 20 | 8 | — | — | + |
PLPU | Payment Proposal unique parameters | PLPU080 | Use Other Currency | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU081 | Payment Currency | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU082 | Book Date | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU083 | Due Date Credit | DATETIME | 8 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU084 | Journal Code | NCHAR | 6 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU085 | Trans in Close | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU086 | swiss | NVARCHAR | 10 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU087 | Check PM Balance | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU088 | Defer. of Payment | INT | 3 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU089 | Priority 1 | INT | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU090 | Priority 2 | INT | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU091 | Priority 3 | INT | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU092 | Priority 4 | INT | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU093 | Priority 5 | INT | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU094 | Priority 6 | INT | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU095 | Priority 7 | INT | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU096 | Priority 8 | INT | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU097 | Priority 9 | INT | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU098 | Payment Currency 2 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU099 | Payment Currency Sub-type 1 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU100 | Payment Currency Sub-type 2 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU101 | Payment Currency Sub-type 3 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU102 | Payment Currency Sub-type 4 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU103 | Payment Currency Sub-type 5 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU104 | Payment Currency Sub-type 6 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU105 | Payment Currency Sub-type 7 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU106 | Payment Currency Sub-type 8 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU107 | Payment Currency Sub-type 9 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU108 | Payment Currency Sub-type 10 | NCHAR | 1 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU109 | Currency Code Sub-type 1 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU110 | Currency Code Sub-type 2 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU111 | Currency Code Sub-type 3 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU112 | Currency Code Sub-type 4 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU113 | Currency Code Sub-type 5 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU114 | Currency Code Sub-type 6 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU115 | Currency Code Sub-type 7 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU116 | Currency Code Sub-type 8 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU117 | Currency Code Sub-type 9 | INT | 2 | — | — | + | |
PLPU | Payment Proposal unique parameters | PLPU118 | Currency Code Sub-type 10 | INT | 2 | — | — | + | |
PLR4 | PL Reversed Transaction | PLR4001 | Original Transaction Number | NCHAR | 9 | — | — | + | |
PLR4 | PL Reversed Transaction | PLR4002 | Reversed Transaction Number | NCHAR | 9 | — | — | + | |
PLR4 | PL Reversed Transaction | PLR4003 | Journal Number Original Transaction | NVARCHAR | 9 | — | — | + | |
PLR4 | PL Reversed Transaction | PLR4004 | Journal Number Reversed Transaction | NVARCHAR | 9 | — | — | + | |
PLRE | Additional group status reason data | PLRE001 | OrigMesId | NVARCHAR | 35 | — | — | + | |
PLRE | Additional group status reason data | PLRE002 | GrResonLineN | INT | 3 | — | — | + | |
PLRE | Additional group status reason data | PLRE003 | GrStatReasonAddInfo | NVARCHAR | 105 | — | — | + | |
PLS0 | SEPA Instalment – Bank account | PLS0001 | Supplier | NVARCHAR | 10 | — | — | + | |
PLS0 | SEPA Instalment – Bank account | PLS0002 | Bank Code | NCHAR | 2 | — | — | + | |
PLS0 | SEPA Instalment – Bank account | PLS0003 | Payment Term | NCHAR | 2 | — | — | + | |
PLS0 | SEPA Instalment – Bank account | PLS0004 | Instalment No | NCHAR | 3 | — | — | + | |
PLS0 | SEPA Instalment – Bank account | PLS0005 | Bank Account | NVARCHAR | 34 | — | — | + | |
PLS0 | SEPA Instalment – Bank account | PLS0006 | Tax Bank Account | NVARCHAR | 34 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE001 | Supplier Code | NCHAR | 10 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE002 | Invoice No | NCHAR | 25 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE003 | Payment Block | NCHAR | 1 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE004 | AmountPaidInvCur | NUMERIC | 20 | 8 | — | — | + |
PLSE | SEPA CRT payments and receipts | PLSE005 | DiscountAmountInvCur | NUMERIC | 20 | 8 | — | — | + |
PLSE | SEPA CRT payments and receipts | PLSE006 | CalcuDueDate | DATETIME | 8 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE007 | WHTaxAmountInvCur | NUMERIC | 20 | 8 | — | — | + |
PLSE | SEPA CRT payments and receipts | PLSE008 | Code | NCHAR | 8 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE009 | WayOfPayment | NCHAR | 2 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE010 | AmoPaidPaymentCurr | NUMERIC | 20 | 8 | — | — | + |
PLSE | SEPA CRT payments and receipts | PLSE011 | DscAmoPaymentCurr | NUMERIC | 20 | 8 | — | — | + |
PLSE | SEPA CRT payments and receipts | PLSE012 | WHoldTaxPayCurrency | NUMERIC | 20 | 8 | — | — | + |
PLSE | SEPA CRT payments and receipts | PLSE013 | PaymentCurrencyCode | INT | 2 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE014 | ExchangeRate1 | NUMERIC | 10 | 8 | — | — | + |
PLSE | SEPA CRT payments and receipts | PLSE015 | ExchangeRate2 | NUMERIC | 10 | 8 | — | — | + |
PLSE | SEPA CRT payments and receipts | PLSE016 | ExchnageAlgorithm | NCHAR | 3 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE017 | PaymentDetails | NVARCHAR | 50 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE018 | INstallmentNumber | INT | 3 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE019 | Payment order number | NVARCHAR | 6 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE020 | Cheque number | NVARCHAR | 6 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE021 | Payment order approved | NCHAR | 1 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE022 | Debtor Account | NVARCHAR | 34 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE023 | Spare | NVARCHAR | 30 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE024 | Invoice Currency Code | NCHAR | 2 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE025 | Bank account currency code | NCHAR | 2 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE026 | Payment Detail ID | NVARCHAR | 10 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE027 | Payment Tax Liability Code | NCHAR | 6 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE028 | OrigMesID | NVARCHAR | 35 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE029 | OrigCreDtTm | DATETIME | 17 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE030 | OrigEndToEndId | NVARCHAR | 35 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE031 | StepStatus | INT | 1 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE032 | Group Status | NCHAR | 4 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE033 | GrStatusReasonCd | NCHAR | 4 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE034 | GrStatusReasonTxt | NVARCHAR | 35 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE035 | TransStatus | NCHAR | 4 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE036 | TrStatusReasonCd | NCHAR | 4 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE037 | TrStatusReasonTxt | NVARCHAR | 35 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE038 | ConversToPaymCur | NCHAR | 1 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE039 | Payment Proposal | NCHAR | 10 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE040 | Charge Bearer | NVARCHAR | 4 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE041 | Payment ID | NVARCHAR | 35 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE042 | Debtor Account Type | INT | 2 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE043 | Sub-Type | NCHAR | 2 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE044 | BIC — Creditor Account’s Bank | NVARCHAR | 11 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE045 | Creditor Account | NVARCHAR | 35 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE046 | Creditor Account Type | NCHAR | 2 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE047 | Payment Priority | INT | 1 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE048 | Central Bank Code | NCHAR | 4 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE049 | Invoice Comment | NVARCHAR | 50 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE050 | Clearing System ID – Creditor Bank | NCHAR | 5 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE051 | Clearing Member ID – Creditor Bank | NVARCHAR | 35 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE052 | Credit Split Status | INT | 1 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE053 | PM AAS Reference | INT | 1 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE054 | GL Account | NVARCHAR | 120 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE055 | Alt Grouping 1 | NVARCHAR | 10 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE056 | Alt Grouping 2 | NVARCHAR | 10 | — | — | + | |
PLSE | SEPA CRT payments and receipts | PLSE057 | Original instalment number | NCHAR | 3 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG001 | SEPA CRT Bank Template | NCHAR | 2 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG002 | Sub-Type | NCHAR | 2 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG003 | Max Number (Cr.Gr) | INT | 3 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG004 | Min Coin (Cr.Gr.) | NCHAR | 1 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG005 | One Invoice – N Credits (Cr.Gr.) | INT | 1 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG006 | One Credit – N Invoices (Cr.Gr.) | INT | 1 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG007 | Split Credit (Cr.Gr.) | NCHAR | 1 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG008 | Merge (Cr.Gr.) | NCHAR | 1 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG009 | Fill Group (Cr.Gr.) | NCHAR | 1 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG010 | Max Number (In.Gr.) | INT | 3 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG011 | Only Without Ref. (In.Gr.) | NCHAR | 1 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG012 | Property 1 | NCHAR | 1 | — | — | + | |
PLSG | SEPA Grouping Parameters | PLSG013 | Property 2 | NCHAR | 1 | — | — | + | |
PLT7 | Temp Tax table for autopayments | PLT7001 | Invoice Number | NVARCHAR | 25 | — | — | + | |
PLT7 | Temp Tax table for autopayments | PLT7002 | Supplier Code | NVARCHAR | 10 | — | — | + | |
PLT7 | Temp Tax table for autopayments | PLT7003 | Line type | NVARCHAR | 1 | — | — | + | |
PLT7 | Temp Tax table for autopayments | PLT7004 | Line number | NVARCHAR | 15 | — | — | + | |
PLT7 | Temp Tax table for autopayments | PLT7005 | Tax type | NVARCHAR | 6 | — | — | + | |
PLT7 | Temp Tax table for autopayments | PLT7006 | Base Amount | NUMERIC | 20 | 8 | — | — | + |
PLT7 | Temp Tax table for autopayments | PLT7007 | Tax Amount | NUMERIC | 20 | 8 | — | — | + |
PLT7 | Temp Tax table for autopayments | PLT7008 | Rate code | NVARCHAR | 2 | — | — | + | |
PLT7 | Temp Tax table for autopayments | PLT7009 | Rate percent | NUMERIC | 12 | 8 | — | — | + |
PLT7 | Temp Tax table for autopayments | PLT7010 | Installment number | INT | 3 | — | — | + | |
PLT7 | Temp Tax table for autopayments | PLT7011 | AdjustedTax | NCHAR | 1 | — | — | + | |
PLT7 | Temp Tax table for autopayments | PLT7012 | Actual Tax Base | NUMERIC | 20 | 8 | — | — | + |
PLT7 | Temp Tax table for autopayments | PLT7013 | Actual Tax Rate | NUMERIC | 12 | 8 | — | — | + |
PLTC | Work File for Printing Tax Certificate | PLTC001 | InvoiceNo | NVARCHAR | 25 | 15 | — | ||
PLTE | Additional transaction status reason data | PLTE001 | OrigMesId | NVARCHAR | 35 | — | — | + | |
PLTE | Additional transaction status reason data | PLTE002 | OrigEndToEndId | NVARCHAR | 35 | — | — | + | |
PLTE | Additional transaction status reason data | PLTE003 | TrResonLineN | INT | 3 | — | — | + | |
PLTE | Additional transaction status reason data | PLTE004 | TrStatReasonAddInfo | NVARCHAR | 105 | — | — | + | |
PLXX | PLXX Work File | PLXX002 | InvoiceNo | NVARCHAR | 25 | 15 | — | ||
PLXX | PLXX Work File | PLXX003 | PaymentNo | NVARCHAR | 7 | 3 | — | ||
PLXX | PLXX Work File | PLXX004 | wotra | NVARCHAR | 9 | 6 | — |
Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
На один уровень вверх / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2