One level Up / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2

Изменения структуры таблиц модуля «Книга Закупок» / Purchase Ledger tables structure changes

Название Таблицы / 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