ITEM_ACT_TEO2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
5	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
6	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
7	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.
8	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""."
9	ENTRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the monetary amount of a pending item transaction such as invoice or credit memo.
10	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
11	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
12	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
13	ASOF_DT	Date(10)	DATE	As of Date
14	DOCUMENT	Character(30)	VARCHAR2(30) NOT NULL	Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
15	DOCUMENT_LINE	Number(6,0)	INTEGER NOT NULL	Specifies the line number of a Document ID used as a reference on a Receivables item.
16	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
17	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
18	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
19	DRAFT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.
20	DRAFT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.
21	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
22	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
23	GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
24	HIST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	History Status N=No T=Transfer Y=Yes
25	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.
26	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.
27	SUBCUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SubCustomer History Status
28	ENTRY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency associated with the monetary amount of a pending item.
29	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
30	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
31	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
32	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
33	PAYMENT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
34	PYMT_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of exchange rate to be used when the currency of a customer payment is converted to the base currency of a business unit. The exchange rate type is also called the market rate type. Examples are spot rate current rate and official rate.
35	PYMT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_ RATE_DIV. Refer to documentation on the Triangulation Process for the exact calculation.
36	PYMT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_RATE_MULT. Refer to documentation on the Triangulation Process for the exact calculation.
37	ENTRY_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the monetary amount of a pending item transaction such as invoice or credit memo in the base currency of the business unit.
38	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
39	REAL_GAIN_LOSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the monetary amount of realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
40	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
41	ORIGIN_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the source or method of entry for a pending item group.
42	PAYMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifies a customer payment. This is usually a check number but may be some other identifying number.
43	GROUP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
44	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
45	SENT_TO_AP	Character(1)	VARCHAR2(1) NOT NULL	Sent to AP
46	CONSOL_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Billing business unit associated with a consolidated bill.
47	CONSOL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Specifies the invoice identifier associated with a consolidated bill.
48	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.
49	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.
50	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.
51	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
52	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.
53	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
54	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
55	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
56	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
57	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
58	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
59	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
60	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
61	DD_BU	Character(5)	VARCHAR2(5) NOT NULL	Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process.
62	DD_ID	Character(15)	VARCHAR2(15) NOT NULL	Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
63	POSTED_PI	Number(10,0)	DECIMAL(10) NOT NULL	Last Post Process Instance
64	ARRE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process status indicator for AR Commitment Control B=Processed by Billing C=Corrected online E=Unknown Error M=Unable dist to multi rev lines N=No effect on revenue estimate O=Transfered out of Bus Unit P=Processed successfully R=No item rev lines S=Skip process T=No transfer 'from' item found U=No revenue lines X=Error exists in prior activity
65	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
66	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)
67	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)
68	USER_AMT3	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)
69	USER_AMT4	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)
70	USER_AMT5	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)
71	USER_AMT6	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)
72	USER_AMT7	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)
73	USER_AMT8	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)
74	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).
75	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).
76	USER_DT3	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).
77	USER_DT4	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).
78	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).
79	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).
80	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).
81	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).
82	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).
83	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).
84	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).
85	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).
86	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).
87	USER10	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).
88	ST_ID_NUM	Number(8,0)	INTEGER NOT NULL	Statement Number
89	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
90	UNPOST_REASON	Character(10)	VARCHAR2(10) NOT NULL	Reason code for Unposted groups. For informational purposes.
91	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
92	WS_REASON	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
93	SUB_GROUP_ID	Number(6,0)	INTEGER NOT NULL	Sub Group ID
94	SENT_TO_PURCHASING	Character(1)	VARCHAR2(1) NOT NULL	Sent to Purchasing Default Value: N
95	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
96	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
97	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
98	SUBROG_CASE_NUM	Character(30)	VARCHAR2(30) NOT NULL	Subrogation case number used for Insurance
99	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location