EX_PUBMC_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 | LOAD_DATETIME | DateTime(26) | TIMESTAMP | Load Date/Time |
7 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
8 | EX_FILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
File Load Status
E=Error L=Loaded X=Loaded with Errors |
9 | EX_LOAD_PROGRAM | Character(1) | VARCHAR2(1) NOT NULL | Run Load Program |
10 | CREDIT_CARD_VENDOR | Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |
11 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |