BI_WKSH_UPD_AET

(SQL Table)
Index Back

Billing Worksheet Update AET

Billing 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