GP Tables

coPeriod - Period Cache

Dynamics GP table coPeriod (Period Cache) contains 7 columns including SERIES, ODESCTN, PERIODDT....

SQL Query Builder

7 Columns

Column Description Type Length
SERIES Series1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll - USA7 = Project Integer 2
Module Series values (8)
1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party
ODESCTN Origin Description String 52
PERIODDT Period Date Date 4
PERIODID Period ID Integer 2
CLOSED Origin Closed Boolean 2
YEAR1 Year Integer 2
ERROR Error Integer 2