PROCESS_INSTANCEC=Complete
CE=Complete with Errors
E=Error
P=In Process
R=Received by Bank
S=Sent to Bank
X=Canceled
E=Error
L=Loaded
X=Loaded with Errors
EX_PUBAMEX_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 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 8 | LOAD_DATETIME | DateTime(26) | TIMESTAMP | Load Date/Time |
| 9 | FILE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
File Status
C=Complete CE=Complete with Errors E=Error P=In Process R=Received by Bank S=Sent to Bank X=Canceled |
| 10 | EX_FILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
File Load Status
E=Error L=Loaded X=Loaded with Errors |
| 11 | LOAD_AMX_HOTEL | Character(1) | VARCHAR2(1) NOT NULL | Load Hotel Folio |
| 12 | EX_LOAD_PROGRAM | Character(1) | VARCHAR2(1) NOT NULL | Run Load Program |
| 13 | EX_OVERRIDE_FILE | Character(1) | VARCHAR2(1) NOT NULL | Override File Check |
| 14 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 15 | CREDIT_CARD_VENDOR | Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |