|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Product Cost Adjustment - Recalculation of Product Cost
Table Name: GPA5
Table Description: Product Cost Adjustment - Recalculation of Product Cost
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Key | Int | 11 | OGPA | Â | Â | Â |
| LineId | Row No. | Int | 11 | - | Â | Â | Â |
| Selected | Choose | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| LnType | Choose | VarChar | 1 | - | O | P | Product Serial/Batch Line |
| Â | Â | Â | Â | Â | Â | O | Production Order Line |
| ProdCode | Product Code | nVarChar | 50 | - | Â | Â | Â |
| ProdDescr | Product Description | nVarChar | 200 | - | Â | Â | Â |
| PODocAbs | PO Document Abs. Entry | Int | 11 | - | Â | Â | Â |
| PODocNum | PO Document Number | Int | 11 | - | Â | Â | Â |
| DocType | Choose | VarChar | 1 | - | I | I | Issue for Production |
| Â | Â | Â | Â | Â | Â | R | Receipt from Production |
| DocAbs | Document Abs. Entry | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| DocLineNum | Document Line Number | Int | 11 | - | Â | Â | Â |
| PostDate | Posting Date | Date | 8 | - | Â | Â | Â |
| ItemCode | Item No. | nVarChar | 50 | - | Â | Â | Â |
| ItemDescr | Item Description | nVarChar | 200 | - | Â | Â | Â |
| DistNumber | Batch Number | nVarChar | 36 | - | Â | Â | Â |
| SnBAbs | SnB Abs. Entry | Int | 11 | - | Â | Â | Â |
| ManagedBy | Managed By | Int | 11 | - | -1 | 10000044 | Batch Numbers |
| Â | Â | Â | Â | Â | Â | 10000045 | Serial Numbers |
| Â | Â | Â | Â | Â | Â | -1 | Â |
| LnQty | Line Quantity | Num | 19.6 | - | Â | Â | Â |
| SnBQty | Serial/Batch Quantity | Num | 19.6 | - | Â | Â | Â |
| LnCost | Line Cost | Num | 19.6 | - | Â | Â | Â |
| DebCred | Debited or Credited | VarChar | 1 | - | D | D | Debited |
| Â | Â | Â | Â | Â | Â | C | Credited |
| LnTotal | Line Total | Num | 19.6 | - | Â | Â | Â |
| SnBTotal | SnB Total | Num | 19.6 | - | Â | Â | Â |
| SBAccTotal | Serial/Batch Accumulated Total | Num | 19.6 | - | Â | Â | Â |
| SBAccQty | Serial/Batch Accumulated Quantity | Num | 19.6 | - | Â | Â | Â |
| ACAccTotal | Actual Cost Accumulated Total | Num | 19.6 | - | Â | Â | Â |
| ACAccQty | Actual Cost Accumulated Quantity | Num | 19.6 | - | Â | Â | Â |
| Applied | Applied Adjustment | Num | 19.6 | - | Â | Â | Â |
| Variance | Variance to Apply | Num | 19.6 | - | Â | Â | Â |
| MRVAdjust | MRV Adjustment | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineId |