|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Check Register
Table Name: OCHH
Table Description: Check Register
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CheckKey | Check Key | Int | 11 | - | Â | Â | Â |
| CheckNum | Check Number | Int | 11 | - | Â | Â | Â |
| BankCode | Bank Code | nVarChar | 30 | - | Â | Â | Â |
| Branch | Branch Number | nVarChar | 50 | - | Â | Â | Â |
| CashCheck | Check Register Account | nVarChar | 15 | - | Â | Â | Â |
| CheckDate | Check Date | Date | 8 | - | Â | Â | Â |
| Details | Details | nVarChar | 20 | - | Â | Â | Â |
| CardCode | BP/Account Code | nVarChar | 15 | OCRD | Â | Â | Â |
| RcptDate | Receipt Date | Date | 8 | - | Â | Â | Â |
| RcptNum | Receipt Number | Int | 11 | ORCT | Â | Â | Â |
| CheckSum | Check Amount | Num | 19.6 | - | Â | Â | Â |
| Trnsfrable | Negotiable | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Deposited | Deposited | VarChar | 1 | - | N | C | As Cash |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | S | As Postdated |
| Converted | Endorsed | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Vendor | Endorsed for | nVarChar | 15 | - | Â | Â | Â |
| TransNum | Payment Transaction | Int | 11 | - | Â | Â | Â |
| DepNum2 | Postdated Deposit Key | Int | 11 | ODPT | 0 | Â | Â |
| DpstAbs | Payment Internal ID | Int | 11 | ODPS | Â | Â | Â |
| BankAcct | Deposit Account | nVarChar | 15 | - | Â | Â | Â |
| AcctNum | Account Number | nVarChar | 50 | - | Â | Â | Â |
| Currency | Check Currency | nVarChar | 3 | - | Â | Â | Â |
| Canceled | Canceled | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RcptLineId | Row Number in Receipt | Int | 11 | - | Â | Â | Â |
| Transfered | Postponed to Next Year | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Instance | Instance | Int | 6 | - | 0 | Â | Â |
| UserID | User Signature | Int | 6 | OUSR | Â | Â | Â |
| BankCountr | Bank Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| Project | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| CanceJEAbs | Cancellation Journal Entry | Int | 11 | OJDT | Â | Â | Â |
| TempJEAbs | Temp. Journal Entry | Int | 11 | - | Â | Â | Â |
| CardName | BP/Account Name | nVarChar | 200 | - | Â | Â | Â |
| FiscalID | Fiscal ID | nVarChar | 100 | - | Â | Â | Â |
| OrigIssdBy | Orginally Issued By | nVarChar | 254 | - | Â | Â | Â |
| RejeByBank | Rejected by Bank | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| EnAcctNum | Encryption of Account Number | Text | 16 | - | Â | Â | Â |
| EncryptIV | Encrypt IV | nVarChar | 100 | - | Â | Â | Â |
| DPPStatus | Data Protection Status | VarChar | 1 | - | N | N | None |
| Â | Â | Â | Â | Â | Â | D | Erased |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| Key | Unique | Field |
| PRIMARY | Yes | CheckKey |
| RECEIPT | No | RcptNum |
| Â | Â | RcptLineId |
| DEP_ABS1 | No | DpstAbs |
| CHECK_NUM | No | CheckNum |
| DEP_ABS2 | No | DepNum2 |