FS_APPLICATION_CDDBI=Billing
DEB=eBill Payment
FAM=Asset Management
FAP=Accounts Payable
FAR=Accounts Receivable
FGL=General Ledger
FRE=Real Estate Management
FS_DOCUMENT_CDFS_AUDIT_DOC_VW(SQL View) |
Index Back |
|---|---|
Documents viewDocuments view - used as a prompt for document |
| SELECT A.FS_APPLICATION_CD , A.FS_DOCUMENT_CD , A.FS_DOC_NAME FROM PS_FS_AUDIT_DOCS A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FS_APPLICATION_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Translate field that has application/product codes.
DBI=Billing DEB=eBill Payment FAM=Asset Management FAP=Accounts Payable FAR=Accounts Receivable FGL=General Ledger FRE=Real Estate Management |
| 2 | FS_DOCUMENT_CD |
Character(8) | VARCHAR2(8) NOT NULL | Document Code |
| 3 | FS_DOC_NAME | Character(30) | VARCHAR2(30) NOT NULL | Document Name |