INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

JURIS_ID

Req

C 10

Id of the taxing authority.

CONSOL_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. This tax rate is the same for sales and use tax and PENTA applies it in all taxable situations.

SALES_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only applies it in situations where that type is applicable.

USE_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only applies it in situations where that type is applicable.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

Must match the vendor Id in the document row.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within request/vendor/invoice.

DR_OU_ID

Req

X

This must be an active general ledger account. The default is the AP OU Id from the INTR_AP_DOC row.

The User Id must have authorization for this OU.

If System Option 107 is Y, this OU must be the AP OU Id from the INTR_AP_DOC row.

DR_ACCT_NUM

Req

X

This must be an active account with an edit rule of AR, Cash, or no edit rule.

If the account’s edit rule is AR or Cash:

• The account’s OU Id must match the AP OU Id from the INTR_AP_DOC row.

• The account’s currency must match the Source Currency from the INTR_AP_DOC row.

If System Option 44 is Y, and the account’s currency is not equal to the Source Currency Id from the INTR_AP_DOC row, an exchange rate must exist for the two currencies.

CUS_ID

Opt

X

This must be an active customer.

Required if the GL Account Number has an edit rule of AR; otherwise, do not enter a value.

D_PRD_END_DATE

Opt

D

Required if the GL Account Number has an edit rule of AR, the Customer Id is an employee, and System Option 105 is Y; otherwise, do not enter a value.

REF_JOB_ID

Opt

X

A job related to the Job ID. This does not have to be a parent, child, or active job.

DESCR

Req

C 30

If System Option 104 is Y, the default is the vendor name of the Vendor Id from the INTR_AP_DOC row. If System Option 104 is N, there is no default.

AMT

Req

F 15.2

Enter a value other than zero.

CR_ACCT_NUM

Req

X

This must be an active account with an edit rule of AP.

If System Option 109 is Y, the default is the:

• Vendor/OU inter-company AP account number.

• OU’s inter-company AP account number.

If System Option 44 is Y, the currency assigned to the account must equal the Source Currency from the INTR_AP_DOC row. If the account does not have a currency, then the currency of the job’s OU must equal the Source Currency from the INTR_AP_DOC row. The default is the AP account of the Source Currency Id.

If System Options 109 and 44 are set to N, the default is the Job Type’s AP account number.

If System Option 89 is Y and the user type is not H (home office), this column must be blank or null.

EXCHANGE_RATE

Opt

F 12.6

Must be greater than zero. If the job’s currency is the same as the Source Currency Id, this column must be 1.0.

Required if System Option 44 is Y; otherwise, do not enter a value.

The default is:

• The job’s exchange rate (from the INTR_AP_DOC row).

• The rate necessary to change between the Source Currency Id and the job’s currency.

• A rate of 1.0.

FORM_ID

Opt

C! 8

The default is the Form Id for the Source Currency Id. The User Id must have authorization to use this Check Form.

Required if System Option 75 is 3; otherwise, do not enter a value.

If System Option 155 is Y, the Check Form type may be AP or GN. If System Option 155 is N, the Check Form type must be AP.

If System Option 44 is Y, the currency of the Check Form must be the same as Source Currency Id.

If System Option 89 is Y and the user type is not H (home office), do not enter a value.

TAX_EXEMPT_
REASON_CD

Opt

C! 3

The defaults are:

• Costcode tax exempt reason code.

• Job’s tax exempt reason code.

If System Option 152 is N, this column must be blank or null.

If Tax Exempt Reason Code on the INTR_AP_DOC row has a value, this column must be one of the defaults.

The default is stored in PENTA, but the document reason code overrides the distribution reason code; you cannot manually override it.

TAX_CERTIFICATE

Opt

C 15

The defaults are:

• Costcode tax certificate.

• Job’s tax certificate.

If System Option 152 is N, this column must be blank or null.

If the Tax Exempt Certificate Id on the INTR_AP_DOC row has a value, this column must be one of the defaults.

The default is stored in PENTA, but the Document certificate overrides the distribution certificate. You cannot manually override it.

EARN_CD

Opt

I 2

1099 Earnings Code.

TRANX_REF_ID

Opt

C 15

PENTA marks job cost and billing transactions within the interface files with this Transaction Reference Id. This enables your external application to perform functions (e.g., billing and profit analysis) by whatever grouping this Id represents.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

FORM_1099_ST_CD

Opt

C 4

The 1099 State Code.

CASH_ACCOUNT_NUM

Opt

X

Account # of the Cash Account.

Required if the GL Account Number has an edit rule of Cash; otherwise, do not enter a value.

Cash Account must have the same GL account as entered in the DR_ACCT_NUM.

The Cash Account's OU Id must have the same BS OU as the account on the DR_OU_ID row.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

CUS_REF_CD

Req

C 15

A reference code that pertains to the work order’s distribution.

CUS_REF_VALUE

Opt

C 30

The value for the associated Customer Reference Code.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

The invoice number must be unique.

If the Invoice Number and Vendor Id match an invoice that has a void status of Y, PENTA rejects this invoice (INTR_AP_DOC and all associated INTR_AP_JOB and INTR_AP_ACCT rows).

VEN_ID

Req

X

ID of the Vendor associated with the invoice. This must be a vendor with an Active or Hold status. The vendor type cannot be Miscellaneous* and the vendor class must be set up as a supplier.

