IF000003 - IF_Distribution_Process_TEMP
Dynamics GP table IF000003 (IF_Distribution_Process_TEMP) contains 16 columns including USERID, BACHNUMB, BCHSOURC....
SQL Query Builder
16 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| USERID | User ID | String | 16 | |
| BACHNUMB | Batch Number | String | 16 | |
| BCHSOURC | Batch Source | String | 16 | |
| JRNENTRY | Journal Entry | Long Integer | 4 | |
| 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 | |
| TRXAMNT | TRX Amount | Currency | 10 | |
| ORIGAMT | Originating Amount | Currency | 10 | |
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | |
| DSCRIPTN | Description | String | 32 | |
| ORCTRNUM | Originating Control Number | String | 22 | |
| ORDOCNUM | Originating Document Number | String | 22 | |
| ORMSTRID | Originating Master ID | String | 32 | |
| ORMSTRNM | Originating Master Name | String | 66 | |
| ORTRXTYP | Originating TRX Type | Integer | 2 | |
| ORTRXDESC | Originating TRX Description | String | 32 | |
| OrigSeqNum | Originating Sequence Number | Long Integer | 4 |
Related Tables
Tables that share columns with IF000003. Click "Join" to add to your query.
ORCTRNUM