|
  
|
||
|
|
||
The Bank Reconciliation Details table contains the details of complete and incomplete bank reconciliations that have been performed using the Bank Reconciliation Wizard.
Header information is stored in the Bank Reconciliation Headers table.
Key Field: brdIdxCode1
Field Name |
Description |
Type |
Length |
brdIdxRecSub |
|
String |
2 |
brdSpare |
|
String |
1 |
brdIdxCode1 |
|
String |
30 |
brdIdxCode2 |
|
String |
45 |
brdIdxCode3 |
|
String |
31 |
brdPaymentRefLB |
not used |
String |
1 |
brdPaymentRef |
Line Reference |
String |
10 |
brdLineDateLB |
not used |
String |
1 |
brdLineDate |
Line Date |
Date |
8 |
brdMatchingOurRefLB |
not used |
String |
1 |
brdMatchingOurRef |
Transaction OurRef |
String |
16 |
brdValue |
Amount Reconciled |
Float |
8 |
brdLineNo |
Line number |
Integer |
4 |
brdStatementIDLB |
not used |
String |
1 |
brdStatementID |
|
String |
4 |
brdStatementLineNo |
|
Integer |
4 |
brdAcCodeLB |
not used |
String |
1 |
brdAcCode |
|
String |
10 |
brdPeriod |
|
Integer |
1 |
brdYear |
|
Integer |
1 |
brdCompanyRate_1 |
not used |
Integer |
2 |
brdCompanyRate_2 |
not used |
Integer |
4 |
brdDailyRate_1 |
not used |
Integer |
2 |
brdDailyRate_2 |
not used |
Integer |
4 |
brdLUseORate |
not used |
Integer |
1 |
brdTriangulationRate |
not used |
Float |
8 |
brdTriangulationEuro |
not used |
Integer |
1 |
brdTriangulationInve |
not used |
Logical |
1 |
brdTriangulationFloa |
not used |
Logical |
1 |
brdMatchingYourRefLB |
not used |
String |
1 |
brdMatchingYourRef |
|
String |
10 |
brdTransValue |
|
Float |
8 |
brdDepartmentLB |
not used |
String |
1 |
brdDepartment |
|
String |
3 |
brdCostCentreLB |
not used |
String |
1 |
brdCostCentre |
|
String |
3 |
brdGLCode |
|
Integer |
4 |
brdSRIGLCode |
|
Integer |
4 |
brdFolio |
|
Integer |
4 |
brdVATCode |
|
String |
1 |
brdVATAmount |
|
Float |
8 |
brdTransDateLB |
not used |
String |
1 |
brdTransDate |
|
Date |
8 |
brdIsNewTrans |
|
Logical |
1 |
brdLineStatus |
|
Integer |
1 |
