ENC10500 - Encumbrance Received Transactions
SQL Query Builder
23 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PONUMBER | char(17) '' | |||
| POLNENUM | int 0 | |||
| POPTYPE | smallint 0 | |||
| POPRCTNM | char(17) '' | |||
| RCPTLNNM | int 0 | |||
| Status | smallint 0 | |||
| GLPOSTDT | datetime '1/1/1900' | |||
| TRXDATE | datetime '1/1/1900' | |||
| YEAR1 | smallint 0 | |||
| PERIODID | smallint 0 | |||
| QTYSHPPD | numeric(19,5) 0.00 | |||
| QTYINVCD | numeric(19,5) 0.00 | |||
| QTYRESERVED | numeric(19,5) 0.00 | |||
| INVINDX | int 0 | |||
| UOFM | char(9) '' | |||
| UMDPQTYS | smallint 0 | |||
| UMQTYINB | numeric(19,5) 0.00 | |||
| OREXTCST | numeric(19,5) 0.00 | |||
| LIQUDAMT | numeric(19,5) 0.00 | |||
| REQDATE | datetime '1/1/1900' | |||
| aaDimID | int 0 | |||
| aaTrxDimID | int 0 | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with ENC10500. Click "Join" to add to your query.