GP Tables

ENC10114 - ENC Period Actual

Dynamics GP table ENC10114 (ENC Period Actual) contains 7 columns including YEAR1, PERIODID, PERNAME....

SQL Query Builder

7 Columns

Column Description Type Length
YEAR1 Year Integer 2
PERIODID Period ID Integer 2
PERNAME Period Name String 22
ACTINDX Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. Long Integer 4
ACTNUMST Account Number String String 130
DEBITAMT Debit Amount Currency 10
CRDTAMNT Credit Amount Currency 10

Related Tables

Tables that share columns with ENC10114. Click "Join" to add to your query.

PERNAME