|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Government Payment Code
Table Name: OGPC
Table Description: Government Payment Code
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsId | Internal Number | Int | 11 | - | Â | Â | Â |
| Code | Code | nVarChar | 6 | - | Â | Â | Â |
| Descr | Description | nVarChar | 100 | - | Â | Â | Â |
| StateTax | Reporting by State | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Prdcity | Periodicity | VarChar | 1 | - | M | M | Monthly |
| Â | Â | Â | Â | Â | Â | Q | Quarterly |
| Â | Â | Â | Â | Â | Â | H | Semimonthly |
| Â | Â | Â | Â | Â | Â | T | Every 10 Days |
| SPEDCtgory | SPED Category | Int | 11 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | 1 | ICMS |
| Â | Â | Â | Â | Â | Â | 2 | ICMS-ST |
| Â | Â | Â | Â | Â | Â | 3 | IPI |
| Â | Â | Â | Â | Â | Â | 4 | ISS |
| Â | Â | Â | Â | Â | Â | 5 | PIS |
| Â | Â | Â | Â | Â | Â | 6 | COFINS |
| Â | Â | Â | Â | Â | Â | 7 | PIS-ST |
| Â | Â | Â | Â | Â | Â | 8 | COFINS-ST |
| Key | Unique | Field |
| PRIMARY | Yes | AbsId |
| CODE | Yes | Code |