| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 3 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 4 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 5 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 6 |
ORIGINAL_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Original Line Sequence 5
Default Value: BI_LINE.LINE_SEQ_NUM
|
| 7 |
NEXT_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusting Invoice
|
| 8 |
NEXT_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Next Adjustment Line Sequence
|
| 9 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 10 |
PRIOR_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prior Adjustment Line Seq
|
| 11 |
LATEST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Latest Invoice
|
| 12 |
LATEST_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Latest Line Sequence
Default Value: BI_LINE.LINE_SEQ_NUM
|
| 13 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC_EF_VW
|
| 14 |
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.
|
| 15 |
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.
|
| 16 |
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)
|
| 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 |
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
Default Value: REV
|
| 19 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 20 |
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. "
|
| 21 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
|
| 22 |
RT_EFFDT |
Date(10) |
DATE |
The effective date for a given item of market rate data.
|
| 23 |
CHARGE_FROM_DT |
Date(10) |
DATE |
From Date for line charges
Default Value: BI_HDR.FROM_DT
|
| 24 |
CHARGE_TO_DT |
Date(10) |
DATE |
Through date for charges
Default Value: BI_HDR.TO_DT
|
| 25 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
Prompt Table:
%EDITTABLE4
|
| 26 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 27 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
UNITS_TBL
|
| 28 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 29 |
ORIG_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Original Quantity
|
| 30 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 31 |
PRICE_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalculate Price
Y/N Table Edit
Default Value: N
|
| 32 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table:
TAX_HEADER_TBL
|
| 33 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
Prompt Table:
CUST_EXEMPT
|
| 34 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
Default Value: N
|
| 35 |
GROSS_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 36 |
NET_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt
|
| 37 |
ORIG_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Original Amount
|
| 38 |
GROSS_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 39 |
NET_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount
|
| 40 |
GROSS_EXTENDED_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 41 |
NET_EXTENDED_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount
|
| 42 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 43 |
TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount (base)
|
| 44 |
TAX_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount - Euro
|
| 45 |
TAX_PCT |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Tax Percent
|
| 46 |
FINAL_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Tax Flag
|
| 47 |
MAX_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
max_tax_flg = 'Y' implies that max taxes were applied
|
| 48 |
BI_TAX_TIMING |
Character(1) |
VARCHAR2(1) NOT NULL |
BI Tax Timing
S=Tax on Services Rendered
|
| 49 |
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.
|
| 50 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 51 |
VAT_BASIS_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amount in Euro Curr
|
| 52 |
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.
|
| 53 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount in Base Curr
|
| 54 |
VAT_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount - Euro Currency
|
| 55 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 56 |
VAT_TRANS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount in base currency against which the VAT is applicable
|
| 57 |
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.
|
| 58 |
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.
|
| 59 |
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.
|
| 60 |
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
|
| 61 |
PROD_GRP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product Group SetID
|
| 62 |
VAT_PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Group
|
| 63 |
PRODUCT_KIT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product Kit Number
|
| 64 |
VAT_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Distribution Status
D=Distributed
E=Error Flag
I=Ignored
M=Archival Entry
N=Not Distributed
P=Processed
R=Reversal Entry
U=Undefined
|
| 65 |
TAX_VAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include VAT
N=No
Y=Yes
|
| 66 |
REV_RECOG_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Revenue Recognition Basis
CHG=From/To Date Range
CON=Contract Date
INV=Invoice Date
ORD=Order Date
SHP=Ship Date
STE=Start/End Date Range
UD1=User Date 1
UD2=User Date 2
|
| 67 |
DEFERRED_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to Deferred Booking
|
| 68 |
TOT_LINE_DST_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Total Revenue Percent
|
| 69 |
TOT_LINE_DFR_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Total Deferred Percent
|
| 70 |
TOT_LINE_UAR_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Total Unbilled AR Percent
|
| 71 |
TOT_LINE_DST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Dist Amount
|
| 72 |
TOT_LINE_DFR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Deferred Amount
|
| 73 |
TOT_LINE_UAR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Unbilled AR Amount
|
| 74 |
TOT_LINE_DST_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Dist Amount
|
| 75 |
TOT_LINE_DFR_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Contract Liability Amt
|
| 76 |
TOT_LINE_UAR_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Contract Asset Amount
|
| 77 |
TOT_LINE_DST_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Dist Amount
|
| 78 |
TOT_LINE_DFR_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Contract Liability Amt
|
| 79 |
TOT_LINE_UAR_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Contract Asset Amount
|
| 80 |
TOT_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amt
|
| 81 |
TOT_SURCHARGE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amt
|
| 82 |
TOT_DISCOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Discount Amount
|
| 83 |
TOT_SURCHARGE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amount
|
| 84 |
TOT_DISCOUNT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Discount Amount
|
| 85 |
TOT_SURCHARGE_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amount
|
| 86 |
LINE_DST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Revenue Sequence Number
Default Value: 1
|
| 87 |
LINE_DFR_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Deferred Sequence Number
|
| 88 |
LINE_UAR_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Unbilled AR Sequence Number
Default Value: 1
|
| 89 |
LAST_NOTE_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Last note sequence number
Default Value: 1
|
| 90 |
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:
%EDITTABLE
|
| 91 |
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:
%EDITTABLE2
|
| 92 |
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
|
| 93 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
Default Value: BI_HDR.PO_REF
|
| 94 |
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.
|
| 95 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 96 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Default Value: BI_HDR.CONTRACT_NUM
|
| 97 |
CONTRACT_DT |
Date(10) |
DATE |
Contract Date
Default Value: BI_HDR.CONTRACT_DT
|
| 98 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
Default Value: BI_HDR.CONTRACT_TYPE
|
| 99 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
|
| 100 |
BPLAN_LN_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bill Plan Line Number
|
| 101 |
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.
|
| 102 |
XREF_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Cross Reference Sequence No.
|
| 103 |
CONTRACT_PPD_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prepaid Add Sequence
|
| 104 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Default Value: BI_HDR.BUSINESS_UNIT_OM
|
| 105 |
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
Default Value: BI_HDR.ORDER_NO
|
| 106 |
ORDER_DATE |
Date(10) |
DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Default Value: BI_HDR.ORDER_DATE
|
| 107 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 108 |
SCHED_LINE_NBR |
Number(6,0) |
INTEGER NOT NULL |
Schedule Line Number
|
| 109 |
BUSINESS_UNIT_RMA |
Character(5) |
VARCHAR2(5) NOT NULL |
RMA Business Unit
|
| 110 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
|
| 111 |
RMA_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
RMA Line Number
|
| 112 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 113 |
DIST_CFG_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Configuration
|
| 114 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Default Value: BI_HDR.FREIGHT_TERMS
Prompt Table:
FREIGHT_TERMS
|
| 115 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
Default Value: BI_HDR.BILL_OF_LADING
|
| 116 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
Default Value: BI_HDR.SHIP_TO_CUST_ID
Prompt Table:
%EDITTABLE7
|
| 117 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
Default Value: BI_HDR.SHIP_TO_ADDR_NUM
Prompt Table:
BI_SHP_ADDR_VW
|
| 118 |
SHIP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shipping ID
Default Value: BI_HDR.SHIP_ID
|
| 119 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Default Value: BI_HDR.SHIP_TYPE_ID
Prompt Table:
SHIP_METHOD
|
| 120 |
SHIP_FROM_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Ship from INV BU
Default Value: BI_HDR.SHIP_FROM_BU
|
| 121 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 122 |
SHIP_TIME |
Time(15) |
TIMESTAMP |
Ship Time
|
| 123 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 124 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Default Value: BI_HDR.SOLD_TO_CUST_ID
Prompt Table:
BI_SOLD_TO_VW
|
| 125 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
|
| 126 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Default Value: BI_HDR.BUSINESS_UNIT_PC
|
| 127 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 128 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: BI_HDR.PROJECT_ID
Prompt Table:
PROJID_BUGL_VW
|
| 129 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Default Value: BI_HDR.ANALYSIS_TYPE
|
| 130 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Default Value: BI_HDR.RESOURCE_TYPE
|
| 131 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Default Value: BI_HDR.RESOURCE_CATEGORY
|
| 132 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Default Value: BI_HDR.RESOURCE_SUB_CAT
|
| 133 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Default Value: BI_HDR.ACTIVITY_ID
|
| 134 |
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
Default Value: BI_HDR.ACTIVITY_TYPE
|
| 135 |
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.
Default Value: BI_HDR.SYSTEM_SOURCE
|
| 136 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: BI_HDR.EMPLID
|
| 137 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
Default Value: BI_HDR.SSN
|
| 138 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 139 |
SERVICE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Customer ID
Default Value: BI_HDR.SERVICE_CUST_ID
Prompt Table:
CUSTOMER
|
| 140 |
SERVICE_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Service Address Num
Default Value: BI_HDR.SERVICE_ADDR_NUM
Prompt Table:
BI_SVC_ADDR_VW
|
| 141 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 142 |
END_DT |
Date(10) |
DATE |
End Date
Default Value: BI_LINE.START_DT
|
| 143 |
ACCUMULATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in Cumulative Balance
Y/N Table Edit
Default Value: Y
|
| 144 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|
| 145 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 146 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
|
| 147 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No
Y=Yes
|
| 148 |
IST_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Distribution Status
A=Awaiting Arrival Processing
D=Distributed
I=Ignored
M=Archival Entry
N=Not Distributed
R=Reversal Entry
S=Awaiting Dispatch Processing
U=Undefined
|
| 149 |
INVENTORY_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Item
N=No
Y=Yes
|
| 150 |
FISCAL_REGIME |
Character(6) |
VARCHAR2(6) NOT NULL |
Fiscal Regime
|
| 151 |
NATURE_OF_TXN1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Nature of Transaction 1
|
| 152 |
NATURE_OF_TXN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Nature of Transaction 2
|
| 153 |
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
|
| 154 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 155 |
DEFER_DT |
Date(10) |
DATE |
Defer Date
|
| 156 |
PPRC_PROMO_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
Price Promotion Code
|
| 157 |
MERCH_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Merchandising Type
|
| 158 |
LIST_PRICE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
List Price
|
| 159 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
|
| 160 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 161 |
VAT_TREATMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment
Prompt Table:
BI_VT_TREAT_VW
|
| 162 |
VAT_SVC_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
|
| 163 |
VAT_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
|
| 164 |
VAT_DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
|
| 165 |
VAT_ADVPAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT prepayment flag is to indicate if the VAT amount should be calculated on the advance payments
|
| 166 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 167 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
|
| 168 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 169 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
|
| 170 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 171 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 172 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
|
| 173 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 174 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 175 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|
| 176 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 177 |
EXD_CUST_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Customer Category Code
|
| 178 |
STX_CUST_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Customer Category Code
|
| 179 |
VAT_DFLT_DONE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done
|
| 180 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 181 |
QTY_BASE |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Base Quantity
|
| 182 |
EXD_INVOICE_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Invoice Number
|
| 183 |
EXD_INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Excise Invoice Line Number
|
| 184 |
ORG_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Organization SetID.
|
| 185 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 186 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 187 |
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.
|
| 188 |
STX_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Applicability.
|
| 189 |
EXS_DFLTS_APPLIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise Defaults Applied Flag
N=Defaults have not been applied
X=Non-India Bill-Not Applicable
Y=Defaults have been applied
|
| 190 |
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
|
| 191 |
STX_TAX_AUTH_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Authority Code
|
| 192 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
|
| 193 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
|
| 194 |
EXD_ITM_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Item Category Code
|
| 195 |
STX_ITM_CATG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Item Category Code
|
| 196 |
EXS_SERV_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Tax Indicator
N=Not Service Tax
Y=Service Tax
|
| 197 |
STX_FORM_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Form Code
|
| 198 |
FORM_DISTRIB_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for Sales Tax Forms tracking
D=Distributed
I=Ignore
N=Not Distributed
U=Undefined
|
| 199 |
EXD_ASSESS_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Assessable Value
|
| 200 |
EXD_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Unit Of Measure
|
| 201 |
EXD_CONVERSION_RT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 202 |
EXD_USE_AV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise Use Av Flag
|
| 203 |
EXD_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Excise Tax Calculation Code
|
| 204 |
EXD_TAX_RATE_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Excise Tax Rate Source
1=System Defined
2=Manually Entered
|
| 205 |
EXD_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Tax Amount
|
| 206 |
EXD_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Duty in Base Currency
|
| 207 |
EXD_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Duty Amt In Rpt Curr
|
| 208 |
STX_TAX_RATE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales Tax Calculation Code
|
| 209 |
STX_TAX_RATE_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Rate Source
1=System Defined
2=Manually Entered
|
| 210 |
STX_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 211 |
STX_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SALES TAX IN BASE CURR
|
| 212 |
STX_TAX_AMT_RPT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SALES TAX IN REPORT CURR
|
| 213 |
EXS_CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Excise Currency Reporting
|
| 214 |
BUSINESS_UNIT_AMTO |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Business Unit To
|
| 215 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 216 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 217 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 218 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
|
| 219 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
|
| 220 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 221 |
LANG_DESCR_OVR |
Character(3) |
VARCHAR2(3) NOT NULL |
Language of Descr Override
|
| 222 |
SO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Order ID
|
| 223 |
BUSINESS_UNIT_RF |
Character(5) |
VARCHAR2(5) NOT NULL |
Field Services Business Unit
|
| 224 |
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
|
| 225 |
SOURCE_REF_NO |
Character(35) |
VARCHAR2(35) NOT NULL |
Generic reference number
|
| 226 |
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.
|
| 227 |
CA_PGP_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Progress Payment Sequence
|
| 228 |
SUM_TEMPLATE_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Summarization Template ID
|
| 229 |
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.
|
| 230 |
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.
|
| 231 |
CUST_DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer Deposit ID
|
| 232 |
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)
|
| 233 |
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)
|
| 234 |
USER_AMT1_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amt 1
|
| 235 |
USER_AMT2_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amt 2
|
| 236 |
USER_AMT1_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amt 1
|
| 237 |
USER_AMT2_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amt 2
|
| 238 |
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).
|
| 239 |
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).
|
| 240 |
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).
|
| 241 |
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).
|
| 242 |
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).
|
| 243 |
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).
|
| 244 |
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).
|
| 245 |
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).
|
| 246 |
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).
|
| 247 |
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).
|
| 248 |
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).
|
| 249 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 250 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 251 |
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.
|
| 252 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 253 |
OFAC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid
Default Value: V
|
| 254 |
SDN_PUBLISH_DATE |
Date(10) |
DATE |
Publish date given on the loaded Financial Sanction list.
|
| 255 |
FSS_ACTIVITY_DT |
Date(10) |
DATE |
EGS 03/02/06: Created
|
| 256 |
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
|
| 257 |
CUSTOMER_PO_LINE |
Character(11) |
VARCHAR2(11) NOT NULL |
Customer PO Line
|
| 258 |
CUSTOMER_PO_SCHED |
Character(11) |
VARCHAR2(11) NOT NULL |
Customer PO Schedule
|
| 259 |
PC_CF_CHANGE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator to flag whether the Project chartfields were updated on a billing line.
|
| 260 |
CREDIT_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
Adjustment Reason
|
| 261 |
VAT_RVRSE_CHG_GDS |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reverse Charge goods flag
Y/N Table Edit
|
| 262 |
TAX_CD_VAT_RVC |
Character(8) |
VARCHAR2(8) NOT NULL |
Reverse Charge VAT Code
|
| 263 |
TAX_CD_VAT_RVC_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Customer VAT Rate
|
| 264 |
VAT_AMT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reverse Charge VAT Amount
|
| 265 |
VAT_AMT_RVC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Reverse Charge Amount in Base Currency
|
| 266 |
VAT_AMT_RVC_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Customer Amount
|
| 267 |
TEMP_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Temporary Invoice
|