EX_ADV_CHK (SQL Table)	Index Back
Cash Advance Checks Check Amount Entry. To allow reconciliation of unused cash advances.

EX_ADV_CHK

(SQL Table)

Cash Advance Checks

Check Amount Entry. To allow reconciliation of unused cash advances.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID

2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

3 CHECK_NBR Character(30) VARCHAR2(30) NOT NULL Check Number

4 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
Default Value: 0

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: EX_ADV_HDR.CURRENCY_CD

6 PAYMENT_DT Date(10) DATE NOT NULL Payment Date
Default Value: %date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID
2	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	CHECK_NBR	Character(30)	VARCHAR2(30) NOT NULL	Check Number
4	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Default Value: 0
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: EX_ADV_HDR.CURRENCY_CD
6	PAYMENT_DT	Date(10)	DATE NOT NULL	Payment Date Default Value: %date