PeopleSoft 9
Account Payables

Table Name AP_INV_STAT_RES

Table Description
AP_INV_STAT_RES
Columns
Name Datatype Is PK Is FK
INVOICE_ID VARCHAR(30) No No
PYMNT_ID VARCHAR(10) No No
PYMNT_SELCT_STATUS VARCHAR(1) No No
PYMNT_GROSS_AMT DECIMAL(26,3) No No
TXN_CURRENCY_CD VARCHAR(3) No No
PAID_AMT DECIMAL(26,3) No No
CURRENCY_PYMNT VARCHAR(3) No No
MESSAGE_SET_NBR INT No No
MESSAGE_NBR INT No No
ERROR_MESSAGE VARCHAR(254) No No
Index
Name Type Unique Member
PS_AP_INV_STAT_RES PK Yes
Member(s) of "PS_AP_INV_STAT_RES" Index

Published June 06, 2007