ARPYWOHD_FL_VW

(SQL View)
 Index Back

Payment Write-off FL Header


SELECT DISTINCT V.DEPOSIT_BU , V.DEPOSIT_ID , V.PAYMENT_SEQ_NUM ,DE.PAY_WS_TYPE , V.PAYMENT_ID , V.WO_ITEM_AMT , V.PAYMENT_CURRENCY , V.ACCOUNTING_DT , U.OPRID ,'2' ,' ' , U.EOAWDTTM_MODIFIED , U.EOAWORIG_OPRID , U.EOAWDTTM_COMPLETE , S.EOAWTHREAD_ID , U.EOAWSTEP_STATUS , S.EOAWPRCS_ID , S.EOAWDEFN_ID , S.EFFDT ,S.EOAWPATH_ID ,S.EOAWSTEP_INSTANCE ,S.EOAWSTAGE_NBR ,S.EOAWSTEP_NBR ,X.ORIGINATORID , X.EOAWREQUESTOR_ID , X.EOAWTHREAD_STATUS , X.EOAWDTTM_MODIFIED ,%DateOut(%DatePart (U.DTTM_CREATED )) FROM PS_AR_PAYMENTWO_AW X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_PAYMENT V ,PS_DEPOSIT_CONTROL DE WHERE V.DEPOSIT_ID = X.DEPOSIT_ID AND V.DEPOSIT_BU=X.DEPOSIT_BU AND V.PAYMENT_SEQ_NUM=X.PAYMENT_SEQ_NUM AND V.DEPOSIT_BU=DE.DEPOSIT_BU AND V.DEPOSIT_ID=DE.DEPOSIT_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND X.EOAWTHREAD_ID = ( SELECT MAX(X1.EOAWTHREAD_ID) FROM PS_AR_PAYMENTWO_AW X1 WHERE X1.DEPOSIT_ID = X.DEPOSIT_ID AND X1.DEPOSIT_BU=X.DEPOSIT_BU AND X1.PAYMENT_SEQ_NUM=X.PAYMENT_SEQ_NUM )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
2 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
3 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
4 PAY_WS_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Worksheet Type
C=Credit Card Worksheet
E=ePayment Worksheet
P=Payment Worksheet
5 PAYMENT_ID Character(15) VARCHAR2(15) NOT NULL Identifies a customer payment. This is usually a check number but may be some other identifying number.
6 WO_ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Write Off Item
7 PAYMENT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
8 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
10 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
1=High
2=Medium
3=Low
11 HDR_DETAIL5 Character(50) VARCHAR2(50) NOT NULL Header Detail 5
12 EOAWSTART_DT Date(10) DATE Start Date
13 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
14 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
15 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
16 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
17 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
18 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
19 EFFDT Date(10) DATE Effective Date

Default Value: %date

20 EOAWPATH_ID Character(30) VARCHAR2(30) NOT NULL Approval Path ID
21 EOAWSTEP_INSTANCE Number(15,0) DECIMAL(15) NOT NULL Object id of a step instance. Generated off the main thread id for the approval process.
22 EOAWSTAGE_NBR Number(3,0) SMALLINT NOT NULL Approval Framework Stage Number
23 EOAWSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path
24 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
25 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
26 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
A=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Awaiting Further Approvals
T=Terminated
W=Canceled
X=Suspended/Pending Denial
27 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
28 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created