| # |
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 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 6 |
PRINT_SEQ_NBR |
Number(5,0) |
INTEGER NOT NULL |
Print Sequence
|
| 7 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 8 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 9 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 10 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 11 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 12 |
DIST_CFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Configuration
|
| 13 |
CONFIG_CODE |
Character(50) |
VARCHAR2(50) NOT NULL |
Product Configurator
|
| 14 |
PRODUCT_KIT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product Kit Number
|
| 15 |
SETID_PRODKIT |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 16 |
PROD_KIT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Product Kit Description
|
| 17 |
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.
|
| 18 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 19 |
ADJ_LINE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Line Type
ACR=Adjustment Credit Line
ADJ=Adjustment
ARB=Adjustment Rebill Line
REG=Regular bill line (not adjust)
|
| 20 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 21 |
ORIGINAL_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Original Line Sequence 5
|
| 22 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 23 |
PRIOR_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prior Adjustment Line Seq
|
| 24 |
NEXT_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusting Invoice
|
| 25 |
NEXT_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Next Adjustment Line Sequence
|
| 26 |
LATEST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Latest Invoice
|
| 27 |
LATEST_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Latest Line Sequence
|
| 28 |
LINE_DST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Revenue Sequence Number
|
| 29 |
LAST_NOTE_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Last note sequence number
|
| 30 |
IDENTIFIER_TBL |
Character(3) |
VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID
CON=Contracts
D=Discount Table
G=Generic Identifier
ID=PS/Billing Charge Id
ITM=PS/Inventory Item ID
LAB=Labor type
PDA=Product Alias
PRD=PS/Product Id
PRM=PS/Promotion Code
S=Surcharge Table
SVC=Service
UPC=UPC
UPN=Universal Item ID
|
| 31 |
LANG_DESCR_OVR |
Character(3) |
VARCHAR2(3) NOT NULL |
Language of Descr Override
|
| 32 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 33 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 34 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 35 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 36 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 37 |
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
|
| 38 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 39 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
|
| 40 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
|
| 41 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
|
| 42 |
TAX_CD_DESCR |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Code Short Description
|
| 43 |
TAX_PCT |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Tax Percent
|
| 44 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 45 |
VAT_TREATMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment
|
| 46 |
VAT_TRTMENT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Vat Treatment Description
|
| 47 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 48 |
TAX_CD_VAT_DESCR |
Character(10) |
VARCHAR2(10) NOT NULL |
VAT Tax Code Short Description
|
| 49 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 50 |
VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
|
| 51 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount in Base Curr
|
| 52 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
|
| 53 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 54 |
STX_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Applicability.
|
| 55 |
EXD_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values.
|
| 56 |
STX_FORM_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Form Code
|
| 57 |
DISC_SUR_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount/Surcharge
D=Discount
I=Installment Surcharge
S=Surcharge
|
| 58 |
TOT_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 59 |
TOT_SURCHARGE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amt
|
| 60 |
NET_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt
|
| 61 |
NET_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount
|
| 62 |
TOT_LINE_DST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Dist Amount
|
| 63 |
TOT_LINE_DST_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Total Revenue Percent
|
| 64 |
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""."
|
| 65 |
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.
|
| 66 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
|
| 67 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 68 |
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
|
| 69 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 70 |
ORDER_DATE |
Date(10) |
DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 71 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 72 |
PROD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product SetID
|
| 73 |
PRODUCT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Product Description
|
| 74 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 75 |
PO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.
|
| 76 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 77 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 78 |
FREIGHT_TRMS_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Freight Terms Description
|
| 79 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
|
| 80 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 81 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 82 |
BUSINESS_UNIT_RMA |
Character(5) |
VARCHAR2(5) NOT NULL |
RMA Business Unit
|
| 83 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
|
| 84 |
RMA_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
RMA Line Number
|
| 85 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 86 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 87 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 88 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
|
| 89 |
CONTRACT_DT |
Date(10) |
DATE |
Contract Date
|
| 90 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
|
| 91 |
BPLAN_LN_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bill Plan Line Number
|
| 92 |
CONTRACT_PPD_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prepaid Add Sequence
|
| 93 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 94 |
END_DT |
Date(10) |
DATE |
End Date
|
| 95 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 96 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 97 |
PROJ_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Project ID Description
|
| 98 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 99 |
SETID_ACTIVITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity SetID
|
| 100 |
ACTIVITY_ID_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Activity ID Description
|
| 101 |
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
|
| 102 |
ACTIV_TYPE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Activity Type Description
|
| 103 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 104 |
ANALYSIS_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 105 |
ANAL_TYPE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Analysis Type Description
|
| 106 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 107 |
SETID_RES_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid for Resource Category
|
| 108 |
RES_CAT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Resource Category Description
|
| 109 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 110 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 111 |
SETID_RES_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid for Resource Type
|
| 112 |
RES_TYPE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Resource Type Description
|
| 113 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 114 |
SETID_RES_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid for Resource SubCategory
|
| 115 |
RES_SUB_CAT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Resource Sub Categ Description
|
| 116 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 117 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 118 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 119 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 120 |
CHARGE_FROM_DT |
Date(10) |
DATE |
From Date for line charges
|
| 121 |
CHARGE_TO_DT |
Date(10) |
DATE |
Through date for charges
|
| 122 |
SERVICE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Customer ID
|
| 123 |
SERVICE_CUST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Customer Name
|
| 124 |
SERVICE_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Service Address Num
|
| 125 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 126 |
SHIP_CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Ship To Name
|
| 127 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 128 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 129 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 130 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 131 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 132 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 133 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 134 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 135 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 136 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 137 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 138 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 139 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 140 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 141 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 142 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 143 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 144 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 145 |
COUNTRY_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Country
|
| 146 |
STATE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
State Name
|
| 147 |
ADDR_LN1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 1
|
| 148 |
ADDR_LN2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 2
|
| 149 |
ADDR_LN3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 3
|
| 150 |
ADDR_LN4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 4
|
| 151 |
ADDR_LN5 |
Character(80) |
VARCHAR2(80) NOT NULL |
Address Line 5
|
| 152 |
ADDR_LN6 |
Character(80) |
VARCHAR2(80) NOT NULL |
Address Line 6
|
| 153 |
ADDR_LN7 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 7
|
| 154 |
ADDR_LN8 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 8
|
| 155 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 156 |
SOLD_CUST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Sold To Name
|
| 157 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
|
| 158 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 159 |
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.
|
| 160 |
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.
|
| 161 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 162 |
BUSINESS_UNIT_AMTO |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Business Unit To
|
| 163 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 164 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 165 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 166 |
PROFILE_ID_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Profile Id Description
|
| 167 |
BI_TAX_TIMING |
Character(1) |
VARCHAR2(1) NOT NULL |
BI Tax Timing
S=Tax on Services Rendered
|
| 168 |
ACCRUE_DT |
Date(10) |
DATE |
Accrual Date
|
| 169 |
DEFER_DT |
Date(10) |
DATE |
Defer Date
|
| 170 |
RT_EFFDT |
Date(10) |
DATE |
The effective date for a given item of market rate data.
|
| 171 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 172 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 173 |
MERCH_TYPE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Merchandise Type Description
|
| 174 |
INVENTORY_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Item
N=No
Y=Yes
|
| 175 |
FISCAL_REGIME |
Character(6) |
VARCHAR2(6) NOT NULL |
Fiscal Regime
|
| 176 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 177 |
ORG_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Organization SetID.
|
| 178 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 179 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 180 |
PROD_GRP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product Group SetID
|
| 181 |
EVENT_OCCURRENCE |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
|
| 182 |
XREF_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Cross Reference Sequence No.
|
| 183 |
CA_PGP_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Progress Payment Sequence
|
| 184 |
BUSINESS_UNIT_RF |
Character(5) |
VARCHAR2(5) NOT NULL |
Field Services Business Unit
|
| 185 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
|
| 186 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 187 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 188 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 189 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
|
| 190 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 191 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
|
| 192 |
VAT_APPLIC_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
VAT Applicability Description
|
| 193 |
VAT_PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Group
|
| 194 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
|
| 195 |
VAT_TXN_TYCD_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
VAT Transaction Type CD Descr
|
| 196 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 197 |
PHY_NATURE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Physcial Nature Description
|
| 198 |
EXD_INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Excise Invoice Line Number
|
| 199 |
EXD_INVOICE_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Invoice Number
|
| 200 |
EXD_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 201 |
EXS_TAX_TXN_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
|
| 202 |
EXS_TX_TXNTY_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Excise Tax Trans Type Descrip
|
| 203 |
EXD_CUST_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Customer Category Code
|
| 204 |
STX_CUST_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Customer Category Code
|
| 205 |
EXD_ITM_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Item Category Code
|
| 206 |
STX_ITM_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Item Category Code
|
| 207 |
EXD_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Tax Calculation Code
|
| 208 |
STX_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Tax Calculation Code
|
| 209 |
STX_FORM_NAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Form Name
|
| 210 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
|
| 211 |
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.
|
| 212 |
SOURCE_REF_NO |
Character(35) |
VARCHAR2(35) NOT NULL |
Generic reference number
|
| 213 |
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
|
| 214 |
SRCE_REF_TYP_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Source Reference Type Descr
|
| 215 |
SUM_GROUP_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
This field is used to provide additional grouping criteria for billing summarization. It is to be used with SUM_GROUP_TYPE. User defines a set of Summarization Group IDs per Summarization Group Type.
|
| 216 |
SUM_GROUP_ID_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Summarizatiion Group ID Descr
|
| 217 |
SUM_GROUP_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to provide additional grouping criteria for billing summarization. It is related to SUM_GROUP_ID. User defines a list of valid SUM_GROUP_IDs per SUM_GROUP_TYPE value.
|
| 218 |
SUM_GROUP_TY_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Summarizatiion Group Typ Descr
|
| 219 |
SUM_TEMPLATE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Summarization Template ID
|
| 220 |
SUM_TMPL_ID_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Sum Template ID Description
|
| 221 |
SUM_QTY_UOM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Summarize & Display Qty & UOM
|
| 222 |
GROUP_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
|
| 223 |
CUST_DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer Deposit ID
|
| 224 |
DEPOSIT_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Deposit Invoice
|
| 225 |
DEPOSIT_INVOICE_DT |
Date(10) |
DATE |
Deposit Invoice Date
|
| 226 |
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)
|
| 227 |
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)
|
| 228 |
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).
|
| 229 |
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).
|
| 230 |
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).
|
| 231 |
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).
|
| 232 |
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).
|
| 233 |
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).
|
| 234 |
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).
|
| 235 |
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).
|
| 236 |
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).
|
| 237 |
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).
|
| 238 |
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).
|
| 239 |
ADD_DT |
Date(10) |
DATE |
Customer Added On
|
| 240 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 241 |
OFAC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid
Default Value: V
|
| 242 |
SDN_PUBLISH_DATE |
Date(10) |
DATE |
Publish date given on the loaded Financial Sanction list.
|
| 243 |
FSS_ACTIVITY_DT |
Date(10) |
DATE |
EGS 03/02/06: Created
|
| 244 |
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
|
| 245 |
CUSTOMER_PO_LINE |
Character(11) |
VARCHAR2(11) NOT NULL |
Customer PO Line
|
| 246 |
CUSTOMER_PO_SCHED |
Character(11) |
VARCHAR2(11) NOT NULL |
Customer PO Schedule
|
| 247 |
UPN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Universal Product Number
|
| 248 |
PUBLIC_VOUCHER_NBR |
Number(6,0) |
INTEGER NOT NULL |
Public Voucher Number
|
| 249 |
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
|
| 250 |
VAT_RVRSE_CHG_GDS |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reverse Charge goods flag
Y/N Table Edit
|
| 251 |
TAX_CD_VAT_RVC |
Character(8) |
VARCHAR2(8) NOT NULL |
Reverse Charge VAT Code
|
| 252 |
TAX_CD_VAT_RVC_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Customer VAT Rate
|
| 253 |
VAT_AMT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reverse Charge VAT Amount
|
| 254 |
VAT_AMT_RVC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Reverse Charge Amount in Base Currency
|
| 255 |
TAX_CD_VAT_RVC_DSC |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer VAT Code Description
|