| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| BankCode |
Bank Code |
nVarChar |
30 |
- |
|
|
|
| Account |
Acct No. |
nVarChar |
50 |
- |
|
|
|
| Branch |
Branch |
nVarChar |
50 |
- |
|
|
|
| NextCheck |
Next Check No. |
Int |
11 |
- |
|
|
|
| GLAccount |
G/L Account |
nVarChar |
15 |
OACT |
|
|
|
| Free |
Free |
VarChar |
1 |
- |
|
|
|
| Street |
Street |
nVarChar |
100 |
- |
|
|
|
| Block |
Block |
nVarChar |
100 |
- |
|
|
|
| ZipCode |
Zip Code |
nVarChar |
20 |
- |
|
|
|
| City |
City |
nVarChar |
100 |
- |
|
|
|
| County |
County |
nVarChar |
100 |
- |
|
|
|
| Country |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| State |
State |
nVarChar |
3 |
OCST |
|
|
|
| BISR |
BISR |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ControlKey |
Control Key |
nVarChar |
2 |
- |
|
|
|
| UsrNumber1 |
User No. 1 |
nVarChar |
25 |
- |
|
|
|
| UsrNumber2 |
User No. 2 |
nVarChar |
25 |
- |
|
|
|
| UsrNumber3 |
User No. 3 |
nVarChar |
25 |
- |
|
|
|
| UsrNumber4 |
User No. 4 |
nVarChar |
25 |
- |
|
|
|
| IBAN |
IBAN |
nVarChar |
50 |
- |
|
|
|
| DscountBOE |
Debt of Discounted BoE |
nVarChar |
15 |
OACT |
|
|
|
| TolrnceDay |
Tolerance Days |
Int |
11 |
- |
|
|
|
| MinAmntBOE |
Min. Amount of Bill of Exchange |
Num |
19.6 |
- |
|
|
|
| MaxAmntBOE |
Max. Amount of Bill of Exchange |
Num |
19.6 |
- |
|
|
|
| DscntLimit |
Discount Limit |
Num |
19.6 |
- |
|
|
|
| DaysInAdva |
Days in Advance |
Int |
11 |
- |
|
|
|
| BankCollec |
Bank on Collection |
nVarChar |
15 |
OACT |
|
|
|
| BankDiscou |
Bank on Discounted |
nVarChar |
15 |
OACT |
|
|
|
| BranchName |
Branch Name |
nVarChar |
50 |
- |
|
|
|
| AliasName |
Alias Name |
nVarChar |
50 |
- |
|
|
|
| CompanyCod |
Company Code |
nVarChar |
10 |
- |
|
|
|
| AcctType |
Account Type |
VarChar |
1 |
- |
|
|
|
| Building |
Building/Floor/Room |
Text |
16 |
- |
|
|
|
| BIK |
BIK |
nVarChar |
15 |
- |
|
|
|
| AcctName |
Bank Account Name |
nVarChar |
250 |
- |
|
|
|
| CorresAcct |
Correspondent Account |
nVarChar |
30 |
- |
|
|
|
| Phone |
Telephone No. |
nVarChar |
50 |
- |
|
|
|
| Fax |
Fax |
nVarChar |
50 |
- |
|
|
|
| GLIntriAct |
G/L Interim Account |
nVarChar |
15 |
OACT |
|
|
|
| ChkPaper |
Paper Type |
VarChar |
1 |
- |
D |
B |
Blank Paper |
| |
|
|
|
|
|
S |
Overflow Prenumbered Check Stock |
| |
|
|
|
|
|
P |
Overflow Blank Paper |
| |
|
|
|
|
|
D |
Default |
| MaxChkLine |
Maximum Lines |
Int |
6 |
- |
|
|
|
| TmpltName |
Template Name |
nVarChar |
8 |
- |
|
|
|
| AbsEntry |
Internal Number |
Int |
11 |
- |
|
|
|
| BankKey |
Bank Internal ID |
Int |
11 |
ODSC |
|
|
|
| LockChk |
Lock Checks Printing |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OurNum |
Our Number in Next Boleto |
Int |
11 |
- |
|
|
|
| AgreeNum |
Agreement Number |
nVarChar |
10 |
- |
|
|
|
| AccountChk |
Account Check Digit |
VarChar |
1 |
- |
|
|
|
| ISRType |
ISR Type |
Int |
6 |
- |
2 |
1 |
ISR |
| |
|
|
|
|
|
2 |
BISR |
| |
|
|
|
|
|
3 |
ISR+ |
| |
|
|
|
|
|
4 |
BISR+ |
| ISRBillerI |
ISR Biller ID |
nVarChar |
9 |
- |
|
|
|
| CustIdNum |
Customer ID Number |
nVarChar |
10 |
- |
0 |
|
|
| InSeri |
Incoming Payment Series |
Int |
11 |
NNM1 |
-1 |
|
|
| OutSeri |
Outgoing Payment Series |
Int |
11 |
NNM1 |
-1 |
|
|
| JDTSeri |
Journal Entry Series |
Int |
11 |
NNM1 |
-1 |
|
|
| FilePlug |
Import File Name |
nVarChar |
50 |
- |
|
|
|
| ImpStmt |
Imported Bank Statement |
VarChar |
1 |
- |
N |
Y |
Create New - From File |
| |
|
|
|
|
|
N |
Create New - Manually |
| PreNumber |
Prenumbered Check |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AddrType |
Address Type |
nVarChar |
100 |
- |
|
|
|
| StreetNo |
Street No. |
nVarChar |
100 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| UsrLogSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| SwiftNum |
BIC/SWIFT Code |
nVarChar |
50 |
- |
|
|
|
| FineAcct |
Fine Account |
nVarChar |
15 |
OACT |
|
|
|
| IntrstAcct |
Interest Account |
nVarChar |
15 |
OACT |
|
|
|
| DscntAcct |
Discount Account |
nVarChar |
15 |
OACT |
|
|
|
| SvcFeeAcct |
Service Fee Account |
nVarChar |
15 |
OACT |
|
|
|
| BranchChk |
Branch Check Digit |
nVarChar |
5 |
- |
|
|
|
| RetFile |
Retorno File Format |
nVarChar |
50 |
- |
|
|
|
| IOFTaxAcct |
IOF Tax Account |
nVarChar |
15 |
- |
|
|
|
| OthExpAcct |
Other Expenses Account |
nVarChar |
15 |
OACT |
|
|
|
| OthIncAcct |
Other Incomes Account |
nVarChar |
15 |
OACT |
|
|
|
| CollCode |
Collection Code |
nVarChar |
50 |
- |
|
|
|
| FileSeqNNo |
File Sequence Next Number |
Int |
11 |
- |
|
|
|
| RefCoLevel |
Reference control level |
VarChar |
1 |
- |
H |
S |
Soft Control |
| |
|
|
|
|
|
H |
Hard Control |
| |
|
|
|
|
|
V |
Hard Control with variable length |
| |
|
|
|
|
|
F |
Hard Control with fixed length |
| RefFixLen1 |
Reference fixed length 1 |
Int |
6 |
- |
|
|
|
| RefFixLen2 |
Reference fixed length 2 |
Int |
6 |
- |
|
|
|
| Currency |
Currency |
nVarChar |
3 |
OCRN |
|
|
|
| NoValidBal |
No Validation for Starting/Ending Balance |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ECheck |
E-Check |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EnAccount |
Encryption of Acct No. |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|