ORG_DFHI_OPT_VW

(SQL View)
Index Back

Origin-Lvl Dflt Hier Opt View


SELECT A.BUSINESS_UNIT , B.ORIGIN , B.ACCOUNTING_DT_IND , B.ACCOUNTING_DT , B.PYMNT_TERMS_CD , B.DFT_SIGHT_CD , B.DST_CNTRL_ID , B.CURRENCY_CD , B.CUR_RT_TYPE , B.VCHR_APPRVL_FLG , B.BUSPROCNAME , B.APPR_RULE_SET , B.DOC_TYPE_FLG , B.DOC_TYPE , B.DUP_INVOICE_IND , B.DUP_INVOICE_ACTION , B.DUP_INV_COMB_CODE , B.CHART_EDIT_OPTION , B.COMBO_EDIT_FLG , B.SHIPTO_ID , B.SUT_BASE_ID , B.SALETX_TOL_FLG , B.SALETX_TOL_PCT , B.SALETX_TOL_AMT , B.SALETX_TOL_CUR_CD , B.SALETX_TOL_RT_TYPE , B.PAY_SCHEDULE_TYPE , B.LATE_CHRG_FLG , B.LATE_CHRG_OPT , B.LATE_CHRG_CD , B.BANK_CD , B.BANK_ACCT_KEY , B.PYMNT_HANDLING_CD , B.PHYSICAL_NATURE , B.ULTIMATE_USE_CD , B.VAT_SVC_PERFRM_FLG , B.MATCH_DELAY_DAYS , B.MATCH_DELAY_FLG FROM PS_BUS_UNIT_TBL_AP A , PS_ORIGIN_AP_OPT B , PS_SET_CNTRL_REC I WHERE B.SETID = I.SETID AND I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'AP_04' AND I.RECNAME = 'ORIGIN_AP_OPT' AND B.EFFDT = ( SELECT MAX(J.EFFDT) FROM PS_ORIGIN_AP_OPT J WHERE J.SETID = B.SETID AND J.ORIGIN = B.ORIGIN AND J.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
3 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
4 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
5 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
6 DFT_SIGHT_CD Character(5) VARCHAR2(5) NOT NULL Draft Sight Code
7 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
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 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
11 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
12 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
13 DOC_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Document Type Flag
D=Default from Higher Level
S=Specify at This level
14 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.
15 DUP_INVOICE_IND Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Indicator
D=Default from Higher Level
S=Specify at this Level
16 DUP_INVOICE_ACTION Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Severity
K=Reject
R=Recycle
W=Warning
17 DUP_INV_COMB_CODE Number(3,0) SMALLINT NOT NULL Dupl Invoice Combination Code
18 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
19 COMBO_EDIT_FLG Character(1) VARCHAR2(1) NOT NULL Edit Combinations
20 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
21 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
22 SALETX_TOL_FLG Character(1) VARCHAR2(1) NOT NULL Sales Tax Tolerance Flag
D=Default from Higher Level
S=Specify at this Level
23 SALETX_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Sales Tax Tolerance Percent
24 SALETX_TOL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Tolerance Amount
25 SALETX_TOL_CUR_CD Character(3) VARCHAR2(3) NOT NULL Sales Tax Tolerance Curr Code
26 SALETX_TOL_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Sales Tax Tolerance Rate Type
27 PAY_SCHEDULE_TYPE Character(3) VARCHAR2(3) NOT NULL Pay Schedule Type
MAN=Manual
OTH=Other Non Transportation
TRN=Transportation
28 LATE_CHRG_FLG Character(1) VARCHAR2(1) NOT NULL Late Charges
D=Default from Higher Level
S=Specify
29 LATE_CHRG_OPT Character(1) VARCHAR2(1) NOT NULL Late Charge Option
C=Compute Charges
N=Not Applicable
30 LATE_CHRG_CD Character(4) VARCHAR2(4) NOT NULL Late Charge Code
31 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
32 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
33 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
34 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
35 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
36 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
37 MATCH_DELAY_DAYS Number(3,0) SMALLINT NOT NULL Match Delay Days
38 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