| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUS_UNIT_TBL_SP
|
| 2 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
Default Value: SPF_INVOICE_HDR.INVOICE_ID
|
| 3 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 4 |
PRINT_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Print Sequence Number for Invoicing
|
| 5 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 6 |
TIME_SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 7 |
PLOG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 8 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 9 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 10 |
INV_LINE_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Invoice Line Status
1=Generated
10=Adjusted by Ent Approver
11=Adjusted by Enterprise
2=Approved by Enterprise
3=Submitted to Enterprise
4=Denied by Enterprise
5=Submitted to Supplier
6=Approved by Supplier
7=Denied by Supplier
8=Canceled
9=Adjusted by Supplier
|
| 11 |
WORK_ORDER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order ID
|
| 12 |
PROVIDER_CONTACT |
Character(15) |
VARCHAR2(15) NOT NULL |
PROVIDER CONTACT
|
| 13 |
SP_SUP_INVAPPROVER |
Character(15) |
VARCHAR2(15) NOT NULL |
Supplier Proforma Invoice Approver
|
| 14 |
SP_END_SUPPLIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The Supplier who is being managed by the VMS (Vendor Managed Service) Supplier
|
| 15 |
PERIOD_END_DT |
Date(10) |
DATE |
Represents the date termination point for a given time set utilized in cash worksheet processing.
|
| 16 |
ADJUST_DT |
Date(10) |
DATE |
Transaction Date
|
| 17 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 18 |
PERCENT_COMPLETE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Complete
|
| 19 |
SPA_SUP_INV_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Supplier Invoice ID
|
| 20 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 21 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 22 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 23 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 24 |
SP_TIME_QTY |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Time Quantity
|
| 25 |
SP_TIME_QTY_ADJ |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Adjusted Time Quantity
|
| 26 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 27 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 28 |
TAX_CD_SUT_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Sales/Use Tax Code Percent
|
| 29 |
ADJ_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code which has been adjusted.
|
| 30 |
ADJ_SUT_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Adjusted Sales/Use Tax Code Percent
|
| 31 |
INV_LINE_ADJRATE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Adjusted Invoice Line Rate
|
| 32 |
INV_LINE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Line Amount
|
| 33 |
VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
|
| 34 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 35 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 36 |
INV_EXP_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Expense Amount
|
| 37 |
SP_MSP_FEE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Managed Service Provider Fee
|
| 38 |
SP_MSP_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount including MSP Fee
|
| 39 |
INV_LINE_ADJAMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Adjusted Invoice Line Amount
|
| 40 |
ADJ_VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field stores the adjusted VAT amount. The original amount is stored in the VAT_AMT field for sPro.
|
| 41 |
ADJ_SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field stores the adjusted Sales Tax Amount. The original amount is stored in the SALETX_AMT field for sPro.
|
| 42 |
ADJ_USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field stores the adjusted Use Tax amount. The original amount is stored in the USETAX_AMT field for sPro.
|
| 43 |
INV_LINE_ADJEXP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Line Adjusted Expense Amount
|
| 44 |
ADJ_SP_MSP_FEE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Managed Service Provider/Vendor Managed Services Fee
|
| 45 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 46 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 47 |
INV_LN_ADJRATE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Invoice Line Adjusted Rate in Base Currency
|
| 48 |
INV_LINE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Invoice Line Amount
|
| 49 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount in Base Curr
|
| 50 |
SALETX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 51 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 52 |
INV_EXP_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Expense Amount for Base Currency
|
| 53 |
SP_MSP_FEE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Managed Service Provider Fee (Base Currency)
|
| 54 |
SP_MSP_TOTAL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount including MSP Fee (Base Currency)
|
| 55 |
INV_LN_ADJAMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Line Adjusted Amount in base currency
|
| 56 |
ADJ_VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Adjusted VAT Amount - Base Currency
|
| 57 |
ADJ_SALETX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Adjusted Sales Tax Amount - Base Currency
This field stores the adjusted Sales Tax Amount in Base Currency. The original amount is stored in the SALETX_AMT_BSE field for sPro.
|
| 58 |
ADJ_USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field stores the adjusted Use Tax amount in Base Currency. The original amount is stored in the USETAX_AMT_BSE field for sPro.
|
| 59 |
INV_LN_ADJEXP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Line Adjusted Expense Amount in Base Currency
|
| 60 |
ADJ_SP_MSP_FEE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Managed Service Provider/Vendor Managed Services Fee
|
| 61 |
INVOICE_AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount in Base Currency
|
| 62 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 63 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 64 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 65 |
EXPENSE_TYPE |
Character(7) |
VARCHAR2(7) NOT NULL |
Expense Type
|
| 66 |
TIME_LINE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Line Type
H=Hours
I=Incident
|
| 67 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 68 |
PC_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
Default Value: N
|
| 69 |
SPF_SUP_INC_IN_APR |
Character(1) |
VARCHAR2(1) NOT NULL |
Include supplier in approvals
|
| 70 |
INV_ENT_ADJ_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Enterprise Side Invoice
A=Adjusted
N=Not Adjusted
Default Value: N
|
| 71 |
INV_SUP_ADJ_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Supplier Side Invoice
A=Adjusted
N=Not Adjusted
Default Value: N
|