JC40602 - JC_Period_Setup
SQL Query Builder
15 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CLOSED | tinyint | ||||
| SERIES | smallint | ||||
Module Series values (8) 1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party | |||||
| ODESCTN | char(51) | ||||
| FORIGIN | tinyint | ||||
| PERIODID | smallint | ||||
| PERIODDT | datetime | ||||
| PERNAME | char(21) | ||||
| PSERIES_1 | tinyint | ||||
| PSERIES_2 | tinyint | ||||
| PSERIES_3 | tinyint | ||||
| PSERIES_4 | tinyint | ||||
| PSERIES_5 | tinyint | ||||
| PSERIES_6 | tinyint | ||||
| YEAR1 | smallint | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with JC40602. Click "Join" to add to your query.
CLOSED