|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Boleto Retorno Wizard: Import Table
Table Name: RTW1
Table Description: Boleto Retorno Wizard: Import Table
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| BoeMatch | BoE Match | nVarChar | 10 | - | Â | Â | Â |
| BoeNo | BoE Number | nVarChar | 10 | - | Â | Â | Â |
| BoeDate | BoE Date | Date | 8 | - | Â | Â | Â |
| BoeDueDate | BoE Due Date | Date | 8 | - | Â | Â | Â |
| CreditDate | Credit Date | Date | 8 | - | Â | Â | Â |
| CurrBoeSt | Current BoE Status | VarChar | 1 | - | Â | G | Generated |
| Â | Â | Â | Â | Â | Â | S | Sent |
| Â | Â | Â | Â | Â | Â | D | Deposited |
| Â | Â | Â | Â | Â | Â | P | Paid |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| Â | Â | Â | Â | Â | Â | L | Closed |
| Â | Â | Â | Â | Â | Â | F | Failed |
| Â | Â | Â | Â | Â | Â | V | BoE to Vendor |
| ReqBoeSt | Requested BoE Status | VarChar | 1 | - | Â | G | Generated |
| Â | Â | Â | Â | Â | Â | S | Sent |
| Â | Â | Â | Â | Â | Â | D | Deposited |
| Â | Â | Â | Â | Â | Â | P | Paid |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| Â | Â | Â | Â | Â | Â | L | Closed |
| Â | Â | Â | Â | Â | Â | F | Failed |
| Â | Â | Â | Â | Â | Â | V | BoE to Vendor |
| Instruct1 | BoE Instruction 1 | nVarChar | 2 | - | Â | Â | Â |
| Instruct2 | BoE Instruction 2 | nVarChar | 2 | - | Â | Â | Â |
| CancelCode | Cancellation Code | nVarChar | 4 | - | Â | Â | Â |
| MovmntCode | Movement Code | Int | 6 | - | Â | Â | Â |
| OccurCode | Occurrence Code | Int | 6 | - | Â | Â | Â |
| OccurDate | Occurrence Date | Date | 8 | - | Â | Â | Â |
| Portfolio | Portfolio | VarChar | 1 | - | Â | Â | Â |
| OurNum | Our Number | Int | 11 | - | Â | Â | Â |
| ValueOfT | Value of Title | Num | 19.6 | - | Â | Â | Â |
| NetAmnt | Net Amount | Num | 19.6 | - | Â | Â | Â |
| PaidAmnt | Paid Amount | Num | 19.6 | - | Â | Â | Â |
| FineAmnt | Fine Amount | Num | 19.6 | - | Â | Â | Â |
| IntAmnt | Interest Amount | Num | 19.6 | - | Â | Â | Â |
| Discounts | Discount Amount | Num | 19.6 | - | Â | Â | Â |
| ServiceFee | Service Fee | Num | 19.6 | - | Â | Â | Â |
| IOFTax | IOF Tax | Num | 19.6 | - | Â | Â | Â |
| OtherCred | Other Credits | Num | 19.6 | - | Â | Â | Â |
| OtherExp | Other Expenses | Num | 19.6 | - | Â | Â | Â |
| OtherInc | Other Incomes | Num | 19.6 | - | Â | Â | Â |
| Errors | Errors | nVarChar | 8 | - | Â | Â | Â |
| RefNum | Reference No. | nVarChar | 254 | - | Â | Â | Â |
| Ref2 | Reference 2 | nVarChar | 254 | - | Â | Â | Â |
| CardName | BP Name | nVarChar | 200 | - | Â | Â | Â |
| BoEBPName | BoE BP Name | nVarChar | 200 | - | Â | Â | Â |
| MatchCode | Match Code | VarChar | 1 | - | N | A | Automatic |
| Â | Â | Â | Â | Â | Â | M | Manual |
| Â | Â | Â | Â | Â | Â | N | Not Identified |
| Selected | Selected | VarChar | 1 | - | N | Â | Â |
| BoeRec | BoE Record Number | Int | 11 | - | Â | Â | Â |
| RetIndex | RET File Record Index | Int | 11 | - | Â | Â | Â |
| Filtered | Filtered | VarChar | 1 | - | Y | Â | Â |
| Executed | Executed | VarChar | 1 | - | N | Â | Â |
| Failed | Failed | VarChar | 1 | - | N | Â | Â |
| LastRun | Last Run | VarChar | 1 | - | N | Â | Â |
| ErrorMsg | Error Message | nVarChar | 254 | - | Â | Â | Â |
| JETransId | JE Trans. ID | nVarChar | 10 | - | Â | Â | Â |
| CardCode | BoE BP Code | nVarChar | 15 | - | Â | Â | Â |
| PostType | Transaction Type | VarChar | 1 | - | C | C | Collection |
| Â | Â | Â | Â | Â | Â | D | Discounted |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |