BI_BILL_CPY_GRP

(SQL Table)
Index Back

Bill Copy Groups

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BILL_CPY_GRP_ID Character(10) VARCHAR2(10) NOT NULL Bill Copy Group ID
2 SEQ_NUM 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