ARMTWOHD_FL_VW (SQL View)	Index Back
Maintenance Header view Maintenance Header view

ARMTWOHD_FL_VW

(SQL View)

Maintenance Header view

SELECT DISTINCT M.WS_BU , M.WS_ID , M.GROUP_SEQ_NUM , M.GROUP_TYPE , M.WS_TOTAL_WO , M.WS_TOTAL_REF , M.AR_WOAPPR_STATUS , M.CURRENCY_CD , M.ACCOUNTING_DT , M.WS_REASON , 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_MAINT_WO_AW X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_WS_CONTROL M WHERE M.WS_BU=X.WS_BU AND M.WS_ID=X.WS_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_MAINT_WO_AW X1 WHERE X1.WS_BU=X.WS_BU AND X1.WS_ID=X.WS_ID AND X1.EOAWPRCS_ID = X.EOAWPRCS_ID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 WS_BU Character(5) VARCHAR2(5) NOT NULL Worksheet Business Unit

2 WS_ID Character(15) VARCHAR2(15) NOT NULL Worksheet ID

3 GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.

4 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.

5 WS_TOTAL_WO Signed Number(28,3) DECIMAL(26,3) NOT NULL Write Off

6 WS_TOTAL_REF Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Worksheet Refunds

7 AR_WOAPPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved Write-Off
D=Denied Write-Off
I=Initial
P=Pending Write-Off Approval
Default Value: I

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURR_CD_AR_VW

9 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date

10 WS_REASON Character(10) VARCHAR2(10) NOT NULL Reason Code
Prompt Table: WS_REASON_TBL

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

12 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
1=High
2=Medium
3=Low

13 HDR_DETAIL5 Character(50) VARCHAR2(50) NOT NULL Header Detail 5

14 EOAWSTART_DT Date(10) DATE Start Date

15 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

16 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed

17 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID

18 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

19 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

20 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

21 EFFDT Date(10) DATE Effective Date
Default Value: %date

22 EOAWPATH_ID Character(30) VARCHAR2(30) NOT NULL Approval Path ID

23 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.

24 EOAWSTAGE_NBR Number(3,0) SMALLINT NOT NULL Approval Framework Stage Number

25 EOAWSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path

26 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier

27 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

28 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

29 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified

30 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	WS_BU	Character(5)	VARCHAR2(5) NOT NULL	Worksheet Business Unit
2	WS_ID	Character(15)	VARCHAR2(15) NOT NULL	Worksheet ID
3	GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
4	GROUP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
5	WS_TOTAL_WO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Write Off
6	WS_TOTAL_REF	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Worksheet Refunds
7	AR_WOAPPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved Write-Off D=Denied Write-Off I=Initial P=Pending Write-Off Approval Default Value: I
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURR_CD_AR_VW
9	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple Default Value: %date
10	WS_REASON	Character(10)	VARCHAR2(10) NOT NULL	Reason Code Prompt Table: WS_REASON_TBL
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
12	PRIORITY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Priority Flag 1=High 2=Medium 3=Low
13	HDR_DETAIL5	Character(50)	VARCHAR2(50) NOT NULL	Header Detail 5
14	EOAWSTART_DT	Date(10)	DATE	Start Date
15	EOAWORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
16	EOAWDTTM_COMPLETE	DateTime(26)	TIMESTAMP	Date/Time Completed
17	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
18	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
19	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
20	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
21	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
22	EOAWPATH_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Path ID
23	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.
24	EOAWSTAGE_NBR	Number(3,0)	SMALLINT NOT NULL	Approval Framework Stage Number
25	EOAWSTEP_NBR	Number(6,2)	DECIMAL(5,2) NOT NULL	Sequence number of step in its path
26	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
27	EOAWREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
28	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
29	EOAWDTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
30	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created