OMBCK_END_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AUDIT_DTTM	DateTime(26)	TIMESTAMP	Audit DtTm
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	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
7	ORDER_NO_TO	Character(10)	VARCHAR2(10) NOT NULL	To Order No
8	ORDER_DATE	Date(10)	DATE	Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
9	REPRICE_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Reprice Only
10	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
11	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
12	OM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	OM Work Flag
13	SETID_CUSTOMER	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
14	SETID_CUST_GRP	Character(5)	VARCHAR2(5) NOT NULL	Customer Group SetID
15	SETID_CUST_SHIPTO	Character(5)	VARCHAR2(5) NOT NULL	Shipto Cust SetID
16	SETID_FRT_TERMS	Character(5)	VARCHAR2(5) NOT NULL	Freight Terms SETID
17	SETID_PAYTRMS	Character(5)	VARCHAR2(5) NOT NULL	Payment Terms Setid
18	SETID_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
19	SETID_PROD_GRP	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
20	SETID_TAX_CD	Character(5)	VARCHAR2(5) NOT NULL	Setid Tax Code
21	QTY_SCHEDULED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Scheduled
22	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
23	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
24	SEARCH_STOPPED	Character(1)	VARCHAR2(1) NOT NULL	Search Stopped Y/N Table Edit
25	DISCOUNT_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Discount Percentage
26	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
27	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
28	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
29	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
30	NET_EXTENDED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Extended Amt
31	TAX_VENDOR	Character(1)	VARCHAR2(1) NOT NULL	Tax Provider A=Taxware N=None V=Vertex
32	TAX_COMPANY	Character(5)	VARCHAR2(5) NOT NULL	Company for Tax Suppliers
33	TAX_DIVISION	Character(5)	VARCHAR2(5) NOT NULL	Division for Tax Suppliers
34	STORE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Store Location
35	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
36	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
37	ORIGINAL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Original Invoice
38	INVOICE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Invoice Type ACR=Credit Bill ADJ=Adjustment Only bill ARB=Rebill Bill PRF=Pro Forma Invoice RAD=Regular bill with adjustments REG=Regular Bill
39	INVOICE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Invoice Action C=Reprint I=Invoice P=Pro Forma
40	INVOICE_DT	Date(10)	DATE	Invoice Date
41	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)
42	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
43	TAX_JOB_NUM	Character(10)	VARCHAR2(10) NOT NULL	Job Number
44	TAX_USER_AREA	Character(25)	VARCHAR2(25) NOT NULL	Used for tax calculation by tax vendor.
45	ADDR_OVRD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Address Override Level D=Demand Line H=Header L=Line S=Schedule
46	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
47	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
48	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
49	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
50	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
51	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
52	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit
53	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
54	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
55	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
56	TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount
57	TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount (base)
58	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
59	TAX_PCT	Number(7,4)	DECIMAL(6,4) NOT NULL	Tax Percent
60	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
61	TAX_EXEMPT_RC	Character(2)	VARCHAR2(2) NOT NULL	Exempt Reason Code 01=Certificat
62	TAX_EXEMPT_CERT	Character(30)	VARCHAR2(30) NOT NULL	Exemption Certificate
63	TAX_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type 1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return
64	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
65	TAX_VAT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Include VAT N=No Y=Yes
66	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.
67	VAT_AMT_BASE	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. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.
68	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.
69	VAT_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Basis Amt in Base Curr
70	VAT_DFLT_WRK	Character(2)	VARCHAR2(2) NOT NULL	VAT Defaulting Work
71	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
72	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.
73	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.
74	RETURN_CD	Character(1)	VARCHAR2(1) NOT NULL	Return Code 0=Return OK 1=Return error
75	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
76	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
77	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
78	CURRENCY_CD_XEU	Character(3)	VARCHAR2(3) NOT NULL	Euro Currency
79	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
80	MULTICURRENCY	Character(1)	VARCHAR2(1) NOT NULL	Multi-Currency
81	CC_AMOUNT	Number(27,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
82	CR_CARD_AMT_BASE	Number(27,3)	DECIMAL(26,3) NOT NULL	Credit Card Base Amount
83	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount against which the VAT is applicable.
84	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
85	EXCEPTIONS_AVP	Character(1)	VARCHAR2(1) NOT NULL	Using STEP
86	TAX_RC_MATCHING	Character(1)	VARCHAR2(1) NOT NULL	Reason Code Matching 1=Only Exact Reason Code Match 2=Use Default Record
87	TAX_CERT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Certificate Level 1=Individual Certificate Levels 2=State Level Only
88	EXCEPTIONS_VERTEX	Character(1)	VARCHAR2(1) NOT NULL	Using TDM
89	VER_VERTEX	Character(1)	VARCHAR2(1) NOT NULL	Version I=ISAM
90	SERVER_VERTEX	Character(20)	VARCHAR2(20) NOT NULL	Server Name
91	USER_VERTEX	Character(10)	VARCHAR2(10) NOT NULL	User Name
92	PSWD_VERTEX	Character(254)	VARCHAR2(254) NOT NULL	11/04 - Increased to 44 bytes to allow for encryption. Vertex passwords must be 6-16 characters.
93	ORD_ACCEPT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Acceptance
94	ORD_ORIGIN_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Origin
95	SHIP_FROM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Ship From Location
96	FREIGHT_CHARGE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge
97	FREIGHT_CHARGE_BSE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge (base)