ENCAA10110 - Encumbrance AA Purchase Order Line
SQL Query Builder
40 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PONUMBER | char(17) '' | |||
| POLNENUM | int 0 | |||
| aaSubLedgerHdrID | int 0 | |||
| aaSubLedgerDistID | int 0 | |||
| aaSubLedgerAssignID | int 0 | |||
| aaTrxDimID | int 0 | |||
| aaTrxDimCodeID | int 0 | |||
| aaCodeSequence | int 0 | |||
| POLNESTA | smallint 0 | |||
| ENCBSTAT | smallint 0 | |||
| ENCMBAMT | numeric(19,5) 0.00 | |||
| LIQUDAMT | numeric(19,5) 0.00 | |||
| Balance | numeric(19,5) 0.00 | |||
| aaAssignedPercent | int 0 | |||
| LIQUIDAT | tinyint 0 | |||
| INVINDX | int 0 | |||
| ITEMNMBR | char(31) '' | |||
| VENDORID | char(15) '' | |||
| UOFM | char(9) '' | |||
| UMQTYINB | numeric(19,5) 0.00 | |||
| QUANTITY | numeric(19,5) 0.00 | |||
| DECPLCUR | smallint 0 | |||
| DECPLQTY | smallint 0 | |||
| UNITCOST | numeric(19,5) 0.00 | |||
| EXTDCOST | numeric(19,5) 0.00 | |||
| YEAR1 | smallint 0 | |||
| PERIODID | smallint 0 | |||
| REQDATE | datetime '1/1/1900' | |||
| ENCBDATE | datetime '1/1/1900' | |||
| CRUSRID | char(15) '' | |||
| CREATDDT | datetime '1/1/1900' | |||
| MDFUSRID | char(15) '' | |||
| MODIFDT | datetime '1/1/1900' | |||
| DOCDATE | datetime '1/1/1900' | |||
| LINEORIGIN | smallint 0 | |||
| POTYPE | smallint 0 | |||
| LineNumber | smallint 0 | |||
| ProjNum | char '' | |||
| DEX_ROW_ID | int auto number (1,1) | |||
| CostCatID | char '' |
Related Tables
Tables that share columns with ENCAA10110. Click "Join" to add to your query.