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