PeopleSoft 9
Account Payables

Table Name PST_UNBALANCED

Table Description
PST_UNBALANCED
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes No
VOUCHER_ID VARCHAR(8) Yes No
UNPOST_SEQ SMALLINT Yes No
APPL_JRNL_ID VARCHAR(10) Yes No
PYMNT_CNT int Yes No
VOUCHER_LINE_NUM int Yes No
DISTRIB_LINE_NUM int Yes No
DST_ACCT_TYPE VARCHAR(4) Yes No
CF_BAL_LINE_NUM decimal(10) Yes No
LEDGER VARCHAR(10) Yes No
BUSINESS_UNIT_GL VARCHAR(5) No No
LEDGER_GROUP VARCHAR(10) No No
PRIMARY_LEDGER VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
FOREIGN_AMOUNT decimal(26,3) No No
FOREIGN_CURRENCY VARCHAR(3) No No
MONETARY_AMOUNT decimal(26,3) No No
CURRENCY_CD VARCHAR(3) No No
Index
Name Type Unique Member
PS_PST_UNBALANCED PK Yes
Member(s) of "PS_PST_UNBALANCED" Index
BUSINESS_UNIT
VOUCHER_ID
UNPOST_SEQ
APPL_JRNL_ID
PYMNT_CNT
VOUCHER_LINE_NUM
DISTRIB_LINE_NUM
DST_ACCT_TYPE
CF_BAL_LINE_NUM
LEDGER

Published June 06, 2007