BUSINESS_UNITVOUCHER_IDDTTM_STAMPA=Approved
D=Denied
P=Pending
0=None
1=Special Depr
2=Accelerated Depr
3=Initial Depr
A=All (I,O,U)
D=Discard
I=Inventory
O=Over
R=Retire
U=Under
Y/N Table Edit
EM_EXT_SELL(SQL Table) |
Index Back |
|---|---|
Voucher Extract - SellerRecord used to store vouchers that have been extracted by the Seller. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | DTTM_STAMP |
DateTime(26) | TIMESTAMP NOT NULL | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved D=Denied P=Pending |
| 7 | MATCH_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PI Match Status
0=None 1=Special Depr 2=Accelerated Depr 3=Initial Depr A=All (I,O,U) D=Discard I=Inventory O=Over R=Retire U=Under |
| 8 | EM_EXT_EMAIL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Y/N Table Edit |
| 9 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |