Table Indexes
PROMOTION HISTORY C: OFFER_CD, USE_CD
REF_ACTION_SRCH_LGCY_CD ACTION_SRCH_LGCY_CD
REF_CUST_ACTION_LGCY_CD CUST_ACTION_LGCY_CD
REF_CUST_STA_LGCY_CD CUST_STA_LGCY_CD
REF_CUST_TYPE_LGCY_CD CUST_TYPE_LGCY_CD
REF_FOP_TYPE_LGCY_CD FOP_TYPE_LGCY_CD
REF_ITM_STA_LGCY_CD ITM_STA_LGCY_CD
REF_MAJ_CAT_LGCY_CD MAJ_CAT_LGCY_CD
REF_MIN_CAT_LGCY_CD MIN_CAT_LGCY_CD
REF_ORD_ITM_HP_LGCY_CD ORD_ITM_HP_LGCY_CD
REF_ORD_ITM_POR_LGCY_CD ORD_ITM_POR_LGCY_CD
REF_ORD_ITM_STA_LGCY_CD ORD_ITM_STA_LGCY_CD
REF_ORD_ITM_TYPE_LGCY_CD ORD_ITM_TYPE_LGCY_CD
REF_ORD_SUB_STA_LGCY_CD ORD_SUB_STA_LGCY_CD
REF_PERIOD_TABLE DATE
FULL_DATE
REF_PROCESS_ACTION_SRCH ACTION_SRCH_LGCY_CD
REF_PURCH_ORD_REAS_LGCY_CD PURCH_ORD_REAS_LGCY_CD
REF_RTN_REAS_LGCY_CD RTN_REAS_LGCY_CD
REF_SHIP_METH_LGCY_CD SHIP_METH_LGCY_CD
REF_SHIP_TO_LGCY_CD SHIP_TO_LGCY_CD
REF_SUB_MAJ_CAT_LGCY_CD SUB_MAJ_CAT_LGCY_CD
REF_SUB_MIN_CAT_LGCY_CD SUB_MIN_CAT_LGCY_CD
REF_UNIT_OF_MEAS_LGCY_CD UNIT_OF_MEAS_LGCY_CD
SV_MACACT_MACS_ACCOUNTS_DTL C: CO_CD, DIV_CD, FIN_TRANS_LGCY_CD
C: FIN_TRANS_TYPE_LGCY_CD, FIN_AMT_TYPE_LGCY_CD
GL_DEBIT_ACCT
SV_MACITM_INV_DETAILS EDP_NO_ID
SV_MACITM_INV_TRANS_POR C:EDP_NO_ID, INV_TRANS_CD, INV_TRANS_FRM_CD, INV_TRANS_TO_CD, INV_TRANS_STA_LGCY_CD
PURCH_ORD_NR
SV_MACITM_INVENTORY_TRANS C:EDP_NO_ID, INV_TRANS_CD, INV_TRANS_FRM_CD, INV_TRANS_TO_CD, INV_TRANS_STA_LGCY_CD
EDP_NO_ID
INV_TRANS_DT
INV_TRANS_STA_LGCY_CD
SV_MACITM_ITEM_MAST CATEGORY
CO_CD
DIV_CD
EDP_NO_ID
ITM_STA_LGCY_CD
SV_MACITM_ITEM_MAST_WH EDP_NO_ID
SV_MACITM_MACS_SNAPSHOT SNAPSHOT_DATE
SV_MACITM_OFFER_ITEMS C: EDP_NO_ID, OFFER_CD
C: OFFER_CD, EDP_NO_ID
EDP_NO_ID
OFFER_CD
SV_MACITM_OFFERS CO_CD
DIV_CD
OFFER_CD
SV_MACITM_PO_DETAILS C: PURCH_ORD_NR, PURCH_ORD_LN_NR
EDP_NO_ID
PURCH_ORD_NR
VEND_CD
SV_MACITM_PO_HEADER BUYER_LGCY_CD
CO_CD
DIV_CO
PURCH_ORD_NR
VEND_CD
SV_MACITM_PO_REC C: PURCH_ORD_NR, PURCH_ORD_LN_NR
SV_MACITM_SOURCES C:OFFER_CD, USE_CD
OFFER_CD
SV_MACITM_SOURCES_FOP_TOT C: OFFER_CD, USE_CD
C: OFFER_CD, USE_CD
SV_MACITM_STYLE_HEADER STY_CD
SV_MACITM_STYLE_ITEM_DATA EDP_NO_ID
SV_MACITM_VEND_ORD_FROM C: VEND_CD, AP_VEND_CD
VEND_CD
SV_MACITM_VEND_TEL VEND_CD
SV_MACITM_VENDOR_ITEMS BUYER_LGCY_CD
C: EDP_NO_ID, VEND_CD
SV_MACITM_VENDOR_ITEMS EDP_NO_ID
SV_MACITM_WHSE_LOCS WH_LOC_CD
SV_MACMAN_AIRBORNE_PKG_SHIP TRK_NR
SV_MACMAN_FEDEX_PKG_SHIP TRK_NR
SV_MACMAN_MANI_PKG_SHIP C: MANI_REF_NR, MANI_PKG_SEQ_NR
SV_MACMAN_MANIFEST_ENTRIES C: MANI_REF_NR, MANI_PKG_SEQ_NR
CO_CD
DIV_CD
SV_MACORD_AR_COMMENTS C: ORIG_DOC_NR, ORIG_DOC_TYPE_LGCY_CD
C: ORIG_SALES_ORD_NR, ORIG_SALES_ORD_SHIP_NR, ORIG_SALES_ORD_SHIP_TO_NR
ORIGINATING_REF
SV_MACORD_BACK_ORDER C: SALES_ORD_NR, SALES_ORD_LN_NR
CO_CD
DIV_CD
EDP_NO_ID
SV_MACORD_CLOSED_AR C: ORIG_DOC_NR, ORIG_DOC_TYPE_LGCY_CD
C: ORIG_SALES_ORD_NR, ORIG_SALES_ORD_SHIP_NR, ORIG_SALES_ORD_SHIP_TO_NR
C: POST_DOC_NR, POST_DOC_TYPE_LGCY_CD
C: POST_SALES_ORD_NR, POST_SALES_ORD_SHIP_NR, POST_SALES_ORD_SHIP_TO_NR
CUST_EDP_ID
ORIGINATING_REF
TRANS_DT
TRANS_TYPE_LGCY_CD
SV_MACORD_CREDIT_APPROVAL C: CUST_EDP_ID, CO_CD, DIV_CD
SV_MACORD_CUST_EMAIL CUST_EDP_ID
SV_MACORD_CUST_TEL CUST_EDP_ID
SV_MACORD_CUSTOMER_ADDL CUST_EDP_ID
SV_MACORD_CUSTOMER_COMP C: CUST_EDP_ID, CO_CD, DIV_CD
CO_CD
CUST_EDP_ID
DIV_CD
SV_MACORD_CUSTOMERS CUST_EDP_ID
SV_MACORD_FT_CUST C: CO_CD, DIV_CD, FIN_TRANS_LGCY_CD
C: CUST_EDP_ID, FIN_TRANS_AMT
SV_MACORD_FT_CUST_AMT C: FIN_TRANS_TYPE_LGCY_CD, FIN_AMT_TYPE_LGCY_CD
CUST_EDP_ID
SV_MACORD_FT_DOC C: DOCUMENT_NR, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
SV_MACORD_FT_DOC_AMT C: DOCUMENT_NR, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
SV_MACORD_FT_INV_TRANS C: INV_TRANS_CD, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
SV_MACORD_FT_INV_TRANS_AMT C: INV_TRANS_CD, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
SV_MACORD_FT_SALES_ORD C: SALES_ORD_NR, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
SV_MACORD_FT_SALES_ORD_AMT C: SALES_ORD_NR, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
C:SALES_ORD_NR, FIN_AMT_TYPE_LGCY_CD
SV_MACORD_FT_SHIP C: SALES_ORD_NR, SALES_ORD_SHIP_TO_NR, SALES_ORD_SHIP_NR, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
C:SALES_ORD_NR, SALES_ORD_SHIP_TO_NR, SALES_ORD_SHIP_NR, FIN_TRANS_LGCY_CD
SV_MACORD_FT_SHIP_AMT C: SALES_ORD_NR, SALES_ORD_SHIP_TO_NR, SALES_ORD_SHIP_NR, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
C:SALES_ORD_NR, SALES_ORD_SHIP_TO_NR, SALES_ORD_SHIP_NR
C:SALES_ORD_NR, SALES_ORD_SHIP_TO_NR, SALES_ORD_SHIP_NR, FIN_TRANS_LGCY_CD
SV_MACORD_FT_SHIP_TO C: SALES_ORD_NR_SALES_ORD_SHIP_TO_NR, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
SV_MACORD_FT_SHIP_TO_AMT C: SALES_ORD_NR_SALES_ORD_SHIP_TO_NR, FIN_TRANS_LGCY_CD, FIN_TRANS_MEMO_LGCY_CD, FIN_TRANS_DT
SV_MACORD_OA_ORD_OTH C: SALES_ORD_NR, SALES_ORD_SHIP_TO_NR
C: SALES_ORD_NR,SALES_ORD_SHIP_NR, SALES_ORD_SHIP_TO_NR
CO_CD
DIV_CD
ORD_MESSAGE_LGCY_CD
SALES_ORD_NR
SV_MACORD_OPEN_AR C: CUST_EDP_ID, CO_CD, DIV_CD
C: ORIG_DOC_NR, ORIG_DOC_TYPE_LGCY_CD
C: ORIG_SALES_ORD_NR, ORIG_SALES_ORD_SHIP_NR, ORIG_SALES_ORD_SHIP_TO_NR
SV_MACORD_ORDER_HEADER C: CO_CD, DIV_CD
C: CO_CD, DIV_CD, CUST_EDP_ID
C: CUST_EDP_ID, SALES_ORD_NR
C: OFFER_CD, USE_CD
C: SALES_ORD_NR, OFFER_CD
C:SALES_ORD_NR, CUST_EDP_ID
CO_CD
CUST_EDP_ID
DIV_CD
OFFER_CD
SALES_ORD_MAIL_DT
SALES_ORD_NR
USE_CD
SV_MACORD_PICK_LOT_DETAIL C: SALES_ORD_NR, SALES_ORD_LN_NR
CO_CD
DIV_CD
EDP_NO_ID
PICK_LOT_CD
PICK_LOT_ITM_CANC_IND
SV_MACORD_PICK_LOT_DETAIL_WH C: SALES_ORD_NR, SALES_ORD_LN_NR
SV_MACORD_PICK_LOT_HEADER PICK_LOT_CD
WH_CD
SV_MACORD_PROC_RETURN C: RTN_CD, SALES_ORD_LN_NR, RTN_SEQ_NR
C: RTN_CD, SALES_ORD_NR
RNT_DT
SV_MACORD_PROCESS_ORDER ACTION_SRCH_LGCY_CD
C: SALES_ORD_NR, SALES_ORD_SHIP_TO_NR
C: SALES_ORD_NR, SALES_ORD_SHIP_TO_NR, SALES_ORD_SHIP_NR
CO_CD
CUST_EDP_ID
DIV_CD
HDR_ACTION_SRCH_LGCY_CD
SALES_ORD_NR
SV_MACORD_PROCESS_REFUND ACTION_SRCH_LGCY_CD
CO_CD
CUST_EDP_ID
DIV_CD
SV_MACORD_RETURN_AUTH C: RTN_CD, SALES_ORD_LN_NR
SV_MACORD_RETURNS C: RTN_CD, SALES_ORD_LN_NR
C: RTN_CD, SALES_ORD_LN_NR, RTN_SEQ_NR
C: SALES_ORD_NR, SALES_ORD_LN_NR
CO_CD
DIV_CD
EDP_NO_ID
RTN_AUTH_IND
RTN_REAS_LGCY_CD
SALES_ORD_NR
SV_MACORD_SALES_ORD_LINES C: SALES_ORD_LN_NR,EDP_NO_ID
C: SALES_ORD_NR, EDP_NO_ID
C: SALES_ORD_NR, SALES_ORD_LN_NR
C: SALES_ORD_NR, SALES_ORD_SHIP_TO_NR
C: SALES_ORD_NR, SALES_ORD_SHIP_TO_NR, SALES_ORD_SHIP_NR
EDP_NO_ID
ORD_ITM_HP_LGCY_CD
ORD_ITM_TYPE_LGCY_CD
SALES_ORD_NR
SHIP_DT