DR_EFT_TYPE_VW(SQL View) |
Index Back |
---|---|
Draft Type |
SELECT %subrec(DR_EFT_TYPE_VW, A) FROM PS_DRAFT_TYPE_TBL A WHERE A.DRAFT_EFT_FLG = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | 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: DRAFT_TYPE_TBL |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DRAFT_INITIATOR | Character(1) | VARCHAR2(1) NOT NULL |
Draft Initiator
C=Customer V=Supplier |
5 | DRAFT_TXN_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Draft Transaction Type
Prompt Table: DR_TXN_TYPE_TBL |
6 | DISCOUNT_DRAFT | Character(1) | VARCHAR2(1) NOT NULL |
Discount Draft
Y/N Table Edit Default Value: N |
7 | DRAFT_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
"Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""."
P=Preapproved R=Approval Required |
8 | DRAFT_DOC | Character(1) | VARCHAR2(1) NOT NULL |
"A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. "
C=Create Document N=Do Not Create Document |
9 | DRAFT_NUM_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Auto-number Draft Ref
Y/N Table Edit Default Value: N |
10 | DRAFT_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
"A flag that indicates whether a draft will be associated with a single item or with multiple items. This field is used only when the payment method is ""draft""."
M=Multiple Items Per Draft S=Single Item Per Draft Default Value: M |
11 | REJECT_REASON_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Reject Reason Required
Y/N Table Edit Default Value: Y |
12 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type |
13 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
14 | DRAFT_EFT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
EFT Draft Flag
Y/N Table Edit Default Value: N |
15 | DRAFT_CANCEL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Permit Remittance Cancellation
Y/N Table Edit Default Value: Y |
16 | DRAFT_UNPOST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Permit Unpost Draft
Y/N Table Edit Default Value: Y |
17 | DRAFT_VOID_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Permit Void Draft
Y/N Table Edit Default Value: Y |