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 |