FO_PO_AET (SQL Table)	Index Back
AET for CA_COMMIT_PO

FO_PO_AET

(SQL Table)

AET for CA_COMMIT_PO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

4 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

6 CA_PO_ID Character(10) VARCHAR2(10) NOT NULL Internal PO ID

7 EXTENSION_NBR Signed Number(4,0) DECIMAL(3) NOT NULL Extension Number

8 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

9 REMAINING_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Remaining Amount

10 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

11 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

12 ENCUMBRANCE_PCT Number(6,3) DECIMAL(5,3) NOT NULL Encumbrance %

13 TRANS_DT Date(10) DATE Transaction Date

14 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

15 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID

16 NET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The resulting net amount related to settlement cash flows subject to counterparty netting agreements.

17 ERROR_STATUS Character(2) VARCHAR2(2) NOT NULL Error Status
1=None
2=Unbalanced
3=CF Combo Error
4=No Exchange Rate
5=Acct Not Specified
6=IU Processor Error
7=Document Sequencing Error

18 TMP_FLD Character(1) VARCHAR2(1) NOT NULL Field for holding temp data

19 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

20 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

21 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

22 PO_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Used in Virtual Approver to store the various rule amounts that go on each approval step

23 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

24 CA_PO_STATUS Character(1) VARCHAR2(1) NOT NULL PO Status
A=Active
H=Exhausted
N=New
P=Expired

25 EXHAUSTION_DATE Date(10) DATE Exhaustion Date

26 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

27 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

28 PCCA_RUN Character(1) VARCHAR2(1) NOT NULL Flag used when kicking off the Billing/PCCA interface program BIPCC000.
A=All Business Units
S=Single Business Unit

29 COMMITTED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Committed Assets

30 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount

31 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

32 INVOICE_DT Date(10) DATE Invoice Date

33 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line

34 DESCR200 Character(254) VARCHAR2(254) NOT NULL Long Description

35 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

36 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number

37 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

38 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

39 ORIG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Original Process Instance

40 TOTAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Amount

41 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.

42 DTTM_STAMP 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
3	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
4	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	CA_PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Internal PO ID
7	EXTENSION_NBR	Signed Number(4,0)	DECIMAL(3) NOT NULL	Extension Number
8	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
9	REMAINING_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Remaining Amount
10	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
11	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
12	ENCUMBRANCE_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	Encumbrance %
13	TRANS_DT	Date(10)	DATE	Transaction Date
14	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
15	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
16	NET_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
17	ERROR_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Error Status 1=None 2=Unbalanced 3=CF Combo Error 4=No Exchange Rate 5=Acct Not Specified 6=IU Processor Error 7=Document Sequencing Error
18	TMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Field for holding temp data
19	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID
20	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
21	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
22	PO_AMT1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used in Virtual Approver to store the various rule amounts that go on each approval step
23	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
24	CA_PO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PO Status A=Active H=Exhausted N=New P=Expired
25	EXHAUSTION_DATE	Date(10)	DATE	Exhaustion Date
26	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
27	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
28	PCCA_RUN	Character(1)	VARCHAR2(1) NOT NULL	Flag used when kicking off the Billing/PCCA interface program BIPCC000. A=All Business Units S=Single Business Unit
29	COMMITTED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Committed Assets
30	TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Amount
31	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
32	INVOICE_DT	Date(10)	DATE	Invoice Date
33	INVOICE_LINE	Number(5,0)	INTEGER NOT NULL	Invoice Line
34	DESCR200	Character(254)	VARCHAR2(254) NOT NULL	Long Description
35	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
36	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
37	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
38	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
39	ORIG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Original Process Instance
40	TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
41	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.
42	DTTM_STAMP	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.