Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
og:
QUALIFY*;
UNQUALIFY oyear,omonth;
LOAD
BR_NAME,
CUSTOMER_NAME,
VC_GOLD_TYPE,
EX_TYPE,
VC_BILL_NO,
DT_BILL_DATE,
DT_YEAR as oyear,
DT_MON as omonth ,
VC_CATEGORY,
VC_ITEM_DET,
VC_ITEM_DESC,
VC_PURITY,
VC_TYPE,
VC_PRIMARY_UOM,
VC_ITEM_CODE,
NU_NANG,
NU_NANG_PCS,
NU_GROSS_WTT,
NU_NETT_WTT,
NU_CARRAT_WTT,
NU_RATE,
NU_OTHER_CHARGES,
NU_AMOUNT
FROM
[D:\DATA\QVD\XXTBZ_POSURD_CHECKLIST_V.qvd]
(qvd);
pm:
QUALIFY*;
UNQUALIFY omonth,oyear;
LOAD
BR_NAME,
VC_VOUCHER_NO,
DT_VOUCHER_DATE,
DT_MONTH as omonth,
DT_YEAR as oyear,
VC_REF_SALE_VOUCHER_NO,
DT_REF_SALE_VOUCHER_DATE,
VC_CATEGORY,
CATEGORY_DESCRIPTION,
CUSTOMER_NAME,
BR_CODE,
CH_PAY_MODE,
PAY_MODE_DESC,
TCS_AMOUNT,
TOTAL_BILL_AMOUNT
FROM
[D:\DATA\QVD\XXPOS_SALES_PAYMENT_V.qvd]
(qvd);
now how to create a link table for oyear and omonth
Which fields do you need in the link table? To reference the qualified fields, just add the prefix, like [og.BR_NAME] or [pm.BR_NAME]