Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR301
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Extract_Exception_WORK_12005c
Physical Name: NCABR301
Technical Name: NC_Extract_Exception_WORK_12005c
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | OPENYEAR  | Open Year | INT4_S0 | Integer | 4 | |
| 2 | JRNENTRY | Journal Entry | LI8_U0 | Long Integer | 8 | |
| 3 | RCTRXSEQ | Recurring TRX Sequence | DLR19_$S2 | Currency | 19 | |
| 4 | TRXDATE | TRX Date | DT_Date | Date | 6 | |
| 5 | ACTINDX | Account Index | LI_14 | Long Integer | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hide | ||||||
| 6 | SEQNUMBR | Sequence Number | LI_Sequence_Number | Long Integer | 10 | |
| 7 | CURNCYID | Currency ID | STR15_Currency_ID | String | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hide | ||||||
| 8 | BANKID | Bank ID | STR15_Bank_ID | String | 15 | |
| 9 | DEBITAMT | Debit Amount | DLR19_$S2 | Currency | 19 | |
| 10 | CRDTAMNT | Credit Amount | DLR19_$S2 | Currency | 19 | |
| 11 | ORCTRNUM | Originating Control Number | STR20 | String | 20 | |
| 12 | NC_Orig_ID_600 | NC_Orig_ID_600 | STR20 | String | 20 | |
| 13 | ORDOCNUM | Originating Document Number | STR20 | String | 20 | |
| 14 | ORMSTRID | Originating Master ID | STR30 | String | 30 | |
| 15 | ORGNTSRC | Originating Source | STR15 | String | 15 | |
| 16 | ORTRXSRC | Originating TRX Source | STR13 | String | 13 | |
| 17 | ORTRXTYP | Originating TRX Type | INT | Integer | 0 | |
| 18 | ORGNATYP | Originating Type | INT | Integer | 0 | |
| 19 | XCHGRATE | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
| 20 | EXGTBLID | Exchange Table ID | STR15_Exchange_Table_ID | String | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide | ||||||
| 21 | RTCLCMTD | Rate Calculation Method | GB | Integer | 0 | |
| 22 | RATETPID | Rate Type ID | STR15_Rate_Type_ID | String | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide | ||||||
| 23 | DENXRATE | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
| 24 | MCTRXSTT | MC Transaction State | INT1 | Integer | 1 | |
| 25 | MKTOPROC | Marked To Process | CB | Boolean | 0 | |