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 |