You can only enter a Vendor ID or Employee ID.

Required if Employee ID is blank or null; otherwise, do not enter a value.

If System Option 109 is Y, the Vendor Id cannot be the same as the Vendor Id assigned to the AP OU.

CR_OU_ID

Req

X

This must be an active balance sheet OU.

The User Id passed to the package must have authorization for this OU. PENTA will not verify authorization for this OU until the user attempts to view the batch using the Accounts Payable windows.

The default is the OU of the user (User Id).

EMP_ID

Opt

X

You can only enter a Vendor ID or Employee ID.

Required if Vendor Id is blank or null; otherwise, do not enter a value.

The default is the employee associated with the vendor.

INVOICE_AMT

Req

F 15.2

The total amount of all invoices in this INTR_RQST_ID.

D_INVOICE_DATE

Req

D

The invoice date must be less than or equal to a year from the current processing date (a year in the future).

If this column is null and System Option 20 is Y, PENTA uses the system date.

D_DISTR_DATE

Opt

D

The date must be less than or equal to a year from the current processing date (a year in the future). The default is the invoice date.

The date must be within an open accounting period for the Accounts Payable OU.

PAY_TERM_NUM

Opt

I 3

The default is the vendor’s payment terms. Optionally, enter a Proximo date for the following conditions:

• Due date and payment date are in the month following the invoice date.

• The invoice date, discount date, and due date can be either in the same month, or in two different months.

Notes:

• PENTA compares the invoice date to the cutoff day to determine which discount date and due date should apply to an invoice.

• The payment month indicator tells PENTA whether the discount and/or due dates are in the same month as the invoice date, or in the month following the invoice date.

• If System Option 329 is 2 or 3 and you are charging a subcontract, PENTA applies the subcontract’s Payment Terms to the invoice.

• If System Option 217 is 2 or 3 and you are charging a purchase order, PENTA applies the purchase order’s Payment Terms to the invoice.

DSCNT_PCT

Opt

F 8.5

Must be between 0.001 and 100.000 percent. The default is the discount percent associated with the Payment Terms.

Either enter this value or a Discount Amount, not both.

DSCNT_AMT

Opt

F 15.2

Must be the same sign (+ or –) as Invoice Amount and less than the Invoice Amount.

Either enter this value or a Discount Percent, not both.

RET_PCT

Opt

F 8.5

Must be between 0.001 and 100.000 percent.

Either enter this value or a Retention Amount, not both.

RET_AMT

Opt

F 15.2

Must be the same sign (+ or –) as Invoice Amount and less than the Invoice Amount.

Either enter this value or a Retention Percent, not both.

INVOICE_UNITS

Opt

F 12.3

The total units on the invoice

PAY_RQST_NUM

Opt

C 15

If System Option 148 is Y, the Pay Request Number must be in digits (rather than characters).

INVOICE_TYPE_CD

Req

C! 3

The value should be REG. The default is REG.

REMIT_ADDR_NUM

Opt

I 5

The default is the remit-to address of the Vendor Id.

Note: The Vendor Type cannot be Miscellaneous. PENTA does not support Miscellaneous Vendor Types with the accounts payable interface.

Required if System Option 77 is Y; otherwise, do not enter a value.

SOURCE_CURRENCY_
ID

Opt

C! 3

The default is the currency of the Vendor Id. If the vendor does not have an assigned currency, PENTA uses the currency of the AP OU Id.

Required if System Option 44 is Y; otherwise, do not enter a value.

FORM_ID

Opt

C! 8

The default is the Form Id for the Source Currency Id. The User Id must have authorization to use this Check Form.

Required if System Option 75 is 3; otherwise, do not enter a value.

If System Option 155 is Y, the Check Form type may be AP or GN. If System Option 155 is N, the Check Form type must be AP.

If System Option 44 is Y, the currency of the Check Form must be the same as Source Currency Id.

If System Option 89 is Y and the user type is not H (home office), do not enter a value.

TAX_AMT

Opt

F 15.2

The amount of taxes for the invoice.

If System Option 152 is N, this column must be blank or null.

If System Option 271 is Y, PENTA records sales tax amounts entered by the user on an AP invoice as sales tax for jurisdictions associated with the AP invoice distribution.

Individual AP Invoice distributions are determined to be taxable or non-taxable (based on a purchase order’s set up, based on the Job an invoice is charged to, based on the OU/Account, etc.). PENTA will require that at least one AP invoice distribution is taxable; otherwise, PENTA issues an error message and prevents the user from entering the vendor’s invoice with a sales tax amount.

Users record sales tax charged by a vendor as a lump sum amount. PENTA does not require users to break down the sales tax amount by taxing jurisdiction when recording the vendor’s invoice. Therefore, PENTA must allocate the sales tax amount across the tax jurisdictions associated with distributions entered on the AP document (State, City, etc.):

• When the entered tax amount equals the PENTA calculated tax amount PENTA records the sales tax amount as “sales tax paid” for each jurisdiction.

