BI_BILL_CPY_GRP(SQL Table) |
Index Back |
|---|---|
Bill Copy Groups |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | Bill Copy Group ID | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Sequence | |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_BI_NONVW |
| 4 | TEMPLATE_INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Template Invoice ID
Prompt Table: BI_HDR_COPY_VW |
| 5 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 6 | SELECT_BILL_CHKBX | Character(1) | VARCHAR2(1) NOT NULL |
Select Bill Checkbox
Y/N Table Edit Default Value: N |
| 7 | NEW_BILL_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
New Bill Status
CAN=Canceled HLD=Hold Bill NEW=New Bill PND=Pending RDY=Ready Bill Default Value: NEW |
| 8 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Invoice
Default Value: NEXT |
| 9 | REPLACE_TEMPLATE | Character(1) | VARCHAR2(1) NOT NULL |
Replace Template Invoice
Y/N Table Edit Default Value: N |
| 10 | BILL_CPY_START_DT | Date(10) | DATE NOT NULL | Copy Begin Dt |
| 11 | BILL_CPY_END_DT | Date(10) | DATE NOT NULL | Copy End Dt |
| 12 | CPY_STATUS | Character(3) | VARCHAR2(3) NOT NULL | Copy Status |
| 13 | ERROR_STATUS_BI | Character(4) | VARCHAR2(4) NOT NULL | Error Status |
| 14 | NULL_DATE | Date(10) | DATE | Date field with NULL value |
| 15 | NULL_DTTM | DateTime(26) | TIMESTAMP | Null Date Time |
| 16 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 17 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 18 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 19 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |