PeopleSoft 9
Account Payables

Table Name LC_EXT_LOG_DETL

Table Description
LC_EXT_LOG_DETL
Columns
Name Datatype Is PK Is FK
PROCESS_INSTANCE decimal(10) Yes No
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM int Yes Yes
BUSINESS_UNIT_RECV VARCHAR(5) Yes No
RECEIVER_ID VARCHAR(10) Yes No
RECV_LN_NBR int Yes No
BUSINESS_UNIT_RTV VARCHAR(5) Yes No
RTV_ID VARCHAR(10) Yes No
RTV_LN_NBR int Yes No
MATCH_RULE_ID VARCHAR(10) Yes No
MATCH_CNTRL_ID VARCHAR(10) No No
DESCR254 VARCHAR(254) No No
Index
Name Type Unique Member
PS_LC_EXT_LOG_DETL PK Yes
Member(s) of "PS_LC_EXT_LOG_DETL" Index
PROCESS_INSTANCE
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
BUSINESS_UNIT_RECV
RECEIVER_ID
RECV_LN_NBR
BUSINESS_UNIT_RTV
RTV_ID
RTV_LN_NBR
MATCH_RULE_ID

Published June 06, 2007