• When the entered tax amount does not equal the PENTA calculated tax amount, and the absolute value of the difference between the entered tax amount and the PENTA calculated tax amount is less than the “Sales & Use Tax Variance Limit,” PENTA adjusts its calculated tax amount for the tax jurisdiction with the largest sales tax percent until the total calculated sales tax value equals the entered sales tax value. In a situation where the entered sales tax is less than the calculated sales tax, and the reduction of the calculated sales tax exceeds the amount of tax calculated for that jurisdiction, PENTA adjusts the remaining amount for the jurisdiction with the next largest tax percentage. PENTA records the adjusted amounts as “sales tax paid” for those jurisdictions. Note: PENTA assumes you will set the Sales & Use Tax Variance Limit to a small amount, $0.10 for example. Therefore if there are rounding differences between the calculated tax amount PENTA calculates vs. what the vendor calculated, PENTA will adjust its calculated value rather than post penny adjustments (accruals) in the sales tax liability accounts.

• When the entered tax amount does not equal the PENTA calculated tax amount, and the absolute value of the difference between the entered tax amount and the PENTA calculated tax amount is greater than the “Sales & Use Tax Variance Limit,” PENTA allocates the entered sales tax amounts to the applicable tax jurisdictions, beginning with the jurisdiction with the smallest sales tax percent until the entered tax amount is fully allocated. These amounts record as “sales tax paid.” PENTA accrues and records as “use tax” the difference between its calculated value and the allocation to each jurisdiction.

The Sales & Use Tax reporting gives detailed sales tax jurisdiction reporting for amounts paid as sales tax plus accruals made where one of the following is true:

• A vendor did not charge tax in a taxable situation.

• The amount of tax charged by the vendor does not agree with the sales tax rules defined for each jurisdiction.

TAX_EXEMPT_
REASON_CD

Opt

C! 3

Must be a valid reason code.

Required if System Option 152 is Y and no tax jurisdictions exist for Vendor Id and the postal code associated with that vendor’s remit-to address number; otherwise, do not enter a value.

TAX_CERTIFICATE

Opt

C 15

If System Option 152 is N, this column must be blank or null.

PAYMENT_CYCLE_
NUM

Opt

I 3

The cycle you plan to pay the Invoice with. This value helps in selecting items for payment.

TRANX_REF_ID

Opt

C! 15

PENTA marks job cost and billing transactions within the interface files with this Transaction Reference Id. This enables your external application to perform functions (e.g., billing and profit analysis) by whatever grouping this Id represents.

D_DUE_DATE

Opt

D

The due date for the invoice payment.

D_DSCNT_DATE

Opt

D

The date by which you must pay the invoice amount in order to receive a discounted price.

MISC_VEN_ADDR_
NAME

Opt

C! 30

MISC_VEN_ADDR_NAME=XXXX, where XXXX is the Vendor Name in the address block.

Enter this as Column Name =Name. Example: MISC_VEN_ADDR_NAME =Acme Supply

You can enter this for any Vendor Type.

MISC_VEN_ADDR_1

Opt

C! 30

MISC_VEN_ADDR_1=XXXX, where XXXX is the Address in line 1 of the address block.

Enter this as Column Name =Address 1. Example: MISC_VEN_ADDR_1=123 Any Street

MISC_VEN_ADDR_2

Opt

C! 30

MISC_VEN_ADDR_2=XXXX, where XXXX is the Address in in line 2 of the address block.

Enter this as Column Name =Address 2. Example: MISC_VEN_ADDR_2=PO Box 1234

MISC_VEN_ADDR_3

Opt

C! 30

MISC_VEN_ADDR_3=XXXX, where XXXX is the Address that appears in line 3 of the address block.

Enter this as Column Name =Address 3. Example: MISC_VEN_ADDR_3=C/O Accounts Payable Department

MISC_VEN_CITY

Opt

C! 20

MISC_VEN_CITY=XXXX, where XXXX is the City in the address block.

Enter this as Column Name =City. Example: MISC_VEN_CITY =Brookfield.

Required if a MISC_VEN_ADDR_NAME exists; otherwise, do not enter a value.

MISC_VEN_ST_CD

Opt

C! 4

MISC_VEN_ST_CD=XX, where XX is the name in the State field of the address block.

Enter this as Column Name =State. Example: MISC_VEN_ST_CD =WI

MISC_VEN_POSTAL_
CD

Opt

C! 10

MISC_VEN_POSTAL_CD=XXXX(-XXX), where XXXX(-XXX) is the Numeric Code in the Postal Code field of the address block.

Enter this as Column Name =Postal Code. Example: MISC_VEN_POSTAL_CD =53188

Required if you entered a vendor address name; otherwise, do not enter a value.

MISC_VEN_COUNTRY_CD

Opt

C! 3

MISC_VEN_COUNTRY_CD=XXXX, where XXXX is the Country in the address block.

Enter this as Column Name =Country. Example: MISC_VEN_COUNTRY_CD =USA

MISC_VEN_PHONE_
AREA_CD

Opt

C! 3

MISC_VEN_PHONE_AREA_CD=XXX, where XXX is the 3 digit Area Code in the address block.

Enter this as Column Name =Area Code. Example: MISC_VEN_PHONE_AREA_CD =262

MISC_VEN_PHONE_
NUM

Opt

C! 11

MISC_VEN_PHONE_NUM=XXXXXXX, where XXXXXXX is the 7 digit Phone number in the address block.

Enter this as Column Name =Phone Number. Example: MISC_VEN_PHONE_AREA_CD =5740505.

MISC_VEN_FAX_AREA_CD

Opt

C! 3

