PO_REQPOST_AET(SQL Table) |
Index Back |
---|---|
PO Req Posting Cache Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |