Visual Catpro
|
Visual Catpro
|
|
|
Property
|
Description
|
DB Field
|
|
ABETMENT
|
|
AbetmentRate
|
|
ABSOLUTE_DISCOUNT
|
You may add this column if you want to
give item wise discount in rupees. If does
not effect the Rate of the amount.
|
VDiscountAmt
|
|
ADD_AMOUNT
|
You may add this column if you want to
add any additional item wise charges.
|
AddAmount
|
|
ADD_LESS_KGS
|
|
AddLessKgs
|
 ADD_RATE |
|
|
|
ADD_RATE_PER
|
|
|
|
ALIAS
|
You may add this column if you want to
view the alias of the item. Alias may be
enter in stock master. This field is read only
in doc columns.
|
qAlias1
|
|
ALT_QTY
|
|
|
|
AMOUNT
|
This column shows the total amount of an
item. This is column is a read only column.
|
Amount
|
|
AMT_BEFORE_DISCOUNT
|
This column shows the total amount of an
item. It is similar to AMOUNT column but if
u have any discount column then this
column stores the total amount before
discount. Where as AMOUNT column stores
total amount after discount. This is column
is a read only column.
|
GAmount
|
|
AMT_FOR_QTY
|
Sometimes we want to enter the rate and
the total amount and we want it
automatically calculates the quantity. In
such case you may add this column. You fill
the rate and total amount in this column it
auto calculates the quantity.
|
Amt_for_Qty
|
|
AMT_FOR_RATE
|
It is similar to AMT_FOR_QTY column but
instead of calculating quantity it calculates
the rate after filling quantity and total
amount.
|
Amt_for_Rate
|
|
ASS_RATE
ASS_VALUE
BAG_CODE
|
|
|
|
BATCH_NO
|
This column is for selecting Batch no. while
entering items. It is specially required when
we designing a pharmaceutical company's
invoice. Where stock is managed against
batch numbers.
|
BatchNo
|
|
BOTTOM_DISCOUNT
|
This field is generally required when we
want to give item wise discount and instead
of printing discount in columns we want to
print the discount in totals. In such case
you have to add this column and also add
BOTTOM_DISCOUNT field in DocTotals.
|
BottomDiscount
|
|
BOTTOM_DISCOUNT_NTX
|
Read BOTTOM_DISCOUNT
|
BottomDiscount3
|
|
BOTTOM_DISCOUNT2
|
Read BOTTOM_DISCOUNT
|
BottomDiscount2
|
|
BOX_FROM
BOX_TO
BOX_RATE
BOX_WT
|
All four fields are used for designing a
packing list. It does not effect any
calculation.
|
BoxFrom
BoxTo
BoxRate
BoxWt
|
|
BRAND
|
This field is used for entering brand name
for each item.
|
Brand
|
|
CHALLAN_DATE
|
This is used for Challan Processing. This
stores the Challan Date.
|
ChallanDate
|
|
CHALLAN_NO
|
This is used for Challan Processing. This
stores the Challan Number.
|
ChallanNo
|
|
CHASIS_NO
CHR_JOINT
CHR_QTY
|
|
|
|
COLOR
|
This field is used for entering color for each
item.
|
Color
|
|
CUSTOMER_ID
|
This field is used for selecting any account
with the item. This field may be printed by
specifying rv("addline1") in expression
field.
|
|
|
DIAMOND_QTY
|
|
|
|
DISCOUNT
|
This column is used for applying discount in
%. If you use this column then you also
have to add REVISED_RATE. Discount
column reduce the rate and get the
discounted rate in REVISED_RATE column.
Amount will be calculated on revised rate.
|
VDiscount
|
|
DISCOUNT_AMT
|
This column is useful if you have add
DISCOUNT column. This column shows the
discounted amount.
|
DiscountAmt
|
|
DISCOUNT_PERPC
|
This column is also for giving discount but
instead of discount on whole amount it
gives the discount on per unit basis.
|
VDiscountPer
|
|
DISCOUNT2
|
|
|
|
DUTY_PER_UNIT
|
This is entering excise duty per unit. This
column is required in Excise invoice.
|
DutyPerUnit
|
|
ENGINE_NO
|
This is for entering excise duty per unit.
This column is required in Excise invoice.
|
EngineNo
|
|
EXEMPT_RATE
|
|
|
|
EXPIRY_DATE
|
This is for entering expiry date of product.
This column is required in pharmaceuticals
invoice.
|
ExpiryDate
|
|
FACTOR_DAYS
|
This is for entering factor days. It multiplies
the total amount with factor days. This
column is required when a company is
giving the products on rent and charging
from customer on par day basis.
You may also add CHALLAN_DATE and
GOODS_IN_DATE column to
automatically calculate factor days.
|
FactorDays
|
 FREE_ITEM_DESC |
