AP Check Import
...
Allows third-party applications to set a comment on checks generated in the PrismCore A/P module.
...
AP Check Import does not import new checks into PrismCore.
...
PrismCore Import_AP_Checks Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)
Column |
|---|
...
Data |
|---|
...
------------------- ---------- ------ ------ ------ -----------------------------------
check_number char 25 25 Check Number
comment char 80 80 Comment to add
tm_stamp timestamp 8 8 SQL timestamp
ASCII Delimited Format
check_number char 25 Check Number should match to existing check
...
Type | Length | Prec | Scale | Description | |
|---|---|---|---|---|---|
check_number | char | 25 | 25 | Check Number | |
comment | char | 80 | 80 | Comment to add | |
tm_stamp | timestamp | 8 | 8 | SQL timestamp |
ASCII Delimited Format
check_number | char | 25 | Check Number should match to existing check |
comment | char | 80 | Comment that will be added to the check |
...
XML Definition
The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data. All attributes are CDATA #IMPLIED.
...
/>
</trn_ap_check_imports>
PRISM Format for AP Check Import
Note: Be careful while using PRISM formats, because some fields most likely be cut off, thus you may not get the result you want. For example, Check Number generally may contain up to 25 characters, but in PRISM format it can only contain up to 10 characters.
Name Length Description
------ ------ ---------------------------------------------------
Check Number 10 Check Number
Comment 70 Comment
AP Check Export
Exports check information to a third-party application. Generated by either the auto export or using a configured AP Export in PrismCore Admin.
PrismCore Export_AP_Checks Table Names
Name | Length | Description |
|---|---|---|
Check Number | 10 | Check Number |
Comment | 70 | Comment |
AP Check Export
Exports check information to a third-party application. Generated by either the auto export or using a configured AP Export in PrismCore Admin.
PrismCore Export_AP_Checks Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)Column
Column | Data |
|---|
...
Type | Length |
|---|
...
------------------- ---------- ------ ------ ------ -----------------------------------
check_number char 25 25 Check Number
vendor_code char 10 10 Vendor Code
check_date datetime 8 23 3 Check Date
check_amount money 8 19 4 Amount of check
discount_amount money 8 19 4 Discount Amount
credit_amount money 8 19 4 Credit Amount
store_id int 4 10 0 0
check_id int 4 10 0 Check Header ID
currency_code char 3 3 Null
exch_rate decimal 9 10 8 Null
tm_stamp datetime 8 23 3 SQL timestamp
ASCII Delimited Format
check_number char 25 Check Number
vendor_code char 10 Vendor Code
check_date datetime Date of Check
check_amount money Amount on Check
discount_amount money Discount on Check
credit_amount money Credit Amount on Check
store_id int 0
currency_code char Blank Field
exch_rate decimal Blank Field
Prec | Scale | Description | |||
|---|---|---|---|---|---|
check_number | char | 25 | 25 | Check Number | |
vendor_code | char | 10 | 10 | Vendor Code | |
check_date | datetime | 8 | 23 | 3 | Check Date |
check_amount | money | 8 | 19 | 4 | Amount of check |
discount_amount | money | 8 | 19 | 4 | Discount Amount |
credit_amount | money | 8 | 19 | 4 | Credit Amount |
store_id | int | 4 | 10 | 0 | 0 |
check_id | int | 4 | 10 | 0 | Check Header ID |
currency_code | char | 3 | 3 | Null | |
exch_rate | decimal | 9 | 10 | 8 | Null |
tm_stamp | datetime | 8 | 23 | 3 | SQL timestamp |
ASCII Delimited Format
check_number | char | 25 | Check Number |
vendor_code | char | 10 | Vendor Code |
check_date | datetime | Date of Check | |
check_amount | money | Amount on Check | |
discount_amount | money | Discount on Check | |
credit_amount | money | Credit Amount on Check | |
store_id | int | 0 | |
currency_code | char | Blank Field | |
exch_rate | decimal | Blank Field |
XML Definition
The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data. All attributes are CDATA #IMPLIED.
...
exch_rate=""
/>
trn_ap_check_exports>
PRISM Format for AP Check Export
...
All Dates are in MM/DD/YY format - (03/05/95).
...
All amounts have embedded decimal points
...
but no leading zeros - ( 10.23).
...
All fields have a tilde (~) between them
...
All records end in
...
Name Length Description
------ ------ ---------------------------------------------------
...
a CR/LF.
Name | Length | Description |
|---|---|---|
Record | 1 | 'H' AP Check Record - Header |
Check Number |
...
10 | Check Number | |
Vendor |
...
Code | 8 | Vendor Number |
Check |
...
Date | 8 | Check Date 99/99/99 |
...
Amount | 10 | Check Amount |
...
Discount | 10 | Discount Amount |
Credit |
...
10 |
...
Credit Amount |
AP Vendor Export
Exports vendor information for vendors that are used in check, invoice, credit or discount exports.
PrismCore Export_AP_Vendor Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)
...