| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_BI_NONVW
|
| 2 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
Default Value: NEXT
Prompt Table:
BI_HDR
|
| 3 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
Prompt Table:
%EDITTABLE3
|
| 4 |
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
Default Value: NEW
|
| 5 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_HDR_ACT_VW
|
| 6 |
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
Default Value: REG
|
| 7 |
CONSOL_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidated Hdr?
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 8 |
CONSOL_KEY |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Consolidation Key
Default Value: CUST_OPTION.CONSOL_KEY
|
| 9 |
CONSOL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Consolidation Customer SetID
|
| 10 |
CONSOL_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Consolidation Customer ID
|
| 11 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 12 |
CONSOL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Specifies the invoice identifier associated with a consolidated bill.
|
| 13 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 14 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 15 |
NEXT_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusting Invoice
|
| 16 |
LATEST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Latest Invoice
|
| 17 |
ADJUSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusted Flag
H=Header Level Adjustment
L=Line Level Adjustment
N=No Adjustments
Default Value: N
|
| 18 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table:
BI_TYPE_EF_VW
|
| 19 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC_EF_VW
|
| 20 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE_VW
|
| 21 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
|
| 22 |
HDR_FIELDS_KEY |
Character(30) |
VARCHAR2(30) NOT NULL |
Header Fields Key
|
| 23 |
BILLING_FREQUENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Frequency
INS=Installment
ONC=Once
REC=Recurring
Default Value: ONC
|
| 24 |
TEMPLATE_IVC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Template Invoice Flag
I=Installment Bill
N=No
R=Recurring Bill
Y/N Table Edit
Default Value: N
|
| 25 |
TEMPLATE_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Template Invoice ID
|
| 26 |
RECURRING_START_DT |
Date(10) |
DATE |
Starting Date
|
| 27 |
RECURRING_END_DT |
Date(10) |
DATE |
Ending Date
|
| 28 |
AUTO_GEN_IVC_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre-Assign Invoice Numbers
Y/N Table Edit
Default Value: N
|
| 29 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 30 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 31 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
CUST_ADDR_BI_VW
|
| 32 |
BILL_TO_COPIES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Copies
Default Value: 1
|
| 33 |
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
Default Value: P
|
| 34 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
Prompt Table:
CUST_CNCT_EF_VW
|
| 35 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 36 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
Prompt Table:
%EDITTABLE20
|
| 37 |
CR_CARD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Flag
Y/N Table Edit
Default Value: N
|
| 38 |
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.
Prompt Table:
SUBCUST_Q1_TBL
|
| 39 |
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.
Prompt Table:
SUBCUST_Q2_TBL
|
| 40 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
Prompt Table:
BI_INQPHONE_VW
|
| 41 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPECIALST_VW
|
| 42 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTHORITY_VW
|
| 43 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Default Value: CUST_OPTION.COLLECTOR
Prompt Table:
COLLECTOR_TBL
|
| 44 |
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.
Prompt Table:
BI_TEAM_MBR_VW
Set Control Field: BUSINESS_UNIT
|
| 45 |
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.
Default Value: CUST_OPTION.CR_ANALYST
Prompt Table:
CR_ANALYST_TBL
|
| 46 |
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.
Prompt Table:
AR_TRMS_VW
|
| 47 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
%EDITTABLE15
|
| 48 |
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
Prompt Table:
%EDITTABLE16
|
| 49 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 50 |
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. "
|
| 51 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
|
| 52 |
FINAL_CURCNV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Currency Conversion Flag
Y/N Table Edit
Default Value: N
|
| 53 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 54 |
CUR_RT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
Default Value: T
|
| 55 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 56 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 57 |
RATE_MULT_XEU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 58 |
RATE_DIV_XEU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 59 |
RATE_MULT_IU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 60 |
RATE_DIV_IU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 61 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 62 |
BI_PAID_AT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Paid at Source Indicator
0=Unpaid
1=Customer Deposit Applied
2=Partially Paid
9=Fully Paid
Default Value: 0
|
| 63 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 64 |
FORWARD_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Forwarding Balance
|
| 65 |
INVOICE_AMT_PRETAX |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 66 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 67 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 68 |
FORWARD_BAL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Forwarding Balance
|
| 69 |
INVOICE_PRETAX_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 70 |
INVOICE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 71 |
FORWARD_BAL_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Forwarding Balance
|
| 72 |
INVOICE_PRETAX_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 73 |
INVOICE_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 74 |
PAID_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Euro Paid Amount
|
| 75 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 76 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 77 |
DT_INVOICED |
Date(10) |
DATE |
Date Invoiced
|
| 78 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 79 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
Prompt Table:
%EDITTABLE14
|
| 80 |
IVC_PRINTED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Printed
N=Not Printed
R=Printed as Rebill
Y=Printed
Y/N Table Edit
Default Value: N
|
| 81 |
IVC_PRINTED_DT |
Date(10) |
DATE |
Invoice Printed Date
|
| 82 |
EDI_SENT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
EDI Sent Flag
Y/N Table Edit
Default Value: N
|
| 83 |
CF_ACTION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Chartfield Action Flag
Default Value: N
|
| 84 |
PRELOAD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing: Used to indicate the status of the invoice with regard to the PreLoad Process (BIPRELD).
1=Pending - Invoices ready to be processed
2=Done - Invoices processed with no errors
3=ComboEdit Error - Invoices contain combo edit error
1=Pending
2=Done
3=ComboEdit Error
Default Value: 1
|
| 85 |
ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Prompt Table:
%EDITTABLE12
Set Control Field: BUSINESS_UNIT_AR
|
| 86 |
ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table:
%EDITTABLE13
Set Control Field: BUSINESS_UNIT_AR
|
| 87 |
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
|
| 88 |
AR_DST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Distribution Option
H=Use Header for Distribution
L=Use Line for Distribution
|
| 89 |
AR_ENTRY_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Accounting Entry Created
Y/N Table Edit
Default Value: N
|
| 90 |
GEN_AR_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate AR Open Item
Default Value: N
|
| 91 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: BUS_UNIT_TBL_BI.BUSINESS_UNIT_GL
|
| 92 |
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
|
| 93 |
GL_ENTRY_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Accounting Entry Created
Y/N Table Edit
Default Value: N
|
| 94 |
ENABLE_DFR_REV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Deferred Revenues
|
| 95 |
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
|
| 96 |
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
|
| 97 |
DFR_MID_PERIOD_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Mid-Period # of Days
|
| 98 |
DST_ID_DFR |
Character(10) |
VARCHAR2(10) NOT NULL |
Deferred Distribution Code
|
| 99 |
BILL_STATUS_TEXT |
Character(12) |
VARCHAR2(12) NOT NULL |
Bill Status Text
|
| 100 |
MANUAL_LIN_NUM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Manual Line Numbering
Y/N Table Edit
Default Value: INSTALLATION_BI.MANUAL_LIN_NUM_FLG
|
| 101 |
LAST_LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Last Line Sequence Number
Default Value: 1
|
| 102 |
LAST_LINE_AAUX_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Last Line Seq Num in Adj Aux
|
| 103 |
LAST_NOTE_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Last note sequence number
Default Value: 1
|
| 104 |
ACCRUE_UNBILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Bills of This Level
Y/N Table Edit
Default Value: N
|
| 105 |
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.
Prompt Table:
BI_DOC_TYPE_VW
|
| 106 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 107 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 108 |
PC_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
Default Value: I
|
| 109 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 110 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 111 |
CONTRACT_DT |
Date(10) |
DATE |
Contract Date
|
| 112 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
|
| 113 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
Default Value: N
|
| 114 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BU_OM_NONVW
|
| 115 |
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
Prompt Table:
BI_ORD_HDR_VW
|
| 116 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
Prompt Table:
BI_RMA_HDR_VW
|
| 117 |
ORDER_DATE |
Date(10) |
DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 118 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
%EDITTABLE10
|
| 119 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 120 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table:
%EDITTABLE2
|
| 121 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
Prompt Table:
BI_SHP_ADDR_VW
|
| 122 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 123 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
%EDITTABLE11
|
| 124 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 125 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
BI_SOLD_TO_VW
|
| 126 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
Prompt Table:
BI_SLD_ADDR_VW
|
| 127 |
ACTIVITY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason
|
| 128 |
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.
|
| 129 |
RANGE_SELECTION_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Range Selection ID
|
| 130 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 131 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 132 |
SERVICE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Customer ID
Prompt Table:
CUSTOMER
|
| 133 |
SERVICE_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Service Address Num
Prompt Table:
BI_SVC_ADDR_VW2
|
| 134 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 135 |
END_DT |
Date(10) |
DATE |
End Date
|
| 136 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|
| 137 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 138 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 139 |
GEN_AP_VCHR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate AP Voucher
Y/N Table Edit
Default Value: N
|
| 140 |
AP_CREATED_DT |
Date(10) |
DATE |
AP Voucher Created Date
|
| 141 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 142 |
EARLY_PY_DSCNT_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Early Pymnt Dscnt Percentage
|
| 143 |
DS_PY_TRMS_TIME_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Discount Timing
|
| 144 |
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.
|
| 145 |
MAX_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
max_tax_flg = 'Y' implies that max taxes were applied
Y/N Table Edit
Default Value: N
|
| 146 |
TOT_SU_TAX |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Sales/Use Tax
|
| 147 |
TOT_SU_TAX_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Sales/Use Tax
|
| 148 |
TOT_SU_TAX_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Sales/Use Tax
|
| 149 |
TOT_VAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 150 |
TOT_VAT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 151 |
TOT_VAT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 152 |
TOT_VAT_BASIS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Basis Amount
|
| 153 |
TOT_VAT_BASIS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Basis Amount
|
| 154 |
TOT_VAT_BASIS_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Basis Amount
|
| 155 |
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
Default Value: CHK
|
| 156 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 157 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 158 |
LOC_DOC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
|
| 159 |
PAID_REFERENCE |
Character(30) |
VARCHAR2(30) NOT NULL |
Pre-payment Reference
|
| 160 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
|
| 161 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 162 |
FAX |
Character(24) |
VARCHAR2(24) NOT NULL |
Fax Number
|
| 163 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 164 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 165 |
REIMB_AGREEMENT |
Character(25) |
VARCHAR2(25) NOT NULL |
Date Init. Issue # Description
09/25/01 JJM DI-EDWONG-17 Created field to replace CONTRACT_NUM in certain records
Prompt Table:
CUST_AGREE_VW
|
| 166 |
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
|
| 167 |
EXD_INVOICE_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Invoice Number
|
| 168 |
STX_TAX_AUTH_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Authority Code
|
| 169 |
TOT_EXD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Excise Amount
|
| 170 |
TOT_EXD_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Excise Amount Base
|
| 171 |
TOT_STX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total ST/VAT Amount
|
| 172 |
TOT_STX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Sales Tax Amount Base
|
| 173 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 174 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
Prompt Table:
BI_VT_TRMTG_VW
|
| 175 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
Prompt Table:
VAT_ENT_REG_VW
|
| 176 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
Prompt Table:
COUNTRY_VAT_VW
|
| 177 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
Prompt Table:
VAT_STATE_TO_VW
|
| 178 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 179 |
REPRINT_GROUP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Reprint Group ID
|
| 180 |
MAST_CONTR_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Master Contract #
|
| 181 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 182 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
|
| 183 |
BUSINESS_UNIT_RF |
Character(5) |
VARCHAR2(5) NOT NULL |
Field Services Business Unit
|
| 184 |
SOURCE_REF_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Generice reference type
001=CRM Agreement
002=CRM Case
003=CRM Order
004=CRM Service Order
005=Accounts Receivable
006=Billing
007=Order Management
|
| 185 |
SOURCE_REF_NO |
Character(35) |
VARCHAR2(35) NOT NULL |
Generic reference number
|
| 186 |
SOURCE_REF_KEY |
Character(5) |
VARCHAR2(5) NOT NULL |
Additional key for generic reference. May be populated with business unit, setid, or other key value.
|
| 187 |
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.
Y/N Table Edit
Default Value: N
|
| 188 |
AG_REF_NBR |
Number(16,0) |
DECIMAL(16) NOT NULL |
Payment Reference Number
|
| 189 |
IVC_DELIVERED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Delivered
Y/N Table Edit
Default Value: N
|
| 190 |
IVC_DELIVERED_DT |
Date(10) |
DATE |
Invoice Delivered Date
|
| 191 |
SUMMARIZE_IVC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Summarize Invoice Flag
Y/N Table Edit
Default Value: N
|
| 192 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 193 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 194 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 195 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 196 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 197 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 198 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 199 |
ATT_IVC_IMG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Attach Invoice Image
Y/N Table Edit
Default Value: N
|
| 200 |
USER_AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 201 |
USER_AMT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8)
|
| 202 |
USER_AMT1_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amt 1
|
| 203 |
USER_AMT2_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amt 2
|
| 204 |
USER_AMT1_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amt 1
|
| 205 |
USER_AMT2_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amt 2
|
| 206 |
USER_DT1 |
Date(10) |
DATE |
Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4).
|
| 207 |
USER_DT2 |
Date(10) |
DATE |
Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4).
|
| 208 |
USER1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 209 |
USER2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 210 |
USER3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 211 |
USER4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 212 |
USER5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 213 |
USER6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 214 |
USER7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 215 |
USER8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 216 |
USER9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
|
| 217 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 218 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 219 |
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.
|
| 220 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 221 |
BILL_FSS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmed
B=Blocked
C=Cleared
R=Review
V=Valid
Default Value: V
|
| 222 |
OFAC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid
Default Value: V
|
| 223 |
SDN_PUBLISH_DATE |
Date(10) |
DATE |
Publish date given on the loaded Financial Sanction list.
|
| 224 |
FSS_ACTIVITY_DT |
Date(10) |
DATE |
EGS 03/02/06: Created
|
| 225 |
FSS_CLEAR_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Clearing Operator
|
| 226 |
FSS_USER_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
User Override
A=Customer Name has Overriden
N=No Customer Information Change
Y=Customer Information Changed
Default Value: N
|
| 227 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
BI_FSS_RSN_VW
|
| 228 |
REASON_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Reason Type
|
| 229 |
PUBLIC_VOUCHER_NBR |
Number(6,0) |
INTEGER NOT NULL |
Public Voucher Number
|
| 230 |
PVN_GEN_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
PVN Generation Level field used to store the Level on which a Public Voucher needs to be generated for a contract
C=Contract Number
CL=Contract Number/Contract Line
CP=Contract Number/Project
|
| 231 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 232 |
EIVC_COPY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
E-Invoice Copy Indicator
N=Original Elec Invoice File
O=Cannot Generate EIVC File
Y=Copy Electronic Invoice File
Default Value: N
|
| 233 |
FINAL_FF_EXT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether a Final run of the Federal Highway Extract File process has taken place for an invoice.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 234 |
TARGET_PYMT_DT |
Date(10) |
DATE |
The Target Payment Date on the final run of the Federal Highway Extract File process for an invoice.
|
| 235 |
HOLD_UNTIL_DT |
Date(10) |
DATE |
Hold Until Date
|
| 236 |
BI_APPROVAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
0=Not Required
1=Initial
2=Pending
3=Approved
4=Denied
5=Canceled
Default Value: 0
|
| 237 |
TOT_VAT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 238 |
TOT_VAT_RVC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 239 |
TOT_VAT_RVC_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Reverse Charge Amt
|
| 240 |
CREATEOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 241 |
BI_CREATE_PROC |
Character(2) |
VARCHAR2(2) NOT NULL |
Created By Process
00=Billing Interface
01=Worksheet Online
02=Worksheet Batch
20=Standard Billing
21=Express Billing
22=Consolidated Billing
23=Single Bill Copy
24=Adjust Entire Bill
25=Adjust Line
40=Installment Bill
41=Recurring Bill
42=Copy Bill Group
|
| 242 |
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
|