BI_WKSH_UPD_AET(SQL Table) |
Index Back |
---|---|
Billing Worksheet Update AETBilling Worksheet Update AET Date Initials Issue # Description 061307 ss 1638684000 Added PBI_NZERO_EVENTto track Txn - PBI, non UTL, such that non zero event ocucurence in bill plan. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
4 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
5 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
6 | ADD_LINES | Character(1) | VARCHAR2(1) NOT NULL | Add Lines |
7 | BI_ACTION_TMP | Character(1) | VARCHAR2(1) NOT NULL |
Bill Action
A=Approve Later C=Approve Now D=Delete Later R=Delete Now |
8 | ADD_TO_BILL_CHKBX | Character(1) | VARCHAR2(1) NOT NULL |
Add to Existing Bill
N=No Y=Yes |
9 | ADD_TO_BILL | Character(22) | VARCHAR2(22) NOT NULL | Add To Bill |
10 | BILL_BY_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill By Identifier |
11 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: %EDITTABLE2 |
12 | THRU_BILL_TO_CUST | Character(15) | VARCHAR2(15) NOT NULL |
THRU_BILL_TO_CUST_ID
Prompt Table: %EDITTABLE2 |
13 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table: BI_TYPE_EF_VW |
14 | THRU_BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Thru Bill Type Identifier
Prompt Table: BI_TYPE_EF_VW |
15 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC_EF_VW |
16 | THRU_BILL_SOURCE | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC_EF_VW |
17 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table: CA_TYPE_TBL |
18 | THRU_CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table: CA_TYPE_TBL |
19 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: %EDITTABLE3 |
20 | THRU_CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Thru Contract Number
Prompt Table: %EDITTABLE3 |
21 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDITTABLE4 |
22 | THRU_PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Thru Project Id
Prompt Table: %EDITTABLE4 |
23 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table: BI_SPECIALST_VW |
24 | THRU_BI_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL |
Thru Billing Specialist
Prompt Table: BI_SPECIALST_VW |
25 | START_INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Starting Invoice Number
Prompt Table: %EDITTABLE |
26 | END_INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Ending Invoice Number
Prompt Table: %EDITTABLE |
27 | LC_ID | Character(12) | VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
Prompt Table: %EDITTABLE5 |
28 | THRU_LC_ID | Character(12) | VARCHAR2(12) NOT NULL |
Thru Treasury Letter of Credit Number Assigned by the System
Prompt Table: %EDITTABLE5 |
29 | LOC_DOC_ID | Character(30) | VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
Prompt Table: %EDITTABLE6 |
30 | THRU_LOC_DOC_ID | Character(15) | VARCHAR2(15) NOT NULL |
Thru Letter of Credit Document ID
Prompt Table: %EDITTABLE6 |
31 | INVOICE_AMT_PRETAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
32 | THRU_INVAMT_PRETAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Thru Pretax Invoice Amount |
33 | ADDED_IN_DAYS | Number(3,0) | SMALLINT NOT NULL | Added within days |
34 | DATE_ADDED | Date(10) | DATE | Date Added |
35 | THRU_DATE | Date(10) | DATE | Through Date |
36 | USER1 | Character(1) | VARCHAR2(1) NOT NULL | Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10). |
37 | THRU_USER1 | Character(1) | VARCHAR2(1) NOT NULL | Thru USER1 (customizable and user defined field) |
38 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
39 | ACCOUNTING_DT_TO | Date(10) | DATE | The range of the accounting entry construction dates |
40 | INVOICE_DT | Date(10) | DATE | Invoice Date |
41 | INVOICE_DT_TO | Date(10) | DATE | Through |
42 | BI_WKSH_RERUN | Character(1) | VARCHAR2(1) NOT NULL |
Billin gWorksheet Update Rerun Option
1=Use Same Criteria 2=Use New Criteria N=Don't Rerun |
43 | BI_WKSH_PROC_ST | Character(3) | VARCHAR2(3) NOT NULL |
Billing Worksheet Update Process State
001=No records processed 005=Rerun initial processing 010=BI records locked 015=CA_BILL_PLAN locked 050=Invoice Numbers Assigned 100=BI records updated 101=After Approval 102=Reprocess Partials 110=Additional BI records locked 120=Project Resource IDs assigned 121=Project resource locked 125=CA_BILL_PLAN locked-del PBI 130=FO_PO_HDR locked 140=CA_PREPAID_TBL locked 150=CA_BILL_PLAN locked-del wrksht 160=PC/FO/CA records updated 162=Rerun After Non-BI Updates 170=Addl BI recs locked for delete 200=CA_BILL_PLAN lock - other 210=CA recs updated-other 250=BI records deleted |
44 | BILL_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
45 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
46 | LAST_LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Last Line Sequence Number |
47 | LATEST_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Latest Line Sequence |
48 | LINE_SEQ_CNT | Number(5,0) | INTEGER NOT NULL | Line Sequence Counter |
49 | LAST_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Last invoice |
50 | DUP_INVOICE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Indicator
D=Default from Higher Level S=Specify at this Level |
51 | FO_INSTALLED | Character(1) | VARCHAR2(1) NOT NULL |
Front Office Installed
N=No Y=Yes |
52 | LAST_RESOURCE_ID | Number(20,0) | DECIMAL(20) NOT NULL | Last Transaction ID |
53 | PBI_NUTL_FLG | Character(1) | VARCHAR2(1) NOT NULL | PBI Non UTL Lines Flag |
54 | ORIG_LAST_RES_ID | Number(20,0) | DECIMAL(20) NOT NULL | Original Last Resource ID |
55 | PBI_UTL_DEL_FLG | Character(1) | VARCHAR2(1) NOT NULL | PBI UTL Lines Delete Flag |
56 | PBI_NUTL_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | PBI Non UTL Lines Count |
57 | CBI_FLAG | Character(1) | VARCHAR2(1) NOT NULL | CBI Origin Flag |
58 | CBI_ZERO_EVENT | Character(1) | VARCHAR2(1) NOT NULL | CBI Zero Event Flag |
59 | CBI_NZERO_EVENT | Character(1) | VARCHAR2(1) NOT NULL | CBI Non Zero Event Flag |
60 | CBI_UTL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | CBI UTL Flag |
61 | CBI_RECUR_FLG | Character(1) | VARCHAR2(1) NOT NULL | CBI Recurring Flag |
62 | FO_PO_UPD_FLG | Character(1) | VARCHAR2(1) NOT NULL | FO_PO Update Flag |
63 | SQL_STMT | Long Character(8192) | CLOB | An internal work field that contains SQL text that is to be utilized in treasury application processing. |
64 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |
65 | SQL_GROUP_BY_001 | Character(254) | VARCHAR2(254) NOT NULL | |
66 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
67 | LOCK_ERROR | Character(1) | VARCHAR2(1) NOT NULL | Lock Error Flag |
68 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
69 | INVOICE_NUMBERING | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Numbering Option
B=Business Unit O=Bill Source S=System T=Bill Type U=User Defined |
70 | IVC_NUM_ID | Character(8) | VARCHAR2(8) NOT NULL | Invoice Number ID |
71 | FIRST_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | First Sequence number in list |
72 | LAST_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Last Sequence number in list |
73 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
74 | WITHHOLDING | Character(1) | VARCHAR2(1) NOT NULL | Withholding Post Functions |
75 | DELETE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Delete Loaded Items |
76 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
77 | GL_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal |
78 | BI_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Billing Distribution Status
D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet |
79 | CA_PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Internal PO ID |
80 | EXTENSION_NBR | Signed Number(4,0) | DECIMAL(3) NOT NULL | Extension Number |
81 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
82 | CONTRACT_PPD_SEQ | Number(5,0) | INTEGER NOT NULL | Prepaid Add Sequence |
83 | ACCOUNTING_EXISTS | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Exists field is used in the temporary record CA_AP_MS_TA0 to determine if the processed milestone events can use their milestone completion date as their accounting date if they have valid accounting distribution.
Default Value: N |
84 | WRKSHT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Billing Worksheet Status
0=Not Processed 1=In Process 2=In Process - Other Update 3=In Process - Billing Delete 8=Error 9=Successful Update |
85 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
86 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |
87 | ERROR_STATUS_BI | Character(4) | VARCHAR2(4) NOT NULL | Error Status |
88 | VAT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | VAT Flag |
89 | PROCESS_INST_STG | Number(10,0) | DECIMAL(10) NOT NULL | Stage Record Process Instance |
90 | ORIG_PROC_ST | Character(3) | VARCHAR2(3) NOT NULL |
Original Billing Worksheet Update Process State
001=No records processed 005=Rerun initial processing 010=BI records locked 015=CA_BILL_PLAN locked 050=Invoice Numbers Assigned 100=BI records updated 101=After Approval 102=Reprocess Partials 110=Additional BI records locked 120=Project Resource IDs assigned 121=Project resource locked 130=FO_PO_HDR locked 140=CA_PREPAID_TBL locked 150=CA_BILL_PLAN locked-del wrksht 160=PC/FO/CA records updated 170=Addl BI recs locked for delete 200=CA_BILL_PLAN lock - other 210=CA recs updated-other 250=BI records deleted |
91 | FROM_DT | Date(10) | DATE | From Date |
92 | PBI_NZERO_EVENT | Character(1) | VARCHAR2(1) NOT NULL | PBI Non Zero Event Flag |
93 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL | Contracts Business Unit |
94 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
95 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
96 | PVN_GEN_LVL | Character(2) | VARCHAR2(2) NOT NULL |
PVN Generation Level field used to store the Level on which a Public Voucher needs to be generated for a contract
C=Contract Number CL=Contract Number/Contract Line CP=Contract Number/Project |
97 | PUBLIC_VOUCHER_NBR | Number(6,0) | INTEGER NOT NULL | Public Voucher Number |
98 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
99 | HOLD_UNTIL_DT | Date(10) | DATE | Hold Until Date |