|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Gross Profit Adjustment
Table Name: OGPA
Table Description: Gross Profit Adjustment
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | - | Â | Â | Â |
| Name | Gross Profit Adjustment Name | nVarChar | 100 | - | Â | Â | Â |
| CreateDate | Create Date | Date | 8 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | - | Â | Â | Â |
| Status | Status | VarChar | 1 | - | Â | R | Saved Recommendations |
| Â | Â | Â | Â | Â | Â | S | Simulation |
| Â | Â | Â | Â | Â | Â | E | Executed |
| Â | Â | Â | Â | Â | Â | P | Saved Parameters |
| Remarks | Description | nVarChar | 254 | - | Â | Â | Â |
| WizType | Wizard Type | VarChar | 1 | - | A | A | Gross Profit Adjustment Wizard |
| Â | Â | Â | Â | Â | Â | R | Production Cost Recalculation Wizard |
| nGPAdj | Number of Gross Profits Recalculated | Int | 11 | - | Â | Â | Â |
| nPCAdj | Number of Product Costs Recalculated | Int | 11 | - | Â | Â | Â |
| nGPFail | Number of Gross Profit Recalculations Failed | Int | 11 | - | Â | Â | Â |
| nPCFail | Number of Failed Product Cost Recalculations | Int | 11 | - | Â | Â | Â |
| nJECreate | Number of Journal Entries Created | Int | 11 | - | Â | Â | Â |
| nMRVCreate | Number of MRV Created | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |