AP_EXT_LINE_VW (SQL View)	Index Back
AP Extract Line View This view contains the output of Accounts Payable extract programs.

AP_EXT_LINE_VW

(SQL View)

AP Extract Line View

This view contains the output of Accounts Payable extract programs.

SELECT A.SETID , A.VENDOR_ID , A.INVOICE_ID , A.SEQUENCENO , A.SEQNO , A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.BENEFIT_RCD_NBR , A.PLAN_TYPE , A.BENEFIT_PLAN , A.DEDCD , A.DED_CLASS , A.DED_SLSTX_CLASS , A.GARN_PRIORITY , A.GARNID , A.EMPLID , A.BOND_ID , A.BOND_OWNER_ID , A.BOND_OTH_REG_TYPE , A.BOND_OTH_REG_ID , A.BOND_LOG_SEQ , A.STATE , A.LOCALITY , A.TAX_CLASS , A.TAX_CLASS_CAN , A.TAX_GRP_TYPE , A.TAX_TYPE_CAN , A.PROVINCE , A.EMPL_RCD , A.AMOUNT , A.PAY_MODE , A.SEPARATE_AP_PAYMNT , A.EXTRACT_TYPE_LINE , A.ACCOUNT , A.DEPTID , A.PROJECT_ID , A.PRODUCT , A.FUND_CODE , A.PROGRAM_CODE , A.CLASS_FLD , A.AFFILIATE , A.OPERATING_UNIT , A.ALTACCT , A.BUDGET_REF , A.CHARTFIELD1 , A.CHARTFIELD2 , A.CHARTFIELD3 , A.AFFILIATE_INTRA1 , A.AFFILIATE_INTRA2 , A.PROCESS_INSTANCE , A.SEND_TO_AP , B.NAME FROM PS_AP_EXTRACT_LINE A , PS_PERSONAL_DATA B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number

4 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number

5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

7 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

8 PAY_END_DT Date(10) DATE Pay Period End Date

9 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

10 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #

11 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #

12 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.

13 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.

14 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

15 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

16 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

17 DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
A=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit

18 DED_SLSTX_CLASS Character(1) VARCHAR2(1) NOT NULL Sales Tax Type
B=None
G=Goods and Services Tax
H=Harmonized Sales Tax
I=Provincial Sales Tax Insurance
P=Provincial Sales Tax
Q=QC Prov Sales Tax Insurance
S=QC Provincial Sales Tax
T=Provincial Premium Tax
U=QC Provincial Premium Tax

19 GARN_PRIORITY Number(3,0) SMALLINT NOT NULL Garnish Priority

20 GARNID Character(6) VARCHAR2(6) NOT NULL Garnish ID

21 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

22 BOND_ID Character(3) VARCHAR2(3) NOT NULL Savings Bond ID

23 BOND_OWNER_ID Character(2) VARCHAR2(2) NOT NULL Bond Owner ID

24 BOND_OTH_REG_TYPE Character(1) VARCHAR2(1) NOT NULL Bond Other Registrant Type
B=Beneficiary
C=Co-Owner
N=No Other Bond Registrant

25 BOND_OTH_REG_ID Character(2) VARCHAR2(2) NOT NULL Bond Other Registrant ID

26 BOND_LOG_SEQ Number(3,0) SMALLINT NOT NULL Bond Activity Seq #

27 STATE Character(6) VARCHAR2(6) NOT NULL State

28 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

29 TAX_CLASS Character(1) VARCHAR2(1) NOT NULL Tax Balance Class

30 TAX_CLASS_CAN Character(3) VARCHAR2(3) NOT NULL Canadian Tax Class
ALL=Total Gross
CBT=Canadian Bonus Tax
CIT=Canadian Income Tax (T4)
CPA=Pension Adjustment
CPP=Canada Pension Plan Employee
CPR=Canada Pension Plan Employer
EIE=Employment Insurance Employee
EIR=Employment Insurance Employer
HTX=Provincial Health Tax
PYT=Payroll Tax
QBT=Quebec Bonus Tax
QCD=Quebec Tax Deduction
QIE=Quebec Parental Plan Employee
QIR=Quebec Parental Plan Employer
QIT=Quebec Income Tax (RL-1)
QPP=Quebec Pension Plan Employee
QPR=Quebec Pension Plan Employer
RV2=Quebec Income Tax (RL-2)
T4A=Canadian Income Tax (T4A)
TRV=True RL
TT4=True T4

