TD_INTFC_BI_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
2	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
3	TRANS_TYPE_BI	Character(4)	VARCHAR2(4) NOT NULL	Transaction Type AE=Accounting Entry AHDR=Adjustment Header DDS=Deferred Discount/Surcharge DS=Discount/Surcharge EXSD=Indian Excise/Sales Tax Detail LINE=Chargeable Line NOTE=Note/Comment TAX=Sales/Use Tax Detail
4	TRANS_TYPE_BI_SEQ	Number(3,0)	SMALLINT NOT NULL	Transaction Type Seq 010=Invalid Transaction Type 020=Too many charge lines 030=No charge line for activity 040=Invalid Business Unit 050=Invalid bill-to customer 060=Invalid Billing Address 070=Invalid bill-to contact 080=No Bill Source provided 090=Invalid Bill Source 100=Invalid Bill Type 110=Invalid Bill Cycle 120=Invalid Payment Term 130=Invalid Tax Code 140=Invalid Unit of measure 200=Invalid Standard Note Code 210=No Note Code or Text exists 300=Both Amount & Percentage are 0
5	HDR_FIELDS_KEY	Character(30)	VARCHAR2(30) NOT NULL	Header Fields Key
6	HDR_FIELDS_BILL_BY	Character(1)	VARCHAR2(1) NOT NULL	Header Fields Bill By
7	ADJ_TRANS_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Adjustment Transaction Type
8	CREATE_NEW_BILL	Character(1)	VARCHAR2(1) NOT NULL	Create New Bill Y/N Table Edit Default Value: N
9	TMP_BILL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Temporary Bill Y/N Table Edit Default Value: N
10	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: ENTRY_TYPE_TBL
11	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: ENTRY_REASN_TBL
12	LOAD_STATUS_BI	Character(3)	VARCHAR2(3) NOT NULL	Billing Interface Load Status DON=Done (Complete) ERR=Error NEW=New RDY=Ready UPD=Updating
13	ERROR_STATUS_BI	Character(4)	VARCHAR2(4) NOT NULL	Error Status
14	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_BI_NONVW
15	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BU_GL_NONVW
16	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: BI_BILL_TO_VW
17	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: BI_CUST_ADDR_VW
18	BILL_TO_COPIES	Number(3,0)	SMALLINT NOT NULL	Number of Copies Default Value: 1
19	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number Prompt Table: CUST_CNCT_BI_VW
20	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
21	INTERUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit N=No Y=Yes Y/N Table Edit Default Value: N
22	BUSINESS_UNIT_TO	Character(5)	VARCHAR2(5) NOT NULL	04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW
23	DIRECT_INVOICING	Character(1)	VARCHAR2(1) NOT NULL	Direct Invoicing Y/N Table Edit Default Value: N
24	RANGE_SELECTION_ID	Character(30)	VARCHAR2(30) NOT NULL	Range Selection ID
25	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source Prompt Table: BI_SRC_EF_VW
26	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier Prompt Table: BI_TYPE_EF_VW
27	BILL_CYCLE_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Cycle Identifier Prompt Table: BI_CYCLE_VW
28	BILL_BY_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill By Identifier Prompt Table: BI_BILL_BY
29	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
30	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. Prompt Table: AR_TRMS_VW
31	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_BI_BR_VW
32	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank Prompt Table: BANK_BI_R_VW
33	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
34	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. "
35	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
36	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
37	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
38	CUR_RT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Exchange Rate Source T=Use Exchange Rate Tables U=User Specified
39	INVOICE_DT	Date(10)	DATE	Invoice Date
40	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
41	ACCRUE_UNBILLED	Character(1)	VARCHAR2(1) NOT NULL	Accrue Bills of This Level Y/N Table Edit
42	TARGET_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Target Invoice
43	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
44	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. Prompt Table: BI_DOC_TYPE_VW
45	CONSOL_SETID	Character(5)	VARCHAR2(5) NOT NULL	Consolidation Customer SetID Prompt Table: SP_SETID_NONVW
46	CONSOL_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Consolidation Customer ID Prompt Table: CUST_CONSOL_VW
47	CONSOL_KEY	Character(22)	VARCHAR2(22) NOT NULL	Invoice Consolidation Key
48	INVOICE_TO_ADJ	Character(22)	VARCHAR2(22) NOT NULL	Invoice To Adjust Prompt Table: BI_HDR_NOADH_VW
49	ADJ_DELTA_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Adjustment Delta Action ADD=Add DEL=Delete RPL=Replace
50	LINE_SEQ_TO_ADJ	Number(5,0)	INTEGER NOT NULL	Line Sequence To Adjust
51	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
52	LINE_DST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Revenue Sequence Number
53	LINE_DFR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Deferred Sequence Number
54	LINE_UAR_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Unbilled AR Sequence Number
55	LAST_NOTE_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Last note sequence number
56	NOTES_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Notes Sequence Num
57	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
58	IDENTIFIER	Character(18)	VARCHAR2(18) NOT NULL	Identifier
59	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
60	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
61	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
62	UNIT_AMT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Unit Price
63	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
64	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code
65	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type
66	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code Prompt Table: TAX_SU_HDR_VW
67	TAX_EXEMPT_CERT	Character(30)	VARCHAR2(30) NOT NULL	Exemption Certificate Prompt Table: CUST_EXEMPT
68	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit
69	TAX_EXEMPT_RC	Character(2)	VARCHAR2(2) NOT NULL	Exempt Reason Code 01=Certificat
70	TAX_JOB_NUM	Character(10)	VARCHAR2(10) NOT NULL	Job Number
71	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
72	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 Set Control Field: BUSINESS_UNIT
73	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 Set Control Field: BUSINESS_UNIT
74	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
75	VAT_PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
76	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID Prompt Table: SP_SETID_NONVW
77	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
78	SHIP_FROM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Ship From Location Prompt Table: LOCATION_TBL
79	ORD_ACCEPT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Acceptance Prompt Table: LOCATION_TBL
80	ORD_ORIGIN_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Origin Prompt Table: LOCATION_TBL
81	STORE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Store Location
82	TITLE_PASSAGE	Character(1)	VARCHAR2(1) NOT NULL	Title Passage B=Buyer's Destination-Ship To I=Intermediate Consignee S=Seller's Origination-Ship From
83	TAX_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Tax Group
84	TAX_USER_AREA	Character(25)	VARCHAR2(25) NOT NULL	Used for tax calculation by tax vendor.
85	TAX_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type 1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return
86	TAX_TRANS_SUB_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Sub Type 1=Property 2=Freight 3=Service 4=Rental or Lease 5=Expense 6=Misc N=None
87	NET_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amt
88	GROSS_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Extended
89	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
90	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
91	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit Prompt Table: SP_BU_OM_NONVW
92	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 Prompt Table: BI_ORD_HDR_VW
93	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
94	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
95	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
96	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
97	BUSINESS_UNIT_RMA	Character(5)	VARCHAR2(5) NOT NULL	RMA Business Unit Prompt Table: SP_BU_OM_NONVW
98	RMA_ID	Character(10)	VARCHAR2(10) NOT NULL	RMA Number Prompt Table: BI_RMA_HDR_VW
99	RMA_LINE_NBR	Number(5,0)	INTEGER NOT NULL	RMA Line Number
100	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: BI_PROD_ITEM_VW
101	ORDER_DATE	Date(10)	DATE	Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
102	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
103	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.
104	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
105	CONTRACT_DT	Date(10)	DATE	Contract Date
106	CONTRACT_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Contract Type
107	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
108	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
109	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
110	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only). Prompt Table: COUNTRY_TBL
111	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only). Prompt Table: COUNTRY_TBL
112	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer Prompt Table: BI_SHIP_TO_VW
113	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num Prompt Table: BI_SHP_ADDR_VW
114	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID
115	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD
116	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
117	SHIP_DATE	Date(10)	DATE	Item Shipping Date
118	SHIP_TIME	Time(15)	TIMESTAMP	Ship Time
119	PACKSLIP_NO	Character(22)	VARCHAR2(22) NOT NULL	Packing Slip Number
120	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System
121	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
122	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer Prompt Table: BI_SOLD_TO_VW
123	SOLD_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Sold To Address Sequence Num Prompt Table: BI_SLD_ADDR_VW
124	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: SP_BU_PC_NONVW
125	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
126	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID
127	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
128	BPLAN_LN_NBR	Number(3,0)	SMALLINT NOT NULL	Bill Plan Line Number
129	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.
130	XREF_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Cross Reference Sequence No.
131	CONTRACT_PPD_SEQ	Number(5,0)	INTEGER NOT NULL	Prepaid Add Sequence
132	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: PROJ_ANTYPE_FS
133	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
134	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS
135	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: PROJ_RESCAT_FS
136	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: PROJ_SUBCAT_FS
137	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACT_FS
138	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
139	DIST_CFG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Distribution Configuration
140	PRODUCT_KIT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product Kit Number
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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
144	START_DT	Date(10)	DATE	Start Date
145	END_DT	Date(10)	DATE	End Date
146	FROM_DT	Date(10)	DATE	From Date
147	TO_DT	Date(10)	DATE	To Date
148	SERVICE_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Customer ID Prompt Table: CUSTOMER
149	SERVICE_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Service Address Num Prompt Table: BI_SVC_ADDR_VW
150	NOTE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Note Type Prompt Table: NOTE_TYPE_EF_VW
151	STD_NOTE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Standard Note Flag N=No Y=Yes
152	INTERNAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Internal Only Flag N=No Y=Yes
153	HDR_OR_LINE_NOTE	Character(1)	VARCHAR2(1) NOT NULL	Header or Line Note H=Header Note L=Line Note
154	AR_LVL	Character(1)	VARCHAR2(1) NOT NULL	AR Level H=Header is AR Open Item L=Bill Line is AR Open Item N=No AR Open Items
155	AR_DST_OPT	Character(1)	VARCHAR2(1) NOT NULL	AR Distribution Option H=Use Header for Distribution L=Use Line for Distribution
156	GL_LVL	Character(1)	VARCHAR2(1) NOT NULL	GL Level A=AR Creates GL Acct Entries B=BI Creates GL Acct Entries N=No GL Accounting Entries
157	ENABLE_DFR_REV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enable Deferred Revenues
158	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist Prompt Table: BI_SPECIALST_VW
159	BILLING_FREQUENCY	Character(3)	VARCHAR2(3) NOT NULL	Billing Frequency INS=Installment ONC=Once REC=Recurring
160	BILL_INQUIRY_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Bill Inquiry Phone Prompt Table: BI_INQPHONE_VW
161	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer. Prompt Table: TEAM_MEMBER_VW Set Control Field: BUSINESS_UNIT
162	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments. Prompt Table: COLLECTOR_TBL
163	CR_ANALYST	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer. Prompt Table: CR_ANALYST_TBL
164	INVOICE_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Form Prompt Table: BI_IVC_FORM_VW
165	STD_NOTE_CD	Character(10)	VARCHAR2(10) NOT NULL	Standard Note Code Prompt Table: BI_STD_NOTE_VW
166	TOT_LINE_DST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Dist Amount
167	TOT_LINE_DST_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total Revenue Percent
168	TOT_LINE_DFR_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total Deferred Percent
169	TOT_LINE_DFR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Deferred Amount
170	TOT_LINE_UAR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Line Unbilled AR Amount
171	TOT_LINE_UAR_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Total Unbilled AR Percent
172	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
173	CHARGE_FROM_DT	Date(10)	DATE	From Date for line charges
174	CHARGE_TO_DT	Date(10)	DATE	Through date for charges
175	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. Prompt Table: SUBCUST_Q1_TBL
176	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. Prompt Table: SUBCUST_Q2_TBL
177	TOT_DISCOUNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amt
178	TOT_SURCHARGE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Surcharge Amt
179	ACCUMULATE	Character(1)	VARCHAR2(1) NOT NULL	Include in Cumulative Balance Y/N Table Edit
180	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
181	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
182	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
183	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.