PeopleSoft 9
Account Payables

Table Name VCHR_MTCH_DETLS

Table Description
VCHR_MTCH_DETLS
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM int Yes Yes
BUSINESS_UNIT_PO VARCHAR(5) Yes No
PO_ID VARCHAR(10) Yes No
LINE_NBR int Yes No
SCHED_NBR SMALLINT Yes No
BUSINESS_UNIT_RECV VARCHAR(5) Yes No
RECEIVER_ID VARCHAR(10) Yes No
RECV_LN_NBR int Yes No
RECV_SHIP_SEQ_NBR SMALLINT Yes No
DESCR VARCHAR(30) No No
INVOICE_ID VARCHAR(30) No No
INVOICE_DT PSDATE No No
VENDOR_SETID VARCHAR(5) No No
VENDOR_ID VARCHAR(10) No No
VNDR_LOC VARCHAR(10) No No
PROCESS_INSTANCE decimal(10) No No
ORIGIN_VCHR VARCHAR(3) No No
PYMNT_TERMS_CD VARCHAR(5) No No
PYMNT_TERMS_CD_PO VARCHAR(5) No No
TXN_CURRENCY_CD VARCHAR(3) No No
MERCH_AMT_VCHR decimal(26,3) No No
MERCH_AMT_VCHR_B decimal(26,3) No No
MERCH_AMT_VCHRR_B decimal(26,3) No No
INVOICED_AMT_B decimal(26,3) No No
ITM_SETID VARCHAR(5) No No
INV_ITEM_ID VARCHAR(18) No No
QTY_VCHR decimal(15,4) No No
INVOICED_QTY_CNVT decimal(15,4) No No
UOM_VCHR VARCHAR(3) No No
UNIT_PRICE decimal(15,5) No No
DUE_DT PSDATE No No
MATCH_CNTRL_ID VARCHAR(10) No No
VNDR_SETID_PO VARCHAR(5) No No
VENDOR_PO VARCHAR(10) No No
VNDR_LOC_PO VARCHAR(10) No No
TAX_EXEMPT VARCHAR(1) No No
CNTRCT_ID_VCHR VARCHAR(25) No No
CNTRCT_ID VARCHAR(25) No No
CTRCT_LINE_NBR int No No
PO_DT PSDATE No No
ITM_SETID_PO VARCHAR(5) No No
INV_ITEM_ID_PO VARCHAR(18) No No
AMT_ONLY_FLG_PO VARCHAR(1) No No
ITM_ID_VNDR VARCHAR(50) No No
PRICE_PO decimal(15,5) No No
UOM_PO VARCHAR(3) No No
BUYER_ID VARCHAR(30) No No
RECV_REQ VARCHAR(1) No No
UNIT_PRC_TOL decimal(13,5) No No
PCT_UNIT_PRC_TOL decimal(5,2) No No
EXT_PRC_TOL decimal(13,5) No No
PCT_EXT_PRC_TOL decimal(5,2) No No
UNIT_PRC_TOL_L decimal(13,5) No No
PCT_UNIT_PRC_TOL_L decimal(5,2) No No
EXT_PRC_TOL_L decimal(13,5) No No
PCT_EXT_PRC_TOL_L decimal(5,2) No No
INSPECT_CD VARCHAR(1) No No
SHIPTO_ID VARCHAR(10) No No
ORIG_PROM_DT PSDATE No No
QTY_PO decimal(15,4) No No
MERCH_AMT_PO decimal(26,3) No No
FREIGHT_TERMS VARCHAR(10) No No
VNDR_SETID_RECV VARCHAR(5) No No
VENDOR_RECV VARCHAR(10) No No
VNDR_LOC_RECV VARCHAR(10) No No
ITM_SETID_RECV VARCHAR(5) No No
INV_ITEM_ID_RECV VARCHAR(18) No No
AMT_ONLY_FLG_RECV VARCHAR(1) No No
ASSTN_NAME VARCHAR(30) No No
UOM_RECV VARCHAR(3) No No
INSPECT_STATUS VARCHAR(1) No No
QTY_SH_RECVD_SUOM decimal(15,4) No No
QTY_SH_RECVD_VUOM decimal(15,4) No No
QTY_SH_ACCPT_SUOM decimal(15,4) No No
QTY_SH_ACCPT_VUOM decimal(15,4) No No
QTY_SH_INSPD_VUOM decimal(15,4) No No
BILLED_QTY_PO decimal(15,4) No No
BILLED_QTY_RECV decimal(15,4) No No
BILLED_AMT_PO decimal(26,3) No No
BILLED_AMT_RECV decimal(26,3) No No
MERCH_AMT_RECV decimal(26,3) No No
TOTAL_RECV_QTY decimal(15,4) No No
TOTAL_RECV_AMT DECIMAL(26,3) No No
TOTAL_RECV_QTY_PO decimal(15,4) No No
TOTAL_RECV_AMT_PO decimal(26,3) No No
CNVT_RT_PO decimal(15,8) No No
CNVT_RT_RECV decimal(15,8) No No
QTY_RECEIVED_CNVT decimal(15,4) No No
QTY_ACCEPTED_CNVT decimal(15,4) No No
QTY_INSPECTED_CNVT decimal(15,4) No No
QTY_VCHR_CNVT decimal(15,4) No No
QTY_VCHR_CNVTR decimal(15,4) No No
UNIT_PRICE_CNVT decimal(15,5) No No
UNIT_PRICE_CNVT_B decimal(15,5) No No
UNIT_PRICE_CNVTR decimal(15,5) No No
UNIT_PRICE_CNVTR_B decimal(15,5) No No
PRICE_DIFF decimal(15,5) No No
QTY_DIFF_RECV decimal(15,4) No No
MERCH_AMT_EXTND decimal(26,3) No No
MERCH_AMT_EXTND_B decimal(26,3) No No
MERCH_AMT_EXT_DIFF decimal(26,3) No No
MERCH_AMT_EXTND_PO decimal(26,3) No No
MATCH_RECEIPT_REQ VARCHAR(1) No No
MATCH_LINE_OPT VARCHAR(1) No No
MATCH_ERROR_FLG VARCHAR(1) No No
MATCH_STATUS_VCHR VARCHAR(1) No No
ZERO_IND VARCHAR(1) No No
QTY_RECV_TOL_PCT decimal(5,2) No No
TXN_CURRENCY_PO VARCHAR(3) No No
TXN_CURRENCY_RECV VARCHAR(3) No No
RT_TYPE VARCHAR(5) No No
ACCOUNTING_DT PSDATE No No
PRICE_PO_RECV decimal(15,5) No No
QTY_ENTERED decimal(15,4) No No
QTY_ENTERED_CNVT decimal(15,4) No No
TOTAL_RECV_ENT decimal(15,4) No No
TOTAL_RECV_ENT_PO decimal(15,4) No No
RECEIPT_DELAY_DAYS SMALLINT No No
PO_TYPE_PO VARCHAR(4) No No
PO_TYPE_RECV VARCHAR(4) No No
PRICE_CAN_CHANGE VARCHAR(1) No No
ZERO_PRICE_IND VARCHAR(1) No No
ORIGIN_PO VARCHAR(3) No No
ORIGIN_RECV VARCHAR(3) No No
FROZEN_FLG VARCHAR(1) No No
RJCT_OVER_TOL_FLAG VARCHAR(1) No No
PO_RECEIPT_FLG VARCHAR(1) No No
RECV_SOURCE VARCHAR(1) No No
MATCH_LINE_FLG VARCHAR(1) No No
PRICE_CAN_CHANGE_R VARCHAR(1) No No
TOT_RECV_ENT_VCHR decimal(15,4) No No
ALGTHM_BEHAVIOR VARCHAR(4) No No
Index
Name Type Unique Member
PS_VCHR_MTCH_DETLS PK Yes
Member(s) of "PS_VCHR_MTCH_DETLS" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
BUSINESS_UNIT_PO
PO_ID
LINE_NBR
SCHED_NBR
BUSINESS_UNIT_RECV
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR

Published June 06, 2007