BI_WRKSHT_STG(SQL Table) |
Index Back |
|---|---|
Billing Worksheet Staging TblBilling Worksheet Staging Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_BI_NONVW |
| 2 | INVOICE |
Character(22) | VARCHAR2(22) NOT NULL |
Invoice
Prompt Table: BI_HDR |
| 3 | BI_ACTION_TMP | Character(1) | VARCHAR2(1) NOT NULL |
Bill Action
A=Approve Later C=Approve Now D=Delete Later R=Delete Now |
| 4 | ADD_TO_BILL | Character(22) | VARCHAR2(22) NOT NULL | Add To Bill |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | 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 Default Value: 0 |
| 7 | ERROR_STATUS_BI | Character(4) | VARCHAR2(4) NOT NULL | Error Status |
| 8 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |