Wennsoft PO Integration Archive (WS30101)

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: Wennsoft PO Integration HIST
Physical Name: WS30101
Technical Name: WS_PO_Line_HIST

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PONUMBER	PO Number	STR17_POP_Number	String	17
2	ORD	Ord	LI_Sequence_Number	Long Integer	10
3	Product_Indicator	Product Indicator	DDL_Product_Indicator	Integer	0
4	JOBNUMBR	Job Number	STR17_LBAU	String	17
5	COSTTYPE	Cost Code Type	INT3_RB0_U	Integer	3
6	COSTCODE	Cost Code	STR27	String	27
7	POLNESTA	PO Line Status	DDL_PO_Line_Status	Integer	0
8	POSTATUS	PO Status	DDL_PO_Status	Integer	0
9	QTYORDER	QTY Ordered	DLR17_QTY_RBS0_UTR	Currency	17
10	QTYCOMTD	QTY Committed	DLR17_QTY_RBS0_UTR	Currency	17
11	QTYINVCD	QTY Invoiced	DLR17_QTY_RBS0_UTR	Currency	17
12	QTYCANCE	QTY Canceled	DLR17_QTY_RBS0_UTR	Currency	17
13	QTYREJ	QTY Rejected	DLR17_QTY_RBS0_UTR	Currency	17
14	QTY_Actual	QTY Actual	DLR17_QTY_RBS0_UTR	Currency	17
15	UNITCOST	Unit Cost	DLR17_RBS0_UTR$	Currency	17
16	Retention_Pct	Retention %	DLR14_TS	Currency	14
17	Retention_Amount_TTD	Retention Amount TTD	DLR14_TS	Currency	14
18	TAXAMNT	Tax Amount	DLR17_RBS0_UTR$	Currency	17
19	FRTAMNT	Freight Amount	DLR17_RBS0_UTR$	Currency	17
20	Committed_Cost	Committed Cost	DLR19_TS	Currency	19
21	Actual_Total_Cost	Actual Total Cost	DLR14_RBS0_STR$	Currency	14
22	WSPOText	WSPOText	STR15_LBAU	String	15
23	QTYRTRND	QTY Returned	DLR17_QTY_RBS0_UTR	Currency	17
24	RetUnitCost	Returned Unit Cost	DLR17_RBS0_STR$	Currency	17
25	RetTotalCost	Returned Total Cost	DLR17_RBS0_STR$	Currency	17
26	TXTFIELD	Text Field	TX32000	Text	32000