PeopleSoft 9
Account Payables

Table Name PYMNT_ADVICE

Table Description
PYMNT_ADVICE
Columns
Name Datatype Is PK Is FK
PAY_CYCLE VARCHAR(6) Yes Yes
PAY_CYCLE_SEQ_NUM int Yes Yes
BANK_SETID VARCHAR(5) Yes Yes
BANK_CD VARCHAR(5) Yes Yes
BANK_ACCT_KEY VARCHAR(4) Yes Yes
PYMNT_METHOD VARCHAR(3) Yes Yes
PYMNT_SEPARATE VARCHAR(1) Yes No
PAY_DOC_SEQ int Yes No
PYMNT_ID_REF VARCHAR(20) Yes No
PYMNT_OVERFLOW_ID VARCHAR(10) Yes No
SOURCE_TXN VARCHAR(4) Yes No
BUSINESS_UNIT VARCHAR(5) Yes No
PAY_DOC_ID VARCHAR(20) Yes No
REMIT_LINE_TYPE VARCHAR(1) Yes No
PYMNT_ADVICE_COMBO VARCHAR(38) Yes No
PYCYCL_KEY_FIELD2 PSDATE Yes No
CURRENCY_PYMNT VARCHAR(3) No No
REMIT_SETID VARCHAR(5) No No
REMIT_VENDOR VARCHAR(10) No No
AR_NUM VARCHAR(15) No No
VENDOR_ID VARCHAR(10) No No
EMPLID VARCHAR(11) No No
INVOICE_ID VARCHAR(30) No No
PAY_DOC_DT PSDATE No No
PAID_AMT_GROSS decimal(26,3) No No
PAID_AMT decimal(26,3) No No
DISCOUNT_TAKEN decimal(26,3) No No
PAID_AMT_DSCNT decimal(26,3) No No
PYMNT_MESSAGE VARCHAR(70) No No
PYMNT_HANDLING_CD VARCHAR(2) No No
PYMNT_ID VARCHAR(10) No Yes
ORIGIN VARCHAR(3) No No
SBI_NUM VARCHAR(40) No No
ADVICE_SEQ_CHAR VARCHAR(5) No No
Index
Name Type Unique Member
PS_PYMNT_ADVICE PK Yes
PSAPYMNT_ADVICE IE1 No
Member(s) of "PS_PYMNT_ADVICE" Index
PAY_CYCLE
PAY_CYCLE_SEQ_NUM
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_METHOD
PYMNT_SEPARATE
PAY_DOC_SEQ
PYMNT_ID_REF
PYMNT_OVERFLOW_ID
SOURCE_TXN
BUSINESS_UNIT
PAY_DOC_ID
REMIT_LINE_TYPE
PYMNT_ADVICE_COMBO
PYCYCL_KEY_FIELD2
Member(s) of "PSAPYMNT_ADVICE" Index
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_ID
PYMNT_METHOD
PYMNT_ID_REF

Published June 06, 2007