| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| PayMethCod |
Payment Method Code |
nVarChar |
15 |
- |
|
|
|
| Descript |
Description |
nVarChar |
100 |
- |
|
|
|
| Type |
Type |
VarChar |
1 |
- |
|
O |
Outgoing |
| |
|
|
|
|
|
I |
Incoming |
| BankTransf |
Payment Means |
VarChar |
1 |
- |
|
C |
Check |
| |
|
|
|
|
|
T |
Bank Transfer |
| |
|
|
|
|
|
B |
Bill of Exchange |
| Address |
Check Address |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BankDet |
Check Bank Details |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CllctAutor |
Check Collection Authorization |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FrgnPmntBl |
Block Foreign Payment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FrgnBnkBl |
Block Foreign Bank |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CurrRestr |
Currency Restriction |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PostOffBnk |
Post Office Bank |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MinAmount |
Minimum Amount |
Num |
19.6 |
- |
|
|
|
| MaxAmount |
Maximum Amount |
Num |
19.6 |
- |
|
|
|
| BnkDflt |
Default Bank |
nVarChar |
30 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| BankCountr |
Bank Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| DflAccount |
Default Bank Account |
nVarChar |
50 |
- |
|
|
|
| GLAccount |
G/L Account |
nVarChar |
15 |
OACT |
|
|
|
| Branch |
Bank Branch |
nVarChar |
50 |
- |
|
|
|
| KeyCode |
Key Code |
nVarChar |
6 |
- |
|
|
|
| TrnsType |
Transaction Type |
nVarChar |
2 |
- |
|
|
|
| Format |
File Format |
nVarChar |
11 |
OFRM |
|
|
|
| AgtCollect |
Agent Collection |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SendAccept |
Send for Acceptance |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| GrpByDate |
Group By Date |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DepNorm |
Deposit Norm |
nVarChar |
8 |
- |
|
|
|
| DebitMemo |
Debit Memo |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| GroupPmRef |
Group by Payment Reference No. |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| GroupInv |
Group Invoices by Pay |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| ValDateSel |
Due Date Selection |
VarChar |
1 |
- |
P |
P |
Date of Payment Run |
| |
|
|
|
|
|
I |
Due Date of Invoice |
| |
|
|
|
|
|
T |
Payment Terms |
| PaymTerms |
Payment Terms Code |
Int |
6 |
OCTG |
|
|
|
| IntrimAcct |
Post to G/L Interim Account |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| BnkActKey |
Bank Account Key |
Int |
11 |
DSC1 |
|
|
|
| DocType |
BoE Document Type |
nVarChar |
2 |
- |
|
|
|
| Accepted |
BoE Status - Accepted |
VarChar |
1 |
- |
|
|
|
| PtfID |
BoE Internal Portfolio ID |
nVarChar |
3 |
- |
|
|
|
| PtfCode |
BoE Portfolio Code |
nVarChar |
2 |
- |
|
|
|
| PtfNum |
BoE Portfolio Number |
nVarChar |
4 |
- |
|
|
|
| CurCode |
BoE Currency Code |
nVarChar |
2 |
- |
|
|
|
| Instruct1 |
BoE Instruction 1 |
nVarChar |
2 |
- |
|
|
|
| Instruct2 |
BoE Instruction 2 |
nVarChar |
2 |
- |
|
|
|
| PaymntPlc |
BoE Payment Place |
nVarChar |
128 |
- |
|
|
|
| BoeDll |
Bar Code DLL |
nVarChar |
50 |
- |
|
|
|
| BankCtlKey |
Bank Control No. |
nVarChar |
2 |
- |
|
|
|
| Active |
Status of the Payment Method |
VarChar |
1 |
- |
Y |
Y |
Active |
| |
|
|
|
|
|
N |
Inactive |
| BcgPcnt |
Bank Charge Rate (%) |
Num |
19.6 |
- |
|
|
|
| GrpByCur |
Group Invoices by Currency |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| GrpByBank |
Group Invoices by Pay-To Bank |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DflIBAN |
Bank IBAN |
nVarChar |
50 |
- |
|
|
|
| DflSwift |
Bank BIC/SWIFT |
nVarChar |
50 |
- |
|
|
|
| BoeReport |
BoE Report Code |
nVarChar |
8 |
- |
|
|
|
| CancInstr |
Cancellation Instruction |
nVarChar |
2 |
- |
|
|
|
| OccurCode |
Occurrence Code |
nVarChar |
2 |
- |
|
|
|
| MovmntCode |
Movement Code |
nVarChar |
10 |
- |
|
|
|
| NegPymCode |
Negative Payment Method Code |
nVarChar |
15 |
OPYM |
|
|
|
| DirectDbt |
Direct Debit |
nVarChar |
5 |
- |
|
|
|
| |
|
|
|
|
|
CORE |
|
| |
|
|
|
|
|
B2B |
|
| |
|
|
|
|
|
COR1 |
|
| IssueIndic |
Issue Indicator |
VarChar |
1 |
- |
R |
3 |
|
| |
|
|
|
|
|
R |
|
| PrintSEPA |
Print SEPA Prenotification |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PmntType |
Payment Type |
nVarChar |
50 |
- |
01 |
01 |
Efectivo |
| |
|
|
|
|
|
02 |
Cheque nominativo |
| |
|
|
|
|
|
03 |
Transferencia electr�nica de fondos |
| |
|
|
|
|
|
04 |
Tarjeta de cr�dito |
| |
|
|
|
|
|
05 |
Monedero electr�nico |
| |
|
|
|
|
|
06 |
Dinero electr�nico |
| |
|
|
|
|
|
08 |
Vales de despensa |
| |
|
|
|
|
|
12 |
Daci�n en pago |
| |
|
|
|
|
|
13 |
Pago por subrogaci�n |
| |
|
|
|
|
|
14 |
Pago por consignaci�n |
| |
|
|
|
|
|
15 |
Condonaci�n |
| |
|
|
|
|
|
17 |
Compensaci�n |
| |
|
|
|
|
|
23 |
Novaci�n |
| |
|
|
|
|
|
24 |
Confusi�n |
| |
|
|
|
|
|
25 |
Remisi�n de deuda |
| |
|
|
|
|
|
26 |
Prescripci�n o caducidad |
| |
|
|
|
|
|
27 |
A satisfacci�n del acreedor |
| |
|
|
|
|
|
28 |
Tarjeta de d�bito |
| |
|
|
|
|
|
29 |
Tarjeta de servicios |
| |
|
|
|
|
|
30 |
Aplicaci�n de anticipos |
| |
|
|
|
|
|
31 |
Intermediario pagos |
| |
|
|
|
|
|
99 |
Por definir |
| GrpByAgrNo |
Group Blanket Agreement |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SpltPmtVAT |
Split Payments for VAT |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EnDflAcct |
Encryption of Default Bank Account |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|