PAY_CTX_LIAB_AP(SQL Table) |
Index Back |
---|---|
Canadian CA Tax LiabilityThis record contains the committment accounting Canadian tax liability information to be sent to AP. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
2 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
3 | PAY_END_DT | Date(10) | DATE NOT NULL |
Pay Period End Date
Prompt Table: PAY_CALENDAR |
4 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit |
5 | PAGE_NUM | Number(5,0) | INTEGER NOT NULL | Page Nbr |
6 | LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Line Nbr |
7 | SEPCHK | Number(2,0) | SMALLINT NOT NULL | Separate check number. |
8 | PROVINCE | Character(6) | VARCHAR2(6) NOT NULL | Province |
9 | TAX_CLASS_CAN | Character(3) | VARCHAR2(3) NOT NULL |
Canadian Tax Class
ALL=Total Gross CBT=Canadian Bonus Tax CIT=Canadian Income Tax (T4) CP2=CPP Second Additional Employee CPA=Pension Adjustment CPP=Canada Pension Plan Employee CPR=Canada Pension Plan Employer CR2=CPP Second Additional 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) QP2=QPP Second Additional Employee QPP=Quebec Pension Plan Employee QPR=Quebec Pension Plan Employer QR2=QPP Second Additional Employer RV2=Quebec Income Tax (RL-2) T4A=Canadian Income Tax (T4A) TRV=True RL TT4=True T4 |
10 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
11 | TAX_CUR | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Current Tax |
12 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
13 | DEPTID_CF | Character(10) | VARCHAR2(10) NOT NULL | Department |
14 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project/Grant |
15 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product |
16 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
17 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code |
18 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Public Sector Financials Chart Field. |
19 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Public Sector Financials Chart Field |
20 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit |
21 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
22 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference Chartfield |
23 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield number 1 |
24 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
25 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
26 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
27 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate2 |
28 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | Project Costing Business Unit |
29 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
30 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Project Costing Resource Type |
31 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Project Costing Resource Category |
32 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Project Costing Resource Sub Category |
33 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number |