| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| IdNumber |
External Bank Statement No. |
Int |
11 |
OBNH |
|
|
|
| AcctCode |
Account Number |
nVarChar |
15 |
OACT |
|
|
|
| Sequence |
Sequence No. |
Int |
11 |
- |
0 |
|
|
| AcctName |
Account Name |
nVarChar |
200 |
- |
|
|
|
| Ref |
Reference |
nVarChar |
27 |
- |
|
|
|
| DueDate |
Due Date |
Date |
8 |
- |
|
|
|
| Memo |
Details |
nVarChar |
254 |
- |
|
|
|
| DebAmount |
Debit Amount (FC) |
Num |
19.6 |
- |
|
|
|
| DebAmntCur |
Currency for Accounts Payable |
nVarChar |
3 |
OCRN |
|
|
|
| CredAmnt |
Credit Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CredAmntCu |
Credit Currency |
nVarChar |
3 |
OCRN |
|
|
|
| balance |
Balance |
Num |
19.6 |
- |
|
|
|
| BankMatch |
Reconciliation No. |
Int |
11 |
- |
|
|
|
| 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 |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| ExternCode |
External Code |
nVarChar |
30 |
- |
|
|
|
| CardCode |
BP Code |
nVarChar |
15 |
OCRD |
|
|
|
| CardName |
BP Name |
nVarChar |
200 |
- |
|
|
|
| StatemNo |
Statement Number |
Int |
11 |
- |
|
|
|
| DocNum |
Invoice Document |
nVarChar |
27 |
- |
|
|
|
| PaymCreat |
Payment Created |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LineStatus |
Row Status |
VarChar |
1 |
- |
|
|
|
| VisOrder |
Visual Order |
Int |
11 |
- |
|
|
|
| DocNumType |
Doc. No. Source |
VarChar |
1 |
- |
D |
P |
Payment Reference No. |
| |
|
|
|
|
|
I |
ISR |
| |
|
|
|
|
|
D |
Doc Num |
| Memo2 |
Details 2 |
nVarChar |
254 |
- |
|
|
|
| PaymentRef |
Payment Reference No. |
nVarChar |
27 |
- |
|
|
|
| autoCreate |
Manually/Automatically Create |
VarChar |
1 |
- |
M |
M |
Manual |
| |
|
|
|
|
|
A |
Automatic |
| BSLineDate |
Bank Statement Entry Date |
Date |
8 |
- |
|
|
|
| BSValuDate |
Bank Statement Due Date |
Date |
8 |
- |
|
|
|
| InOpCode |
Internal Bank Operation Code |
Int |
11 |
OBTC |
|
|
|
| Cleared |
Cleared |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OposAct |
BP Bank Account |
nVarChar |
50 |
- |
|
|
|
| DebAmntLC |
Debit Amount (LC) |
Num |
19.6 |
- |
|
|
|
| CredAmntLC |
Credit Amount (LC) |
Num |
19.6 |
- |
|
|
|
| ExchngRate |
Exchange Rate |
Num |
19.6 |
- |
|
|
|
| BPIBAN |
IBAN of the BP Bank Account |
nVarChar |
50 |
- |
|
|
|
| Fee |
Fee on the Line |
Num |
19.6 |
- |
|
|
|
| PmnPstDate |
Payment Posting Date |
Date |
8 |
- |
|
|
|
| PmnValDate |
Payment Due Date |
Date |
8 |
- |
|
|
|
| LnDocDate |
Line Document Date |
Date |
8 |
- |
|
|
|
| VatAmntLC |
VAT Amount (LC) |
Num |
19.6 |
- |
|
|
|
| VatAmntFC |
VAT Amount (FC) |
Num |
19.6 |
- |
|
|
|
| JDTID |
Journal Entry ID |
Int |
11 |
OJDT |
|
|
|
| PmntID |
Payment ID |
Int |
11 |
- |
|
|
|
| ObjCrtType |
Document Type |
Int |
6 |
- |
24 |
|
|
| PstMethod |
Posting Method |
VarChar |
1 |
- |
C |
A |
G/L Account from/to Bank Account |
| |
|
|
|
|
|
C |
BP from/to Bank Account |
| |
|
|
|
|
|
J |
Interim Account from/to Bank Account |
| |
|
|
|
|
|
E |
External Reconciliation |
| |
|
|
|
|
|
I |
Ignore |
| FeeAct |
G/L Account for Fee |
nVarChar |
15 |
OACT |
|
|
|
| FeeProfitC |
Fee Distribution Rule |
nVarChar |
8 |
OOCR |
|
|
|
| FeeProj |
Project Fee |
nVarChar |
20 |
OPRJ |
|
|
|
| BpBankCode |
BP Bank Code |
nVarChar |
30 |
- |
|
|
|
| FeeProfit2 |
Fee Distribution Rule2 |
nVarChar |
8 |
OOCR |
|
|
|
| FeeProfit3 |
Fee Distribution Rule3 |
nVarChar |
8 |
OOCR |
|
|
|
| FeeProfit4 |
Fee Distribution Rule4 |
nVarChar |
8 |
OOCR |
|
|
|
| FeeProfit5 |
Fee Distribution Rule5 |
nVarChar |
8 |
OOCR |
|
|
|
| ApplWTSum |
Applied WTax Sum |
Num |
19.6 |
- |
|
|
|
| InfoLog |
Information Log |
nVarChar |
254 |
- |
|
|
|
| LineOrigin |
Row Origin |
VarChar |
1 |
- |
R |
R |
Regular |
| |
|
|
|
|
|
A |
Archive |
| BPSwift |
BP BIC/SWIFT Code |
nVarChar |
50 |
- |
|
|
|
| Source |
Source |
VarChar |
1 |
- |
I |
I |
Imported |
| |
|
|
|
|
|
A |
Imported and Amended |
| |
|
|
|
|
|
M |
Manually Entered |
| PayOrderNo |
Payment Order Number |
Int |
11 |
- |
|
|
|
| TaxIDNum |
Federal Tax ID |
nVarChar |
32 |
- |
|
|
|
| PONumber |
External Payment Order Number |
Int |
11 |
- |
|
|
|
| FormatName |
Format Name for Bank Statement |
nVarChar |
254 |
- |
|
|
|
| FileCRC |
Bank Statement File Hash Code |
nVarChar |
32 |
- |
|
|
|
| FolioPref |
Folio Prefix String |
nVarChar |
4 |
- |
|
|
|
| FolioNum |
Folio Number |
Int |
11 |
- |
|
|
|
| BPLIdPmn |
Branch for Payment ID |
Int |
11 |
OBPL |
|
|
|
| BPAcctName |
BP Bank Account Name |
nVarChar |
250 |
- |
|
|
|
| EnOposAct |
Encryption of BP Bank Account |
Text |
16 |
- |
|
|
|
| EnBPIBAN |
Encryption of BP Bank IBAN |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| CtrlAcct |
Control Account |
nVarChar |
15 |
OACT |
|
|
|