Module List >
Module WS tables
WS10101
You are currently viewing the COMPANY
database.
Change
|
COMPANY..WS10101 Table Definition
(COMPANY..WS_PO_Line)
Field Definitions:
What is the 'source' column?
| PONUMBER |
char(17)
|
PO Number ...(more) Join Now
|
POP10110.PONUMBER
|
|
|
| ORD |
int
|
Ord Unique...(more) Join Now
|
BM00111.ORD
|
|
|
| Product_Indicator |
smallint
|
Product In...(more) Join Now
|
POP10110.Product_Indicator
|
|
|
| JOBNUMBR |
char(17)
|
Job Number...(more) Join Now
|
POP10110.JOBNUMBR
|
|
|
| COSTTYPE |
smallint
|
Cost Code ...(more) Join Now
|
POP10110.COSTTYPE
|
|
|
| COSTCODE |
char(27)
|
Cost Code ...(more) Join Now
|
POP10110.COSTCODE
|
|
|
| POLNESTA |
smallint
|
PO Line St...(more) Join Now
|
POP10110.POLNESTA
|
|
|
| POSTATUS |
smallint
|
PO Status ...(more) Join Now
|
POP30100.POSTATUS
|
|
|
| QTYORDER |
numeric(19,5)
|
QTY Ordered: The quantity ordered on the line item.
|
POP10210.QTYORDER
|
|
|
| QTYCOMTD |
numeric(19,5)
|
QTY Commit...(more) Join Now
|
IV10200.QTYCOMTD
|
|
|
| QTYINVCD |
numeric(19,5)
|
QTY Invoic...(more) Join Now
|
POP10500.QTYINVCD
|
|
|
| QTYCANCE |
numeric(19,5)
|
QTY Cancel...(more) Join Now
|
SVC35601.QTYCANCE
|
|
|
| QTYREJ |
numeric(19,5)
|
QTY Reject...(more) Join Now
|
POP10500.QTYREJ
|
|
|
| QTY_Actual |
numeric(19,5)
|
|
|
|
|
| UNITCOST |
numeric(19,5)
|
Unit Cost:...(more) Join Now
|
IV10001.UNITCOST
|
|
|
| Retention_Pct |
numeric(19,5)
|
|
|
|
|
| Retention_Amount_TTD |
numeric(19,5)
|
|
|
|
|
| TAXAMNT |
numeric(19,5)
|
Tax Amount...(more) Join Now
|
RM20101.TAXAMNT
|
|
|
| FRTAMNT |
numeric(19,5)
|
Freight Am...(more) Join Now
|
PM10000.FRTAMNT
|
|
|
| Committed_Cost |
numeric(19,5)
|
|
|
|
|
| Actual_Total_Cost |
numeric(19,5)
|
|
|
|
|
| WSPOText |
char(15)
|
|
|
|
|
| QTYRTRND |
numeric(19,5)
|
QTY Return...(more) Join Now
|
SOP30300.QTYRTRND
|
|
|
| RetUnitCost |
numeric(19,5)
|
|
|
|
|
| RetTotalCost |
numeric(19,5)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| TXTFIELD |
text
|
Text Field...(more) Join Now
|
SY03900.TXTFIELD
|
|
|
|