GFPYM_SCH_CANC (SQL View)	Index Back
Cancel sched pymnt info

GFPYM_SCH_CANC

(SQL View)

Cancel sched pymnt info

SELECT A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.PYMNT_ID_REF , A.PYMNT_ID , A.PYMNT_METHOD , A.SCHEDULE_ID , A.BANK_ACCOUNT_NUM , A.REMIT_SETID , A.REMIT_VENDOR , A.NAME1 , A.PYMNT_DT , A.CREATION_DT , A.OPRID , A.PYMNT_AMT , A.CURRENCY_PYMNT , A.PYMNT_HANDLING_CD , A.PYMNT_STATUS , A.PYMNT_RECONCILE_DT , A.CANCEL_ACTION , A.CANCEL_DT , A.ACCOUNTING_DT , A.POST_STATUS_AP , A.PROCESS_INSTANCE , A.PAY_CYCLE , A.PAY_CYCLE_SEQ_NUM , A.RECON_TYPE , A.RECON_CYCLE_NBR , A.POSITIVE_PAY_STAT , A.CASH_CLEARED_DT , A.RECON_STATUS , A.CASH_CLEARED_FLG , A.CANCEL_POST_STATUS , A.DESCRLONG FROM PS_PAYMENT_TBL A WHERE SCHEDULE_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
Default Value: OPR_BANK_VW_AP.BANK_SETID

2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
Prompt Table: BANK_CD_TBL

3 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

4 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference

5 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number

6 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

7 SCHEDULE_ID Character(10) VARCHAR2(10) NOT NULL Schedule ID

8 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

9 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

10 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

12 PYMNT_DT Date(10) DATE Payment Date

13 CREATION_DT Date(10) DATE Creation Date

14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

15 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount

16 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

17 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling

18 PYMNT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted

19 PYMNT_RECONCILE_DT Date(10) DATE Date Reconciled

20 CANCEL_ACTION Character(1) VARCHAR2(1) NOT NULL Cancel Action
C=Do Not Reissue/Close Liability
H=Re-Open Voucher(s)/Put on Hold
N=No Cancel Action
P=Processed
R=Re-Open Voucher(s)/Re-Issue
S=Stale Dated Check
W=Escheated

21 CANCEL_DT Date(10) DATE Date Cancelled

22 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

23 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted

24 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

25 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

26 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

27 RECON_TYPE Character(1) VARCHAR2(1) NOT NULL Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled
B=Balance System(s) to BankTran
F=Forced to Reconcile
M=Manually Reconciled
S=Semi Manual
U=Unreconciled

28 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.

29 POSITIVE_PAY_STAT Character(1) VARCHAR2(1) NOT NULL Positive Payment Status
C=Sent to bank
N=Not Sent to bank
S=Selected for transmission
Z=Zero Payment

30 CASH_CLEARED_DT Date(10) DATE Cash Cleared Date

31 RECON_STATUS Character(3) VARCHAR2(3) NOT NULL Reconciliation Status
ALG=Alignment Check
AMB=Ambiguous Match
AMT=Amounts Not Equal
CUR=Currency not Defined
DAT=Tran Date <> Value Date
DPI=Duplicate Input Transactions
DUP=Duplicate Transaction
MSC=Miscellaneous Transaction
NAM=Payee Names Not Equal
NTB=Not Found in Statement
NTF=Not Found In System
NTP=Not Found in POS Data
NUL=Null Transaction ID Ref
OVR=Overflow
PND=Pending Reconciliation
REC=Reconciled
RPR=Reprinted Check
RR=Requires Review - BSAC
STP=Stop Payment
TYP=Wrong Transaction Type
UNR=Unreconciled
VOI=Voided Check

32 CASH_CLEARED_FLG Character(1) VARCHAR2(1) NOT NULL Cash Cleared Flag

33 CANCEL_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Used to determine the post status of cancelled payment. If posting has not been run it will be set to W Pending. If the payment action is not V Void, S Stopped, W Escheated Check then the value is N. If the payment has not be posted but has been cancel the value = W. After the cancellation has been posted it the value is P posted.
N=Not Applicable
P=Posted
W=Pending

34 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty. Default Value: OPR_BANK_VW_AP.BANK_SETID
2	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_TBL
3	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
4	PYMNT_ID_REF	Character(20)	VARCHAR2(20) NOT NULL	Payment Reference
5	PYMNT_ID	Character(10)	VARCHAR2(10) NOT NULL	Payment Number
6	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
7	SCHEDULE_ID	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID
8	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
9	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
10	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
11	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
12	PYMNT_DT	Date(10)	DATE	Payment Date
13	CREATION_DT	Date(10)	DATE	Creation Date
14	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
15	PYMNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amount
16	CURRENCY_PYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Currency
17	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling
18	PYMNT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Alignment E=ACH/EFT Prenote L=Stale Dated Payment N=Reprinted with same ref number O=Overflow P=Paid R=Replaced S=Stopped T=Undo Escheatment U=Undo Cancel V=Void W=Escheated Check X=Deleted
19	PYMNT_RECONCILE_DT	Date(10)	DATE	Date Reconciled
20	CANCEL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Cancel Action C=Do Not Reissue/Close Liability H=Re-Open Voucher(s)/Put on Hold N=No Cancel Action P=Processed R=Re-Open Voucher(s)/Re-Issue S=Stale Dated Check W=Escheated
21	CANCEL_DT	Date(10)	DATE	Date Cancelled
22	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
23	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
24	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
25	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
26	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
27	RECON_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank A=Automatically Reconciled B=Balance System(s) to BankTran F=Forced to Reconcile M=Manually Reconciled S=Semi Manual U=Unreconciled
28	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
29	POSITIVE_PAY_STAT	Character(1)	VARCHAR2(1) NOT NULL	Positive Payment Status C=Sent to bank N=Not Sent to bank S=Selected for transmission Z=Zero Payment
30	CASH_CLEARED_DT	Date(10)	DATE	Cash Cleared Date
31	RECON_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Reconciliation Status ALG=Alignment Check AMB=Ambiguous Match AMT=Amounts Not Equal CUR=Currency not Defined DAT=Tran Date <> Value Date DPI=Duplicate Input Transactions DUP=Duplicate Transaction MSC=Miscellaneous Transaction NAM=Payee Names Not Equal NTB=Not Found in Statement NTF=Not Found In System NTP=Not Found in POS Data NUL=Null Transaction ID Ref OVR=Overflow PND=Pending Reconciliation REC=Reconciled RPR=Reprinted Check RR=Requires Review - BSAC STP=Stop Payment TYP=Wrong Transaction Type UNR=Unreconciled VOI=Voided Check
32	CASH_CLEARED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Cash Cleared Flag
33	CANCEL_POST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Used to determine the post status of cancelled payment. If posting has not been run it will be set to W Pending. If the payment action is not V Void, S Stopped, W Escheated Check then the value is N. If the payment has not be posted but has been cancel the value = W. After the cancellation has been posted it the value is P posted. N=Not Applicable P=Posted W=Pending
34	DESCRLONG	Long Character	CLOB	Long Description