Home > Technical > Table Definitions > PROPOSEDSELLS

PROPOSEDSELLS

When new sells are proposed for cost changes as part of EOD processing, they are stored in this table. They are then used for the Proposed Sells Report.

Column Type Description
STRSELLTRADEUNIT VARCHAR(10) A unique code, assigned by the user, to identify a device. All devices in the entire location will have a unique code.
TRADUNIT.strTradeCode
LINTITEMNUMBER INT The item that the sell is for.
ITEM.lintItemNumber
DTMPROPOSEEFFECTIVE DATETIME The date the sell will become effective.
STRINCREASE VARCHAR(10) An 'I if the cost price has increased, 'D' if a decrease.
CURNORMALCOST DECIMAL(19,4) The current normal cost.
CURNORMALLANDEDCOST DECIMAL(19,4) The current normal landed cost.
INTCARTONSIZE DECIMAL(9,3) The current carton size.
STRSUPPLIERCODE VARCHAR(10) The current supplier code.
STRORDERCODE VARCHAR(20) The current order code.
CUREXTAXCOST DECIMAL(19,4) The current normal ex-tax cost.
CURNORMALSELL DECIMAL(19,4) The current normal sell.
CURNORMALSELL2 DECIMAL(19,4) The second current normal sell.
CURNORMALSELL3 DECIMAL(19,4) The third current normal sell.
CURNORMALSELL4 DECIMAL(19,4) The fourth current normal sell.
CURNORMALSELL5 DECIMAL(19,4) The fifth current normal sell.
DBLNORMALMARGIN DECIMAL(19,4) The first current normal margin.
DBLNORMALMARGIN2 DECIMAL(19,4) The second current normal margin.
DBLNORMALMARGIN3 DECIMAL(19,4) The third current normal margin.
DBLNORMALMARGIN4 DECIMAL(19,4) The fourth current normal margin.
DBLNORMALMARGIN5 DECIMAL(19,4) The fifth current normal margin.
CURPROPOSECOST DECIMAL(19,4) The new cost that the sell price is based on.
CURPROPOSELANDEDCOST DECIMAL(19,4) The new landed cost that the sell price is based on.
CURPROPOSESELL DECIMAL(19,4) The new proposed sell.
CURPROPOSESELL2 DECIMAL(19,4) The second new proposed sell.
CURPROPOSESELL3 DECIMAL(19,4) The third new proposed sell.
CURPROPOSESELL4 DECIMAL(19,4) The fourth new proposed sell.
CURPROPOSESELL5 DECIMAL(19,4) The fifth new proposed sell.
DBLPROPOSEMARGIN DECIMAL(19,4) The new proposed normal margin.
DBLPROPOSEMARGIN2 DECIMAL(19,4) The new second proposed normal margin.
DBLPROPOSEMARGIN3 DECIMAL(19,4) The new third proposed normal margin.
DBLPROPOSEMARGIN4 DECIMAL(19,4) The new fourth proposed normal margin.
DBLPROPOSEMARGIN5 DECIMAL(19,4) The new fifth proposed normal margin.
LINTPROPOSECOSTCODE INT The code of the new cost record.
COST.ctrCode
INTPROPOSESIZE INT The carton size of the new cost.
CURPROPOSENETTCOST DECIMAL(19,4) The new ex-tax cost.
STRPROPOSESUPPLIERCODE VARCHAR(10) The supplier of the new cost.
STRPROPOSEORDERCODE VARCHAR(20) The new order code for the item that has the new cost.
STRTYPE VARCHAR(5) Not used.
LINTRANGECODE INT The code of the range record that the new cost is for.
RANGE.lintRangeCode
YSNWARNDOLLARMARGIN VARCHAR(1) No longer used.
YSNWARNEXCEEDSELL VARCHAR(1) No longer used.
STREXPECTEDSELLTAX VARCHAR(10) 'No longer used.
CURPROPOSEGP DECIMAL(19,4) The proposed GP based on the expected cost, the expected sell tax, sell price 1.
CURPROPOSEGP2 DECIMAL(19,4) The proposed GP based on the expected cost, the expected sell tax, sell price 2.
CURPROPOSEGP3 DECIMAL(19,4) The proposed GP based on the expected cost, the expected sell tax, sell price 3.
CURPROPOSEGP4 DECIMAL(19,4) The proposed GP based on the expected cost, the expected sell tax, sell price 4.
CURPROPOSEGP5 DECIMAL(19,4) The proposed GP based on the expected cost, the expected sell tax, sell price 5.
STRREASON VARCHAR(20) The reason why this item was checked, for example 'Cost Change', 'Supplier Terms', and so on
STRPROPOSESELLCURRENCYCODE VARCHAR(5) The currency code of the proposed sell price.

CURRENCYCODE.strCurrencyCode

STRNORMALCURRENCYCODE VARCHAR(5) The currency code of the current normal sell.

CURRENCYCODE.strCurrencyCode

STRPROPOSEDCURRENCYCODE VARCHAR(5) The currency code of the current normal cost.

CURRENCYCODE.strCurrencyCode

 

Primary Key: LINTITEMNUMBER + STRSELLTRADEUNIT + DTMPROPOSEEFFECTIVE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)