AP_CCR_VBLD_AET

(SQL Table)
Index Back

CCR Load State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPSTATUS Number(1,0) SMALLINT NOT NULL AE Application Warning Status
3 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
4 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
5 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
6 CCR_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix
7 CCR_SIC_FLG Character(1) VARCHAR2(1) NOT NULL Use SIC code functionality flag
8 CCR_NAICS_FLG Character(1) VARCHAR2(1) NOT NULL Use delivered NAICS code functionality flag
9 SQLTEXT Long Character(14000) CLOB SQL Statement Text
10 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL Source System
CCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer