ARDFWOHD_FL_VW(SQL View) |
Index Back |
---|---|
Draft writeoff headerDraft 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 | 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 | 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
|
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 |