GP_ACC_LINE_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
2	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
3	ACCOUNTING_DT	Date(10)	DATE	Accounting Date
4	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Accounting Period
5	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
8	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
9	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status D=Distributed G=Generated H=Hold I=Ignored M=Modified N=None
10	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	GL Journal ID
11	JOURNAL_DATE	Date(10)	DATE	Journal Date
12	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	GL Journal Line Number
13	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
14	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
15	LINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Journal Line Description
16	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
17	MONETARY_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Monetary Amount
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	FOREIGN_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Foreign Amount
20	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
21	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.
22	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
23	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
24	PIN_CHART1_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
25	PIN_CHART2_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
26	PIN_CHART3_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value`
27	PIN_CHART4_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
28	PIN_CHART5_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
29	PIN_CHART6_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
30	PIN_CHART7_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
31	PIN_CHART8_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
32	PIN_CHART9_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
33	PIN_CHART10_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
34	PIN_CHART11_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
35	PIN_CHART12_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
36	PIN_CHART13_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
37	PIN_CHART14_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
38	PIN_CHART15_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
39	PIN_CHART16_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
40	PIN_CHART17_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
41	PIN_CHART18_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
42	PIN_CHART19_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
43	PIN_CHART20_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
44	PIN_CHART21_VAL	Character(15)	VARCHAR2(15) NOT NULL	pin chart field value
45	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
46	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.