| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
INVOICE_RANGE_OPT |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Range Option
ALI=All Invoiced Bills
ALL=All
CUS=Cust ID
CYC=Bill Cycle
DT=Date Bill Added
DTI=Date
GRP=Copy Group ID
INV=Invoice ID
MUL=Multi-Select Table
PVN=Public Voucher Number
RGP=Reprint Group
SEL=Range ID
SHP=Ship ID
SRC=Bill Source
TYP=Bill Type
|
| 4 |
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.
|
| 5 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
|
| 6 |
START_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Starting Invoice Number
|
| 7 |
END_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Ending Invoice Number
|
| 8 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 9 |
BI_HDR_FROM_DT |
Date(10) |
DATE |
Bill Header From Date
|
| 10 |
BI_HDR_TO_DT |
Date(10) |
DATE |
Bill Header To Date
|
| 11 |
BI_LINE_FROM_DT |
Date(10) |
DATE |
Bill Line From Date
|
| 12 |
BI_LINE_TO_DT |
Date(10) |
DATE |
Bill Line To Date
|
| 13 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 14 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 15 |
INVOICE_NUMBERING |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Numbering Option
B=Business Unit
O=Bill Source
S=System
T=Bill Type
U=User Defined
|
| 16 |
IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Invoice Number ID
|
| 17 |
MANUAL_LIN_NUM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Manual Line Numbering
|
| 18 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 19 |
TEMPLATE_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Template Invoice ID
|
| 20 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 21 |
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. "
|
| 22 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 23 |
ERROR_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Error Count
|
| 24 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 25 |
BUSINESS_UNIT_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Non-Joint Venture BU
|
| 26 |
GENERATED_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Generated Invoice
|
| 27 |
USER_FIELD_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 1
|
| 28 |
USER_FIELD_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 2
|
| 29 |
USER_FIELD_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 3
|
| 30 |
USER_FIELD_4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 4
|
| 31 |
USER_FIELD_5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 5
|
| 32 |
EVENT_OCCURRENCE |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
|
| 33 |
CPY_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Copy Status
|
| 34 |
LAST_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Last Step Completed
|
| 35 |
GENERATED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recurring Bill Generated Flag
|
| 36 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 37 |
ENABLE_DFR_REV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Deferred Revenues
|
| 38 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 39 |
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
|
| 40 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 41 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 42 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 43 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 44 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 45 |
PRICE_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalculate Price
|
| 46 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 47 |
REV_RECOG_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Revenue Recognition Basis
CHG=From/To Date Range
CON=Contract Date
INV=Invoice Date
ORD=Order Date
SHP=Ship Date
STE=Start/End Date Range
UD1=User Date 1
UD2=User Date 2
|
| 48 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|
| 49 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 50 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 51 |
CHARGE_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Billing Charge ID
|
| 52 |
LIST_PRICE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
List Price
|
| 53 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 54 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 55 |
LVL_SUBTOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Level Subtotal
|
| 56 |
PRIOR_LVL_SUBTOTAL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Prior Level Subtotal
|
| 57 |
TOTAL_LVL_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Level Discount Total
|
| 58 |
TOTAL_LVL_SUR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Level Surcharge Total
|
| 59 |
LINE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cost Retired at Chart
|
| 60 |
PERCENTAGE2 |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 61 |
DISC_SUR_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount/Surcharge
D=Discount
I=Installment Surcharge
S=Surcharge
|
| 62 |
DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the discount amount available if payment on an item is made before the discount date. The amount is manually entered or system-generated using the payment terms code. The discount date associated with this amount is specified in DISC_DT. This is the first of two possible discounts associated with an item.
|
| 63 |
DISC_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 64 |
DISTRIB_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Distributed amount
|
| 65 |
PERCENTAGE1 |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 66 |
LINE_DST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Revenue Sequence Number
|
| 67 |
DST_SEQ_END |
Number(3,0) |
SMALLINT NOT NULL |
Last DST Line Seq in Chunk
|
| 68 |
AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used in Virtual Approver to store the various rule amounts that go on each approval step
|
| 69 |
PERCENT_VALUE |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Percent Value
|
| 70 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 71 |
DIFFERENCE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Difference Amount
|
| 72 |
AMOUNT_DFR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Deferred Amount
|
| 73 |
PERCENT_PNL |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Percent on Panels
|
| 74 |
AMOUNT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 75 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 76 |
NET_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt
|
| 77 |
TOT_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 78 |
TOT_SURCHARGE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amt
|
| 79 |
AMOUNT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 80 |
NULL_DTTM |
DateTime(26) |
TIMESTAMP |
Null Date Time
|
| 81 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 82 |
MULTI_CURR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Multi-Currency
N=No
Y=Yes
|
| 83 |
AUTO_GEN_LN_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Header Dates For Lines
|
| 84 |
BI_APPROVAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Invoice Approvals
|
| 85 |
ONLY_APPR_CREDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Only Submit Credits
|
| 86 |
INVOICE2 |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 87 |
GST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Goods and Services Tax
|
| 88 |
BI_BU_TAX_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Business Unit Tax Flag
0=PS standard taxes/VAT
1=Third-party tax supplier
2=India taxes
|
| 89 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|