OMBI_INTFC_HTMP

#	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	HDR_FIELDS_KEY	Character(30)	VARCHAR2(30) NOT NULL	Header Fields Key
4	HDR_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Header Transaction Type CRC=Credit Card Transaction HAR=HDR AR Transaction MSC=Miscellaneous Bill Header Flds VAT=VAT Transaction
5	LOAD_STATUS_BI	Character(3)	VARCHAR2(3) NOT NULL	Billing Interface Load Status DON=Done (Complete) ERR=Error NEW=New RDY=Ready UPD=Updating
6	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment. A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time
7	VAT_CALC_GROSS_NET	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount. G=Calculate at Gross N=Calculate at Net
8	VAT_RECALC_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
9	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.
10	VAT_TREATMENT_SAL	Character(3)	VARCHAR2(3) NOT NULL	Describes the VAT Treatment that will be applied to this sales event. VAT treatment determines the accounting and processing that will be performed by the system. VAT treatments correspond to real world events. For example: domestic sale Distance EC Sale Export Sale. DDS=Domestic VAT - Distance Sale DOM=Domestic VAT EUS=Intra-EU Sale EUT=Intra-EU Sale Simplification EXP=Export OOS=Outside the Scope of VAT
11	VAT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type. N=None S=Suspended X=Exonerated
12	VAT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
13	VAT_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	" Rounding rule to be applied to VAT calculations. Options are 'Natural' D=Round Down N=Natural Round U=Round Up
14	VAT_DCLRTN_DT	Date(10)	DATE	"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "
15	VAT_DCLRTN_DT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Declaration Date Source A=Delivery Date - Ext Process D=Delivery Date - Txn Entry I=Invoice Date M=Manual Entry N=Not Applicable
16	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
17	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
18	VAT_RGSTRN_BUYER	Character(20)	VARCHAR2(20) NOT NULL	Specifies a customers VAT Registration ID for a particular country.
19	VAT_RGSTRN_SELLER	Character(20)	VARCHAR2(20) NOT NULL	Seller's VAT Registration
20	PROVINCE	Character(1)	VARCHAR2(1) NOT NULL	Province
21	DFLTS_APPLIED	Character(1)	VARCHAR2(1) NOT NULL	VAT Defaults Applied Flag N=No Y=Yes
22	CR_CARD_NBR	Character(44)	VARCHAR2(44) NOT NULL	"See OM
23	CR_CARD_TYPE	Character(3)	VARCHAR2(3) NOT NULL	"See OM 01=Visa 02=MasterCard 03=Diners Club/Carte Blanche 04=AMEX 05=Discover 06=EnRoute
24	CR_CARD_VENDOR	Character(16)	VARCHAR2(16) NOT NULL	Processor Name
25	CC_PROF_TOKEN	Character(44)	VARCHAR2(44) NOT NULL	Profile Token ID
26	CR_CARD_LNAME	Character(40)	VARCHAR2(40) NOT NULL	Credit Card Last Name
27	CR_CARD_FNAME	Character(40)	VARCHAR2(40) NOT NULL	Credit Card First Name
28	CR_CARD_EXPMO	Character(2)	VARCHAR2(2) NOT NULL	Card Expiration Month 01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December
29	CR_CARD_EXPYR	Character(4)	VARCHAR2(4) NOT NULL	Card Expiration Year 2011=2011 2012=2012 2013=2013 2014=2014 2015=2015 2016=2016 2017=2017 2018=2018 2019=2019 2020=2020
30	CR_CARD_DIGITS	Character(4)	VARCHAR2(4) NOT NULL	Card Number's Last Four Digits
31	CR_CARD_RQST_ID	Character(30)	VARCHAR2(30) NOT NULL	Credit Card Request ID
32	CR_CARD_AUTH_STAT	Character(1)	VARCHAR2(1) NOT NULL	Credit Card Auth Status A=Authorized B=Billed C=Credited D=Denied E=Validation Errors F=Auth Reversal G=Validated H=Auth Reversal Denied J=Reauthorize K=No Action L=Credit Card Not In Group M=Manually Approved/Settled N=Change to Terms P=Authorized and Billed R=Processing T=Cancel Order U=Unprocessed/Retry V=Pending Approval W=Deleted after Settlement X=Deleted Y=Cancelled Z=Zero Payment for Maintenance
33	CR_CARD_AUTH_CD	Character(10)	VARCHAR2(10) NOT NULL	Credit Card Auth Code
34	CR_CARD_A_DTTM	Character(20)	VARCHAR2(20) NOT NULL	Cr Card Auth Date/Time
35	CR_CARD_AUTH_DTTM	DateTime(26)	TIMESTAMP	Credit Card Auth Datetime
36	CR_CARD_MSG1	Character(50)	VARCHAR2(50) NOT NULL	Credit Card Message 1
37	CR_CARD_MSG2	Character(50)	VARCHAR2(50) NOT NULL	Credit Card Message 2
38	CR_CARD_MSG3	Character(50)	VARCHAR2(50) NOT NULL	Credit Card Message 3
39	NAME_EXACT	Character(40)	VARCHAR2(40) NOT NULL	Exact Name on Card
40	EXPIRATION_DT	Date(10)	DATE	Expiration Date
41	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
42	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
43	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
44	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
45	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
46	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
47	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
48	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
49	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
50	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
51	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
52	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
53	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
54	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
55	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
56	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
57	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
58	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit
59	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
60	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
61	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
62	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance