| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| BoeKey |
Bill of Exchange Key |
Int |
11 |
- |
|
|
|
| BoeNum |
Bill of Exchange No. |
Int |
11 |
- |
|
|
|
| BoeStatus |
Bill of Exchange Status |
VarChar |
1 |
- |
|
G |
Generated |
| |
|
|
|
|
|
S |
Sent |
| |
|
|
|
|
|
D |
Deposited |
| |
|
|
|
|
|
P |
Paid |
| |
|
|
|
|
|
C |
Canceled |
| |
|
|
|
|
|
L |
Closed |
| |
|
|
|
|
|
F |
Failed |
| |
|
|
|
|
|
V |
BoE to Vendor |
| BoeType |
Bill of Exchange Type |
VarChar |
1 |
- |
I |
I |
Incoming |
| |
|
|
|
|
|
O |
Outgoing |
| DpsBankCod |
Deposit Bank Code |
nVarChar |
30 |
- |
|
|
|
| DpsCntrCod |
Deposit Country/Region Code |
nVarChar |
3 |
OCRY |
|
|
|
| DueDate |
Bill of Exchange Due Date |
Date |
8 |
- |
|
|
|
| DpstAcct |
Bank Account No. |
nVarChar |
50 |
- |
|
|
|
| DpstBranch |
Branch for Payments |
nVarChar |
50 |
- |
|
|
|
| Details |
Details |
nVarChar |
50 |
- |
|
|
|
| TransRef |
Journal Entry Reference |
nVarChar |
8 |
- |
|
|
|
| PmntDate |
Payment Date |
Date |
8 |
- |
|
|
|
| PmntNum |
Payment No. |
Int |
11 |
- |
|
|
|
| BoeSum |
Bill of Exchange Amount |
Num |
19.6 |
- |
|
|
|
| BoeSumSC |
Bill of Exchange Amount (SC) |
Num |
19.6 |
- |
|
|
|
| BoeSumFC |
Bill of Exchange Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CardCode |
BP Code |
nVarChar |
15 |
OCRD |
|
|
|
| CardName |
BP Name |
nVarChar |
200 |
- |
|
|
|
| BoeAcct |
BP Account Code |
nVarChar |
15 |
OACT |
|
|
|
| Currency |
Bill of Exchange Currency |
nVarChar |
3 |
OCRN |
|
|
|
| Printed |
Printed |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| TotalWords |
Total in Words |
nVarChar |
100 |
- |
|
|
|
| Signature |
Signature |
nVarChar |
155 |
- |
|
|
|
| TransNum |
Transaction No. |
Int |
11 |
- |
0 |
|
|
| LinesSum |
Row Totals |
Num |
19.6 |
- |
|
|
|
| DdctPrcnt |
% Withholding Tax Ded. |
Num |
19.6 |
- |
|
|
|
| Address |
Address |
nVarChar |
254 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| VatTotal |
Total Tax |
Num |
19.6 |
- |
|
|
|
| VatTotalSC |
Total Tax (SC) |
Num |
19.6 |
- |
|
|
|
| VatTotalFC |
Total Tax (FC) |
Num |
19.6 |
- |
|
|
|
| VatCalcult |
Calculate Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TaxDate |
Document Date |
Date |
8 |
- |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Upgrade |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| SumRfndCln |
Deduction Refund Amount |
Num |
19.6 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| PrintedBy |
Printed By |
Int |
6 |
- |
|
|
|
| Transfered |
Transferred to next year |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Instance |
Instance |
Int |
6 |
- |
0 |
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| BPBankCod |
BP Bank Code |
nVarChar |
30 |
- |
|
|
|
| BPBankNam |
BP Bank Name |
nVarChar |
250 |
- |
|
|
|
| BPBankAct |
BP Bank Account |
nVarChar |
50 |
- |
|
|
|
| BPBankBrnc |
BP Bank Branch |
nVarChar |
50 |
- |
|
|
|
| BPBankCtr |
BP Bank Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| RefNum |
Reference No. |
nVarChar |
254 |
- |
|
|
|
| IsReconcld |
Reconciled |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| Comments |
Remarks |
nVarChar |
254 |
- |
|
|
|
| PayMethCod |
Payment Method Code |
nVarChar |
15 |
OPYM |
|
|
|
| DepositNum |
Deposit Number |
Int |
11 |
- |
|
|
|
| PymMethNam |
Payment Method Name |
nVarChar |
100 |
- |
|
|
|
| DeductSum |
Deduction Amount |
Num |
19.6 |
- |
|
|
|
| ControlKey |
Control Key |
nVarChar |
2 |
- |
|
|
|
| AgentCode |
Agent Code |
nVarChar |
32 |
OAGP |
|
|
|
| ReconcilNu |
External Reconciliation No. |
Int |
11 |
- |
|
|
|
| DepositTyp |
Deposit Type |
VarChar |
1 |
- |
|
C |
Collection |
| |
|
|
|
|
|
D |
Discounted |
| CreatStatu |
Creation Status |
VarChar |
1 |
- |
|
G |
Generated |
| |
|
|
|
|
|
S |
Sent |
| Ref2 |
Reference 2 |
nVarChar |
254 |
- |
|
|
|
| PayEngSt1 |
Payment Engine Status 1 |
VarChar |
1 |
- |
|
|
|
| PayEngSt2 |
Payment Engine Status 2 |
VarChar |
1 |
- |
|
|
|
| PayEngSt3 |
Payment Engine Status 3 |
nVarChar |
3 |
- |
|
|
|
| StampTax |
Stamp Tax Code |
nVarChar |
8 |
OVTG |
|
|
|
| StmpTxAmnt |
Stamp Tax Amount |
Num |
19.6 |
- |
|
|
|
| DpsActKey |
Bank Account Internal ID |
Int |
11 |
DSC1 |
|
|
|
| OutBnkKey |
Outgoing Bank Account Key |
Int |
11 |
DSC1 |
|
|
|
| Portfolio |
Portfolio |
nVarChar |
8 |
OPFT |
|
|
|
| VndCodeCEE |
Vendor Code |
nVarChar |
15 |
OCRD |
|
|
|
| VndNameCEE |
Vendor Name |
nVarChar |
200 |
- |
|
|
|
| OurNum |
Our Number |
Int |
11 |
- |
|
|
|
| BarcodeNum |
Bar Code Number |
nVarChar |
120 |
- |
|
|
|
| BarcodeRep |
Bar Code Representation |
nVarChar |
100 |
- |
|
|
|
| OurNumChk |
Our Number Check Digit |
VarChar |
1 |
- |
|
|
|
| FolioPref |
Folio Prefix String |
nVarChar |
4 |
- |
|
|
|
| FolioNum |
Folio Number |
Int |
11 |
- |
|
|
|
| LPgFolioN |
Folio No. for Last Page in Doc. |
Int |
11 |
- |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| IntrstAmnt |
Interest Amount |
Num |
19.6 |
- |
|
|
|
| DiscAmnt |
Discount Amount |
Num |
19.6 |
- |
|
|
|
| FineAmnt |
Fine Amount |
Num |
19.6 |
- |
|
|
|
| IntrstDate |
BoE Interest Date |
Date |
8 |
- |
|
|
|
| DiscDate |
BoE Discount Date |
Date |
8 |
- |
|
|
|
| FineDate |
BoE Fine Date |
Date |
8 |
- |
|
|
|
| PostType |
Posting Type |
VarChar |
1 |
- |
|
D |
Default |
| |
|
|
|
|
|
A |
Alternative |
| IOFAmnt |
IOF Amount |
Num |
19.6 |
- |
|
|
|
| ServFeeAm |
Service Fee Amount |
Num |
19.6 |
- |
|
|
|
| OtherExAm |
Other Expenses Amount |
Num |
19.6 |
- |
|
|
|
| OtherInAm |
Other Incomes Amount |
Num |
19.6 |
- |
|
|
|
| BPLId |
Branch |
Int |
11 |
OBPL |
|
|
|
| EnBPBnkAct |
Encryption of BP Bank Account |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| EnDpstAcct |
Encryption of Bank Account No. |
Text |
16 |
- |
|
|
|