MISC_VEN_FAX_AREA_CD=XXX, where XXX is the 3 digit Fax number Area Code in the address block.

Enter this as Column Name =Area Code. Example: MISC_VEN_PHONE_AREA_CD =262

MISC_VEN_FAX_NUM

Opt

C! 11

MISC_VEN_FAX_NUM=XXXXXXX, where XXXXXXX is the 7 digit Fax number in the address block.

Enter this as Column Name =Phone Number. Example: MISC_VEN_FAX_AREA_CD =5741212.

MISC_VEN_WWW_
ADDR

Opt

C! 100

MISC_VEN_WWW_ADDR=XXXX, where XXXX is the web address.

Enter this as Column Name = web address. Example: MISC_VEN_WWW_ADDR=www.supplier.com.

MISC_VEN_ADDL_
CHECK_LINE_1

Opt

C! 50

MISC_VEN_ADDL_CHECK_LINE_1=XXXX, where XXXX is the line that prints below the vendor address on the AP check.

Enter this as Column Name =Line 1 Information. Example: MISC_VEN_ADDL_CHECK_LINE_1=Attention: Ms. M. Berkly

MISC_VEN_ADDL_
CHECK_LINE_2

Opt

C! 50

MISC_VEN_ADDL_CHECK_LINE_2=XXXX, where XXXX is the line that prints below the vendor address on the AP check.

Enter this as Column Name =Line 2 Information. Example: MISC_VEN_ADDL_CHECK_LINE_2=Account #1234567.

WH_ST_CD

Opt

C 4

The withholding state’s code.

ST_WH_PCT

Opt

F 8.5

The percent to withhold for the state. Must be non-zero or null. PENTA only allows entry in this column if the FORM_1099_ST_CD has a valid value.

ST_WH_ACCT_NUM

Opt

X

The accrual account for the state withholding.

Required if a ST_WH_PCT exists; otherwise, do not enter a value.

ST_WH_VEN_ID

Opt

X

The vendor that receives the state withholding payment.

Required if a ST_WH_PCT exists; otherwise, do not enter a value

FED_WH_PCT

Opt

F 8.5

The percent to withhold for Federal withholding.

Must be non-zero or null.

FED_WH_ACCT_NUM

Opt

X

The accrual account for the federal withholding.

Required if the FED_WH_PCT has a non-zero value; otherwise, do not enter a value.

FED_WH_VEN_ID

Opt

X

The vendor you pay federal withholding to.

Required if the FED_WH_PCT has a non-zero value; otherwise, do not enter a value.

FREIGHT_AMT

Opt

F 15.2

PENTA only uses Freight Amount to determine the Invoice Basis Amount.

AP_STAT_CD

Opt

C! 1

Indicates the Pay Status of the Invoice. Possible values are: A (Active & available for payment) and H (Hold upon distribution, not available for payment).

If you enter nothing, this defaults according to System Option 87: If the System Option is N and the Vendor Status is H (hold), Status defaults as H. Otherwise, this defaults as A.

Error occurs if System Option 87 is Y, this value is H, and there is no HOLD record for the document.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

This defaults as the current date. This column contains the date that the record is marked as modified in the database once the process initiates and completes.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Vendor’s Invoice Number. This must be unique.

If the Invoice Number and Vendor Id match an invoice that has a void status of Y, PENTA rejects this invoice (INTR_AP_DOC and all associated INTR_AP_JOB and INTR_AP_ACCT rows).

VEN_ID

Req

X

The Vendor Id associated with the invoice. This must be a vendor with an Active or Hold status. The Vendor type cannot be Miscellaneous and the Vendor Class must be set up as a Supplier.

If System Option 109 is Y, the Vendor Id cannot be the same as the Vendor Id assigned to the AP OU.

HOLD_CD

Req

C! 3

Id of the Hold Reason currently against the Invoice.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_DATE

Opt

D

This defaults as the current date. This column contains the date that the record is marked as modified in the database once the process initiates and completes.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

Id of the Invoice’s vendor.

JURIS_ID

Req

C 10

Id of the taxing authority.

CONSOL_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. This tax rate is the same for sales and use tax and PENTA applies it in all taxable situations.

SALES_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it in when this type applies.

USE_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it when this type applies.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

Id of the vendor on the invoice.

AMT

Req

F 15.2

The Payment Amount applied to the advance.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

JURIS_ID

Req

C 10

Id of the taxing authority.

CONSOL_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. This tax rate is the same for sales and use tax and PENTA applies it in all taxable situations.

SALES_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it when that type is applicable.

USE_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it when that tax type applies.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

Must match the vendor Id in the document row.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within request/vendor/invoice.

FA_ID

Opt

X

If Fixed Asset Id is not null, Fixed Asset Expense Category cannot be null. PENTA checks to ensure the following:

• The Fixed Asset is active,

• You have access to post charges to the OU associated with this asset, and

• The Fixed Asset belongs to the same parent OU as the OU on the INTR_AP_DOC record.

FA_EXP_CAT_NUM

Opt

I 3

PENTA checks to insure that the expense category is active and associated with the asset’s class in the Asset Class Information window.

DESCR

Req

C 30

If System Option 104 is Y, the default is the vendor name of the Vendor Id from the INTR_AP_DOC row. If System Option 104 is N, there is no default.

AMT

Req

