PROCESS_INSTANCEE=Error
L=Loaded
X=Loaded with Errors
EX_PUBDC_AET(SQL Table) |
Index Back |
|---|---|
State rec for corp card loadState record used in AE process to load corporate card data into EX_TRANS for expense sheet access |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | EX_FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 6 | EX_FILE_NAME2 | Character(80) | VARCHAR2(80) NOT NULL | File Name (Accounts.dat) |
| 7 | LOAD_DATETIME | DateTime(26) | TIMESTAMP | Load Date/Time |
| 8 | EX_FILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
File Load Status
E=Error L=Loaded X=Loaded with Errors |
| 9 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | EX_LOAD_PROGRAM | Character(1) | VARCHAR2(1) NOT NULL | Run Load Program |
| 11 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 12 | CREDIT_CARD_VENDOR | Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |