PO_REQPOST_AET

(SQL Table)
Index Back

PO Req Posting Cache Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPL_ABORT Character(1) VARCHAR2(1) NOT NULL AE Application Abort Indicator
3 AE_MSG_NUM Number(5,0) INTEGER NOT NULL Message Number
4 AE_CNV_IN_FLD_NM Character(18) VARCHAR2(18) NOT NULL AE input convert field
5 AE_CNV_OUT_FLD_NM Character(18) VARCHAR2(18) NOT NULL AE output converion field
6 AE_CNV_FILL_CHAR Character(1) VARCHAR2(1) NOT NULL AE Convert Fill Character
7 AE_CNV_JUSTIFY Character(1) VARCHAR2(1) NOT NULL AE Convert Justify Indicator
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
10 RUN_DT Date(10) DATE Run Date
11 PO_POST_RUN_IND Character(1) VARCHAR2(1) NOT NULL /* 615584 05/05/2005 - Added a new label for RTV Recon Process */
A=All BUs
B=1 Bus Unit
D=1 Document
12 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
D=Distributed
N=None
13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
14 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
15 PRCS_OPTION_ID Character(5) VARCHAR2(5) NOT NULL Processing Option ID
16 SETID Character(5) VARCHAR2(5) NOT NULL SetID
17 POST_OPTION Character(1) VARCHAR2(1) NOT NULL Posting Option
18 POST_THRU_DT Date(10) DATE Post Thru Date
19 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
20 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
21 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
22 APPL_JRNL_ID_PREM Character(10) VARCHAR2(10) NOT NULL Pre-Encumbrance
23 APPL_JRNL_ID_PREL Character(10) VARCHAR2(10) NOT NULL Pre-Encumbrance Closure
24 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template