| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 3 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 4 |
SCHED_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 5 |
PRC_SCHED_NBR |
Number(6,0) |
INTEGER NOT NULL |
Pricing Schedule Number
|
| 6 |
QTY_ORDERED |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Order Qty
|
| 7 |
INVOICED_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Note: OM_BILL populates this field with the quantity invoiced in PRICING UOM.
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
|
| 9 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 10 |
NET_UNIT_PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Net Unit Price
|
| 11 |
NET_UNIT_PRICE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Net Unit Price (base)
|
| 12 |
PRICING_QTY |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Pricing quantity.
|
| 13 |
PRC_NET_UNIT_PRICE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Net Unit Price
|
| 14 |
PRC_NET_UNIT_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Net Unit Price (base)
|
| 15 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 16 |
TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount - Base
|
| 17 |
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.
|
| 18 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimate VAT base amount, base currency amount
|
| 19 |
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.
|
| 20 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field is used to determine the VAT Basis amount in the base currency.
|
| 21 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 22 |
VAT_TRANS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount in base currency against which the VAT is applicable
|
| 23 |
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.
|
| 24 |
ORD_ADJST_SCH_AMT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Adjustment Amount
|
| 25 |
ORD_ADJST_SCH_BASE |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Adjustment Amount
|