Home > Technical > Table Definitions > 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. |
STRNORMALCURRENCYCODE | VARCHAR(5) | The currency code of the current normal sell. |
STRPROPOSEDCURRENCYCODE | VARCHAR(5) | The currency code of the current normal cost. |
Primary Key: LINTITEMNUMBER + STRSELLTRADEUNIT + DTMPROPOSEEFFECTIVE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |