PeopleSoft 9
Account Payables

Table Name AP_IPAC_DETAIL

Table Description
AP_IPAC_DETAIL
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
IPAC_HDR_SEQ_NUM int Yes Yes
IPAC_DTL_SEQ_NUM int Yes No
IPAC_ACL_CD VARCHAR(16) No No
IPAC_ACRN VARCHAR(12) No No
IPAC_LN_AMT decimal(26,3) No No
CONTACT_NAME VARCHAR(50) No No
PHONE_NUM VARCHAR(12) No No
IPAC_CLIN VARCHAR(6) No No
IPAC_CNTRCT_NUM VARCHAR(17) No No
IPAC_RECVR_DEPT VARCHAR(2) No No
IPAC_DESCR VARCHAR(254) No No
IPAC_XREF_DOC VARCHAR(8) No No
IPAC_FSN int No No
INVOICE_ID VARCHAR(30) No No
INVOICE_DT PSDATE No No
IPAC_JAS_NUM VARCHAR(30) No No
IPAC_JOB_NUM VARCHAR(20) No No
IPAC_MISC_DESCR VARCHAR(254) No No
IPAC_OBL_DOC_NBR VARCHAR(17) No No
IPAC_PAY_FLAG VARCHAR(1) No No
IPAC_PO_ID VARCHAR(22) No No
IPAC_QUANTITY DECIMAL(16,4) No No
IPAC_RECVR_TAS VARCHAR(27) No No
IPAC_REQ_ID VARCHAR(22) No No
IPAC_SENDER_TAS VARCHAR(27) No No
IPAC_TRACE_NUM VARCHAR(15) No No
UNIT_OF_ISSUE VARCHAR(2) No No
IPAC_UNIT_PRICE decimal(15,5) No No
IPAC_DODAC VARCHAR(15) No No
IPAC_ORIG_LN_ITM int No No
IPAC_FY_OBLIG_ID VARCHAR(1) No No
IPAC_RECVR_BETC VARCHAR(8) No No
IPAC_RECVR_DUNS VARCHAR(9) No No
IPAC_RECVR_DUNS4 VARCHAR(4) No No
IPAC_SENDER_BETC VARCHAR(8) No No
IPAC_SENDER_DUNS VARCHAR(9) No No
IPAC_SENDER_DUNS4 VARCHAR(4) No No
Index
Name Type Unique Member
PS_AP_IPAC_DETAIL PK Yes
Member(s) of "PS_AP_IPAC_DETAIL" Index
BUSINESS_UNIT
VOUCHER_ID
IPAC_HDR_SEQ_NUM
IPAC_DTL_SEQ_NUM

Published June 06, 2007