biuan SAP® BUSINESS ONE SDK
SQL Administration / Government Payment Code
DTW Inventory / Bin Locations
API OGPC
OGPC - Government Payment Code Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEInternal NumberInt
11
PRIMARYYes
Code KEY UNIQUECodenVarChar
6
CODEYes
DescrDescriptionnVarChar
100
StateTaxReporting by StateVarChar
Y) Yes
N) No
1
N
PrdcityPeriodicityVarChar
M) Monthly
Q) Quarterly
H) Semimonthly
T) Every 10 Days
1
M
SPEDCtgorySPED CategoryInt
11

SELECT statement

SELECT OGPC.AbsId AS 'Internal Number', OGPC.Code AS 'Code', OGPC.Descr AS 'Description', OGPC.StateTax AS 'Reporting by State', OGPC.Prdcity AS 'Periodicity', OGPC.SPEDCtgory AS 'SPED Category' FROM OGPC AS OGPC

Related information


OGPC SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates