35
I am trying to create an Integration for employee expenses but I am getting the following error message. Anyone else run into this issue?
DOC 1 ERROR: Microsoft.Dynamics.GP.eConnect: Number = 1998 Stored Procedure taPAEmpExpenseHdrInsert : Description = Total Backout Purchases Amount does not match sum of Line items.
*This post is locked for comments
Thanks so much for getting back to me. This was very helpful. I followed these steps and tried to import but i am getting the following error message.
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Microsoft.Dynamics.GP.eConnect: Number = 1877 Stored Procedure taPAEmpExpenseHdrInsert : Description = Total Quantity does not match sum of Line items
Integration Failed
Integration Results
1 documents were read from the source query.
1 documents were attempted:
0 integrated without warnings.
0 integrated with warnings.
1 failed to integrate.
I looked at the total quantity in my header file and compared it to the PA Quantity in my line file and it matches. Please help
If you have installed SDK you can find this file C:\Program Files (x86)\Microsoft Dynamics\GP 11.0 SDK\Content\PA_EmplExpWork.doc where you have detailed info on how to construct the header files and detail line files is explained. There is also a sample file with data which you can use to validate your data. I have copy pasted the SDK for your reference.
Employee Expense
The following is a brief description of the fields and data flow that occurs with Employee Expense. Use this document as a guide for developing Employee Expense transactions.
Employee Expense. 1
Table: PA_Employee_Expense_WORK_HDR.. 2
Sample Record: 13
Table: PA_Employee_Expense_WORK_LINE.. 15
Sample Record: 25
Table: PA_EE_Distribution_WORK.. 28
Sample Record: 29
Table: PA_Employee_Expense_Tax_WORK.. 31
Sample Record: 33
The PA_Employee_Expense_WORK_HDR file is where all transactions created from the PA_Employee_Expense_Entry form are stored until they are posted.
|
Display Name |
PA Employee Expense Header File |
|
Physical Name |
PA10500 |
Field descriptions: (Required fields appear in bold and are underlined)
|
PA Empl Expense TRX Type |
Stores the Employee Expense document type. |
|
|
Field values: |
|
|
1 = Standard |
|
|
2 = Referenced |
|
|
|
|
PA Empl Expense Document No. |
This is the 17-character editable field for entering unique document numbers. The next default document number is stored in the PA_Employee_Expense_SETP file. |
|
|
|
|
PDK EE No. |
This field stores PDK EE Number if this document was entered in PDK. |
|
|
|
|
PA Document Date |
This stores the transaction document date of the posted transaction. For purchases/material this stores the receipt date. |
|
|
|
|
User ID |
This string field stores the ID of the user who entered the Employee Expense transaction entry. |
|
|
|
|
Batch Number |
This batch number identifies the Batch_Header for this Employee Expense transaction. A field in the Batch Headers File indicates how many transactions are saved in the work file with this batch number. |
|
|
|
|
Batch Source |
This is the Batch Source for the transaction. Valid values are PA_EE, if in batch mode, or XPA_EE, if posted real-time. This field is required. |
|
|
|
|
TRX Source: |
This stores an internally assigned audit trail code that is saved on the record when the transaction is posted. This code consists of the prefix plus the next number. This field is left blank when the document is in the WORK table. |
|
|
|
|
PA Reference Document No. |
If the Employee Expense document type is referenced, this field stores the Employee Expense number of the posted Employee Expense transaction being corrected. |
|
|
|
|
Shipping Method |
This field stores the shipping method for the transaction. It should exist in the SY_Shipping_Methods_MSTR table. |
|
|
|
|
PA User Defined 1 |
Both user-defined fields are for the User Defined categories setup in Employee Expense Setup. |
|
|
|
|
PA User Defined 2 |
Both user-defined fields are for the User Defined categories setup in Employee Expense Setup. |
|
|
|
|
Employee ID |
This string field stores the ID of the Employee who is the cost owner of the Employee Expense transaction entry. |
|
|
|
|
PA Vendor Address ID |
This field stores the address ID of the Employee. The employee – address ID combination should exist in the PM_Address_MSTR table. |
|
|
|
|
PA Start Date |
This field stores the beginning date of the reporting date range. Start Date and End Date set the range of dates that you could enter in the scrolling window. Employee expenses that do not fall within this range cannot be included. |
|
|
|
|
PA End Date |
This field stores the beginning date of the reporting date range. Start Date and End Date set the range of dates that you could enter in the scrolling window. Employee expenses that do not fall within this range cannot be included. |
|
|
|
|
PA Reporting Suffix |
This field stores the reporting sequence. |
|
|
|
|
PA Year |
This field stores the fiscal year of the reporting date. |
|
|
|
|
Payment Terms ID |
The control ID for payment terms. A record with this control ID should exist in the Payment Terms Master File with this ID. |
|
|
|
|
Due Date |
The due date as returned from payment terms calculation. This field is set to the document date if there are no payment terms. |
|
|
|
|
Discount Dollar Amount |
The discount available amount for payment terms when entered by the user and not calculated |
|
|
|
|
Originating Discount Dollar Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Discount Dollar Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Discount Dollar Amount’ field. |
|
|
|
|
Discount Date |
The discount date returned from payment terms calculation. This field is set to the document date if there are no payment terms. This field is required if discounts are calculated. |
|
|
|
|
Discount Amount Available |
The amount of discounts available on debit type documents. |
|
|
|
|
Originating Discount Amount Available |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Discount Available Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Discount Available Amount’ field. |
|
|
|
|
Percent Discount |
This is the discount percentage on an employee expense transaction. |
|
|
|
|
PA Comment |
This string field stores a short description of the transaction entry. |
|
|
|
|
Currency ID |
Originating currency ID for multicurrency documents – Required if using multicurrency. For non-multicurrency documents set to Functional Currency of globals. |
|
|
|
|
Currency Index |
Currency formatting index from the currency definition record. |
|
|
|
|
PA Total Quantity |
Summation of all quantities expended for the transaction entry. |
|
|
|
|
PA Extended Cost |
Computed as (‘PA Base Unit Cost’ * ‘PA Base Qty’). |
|
|
|
|
Originating Extended Cost |
The cost derived from multiplying the Originating Unit Cost and Quantity Shipped if the Receipt is a Shipment; otherwise it is Originating Unit Cost x Quantity Invoiced. If the transaction is not a multi-currency transaction, set to the same amount as the PA Extended Cost field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the PA Extended Cost field. |
|
|
|
|
PA Total Costs |
Summation of all costs expended for the transaction entry. |
|
|
|
|
PA Originating Total Costs |
The originating costs amount from the transaction. It is the sum of the costs amounts for the transaction. |
|
|
|
|
PA Reimbursable Tax Amount |
The amount of tax computed for the reimbursable amount. |
|
|
|
|
PA Originating Reimbursable Tax Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Reimbursable Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Reimbursable Tax Amount’ field. |
|
|
|
|
Backout Purchases Amount |
If there is a tax included with item price detail, then this is the true purchase amount. |
|
|
|
|
PA Total Accrued Revenues |
Summation of all revenues accrued from the transaction entry. |
|
|
|
|
PA Originating Accrued Revenues |
The originating accrued revenues amount from the transaction. It is the sum of the accrued revenues amounts for the transaction. |
|
|
|
|
Trade Discount Amount |
Trade discount amount given for the purchases/material transaction. |
|
|
|
|
Originating Trade Discount Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Trade Discount Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Trade Discount Amount’ field. |
|
|
|
|
PA Freight Taxable – Purchase |
If Advance Tax Calculations is set in Employee Expense Setup, this field will determine if freight will be taxable (based on a selected Freight Tax Schedule or that of the Vendor Tax Schedule) or nontaxable. |
|
|
Field Values: |
|
|
1 = Taxable |
|
|
2 = Nontaxable |
|
|
3 = Based on vendor |
|
|
|
|
Freight Schedule ID |
Stores the Freight Schedule ID that is used in calculating the Freight Tax if the ‘PA Freight Taxable - Purchase’ field is set to Taxable. |
|
|
|
|
Freight Amount |
This field stores the total amount of freight charges for the transaction. |
|
|
|
|
Originating Freight Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Freight Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Freight Amount’ field. |
|
|
|
|
Freight Tax Amount |
The tax amount from the 'Freight Amount' field. This field is needed for backing out tax included with item price. If the transaction is not a multi-currency transaction, set to the same amount as the ‘Freight Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Freight Tax Amount’ field. |
|
|
|
|
Originating Freight Tax Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Freight Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Freight Tax Amount’ field. |
|
|
|
|
PA Misc Taxable – Purchase |
If Advance Tax Calculations is set in Employee Expense Setup, this field will determine if miscellaneous charges will be taxable (based on a selected Misc. Tax Schedule or that of the Vendor Tax Schedule) or nontaxable. |
|
|
Field Values: |
|
|
1 = Taxable |
|
|
2 = Nontaxable |
|
|
3 = Based on vendor |
|
|
|
|
Misc Schedule ID |
Stores the Miscellaneous Schedule ID that is used in calculating the Misc. Tax if the ‘PA Misc Taxable - Purchase’ field is set to Taxable. |
|
|
|
|
Misc Charges Amount |
This field stores the total amount of miscellaneous charges for the transaction. |
|
|
|
|
Originating Misc Charges Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Misc Charges Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Misc Charges Amount’ field. |
|
|
|
|
Misc Tax Amount |
The miscellaneous tax assigned to the detail. The amount in this field is needed for backing out taxes included with item price. |
|
|
|
|
Originating Misc Tax Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Misc Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Misc Tax Amount’ field. |
|
|
|
|
Document Amount |
Computed as ('PA Reimbursable Amount') + ('Freight Amount' + 'Misc Charges Amount' + 'Tax Amount') |
|
|
|
|
Originating Document Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Document Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Document Amount’ field. |
|
|
|
|
1099 Amount |
The amount that needs to be reported as 1099 Amount for taxation purposes. |
|
|
|
|
Originating 1099 Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘1099 Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘1099 Amount’ field. |
|
|
|
|
Unapplied 1099 Amount |
Set initially to the value of the ‘1099 Amount’ field. |
|
|
|
|
Cash Amount |
Amount of a cash payment. If transactions are entered in batch mode and the batch is a recurring batch, payment amounts are not allowed for the transaction. This would result in duplicate Payment Numbers. |
|
|
|
|
Originating Cash Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Cash Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Cash Amount’ field. |
|
|
|
|
Cash Amount Checkbook ID |
The checkbook assigned to cash received. This field is required if a cash amount is entered. |
|
|
|
|
Cash Document Number |
The customer’s cash document number. This field is required if a cash amount is entered. |
|
|
|
|
Cash Amount Date |
The date assigned to the payment document for cash received. This field is required if a cash amount is entered. |
|
|
|
|
Cash Amount Payment Number |
Document number assigned to the payment document for cash received. This field is required if a cash amount is entered. |
|
|
|
|
Charge Amount |
This field contains the amount of the invoice that will remain charged to the vendor. This amount can be all or part of the Document Amount. This field should be the same as Current Transaction Amount. |
|
|
|
|
Originating Charge Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Charge Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Charge Amount’ field. |
|
|
|
|
Check Amount |
Amount of the check payment. If transactions are entered in batch mode and the batch is a recurring batch, payment amounts are not allowed for the transaction. This would result in duplicate Payment Numbers and Check Numbers. |
|
|
|
|
Originating Check Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Check Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Check Amount’ field. |
|
|
|
|
Check Number |
The customer’s check number. This field is required if a check amount is entered. |
|
|
|
|
Check Date |
The date assigned to the payment document for the check. This field is required if a check amount is entered. |
|
|
|
|
Check Amount Payment Number |
The document assigned to the payment document for the check amount. This field is required if a check amount is entered. |
|
|
|
|
Check Amount Checkbook ID |
The checkbook assigned to the check amount. This field is required if a check amount is entered. |
|
|
|
|
Card Name |
The name of the credit card. A record should exist in the Credit Card Master file with this ID. This field is required if a credit card amount is entered. |
|
|
|
|
Credit Card Amount |
The amount received if payment is made through a credit card. |
|
|
|
|
Originating Credit Card Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Credit Card Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Credit Card Amount’ field. |
|
|
|
|
Credit Card Date |
The date assigned to the payment document for the amount received on the credit card. This field is required if a credit card amount is entered. |
|
|
|
|
Credit Card Amount Payment Number |
The document assigned to the payment document for the credit card amount. This field is required if a credit card amount is entered. |
|
|
|
|
Credit Card Receipt Number |
The receipt number for credit cards. |
|
|
|
|
Discount Taken Amount |
Currency field. Stores the discounts made on the project. This is used for purchases/material and employee expense transactions. |
|
|
|
|
Originating Discount Taken Amount |
The originating discount taken amount from the transaction record. Currency storage type, keyable length: 17, storage size: 10. |
|
|
|
|
Originating Discount Available Freight |
The originating discount available freight amount from the transaction. Currency storage type, keyable length: 17, storage size: 10. |
|
|
|
|
Originating Discount Available Purchases |
The originating discounts available for purchases. Currency storage type, keyable length: 17, storage size: 10. |
|
|
|
|
Originating Discount Available Misc |
The originating discount available miscellaneous amount from the transaction. Currency storage type, keyable length: 17, storage size: 10. |
|
|
|
|
Tax Schedule ID |
The main tax schedule for this transaction. The tax schedule should exist in the TX_Schedule_MSTR file. |
|
|
|
|
Tax Amount |
The amount in this field is the amount of tax listed on the invoice. This field will not show any tax amounts calculated for Tax Included With Item Price tax details. The summation of Purchase, Freight and Miscellaneous taxes. |
|
|
|
|
Originating Tax Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Tax Amount’ field. |
|
|
|
|
Backout Tax Amount |
If there is a tax included with item price detail, this is the amount of the backout tax. |
|
|
|
|
Originating Backout Tax Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Backout Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Backout Tax Amount’ field. |
|
|
|
|
PA Reimbursable Amount |
The total reimbursable amount for the transaction. Summation of transaction line items reimbursable amounts. |
|
|
|
|
PA Originating Reimbursable Amount |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Reimbursable Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Reimbursable Amount’ field. |
|
|
|
|
PA Post Date |
Set to the date that should go with distributions when posting to General Ledger. |
|
|
|
|
Rate Type ID |
A unique string describing a rate type identifier. The Rate Type a customer uses by default Only used on a MC transaction. |
|
|
|
|
Exchange Table ID |
The multicurrency exchange table of the transaction record. |
|
|
|
|
Exchange Rate |
The multicurrency exchange rate of the transaction record. If there is triangulation and both rates are fixed, this is the originating to Euro fixed rate. Otherwise, this is the variable rate. |
|
|
|
|
Exchange Date |
The multicurrency exchange date of the transaction record. |
|
|
|
|
Time |
The multicurrency exchange time of the transaction record. Format is HHMMSS. |
|
|
|
|
Rate Calculation Method |
The rate calculation method from the currency record. |
|
|
0=Multiply |
|
|
1=Divide |
|
|
|
|
Denomination Exchange Rate |
The denomination exchange rate from the transaction record. If there is triangulation, this is the fixed rate. If both rates are fixed, this is the Euro to functional fixed rate. If there is no triangulation, this is 0.0 |
|
|
|
|
MC Transaction State |
MC Transaction State of the transaction record. State the transaction was created in. |
|
|
|
|
PA EE HDR Errors |
This field is used for tracking general transaction error messages during edit lists and posting. |
|
|
1 The Employee ID is missing |
|
|
2 No Vendor record for ID |
|
|
3 This Employee ID is inactive |
|
|
4 The employee expense document number is missing |
|
|
5 Duplicate Checks are not allowed |
|
|
6 Duplicate Invoices are not allowed |
|
|
7 No record exists for this Credit Card |
|
|
8 Vendor summary record cannot be found |
|
|
9 This transaction is recurring; it cannot include a payment amount |
|
|
10 The total applied amount is incorrect |
|
|
11 Tax detail information is incorrect |
|
|
12 Vendor ID is on hold |
|
|
13 PPS Vendor ID is invalid |
|
|
14 VAT incorrectly distributed or Intrastat record missing |
|
|
15 The document type is missing or invalid |
|
|
16 The reference document does not exist |
|
|
17 The reporting period is missing or invalid |
|
|
18 The reporting period start date is missing or invalid |
|
|
19 The total quantity is incorrect |
|
|
20 The total cost is incorrect |
|
|
21 The total revenue is incorrect |
|
|
22 Fiscal period for posting date does not exist |
|
|
23 Fiscal period for posting date is closed |
|
|
24 Distribution(s) contain errors |
|
|
25 Line(s) contain errors |
|
|
26 This document number has already been posted |
|
|
27 The transaction reported errors during posting and will not be posted |
|
|
28 This transaction contains multicurrency error(s). |
|
|
29 This Vendor ID is inactive |
|
|
30 You cannot post to a tax date within a closed tax period. |
|
|
31 You cannot post to a tax period that has not been set up. |
|
|
|
|
PA EE Distribution Errors |
This field is used for tracking general transaction error messages during edit lists and posting. |
|
|
1 The PRJCOST distributions do not equal the total costs to post |
|
|
2 The PRJREV distributions do not equal the total revenues to post |
|
|
3 The account payable distribution(s) does not equal the actual amount |
|
|
4 The purchases distribution(s) does not equal the actual amount |
|
|
5 The discount available distribution(s) does not equal the actual amount |
|
|
6 The trade discount distribution(s) does not equal the actual amount |
|
|
7 The misc distribution(s) does not equal the actual amount |
|
|
8 The freight distribution(s) does not equal the actual amount |
|
|
9 The tax distribution(s) does not equal the actual amount |
|
|
10 The cash distribution(s) does not equal the actual amount |
|
|
11 The other distribution(s) does not equal the actual amount |
|
|
12 The write off distribution(s) does not equal the actual amount |
|
|
13 The GST distribution(s) does not equal the actual amount |
|
|
14 The PPS distribution(s) does not equal the actual amount |
|
|
15 No account number specified in distribution(s) |
|
|
16 Account number not found in General Ledger |
|
|
17 Account number is inactive |
|
|
18 No distribution type specified |
|
|
19 Distribution type is invalid |
|
|
20 The debit distributions do not equal the credit distributions |
|
|
21 The Debit amount should not contain a negative figure |
|
|
22 The Credit amount should not contain a negative figure |
|
|
23 Invalid Distribution, line contains both a debit and a credit amount |
|
|
24 Account number has no access to the Currency ID |
|
|
|
|
PA MC EE Posting Errors |
This field is used for tracking general transaction error messages during edit lists and posting. |
|
|
1 The currency ID is missing. |
|
|
2 This company does not have access to this currency ID. |
|
|
3 The currency ID is inactive for this company. |
|
|
4 The rate type ID is missing. |
|
|
5 The rate type ID is not associated with the currency ID. |
|
|
6 The exchange table ID is missing. |
|
|
7 The company does not have access to this exchange table ID. |
|
|
8 The exchange table ID is inactive for this company. |
|
|
9 The exchange rate does not exist. |
|
|
10 The exchange rate has expired. |
|
|
11 Cannot post Multicurrency transactions to a recurring batch. |
|
|
12 The Multicurrency setup information is missing or damaged. |
|
|
13 The functional currency is missing. |
|
|
14 This company does not have access to the functional currency. |
|
|
15 The functional currency for this company is inactive. |
|
|
16 Originating debits not equal to originating credits. |
|
|
17 The fixed exchange rate for the Euro Currency ID could not be found. |
|
|
18 The currency must be either the functional currency, |
|
|
19 The currency must be the same as the currency assigned to the checkbook. |
|
|
20 the Euro currency, |
|
|
21 an enabled denomination currency, |
|
|
22 or the same as the currency assigned to the checkbook |
|
|
|
|
PA Post to Dyn Payables Mgmt |
Specifies where Project Accounting transactions will be posted if this option is marked. Checkbox storage type, storage size: 2. |
|
|
|
|
Tax Date |
Date used on VAT reports different from the document date that is used for tax reporting purposes. This can only be entered if VAT Line Analysis is turned on. Otherwise it defaults to the document date. |
|
|
|
|
Note Index |
Stores the document number note index that relates to a SY_Record_Notes_MSTR record. |
|
|
|
|
Tax Invoice Received |
If this field is marked, then the tax invoice has been received from the vendor. |
|
|
1 – Tax Invoice Received |
|
|
|
|
Tax Invoice Required |
If this transaction contains a tax detail with this field marked, then this transaction required a tax invoice. Defaulted from vendor. |
|
|
1 – Tax Invoice Required |
|
|
|
|
Correcting Trx Type |
Integer value set if the document was used to create Adjustment Transaction. 1 - Reverse 2 - Correcting |
|
|
|
|
PA Original Document Number |
The PA Empl Expense Document No. that was originally based on. |
|
1099 Type
1099 Box Number
|
The 1099 Type defaults from the Vendor ID where the PM00200.Vendor ID = PA10500.Employee ID.
The 1099 Box Number defaults from the Vendor ID where the PM00200.Vendor ID = PA10500.Employee ID.
|
|
Created Date |
The date the document was created |
|
|
|
|
Created User ID |
The User ID of the creator. |
|
PA Empl Expense TRX Type: |
1 |
|
PA Empl Expense Document No.: |
EE000000000006002 |
|
PDK EE No.: |
|
|
PA Document Date: |
'01/08/2002 |
|
User ID: |
|
|
Batch Number: |
B_EE1 |
|
Batch Source: |
PA_EE |
|
TRX Source: |
|
|
PA Reference Document No.: |
|
|
Shipping Method: |
|
|
PA User Defined 1: |
|
|
PA User Defined 2: |
|
|
Employee ID: |
|
|
PA Vendor Address ID: |
PRIMARY |
|
PA Start Date: |
'01/07/2002 |
|
PA End Date: |
'01/08/2002 |
|
PA Reporting Suffix: |
|
|
PA Year: |
2002 |
|
Payment Terms ID: |
|
|
Due Date: |
'00/00/0000 |
|
Discount Dollar Amount: |
0.00000 |
|
Originating Discount Dollar Amount: |
0.00000 |
|
Discount Date: |
'00/00/0000 |
|
Discount Amount Available: |
0.00000 |
|
Originating Discount Amount Available: |
0.00000 |
|
Percent Discount: |
0 |
|
PA Comment: |
|
|
Currency ID: |
USA |
|
Currency Index: |
1000 |
|
PA Total Quantity: |
13.50000 |
|
PA Extended Cost: |
7047.05000 |
|
Originating Extended Cost: |
7047.05000 |
|
PA Total Costs: |
7047.05000 |
|
PA Originating Total Costs: |
7047.05000 |
|
PA Reimbursable Tax Amount: |
0.00000 |
|
PA Originating Reimbursable Tax Amount: |
0.00000 |
|
Backout Purchases Amount: |
7047.05000 |
|
PA Total Accrued Revenues: |
25.00000 |
|
PA Originating Accrued Revenues: |
25.00000 |
|
Trade Discount Amount: |
0.00000 |
|
Originating Trade Discount Amount: |
0.00000 |
|
PA Freight Taxable - Purchase: |
0 |
|
Freight Schedule ID: |
|
|
Freight Amount: |
0.00000 |
|
Originating Freight Amount: |
0.00000 |
|
Freight Tax Amount: |
0.00000 |
|
Originating Freight Tax Amount: |
0.00000 |
|
PA Misc Taxable - Purchase: |
0 |
|
Misc Schedule ID: |
|
|
Misc Charges Amount: |
0.00000 |
|
Originating Misc Charges Amount: |
0.00000 |
|
Misc Tax Amount: |
0.00000 |
|
Originating Misc Tax Amount: |
0.00000 |
|
Document Amount: |
7047.05000 |
|
Originating Document Amount: |
7047.05000 |
|
1099 Amount: |
7047.05000 |
|
Originating 1099 Amount: |
7047.05000 |
|
Unapplied 1099 Amount: |
7047.05000 |
|
Cash Amount: |
0.00000 |
|
Originating Cash Amount: |
0.00000 |
|
Cash Amount Checkbook ID: |
|
|
Cash Document Number: |
|
|
Cash Amount Date: |
'00/00/0000 |
|
Cash Amount Payment Number: |
|
|
Charge Amount: |
7047.05000 |
|
Originating Charge Amount: |
7047.05000 |
|
Check Amount: |
0.00000 |
|
Originating Check Amount: |
0.00000 |
|
Check Number: |
|
|
Check Date: |
'00/00/0000 |
|
Check Amount Payment Number: |
|
|
Check Amount Checkbook ID: |
|
|
Card Name: |
|
|
Credit Card Amount: |
0.00000 |
|
Originating Credit Card Amount: |
0.00000 |
|
Credit Card Date: |
'00/00/0000 |
|
Credit Card Amount Payment Number: |
|
|
Credit Card Receipt Number: |
|
|
Discount Taken Amount: |
0.00000 |
|
Originating Discount Taken Amount: |
0.00000 |
|
Originating Discount Available Freight: |
0.00000 |
|
Originating Discount Available Purchases: |
0.00000 |
|
Originating Discount Available Misc: |
0.00000 |
|
Tax Schedule ID: |
|
|
Tax Amount: |
0.00000 |
|
Originating Tax Amount: |
0.00000 |
|
Backout Tax Amount: |
0.00000 |
|
Originating Backout Tax Amount: |
0.00000 |
|
PA Reimbursable Amount: |
7047.05000 |
|
PA Originating Reimbursable Amount: |
7047.05000 |
|
PA Post Date: |
'01/01/2002 |
|
Rate Type ID: |
|
|
Exchange Table ID: |
|
|
Exchange Rate: |
0.0000000 |
|
Exchange Date: |
'02/06/2002 |
|
Time: |
'12:00:00 AM |
|
Rate Calculation Method: |
0 |
|
Denomination Exchange Rate: |
0.0000000 |
|
MC Transaction State: |
0 |
|
PA EE HDR Errors: |
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF |
|
PA EE Distribution Errors: |
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF |
|
PA MC EE Posting Errors: |
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF |
|
PA Post to Dyn Payables Mgmt |
|
|
Tax Date |
|
|
Note Index: |
4253.00000 |
|
Tax Invoice Received |
|
|
Tax Invoice Required |
|
|
Correcting Trx Type: |
|
|
PA Original Document Number |
|
|
1099 Type |
|
|
1099 Box Number |
|
|
Created date |
|
|
Created User ID |
|
This file stores all the unposted line item information until it is posted. The records in this file relate to a specific record in the PA_Employee_Expense_WORK_HDR file.
|
Display Name |
PA Employee Expense Detail File |
|
Physical Name |
PA10501 |
Field descriptions: (Required fields appear in bold and are underlined)
|
PA Empl Expense TRX Type: |
Stores the Employee Expense document type. |
|
|
Field values: |
|
|
1 = Standard |
|
|
2 = Referenced |
|
|
|
|
PA Empl Expense Document No.: |
Same value as the related PA_Employee_Expense_WORK_HDR record. |
|
|
|
|
PA Reference Document No.: |
Same value as the related PA_Employee_Expense_WORK_HDR record. |
|
|
|
|
Employee ID: |
This string field stores the ID of the Employee who is the cost owner of the Employee Expense transaction entry. |
|
|
|
|
PA Date: |
The date when the Cost Category was expended on a project. This date should be within the reporting date specified in the PA_Employee_Expense_WORK_HDR and the period ending date of the reporting date. |
|
|
|
|
PA Contract Number: |
The contract number referencing the contract where the project entered belongs to. It should exist in the contract master table. The contract should not have a status of closed, on-hold or estimate. The contract should not also be closed to cost. Also, the Customer Number where this contract belongs to should exist in the PA customer master table and should not be closed to cost as well. For a “<NONE>” project entered, the value for the Contract Number will contain “<NONE>”. |
|
|
|
|
PA Project Number: |
The project number referencing the project where the cost is being expended. It should exist in the project master table. The project should not have a status of closed, on-hold or estimate. The project should not also be closed to cost. The PA_Project_Access_List_MSTR table should also be checked if the employee is part of the access list of the project or not. If the Employee Expense transaction type is referenced, the project number should exist in the line history table of the posted Employee Expense transaction being referenced. You can enter a cost transaction that doesn’t fall under any project. If this is the case, you’ll use a “<NONE>”. |
|
|
|
|
PA Cost Category ID: |
The cost category number referencing the cost category where the cost is being expended. It should exist in the cost category master table and should not be inactive. Only cost categories with Employee Expense transaction usage type are allowed for Employee Expenses. The cost category should also exist in the budget list of the project and the budget should not have a status of closed, on-hold or estimate. “<NONE>” cost categories are not allowed. If the Employee Expense transaction type is referenced, the project and cost category combination should exist in the line history table of the posted Employee Expense transaction being referenced. |
|
|
|
|
PA Item Number: |
String field to store descriptive name for the employee expense line. |
|
|
|
|
PA Billing Note Index: |
Stores the billing note index for the transaction line and relates to a PA_Billing_Notes_MSTR record. |
|
|
|
|
PA Quantity: |
This is the number of units used for the cost category in the project. |
|
|
|
|
PA Base Qty: |
The quantity in a particular U Of M Schedule. Computed as ('PA Quantity' * 'Equivalent U Of M QTY') if a U of M Schedule is used. If a U of M Schedule is not used, the value is set to the ‘PA Quantity’ field. |
|
|
|
|
PA Unit of Measure: |
This field stores the unit of measure. Units of Measure refer to the quantities in which businesses buys or sells an item. |
|
|
|
|
U of M Schedule: |
This field stores the unit of measure schedule. A unit of measure schedule is a group of related units of measure. This field will be used with the 'PA Unit of Measure' field to calculate the 'PA Base Qty' field. The base quantity is computed based on the U of M Schedules in the PA Unit of Measure Schedule setup window. |
|
|
|
|
PA Unit Cost: |
Cost amount per unit expended. |
|
|
|
|
Originating Unit Cost: |
If the transaction is not a multi-currency transaction, set to the same amount as the PA Unit Cost field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the PA Unit Cost field. |
|
|
|
|
PA Base Unit Cost: |
The unit cost in a particular U of M Schedule. Computed as ('PA Unit Cost' / 'Equivalent U Of M QTY') if a U of M Schedule is used. If a U of M Schedule is not used, the value is set to the ‘PA Unit Cost’ field. |
|
|
|
|
PA Originating Base Unit Cost: |
If the transaction is not a multi-currency transaction, set to the same amount as the PA Base Unit Cost field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the PA Base Unit Cost field. |
|
|
|
|
PA Extended Cost: |
Computed as (‘PA Base Unit Cost’ * ‘PA Base Qty’). |
|
|
|
|
Originating Extended Cost: |
The cost derived from multiplying the Originating Unit Cost and Quantity Shipped if the Receipt is a Shipment; otherwise it is Originating Unit Cost x Quantity Invoiced. If the transaction is not a multi-currency transaction, set to the same amount as the PA Extended Cost field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the PA Extended Cost field. |
|
|
|
|
PA Total Costs: |
Computed as (‘PA Extended Cost’ + ‘Tax Amount’). |
|
|
|
|
PA Originating Total Costs: |
If the transaction is not a multi-currency transaction, set to the same amount as the PA Total Cost field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the PA Total Cost field. |
|
|
|
|
PA Billing Rate: |
The amount to be used in computing the accrued revenues if the profit type is billing rate. |
|
|
|
|
PA Originating Billing Rate: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Billing Rate’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Billing Rate‘ field. |
|
|
|
|
PA Base Billing Rate: |
The billing rate amount in a particular U of M Schedule. Computed as ('PA Billing Rate' / 'Equivalent U Of M QTY') if a U of M Schedule is used. If a U of M Schedule is not used, the value is set to the ‘PA Billing Rate’ field. |
|
|
|
|
PA Originating Base Billing Rate: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Base Billing Rate’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Base Billing Rate‘ field. |
|
|
|
|
PA Markup Percentage: |
The percentage to be used in computing the accrued revenues if the profit type is markup percentage. |
|
|
|
|
PA Overhead Amount: |
Overhead amount for every unit expended on a project. Used if the method of computing overhead cost is Amount per Unit. |
|
|
|
|
PA Originating Overhead Amount: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Overhead Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Overhead Amount‘ field. |
|
|
|
|
PA Base Overhead Cost: |
The overhead amount in a particular U of M Schedule. Computed as ('PA Overhead Amount' / 'Equivalent U Of M QTY') if a U of M Schedule is used. If a U of M Schedule is not used, the value is set to the ‘PA Overhead Amount’ field. |
|
|
|
|
PA Originating Base Overhead Cost: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Base Overhead Cost’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Base Overhead Cost ‘ field. |
|
|
|
|
PA Overhead Percentage: |
Used if the method of computing overhead cost is Percentage of Actual Cost. Adds a percentage of actual cost as overhead cost. |
|
|
|
|
PA Total Overhead: |
Computed as ('PA Base Overhead Cost' + ('PA Base Unit Cost'* ('PA Overhead Percentage'/100))) * 'PA Base Qty'. |
|
|
|
|
PA Originating Total Overhead: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Total Overhead’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Total Overhead‘ field. |
|
|
|
|
PA Profit Type: |
This field stores the profit type or method in which the profit will be computed. |
|
|
Field Values: |
|
|
1 = Billing Rate |
|
|
2 = Markup % |
|
|
3 = Profit/Unit-Fixed |
|
|
4 = Profit/Unit-Variable |
|
|
5 = Total Profit |
|
|
6 = % of Baseline |
|
|
7 = % of Actual |
|
|
8 = None |
|
|
9 = Price Level |
|
|
|
|
PA Profit Amount: |
Field not used |
|
|
|
|
PA Originating Profit Amount: |
The profit amount in originating currency. Currency storage type, keyable length: 17, storage size: 10. |
|
|
|
|
PA Profit Percent: |
Field not used |
|
|
|
|
PA Total Profit: |
Computed as 'PA Accrued Revenues' - 'PA Total Cost' if the 'PA Accrued Revenues' field is not zero. |
|
|
|
|
PA Originating Total Profit: |
Computed as 'PA Originating Accrued Revenues' - 'PA Originating Total Cost' if the 'PA Originating Accrued Revenues' field is not zero. |
|
|
|
|
PA Accrued Revenues: |
The field will store the computed accrued revenue for the transaction line record. The Billing Type should be standard for this field to have a value. Depending on the profit type, the computation is as follows: |
|
|
Billing Rate='PA Base Billing Rate' * 'PA Base Qty' |
|
|
Markup %=‘PA Total Costs’ * (1 + ('PA Markup Percentage'/100) |
|
|
None=0.0 |
|
|
|
|
PA Originating Accrued Revenues: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Accrued Revenues’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Accrued Revenues ‘ field. |
|
|
|
|
PA STD Qty: |
Set to ‘PA Base Qty’ if the Billing Type is STD (Standard). |
|
|
|
|
PA NC Qty: |
Set to ‘PA Base Qty’ if the Billing Type is N/C (No Cost). |
|
|
|
|
PA NB Qty: |
Set to ‘PA Base Qty’ if the Billing Type is N/B (No Billing). |
|
|
|
|
PA Purchase Tax Options: |
This field will determine how the tax of the line item will be computed. |
|
|
Field Values: |
|
|
1 = Taxable |
|
|
2 = Nontaxable |
|
|
3 = Based on vendor |
|
|
|
|
Item Tax Schedule ID: |
Stores the schedule ID that is used in calculating the line item tax if the ‘PA Purchase Tax Options’ field is set to Taxable. |
|
|
|
|
Tax Amount: |
The amount in this field is the amount of tax listed on the invoice. This field will not show any tax amounts calculated for Tax Included With Item Price tax details. The summation of Purchase, Freight and Miscellaneous taxes. |
|
|
|
|
Originating Tax Amount: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Tax Amount ‘ field. |
|
|
|
|
Backout Tax Amount: |
If there is a tax included with item price detail, this is the amount of the backout tax. |
|
|
|
|
Originating Tax Backout Amount: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Backout Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Backout Tax Amount ‘ field. |
|
|
|
|
PA Payment Method: |
This field will store the payment method to indicate whether the expense will be paid in cash, by company credit card or by personal credit card. |
|
|
Field Values: |
|
|
1 = Cash |
|
|
2 = Company Credit Card |
|
|
3 = Personal Credit Card |
|
|
|
|
PA Expense Type: |
This field will determine whether the expense is reimbursable or a personal expense. |
|
|
Field Values: |
|
|
1 = Reimbursable |
|
|
2 = Personal Expense |
|
|
|
|
PA Reimbursable Amount: |
The amount to be reimbursed. If the Expense Type is Reimbursable and the Payment Method is either Personal Credit Card or Cash, reimbursable amount is set to the ‘PA Total Costs’ field. If the Expense Type is Personal and the Payment Method is Company Credit Card, reimbursable amount is set to (–1 * ‘PA Total Costs’). |
|
|
|
|
PA Originating Reimbursable Amount: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Reimbursable Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Reimbursable Amount‘ field. |
|
|
|
|
PA WIP IDX: |
Account index for work in process account. |
|
|
|
|
PA Unbilled AR IDX: |
Account index for accounts receivables account. |
|
|
|
|
PA COGS IDX: |
Stores the Account Index for the cost of goods sold account and relates to a GL_Account_MSTR table. This is the default Account Index that will be used to create a PA_Equipt_Log_Distribution_WORK record of type Cost of Goods Sold/Expense. |
|
|
|
|
PA Contra Account IDX: |
Account index for contra account. |
|
|
|
|
PA Overhead IDX: |
Stores the Account Index for the overhead account and relates to a GL_Account_MSTR table. This is the default Account Index that will be used to create a PA_Equipt_Log_Distribution_WORK record of type Overhead. |
|
|
|
|
PA Unbilled Proj Rev IDX: |
Account index for project revenues account. |
|
|
|
|
Line Item Sequence: |
This field contains the Line Item Sequence Number for the record. |
|
|
|
|
PA Reference Line Seq No: |
If the Employee Expense transaction type is referenced, this field stores the Line Item Sequence of the project and cost category combination in the line history table of the posted Employee Expense transaction being referenced. |
|
|
|
|
PA Billing Type: |
This field will store the billing type on how the cost will be charged to customers. |
|
|
Field Values: |
|
|
1 = STD (Standard) |
|
|
2 = N/C (No Cost) |
|
|
3 = N/B (No Billing) |
|
|
|
|
PA Billing Status: |
This field will store the billing status for the transaction line record. For a “<NONE>” project, the value will always be set to 4. |
|
|
Field Values: |
|
|
1 = Billable |
|
|
2 = In Process |
|
|
3 = Closed |
|
|
4 = Non-Billable |
|
|
5 = Fixed Fee Trx |
|
|
|
|
PA Export Date: |
This field is used by the Employee Expense-Detail Inquiry window when exporting Employee Expense data to text files. |
|
|
|
|
PA EE Line Errors: |
This field is used for tracking general transaction error messages during edit lists and posting. |
|
|
|
|
PA EE Line Errors 2: |
This field is used for tracking general transaction error messages during edit lists and posting. |
|
|
|
|
PA Approved Quantity: |
If this Employee Expense transaction line record is in the process of being billed in the Billing Entry Transaction window, this field will store the number of units to be billed in the Billing Entry Transaction window. |
|
|
|
|
PA Approved Billing Rate: |
If this Employee Expense transaction line record is in the process of being billed in the Billing Entry Transaction window, this field will store the billing rate that is used in the Billing Entry Transaction window. |
|
|
|
|
PA Approved Markup Percentage: |
If this Employee Expense transaction line record is in the process of being billed in the Billing Entry Transaction window, this field will store the markup percentage that is used in the Billing Entry Transaction window. |
|
|
|
|
PA Approved Billing Amount: |
If this Employee Expense transaction line record is in the process of being billed in the Billing Entry Transaction window, this field will store the computed billed amount in the Billing Entry Transaction window. |
|
|
|
|
PA Remaining Quantity: |
The remaining quantity. Currency storage type, keyable length: 15, storage size: 10. |
|
|
|
|
PA Remaining Total Cost: |
The remaining total cost. Currency storage type, keyable length: 17, storage size: 10. |
|
|
|
|
PA Remaining Accrued Revenues: |
The remaining accrued revenues. Currency storage type, keyable length: 17, storage size: 10. |
|
|
|
|
PA Billed Qty-OLD: |
Field not used. Currency storage type, keyable length: 15, storage size: 10. |
|
|
|
|
PA Billed Profit Amount Average: |
If this Employee Expense transaction line record has been billed in the Billing Entry Transaction window, this field will store the billed profit amount average. |
|
|
|
|
PA Billed Profit Percentage Average: |
If this Employee Expense transaction line record has been billed in the Billing Entry Transaction window, this field will store the billed profit percentage average. |
|
|
|
|
PA Billed Amount: |
If this Employee Expense transaction line record has been billed in the Billing Entry Transaction window, this field will store the billed amount. |
|
|
|
|
PA Billed Tax: |
If this Employee Expense transaction line record has been billed in the Billing Entry Transaction window, this field will store the billed tax amount. |
|
|
|
|
PA Write Up/Down Amount: |
If this Employee Expense transaction line record is in the process of being billed in the Billing Entry Transaction window, this field will store the amount used to write up or write down the billed amount in the Billing Entry Transaction window. |
|
|
|
|
PA Write Up/Down Percentage: |
If this Employee Expense transaction line record is in the process of being billed in the Billing Entry Transaction window, this field will store the percentage used to compute the write up or write down to the billed amount in the Billing Entry Transaction window. |
|
|
|
|
PA Approver ID: |
Field not used |
|
|
|
|
PA Approver Type: |
Field not used |
|
|
|
|
PA Partial Bill: |
Field not used |
|
|
|
|
PA Round Amount: |
PA round amount. Currency storage type, keyable length: 17, storage size: 10. |
|
|
|
|
Rounding Difference: |
Stores the Account Index for the rounding account and relates to a GL_Account_MSTR table. This is the default Account Index that will be used to create a PA_Equipt_Log_Distribution_WORK record of type ROUND. |
|
|
|
|
PA Change Order Number |
If the equipment log transaction line is a result of a change order, this field stores the change order number. The value defaults from the ‘PA Change Order Number’ field of the PA_Budget_MSTR record. |
|
|
|
|
PA CB From Add On The Fly |
Checkbox for Add on the Fly. Checkbox storage type, storage size: 2. |
|
|
|
|
PA MC Currency ID |
The Billing Currency ID of the Project. Control type string. Keyable length: 15, storage size: 16. |
|
|
|
|
PA MC Billing Rate |
The Billing Rate in the billing currency of the Project, which may not be the functional currency. Currency control type. Data Type: PA_DLR17_RBS0_UTR$; Keyable length: 17. |
|
|
|
|
PA MC Base Billing Rate |
Currency control type. Data Type: PA_DLR17_RBS0_UTR$; Keyable length: 17. |
|
|
|
|
PA MC Accrued Revenue |
The Accrued Revenue in the billing currency of the Project. Calculated as Quantity x MC Billing Rate Currency control type. Data Type: PA_DLR17_RBS0_UTR$; Keyable length: 17. |
|
|
|
|
Currency Index |
The Currency Index associated with the billing currency ID of the Project. Currency control type. Data Type: PA_DLR17_RBS0_UTR$; Keyable length: 17. |
|
|
|
|
Rate Type ID |
Rate Type ID is associated with the MC Currency ID and is used for identifying exchange tables when entering an Employee Expense transaction. String control type. Keyable length: 15, storage size: 16. |
|
|
|
|
Exchange Table ID |
Identifies the valid exchange rates that may be used for the transaction. String control type. Keyable length: 15, storage size: 16. |
|
|
|
|
Exchange Rate |
For calculating from MC Accrued Revenue to functional Accrued Revenue. Currency control type. Data type: DLR14_Exchange_Rate. Keyable length: 14. |
|
|
|
|
Exchange Date |
Date control type. Keyable length: 6. storage size: 4. |
|
|
|
|
Time |
Time control type. Keyable length: 6. storage size: 4. |
|
|
|
|
Rate Calc Method |
Determines whether to multiply or divide when calculating the Functional Accrued Revenue. Integer control type. Keyable length: 0. storage size: 2. |
|
|
|
|
Denomination Exchange Rate |
Currency control type. Data type: DLR14_Exchange_Rate. Keyable length: 14. Storage size: 10. Decimals: 7. |
|
|
|
|
MC Transaction State |
Integer control type. Keyable length: 1. Storage size: 2. |
|
|
|
|
Correcting Trx Type |
Integer control type. Keyable length: 0. Storage size: 2. |
|
|
|
|
PA Original Document Number |
String control type. Keyable length: 17. Storage size: 18. |
|
|
|
|
PA Original Line Item Sequence |
Long integer control type. Keyable length: 10. Storage size: 4. |
|
PA Empl Expense TRX Type: |
1 |
|
PA Empl Expense Document No.: |
EE000000000006002 |
|
PA Reference Document No.: |
|
|
Employee ID: |
|
|
PA Date: |
'01/07/2002 |
|
PA Contract Number: |
CONS |
|
PA Project Number: |
CONSBUILDING |
|
PA Cost Category ID: |
|
|
PA Item Number: |
|
|
PA Billing Note Index: |
4254.00000 |
|
PA Quantity: |
2.00000 |
|
PA Base Qty: |
2.00000 |
|
PA Unit of Measure: |
Each |
|
U Of M Schedule: |
|
|
PA Unit Cost: |
95.00000 |
|
Originating Unit Cost: |
95.00000 |
|
PA Base Unit Cost: |
95.00000 |
|
PA Originating Base Unit Cost: |
95.00000 |
|
PA Extended Cost: |
190.00000 |
|
Originating Extended Cost: |
190.00000 |
|
PA Total Costs: |
190.00000 |
|
PA Originating Total Costs: |
190.00000 |
|
PA Billing Rate: |
0.00000 |
|
PA Originating Billing Rate: |
0.00000 |
|
PA Base Billing Rate: |
0.00000 |
|
PA Originating Base Billing Rate: |
0.00000 |
|
PA Markup Percentage: |
0.00000 |
|
PA Overhead Amount: |
0.00000 |
|
PA Originating Overhead Amount: |
0.00000 |
|
PA Base Overhead Cost: |
0.00000 |
|
PA Originating Base Overhead Cost: |
0.00000 |
|
PA Overhead Percentage: |
0.00000 |
|
PA Total Overhead: |
0.00000 |
|
PA Originating Total Overhead: |
0.00000 |
|
PA Profit Type: |
5 |
|
PA Profit Amount: |
15.00000 |
|
PA Originating Profit Amount: |
0.00000 |
|
PA Profit Percent: |
0.00000 |
|
PA Total Profit: |
0.00000 |
|
PA Originating Total Profit: |
0.00000 |
|
PA Accrued Revenues: |
0.00000 |
|
PA Originating Accrued Revenues: |
0.00000 |
|
PA STD Qty: |
2.00000 |
|
PA NC Qty: |
0.00000 |
|
PA NB Qty: |
0.00000 |
|
PA Purchase Tax Options: |
0 |
|
Item Tax Schedule ID: |
|
|
Tax Amount: |
0.00000 |
|
Originating Tax Amount: |
0.00000 |
|
Backout Tax Amount: |
0.00000 |
|
Originating Backout Tax Amount: |
0.00000 |
|
PA Payment Method: |
3 |
|
PA Expense Type: |
1 |
|
PA Reimbursable Amount: |
190.00000 |
|
PA Originating Reimbursable Amount: |
190.00000 |
|
PA WIP IDX: |
515 |
|
PA Unbilled AR IDX: |
0 |
|
PA COGS IDX: |
0 |
|
PA Contra Account IDX: |
530 |
|
PA Overhead IDX: |
0 |
|
PA Unbilled Proj Rev IDX: |
0 |
|
Line Item Sequence: |
32768 |
|
PA Reference Line Seq No: |
0 |
|
PA Billing Type: |
1 |
|
PA Billing Status: |
5 |
|
PA Export Date: |
'00/00/0000 |
|
PA EE Line Errors: |
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF |
|
PA EE Line Errors 2: |
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF |
|
PA Approved Quantity: |
0.00000 |
|
PA Approved Billing Rate: |
0.00000 |
|
PA Approved Markup Percentage: |
0.00000 |
|
PA Approved Billing Amount: |
0.00000 |
|
PA Remaining Quantity: |
0.00000 |
|
PA Remaining Total Cost: |
0.00000 |
|
PA Remaining Accrued Revenues: |
0.00000 |
|
PA Billed Qty-OLD: |
0.00000 |
|
PA Billed Profit Amount Average: |
0.00000 |
|
PA Billed Profit Percentage Average: |
0.00000 |
|
PA Billed Amount: |
0.00000 |
|
PA Billed Tax: |
0.00000 |
|
PA Write Up/Down Amount: |
0.00000 |
|
PA Write Up/Down Percentage: |
0 |
|
PA Approver ID: |
|
|
PA Approver Type: |
0 |
|
PA Partial Bill: |
0 |
|
PA Round Amount: |
0.00000 |
|
Rounding Difference: |
0 |
|
PA Change Order Number |
|
|
PA CB From Add On The Fly |
|
|
PA MC Currency ID |
|
|
PA MC Billing Rate |
|
|
PA MC Base Billing Rate |
|
|
PA MC Accrued Revenue |
|
|
Currency Index |
|
|
Rate Type ID |
|
|
Exchange Table ID |
|
|
Exchange Rate |
|
|
Exchange Date |
|
|
Time |
|
|
Rate Calc Method |
|
|
Denomination Exchange Rate |
|
|
MC Transaction State |
|
|
Correcting Trx Type |
|
|
PA Original Document Number |
|
|
PA Original Line Item Sequence |
|
All amounts on Employee Expense transactions must be accounted for in the PA_EE_Distribution_WORK file. The easiest way to see how Project Accounting distributes the various amounts for all the different document types is to enter the type of transaction into the Employee Expense Transaction Entry window, then verify how it was distributed by opening the Employee Expense Distribution window. There may be an unlimited number of distribution records for each transaction. By default there will be only one distribution per distribution type, but the user may split that one record into an unlimited number of distributions as long as the total of that particular type is correct.
|
Display Name |
PA Employee Expense Distribution WORK |
|
Physical Name |
PA10504 |
Field descriptions: (Required fields appear in bold and are underlined)
|
PA Empl Expense Document No.: |
Same value as the related PA_Employee_Expense_WORK_HDR record. |
|
|
|
|
TRX Source: |
This stores an internally assigned audit trail code that is saved on the record when the transaction is posted. This code consists of the prefix plus the next number. This field is left blank when the document is in the WORK table. |
|
|
|
|
Distribution Sequence Number: |
The sequence number is used to order distributions for each transaction. |
|
|
|
|
Control Type: |
Set to zero. |
|
|
|
|
Credit Amount: |
The amount to credit the account by. If not zero, then the debit amount must be zero. |
|
|
|
|
Debit Amount: |
The amount to debit the account by. If not zero, then the credit amount must be zero. |
|
|
|
|
Distribution Account Index: |
The distribution posts to this account index. PC verifies account numbers both at data entry. The account index is a unique long integer assigned to an account number. It is stored in the tables of subsidiary modules instead of the account numbers in order to decrease row size. This field stores the account index that relates to a GL_Account_MSTR table. |
|
|
|
|
Distribution Type: |
This field stores the distribution type. |
|
|
Field values: |
|
|
1 Work In Progress |
|
|
2 Cost of Goods Sold/Expense |
|
|
3 Contra Account |
|
|
4 Unbilled Accounts Receivable |
|
|
5 Unbilled Project Revenue |
|
|
6 Overhead |
|
|
7 OTHER |
|
|
8 ROUND |
|
|
|
|
Distribution Reference: |
Used as the reference when the distribution is posted. If empty, the Reference in PA_PO_Receipt is used instead. |
|
|
|
|
User ID: |
This string field stores the ID of the user who entered the Employee Expense transaction entry. |
|
|
|
|
Employee ID: |
Same value as the related PA_Employee_Expense_WORK_HDR record. |
|
|
|
|
Currency ID: |
Originating currency ID for multicurrency documents – Required if using multicurrency. For non multicurrency documents set to Functional Currency of globals. |
|
|
|
|
Currency Index: |
Currency formatting index from the currency definition record. |
|
|
|
|
Originating Credit Amount: |
The originating amount the account is credited. If non-zero, then originating debit amount must be zero. |
|
|
|
|
Originating Debit Amount: |
The originating amount the account is debited. If non-zero, then originating credit amount must be zero. |
|
PA Empl Expense Document No.: |
EE000000000006002 |
|
TRX Source: |
|
|
Distribution Sequence Number: |
1 |
|
Control Type: |
0 |
|
Credit Amount: |
0.00000 |
|
Debit Amount: |
3097.05000 |
|
Distribution Account Index: |
515 |
|
Distribution Type: |
6 |
|
Distribution Reference: |
|
|
User ID: |
|
|
Employee ID: |
|
|
Currency ID: |
|
|
Currency Index: |
0 |
|
Originating Credit Amount: |
0.00000 |
|
Originating Debit Amount: |
3097.05000 |
This table stores the tax breakdown per Tax Detail ID for each PA_Employee_Expense_WORK_LINE record.
|
Display Name |
PA Employee Expense Tax WORK file |
|
Physical Name |
PA10502 |
Field descriptions: (Required fields appear in bold and are underlined)
|
PA Empl Expense TRX Type: |
Same value as the related PA_Employee_Expense_WORK_HDR record. |
|
|
|
|
PA Empl Expense Document No.: |
Same value as the related PA_Employee_Expense_WORK_HDR record. |
|
|
|
|
Line Item Sequence: |
Same value as the related PA_Employee_Expense_WORK_LINE record. |
|
|
|
|
Tax Detail ID: |
This field stores the Tax Detail ID. All amounts will be in terms of this Tax Detail ID only. |
|
|
|
|
Employee ID: |
Same value as the related PA_Employee_Expense_WORK_HDR record. |
|
|
|
|
Tax Amount: |
The amount in this field is the amount of tax listed on the invoice. This field will not show any tax amounts calculated for Tax Included With Item Price tax details. The summation of Purchase, Freight and Miscellaneous taxes. |
|
|
|
|
PA Reimbursable Tax Amount: |
The amount of tax computed for the reimbursable amount. |
|
|
|
|
Backout Tax: |
This field contains information about whether the tax is a backout tax. |
|
|
True = Tax is a backout tax. |
|
|
False = Tax is not a backout tax. |
|
|
|
|
Originating Tax Amount: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Tax Amount’ field. |
|
|
|
|
PA Originating Reimbursable Tax Amount: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘PA Reimbursable Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘PA Reimbursable Tax Amount’ field. |
|
|
|
|
Purchases Tax Amount: |
The tax amount from the 'Purchases Amount' field. This field is needed for backing out tax included with item price. |
|
|
|
|
Originating Purchases Tax Amount: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Purchases Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Purchases Tax Amount’ field. |
|
|
|
|
Freight Tax Amount: |
The tax amount from the 'Freight Amount' field. This field is needed for backing out tax included with item price. If the transaction is not a multi-currency transaction, set to the same amount as the ‘Freight Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Freight Tax Amount’ field. |
|
|
|
|
Originating Freight Tax Amount: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Freight Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Freight Tax Amount’ field. |
|
|
|
|
Misc Tax Amount: |
The miscellaneous tax assigned to the detail. The amount in this field is needed for backing out taxes included with item price. |
|
|
|
|
Originating Misc Tax Amount: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Misc Tax Amount’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Misc Tax Amount’ field. |
|
|
|
|
Tax Detail Total Purchases: |
The total amount of purchases tax assigned to the detail. |
|
|
|
|
Originating Total Purchases: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Tax Detail Total Purchases’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Tax Detail Total Purchases’ field. |
|
|
|
|
Tax Detail Total Taxable Purchases: |
Same description as Tax Detail Taxable Purchases but in the Originating Currency. Set to Tax Detail Total Taxable Purchases if non-MC transaction. |
|
|
|
|
Originating Total Taxable Purchases: |
If the transaction is not a multi-currency transaction, set to the same amount as the ‘Tax Detail Total Taxable Purchases’ field. If the transaction is a multi-currency transaction, set to the originating currency amount equivalent of the ‘Tax Detail Total Taxable Purchases’ field. |
|
|
|
|
Account Index: |
A unique long integer assigned to an account number. It is stored in the tables of subsidiary modules instead of the account numbers in order to decrease row size. |
|
|
|
|
Currency Index: |
Same value as the related PA_Employee_Expense_WORK_HDR record. |
|
PA Empl Expense TRX Type: |
1 |
|
PA Empl Expense Document No.: |
EE000000000000002 |
|
Line Item Sequence: |
0 |
|
Tax Detail ID: |
AUSSTE+PS0N0 |
|
Employee ID: |
|
|
Tax Amount: |
0.00000 |
|
PA Reimbursable Tax Amount: |
0.00000 |
|
Backout Tax: |
0 |
|
Originating Tax Amount: |
0.00000 |
|
PA Originating Reimbursable Tax Amount: |
0.00000 |
|
Purchases Tax Amount: |
0.00000 |
|
Originating Purchases Tax Amount: |
0.00000 |
|
Freight Tax Amount: |
0.00000 |
|
Originating Freight Tax Amount: |
0.00000 |
|
Misc Tax Amount: |
0.00000 |
|
Originating Misc Tax Amount: |
0.00000 |
|
Tax Detail Total Purchases: |
794.62000 |
|
Originating Total Purchases: |
794.62000 |
|
Tax Detail Total Taxable Purchases: |
794.62000 |
|
Originating Total Taxable Purchases: |
794.62000 |
|
Account Index: |
687 |
|
Currency Index: |
1000 |
Share
Report
All responses (
Answers (
