WS10101 - Wennsoft PO Integration
SQL Query Builder
27 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| PONUMBER | char(17) | |||
| ORD | int | |||
| Product_Indicator | smallint | |||
| JOBNUMBR | char(17) | |||
| COSTTYPE | smallint | |||
| COSTCODE | char(27) | |||
| POLNESTA | smallint | |||
| POSTATUS | smallint | |||
| QTYORDER | numeric(19,5) | |||
| QTYCOMTD | numeric(19,5) | |||
| QTYINVCD | numeric(19,5) | |||
| QTYCANCE | numeric(19,5) | |||
| QTYREJ | numeric(19,5) | |||
| QTY_Actual | numeric(19,5) | |||
| UNITCOST | numeric(19,5) | |||
| Retention_Pct | numeric(19,5) | |||
| Retention_Amount_TTD | numeric(19,5) | |||
| TAXAMNT | numeric(19,5) | |||
| FRTAMNT | numeric(19,5) | |||
| Committed_Cost | numeric(19,5) | |||
| Actual_Total_Cost | numeric(19,5) | |||
| WSPOText | char(15) | |||
| QTYRTRND | numeric(19,5) | |||
| RetUnitCost | numeric(19,5) | |||
| RetTotalCost | numeric(19,5) | |||
| DEX_ROW_ID | int auto number (1,1) | |||
| TXTFIELD | text |
Related Tables
Tables that share columns with WS10101. Click "Join" to add to your query.