Module List > Module WS tables WS10101
You are currently viewing the COMPANY database.
Change

COMPANY..WS10101 Table Definition

(COMPANY..WS_PO_Line)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3