DB_ORDERRQ_VW(SQL View) |
Index Back |
|---|
| SELECT ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION WHERE 'Y'='N' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DB_NUMBER | Character(9) | VARCHAR2(9) NOT NULL | DUNS Number |
| 2 | DB_LANGUAGE_CD | Character(2) | VARCHAR2(2) NOT NULL |
DB_Language Code
DU=Dutch EN=English FR=French GE=German IT=Italian PO=Portuguese SP=Spanish Default Value: EN |
| 3 | DB_PRODUCT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
D&B Product Type Code
D=DataProducts L=LocalPackets T=TextProducts X=FabricatedProducts |
| 4 | DB_PURC_REAS_CD | Character(1) | VARCHAR2(1) NOT NULL |
German D&B Purchase Code
1=CreditDecision 2=Credit Chk - Intended Bus Conn 3=Credit Check - Ongoing Bus 4=Debt Collection 5=Commercial Credit Insurance 6=Insurance Contract 7=Leasing Agreement 8=Rental Agreement |
| 5 | DB_PRODUCT | Character(4) | VARCHAR2(4) NOT NULL |
DB Productsname
BUVR=Business Verification CRSC=Credit Score(USA) DESQ=Delinquency Score DSSP=Decision Support ENMG=Enterprise Management FNCL=Financials FNST=Financial Standing FTBA=Family Tree - Basic FTEN=Family Tree - Enhanced GDM=GDM GDMP=GDM PLUS GLFS=Global Failure Risk Score MKID=WorldBase Marketing ID MKLK=WorldBase Marketing Plus Link MKPL=WorldBase Marketing Plus QKCK=Quick Check VNDR=Supplier Management |
| 6 | DB_TRADEUP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Trade Up
Y/N Table Edit Default Value: N |