Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR022
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Matched_Transactions
Physical Name: NCABR022
Technical Name: NC_Matched_Transactions
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | JRNENTRY  | Journal Entry | LI8_U0 | Long Integer | 8 | |
| 2 | RCTRXSEQ | Recurring TRX Sequence | DLR19_$S2 | Currency | 19 | |
| 3 | SOURCDOC | Source Document | STR10_Source_Document | String | 10 | |
Key to the Source Document Master (SY00900).
Click to show/hide | ||||||
| 4 | REFRENCE | Reference | STR30 | String | 30 | |
| 5 | DSCRIPTN | Description | STR30 | String | 30 | |
| 6 | TRXDATE | TRX Date | DT_Date | Date | 6 | |
| 7 | USERID | User ID | STR15_User_ID | String | 15 | |
Key to the Users Master (SY01400).
Click to show/hide | ||||||
| 8 | NC_Bank_ID | NC_Bank_ID | STR15_Bank_ID | String | 15 | |
| 9 | NC_Trx_Date | NC_Trx_Date | DATE | Date | 6 | |
| 10 | NC_Reference | NC_Reference | STR30 | String | 30 | |
| 11 | NC_Trx_Type | NC_Trx_Type | STR9 | String | 9 | |
| 12 | NC_BL_Amount | NC_BL_Amount | NC_BL_Amount | Currency | 15 | |
| 13 | BANKID | Bank ID | STR15_Bank_ID | String | 15 | |
| 14 | TRXAMNT | TRX Amount | DLR19_$S2 | Currency | 19 | |
| 15 | NC_Sequence_Number | NC_Sequence_Number | NC_Sequence_Number | Long Integer | 10 | |
| 16 | RECONUM | Reconcile Number | DLR_Document_Number | Currency | 19 | |
| 17 | NC_Reconciled_Date | NC_Reconciled_Date | DATE | Date | 6 | |
| 18 | NC_Match_Number | NC_Match_Number | NC_Match_Number | Long Integer | 10 | |
| 19 | NC_Originating_Trx | NC_Originating_Trx | INT1 | Integer | 1 | |
| 20 | NCReconcileJournal | NC_Reconcile_Journal | LI8_U0 | Long Integer | 8 | |
| 21 | CURRNIDX | Currency Index | INT3 | Integer | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hide | ||||||
| 22 | ORIGAMT | Originating Amount | DLR19_$S2 | Currency | 19 | |
| 23 | NC_Bank_Amount | NC Bank Amount | DLR19_$S2 | Currency | 19 | |
| 24 | NC_MC_Def_1 | NC_MC_Def:Currency ID | STR15_Currency_ID | String | 15 | |
| 25 | NC_MC_Def_2 | NC_MC_Def:Currency Index | INT3 | Integer | 3 | |
| 26 | NC_MC_Def_3 | NC_MC_Def:Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
| 27 | NC_MC_Def_4 | NC_MC_Def:Exchange Table ID | STR15_Exchange_Table_ID | String | 15 | |
| 28 | NC_MC_Def_5 | NC_MC_Def:Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
| 29 | NC_MC_Def_6 | NC_MC_Def:Exchange Date | DT_Date | Date | 6 | |
| 30 | NC_MC_Def_7 | NC_MC_Def:Decimal Places | DDL_Decimal_Places | Integer | 0 | |
| 31 | NC_MC_Def_8 | NC_MC_Def:Time | TM6 | Time | 6 | |
| 32 | NC_MC_Def_9 | NC_MC_Def:Rate Calc Method | INT | Integer | 0 | |
| 33 | NC_MC_Def_10 | NC_MC_Def:View Mode | INT | Integer | 0 | |
| 34 | NC_MC_Def_11 | NC_MC_Def:IS MC Trx | INT | Integer | 0 | |
| 35 | NC_MC_Def_12 | NC_MC_Def:Expiration Date | DT_Date | Date | 6 | |
| 36 | NC_MC_Def_13 | NC_MC_Def:Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
| 37 | NC_MC_Def_14 | NC_MC_Def:MC Transaction State | INT1 | Integer | 1 | |