|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Extend Cat. f. Financial Rep.
Table Name: FRC1
Table Description: Extend Cat. f. Financial Rep.
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| CatId | Numerator | Int | 6 | - | Â | Â | Â |
| TemplateId | Template | Int | 11 | OFRT | Â | Â | Â |
| AcctCode | Account Code | nVarChar | 15 | OACT | Â | Â | Â |
| VisOrder | Display Order | Int | 6 | - | Â | Â | Â |
| CFWId | Cash Flow Line Item ID | Int | 11 | OCFW | Â | Â | Â |
| CalcMethod | Calculation Method | nVarChar | 30 | - | Â | BOP | Beginning of Period |
| Â | Â | Â | Â | Â | Â | EOP | End of Period |
| Â | Â | Â | Â | Â | Â | CPID | Current Period In Debit |
| Â | Â | Â | Â | Â | Â | CPIC | Current Period In Credit |
| Â | Â | Â | Â | Â | Â | CPIB | Current Period In Both |
| SlpCode | Sales Unit Code | Int | 11 | OSLP | Â | Â | Â |
| PrcCode | Cost Center Code | nVarChar | 8 | OPRC | Â | Â | Â |
| CalMethod2 | Calculation Method 2 | nVarChar | 30 | - | Â | Â | Â |
| CalMethod3 | Calculation Method 3 | nVarChar | 30 | - | Â | Â | Â |
| Linked | Linked | VarChar | 1 | - | B | B | Balance |
| Â | Â | Â | Â | Â | Â | D | Debit |
| Â | Â | Â | Â | Â | Â | C | Credit |
| Sign | Sign | VarChar | 1 | - | E | E | Â |
| Â | Â | Â | Â | Â | Â | P | Positive |
| Â | Â | Â | Â | Â | Â | N | Negative |
| Key | Unique | Field |
| PRIMARY | Yes | TemplateId |
| Â | Â | CatId |
| Â | Â | AcctCode |
| Â | Â | VisOrder |
| ACCNT_CODE | No | AcctCode |