31 TAX_GRP_TYPE Character(10) VARCHAR2(10) NOT NULL Tax Type

32 TAX_TYPE_CAN Character(4) VARCHAR2(4) NOT NULL Tax Type

33 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

34 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

35 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.

36 PAY_MODE Character(1) VARCHAR2(1) NOT NULL Pay Mode
B=Pay when Bond Price met
C=Pay when Collection Completed
D=Pay as Deducted
S=Pay at Specified Date

37 SEPARATE_AP_PAYMNT Character(1) VARCHAR2(1) NOT NULL Separate AP Payment
Y/N Table Edit

38 EXTRACT_TYPE_LINE Character(1) VARCHAR2(1) NOT NULL Extract Type
B=Benefit
D=Deduction
G=Garnishment
T=Tax

39 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

40 DEPTID_CF Character(10) VARCHAR2(10) NOT NULL Department

41 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant

42 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product

43 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

44 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code

45 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.

46 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field

47 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit

48 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

49 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield

50 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1

51 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

52 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

53 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

54 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

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

56 SEND_TO_AP Character(1) VARCHAR2(1) NOT NULL Send to AP
Y/N Table Edit
Default Value: Y

57 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	INVOICE_ID	Character(22)	VARCHAR2(22) NOT NULL	Invoice Number
4	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
5	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
7	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
8	PAY_END_DT	Date(10)	DATE	Pay Period End Date
9	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
10	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page #
11	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
12	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate check number.
13	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
14	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
15	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
16	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
17	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
18	DED_SLSTX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Type B=None G=Goods and Services Tax H=Harmonized Sales Tax I=Provincial Sales Tax Insurance P=Provincial Sales Tax Q=QC Prov Sales Tax Insurance S=QC Provincial Sales Tax T=Provincial Premium Tax U=QC Provincial Premium Tax
19	GARN_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Garnish Priority
20	GARNID	Character(6)	VARCHAR2(6) NOT NULL	Garnish ID
21	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
22	BOND_ID	Character(3)	VARCHAR2(3) NOT NULL	Savings Bond ID
23	BOND_OWNER_ID	Character(2)	VARCHAR2(2) NOT NULL	Bond Owner ID
24	BOND_OTH_REG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bond Other Registrant Type B=Beneficiary C=Co-Owner N=No Other Bond Registrant
25	BOND_OTH_REG_ID	Character(2)	VARCHAR2(2) NOT NULL	Bond Other Registrant ID
26	BOND_LOG_SEQ	Number(3,0)	SMALLINT NOT NULL	Bond Activity Seq #
27	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
28	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
29	TAX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Tax Balance Class
30	TAX_CLASS_CAN	Character(3)	VARCHAR2(3) NOT NULL	Canadian Tax Class ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer EIE=Employment Insurance Employee EIR=Employment Insurance Employer HTX=Provincial Health Tax PYT=Payroll Tax QBT=Quebec Bonus Tax QCD=Quebec Tax Deduction QIE=Quebec Parental Plan Employee QIR=Quebec Parental Plan Employer QIT=Quebec Income Tax (RL-1) QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4
31	TAX_GRP_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Tax Type
32	TAX_TYPE_CAN	Character(4)	VARCHAR2(4) NOT NULL	Tax Type
33	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
34	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
35	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
36	PAY_MODE	Character(1)	VARCHAR2(1) NOT NULL	Pay Mode B=Pay when Bond Price met C=Pay when Collection Completed D=Pay as Deducted S=Pay at Specified Date
37	SEPARATE_AP_PAYMNT	Character(1)	VARCHAR2(1) NOT NULL	Separate AP Payment Y/N Table Edit
38	EXTRACT_TYPE_LINE	Character(1)	VARCHAR2(1) NOT NULL	Extract Type B=Benefit D=Deduction G=Garnishment T=Tax
39	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
40	DEPTID_CF	Character(10)	VARCHAR2(10) NOT NULL	Department
41	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
42	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
43	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
44	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code
45	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field.
46	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Public Sector Financials Chart Field
47	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit
48	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
49	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Chartfield
50	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield number 1
51	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
52	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
53	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
54	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
55	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
56	SEND_TO_AP	Character(1)	VARCHAR2(1) NOT NULL	Send to AP Y/N Table Edit Default Value: Y
57	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name