F 15.2

Enter a value other than zero.

CR_ACCT_NUM

Req

X

This must be an active account with an edit rule of AP.

If System Option 109 is Y, the default is the:

• Vendor/OU inter-company AP account number.

• OU’s inter-company AP account number.

If System Option 44 is Y, the currency assigned to the account must equal the Source Currency from the INTR_AP_DOC row. If the account does not have a currency, then the currency of the job’s OU must equal the Source Currency from the INTR_AP_DOC row. The default is the AP account of the Source Currency Id.

If System Options 109 and 44 are N, the default is the Job Type’s AP account number.

If System Option 89 is Y and the user type is not H (home office), this column must be blank or null.

EXCHANGE_RATE

Opt

F 12.6

Must be greater than zero. If the job’s currency is the same as the Source Currency Id, this column must be 1.0.

Entry is required if System Option 44 is Y; otherwise, do not enter a value.

The default is:

• The job’s exchange rate (from the INTR_AP_DOC row).

• The rate necessary to change between the Source Currency Id and the job’s currency.

• A rate of 1.0.

FORM_ID

Opt

C! 8

The default is the Form Id for the Source Currency Id. The User Id must have authorization to use this Check Form.

Required if System Option 75’s value is 3; otherwise, do not enter a value.

If System Option 155’s value is Y, the Check Form type may be AP or GN. If System Option 155’s value is N, the Check Form type must be AP.

If System Option 44’s value is Y, the currency of the Check Form must be the same as Source Currency Id.

If System Option 89’s value is Y and the user type is not H (home office), do not enter a value.

TAX_EXEMPT_
REASON_CD

Opt

C! 3

The defaults are:

• Costcode tax exempt reason code.

• Job’s tax-exempt reason code.

If System Option 152’s value is N, this column must be blank or null.

If Tax Exempt Reason Code on the INTR_AP_DOC row has a value, this column must be one of the defaults.

The default is stored in PENTA, but the document reason code overrides the distribution reason code; you cannot manually override it.

TAX_CERTIFICATE

Opt

C 15

The defaults are:

• Costcode tax certificate.

• Job’s tax certificate.

If System Option 152 is N, this column must be blank or null.

If the Tax Exempt Certificate Id on the INTR_AP_DOC row has a value, this column must be one of the defaults.

The default is stored in PENTA, but the Document certificate overrides the distribution certificate. You cannot manually override it.

EARN_CD

Opt

I 2

1099 Earnings Code.

TRANX_REF_ID

Opt

C 15

PENTA marks job cost and billing transactions within the interface files with this Transaction Reference Id. This enables your external application to perform functions (e.g., billing and profit analysis) by whatever grouping this Id represents.

FORM_1099_ST_CD

Opt

C 4

The 1099 State Code

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records that PENTA should process together.

RECORD_COUNT

Req

I 10

Each batch includes a count of the rows (header and detail) within the INTR_AP_HDR and INTR_AP_DTL tables for the INTR_RQST_ID. This number must be greater than zero.

If the number in the header row differs from the number read by PENTA, no update occurs and PENTA rejects the entire file.

BATCH_NUM

Req

I 10

Id of the Batch.

INVOICE_AMT

Req

F 15.2

The total amount of all invoices in this INTR_RQST_ID. PENTA uses this amount to determine if the batch is in balance when viewed in the PENTA Accounts Payable windows.

INVOICE_UNITS

Opt

F 12.3

The total number of units of all invoices in this INTR_RQST_ID. PENTA uses this number to determine if the batch is in balance when viewed in the PENTA Accounts Payable windows.

TRANX_REF_ID

Opt

C 15

PENTA marks job cost and billing transactions within the interface files with this Transaction Reference Id. This enables your external application to perform functions (e.g., billing and profit analysis) by whatever grouping this Id represents.

DEF_CHK_FORM_ID

Opt

C! 8

The Document tab’s default Check Form. You establish the overriding default at the Organizational Units or Currency level. Default Check Forms you enter in the Vendor Information window override this default.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

Must match the vendor Id in the document row.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within request/vendor/invoice.

JOB_ID

Req

X

Must be an active job.

• If System Option 69 is Y, the job must not be closed as of the Posting Date.

• If System Option 44 is Y and the job’s currency is not the same as the Source Currency Id, there must be an exchange rate between the two currencies.

• If System Option 107 is Y and the job OU Id is the same as the balance sheet OU Id, the balance sheet OU Id must be the same as the AP OU Id in the INTR_AP_DOC detail row.

COST_TYPE_CD

Req

C! 4

Must be an active Cost Type associated with the job, and the Cost Type’s All OU code must be A, or the OU associated with the Cost Type is the same as the job’s OU.

CC

Req

X

Must be an active Costcode. If Costcode validation for the Job Id is Y, this must be a valid Costcode for the job.

ITEM_NUM

Opt

X

If System Option 22 is 2, PENTA refers to the Item Number as Tag Number in error messages.

If System Option 122 is Y, the Item Number must be associated with the job.

DESCR

Req

C 30

If System Option 104 is Y, the default is the vendor name of the Vendor Id from the INTR_AP_DOC row. If System Option 104 is N, there is no default.

AMT

Req

F 15.2

Enter a value other than zero.

UNITS

Opt

F 12.3

The number of units used on the job.

Enter a value greater than zero.

