Home > Technical > Table Definitions > CUSTORDERITEM

CUSTORDERITEM

Column Type Description
INTORDERCODE BIGINT The transaction number to which the tender belongs.
CUSTORDERHDR.CTRCODE
CTRCODE INT A unique number assigned by the system.
STRTYPE VARCHAR(1) The type of item.
I   A normal item.
M   A set meal ingredient item.
C Comment
G Return item
E Cancelled item
K Cancelled comment
L Cancelled modifier
N Cancelled set meal

LINTITEMNUMBER

INT

The number of the item.
ITEM.lintItemNumber

STRPOS20DESCRIPTION

VARCHAR(20)

The POS 20 description of the item.

CURSELLPRICE

DECIMAL(19,4)

The sell price of the item.

DBLQUANTITY

DECIMAL(19,4)

Quantity of item sold.

CUREXTENDEDSALE

DECIMAL(19,4)

Total value of the item sold.

DBLAPN

DECIMAL(19,4)

Not used.

STRDEPTCODE

VARCHAR(10)

The department code of the item. Copied in when the item is added. The details are need to do things like calculate discounts when the sale is finally paid.

STRCATCODE

VARCHAR(10)

The category code of the item. Copied in when the item is added. The details are need to do things like calculate discounts when the sale is finally paid.

STRGROUPCODE

VARCHAR(10)

The group code of the item. Copied in when the item is added. The details are need to do things like calculate discounts when the sale is finally paid.

STRCLASSCODE

VARCHAR(10)

The class code of the item. Copied in when the item is added. The details are need to do things like calculate discounts when the sale is finally paid.

STRPRICEFLAG

VARCHAR(1)

Indicates the price level of the sell used. '1'-'5'. 'P' if the price was changed by the user.

CURNORMALSELL

DECIMAL(19,4)

The sell price of the item as it was when the item was originally added (before any possible price changes).

CURDISCOUNT

DECIMAL(19,4)

The total item discount.

INTDISCOUNTCODE

INT

The code of the discount used for the item discount.

INTOFFERCODE

INT

The code of the discount used for the offer discount.

LINTPARENTITEM

INT

The parent IPN of the item on this transaction.

ITEM.lintItemNumber

DBLDISCOUNTPER

DECIMAL(19,4)

Not used.

YSNPRINTED

VARCHAR(1)

Not used. Always 'F'.

YSNCHANGEQTY

VARCHAR(1)

Not used. Always 'F'.

LINTDELIVERYADDRESS

INT

Not used.

CURSALESTAX

DECIMAL(19,4)

Not used.

LINTGIFTNUM

VARCHAR(10)

The first gift certificate number sold. If we sold a range of numbers, the STRGIFTNUMTO stores the last number in the sequence.

INTWARRANTYMONTHS

INT

The number of warranty months for this item. Initially copied in from the item but extra warranties were sold, this will include the extra number of months.

STRCOMMENT

VARCHAR(100)

A comment about the item.

CURCOGS

DECIMAL(19,4)

The cost of goods sold. Would be filled in for a return to indicate the original cost of goods.

CURCOGSREBATE

DECIMAL(19,4)

The rebate on cost of goods sold. Would be filled in for a return to indicate the original cost of goods rebate.

STRTAXCODE1

VARCHAR(10)

