Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WS30101
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: Wennsoft PO Integration HIST
Physical Name: WS30101
Technical Name: WS_PO_Line_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 PONUMBER 
PO Number STR17_POP_Number String 18 17 2 ORD Ord LI_Sequence_Number Long Integer 4 10 3 Product_Indicator Product Indicator DDL_Product_Indicator Integer 2 0 4 JOBNUMBR Job Number STR17_LBAU String 18 17 5 COSTTYPE Cost Code Type INT3_RB0_U Integer 2 3 6 COSTCODE Cost Code STR27 String 28 27 7 POLNESTA PO Line Status DDL_PO_Line_Status Integer 2 0 8 POSTATUS PO Status DDL_PO_Status Integer 2 0 9 QTYORDER QTY Ordered DLR17_QTY_RBS0_UTR Currency 10 17 10 QTYCOMTD QTY Committed DLR17_QTY_RBS0_UTR Currency 10 17 11 QTYINVCD QTY Invoiced DLR17_QTY_RBS0_UTR Currency 10 17 12 QTYCANCE QTY Canceled DLR17_QTY_RBS0_UTR Currency 10 17 13 QTYREJ QTY Rejected DLR17_QTY_RBS0_UTR Currency 10 17 14 QTY_Actual QTY Actual DLR17_QTY_RBS0_UTR Currency 10 17 15 UNITCOST Unit Cost DLR17_RBS0_UTR$ Currency 10 17 16 Retention_Pct Retention % DLR14_TS Currency 10 14 17 Retention_Amount_TTD Retention Amount TTD DLR14_TS Currency 10 14 18 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 10 17 19 FRTAMNT Freight Amount DLR17_RBS0_UTR$ Currency 10 17 20 Committed_Cost Committed Cost DLR19_TS Currency 10 19 21 Actual_Total_Cost Actual Total Cost DLR14_RBS0_STR$ Currency 10 14 22 WSPOText WSPOText STR15_LBAU String 16 15 23 QTYRTRND QTY Returned DLR17_QTY_RBS0_UTR Currency 10 17 24 RetUnitCost Returned Unit Cost DLR17_RBS0_STR$ Currency 10 17 25 RetTotalCost Returned Total Cost DLR17_RBS0_STR$ Currency 10 17 26 TXTFIELD Text Field TX32000 Text 2 32000