PAY_RQST_NUM

Opt

C 15

Defaults as the DOC record’s Pay Request Number.

Required if System Option 87 is Y and System Option 124 is 16, 20, 24, or 28; otherwise, do not enter a value.

If System Option 148 is Y, Pay Request Number must be in digits (rather than characters).

CR_ACCT_NUM

Req

X

This must be an active account with an edit rule of AP.

If System Option 109 is Y, the default is the:

• Vendor/OU inter-company AP account number.

• OU’s inter-company AP account number.

If System Option 44 is Y, the currency assigned to the account must equal the Source Currency from the INTR_AP_DOC row. If the account does not have a currency, then the currency of the job’s OU must equal the Source Currency from the INTR_AP_DOC row. The default is the AP account of the Source Currency Id.

If System Options 109 and 44 are set to N, the default is the Job Type’s AP account number.

If System Option 89 is Y and the user type is not H (home office), this column must be blank or null.

EXCHANGE_RATE

Opt

F 12.6

Must be greater than zero. If the job’s currency is the same as the Source Currency Id, this column must be 1.0.

Required if System Option 44 is Y; otherwise, do not enter a value.

The default is:

• The job’s exchange rate (from the INTR_AP_DOC row).

• The rate necessary to change between the Source Currency Id and the job’s currency.

• A rate of 1.0.

FORM_ID

Opt

C! 8

The default is the Form Id for the Source Currency Id. The User Id must have authorization to use this Check Form.

Required if System Option 75 is 3; otherwise, do not enter a value.

If System Option 155 is Y, the Check Form type may be AP or GN. If System Option 155 is N, the Check Form type must be AP.

If System Option 44 is Y, the currency of the Check Form must be the same as Source Currency Id.

If System Option 89 is Y and the user type is not H (home office), do not enter a value.

TAX_EXEMPT_
REASON_CD

Opt

C! 3

The defaults are:

• Costcode tax exempt reason code.

• Job’s tax exempt reason code.

If System Option 152 is N, this column must be blank or null.

If Tax Exempt Reason Code on the INTR_AP_DOC row has a value, this column must be one of the defaults.

The default is stored in PENTA, but the Document reason code overrides the distribution reason code; you cannot manually override it.

TAX_CERTIFICATE

Opt

C 15

The defaults are:

• Costcode tax certificate.

• Job’s tax certificate.

If System Option 152 is N, this column must be blank or null.

If the Tax Exempt Certificate Id on the INTR_AP_DOC row has a value, this column must be one of the defaults.

The default is stored in PENTA, but the document certificate overrides the distribution certificate. You cannot manually override it.

EARN_CD

Opt

I 2

1099 Earnings Code.

TRANX_REF_ID

Opt

C 15

PENTA marks job cost and billing transactions within the interface files with this Transaction Reference Id. This enables your external application to perform functions (e.g., billing and profit analysis) by whatever grouping this Id represents.

FORM_1099_ST_CD

Opt

C 4

The 1099 State Code

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA processes together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

JURIS_ID

Req

C 10

Id of the taxing authority.

CONSOL_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. This tax rate is the same for sales and use tax and PENTA applies it in all taxable situations.

SALES_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it when that tax type applies.

USE_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it when that tax type applies.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

CUS_REF_CD

Req

C 15

ID referring to Customer-specific information.

CUS_REF_VALUE

Opt

C 30

The value for the associated Customer Reference Code.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

PO_OU_ID

Req

X

OU that issued the purchase order.

PO_NUM

Req

X

Id of the purchase order.

VEN_PROD_ID

Opt

C 26

The vendor associated with the purchase order.

PO_LINE_NUM

Opt

I 9

PENTA validates this against the PO_DTL table.

UNITS

Opt

F 12.3

Units associated with the line item, invoiced to date.

UP

Opt

F 12.3

The unit’s price.

AMT

Opt

F 15.2

Lump sum amount of the amount invoiced to date.

JOB_ID

Req

X

Enter an active job.

If System Option 69 is Y, the job must not be closed as of the Posting Date.

If System Option 44 is Y and the job’s currency is not the same as the Source Currency Id, there must be an exchange rate between the two currencies.

If System Option 107 is Y and the job OU Id is the same as the balance sheet OU Id, the balance sheet OU Id must be the same as the AP OU Id in the DOC Detail Record.

COST_TYPE_CD

Opt

C! 4

Must be an active Cost Type associated with the job, and the Cost Type’s All OU code must be A, or the OU associated with the Cost Type is the same as the job’s OU.

CC

Opt

X

Enter an active Costcode.

If Costcode validation for the Job Id is Y, enter a valid Costcode for the Job.

DR_OU_ID

Opt

X

The Id of the OU associated with the debit.

DR_ACCT_NUM

Opt

X

The debit account number.

FA_ID

Opt

X

If the Fixed Asset Id has a value, the Fixed Asset Expense Category must have a value. PENTA checks to ensure the following are true:

• The Fixed Asset is active.

• You have access to post charges to the OU associated with this asset.

• The Fixed Asset belongs to the same parent OU as the OU on the INTR_AP_DOC record.

FA_EXP_CAT_NUM

Opt

I 3

PENTA checks to insure that the expense category is active and associated with the asset’s class in the Classes window

CR_ACCT_NUM

Req

X

The payable account to which you want to post the distribution.

