CDN Payroll Cheque WORK File (CPY30110)

Product: MICR for Canadian Payroll (2916)
Series: Project

Display Name: CDN Payroll Cheque WORK File
Physical Name: CPY30110
Technical Name: P_CPY_Cheques_WORK

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BACHNUMB	Batch Number	STR15_LBAU	String	15
2	PPaymentMethod	P_Payment_Method	X_Payment_Method	Integer	0
3	PPaychqNum	P_Paycheque_Number	X_STR20	String	20
4	PEmployeeID	P_Employee_ID	X_STR15_Employee_ID	String	15
5	PEmployeeName	P_Employee_Name	X_STR40	String	40
6	PAddress1	P_Address_1	STR60	String	60
7	PAddress2	P_Address_2	STR60	String	60
8	PCity	P_City	STR35	String	35
9	PProvince	P_Province	X_STR04	String	4
10	PPostalCode	P_Postal_Code	X_STR10_Upper	String	10
11	PChequeDate	P_Cheque_Date	X_Date	Date	0
12	PChequeAmount	P_Cheque_Amount	X_DLR11_2	Currency	14
13	PAmountWordsNumbers	P_Amount_Words_Numbers	X_STR60	String	60
14	PHowPaid	P_How_Paid	X_How_Paid	Integer	0
15	PMarkedOff	P_Marked_Off	X_VS_YN	Integer	0
16	PChequeReference	P_Cheque_Reference	X_STR20	String	20
17	PChequeRecordType	P_Cheque_Record_Type	X_DDL_Cheque_Record_Type	Integer	0
18	PPaychqDueDate	P_Paycheque_Due_Date	X_Date	Date	0
19	PBnkEmpInstCd	P_Bank_Employee_Institution_Code	X_Return_Institution_Code	String	3
20	PBnkEmpTranNum	P_Bank_Employee_Transit_Number	X_Data_Center_Number	String	5
21	PBankEmpAccountNumber	P_Bank_Employee_Account_Number	X_STR12_Upper	String	12
22	PBankEmployeeXRefNumber	P_Bank_Employee_X_Ref_Number	X_Cross_Ref_Number	String	19
23	PChequebookID	P_Chequebook_ID	X_STR15_LBAU	String	15
24	PCashAccountIndex	P_Cash_Account_Index	LI_14	Long Integer	14
25	PGLBatchNumber	P_GL_Batch_Number	X_STR15_LBAU	String	15
26	PGLJournalEntry	P_GL_Journal_Entry	X_LI8_U0	Long Integer	8
27	PGLBatchNumber2	P_GL_Batch_Number2	X_STR15_LBAU	String	15
28	PGLJournalEntry2	P_GL_Journal_Entry2	X_LI8_U0	Long Integer	8
29	PCMRecordNumber	P_CM_Record_Number	X_DLR14_U5	Currency	14
30	PAmountWords	P_Amount_Words	X_Memo	Text	8000