BI_WKS_DTL_VW

#	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 Default Value: BI_HDR.BILL_SOURCE_ID 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. Default Value: BI_HDR.SUBCUST_QUAL1 Prompt Table: SUBCUST_Q1_TBL
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. Default Value: BI_HDR.SUBCUST_QUAL2 Prompt Table: SUBCUST_Q2_TBL
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 Default Value: BI_HDR.BI_CURRENCY_CD
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. " Default Value: BI_HDR.BASE_CURRENCY
21	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency Default Value: BI_HDR.CURRENCY_CD_XEU
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_SU_HDR_VW
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 Y/N Table Edit Default Value: N
47	MAX_TAX_FLG	Character(1)	VARCHAR2(1) NOT NULL	max_tax_flg = 'Y' implies that max taxes were applied Y/N Table Edit Default Value: N
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. Prompt Table: VAT_TXN_CD
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. Prompt Table: VAT_HEADER_VW
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	VAT_RVRSE_CHG_GDS	Character(1)	VARCHAR2(1) NOT NULL	VAT Reverse Charge goods flag Y/N Table Edit
62	TAX_CD_VAT_RVC	Character(8)	VARCHAR2(8) NOT NULL	Reverse Charge VAT Code
63	TAX_CD_VAT_RVC_PCT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	Customer VAT Rate
64	VAT_AMT_RVC	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Reverse Charge VAT Amount
65	VAT_AMT_RVC_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Reverse Charge Amount in Base Currency
66	VAT_AMT_RVC_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Customer Amount
67	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID Prompt Table: SP_SETID_NONVW
68	VAT_PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
69	PRODUCT_KIT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Kit Number Prompt Table: BI_PROD_KIT_VW
70	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 Default Value: U
71	TAX_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include VAT N=No Y=Yes Y/N Table Edit Default Value: N
72	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 Default Value: BI_TYPE.REV_RECOG_BASIS
73	DEFERRED_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Subject to Deferred Booking Y/N Table Edit Default Value: N
74	ACCRUE_DT	Date(10)	DATE	Accrual Date
75	TOT_LINE_DST_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total Revenue Percent
76	TOT_LINE_DFR_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total Deferred Percent
77	TOT_LINE_UAR_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total Unbilled AR Percent
78	TOT_LINE_DST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Dist Amount
79	TOT_LINE_DFR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Deferred Amount
80	TOT_LINE_UAR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Unbilled AR Amount
81	TOT_LINE_DST_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Dist Amount
82	TOT_LINE_DFR_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Contract Liability Amt
83	TOT_LINE_UAR_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Contract Asset Amount
84	TOT_LINE_DST_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Dist Amount
85	TOT_LINE_DFR_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Contract Liability Amt
86	TOT_LINE_UAR_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Contract Asset Amount
87	TOT_DISCOUNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amt
88	TOT_SURCHARGE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Surcharge Amt
89	TOT_DISCOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Discount Amount
90	TOT_SURCHARGE_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Surcharge Amount
91	TOT_DISCOUNT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Discount Amount
92	TOT_SURCHARGE_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Surcharge Amount
93	LINE_DST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Revenue Sequence Number Default Value: 1
94	LINE_DFR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Deferred Sequence Number Default Value: 1
95	LINE_UAR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Unbilled AR Sequence Number Default Value: 1
96	LAST_NOTE_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Last note sequence number Default Value: 1
97	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: %EDITTABLE14 Set Control Field: BUSINESS_UNIT_AR
98	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: %EDITTABLE15 Set Control Field: BUSINESS_UNIT_AR
99	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged Default Value: I
100	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item. Default Value: BI_HDR.PO_REF
101	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.
102	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
103	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Default Value: BI_HDR.CONTRACT_NUM Prompt Table: CA_HDR_ACT_VW
104	CONTRACT_DT	Date(10)	DATE	Contract Date Default Value: BI_HDR.CONTRACT_DT
105	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type Default Value: BI_HDR.CONTRACT_TYPE
106	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID Prompt Table: CA_BILL_PLAN_VW
107	BPLAN_LN_NBR	Number(3,0)	SMALLINT NOT NULL	Bill Plan Line Number
108	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.
109	XREF_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Cross Reference Sequence No.
110	CONTRACT_PPD_SEQ	Number(5,0)	INTEGER NOT NULL	Prepaid Add Sequence
111	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit Default Value: BI_HDR.BUSINESS_UNIT_OM Prompt Table: SP_BU_OM_NONVW
112	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 Prompt Table: BI_ORD_HDR_VW
113	ORDER_DATE	Date(10)	DATE	Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop Default Value: BI_HDR.ORDER_DATE
114	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
115	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
116	BUSINESS_UNIT_RMA	Character(5)	VARCHAR2(5) NOT NULL	RMA Business Unit Prompt Table: SP_BU_OM_NONVW
117	RMA_ID	Character(10)	VARCHAR2(10) NOT NULL	RMA Number Prompt Table: BI_RMA_HDR_VW
118	RMA_LINE_NBR	Number(5,0)	INTEGER NOT NULL	RMA Line Number
119	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: BI_PROD_ITEM_VW
120	DIST_CFG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Distribution Configuration Y/N Table Edit Default Value: N
121	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Default Value: BI_HDR.FREIGHT_TERMS Prompt Table: %EDITTABLE10
122	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
123	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer Default Value: BI_HDR.SHIP_TO_CUST_ID Prompt Table: %EDITTABLE7
124	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num Prompt Table: BI_SHP_ADDR_VW
125	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID Default Value: BI_HDR.SHIP_ID
126	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Default Value: BI_HDR.SHIP_TYPE_ID Prompt Table: %EDITTABLE11
127	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU Default Value: BI_HDR.SHIP_FROM_BU Prompt Table: SP_BUIN_NONVW
128	SHIP_DATE	Date(10)	DATE	Item Shipping Date
129	SHIP_TIME	Time(15)	TIMESTAMP	Ship Time
130	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
131	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
132	SOLD_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Sold To Address Sequence Num Prompt Table: BI_SLD_ADDR_VW
133	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Default Value: BI_HDR.BUSINESS_UNIT_PC Prompt Table: SP_BU_PC_NONVW
134	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
135	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Default Value: BI_HDR.PROJECT_ID Prompt Table: PROJID_BUGL_VW
136	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Default Value: BI_HDR.ANALYSIS_TYPE Prompt Table: PROJ_ANTYPE_FS
137	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Default Value: BI_HDR.RESOURCE_TYPE Prompt Table: PROJ_RESTYPE_FS
138	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Default Value: BI_HDR.RESOURCE_CATEGORY Prompt Table: PROJ_RESCAT_FS
139	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Default Value: BI_HDR.RESOURCE_SUB_CAT Prompt Table: PROJ_SUBCAT_FS
140	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Default Value: BI_HDR.ACTIVITY_ID Prompt Table: PROJ_ACT_FS
141	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
142	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.
143	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: BI_HDR.EMPLID
144	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security # Default Value: BI_HDR.SSN
145	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
146	SERVICE_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Customer ID Default Value: BI_HDR.SERVICE_CUST_ID Prompt Table: CUSTOMER
147	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
148	START_DT	Date(10)	DATE	Start Date Default Value: BI_HDR.START_DT
149	END_DT	Date(10)	DATE	End Date Default Value: BI_HDR.END_DT
150	ACCUMULATE	Character(1)	VARCHAR2(1) NOT NULL	Include in Cumulative Balance Y/N Table Edit Default Value: Y
151	ERROR_STATUS_BI	Character(4)	VARCHAR2(4) NOT NULL	Error Status
152	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
153	BUSINESS_UNIT_TO	Character(5)	VARCHAR2(5) NOT NULL	04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
154	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes Y/N Table Edit Default Value: N
155	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 Default Value: U
156	INVENTORY_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Inventory Item N=No Y=Yes
157	FISCAL_REGIME	Character(6)	VARCHAR2(6) NOT NULL	Fiscal Regime
158	NATURE_OF_TXN1	Character(1)	VARCHAR2(1) NOT NULL	Nature of Transaction 1
159	NATURE_OF_TXN2	Character(1)	VARCHAR2(1) NOT NULL	Nature of Transaction 2
160	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
161	PACKSLIP_NO	Character(22)	VARCHAR2(22) NOT NULL	Packing Slip Number
162	DEFER_DT	Date(10)	DATE	Defer Date
163	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code
164	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type
165	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
166	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event Prompt Table: EE_AR_CODE1_VW
167	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services Default Value: BI_HDR.PHYSICAL_NATURE
168	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment Prompt Table: BI_VT_TREAT_VW
169	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
170	VAT_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Service Type 1=Freight Transport 2=Other 3=Electronics/Communication
171	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.
172	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
173	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
174	COUNTRY_LOC_BUYER	Character(3)	VARCHAR2(3) NOT NULL	Buyer's Location Country - May be either the VAT Entity or the Trading Partner Default Value: BI_HDR_VAT.COUNTRY_LOC_BUYER
175	STATE_LOC_BUYER	Character(6)	VARCHAR2(6) NOT NULL	Buyer's Location State - May be either the VAT Entity or the Trading Partner Default Value: BI_HDR_VAT.STATE_LOC_BUYER
176	COUNTRY_LOC_SELLER	Character(3)	VARCHAR2(3) NOT NULL	Seller's Location Country - May be either the VAT Entity or the Trading Partner Default Value: BI_HDR_VAT.COUNTRY_LOC_SELLER
177	STATE_LOC_SELLER	Character(6)	VARCHAR2(6) NOT NULL	Seller's Location State - May be either the VAT Entity or the Trading Partner Default Value: BI_HDR_VAT.STATE_LOC_SELLER
178	COUNTRY_VAT_SUPPLY	Character(3)	VARCHAR2(3) NOT NULL	VAT Place of Supply Country
179	STATE_VAT_SUPPLY	Character(6)	VARCHAR2(6) NOT NULL	VAT Place of Supply State
180	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed Default Value: BI_HDR_VAT.COUNTRY_VAT_PERFRM
181	STATE_VAT_PERFRM	Character(6)	VARCHAR2(6) NOT NULL	State Where Service Physically Performed Default Value: BI_HDR_VAT.STATE_VAT_PERFRM
182	STATE_SHIP_TO	Character(6)	VARCHAR2(6) NOT NULL	Ship To State Default Value: BI_HDR.STATE_SHIP_TO
183	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State Default Value: BI_HDR.STATE_SHIP_FROM
184	EXD_CUST_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Excise Customer Category Code
185	STX_CUST_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Customer Category Code
186	VAT_DFLT_DONE_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Defaulting Done N=Awaiting Defaulting X=Do not default Y=Defaulting Done
187	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: BI_MSTR_ITEM_VW
188	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity
189	EXD_INVOICE_NO	Character(10)	VARCHAR2(10) NOT NULL	Excise Invoice Number
190	EXD_INVOICE_LINE	Number(5,0)	INTEGER NOT NULL	Excise Invoice Line Number
191	ORG_SETID	Character(5)	VARCHAR2(5) NOT NULL	Organization SetID.
192	ORG_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization.
193	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes.
194	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. Default Value: N
195	STX_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Applicability. Default Value: N
196	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
197	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
198	STX_TAX_AUTH_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Authority Code
199	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only). Default Value: BI_HDR.COUNTRY_SHIP_TO
200	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only). Default Value: BI_HDR.COUNTRY_SHIP_FROM
201	EXD_ITM_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Excise Item Category Code
202	STX_ITM_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Item Category Code
203	EXS_SERV_TAX_FLG	Character(1)	VARCHAR2(1) NOT NULL	Service Tax Indicator N=Not Service Tax Y=Service Tax
204	STX_FORM_CD	Character(8)	VARCHAR2(8) NOT NULL	Form Code
205	FORM_DISTRIB_STAT	Character(1)	VARCHAR2(1) NOT NULL	Used for Sales Tax Forms tracking D=Distributed I=Ignore N=Not Distributed U=Undefined
206	EXD_ASSESS_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Assessable Value
207	EXD_UOM	Character(3)	VARCHAR2(3) NOT NULL	Excise Unit Of Measure
208	EXD_CONVERSION_RT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
209	EXD_USE_AV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Excise Use Av Flag
210	EXD_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Excise Tax Calculation Code Prompt Table: EXD_TAX_RATE_VW
211	EXD_TAX_RATE_SRC	Character(1)	VARCHAR2(1) NOT NULL	Excise Tax Rate Source 1=System Defined 2=Manually Entered
212	EXD_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Tax Amount
213	EXD_TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Duty in Base Currency
214	EXD_TAX_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Duty Amt In Rpt Curr
215	STX_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Tax Calculation Code Prompt Table: STX_TAX_RATE_VW
216	STX_TAX_RATE_SRC	Character(1)	VARCHAR2(1) NOT NULL	Tax Rate Source 1=System Defined 2=Manually Entered
217	STX_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
218	STX_TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	SALES TAX IN BASE CURR
219	STX_TAX_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	SALES TAX IN REPORT CURR
220	EXS_CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Excise Currency Reporting
221	BUSINESS_UNIT_AMTO	Character(5)	VARCHAR2(5) NOT NULL	Asset Business Unit To
222	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
223	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
224	COST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cost Type
225	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
226	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
227	STATE_VAT_DEFAULT	Character(6)	VARCHAR2(6) NOT NULL	VAT Defaulting State
228	LANG_DESCR_OVR	Character(3)	VARCHAR2(3) NOT NULL	Language of Descr Override
229	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
230	BUSINESS_UNIT_RF	Character(5)	VARCHAR2(5) NOT NULL	Field Services Business Unit
231	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
232	SOURCE_REF_NO	Character(35)	VARCHAR2(35) NOT NULL	Generic reference number
233	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.
234	CA_PGP_SEQ	Number(3,0)	SMALLINT NOT NULL	Progress Payment Sequence
235	SUM_TEMPLATE_ID	Character(16)	VARCHAR2(16) NOT NULL	Summarization Template ID
236	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.
237	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.
238	CUST_DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Deposit ID
239	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)
240	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)
241	USER_AMT1_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	User Amt 1
242	USER_AMT2_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	User Amt 2
243	USER_AMT1_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	User Amt 1
244	USER_AMT2_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	User Amt 2
245	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).
246	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).
247	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).
248	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).
249	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).
250	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).
251	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).
252	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).
253	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).
254	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).
255	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).
256	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
257	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
258	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.
259	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
260	PC_CF_CHANGE_FLG	Character(1)	VARCHAR2(1) NOT NULL	An indicator to flag whether the Project chartfields were updated on a billing line.
261	CREDIT_REASON	Character(10)	VARCHAR2(10) NOT NULL	Adjustment Reason
262	TEMP_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Temporary Invoice
263	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
264	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
265	CONTRACT_NUM_CA	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
266	PROJECT_ID_2	Character(15)	VARCHAR2(15) NOT NULL	Project
267	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
268	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System
269	LOC_DOC_ID	Character(30)	VARCHAR2(30) NOT NULL	Letter of Credit Document ID
270	FROM_DT	Date(10)	DATE	From Date