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 |