PRODUCT_INSTAM=Asset Management
AP=Accounts Payable
AR=Accounts Receivable
BI=Billing
EX=Expenses
GL=General Ledger
OM=Order Management
PO=Purchase Order
RE=Real Estate Management
SP=Service Procurement
TR=Treasury
VAT_PRODUCT_VW(SQL View) |
Index Back |
|---|---|
VAT Product Installed |
| SELECT %Substring(FIELDVALUE, 1, 3) , XLATLONGNAME FROM PS_INSTALLATION , PSXLATITEM WHERE FIELDNAME = 'PRODUCT_INST' AND ((FIELDVALUE = 'AM' AND AM = 'Y') OR (FIELDVALUE = 'AP' AND AP = 'Y') OR (FIELDVALUE = 'AR' AND AR = 'Y') OR (FIELDVALUE = 'BI' AND BI = 'Y') OR (FIELDVALUE = 'EX' AND EX = 'Y') OR (FIELDVALUE = 'GL' AND GL = 'Y') OR (FIELDVALUE = 'OM' AND OM = 'Y') OR (FIELDVALUE = 'PO' AND PO = 'Y') OR (FIELDVALUE = 'SP' AND SP = 'Y') OR (FIELDVALUE = 'TR' AND TR = 'Y') OR (FIELDVALUE = 'RE' AND RE = 'Y') ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRODUCT_INST |
Character(3) | VARCHAR2(3) NOT NULL |
Product
AM=Asset Management AP=Accounts Payable AR=Accounts Receivable BI=Billing EX=Expenses GL=General Ledger OM=Order Management PO=Purchase Order RE=Real Estate Management SP=Service Procurement TR=Treasury |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |