| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 3 |
ADJ_AUX_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Line Seq Num
|
| 4 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
Default Value: BI_HDR.BI_CURRENCY_CD
|
| 5 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Default Value: BI_HDR.BASE_CURRENCY
|
| 6 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
Default Value: BI_HDR.CURRENCY_CD_XEU
|
| 7 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 8 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 9 |
ORIGINAL_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Original Line Sequence 5
|
| 10 |
NEXT_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusting Invoice
|
| 11 |
NEXT_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Next Adjustment Line Sequence
|
| 12 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 13 |
PRIOR_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prior Adjustment Line Seq
|
| 14 |
LATEST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Latest Invoice
|
| 15 |
LATEST_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Latest Line Sequence
|
| 16 |
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
|
| 17 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
Prompt Table:
%EDITTABLE4
|
| 18 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 19 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
UNITS_TBL
|
| 20 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 21 |
CHARGE_FROM_DT |
Date(10) |
DATE |
From Date for line charges
|
| 22 |
CHARGE_TO_DT |
Date(10) |
DATE |
Through date for charges
|
| 23 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 24 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table:
TAX_HEADER_TBL
|
| 25 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
Prompt Table:
CUST_EXEMPT
|
| 26 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
|
| 27 |
NET_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt
|
| 28 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 29 |
NET_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount
|
| 30 |
GROSS_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 31 |
NET_EXTENDED_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount
|
| 32 |
GROSS_EXTENDED_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 33 |
TOT_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 34 |
TOT_SURCHARGE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amt
|
| 35 |
TOT_DISCOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Discount Amount
|
| 36 |
TOT_SURCHARGE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amount
|
| 37 |
TOT_DISCOUNT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Discount Amount
|
| 38 |
TOT_SURCHARGE_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amount
|
| 39 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 40 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 41 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 42 |
LAST_UPDATE_DTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 43 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|