BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW
CA_PO_IDEXTENSION_NBRPROCESS_INSTANCEA=Applied
C=Committed
E=Rejected
FO_PO_APPL_VW(SQL View) |
Index Back |
|---|---|
PO Application log ViewPO Application log View |
| SELECT L.BUSINESS_UNIT_PC , L.PROJECT_ID , L.ACTIVITY_ID , L.RESOURCE_ID , L.DATETIME_STAMP , L.CONTRACT_NUM , H.DESCR , L.CONTRACT_LINE_NUM , D.DESCR , L.BUSINESS_UNIT , L.CA_PO_ID , L.EXTENSION_NBR , L.PROCESS_INSTANCE , L.CA_PO_ACTION , L.PO_AMT1 , L.INVOICE , L.INVOICE_DT , L.INVOICE_LINE , L.BILL_PLAN_ID , L.NET_EXTENDED_AMT , L.TAX_AMT , L.ENCUMBRANCE_PCT , L.ENCUMBERED_AMOUNT , L.MESSAGE_SET_NBR , L.MESSAGE_NBR , H.CURRENCY_CD FROM PS_FO_PO_APPL_LOG L , PS_CA_CONTR_HDR H , PS_CA_DETAIL D WHERE L.CONTRACT_NUM = D.CONTRACT_NUM AND L.CONTRACT_LINE_NUM = D.CONTRACT_LINE_NUM AND L.CONTRACT_NUM = H.CONTRACT_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |
| 5 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 6 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 7 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 8 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 9 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 10 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 11 | CA_PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Internal PO ID |
| 12 | EXTENSION_NBR |
Signed Number(4,0) | DECIMAL(3) NOT NULL | Extension Number |
| 13 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 14 | CA_PO_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Action
A=Applied C=Committed E=Rejected |
| 15 | PO_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 16 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 17 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 18 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 19 | BILL_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 20 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 21 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 22 | ENCUMBRANCE_PCT | Number(6,3) | DECIMAL(5,3) NOT NULL | Encumbrance % |
| 23 | ENCUMBERED_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Encumbered Amount |
| 24 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 25 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |