| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 4 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
PRINT_SEQ_NBR |
Number(5,0) |
INTEGER NOT NULL |
Print Sequence
|
| 6 |
PRINT_SORT_BY |
Character(60) |
VARCHAR2(60) NOT NULL |
Print Order By
|
| 7 |
INVOICE_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Action
C=Reprint
I=Invoice
P=Pro Forma
|
| 8 |
CONSOLIDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidate Headers
|
| 9 |
CONSOL_HDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidated Hdr?
N=No
Y=Yes
|
| 10 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 11 |
CONSOL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Specifies the invoice identifier associated with a consolidated bill.
|
| 12 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 13 |
CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Name
|
| 14 |
EXD_INVOICE_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Invoice Number
|
| 15 |
STX_TAX_AUTH_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Authority Code
|
| 16 |
STX_LST_RGSTN |
Character(30) |
VARCHAR2(30) NOT NULL |
Local SalesTax Registration Number. It is allocated by the Sales Tax authority. The LST registration number should be captured for the vendor and customer at their location levels.
|
| 17 |
EXD_RGSTN_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Excise Registration Code. This field is unique to a particular Excise Tax Location.
|
| 18 |
STX_CST_RGSTN |
Character(30) |
VARCHAR2(30) NOT NULL |
Central Sales Tax Registration Number. It is allocated by the Sales Tax authority. The CST registration number should be captured for the vendor and customer at their location levels.
|
| 19 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
|
| 20 |
INVOICE_LAYOUT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Layout ID
|
| 21 |
PAGE_ORIENTATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Layout Type
E=Crystal
L=SQR - Landscape
P=SQR - Portrait
X=XML Publisher
|
| 22 |
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
|
| 23 |
LATEST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Latest Invoice
|
| 24 |
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
|
| 25 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware
N=None
V=Vertex
|
| 26 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
|
| 27 |
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.
|
| 28 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
|
| 29 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 30 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 31 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 32 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
|
| 33 |
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
|
| 34 |
BILL_STATUS_TEXT |
Character(12) |
VARCHAR2(12) NOT NULL |
Bill Status Text
|
| 35 |
BILL_TO_COPIES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Copies
|
| 36 |
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
|
| 37 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
|
| 38 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
|
| 39 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
|
| 40 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
|
| 41 |
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.
|
| 42 |
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.
|
| 43 |
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.
|
| 44 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 45 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 46 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
|
| 47 |
VAT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
|
| 48 |
VAT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
|
| 49 |
VAT_RGSTRN_BUYER |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies a customers VAT Registration ID for a particular country.
|
| 50 |
VAT_RGSTRN_SELLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Seller's VAT Registration
|
| 51 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
|
| 52 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
|
| 53 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
|
| 54 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 55 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 56 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 57 |
XEU_PARTICIPATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Euro Participating
|
| 58 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
|
| 59 |
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.
|
| 60 |
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.
|
| 61 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 62 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 63 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 64 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 65 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 66 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
|
| 67 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 68 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 69 |
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. "
|
| 70 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 71 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 72 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 73 |
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
|
| 74 |
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.
|
| 75 |
PYMNT_TERMS_CD_DSC |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Terms Description
|
| 76 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 77 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 78 |
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.
|
| 79 |
DISC_DT |
Date(10) |
DATE |
Specifies the date before which payment must be made on an invoice in order to qualify for a discount. This field applies to the first of two possible discounts and is associated with the discount amount specified in DISC_AMT.
|
| 80 |
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.
|
| 81 |
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.
|
| 82 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 83 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 84 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
|
| 85 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 86 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 87 |
ADDR_LN1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 1
|
| 88 |
ADDR_LN2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 2
|
| 89 |
ADDR_LN3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 3
|
| 90 |
ADDR_LN4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 4
|
| 91 |
ADDR_LN5 |
Character(80) |
VARCHAR2(80) NOT NULL |
Address Line 5
|
| 92 |
ADDR_LN6 |
Character(80) |
VARCHAR2(80) NOT NULL |
Address Line 6
|
| 93 |
ADDR_LN7 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 7
|
| 94 |
ADDR_LN8 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 8
|
| 95 |
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.
|
| 96 |
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.
|
| 97 |
CUSTOM_LABEL |
Character(20) |
VARCHAR2(20) NOT NULL |
Custom Label
|
| 98 |
INV_LABEL |
Character(20) |
VARCHAR2(20) NOT NULL |
Invoice Label
|
| 99 |
REMIT_POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Remit Postal Code
|
| 100 |
REMIT_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Remit Country
|
| 101 |
REMIT_ADDR_LN1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 1
|
| 102 |
REMIT_ADDR_LN2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 2
|
| 103 |
REMIT_ADDR_LN3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 3
|
| 104 |
REMIT_ADDR_LN4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 4
|
| 105 |
REMIT_ADDR_LN5 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 5
|
| 106 |
REMIT_ADDR_LN6 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 6
|
| 107 |
REMIT_ADDR_LN7 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 7
|
| 108 |
REMIT_ADDR_LN8 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 8
|
| 109 |
CONFIG_CD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Code Flag
|
| 110 |
CONFIG_DTL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Configuration Detail Flag
|
| 111 |
CFG_INVOICE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice with Configuration Flg
|
| 112 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 113 |
SHIP_CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name
|
| 114 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 115 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 116 |
SOLD_CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Sold To Name
|
| 117 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
|
| 118 |
SERVICE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Customer ID
|
| 119 |
SERVICE_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Service Address Num
|
| 120 |
CR_CARD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Flag
|
| 121 |
CR_CARD_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
"See OM
|
| 122 |
CR_CARD_DIGITS |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Number's Last Four Digits
|
| 123 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 124 |
AMOUNT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 125 |
NET_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
|
| 126 |
NET_AMOUNT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Amount Euro
|
| 127 |
FORWARD_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Forwarding Balance
|
| 128 |
FORWARD_BAL_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Forwarding Balance
|
| 129 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 130 |
INVOICE_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 131 |
INVOICE_AMT_PRETAX |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pretax Invoice Amount
|
| 132 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 133 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 134 |
PAID_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Euro Paid Amount
|
| 135 |
TOT_EXD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Excise Amount
|
| 136 |
TOT_EXD_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Excise Amount Base
|
| 137 |
TOT_STX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total ST/VAT Amount
|
| 138 |
TOT_STX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Sales Tax Amount Base
|
| 139 |
TOT_SU_TAX |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Sales/Use Tax
|
| 140 |
TOT_VAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 141 |
TEMPLATE_IVC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Template Invoice Flag
I=Installment Bill
N=No
R=Recurring Bill
|
| 142 |
TEMPLATE_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Template Invoice ID
|
| 143 |
BILLING_FREQUENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Frequency
INS=Installment
ONC=Once
REC=Recurring
|
| 144 |
PRINT_INST_DETAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Installment Detail
|
| 145 |
PRINT_INST_SUMMARY |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Installment Bill Summary
|
| 146 |
INS_PLAN_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Varying grid hyperlink
|
| 147 |
PRINT_VAT_ANAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print VAT analysis flag
|
| 148 |
PRINT_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Tax Flag
|
| 149 |
PRINT_UTL_PPD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Utilization Prepaid
|
| 150 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 151 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 152 |
PROJ_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Project ID Description
|
| 153 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 154 |
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
|
| 155 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 156 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 157 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 158 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 159 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 160 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 161 |
END_DT |
Date(10) |
DATE |
End Date
|
| 162 |
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
|
| 163 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 164 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 165 |
CONTRACT_DT |
Date(10) |
DATE |
Contract Date
|
| 166 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
|
| 167 |
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
|
| 168 |
ORDER_DATE |
Date(10) |
DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 169 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 170 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
|
| 171 |
INCL_ATTACHED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Attached Bills
|
| 172 |
PRINT_BILL_CC |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Bill Courtesy Copy
B=Bill To
C=Courtesy Copy To
|
| 173 |
PRIOR_INVOICE_DT |
Date(10) |
DATE |
Prior Invoice Dt
|
| 174 |
ORIG_INVOICE_DT |
Date(10) |
DATE |
Original Invoice Date. Used in BI_EXTRCT for adjustment invoices to hold the original invoice date.
|
| 175 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 176 |
ADJUSTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusted Flag
H=Header Level Adjustment
L=Line Level Adjustment
N=No Adjustments
|
| 177 |
NEXT_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusting Invoice
|
| 178 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 179 |
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.
|
| 180 |
AG_REF_NBR |
Number(16,0) |
DECIMAL(16) NOT NULL |
Payment Reference Number
|
| 181 |
PYMNT_REF_CNTRL_CD |
Number(1,0) |
SMALLINT NOT NULL |
Acceptgiro Pay Ref Num Cntl Cd
|
| 182 |
AG_REF_CHR |
Character(16) |
VARCHAR2(16) NOT NULL |
Payment Reference Number
|
| 183 |
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
|
| 184 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 185 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 186 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
|
| 187 |
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
|
| 188 |
GL_ENTRY_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Accounting Entry Created
|
| 189 |
AP_CREATED_DT |
Date(10) |
DATE |
AP Voucher Created Date
|
| 190 |
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""."
|
| 191 |
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.
|
| 192 |
AR_DST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Distribution Option
H=Use Header for Distribution
L=Use Line for Distribution
|
| 193 |
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
|
| 194 |
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.
|
| 195 |
AR_ENTRY_CREATED |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Accounting Entry Created
|
| 196 |
AUTO_GEN_IVC_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre-Assign Invoice Numbers
|
| 197 |
ACCRUE_UNBILLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrue Bills of This Level
|
| 198 |
DT_INVOICED |
Date(10) |
DATE |
Date Invoiced
|
| 199 |
LAST_LINE_AAUX_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Last Line Seq Num in Adj Aux
|
| 200 |
LAST_LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Last Line Sequence Number
|
| 201 |
LAST_NOTE_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Last note sequence number
|
| 202 |
RANGE_SELECTION_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Range Selection ID
|
| 203 |
SUMMARIZE_IVC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Summarize Invoice Flag
|
| 204 |
SUM_IVC_PRINT_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Summarized Invoice Print Option
BOTH=Print Both Summarized & Detail
DETL=Print Detail
SUM=Print Summarized
|
| 205 |
SUPPRESS_SUMM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to suppress the printing of Summary details on an Invoice that has been sent via Email to an Email ID from the Self Service Transactions.
|
| 206 |
PRINT_UOM_MSG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate that a note message is to be printed.
|
| 207 |
REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
|
| 208 |
REPORT_DEFN_ID2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Consolidated Report ID
|
| 209 |
BURST_VAL |
Character(100) |
VARCHAR2(100) NOT NULL |
Burst Field Value
|
| 210 |
ATT_IVC_IMG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Attach Invoice Image
|
| 211 |
EMAIL_IVC_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Email Invoice Options
1=Email Only
2=Email & Print
3=Print Only
|
| 212 |
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)
|
| 213 |
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)
|
| 214 |
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).
|
| 215 |
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).
|
| 216 |
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).
|
| 217 |
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).
|
| 218 |
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).
|
| 219 |
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).
|
| 220 |
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).
|
| 221 |
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).
|
| 222 |
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).
|
| 223 |
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).
|
| 224 |
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).
|
| 225 |
ADD_DT |
Date(10) |
DATE |
Customer Added On
|
| 226 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 227 |
BILL_FSS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmed
B=Blocked
C=Cleared
R=Review
V=Valid
Default Value: V
|
| 228 |
OFAC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid
Default Value: V
|
| 229 |
SDN_PUBLISH_DATE |
Date(10) |
DATE |
Publish date given on the loaded Financial Sanction list.
|
| 230 |
FSS_ACTIVITY_DT |
Date(10) |
DATE |
EGS 03/02/06: Created
|
| 231 |
FSS_CLEAR_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Clearing Operator
|
| 232 |
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
|
| 233 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
|
| 234 |
REASON_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Reason Type
|
| 235 |
PUBLIC_VOUCHER_NBR |
Number(6,0) |
INTEGER NOT NULL |
Public Voucher Number
|
| 236 |
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
|
| 237 |
TOT_VAT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 238 |
TOT_VAT_RVC_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Reverse Charge Amt
|
| 239 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 240 |
CUST_ID1 |
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.
|
| 241 |
BILL_CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Bill To Name
|
| 242 |
ADDR_SEQ_NUM_BILL |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 243 |
CNTCT_SEQ_BILL |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence - Bill To
|
| 244 |
POSTAL_BILL |
Character(12) |
VARCHAR2(12) NOT NULL |
Bill to Postal Code
|
| 245 |
COUNTRY_BILL |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill to Country
|
| 246 |
ADDR1_BILL |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 247 |
ADDR2_BILL |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 248 |
ADDR3_BILL |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 249 |
ADDR4_BILL |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 250 |
ADDR5_BILL |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 251 |
ADDR6_BILL |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 252 |
ADDR7_BILL |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 253 |
ADDR8_BILL |
Character(55) |
VARCHAR2(55) NOT NULL |
Address
|
| 254 |
GST_RGSTN_NBR_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
GST Registration Number
|
| 255 |
DESCR_BU |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Unit Description
|
| 256 |
BI_REV_CHRG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reverse Charge Amount
|
| 257 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|