SETIDVENDOR_IDVNDR_LOCFILEIDH=On Hold
I=Invalid
L=Loaded
S=File Sent
S=File Sent
W=File Waiting
W=Waiting to be processed
Default Value: W
PV_TPO_FILESTUS(SQL Table) |
Index Back |
|---|---|
TPO files for a MarketplaceHold Catalog items and suppliers latest file generation/ftp�ed timestamp for a marketplace |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | FILEID |
Character(30) | VARCHAR2(30) NOT NULL | File ID (see PSFILEDEFN). |
| 5 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 6 | FILE_INT_NAME | Character(250) | VARCHAR2(250) NOT NULL | Marketplace internal file name |
| 7 | FILE_FTP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of a FTP'ed file on a Marketplace Integration;
H=On Hold I=Invalid L=Loaded S=File Sent S=File Sent W=File Waiting W=Waiting to be processed Default Value: W |
| 8 | PV_DTTM | DateTime(26) | TIMESTAMP | Date and Time Requested |