| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
TEMP_FLD3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary field for App Engine
|
| 3 |
FROM_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
From Interface ID
|
| 4 |
TO_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
To Interface ID
|
| 5 |
INTFC_RUN_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Intfc Run Option
ALL=All - Run With All Edits
EDIT=Edit - Run Edits Only
MIN=Min - Run With Minimum Edits
|
| 6 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 7 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 8 |
TRANS_TYPE_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail
|
| 9 |
TRANS_TYPE_BI_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0
|
| 10 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|
| 11 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 12 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 13 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 14 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 15 |
ALTACCT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Alternate Account
|
| 16 |
ACCT_ENTRY_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Entry Type
|
| 17 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 18 |
ADJ_DELTA_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Delta Action
ADD=Add
DEL=Delete
RPL=Replace
|
| 19 |
ADJ_INVOICE1 |
Character(22) |
VARCHAR2(22) NOT NULL |
Credit Bill
|
| 20 |
ADJ_TRANS_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Adjustment Transaction Type
|
| 21 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 22 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 23 |
AR_DST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Distribution Option
H=Use Header for Distribution
L=Use Line for Distribution
|
| 24 |
AR_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Level
H=Header is AR Open Item
L=Bill Line is AR Open Item
N=No AR Open Items
|
| 25 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 26 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 27 |
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. "
|
| 28 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 29 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
|
| 30 |
HDR_FIELDS_BILL_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Header Fields Bill By
|
| 31 |
HDR_FIELDS_KEY |
Character(30) |
VARCHAR2(30) NOT NULL |
Header Fields Key
|
| 32 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
|
| 33 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
|
| 34 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 35 |
BILL_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Status
CAN=Canceled
FNL=Finalized Bill
HLD=Hold Bill
INV=Invoiced Bill
NEW=New Bill
PND=Pending Approval
RDY=Ready to Invoice
TMP=Temporary Bill
TMR=Temporary Ready Bill
|
| 36 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 37 |
BILL_TO_MEDIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill To Media
A=Email Invoice as Attachment
E=EDI
H=Federal Highway File
N=Email Notification
P=Print Copy
X=Electronic Invoice File
|
| 38 |
BILL_TO_COPIES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Copies
|
| 39 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
|
| 40 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
|
| 41 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
|
| 42 |
BILLING_FREQUENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Frequency
INS=Installment
ONC=Once
REC=Recurring
|
| 43 |
BUS_UNIT_IU_FROM |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit From
|
| 44 |
BUS_UNIT_IU_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit To
|
| 45 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 46 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 47 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 48 |
CALCULATION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Calculation_cd
AMT=Amount
PCT=Percentage
|
| 49 |
CF_ORDER |
Number(2,0) |
SMALLINT NOT NULL |
ChartField Sequence Order
|
| 50 |
CHARGE_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Billing Charge ID
|
| 51 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
|
| 52 |
CR_ANALYST |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
|
| 53 |
CREDIT_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 54 |
CREDIT_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 55 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
|
| 56 |
COMM_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Communication
A=Email Invoice as Attachment
C=Call
E=Email only
F=Fax
I=XML only
M=Standard Mail
N=Email Notification
P=Email & Print
R=XML & Print
|
| 57 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 58 |
CONSOL_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Consolidation Customer ID
|
| 59 |
CONSOL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Specifies the invoice identifier associated with a consolidated bill.
|
| 60 |
CONSOL_KEY |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Consolidation Key
|
| 61 |
CONSOL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Consolidation Customer SetID
|
| 62 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 63 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 64 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
|
| 65 |
XREF_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Cross Reference Sequence No.
|
| 66 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 67 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 68 |
DFR_MID_PERIOD_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Mid-Period # of Days
|
| 69 |
DFR_ACCTG_DT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Future Period Accounting Dates
F=First Day in Accounting Period
L=Last Day in Accounting Period
U=User Defined
|
| 70 |
DFR_REV_PRORATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Proration Method
1=By Days Within Range
2=Evenly Using All Pds
3=Evenly Using Mid-period Rule
4=Evenly/Partial by Days
5=User Defined Proration Method
|
| 71 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|
| 72 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 73 |
DISC_SUR_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount/Surcharge
D=Discount
I=Installment Surcharge
S=Surcharge
|
| 74 |
DISC_SUR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Surcharge Flag
|
| 75 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 76 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 77 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
|
| 78 |
DST_ID_AR |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
|
| 79 |
DST_ID_DFR |
Character(10) |
VARCHAR2(10) NOT NULL |
Deferred Distribution Code
|
| 80 |
ENABLE_DFR_REV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Deferred Revenues
|
| 81 |
FIRST_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
First Sequence number in list
|
| 82 |
GL_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Level
A=AR Creates GL Acct Entries
B=BI Creates GL Acct Entries
N=No GL Accounting Entries
|
| 83 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 84 |
HDR_OR_LINE_NOTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Header or Line Note
H=Header Note
L=Line Note
|
| 85 |
INTFC_ID_ADJ |
Number(8,0) |
INTEGER NOT NULL |
Interface ID of Adj Trans
|
| 86 |
INTFC_LINE_NUM_ADJ |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number - Adj
|
| 87 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 88 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
|
| 89 |
INVOICE_TO_ADJ |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice To Adjust
|
| 90 |
INVOICE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
|
| 91 |
IU_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Used for interunit bill options, to distinguish the different types of inter/intraunit entries.
AE=IntraEntity
AU=IntraUnit
IE=InterEntity
IU=InterUnit
|
| 92 |
IU_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit Method
D=Direct
I=Indirect
P=Pairs
|
| 93 |
IU_ENTRY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Entry Type
AEAP=IntraEntity Accrued Payable
AECG=IntraEntity Cost of Goods
AECS=IntraEntity Customer Shipments
AEEX=IntraEntity Expense
AEPY=IntraEntity Payable
AERC=IntraEntity Receivable
AERV=IntraEntity Revenue
AETR=IntraEntity In Transit
AUEX=IntraUnit Expense
AUPY=IntraUnit Payable
AURC=IntraUnit Receivable
AURV=IntraUnit Revenue
AUTR=IntraUnit In Transit
IEAP=InterEntity Accrued Payable
IECG=InterEntity Cost of Goods
IECS=InterEntity Customer Shipments
IEEX=InterEntity Expense
IEPY=InterEntity Payable
IERC=InterEntity Receivable
IERV=InterEntity Revenue
IETR=InterEntity In Transit
IUAP=InterUnit Accrued Payable
IUCG=InterUnit Cost of Goods
IUCS=InterUnit Customer Shipments
IUEX=InterUnit Expense
IUPY=InterUnit Payable
IURC=InterUnit Receivable
IURV=InterUnit Revenue
IUTR=InterUnit In Transit
|
| 94 |
IU_LEGAL_ENT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity.
|
| 95 |
IU_LEGAL_ENT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Legal Entity for InterUnit
|
| 96 |
IU_INTRA_TMPLT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Key field for IntraUnit Template
|
| 97 |
IU_INTER_TMPLT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Key to the interunit template record. Assigned to a GLBU on the GL business unit table.
|
| 98 |
IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Invoice Number ID
|
| 99 |
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
|
| 100 |
LAST_NOTE_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Last note sequence number
|
| 101 |
LAST_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Sequence number in list
|
| 102 |
LATEST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Latest Invoice
|
| 103 |
LINE_DFR_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Deferred Sequence Number
|
| 104 |
LINE_DST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Revenue Sequence Number
|
| 105 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 106 |
LINE_SEQ_TO_ADJ |
Number(5,0) |
INTEGER NOT NULL |
Line Sequence To Adjust
|
| 107 |
LINE_TOT_DISC_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Discount Amount
|
| 108 |
LINE_TOT_SUR_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Discount Amount
|
| 109 |
LOAD_STATUS_BI |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Interface Load Status
DON=Done (Complete)
ERR=Error
NEW=New
RDY=Ready
UPD=Updating
|
| 110 |
LVL_TOTAL_DISC_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Level Total Discount Amount
|
| 111 |
LVL_TOTAL_SUR_AMT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Level Total Surcharge Amount
|
| 112 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 113 |
NBR_COPIES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Copies
|
| 114 |
NET_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt
|
| 115 |
NEXT_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusting Invoice
|
| 116 |
NEXT_LINE_AR_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 117 |
NEXT_LINE_DFR_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 118 |
NEXT_LINE_DST_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 119 |
NEXT_LINE_STA_SEQ |
Number(5,0) |
INTEGER NOT NULL |
NEXT_LINE_STA_SEQ
|
| 120 |
NEXT_LINE_UAR_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 121 |
NEXT_LINE_IE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 122 |
NEXT_LINE_IP_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 123 |
NEXT_LINE_NOTE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Notes Sequence Num
|
| 124 |
NEXT_LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 125 |
NEXT_NOTES_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Notes Sequence Num
|
| 126 |
LINE_SEQ_CNT |
Number(5,0) |
INTEGER NOT NULL |
Line Sequence Counter
|
| 127 |
NEW_LVL_SUBTOTAL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
New Level Subtotal
|
| 128 |
NOTES_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Notes Sequence Num
|
| 129 |
ORD_ACCEPT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Acceptance
|
| 130 |
ORD_ORIGIN_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Origin
|
| 131 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 132 |
ORIGINAL_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Original Line Sequence 5
|
| 133 |
PAGE_ORIENTATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Layout Type
E=Crystal
L=SQR - Landscape
P=SQR - Portrait
X=XML Publisher
|
| 134 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 135 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 136 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 137 |
PRIOR_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 138 |
PRIOR_DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Prior Discount/Surcharge Level
|
| 139 |
PRIOR_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 140 |
PRIOR_LVL_SUBTOTAL |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Prior Level Subtotal
|
| 141 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 142 |
PROCESS_ADJUSTMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
|
| 143 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 144 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 145 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 146 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 147 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 148 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 149 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 150 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 151 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 152 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 153 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 154 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 155 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 156 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 157 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 158 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 159 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 160 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 161 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 162 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
|
| 163 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 164 |
CR_CARD_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
"See OM
01=Visa
02=MasterCard
03=Diners Club/Carte Blanche
04=AMEX
05=Discover
06=EnRoute
|
| 165 |
CR_CARD_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
"See OM
|
| 166 |
CR_CARD_DIGITS |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Number's Last Four Digits
|
| 167 |
CR_CARD_EXPMO |
Character(2) |
VARCHAR2(2) NOT NULL |
Card Expiration Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
|
| 168 |
CR_CARD_EXPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Expiration Year
2011=2011
2012=2012
2013=2013
2014=2014
2015=2015
2016=2016
2017=2017
2018=2018
2019=2019
2020=2020
|
| 169 |
CR_CARD_FNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card First Name
|
| 170 |
CR_CARD_LNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card Last Name
|
| 171 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 172 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 173 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 174 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 175 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 176 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 177 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 178 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 179 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 180 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 181 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 182 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 183 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
|
| 184 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 185 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 186 |
REBILL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 187 |
REBILL_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 188 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 189 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 190 |
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
|
| 191 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 192 |
SALES_PERSON |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
|
| 193 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 194 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 195 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 196 |
SUPPORT_TEAM_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Support Team Code
|
| 197 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 198 |
SUBCUST_QUAL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 199 |
SUBCUST_QUAL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 200 |
TARGET_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Target Invoice
|
| 201 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
|
| 202 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 203 |
TMP_IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Temp Bill Invoice Num ID
|
| 204 |
TMP_BILL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Bill
|
| 205 |
TOT_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 206 |
TOT_SURCHARGE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amt
|
| 207 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 208 |
VAT_PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Group
|
| 209 |
VAT_SVC_PERFRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
|
| 210 |
CUST_VNDR_AFFILIAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Vendor Affiliate
|
| 211 |
SUMMARIZE_IVC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Summarize Invoice Flag
|
| 212 |
ACCEPTGIRO_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Field indicator that 'Invoice print will have Acceptgiro'. 'Y' indicates that Invoice has to be printed with Acceptgiro. 'N' indicates that Invoice has to be printed without Acceptgiro.
|
| 213 |
EB |
Character(1) |
VARCHAR2(1) NOT NULL |
eBill Payment
|
| 214 |
BUS_UNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit
|
| 215 |
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
|
| 216 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 217 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 218 |
TAX_DIVISION |
Character(5) |
VARCHAR2(5) NOT NULL |
Division for Tax Suppliers
|
| 219 |
TAX_DEPARTMENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department used by Tax Vendors
|
| 220 |
BASE_CURRENCY_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency To
|
| 221 |
HOLD_NBR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Hold Number of Days
|
| 222 |
ATT_IVC_IMG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Attach Invoice Image Option
0=Do not Attach Invoice Image
1=Attach Invoice Image
9=Not Defined at this level
|
| 223 |
ATT_IVC_IMG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Attach Invoice Image
|
| 224 |
BI_AP_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit AP Level
H=Header is AP Voucher
L=Bill Line is AP Voucher
N=No AP Voucher
|
| 225 |
CC_PROF_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Profile Option
0=No Tokenization
1=Create Profiles Before
2=Create Profiles After
|
| 226 |
CR_CARD_VENDOR |
Character(16) |
VARCHAR2(16) NOT NULL |
Processor Name
|
| 227 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 228 |
CC_PROF_TOKEN |
Character(44) |
VARCHAR2(44) NOT NULL |
Profile Token ID
|
| 229 |
CR_CARD_RQST_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Credit Card Request ID
|
| 230 |
CC_RQST_TOKEN |
Long Character(256) |
VARCHAR2(256) |
Request Token
|
| 231 |
GST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Goods and Services Tax
|
| 232 |
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
|
| 233 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 234 |
ORG_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Organization SetID.
|
| 235 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 236 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 237 |
PROD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product SetID
|
| 238 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 239 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 240 |
FROM_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
From Business Unit
Prompt Table:
SP_BU_BI_NONVW
|
| 241 |
TO_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table:
SP_BU_BI_NONVW
|
| 242 |
INTFC_RANGE_OPT |
Character(3) |
VARCHAR2(3) NOT NULL |
Range Selection
BUS=Business Unit
DT=Date Added
INT=Interface ID
SRC=Bill Source
Default Value: INT
|
| 243 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 244 |
BI_OVR_CO_AN_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for overriding collector and credit analyst default
Y/N Table Edit
Default Value: N
|