VED_GRP_AP_VW(SQL View) |
Index Back |
|---|---|
Voucher Edit Group View |
| SELECT A.BUSINESS_UNIT , A.GRP_AP_ID , A.DUP_INVOICE_IND , A.DUP_INVOICE_ACTION , A.DUP_INV_COMB_CODE , A.ACCOUNTING_DT_IND , A.ACCOUNTING_DT , A.CURRENCY_CD , A.CUR_RT_TYPE , A.DST_CNTRL_ID , A.CHART_EDIT_OPTION , A.COMBO_EDIT_FLG , %subrec(VCHR_APPRVL_SBR,A) , A.SHIPTO_ID , A.SUT_BASE_ID , A.SALETX_TOL_FLG , A.SALETX_TOL_PCT , A.SALETX_TOL_AMT , A.SALETX_TOL_CUR_CD , A.SALETX_TOL_RT_TYPE , A.DOC_TYPE_FLG , A.DOC_TYPE , A.PHYSICAL_NATURE , A.ULTIMATE_USE_CD , A.VAT_SVC_PERFRM_FLG , A.MATCH_DELAY_DAYS , A.MATCH_DELAY_FLG FROM PS_GRP_AP A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | GRP_AP_ID | Character(10) | VARCHAR2(10) NOT NULL | Control Group ID |
| 3 | DUP_INVOICE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Indicator
D=Default from Higher Level S=Specify at this Level |
| 4 | DUP_INVOICE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Severity
K=Reject R=Recycle W=Warning |
| 5 | DUP_INV_COMB_CODE | Number(3,0) | SMALLINT NOT NULL | Dupl Invoice Combination Code |
| 6 | 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 |
| 7 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 8 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 9 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 10 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Accounting Template |
| 11 | 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 |
| 12 | COMBO_EDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Edit Combinations |
| 13 | VCHR_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework Default Value: D |
| 14 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: BUSPROCNAME_VW |
| 15 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table: APPR_RULE_HDR |
| 16 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 17 | SUT_BASE_ID | Character(10) | VARCHAR2(10) NOT NULL | Sales/Use Tax Destination |
| 18 | SALETX_TOL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Tolerance Flag
D=Default from Higher Level S=Specify at this Level |
| 19 | SALETX_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Sales Tax Tolerance Percent |
| 20 | SALETX_TOL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Tolerance Amount |
| 21 | SALETX_TOL_CUR_CD | Character(3) | VARCHAR2(3) NOT NULL | Sales Tax Tolerance Curr Code |
| 22 | SALETX_TOL_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Sales Tax Tolerance Rate Type |
| 23 | DOC_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Document Type Flag
D=Default from Higher Level S=Specify at This level |
| 24 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. |
| 25 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 26 | ULTIMATE_USE_CD | Character(8) | VARCHAR2(8) NOT NULL | Ultimate Use Code |
| 27 | VAT_SVC_PERFRM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location |
| 28 | MATCH_DELAY_DAYS | Number(3,0) | SMALLINT NOT NULL | Match Delay Days |
| 29 | MATCH_DELAY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
To indicate whether Match Delay Days is specified at this level or to be defaulted from higher level in the AP defaulting hierarchy.
D=Default from Higher Level S=Specified at This Level |