THIS SHOULD OPEN ITEM SELECTION
GRID
|
|
|
FREE_QUANTITY
|
To specify thee Free Quantity. If Quantity is
zero then quantity becomes Free Quantity.
|
FreeQuantity
|
|
GODOWN
|
To specify the GODOWN name from which
the item is issued.
|
|
|
GOLD_POLISH
|
Gold_Polish
| |
|
GOLD_POLISH_PER
|
Gold_Polish_Per
| |
|
GOLD_PURITY
|
Gold_Purity
| |
|
GOLD_QTY
|
Gold_Qty
| |
|
GOLD_RATE
|
Gold_Rate
| |
|
GOODS_IN_DATE
|
It stores the Goods in date. This is Helpful
in Factor Days column.
|
GoodsInDate
|
|
GROSS_WT
|
This may be used for printing Gross Wt of
Item.
|
GrossWt
|
|
INC_DUTY_RATE
|
|
Inc_Duty_Rate
|
|
ITEM_COMM_PER_UNIT
|
Commision Rate for agents.
|
iCommRate
|
 JOINT |
|
Joint
|
|
JOB_ORDER_NO
|
|
JobOrderNo
|
|
KEY_NO
|
|
KeyNo
|
|
KG_RATE
|
Rate per Kg.
|
|
|
LABOUR_AMT
|
This column is generally required when we
want to charge item wise labour amount
and instead of printing in columns we want
to print the labour amount in totals. In such
case you have to add this column and also
add LABOUR_AMT field in DocTotals.
|
LabourAmt
|
|
LABOUR_RATE
|
This column is required to specify the
labour rate. What ever the rate is mention
in this column that will multiply with the
quantity and the result of that becomes the
Labour Amount.
|
LabourRate
|
|
LENGTH
|
This is used to specify the length of the
product.
|
Length
|
|
MARKDOWN
MARKUP
|
|
|
|
MFG_DATE
|
|
MfgDate
|
|
MRP
|
This column is used for MRP. If MRP is
entered in master that will automatically
picked from the master.
|
MRP
|
|
MRP_AMOUNT
|
This column shows the MRP amount by
multiplying MRP with QUANTITY.
|
MRPAmt
|
|
NARRATION
|
|
Remarks1
|
|
NO_OF_BALES
|
This is used for inputting no of bales of an
item.
|
NoOfBales
|
|
NO_OF_BOXES
|
This is used for inputting No of Boxes for
an item. You may also add QTY_PER_BOX
column to get the quantity as
NO_OF_BOXES * QTY_PER_BOX.
|
NoOfBoxes
|
|
ORDER_DATE
|
This is used for Inputting Order Date
|
OrderDate
|
|
ORDER_NO
|
This is used for Inputting Order No.
|
OrderNo
|
|
PACKING
|
This is used for Inputting Packing. The
Packing will picked from Item Master. You
should open Packing field in Stock Master
|
qPacking
|
|
PCS
|
|
Pcs
|
|
PKG_TYPE
|
|
PkgType
|
|
PO_DATE
|
|
PODate
|
|
PO_NO
|
|
PONo
|
|
PRINT_COLOR
|
PrintColor
| |
|
PRINT_MIN_QTY
|
PrintMinQty
| |
|
PRODUCT_ID
|
This is for Inputting Item Name
|
QMhd
|
|
PRODUCT_NAME
|
This is for Item Description. Item
Description picked from Item Master's
Description1 field.
|
QDesc1
|
|
PUMP_ADD_CESS
PUMP_ADD_VAT
PUMP_CESS
PUMP_COMMISSION
PUMP_FREIGHT
PUMP_MACHINE
PUMP_METER_CLOSE
PUMP_METER_OPEN
PUMP_OIL_PERCENT
PUMP_RATE_DIFF
PUMP_REDUCTION
PUMP_RPO_FACTOR
PUMP_TAX_REBATE
PUMP_TESTING
PUMP_VEH_METER
|
|
|
|
QTY_FOR_RATE
QTY_ISSUE
|
|
|
|
QTY_PER_BOX
|
This is used for Inputting Quantity Per Box.
|
QtyPerBox
|
|
QTY_RECEIPT
QTY_UNIT
|
|
|
|
QUANTITY
|
This is used for inputting the item quantity.
|
Quantity
|
|
RATE
|
This is used for inputting the item rate.
|
Rate
|
|
RATE_PER
|
This is used for inputting the Rate per unit.
|
RatePer
|
|
RATE_UNIT
|
|
|
|
REF_BILL_NO
|
This is used for inputting Ref. Bill No. of
party.
|
RefBillNo
|
|
REV_BAGS
|
|
|
|
REVISED_RATE
|
This is column is required If you add
DISCOUNT column. If shows the rate after
discount. The amount will be calculated on
REVISED_RATE column.
|
RevisedRate
|
|
RG23D_NO
|
This column is required in Excise Invoice. It
is used for inputting RG23D no. of
purchase.
|
RG23DNo
|
|
RG23D_NO_SALE
|
This column is required in Excise Invoice. It
is used for inputting RG23D no. of sale.
|
RG23DNoSale
|
|
ROLLS_DETAIL
|
This is used for inputting the details of rolls.
|
RollsDetail
|
|
ROW_TYPE
|
|
RowType
|
|
S_NO
|
It shows the Sr. No. of item while inputting.
|
|
|
SCHEME_FOR_RATE
|
------NOT A VALID SCHEME--------
|
SchemeForRate
|
|
SERVICE_PER
|
|
ServicePer
|
|
SIZE
|
This is for inputting Size. You have to open
the Size field in master if you wants to pick
size from the master
|
Size, qSize
|
|
SPL_DISCOUNT
|
This is similar to DISCOUNT column. This is
required when you wants to give 2 item
wise discounts. In such case you should
add DISCOUNT column as well as
SPL_DISCOUNT column. REVISED_RATE is
also neccessary if you add SPL_DISCOUNT
column.
|
VSplDiscount
|
|
SQMTRS
|
This is used for inputting Square meters.
|
SqMtrs
|
|
STD_WT
|
This is used for inputting Standard weight
of an item. You may also stores standard
weight of an item in master by opening Std
Wt field.
|
StdWt, qStdWt
|
|
SUBITEM
|
This is used for inputting additional
description of an item for current bill only.
To print this description with item
description first you have to 'True' against
DocMergeSubitem in DocTypes and you
have print qDesc1 field instead of qMhd.
|
SubItem
|
|
SURCHARGE
|
This is used for inputting item wise
surcharge in %. You also have to open
MED_SURCHARGE field in totals style. The
total of surcharge automatically added in
Surcharge field in total style.
|
Surcharge
|
|
TAX_FREE_AMT
|
This is used for inputting tax free amount.
You have to add TAX_FREE_AMT field in
totals style. The total of Tax free amount
column automatically added in
TAX_FREE_AMT field in total style.
|
TaxFreeAmt
|
|
TAX_FREE_RATE
|
This is used for entering Tax Free Rate in
%. Whatever is added in this column that
will calculated and displayed in
TAX_FREE_AMT column. It also reduces the
amount column.
|
TaxFreeRate
|
|
TAX_RATE
|
This is used for specifying tax rate for the
item. Tax Rate can automatically picked
from vat category specified in stock master.
This column is required where in a bill 2
item are there with different Tax Rates.
|
TaxRate
|
|
TOTAL_GROSS_WT
|
This is used for entering Gross Weight.
|
TotalGrossWt
|
|
TOTAL_WT
|
This is used for entering Total Weight.
|
TotalWt
|
|
TOTSQMTRS
|
TotSqMtrs
| |
|
UNIT
|
This is used for entering unit like kgs, pcs
etc.
|
Unit, qUnit
|
|
VAT_QUANTITY
|
|
VATQuantity
|
|
VEH_NO
|
|
VehNo
|
|
WIDTH
|
This is used for entering width of an item.
|
Width
|