EXCHANGE_RATE

Opt

F 12.6

Must be greater than zero. If the job’s currency is the same as the Source Currency Id, this column must be 1.0.

Required if System Option 44 is Y; otherwise, do not enter a value.

The default is:

• The job’s exchange rate (from the DOC record).

• The rate necessary to change between the Source Currency Id and the job’s currency.

• A rate of 1.0.

TAX_EXEMPT_
REASON_CD

Opt

C! 3

The defaults are:

• Costcode tax exempt reason code.

• Job’s tax-exempt reason code.

If System Option 152 is N, this column must be blank or null. If Tax Exempt Reason Code on the INTR_AP_DOC row has a value, this column must be one of the defaults. The default is stored in PENTA, but the document reason code overrides the distribution reason code; you cannot manually override it.

TAX_CERTIFICATE

Opt

C 15

The defaults are:

• Costcode tax certificate.

• Job’s tax certificate.

If System Option 152 is N, this column must be blank or null. If the Tax Exempt Certificate Id on the INTR_AP_DOC row has a value, this column must be one of the defaults. The default is stored in PENTA, but the Document certificate overrides the distribution certificate. You cannot manually override it.

EARN_CD

Opt

I 3

1099 Earnings Code

PAY_RQST_NUM

Opt

C 15

The Id of the pay request (progress billing) that the customer must pay before you pay the Vendor for this Invoice.

FORM_ID

Opt

C! 8

The default is the Form Id of the following:

• DOC record

• Job

• AP OU Id

Required if System Option 75 is 2; otherwise, do not enter a value.

If System Option 155 is Y, the Check Form type may be AP or GN. If System Option 155 is N, the Check Form type must be AP.

If System Option 44 is Y, the currency of the Check Form must be the same as Source Currency Id.

If System Option 89 is Y and the user type is not H (home office), do not enter a value.

DESCR

Req

C 30

The description of the Purchase Order’s line item.

TRANX_REF_ID

Opt

C! 15

PENTA marks the interface files’ job cost and billing transactions with this Transaction Reference Id so your external application can perform functions (e.g., billing and profit analysis) by whatever grouping this Id represents.

FORM_1099_ST_CD

Opt

C! 4

1099 State Code.

WO_ID

Opt

C! 25

The work order to which you are charging the distribution.

WO_OU_ID

Opt

X

The organizational unit associated with the work order.

WO_COST_TYPE_CD

Opt

C! 4

The Cost Type to which you are charging the work order.

WO_CUS_LOC_CD

Opt

C 8

The Customer Location associated with the work order.

WO_CUS_EQ_ID

Opt

C! 15

The piece of customer equipment impacted by the work order’s distribution.

WO_TASK_ID

Opt

C! 10

The work order task to which you are charging the distribution.

WO_FA_ID

Opt

X

The fixed asset you are charging the distribution to when performing maintenance.

WO_FA_EXP_CAT_
NUM

Opt

I 3

The type of expense you are charging to the fixed assed.

WO_MAINT_SCHD_
NUM

Opt

I 6

The Maintenance Schedule associated with the customer equipment or the fixed asset.

WO_MAINT_
CONTRACT_ID

Opt

C! 15

The Maintenance Contract associated with the distribution.

RET_AMT

Opt

F 15.2

The amount you plan to withhold payment on when you pay the invoice.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

JURIS_ID

Req

C 10

Id of the taxing authority.

CONSOL_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. This tax rate is the same for sales and use tax and PENTA applies it in all taxable situations.

SALES_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it when that tax type applies.

USE_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it when that tax type applies.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

JOB_ID

Req

X

The Job Id.

SC_NUM

Req

X

The Subcontract number.

SC_LINE_NUM

Req

I 9

The Subcontract Line number.

DESCR

Req

C 30

The description of the Subcontract Line number.

AMT

Opt

F 15.2

The Distribution Amount.

UNITS

Opt

F 12.3

The number of Units.

UP

Opt

F 12.3

The Unit Price.

RET_AMT

Opt

F 15.2

The Retention Amount.

PAY_RQST_NUM

Opt

C 15

Defaults as the DOC record’s Pay Request Number.

Required if System Option 87 is Y, and System Option 124 is 8, 12, 24, or 28; otherwise, do not enter a value.

If System Option 148 is Y, Pay Request Number must be in digits (rather than characters).

EXCHANGE_RATE

Opt

F 12.6

Must be greater than zero. If the job’s currency is the same as the Source Currency Id, this column must be 1.0.

Required if System Option 44 is Y; otherwise, do not enter a value.

The default is:

• The job’s exchange rate (from the DOC record).

• The rate necessary to change between the Source Currency Id and the job’s currency.

• A rate of 1.0.

FORM_ID

Opt

C! 8

The default is the Form Id of the following:

• DOC record

• Job

• AP OU Id

Required if System Option 75 is 2; otherwise, do not enter a value.

If System Option 155 is Y, the Check Form type may be AP or GN. If System Option 155 is N, the Check Form type must be AP.

If System Option 44 is Y, the currency of the Check Form must be the same as Source Currency Id.

If System Option 89 is Y and the user type is not H (home office), do not enter a value.

CR_ACCT_NUM

Opt

X

Number of the account credited for the transaction.

EARN_CD

Opt

C 3

1099 Earnings Code

