PeopleSoft 9
Account Payables

Table Name AP_VCHR_LN_SUM

Table Description
AP_VCHR_LN_SUM
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM INT Yes No
ASSTN_NAME VARCHAR(30) Yes No
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
QTY_VCHR DECIMAL(15,4) No No
QTY_VCHR_CNVT DECIMAL(15,4) No No
QTY_VCHR_CNVTR DECIMAL(15,4) No No
UNIT_PRICE_CNVT_B DECIMAL(15,5) No No
UNIT_PRICE_CNVTR_B DECIMAL(15,5) No No
BUSINESS_UNIT_RTV VARCHAR(5) No No
ACCOUNTING_DT datetime No No
INVOICE_DT datetime No No
QTY_RECV_APPLIED DECIMAL(15,4) No No
MERCH_AMT_RECVAPPL DECIMAL(26,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
MERCH_AMT_RECV DECIMAL(26,3) No No
MERCH_AMT_PO DECIMAL(26,3) No No
QTY_PO DECIMAL(15,4) No No
QTY_SH_ACCPT_VUOM DECIMAL(15,4) No No
PROCEED_FLG VARCHAR(1) No No
AP_RULE_ACTION VARCHAR(1) No No
DUE_DT datetime No No
FREIGHT_TERMS VARCHAR(10) No No
FROZEN_FLG VARCHAR(1) No No
ORIG_PROM_DT datetime No No
ORIGIN_PO VARCHAR(3) No No
ORIGIN_RECV VARCHAR(3) No No
PO_DT datetime No No
PO_TYPE_PO VARCHAR(4) No No
PO_TYPE_RECV VARCHAR(4) No No
QTY_MATCHED_PO DECIMAL(15,4) No No
QTY_MATCHED_RECV DECIMAL(15,4) No No
AMT_MATCHED_PO DECIMAL(26,3) No No
AMT_MATCHED_RECV DECIMAL(26,3) No No
UNIT_PRICE_CNVT DECIMAL(15,5) No No
UNIT_PRICE_CNVTR DECIMAL(15,5) No No
ALGTHM_BEHAVIOR VARCHAR(4) No No
AMT_ONLY_FLG VARCHAR(1) No No
MATCH_STATUS_PO VARCHAR(1) No No
MATCH_LINE_STATUS VARCHAR(1) No No
MFG_ID VARCHAR(50) No No
USER_LINE_CHAR1 VARCHAR(1) No No
USER_SCHED_CHAR1 VARCHAR(1) No No
RECEIPT_DT datetime No No
SHIPTO_ID VARCHAR(10) No No
MATCH_STATUS_RECV VARCHAR(1) No No
MATCH_LINE_OPT VARCHAR(1) No No
PO_STATUS VARCHAR(2) No No
VCHR_SRC VARCHAR(4) No No
CONVERSION_RATE DECIMAL(15,8) No No
UOM_VCHR VARCHAR(3) No No
UOM_PO VARCHAR(3) No No
UOM_RECV VARCHAR(3) No No
RATE_MULT DECIMAL(15,8) No No
RATE_MULT_TOL DECIMAL(15,8) No No
RATE_DIV_TOL DECIMAL(15,8) No No
RATE_DIV DECIMAL(15,8) No No
RT_TYPE_PO VARCHAR(5) No No
RT_TYPE_VCHR VARCHAR(5) No No
CURRENCY_CD_PO VARCHAR(3) No No
CURRENCY_CD_RECV VARCHAR(3) No No
CURRENCY_CD_VCHR VARCHAR(3) No No
DBMEMO_FLAG VARCHAR(1) No No
DMEMO_CAT_PRICE VARCHAR(1) No No
DMEMO_CAT_QTY VARCHAR(1) No No
DISTRIB_MTHD_FLG VARCHAR(1) No No
INSPECT_DT datetime No No
INVOICE_ID VARCHAR(30) No No
INVOICED_QTY_CNVT DECIMAL(15,4) No No
INVOICED_AMT_B DECIMAL(26,3) No No
KK_PROCESS_PRIOR VARCHAR(1) No No
MATCH_CNTRL_ID VARCHAR(10) No No
PACKSLIP_NO VARCHAR(22) No No
MERCH_AMT_EXTND DECIMAL(26,3) No No
MERCH_AMT_EXTND_B DECIMAL(26,3) No No
MERCH_AMT_EXTND_PO DECIMAL(26,3) No No
EXT_PRC_TOL DECIMAL(13,5) No No
EXT_PRC_TOL_L DECIMAL(13,5) No No
PCT_EXT_PRC_TOL DECIMAL(5,2) No No
PCT_EXT_PRC_TOL_L DECIMAL(5,2) No No
PYMNT_TERMS_CD VARCHAR(5) No No
PYMNT_TERMS_CD_PO VARCHAR(5) No No
QTY_ENTERED DECIMAL(15,4) No No
PO_RECEIPT_FLG VARCHAR(1) No No
VENDOR_SETID VARCHAR(5) No No
VENDOR_ID VARCHAR(10) No No
VNDR_LOC VARCHAR(10) No No
VNDR_SETID_PO VARCHAR(5) No No
VENDOR_PO VARCHAR(10) No No
VNDR_LOC_PO VARCHAR(10) No No
VNDR_SETID_RECV VARCHAR(5) No No
VOUCHER_STYLE VARCHAR(4) No No
VENDOR_RECV VARCHAR(10) No No
VNDR_LOC_RECV VARCHAR(10) No No
INSPECT_STATUS VARCHAR(1) No No
INSPECT_CD VARCHAR(1) No No
ITM_SETID VARCHAR(5) No No
ITM_SETID_PO VARCHAR(5) No No
ITM_SETID_RECV VARCHAR(5) No No
INV_ITEM_ID VARCHAR(18) No No
INV_ITEM_ID_PO VARCHAR(18) No No
INV_ITEM_ID_RECV VARCHAR(18) No No
PRICE_PO DECIMAL(15,5) No No
PRICE_PO_RECV DECIMAL(15,5) No No
RECV_SOURCE VARCHAR(1) No No
RJCT_OVER_TOL_FLAG VARCHAR(1) No No
ZERO_IND VARCHAR(1) No No
ZERO_PRICE_IND VARCHAR(1) No No
TOTAL_RECV_AMT DECIMAL(26,3) No No
TOTAL_RECV_AMT_PO DECIMAL(26,3) No No
TOTAL_RECV_ENT DECIMAL(15,4) No No
TOTAL_RECV_ENT_PO DECIMAL(15,4) No No
TOTAL_RECV_QTY DECIMAL(15,4) No No
TOTAL_RECV_QTY_PO DECIMAL(15,4) No No
PRICE_CAN_CHANGE VARCHAR(1) No No
PRICE_CAN_CHANGE_R VARCHAR(1) No No
PCT_UNIT_PRC_TOL DECIMAL(5,2) No No
PCT_UNIT_PRC_TOL_L DECIMAL(5,2) No No
UNIT_PRC_TOL DECIMAL(13,5) No No
UNIT_PRC_TOL_L DECIMAL(13,5) No No
UNIT_PRICE_VCHR DECIMAL(15,5) No No
RECV_REQ VARCHAR(1) No No
QTY_RECV_TOL_PCT DECIMAL(5,2) No No
BUYER_ID VARCHAR(30) No No
CATEGORY_ID VARCHAR(5) No No
TRANS_DT datetime No No
USER_VCHR_CHAR1 VARCHAR(1) No No
USER_VCHR_CHAR2 VARCHAR(1) No No
USER_VCHR_DEC DECIMAL(26,3) No No
USER_VCHR_DATE datetime No No
USER_VCHR_NUM1 SMALLINT No No
PROCESS_INSTANCE DECIMAL(10) No No
LTD_RECV VARCHAR(1) No No
Index
Name Type Unique Member
PS_AP_VCHR_LN_SUM PK Yes
PSAAP_VCHR_LN_SUM IE1 No
PSBAP_VCHR_LN_SUM IE2 No
Member(s) of "PS_AP_VCHR_LN_SUM" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
ASSTN_NAME
BUSINESS_UNIT_PO
PO_ID
LINE_NBR
SCHED_NBR
BUSINESS_UNIT_RECV
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR
Member(s) of "PSAAP_VCHR_LN_SUM" Index
BUSINESS_UNIT_PO
PO_ID
LINE_NBR
SCHED_NBR
Member(s) of "PSBAP_VCHR_LN_SUM" Index
BUSINESS_UNIT_RECV
RECEIVER_ID
RECV_LN_NBR
RECV_SHIP_SEQ_NBR

Published June 06, 2007