PeopleSoft 9
Account Payables

Table Name IPAC_DETAIL_STG

Table Description
IPAC_DETAIL_STG
Columns
Name Datatype Is PK Is FK
FILENAME VARCHAR(80) Yes No
ALC VARCHAR(8) Yes No
IPAC_HDR_SEQ_NUM INT Yes No
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_FY_OBLIG_ID VARCHAR(1) No No
IPAC_RECVR_TAS VARCHAR(27) No No
IPAC_RECVR_BETC VARCHAR(8) No No
IPAC_RECVR_DUNS VARCHAR(9) No No
IPAC_RECVR_DUNS4 VARCHAR(4) No No
IPAC_REQ_ID VARCHAR(22) No No
IPAC_SENDER_TAS VARCHAR(27) No No
IPAC_SENDER_BETC VARCHAR(8) No No
IPAC_SENDER_DUNS VARCHAR(9) No No
IPAC_SENDER_DUNS4 VARCHAR(4) 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_S_SGL_CMNT VARCHAR(254) No No
IPAC_R_SGL_CMNT VARCHAR(254) No No
IPAC_VCHR_NUM VARCHAR(10) No No
IPAC_EMAIL_ADDR VARCHAR(254) No No
Index
Name Type Unique Member
PS_IPAC_DETAIL_STG PK Yes
Member(s) of "PS_IPAC_DETAIL_STG" Index
FILENAME
ALC
IPAC_HDR_SEQ_NUM
IPAC_DTL_SEQ_NUM

Published June 06, 2007