If using a US Sales tax system, this will be the ITEMTAXGROUP.strPurchaseGroupCode. (Yes the name doesn't indicate that but its the way its used.)

Otherwise, it will be the CESS tax code, if the item is marked to use CESS. A value of 'ex' indicates the CESS was exempted for this transactions.

STRTAXCODE2

VARCHAR(10)

The tax code of the GST/VAT tax charged on the item.

ITEMTAXGROUP.strSalesGroupCode

STRTAXCODE3

VARCHAR(10)

If using a US Sales tax system, this will be the  this will be the ITEMTAXGROUP.strWETGroupCode. (Yes the name doesn't indicate that but its the way its used.).

Otherwise, it will be the Service Fee tax code, if the item is marked to use Service Fee. A value of 'ex' indicates the Service Fee was exempted for this transactions.

CURTAXAMT1

DECIMAL(19,4)

The total tax charged for STRTAXCODE1.

CURTAXAMT2

DECIMAL(19,4)

The total tax charged for STRTAXCODE2.

CURTAXAMT3

DECIMAL(19,4)

The total tax charged for STRTAXCODE3.

CURSELLPRICE1

DECIMAL(19,4)

The level 1 sell price of the item when it was added to the transaction.

CURSALESDISCOUNT

DECIMAL(19,4)

Total sales discount on the item.

INTOPERATORID

INT

The number of the user who added the item to the transaction.

USERCODE.INTUSERCODE

STRSUBGROUPCODE

VARCHAR(10)

The subgroup of the item. Copied in when the item is added. The details are need to do things like calculate discounts when the sale is finally paid.

DTMSALESDATETIME

DATETIME

The date/time the item was added to the transaction.

INTSALESDISCOUNTCODE

INT

The code of the discount used for the sale discount.

CUROFFERDISCOUNT

DECIMAL(19,4)

Total value of the offer discount for the item.

YSNDISCOUNTABLE

VARCHAR(1)

'F' if the item can be discounted. Copied in when the item is added.

INTTENDERDISCOUNTCODE

INT

The code of the discount used for the tender discount.

CURTENDERDISCOUNT

DECIMAL(19,4)

The total value of the tender discount for this item.

STRSELLTYPE

VARCHAR(10)

The sell type of the sell price used, for example Normal or Promo.

STRTRADECODE

VARCHAR(10)

The location where this item was originally added.
TRADUNIT.strTradeCode

STRORDERCODE

VARCHAR(20)

The order code of the item sold.

YSNPACKAGEINGREDIENT

VARCHAR(1)

Not used.

STRFAMILYCODE

VARCHAR(10)

The family code of the item. Copied in when the item is added. The details are need to do things like calculate discounts when the sale is finally paid.

STRPOS12DESCRIPTION

VARCHAR(12)

Not used.

LINTORIGTRANS

BIGINT

When a return is made by matching to an existing sale, this is the DAILYSALES.INTTRANSNUM of the original transaction.

DAILYSALES.intTransNum

On a non-return transaction, if an item was copied , this is the INTTRANSNUM of the original transaction to which the item belonged.

LINTORIGLINECODE

BIGINT

When a return is made by matching to an existing sale, this is the DAILYSALES.CTRCODE of the original transaction.

DAILYSALES.ctrCode

On a non-return transaction, if an item is copied from one transaction to another, this is the line number of the item in the original transaction, which is equivalent to CTRCODE

DBLAVAILABLETORETURN

DECIMAL(19,4)

Contains the quantity that is available to be returned. When a return transaction is matched to an existing transaction, the system calls LoadFromDailySales to build a transaction from the DAILYSALES information. This field will be set to the quantity originally sold less any returns already done. Doesn't appear to be used at POS.

INTSOHCHECKMETHOD

INT

If a SOH check was done, indicates the method used.

0  

POS BE inventory.

1  

WMS interface (for Taiwan).

STRTRACKSERIALNUM

VARCHAR(1)

Indicates if we need to track serial numbers.

T  

Track our serial number.

S  

Track supplier serial number.

B  

Track batch/expiry date.

F  

Do not track.

STRKITCHENCODE

VARCHAR(10)

The kitchen code of the item. Copied in when the item is added. Needed for kitchen printing.

LINTORIGITEMNUMBER

INT

Usually same as LINTITEMNUMBER. If the item is a replacement set meal ingredient, this is the item number of the original set meal ingredient item. Allows kitchen printing to show the item has changed. 

INTPRICETYPE

INT

Indicates the method of replacement sell price for a replacement set meal ingredient.

STRAPN

VARCHAR(20)

The barcode that was scanned to sell the item.

CURORIGSELL

DECIMAL(19,4)

The original sell price of the item. Used on set meal ingredients when the item is replaced with another one which triggers a price change. This field stores the original price of the original item. So if we make further replacements to the item, we have the original starting point for any price adjustments.

STRROUTECODE

VARCHAR(10)

Not used.

STRREPLTRADECODE

VARCHAR(10)

Not used in standard system. Some sites may use it to add replication in which case it would be set by a trigger.

STRITEMMENU

VARCHAR(10)

The item menu of the item.

INTDELIVERYSOURCE

INT

Indicates where the item should be delivered.

0  

Deliver from item in stock.

1  

Deliver from warehouse.

2  

Deliver direct from supplier.

3  

Deliver this store from transferred stock.

4  

Deliver this store from ordered stock.

5  

Deliver direct from other store.

STRDELIVERYCODE

VARCHAR(10)

If INTDELIVERYSOURCE indicates another location, this is the code of the location. If it indicates a supplier is involved, it is the code of the supplier.

INTSALESMETHOD

INT

The sales method used to sell the item. Indicates if the item was eat in or takeaway. ?

DTMSTARTTIME

DATETIME

The start time of the item. Used for items which are sold by time.

DTMENDTIME

DATETIME

The end time of the item. Used for items which are sold by time.

YSNMANUALLYWEIGHED

VARCHAR(1)

'T' if the item was manually weighed.

STRUNITOFMEASURE

VARCHAR(10)

The unit of measure of the item. Copied in when the item is added.

LINTORIGORDER

BIGINT

Usually 0. If a return item that was matched to an existing sale, this is the INTORDERCODE of the original DAILYSALES record the item was copied from.

DAILYSALES.INTORDERCODE

INTITEMDISCREASON

INT

The reason code that explains why an item discount was given.
REASONS.INTCODE

INTSALEDISCREASON

INT

The reason code that explains why a sale discount was given.

REASONS.INTCODE

DBLOLDQUANTITY

DECIMAL(19,4)

The quantity of the item printed so far. If a sale is later cancelled, we can use this to determine how much was already printed and therefore how much to print as the cancelled quantity.

DTMPOSCREDITEXPIRY

DATETIME

The expiry date of the gift certificates that were sold.

INTCHGPRICEREASON

INT

The reason code that explains why a sell price was changed.

REASONS.INTCODE

DBLREFQUANTITY

DECIMAL(19,4)

Not used.

STRGIFTNUMTO

VARCHAR(10)

If we sold a range of gift certificates, this is the last number in the range.

STRTVLA

VARCHAR(1)

The TVLA type of the item. Copied in when the item is added.

STRPRODUCTBRANDNAME

VARCHAR(30)

The brandname of the item. Copied in when the item is added. The details are need to do things like calculate discounts when the sale is finally paid.

INTAUTHORISEUSER

INT

The user who authorised any item specific actions that were secured against normal use.

USERCODE.INTUSERCODE

STRSEASONCODE

VARCHAR(10)

The season of the item.

STRYEARCODE

VARCHAR(4)

The year of the item.

STRFSACATEGORY

VARCHAR(20)

 

INTPARENTITEM

INT

If the entry is of type modifier (STRTYPE=M), it will store the item number of the item it has been selected for.

STRMODIFIERCODE

VARCHAR(10)

If the entry is of type modifier (STRTYPE=M), it will store the MODIFIERCODE it belongs to in the MODIFIERHDR table.

YSNSALESTAXAMENDED

VARCHAR(1)

Has the sales tax been amended for this item?

STRORIGTAXCODE1

VARCHAR(10)

Original tax group 1 code for this item (not currently used).

STRORIGTAXCODE2

VARCHAR(10)

Original sales tax group for this item.

STRORIGTAXCODE3

VARCHAR(10)

Original tax group 3 code for this item (not currently used).

 

Primary Key: INTORDERCODE + CTRCODE

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