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