ME123501 - ME PP Bank Upload MSTR
SQL Query Builder
23 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PP_Number | char(21) '' | |||
| MEBANKID | char(21) '' | |||
| Output_Format | char(21) '' | |||
| BANKID | char(15) '' | |||
| BANKNAME | char(31) '' | |||
| BNKBRNCH | char(21) '' | |||
| PHONE1 | char(21) '' | |||
| PHONE2 | char(21) '' | |||
| HYPELINK | tinyint 0 | |||
| DLFILAPTH | char(81) '' | |||
| HYPEPATH | char(81) '' | |||
| MEINCWFT | tinyint 0 | |||
| MEUPLDID | char(21) '' | |||
| MKLSSTDD | datetime '1/1/1900' | |||
| MEUPTIM | datetime '1/1/1900' | |||
| ME_Number_of_Checks | smallint 0 | |||
| ME_Checks_Amount | numeric(19,5) 0.00 | |||
| ME_Number_of_Voids | smallint 0 | |||
| ME_Voids_Amount | numeric(19,5) 0.00 | |||
| ME_Confirmation_Number | char(21) '' | |||
| Last_Reconciled_Date | datetime '1/1/1900' | |||
| Last_Reconciled_Balance | numeric(19,5) 0.00 | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with ME123501. Click "Join" to add to your query.