BUSINESS_UNIT_PCPROJECT_IDACTIVITY_IDRESOURCE_IDPROCESS_INSTANCEDATETIME_STAMPDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW
A=Applied
C=Committed
E=Rejected
FO_PO_APPL_LOG(SQL Table) |
Index Back |
|---|---|
PO Application logTable to hold the log of the applications of the PO to the different activities. |
| # | 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 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | DATETIME_STAMP |
DateTime(26) | TIMESTAMP | DateTime Stamp |
| 7 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 8 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 10 | CA_PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Internal PO ID |
| 11 | EXTENSION_NBR | Signed Number(4,0) | DECIMAL(3) NOT NULL | Extension Number |
| 12 | CA_PO_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Action
A=Applied C=Committed E=Rejected |
| 13 | 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 |
| 14 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 15 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 16 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 17 | BILL_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 18 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 19 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 20 | ENCUMBRANCE_PCT | Number(6,3) | DECIMAL(5,3) NOT NULL | Encumbrance % |
| 21 | ENCUMBERED_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Encumbered Amount |
| 22 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 23 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |