ORG_LVL_DFHI_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.DST_CNTRL_ID , B.BANK_CD , B.BANK_ACCT_KEY , B.PYMNT_TERMS_CD , B.DFT_SIGHT_CD , B.PYMNT_HANDLING_CD , B.LATE_CHRG_FLG , B.LATE_CHRG_OPT , B.LATE_CHRG_CD , B.DATE_CALC_BASIS , B.PAY_SCHEDULE_TYPE , B.VCHR_APPRVL_FLG , B.BUSPROCNAME , B.APPR_RULE_SET , B.CURRENCY_CD , B.CUR_RT_TYPE , B.DOC_TYPE_FLG , B.DOC_TYPE , B.DUP_INVOICE_IND , B.DUP_INV_NUM_FLG , B.DUP_INV_DT , B.DUP_INV_VENDOR_NUM , B.DUP_INV_GROSS_AMT , B.DUP_INV_BUS_UNIT , B.DUP_INV_COMB_CODE , B.DUP_INVOICE_ACTION , B.CHART_EDIT_OPTION , B.COMBO_EDIT_FLG , B.VCHR_BALANCE_OPT , B.SHIP_LOC_FLG , B.SHIPTO_ID , B.SUT_BASE_ID , B.ULTIMATE_USE_CD , B.SALETX_TOL_FLG , B.SALETX_TOL_PCT , B.SALETX_TOL_AMT , B.SALETX_TOL_CUR_CD , B.SALETX_TOL_RT_TYPE FROM PS_BUS_UNIT_TBL_AP A , PS_ORIGIN_AP_OPT B WHERE B.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE 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 J.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 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
6 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
7 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
8 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.
9 DFT_SIGHT_CD Character(5) VARCHAR2(5) NOT NULL Draft Sight Code
10 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling
11 LATE_CHRG_FLG Character(1) VARCHAR2(1) NOT NULL Late Charges
D=Default from Higher Level
S=Specify
12 LATE_CHRG_OPT Character(1) VARCHAR2(1) NOT NULL Late Charge Option
C=Compute Charges
N=Not Applicable
13 LATE_CHRG_CD Character(4) VARCHAR2(4) NOT NULL Late Charge Code
14 DATE_CALC_BASIS Character(1) VARCHAR2(1) NOT NULL Date Calculation Basis
A=Agricultural Commodities
D=Dairy
M=Meat
O=Poultry
P=Prompt Pay Basis 7 Days
Q=Prompt Pay Basis 14 Days
15 PAY_SCHEDULE_TYPE Character(3) VARCHAR2(3) NOT NULL Pay Schedule Type
MAN=Manual
OTH=Other Non Transportation
TRN=Transportation
16 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
17 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
18 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
19 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
20 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.
21 DOC_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Document Type Flag
D=Default from Higher Level
S=Specify at This level
22 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.
23 DUP_INVOICE_IND Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Indicator
D=Default from Higher Level
S=Specify at this Level
24 DUP_INV_NUM_FLG Character(1) VARCHAR2(1) NOT NULL Invoice Number
N=No
Y=Yes
25 DUP_INV_DT Character(1) VARCHAR2(1) NOT NULL Invoice Date
N=No
Y=Yes
26 DUP_INV_VENDOR_NUM Character(1) VARCHAR2(1) NOT NULL Vendor ID
N=No
Y=Yes
27 DUP_INV_GROSS_AMT Character(1) VARCHAR2(1) NOT NULL Gross Amount
N=No
Y=Yes
28 DUP_INV_BUS_UNIT Character(1) VARCHAR2(1) NOT NULL Business Unit
N=No
Y=Yes
29 DUP_INV_COMB_CODE Number(3,0) SMALLINT NOT NULL Dupl Invoice Combination Code
30 DUP_INVOICE_ACTION Character(1) VARCHAR2(1) NOT NULL Duplicate Invoice Severity
K=Reject
R=Recycle
W=Warning
31 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
32 COMBO_EDIT_FLG Character(1) VARCHAR2(1) NOT NULL Edit Combinations
33 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
34 SHIP_LOC_FLG Character(1) VARCHAR2(1) NOT NULL Ship To/End Location Flag
D=Default from Higher Level
S=Specify at this Level
35 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
36 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
37 ULTIMATE_USE_CD Character(8) VARCHAR2(8) NOT NULL Ultimate Use Code
38 SALETX_TOL_FLG Character(1) VARCHAR2(1) NOT NULL Sales Tax Tolerance Flag
D=Default from Higher Level
S=Specify at this Level
39 SALETX_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Sales Tax Tolerance Percent
40 SALETX_TOL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Tolerance Amount
41 SALETX_TOL_CUR_CD Character(3) VARCHAR2(3) NOT NULL Sales Tax Tolerance Curr Code
42 SALETX_TOL_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Sales Tax Tolerance Rate Type