|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Recurring Postings
Table Name: ORCR
Table Description: Recurring Postings
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| RcurCode | Recurring Postings Code | nVarChar | 8 | - | Â | Â | Â |
| RcurDesc | Transaction Description | nVarChar | 50 | - | Â | Â | Â |
| Frequency | Frequency | VarChar | 1 | - | M | D | Daily |
| Â | Â | Â | Â | Â | Â | W | Weekly |
| Â | Â | Â | Â | Â | Â | M | Monthly |
| Â | Â | Â | Â | Â | Â | Q | Quarterly |
| Â | Â | Â | Â | Â | Â | S | Semi-annually |
| Â | Â | Â | Â | Â | Â | A | Annually |
| Â | Â | Â | Â | Â | Â | O | One Time |
| Â | Â | Â | Â | Â | Â | T | Template |
| Â | Â | Â | Â | Â | Â | N | Not executed yet |
| Remind | Sub-Frequency | Int | 6 | - | Â | Â | Â |
| LastPosted | Last Executed | Date | 8 | - | Â | Â | Â |
| NextDeu | Next Execution | Date | 8 | - | Â | Â | Â |
| EntryCount | Entries Counter | Int | 6 | - | 0 | Â | Â |
| Volume | Transaction Amount | Num | 19.6 | - | Â | Â | Â |
| VolCurr | Total Currency | nVarChar | 3 | - | Â | Â | Â |
| FinancVol | Total Monetary Val. of Trans. | Num | 19.6 | - | Â | Â | Â |
| Ref1 | Reference 1 | nVarChar | 200 | - | Â | Â | Â |
| Ref2 | Reference 2 | nVarChar | 200 | - | Â | Â | Â |
| TransCode | Transaction Code | nVarChar | 4 | - | Â | Â | Â |
| Memo | Details | nVarChar | 254 | - | Â | Â | Â |
| LimitRtrns | Returns Limit | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Returns | No. of Returns | Int | 6 | - | Â | Â | Â |
| LimitDate | Date Limit | Date | 8 | - | Â | Â | Â |
| Instance | Instance | Int | 6 | - | 0 | Â | Â |
| 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 |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| StampTax | Stamp Tax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AutoVat | Automatic VAT | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ManageWTax | Manage WTax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Ref3 | Reference 3 | nVarChar | 100 | - | Â | Â | Â |
| DeferedTax | Deferred Tax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | RcurCode |
| Â | Â | Instance |
| BYDATE | No | NextDeu |