| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 5 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 6 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 7 |
CHARGE_FROM_DT |
Date(10) |
DATE |
From Date for line charges
|
| 8 |
CHARGE_TO_DT |
Date(10) |
DATE |
Through date for charges
|
| 9 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 10 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 11 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 12 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 13 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 14 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 15 |
GROSS_EXTENDED_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 16 |
NET_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt
|
| 17 |
NET_EXTENDED_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount
|
| 18 |
TOT_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 19 |
TOT_DISCOUNT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Discount Amount
|
| 20 |
TOT_SURCHARGE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amt
|
| 21 |
TOT_SURCHARGE_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amount
|
| 22 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 23 |
TAX_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount - Euro
|
| 24 |
TAX_PCT |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Tax Percent
|
| 25 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
|
| 26 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
|
| 27 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
|
| 28 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 29 |
PO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.
|
| 30 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 31 |
CONTRACT_DT |
Date(10) |
DATE |
Contract Date
|
| 32 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
|
| 33 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 34 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
|
| 35 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 36 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 37 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
|
| 38 |
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.
|
| 39 |
VAT_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount - Euro Currency
|
| 40 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 41 |
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.
|
| 42 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
|
| 43 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
|
| 44 |
VAT_BASIS_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amount in Euro Curr
|
| 45 |
LINE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Type 1
ADV=Advance Billing
BAE=Billed Amount in Excess
BRT=Billing Retainage
DAPP=Cust Deposit Applied
DEP=Customer Deposit
DISC=Discount Line
DREF=Cust Deposit Refunded
DRFF=Cust Deposit Refund Fee
FRGT=Freight (Surcharge)
MISC=Miscellaneous Charge
PYCV=Payment with Corporate Voucher
RAE=Reclaimed Amount in Excess
REV=Revenue Line
RSTK=Restock (Surcharge)
SUR=Surcharge Line
UTL=Utilization Line
|
| 46 |
DEPOSIT_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Deposit Invoice
|
| 47 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 48 |
CUST_DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer Deposit ID
|