| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | BoeMatch | BoE Match | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | BoeNo | BoE Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | BoeDate | BoE Date | date | 8 | 0 | | | | |
| 5 | BoeDueDate | BoE Due Date | date | 8 | 0 | | | | |
| 6 | CreditDate | Credit Date | date | 8 | 0 | | | | |
| 7 | CurrBoeSt | Current BoE Status | char | 1 | 0 | | | C=Canceled, D=Deposited, F=Failed, G=Generated, L=Closed, P=Paid, S=Sent, V=BoE to Vendor | Allow NULL? |
| 8 | ReqBoeSt | Requested BoE Status | char | 1 | 0 | | | C=Canceled, D=Deposited, F=Failed, G=Generated, L=Closed, P=Paid, S=Sent, V=BoE to Vendor | Allow NULL? |
| 9 | Instruct1 | BoE Instruction 1 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | Instruct2 | BoE Instruction 2 | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | CancelCode | Cancellation Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | MovmntCode | Movement Code | int | 6 | 0 | | | | Allow NULL? |
| 13 | OccurCode | Occurrence Code | int | 6 | 0 | | | | Allow NULL? |
| 14 | OccurDate | Occurrence Date | date | 8 | 0 | | | | |
| 15 | Portfolio | Portfolio | char | 1 | 0 | | | | Allow NULL? |
| 16 | OurNum | Our Number | int | 11 | 0 | | | | Allow NULL? |
| 17 | ValueOfT | Value of Title | num | 19 | 6 | | | | Allow NULL? |
| 18 | NetAmnt | Net Amount | num | 19 | 6 | | | | Allow NULL? |
| 19 | PaidAmnt | Paid Amount | num | 19 | 6 | | | | Allow NULL? |
| 20 | FineAmnt | Fine Amount | num | 19 | 6 | | | | Allow NULL? |
| 21 | IntAmnt | Interest Amount | num | 19 | 6 | | | | Allow NULL? |
| 22 | Discounts | Discount Amount | num | 19 | 6 | | | | Allow NULL? |
| 23 | ServiceFee | Service Fee | num | 19 | 6 | | | | Allow NULL? |
| 24 | IOFTax | IOF Tax | num | 19 | 6 | | | | Allow NULL? |
| 25 | OtherCred | Other Credits | num | 19 | 6 | | | | Allow NULL? |
| 26 | OtherExp | Other Expenses | num | 19 | 6 | | | | Allow NULL? |
| 27 | OtherInc | Other Incomes | num | 19 | 6 | | | | Allow NULL? |
| 28 | Errors | Errors | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | RefNum | Reference No. | nvarchar | 254 | 0 | | | | Allow NULL? |
| 30 | Ref2 | Reference 2 | nvarchar | 254 | 0 | | | | Allow NULL? |
| 31 | CardName | BP Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 32 | BoEBPName | BoE BP Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 33 | MatchCode | Match Code | char | 1 | 0 | | N | A=Automatic, M=Manual, N=Not Identified | Allow NULL? |
| 34 | Selected | Selected | char | 1 | 0 | | N | | Allow NULL? |
| 35 | BoeRec | BoE Record Number | int | 11 | 0 | | | | Allow NULL? |
| 36 | RetIndex | RET File Record Index | int | 11 | 0 | | | | Allow NULL? |
| 37 | Filtered | Filtered | char | 1 | 0 | | Y | | Allow NULL? |
| 38 | Executed | Executed | char | 1 | 0 | | N | | Allow NULL? |
| 39 | Failed | Failed | char | 1 | 0 | | N | | Allow NULL? |
| 40 | LastRun | Last Run | char | 1 | 0 | | N | | Allow NULL? |
| 41 | ErrorMsg | Error Message | nvarchar | 254 | 0 | | | | Allow NULL? |
| 42 | JETransId | JE Trans. ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | CardCode | BoE BP Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 44 | PostType | Transaction Type | char | 1 | 0 | | C | C=Collection, D=Discounted | Allow NULL? |
