Payroll Projection / Payroll Commitment (Adjustments)
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Adjustment Amount |
COMMIT_ADJUST_HISTORY |
ADJUSTMENT_AMOUNT |
Size: 10 Format: ########.## |
|
Adjustment Type Description |
COMMIT_ADJUST_HISTORY |
ADJUSTMENT_TYPE_DESC |
Internal Lookup: Earnings, Banking, Deduction Employers Share, Size: 30 |
|
Applicable Year |
COMMIT_ADJUST_HISTORY |
YEAR |
Size: 6 |
|
Balance Before Adjustment |
COMMIT_ADJUST_HISTORY |
BEFORE_ADJUSTMENT |
Size: 10 Format: ########.## |
|
Data file key number |
COMMIT_ADJUST_HISTORY |
SEQUENCE_NO |
used to identify each record- internal technical field Size: 10 |
|
Date of Adjustment |
COMMIT_ADJUST_HISTORY |
ADJUSTMENT_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
General Ledger Account Number |
COMMIT_ADJUST_HISTORY |
GL_ACCT_NO |
Size: 20 |
|
General Ledger Account Number |
COMMIT_ADJUST_HISTORY |
GL_ACCT_NO_FORMATTED |
Formatted Size: 20 |
|
Pay or Deduction Code |
COMMIT_ADJUST_HISTORY |
NUMBER_CODE |
Size: 4 |
|
Sib-Ledger Account Number |
COMMIT_ADJUST_HISTORY |
SL_ACCT_NO |
Size: 10 |
|
Sib-Ledger Account Number |
COMMIT_ADJUST_HISTORY |
SL_ACCT_NO_FORMATTED |
Formatted Size: 10 |
|
Storage Bank Code |
COMMIT_ADJUST_HISTORY |
STORAGE_BANK_CODE |
Size: 10 |
|
Storage Bank Description |
COMMIT_ADJUST_HISTORY |
STORAGE_BANK_DESC |
Size: 30 |
|
Transaction Type |
COMMIT_ADJUST_HISTORY |
ADJUSTMENT_TYPE |
A=Earnings, B=Banking, D=Deduction Employers Share, Size: 4 |
Payroll Projection / Payroll Commitment (De-commitments)
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Adjustment Amount |
DECOMMITMENT_HISTORY |
ADJUST_DECOMMITMENT |
Size: 10 Format: ########.## |
|
Applicable Year |
DECOMMITMENT_HISTORY |
YEAR |
Size: 4 |
|
Balance prior to De-commitment |
DECOMMITMENT_HISTORY |
BEFORE_DECOMMITMENT |
Size: 10 Format: ########.## |
|
Data file key number |
DECOMMITMENT_HISTORY |
SEQUENCE_NO |
used to identify each record- internal technical field Size: 10 |
|
Date of De-commitment |
DECOMMITMENT_HISTORY |
DECOMMITMENT_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
De-commitment Type |
DECOMMITMENT_HISTORY |
DECOMMITMENT_TYPE |
[P/B/D] P = Pay; B = Bank; D = Deduction (MA, MB, MD) Size: 4 |
|
De-commitment Type Description |
DECOMMITMENT_HISTORY |
DECOMMITMENT_TYPE_DESC |
Internal Lookup: Earnings, Banking, Deduction Employers Share Size: 30 |
|
General Ledger Account Number |
DECOMMITMENT_HISTORY |
GL_ACCT_NO |
Size: 20 |
|
General Ledger Account Number |
DECOMMITMENT_HISTORY |
GL_ACCT_NO_FORMATTED |
Formatted Size: 20 |
|
New Current De-commitment Amount |
DECOMMITMENT_HISTORY |
DECOMMITMENT_AMOUNT |
Size: 10 Format: ########.## |
|
Pay or Deduction Code |
DECOMMITMENT_HISTORY |
NUMBER_CODE |
Size: 4 |
|
Storage Bank Code |
DECOMMITMENT_HISTORY |
STORAGE_BANK_CODE |
Size: 10 |
|
Storage Bank Description |
DECOMMITMENT_HISTORY |
STORAGE_BANK_DESC |
Size: 30 |
|
Sub-Ledger Account Number |
DECOMMITMENT_HISTORY |
SL_ACCT_NO |
Size: 10 |
|
Sub-Ledger Account Number |
DECOMMITMENT_HISTORY |
SL_ACCT_NO_FORMATTED |
Formatted Size: 10 |
Payroll Projection / Payroll Commitment / Project
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Amount Adjusted |
COMMITMENT_HISTORY |
ADJUSTMENTS_AMOUNT |
Size: 10 Format: ########.## |
|
Commitment Type |
COMMITMENT_HISTORY |
COMMITMENT_TYPE |
A=Earnings, B=Banking, D=Deduction Employers Share, Size: 4 |
|
Commitment Type Description |
COMMITMENT_HISTORY |
COMMITMENT_TYPE_DESC |
Internal Lookup: Earnings=Earnings, Banking=Banking, Deduction Employers Share=Deduction Employers Share, Size: 30 |
|
Data file key number |
COMMITMENT_HISTORY |
SEQUENCE_NO |
used to identify each record- internal technical field Size: 10 |
|
De-commitment to date amount |
COMMITMENT_HISTORY |
DECOMMITMENT_AMOUNT |
Size: 10 Format: ########.## |
|
Expensed to Date Amount |
COMMITMENT_HISTORY |
EXPENSED_AMOUNT |
Size: 10 Format: ########.## |
|
General Ledger Account Number |
COMMITMENT_HISTORY |
GL_ACCT_NO |
Size: 20 |
|
General Ledger Account Number |
COMMITMENT_HISTORY |
GL_ACCT_NO_FORMATTED |
Formatted Size: 20 |
|
Number Code |
COMMITMENT_HISTORY |
NUMBER_CODE |
Earnings, Storage Bank (pay code) or Deduction code Size: 4 |
|
Original Commitment Amount |
COMMITMENT_HISTORY |
ORIGINAL_COMMITMENT |
Size: 10 Format: ########.## |
|
Storage Bank Code |
COMMITMENT_HISTORY |
STORAGE_BANK_CODE |
Size: 10 |
|
Storage Bank Description |
COMMITMENT_HISTORY |
STORAGE_BANK_DESC |
Size: 30 |
|
Sub-Ledger Account Number |
COMMITMENT_HISTORY |
SL_ACCT_NO |
Size: 10 |
|
Sub-Ledger Account Number |
COMMITMENT_HISTORY |
SL_ACCT_NO_FORMATTED |
Fomatted Size: 10 |
|
Year applicable for commitment |
COMMITMENT_HISTORY |
YEAR |
Size: 6 |