FORM_1099_ST_CD

Opt

C! 4

1099 State Code

TRANX_REF_ID

Opt

C! 15

PENTA marks job cost and billing transactions within the interface files with this Transaction Reference Id. This enables your external application to perform functions (e.g., billing and profit analysis) by whatever grouping this Id represents.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

WO_ID

Req

C! 25

The work order to which you are charging the current distribution.

WO_OU_ID

Opt

X

The OU associated with the work order’s distribution.

WO_COST_TYPE_CD

Req

C! 4

Must be an active Cost Type associated with the WO, and the Cost Type’s All OU code must be A, or the OU associated with the Cost Type is the same as the WO’s OU.

WO_CUS_LOC_CD

Opt

C 8

The customer location associated with the work order.

WO_CUS_EQ_ID

Opt

C! 15

The piece of customer equipment impacted by the work order’s distribution.

WO_TASK_ID

Opt

C! 10

The work order task to which you are charging the distribution.

WO_FA_ID

Opt

X

PENTA checks to insure the following:

• The Fixed Asset is active,

• You have access to post charges to the OU associated with this asset, and

• The Fixed Asset belongs to the same parent OU as the OU on the INTR_AP_DOC record.

WO_FA_EXP_CAT_
NUM

Opt

I 3

PENTA checks to insure that the expense category is active and associated with the asset’s class in the Classes window. You must enter an expense category if a Fixed Asset exists.

WO_MAINT_SCHD_
NUM

Opt

I 6

The maintenance schedule associated with the customer equipment or fixed asset.

WO_MAINT_CONTRACT_ID

Opt

C! 15

The maintenance contract associated with the distribution.

DESCR

Req

C 30

If System Option 104 is Y, the default is the vendor name of the Vendor Id from the INTR_AP_DOC row. If System Option 104 is N, there is no default.

AMT

Req

F 15.2

Enter a value other than zero.

CR_ACCT_NUM

Opt

X

Number of the account credited for the transaction.

EXCHANGE_RATE

Opt

F 12.6

Must be greater than zero. If the job’s currency is the same as the Source Currency Id, this column must be 1.0.

Required if System Option 44 is Y; otherwise, do not enter a value.

The default is:

• The WO’s exchange rate (from the DOC record).

• The rate necessary to change between the Source Currency Id and the WO’s currency.

• A rate of 1.0.

FORM_ID

Opt

C! 8

The default is the Form Id of the following:

• DOC record

• Job

• AP OU Id

Required if System Option 75 is 2; otherwise, do not enter a value.

If System Option 155 is Y, the Check Form type may be AP or GN. If System Option 155 is N, the Check Form type must be AP.

If System Option 44 is Y, the currency of the Check Form must be the same as Source Currency Id.

If System Option 89 is Y and the user type is not H (home office), do not enter a value.

TAX_EXEMPT_
REASON_CD

Opt

C! 3

The defaults are:

• Costcode tax exempt reason code.

• Job’s tax-exempt reason code.

If System Option 152 is N, do not enter a value.

If Tax Exempt Reason Code on the INTR_AP_DOC row has a value, this column must be one of the defaults.

The default is stored in PENTA, but the document reason code overrides the distribution reason code; you cannot manually override it.

TAX_CERTIFICATE

Opt

C 15

The defaults are:

• Costcode tax certificate.

• Job’s tax certificate.

If System Option 152 is N, this column must be blank or null.

If the Tax Exempt Certificate Id on the INTR_AP_DOC row has a value, this column must be one of the defaults.

The default is stored in PENTA, but the Document certificate overrides the distribution certificate. You cannot manually override it.

The tax Certificate should default as follows:

• From the Tax Exemption window.

• From the Document tab.

• From the WO.

• From the WO OU.

EARN_CD

Opt

C 3

1099 Earnings Code

FORM_1099_ST_CD

Opt

C 4

1099 State Code

TRANX_REF_ID

Opt

C! 15

PENTA marks job cost and billing transactions within the interface files with this Transaction Reference Id. This enables your external application to perform functions (e.g., billing and profit analysis) by whatever grouping this Id represents.

UNITS

Opt

F 12.3

Work Order units.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.

INTR_RQST_ID

Req

C! 13

The interface request value that you enter to initiate the interface process. The value must be consistent for all records PENTA should process together.

VEN_INVOICE_NUM

Req

C! 15

Must match the invoice number in the document row.

VEN_ID

Req

X

The invoice’s vendor.

SEQ_NUM

Req

I 10

Sequence number uniquely identifying this row within interface request.

JURIS_ID

Req

C 10

Id of the taxing authority.

CONSOL_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. This tax rate is the same for sales and use tax and PENTA applies in all taxable situations.

SALES_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it when that tax type applies.

USE_TAX_RATE

Opt

F 6.3

One of three tax types PENTA uses to determine whether a taxable transaction is sales tax or use tax. PENTA considers the tax rate sales or use tax and only uses it when that tax type applies.

RECORD_NUM

Opt

I 10

Do not assign this value. PENTA assigns this record number, which you can use to identify records with errors or warning messages.

USER_ID

Req

C 6

Id of the employee performing the load process. This user_id must exist in PENTA.

MODIFICATION_
DATE

Opt

D

Once the process completes, this displays the date PENTA marked the record as modified in the database. The current date is the default value.