GRP_AP_OPR_VW4

(SQL View)
 Index Back

AP Control Group Table View


select business_unit, grp_ap_id, group_dt, grp_ap_status, ctl_gross_amt, ctl_vouchers, grp_ap_tape_flg, assigned_by_oprid, assigned_to_oprid, dttm_assigned, dttm_due, dttm_complete, dup_invoice_ind, dup_invoice_action, dup_inv_num_flg, dup_inv_dt, dup_inv_vendor_num, dup_inv_gross_amt, dup_inv_bus_unit, accounting_dt_ind, accounting_dt, dst_cntrl_id, post_timing, post_action_ap, vchr_balance_opt, chart_edit_option, process_instance, currency_cd from PS_GRP_AP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AP_NONVW

2 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID

Default Value: NEXT

Prompt Table: GRP_AP

3 GROUP_DT Date(10) DATE Group Control Date

Default Value: %date

4 GRP_AP_STATUS Character(1) VARCHAR2(1) NOT NULL Status of Control Group
A=Assigned
E=Entry Set Aside
O=Open
R=Ready for Review
S=Supervisor Set Aside
V=Verified

Default Value: O

5 CTL_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Control Gross Amount
6 CTL_VOUCHERS Number(6,0) INTEGER NOT NULL Control Voucher Number
7 GRP_AP_TAPE_FLG Character(1) VARCHAR2(1) NOT NULL Run a Tape
8 ASSIGNED_BY_OPRID Character(30) VARCHAR2(30) NOT NULL Group Assigned by

Default Value: OPR_DEF_TBL_AP.OPRID

9 ASSIGNED_TO_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned to

Prompt Table: OPR_AP_VW

10 DTTM_ASSIGNED DateTime(26) TIMESTAMP Date/Time Assigned
11 DTTM_DUE DateTime(26) TIMESTAMP Date/Time Due
12 DTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
13 DUP_INVOICE_IND Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Indicator
D=Default from Higher Level
S=Specify at this Level

Default Value: D

14 DUP_INVOICE_ACTION Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Severity
K=Reject
R=Recycle
W=Warning

Default Value: K

15 DUP_INV_NUM_FLG Character(1) VARCHAR2(1) NOT NULL Invoice Number
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

16 DUP_INV_DT Character(1) VARCHAR2(1) NOT NULL Invoice Date
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

17 DUP_INV_VENDOR_NUM Character(1) VARCHAR2(1) NOT NULL Vendor ID
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

18 DUP_INV_GROSS_AMT Character(1) VARCHAR2(1) NOT NULL Gross Amount
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

19 DUP_INV_BUS_UNIT Character(1) VARCHAR2(1) NOT NULL Business Unit
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

20 ACCOUNTING_DT_IND Character(1) VARCHAR2(1) NOT NULL Accounting Date Indicator
C=Use Current Date
D=Business Unit Default
P=Use Payment Date
S=Use Specific Date

Default Value: D

21 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
22 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template

Prompt Table: DST_CNTRL_VW

23 POST_TIMING Character(1) VARCHAR2(1) NOT NULL Posting Timing
G=Post Only when Group Balanced
V=Post Vouchers Individually

Default Value: V

24 POST_ACTION_AP Character(1) VARCHAR2(1) NOT NULL Post Group
D=Post on a Deferred basis
N=Do Not Post
P=Post Immediately

Default Value: N

25 VCHR_BALANCE_OPT Character(1) VARCHAR2(1) NOT NULL Voucher Balance Option
D=Default from Higher Level
K=Reject Unbalanced Vouchers
R=Recycle Unbalanced Vouchers

Default Value: D

26 CHART_EDIT_OPTION Character(1) VARCHAR2(1) NOT NULL Chartfield Edit Option
D=Default from Higher Level
K=Reject w/ edit error
N=No Edits
R=Recycle
S=Use suspense account
W=Warning

Default Value: D

27 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code