ARDFWOHD_FL_VW (SQL View)	Index Back
Draft writeoff header Draft writeoff header

ARDFWOHD_FL_VW

(SQL View)

Draft writeoff header

SELECT DISTINCT D.DRAFT_BU , D.DRAFT_ID , D.DRAFT_STATUS , D.DRAFT_DOC_REF , D.WO_ITEM_AMT , D.DRAFT_CURRENCY , D.DRAFT_TYPE , D.GROUP_ID , 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_DRAFT_WO_AW X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_DRAFT_CONTROL D WHERE D.DRAFT_BU=X.DRAFT_BU AND D.DRAFT_ID=X.DRAFT_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_DRAFT_WO_AW X1 WHERE X1.DRAFT_BU=X.DRAFT_BU AND X1.DRAFT_ID=X.DRAFT_ID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DRAFT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARDS_NONVW

2 DRAFT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.
Default Value: NEXT
Prompt Table: DRAFT_CONTROL

3 DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
A=Accepted
C=Complete
D=Dishonored
E=Void
I=Identified
L=Collateral
M=Discounted
N=No Action
P=Pending
R=Remitted
T=Endorsed
Default Value: I

4 DRAFT_DOC_REF Character(20) VARCHAR2(20) NOT NULL Draft Reference

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

6 DRAFT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft.

7 DRAFT_TYPE Character(10) VARCHAR2(10) NOT NULL A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).
Prompt Table: DR_TYPE_ENT_VW
Set Control Field: DRAFT_BU

8 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.

9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DRAFT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process. Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDS_NONVW
2	DRAFT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered. Default Value: NEXT Prompt Table: DRAFT_CONTROL
3	DRAFT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Draft Status A=Accepted C=Complete D=Dishonored E=Void I=Identified L=Collateral M=Discounted N=No Action P=Pending R=Remitted T=Endorsed Default Value: I
4	DRAFT_DOC_REF	Character(20)	VARCHAR2(20) NOT NULL	Draft Reference
5	WO_ITEM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Write Off Item
6	DRAFT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft.
7	DRAFT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2). Prompt Table: DR_TYPE_ENT_VW Set Control Field: DRAFT_BU
8	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: 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