| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_SP_NONVW
|
| 2 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
Default Value: NEXT
|
| 3 |
SP_SERVICE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Type classified as Resource Based or Service Based
D=Deliverable
R=Resource
Default Value: R
|
| 4 |
INVOICE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Invoice Status
0=Submitted to Enterprise
1=Generated
10=Canceled
11=Adjusted
2=Approved
3=Processed
4=Paid
5=Submitted
6=Denied
7=Submitted to Supplier
8=Approved by Supplier
9=Denied by Supplier
Default Value: 1
|
| 5 |
INVOICE_DT |
Date(10) |
DATE NOT NULL |
Invoice Date
Default Value: %DATE
|
| 6 |
INVOICE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Descriptive name for Invoice
|
| 7 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
%EDITTABLE
Set Control Field: BUSINESS_UNIT
|
| 8 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
SPF_VNDRLOC2_VW
Set Control Field: BUSINESS_UNIT
|
| 9 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
VENDOR_ADDR_VW1
|
| 10 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table:
PAYTRMS_SPF_VW
|
| 11 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 12 |
REMIT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit to Location
|
| 13 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
|
| 14 |
GEN_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 15 |
GEN_PROCESS_DATE |
Date(10) |
DATE |
Generate Date
|
| 16 |
PRINT_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 17 |
PRINT_PROCESS_DATE |
Date(10) |
DATE |
Last Print Date
|
| 18 |
EX_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 19 |
EX_PROCESS_DATE |
Date(10) |
DATE |
Export File Date
|
| 20 |
SP_VNDR_INTERNAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor Internal or External type
N=N
Y=Yes
Default Value: N
|
| 21 |
VMS_MANAGED |
Character(1) |
VARCHAR2(1) NOT NULL |
VMS Managed flag indicating if the work order is being managed by a Vendor Managed Service provider
B=Default from Business Unit
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 22 |
ROW_CREATE_DATE |
DateTime(26) |
TIMESTAMP |
Row Creation Date Time
Default Value: %DateTime
|
| 23 |
ROW_MODIFY_DATE |
DateTime(26) |
TIMESTAMP |
Modified Date Time
Default Value: %DateTime
|
| 24 |
ROW_CREATE_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added By
|
| 25 |
ROW_MODIFY_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Modified User
|
| 26 |
AP_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
AP Distribution Status
|