ME142808 - ME_AutoRec_Trx_Codes
SQL Query Builder
14 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| MEBANKID | char(21) '' | ||||
| ME_Transaction_Type | smallint 0 | ||||
| ME_Transaction_Code | char(41) '' | ||||
| DOCTYPE | smallint 0 | ||||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| ACTINDX | Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | int 0 | |||
| ACTNUMBR_1 | char(5) '' | ||||
| ACTNUMBR_2 | char(5) '' | ||||
| TRX_CODE_DESC | char '' | ||||
| ACTNUMBR_3 | char(5) '' | ||||
| ACTNUMBR_4 | char(5) '' | ||||
| ACTNUMBR_5 | char(5) '' | ||||
| DistRef | char(31) '' | ||||
| DSCRIPTN | char(31) '' | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with ME142808. Click "Join" to add to your query.