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 |