| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| Code |
Code |
nVarChar |
3 |
- |
|
|
|
| Name |
Name |
nVarChar |
100 |
- |
|
|
|
| AddrFormat |
Address Format |
Int |
6 |
OADF |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| IsEC |
EU |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ReportCode |
Code for Reports |
nVarChar |
3 |
- |
|
|
|
| TaxIdDigts |
No. of Digits for Tax ID |
Int |
6 |
- |
|
|
|
| BnkCodDgts |
No. of Digits for Bank Code |
Int |
11 |
- |
|
|
|
| BnkBchDgts |
No. of Digits for Branch |
Int |
11 |
- |
|
|
|
| BnkActDgts |
No. of Digits for Account No. |
Int |
11 |
- |
|
|
|
| BnkCtKDgts |
No. of Digits for Control No. |
Int |
11 |
- |
|
|
|
| ValDomAcct |
Domestic Bank Acct. Validation |
nVarChar |
3 |
- |
XX |
XX |
|
| |
|
|
|
|
|
BE |
Belgium |
| |
|
|
|
|
|
ES |
Spain |
| |
|
|
|
|
|
FR |
France |
| |
|
|
|
|
|
IT |
Italy |
| |
|
|
|
|
|
NL |
Netherlands |
| |
|
|
|
|
|
PT |
Portugal |
| ValIban |
IBAN Validation |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IsBlackLst |
On Black List |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UICCode |
UIC Country Code |
nVarChar |
3 |
- |
|
|
|
| CntCodNum |
Country/Region Code Number |
nVarChar |
4 |
- |
|
|
|
| Siscomex |
SISCOMEX Country/Region Code |
nVarChar |
3 |
- |
|
|
|
| IsIntraS |
Intrastat Trans. |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EAEU |
EAEU |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ISO2Code |
ISO Alpha-2 Code |
nVarChar |
2 |
- |
|
|
|
| ISO3Code |
ISO Alpha-3 Code |
nVarChar |
3 |
- |
|
|
|
| ISONumeric |
ISO Numeric |
nVarChar |
3 |
- |
|
|
|