| # |
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(6,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 |
Currency Code
|
| 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 |
VAT Amount in Base Curr
|
| 19 |
VAT_AMT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reverse Charge VAT Amount
|
| 20 |
VAT_AMT_RVC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Reverse Charge Amount in Base Currency
|
| 21 |
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.
|
| 22 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 23 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 24 |
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
|
| 25 |
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.
|
| 26 |
TAX_CD_VAT_RVC_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Customer VAT Rate
|
| 27 |
ORD_ADJST_SCH_AMT |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Adjustment Amount
|
| 28 |
ORD_ADJST_SCH_BASE |
Signed Number(19,4) |
DECIMAL(17,4) NOT NULL |
Adjustment Amount
|
| 29 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 30 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 31 |
BI_USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Billing Use Tax Amount Base
|
| 32 |
USETAX_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use Tax Basis Amount
|
| 33 |
BI_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Billing Tax Amount
|
| 34 |
BI_CURRENCY_BSE |
Character(3) |
VARCHAR2(3) NOT NULL |
BI Base Currency
|