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
...
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 |
|---|
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 Data Type Length 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
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 | Data Type | Length | 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 a CR/LF.
Name |
|---|
...
Length | Description |
|---|
------ ------ ---------------------------------------------------
Record 1 'H' AP Check Record - Header
Check Number 10 Check Number
Vendor Code 8 Vendor Number
...
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)Column
Column | Data |
|---|
...
------------------- ---------- ------ ------ ------ -----------------------------------
vendor_code char 10 10 Vendor Code
vendor_alias char 10 10 Vendor Alias
vendor_name char 100 100 Vendor Name
...
Type | Length | Prec | Scale | Description | |
|---|---|---|---|---|---|
vendor_code | char | 10 | 10 | Vendor Code | |
vendor_alias | char | 10 | 10 | Vendor Alias | |
vendor_name | char | 100 | 100 | Vendor Name | |
address_1 | char | 80 | 80 | 1st Line of Vendor Address | |
address_ |
...
2 | char | 80 | 80 | 2nd Line of Vendor Address | |
address_ |
...
3 | char | 80 | 80 | 3rd Line of Vendor Address |
...
city | char | 40 | 40 | Vendor City |
state char 4 4 Vendor State
...
state | char | 4 | 4 | Vendor State | |
country | char | 24 | 24 | Vendor Country | |
postal_ |
...
code | char | 20 | 20 | Vendor Postal Code |
...
phone char 16 16 Vendor Phone
...
phone | char | 16 | 16 | Vendor Phone | |
telex | char | 16 | 16 | Null | |
fed_tax_ |
...
id | char | 25 | 25 | Federal Tax ID | |
vendor_ |
...
id | int | 4 | 10 | ID from VendorMaster Table | |
currency_ |
...
code | char | 3 | 3 | USD or CAD | |
tm_ |
...
...
stamp | timestamp | 8 | 8 | SQL timestamp |
ASCII Delimited Format
vendor_ |
...
code | char | 10 | PrismCore Vendor Code |
vendor_alias |
...
char | 10 | Alias from Vendor Maintenance | |
vendor_ |
...
name | char | 100 | Vendor Name |
address_ |
...
1 | char | 80 | 1st Line of Vendor Address |
address_ |
...
2 | char | 80 | 2nd Line of Vendor Address |
address_ |
...
3 | char | 80 | 3rd Line of Vendor Address |
...
city | char | 40 | Vendor City |
...
state char 4 Vendor State
...
state | char | 4 | Vendor State |
country | char | 24 | Vendor Country |
postal_ |
...
code | char | 20 | Vendor Postal Code |
phone char 16 Vendor Phone
...
phone | char | 16 | Vendor Phone |
telex | char | 16 | Blank Field |
fed_tax_ |
...
id | char | 25 | Federal Tax ID |
currency_code |
...
char | 3 | USD or CAD |
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_vendor_exports>
PRISM Format for AP Vendor 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 a CR/LF.
Name Length Description
------ ------ ---------------------------------------------------
Record 1 'V' AP Vendor Record - Header
Vendor Number 8 Vendor Number
Vendor Name 25 Vendor Name
Address 1 25 Address 1
Address 2 25 Address 2
City 15 City
State 2 State
Postal Code 10 Postal Code
Phone 14 Phone
Fed ID 11 Fed ID
Telex 15 Telex
Alias 10 Alias
Name | Length | Description |
|---|---|---|
Record | 1 | 'V' AP Vendor Record - Header |
Vendor Number | 8 | Vendor Number |
Vendor Name | 25 | Vendor Name |
Address 1 | 25 | Address 1 |
Address 2 | 25 | Address 2 |
City | 15 | City |
State | 2 | State |
Postal Code | 10 | Postal Code |
Phone | 14 | Phone |
Fed ID | 11 | Fed ID |
Telex | 15 | Telex |
Alias | 10 | Alias |
AP Invoice Export
Exports invoice totals by GL code to third-party applications.
PrismCore Export_AP_Invoice Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)
Column Data Type Length Prec Scale Description
------------------- ---------- ------ ------ ------ ---------------------------------
invoice_id int 4 10 0 Index Key
check_number char 25 25 Null
invoice_number char 25 25 Invoice Number
vendor_code char 25 25 Vendor Code
voucher_number char 25 25 Voucher Number
invoice_date datetime 8 23 3 Invoice Date
due_date datetime 8 23 3
Column | Data Type | Length | Prec | Scale | Description |
|---|---|---|---|---|---|
invoice_id | int | 4 | 10 | 0 | Index Key |
check_number | char | 25 | 25 | Null | |
invoice_number | char | 25 | 25 | Invoice Number | |
vendor_code | char | 25 | 25 | Vendor Code | |
voucher_number | char | 25 | 25 | Voucher Number | |
invoice_date | datetime | 8 | 23 | 3 | Invoice Date |
due_date | datetime | 8 | 23 | 3 | Invoice Due Date |
tot_invoice_amount_ |
...
paid | money | 8 | 19 | 4 | Total Paid on Invoice |
tot_invoice_ |
...
amount | money | 8 | 19 | 4 | 0 |
tot_invoice_ |
...
cost | money | 8 | 19 | 4 | Total Cost on Invoice |
tot_invoice_ |
...
retail | money | 8 | 19 | 4 | 0 |
tot_invoice_ |
...
fees | money | 8 | 19 | 4 | Total Fees from ICS Invoice |
tot_invoice_ |
...
credit | money | 8 | 19 | 4 | Total Credit from ICS Invoice |
tot_invoice_ |
...
GST | money | 8 | 19 | 4 | GST Tax Amount from ICS Invoice |
tot_invoice_ |
...
PST | money | 8 | 19 | 4 | PST Tax Amount from ICS Invoice |
tot_invoice_ |
...
payshort | money | 8 | 19 | 4 | Pay Short Amount on Invoice |
tot_invoice_frt_payshort |
...
money | 8 | 19 | 4 | Pay Short from Freight Invoice | |
tot_invoice_ |
...
discount | money | 8 | 19 | 4 | Total Invoice Discount |
tot_invoice_credit_taken |
...
money | 8 | 19 | 4 | 0 | |
tot_invoice_discount_taken |
...
money | 8 | 19 | 4 | Discount Issued on Check | |
tot_invoice_ |
...
freight | money | 8 | 19 | 4 | Total Freight on the ICS Invoice |
b_ |
...
freight | tinyint | 1 | 3 | 0 | 0=Regular Invoice,1=Special Inv. |
currency_ |
...
code | char | 3 | 3 | USD or CAD | |
exch_ |
...
tm_stamp timestamp 8 8 SQL timestamp
rate | decimal | 9 | 10 | 8 | Exchange rate |
tm_stamp | timestamp | 8 | 8 | SQL timestamp |
ASCII Delimited Format
Line number |
...
int | 4 | Links to detail Line Number | |
Invoice |
...
number | char | 25 | Invoice Number |
Vendor |
...
code | char | 25 | Vendor Code |
Voucher |
...
number | char | 25 | Voucher Number |
Invoice |
...
date | datetime | 8 | Invoice Date |
Due |
...
date | datetime | 8 | Invoice Due Date |
Amount |
...
Paid | money | 8 | Total Paid on Invoice |
...
Amount | money | 8 | Will be 0 |
...
Cost | money | 8 | Total Cost on Invoice |
...
Retail | money | 8 | Will be 0 |
Fees |
...
Amount | money | 8 | Total Fees from ICS Invoice |
Credit |
...
Amount | money | 8 | Total Credit from ICS Invoice |
GST |
...
Amount | money | 8 | GST Tax Amount from ICS Invoice |
PST |
...
Amount | money | 8 | PST Tax Amount from ICS Invoice |
Pay Short |
...
Amount | money | 8 | Pay Short Amount on Invoice |
Freight Pay Short Amt |
...
money | 8 | Pay Short from Freight Invoice | |
Invoice |
...
Discount | money | 8 | Total Invoice Discount |
Credit |
...
Taken | money | 8 | Will be 0 |
Invoice Disc |
...
Taken | money | 8 | Discount Issued on Check |
Invoice |
...
Freight | money | 8 | Total Freight on the ICS Invoice |
Special |
...
Invoice | 1 | 0=Regular Invoice,1=Special Invoice. | |
Currency |
...
code | char | 3 | USD or CAD |
Exchange |
...
Rate | decimal | 9 | Exchange rate used |
...
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_invoice_exports>
PRISM Format for AP Invoice 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, except there are two tildes (~~) between
...
invoice amount and retail amount.
...
This is similar to PRISM Format for AP Credit Export.
...
All records end in a CR/LF.
Name Length Description
------ ------ ---------------------------------------------------
Record 1 'I' AP Invoice Record - Header
GL Account 25 GL Account
GL Description 30 GL Description
Invoice Number 15 Invoice Number
...
Name | Length | Description |
|---|---|---|
Record | 1 | 'I' AP Invoice Record - Header |
GL Account | 25 | GL Account |
GL Description | 30 | GL Description |
Invoice Number | 15 | Invoice Number |
Invoice Date | 8 | Invoice Date 99/99/99 |
Due |
...
Date | 8 | Due Date 99/99/99 |
PO Number |
...
| 10 | PO Number (not required) |
...
Amount | 10 |
...
Invoice Amount |
...
Retail | 10 | Retail Amount |
...
Voucher | 10 | Voucher Number |
Store |
...
ID | 3 | Store ID |
Freight |
...
Flag | 1 | Freight Flag (‘Y’ or ‘N’) |
...
AP Invoice Detail Export
Exports invoice detail totals by GL code to third-party applications.
PrismCore Export_AP_Invoice_Detail Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)Column
Column | Data |
|---|
...
------------------- ---------- ------ ------ ------ -----------------------------------
invoice_dtl_id int 4 10 0 Index Key
invoice_id int 4 10 0 Invoice ID of header record
invoice_number char 25 25 Invoice Number
voucher_number char 25 25 Voucher Number
check_number char 25 25 Null
gl_code char 25 25 GL code for record
gl_description char 80 80 GL Description
invoice_amount money 8 19 4 Item Invoice Amount
invoice_retail money 8 19 4 Item Retail Amount
invoice_paid money 8 19 4 Item Paid Amount
discount_amount money 8 19 4 Item Discount Amount
discount_taken money 8 19 4 Item Discount Taken
...
Type | Length | Prec | Scale | Description | |
|---|---|---|---|---|---|
invoice_dtl_id | int | 4 | 10 | 0 | Index Key |
invoice_id | int | 4 | 10 | 0 | Invoice ID of header record |
invoice_number | char | 25 | 25 | Invoice Number | |
voucher_number | char | 25 | 25 | Voucher Number | |
check_number | char | 25 | 25 | Null | |
gl_code | char | 25 | 25 | GL code for record | |
gl_description | char | 80 | 80 | GL Description | |
invoice_amount | money | 8 | 19 | 4 | Item Invoice Amount |
invoice_retail | money | 8 | 19 | 4 | Item Retail Amount |
invoice_paid | money | 8 | 19 | 4 | Item Paid Amount |
discount_amount | money | 8 | 19 | 4 | Item Discount Amount |
discount_taken | money | 8 | 19 | 4 | Item Discount Taken |
payshort_amount | money | 8 | 19 | 4 | Item Pay/Short Amount |
store_ |
...
id | int | 4 | 10 | 0 | POSID |
tm_ |
...
stamp | timestamp | 8 | 8 | SQL timestamp |
...
ASCII Delimited Format
Detail Line Number |
...
int | 3 | Line number of Item on Invoice | |
Line Number |
...
int | 3 | Line Number of Header Record | |
Invoice |
...
Number | char | 25 | Invoice Number |
Voucher |
...
Number | char | 25 | Voucher Number |
GL Code | char | 25 | GL Code for Item |
GL |
...
Description | char | 80 | Description of GL Code |
Invoice |
...
Amount | money | 8 | Amount on the Invoice |
Invoice |
...
Retail | money |
...
8 |
...
Retail Amount | |
Invoice |
...
Paid | money | 8 | Paid Amount |
Discount |
...
Amount | money | 8 | Discount Allowed |
Discount |
...
Taken | money | 8 | Discount Taken |
Pay Short |
...
Amount | money | 8 | Pay Short Amount |
Store |
...
Id | int | 4 | POSID for Store |
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_invoice_exports>
PRISM Format for AP Invoice Detail Export
There is no PRISM Format for AP Invoice Detail Export.
AP Credit Export
Exports credit totals by GL code to third-party applications.
PrismCore Export_AP_Credit Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)Column
Column | Data |
|---|
...
Type | Length |
|---|
...
------------------- ---------- ------ ------ ------ -----------------------------------
memo_id char 25 25 Index Key
...
Prec | Scale | Description | |||
|---|---|---|---|---|---|
memo_id | char | 25 | 25 | Index Key | |
memo_number | char | 25 | 25 | Credit Memo Number | |
vendor_ |
...
code | char | 10 | 10 | Vendor Code | |
voucher_ |
...
number | char | 25 | 25 | Voucher Number | |
check_number |
...
char | 25 | 25 | Check Number | ||
vend_check_ |
...
number | char | 25 | 25 | Null | |
credit_ |
...
date | datetime | 8 | 23 | 3 | Date/Time of Credit |
credit_ |
...
amount | money | 8 | 19 | 4 | Amount of Credit |
credit_retail | money | 8 | 19 | 4 | Retail Amount |
tot_credit_ |
...
used | money | 8 | 19 | 4 | Amount of Credit Used |
tot_check_ |
...
amount | money | 8 | 19 | 4 | Total Amount on Check |
tot_credit_ |
...
GST | money | 8 | 19 | 4 | Total GST tax Amount |
tot_credit_ |
...
PST | money | 8 | 19 | 4 | Total PST tax Amount |
currency_ |
...
code | char | 3 | 3 | USD or CAD | |
exch_ |
...
rate | decimal | 9 | 10 | 8 | Exchange Rate |
tm_ |
...
stamp | timestamp | 8 | 8 | SQL timestamp |
...
ASCII Delimited Format
Line number |
...
int | 3 | Links to detail Line Number | |
Credit Memo |
...
Vendor code char 10 vendor code
Voucher number char 25 voucher number
Check number char 25 check number
Credit date datetime 8 credit memo date
Amount money 8 amount of credit
Retail money 8 retail amount
...
number | char | 25 | credit memo number |
Vendor code | char | 10 | vendor code |
Voucher number | char | 25 | voucher number |
Check number | char | 25 | check number |
Credit date | datetime | 8 | credit memo date |
Amount | money | 8 | amount of credit |
Retail | money | 8 | retail amount |
Credit Used | money | 8 | amount of credit used |
Check |
...
amount | money | 8 | total amount on check |
...
GST | money | 8 | Total GST tax amount |
...
PST | money | 8 | Total PST tax amount |
Currency |
...
code | char | 3 | USD or CAD |
Exchange |
...
Rate | decimal | 9 | Exchange rate used |
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_credit_exports>
PRISM Format for AP Credit 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, except there are two tildes (~~) between request number and credit amount
...
This is similar to PRISM Format for AP Invoice Export.
...
All records end in a CR/LF.
Name Length Description
------ ------ ---------------------------------------------------
Record 1 'C' AP Credit Record - Header
GL Account 25 GL Account
GL Description 30 GL Description
Memo Number 15 Credit Memo Number
...
Name | Length | Description |
|---|---|---|
Record | 1 | 'C' AP Credit Record - Header |
GL Account | 25 | GL Account |
GL Description | 30 | GL Description |
Memo Number | 15 | Credit Memo Number |
Memo Date | 8 | Credit Memo Date 99/99/99 |
Request Number | 10 |
...
Credit Request Number (not required) | |
Amount |
...
10 |
...
Credit Amount | |
Retail |
...
10 |
...
Retail Amount |
...
Voucher | 10 |
...
Voucher Number | |
Store |
...
ID |
...
3 |
...
Store ID |
AP Credit Detail Export
Exports credit detail totals by GL code to third-party applications.
PrismCore Export_AP_Credit_Detail Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)
Column |
|---|
...
Data Type | Length |
|---|
...
------------------- ---------- ------ ------ ------ -----------------------------------
memo_dtl_id int 4 10 0 Index Key
memo_id int 4 10 0 Credit ID of header record
memo_number char 25 25 Credit Number
check_number char 25 25 Check Number
gl_code char 25 25 GL Code
gl_description char 80 80 GL Description
credit_amount money 8 19 4 Credit Amount
credit_retail money 8 19 4 Credit Retail Amount
credit_used money 8 19 4 Credit Used
store_id int 4 10 0 POSID
tm_stamp timestamp 8 8 SQL timestamp
...
Prec | Scale | Description | |||
|---|---|---|---|---|---|
memo_dtl_id | int | 4 | 10 | 0 | Index Key |
memo_id | int | 4 | 10 | 0 | Credit ID of header record |
memo_number | char | 25 | 25 | Credit Number | |
check_number | char | 25 | 25 | Check Number | |
gl_code | char | 25 | 25 | GL Code | |
gl_description | char | 80 | 80 | GL Description | |
credit_amount | money | 8 | 19 | 4 | Credit Amount |
credit_retail | money | 8 | 19 | 4 | Credit Retail Amount |
credit_used | money | 8 | 19 | 4 | Credit Used |
store_id | int | 4 | 10 | 0 | POSID |
tm_stamp | timestamp | 8 | 8 | SQL timestamp |
ASCII Delimited Format
Detail Line Number |
...
int | 3 | Line number of Item on Credit | |
Line Number |
...
int | 3 | Line Number of Header Record | |
Memo |
...
Number | char | 25 | Credit Number |
GL |
...
Code | char | 25 | GL Code for item |
GL |
...
Description | char | 80 | Description of GL code |
Credit |
...
Amount | money | 8 | Credit Amount |
Credit |
...
Retail | money | 8 | Credit Retail Amount |
Credit |
...
Paid | money | 8 | Credit Used |
Store |
...
Id | int | 4 | POSID for store |
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_credit_exports>
PRISM Format for AP Credit Detail Export
There is no PRISM Format for AP Credit Detail Export.
AP Discount Export
Exports discount totals by GL code to third-party applications
PrismCore Export_AP_Discount Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)
Column Data Type Length Prec Scale Description
------------------- ---------- ------ ------ ------ -----------------------------------
invoice_number char 25 25
gl_code char 25 25
gl_description char 80 80
invoice_date datetime 8 23 3
due_date datetime 8 23 3
discount_amount money 8 19 4
store_id int 4 10 0
b_freight tinyint 1 3 0
currency_code char 3 3 USD or CAD
exch_rate decimal 9 10 8
tm_stamp timestamp 8 8 SQL timestamp
discount totals by GL code to third-party applications
PrismCore Export_AP_Discount Table Names
(Use this for interfaces that bypass WPConsole and go directly to prism_trn)
Column | Data Type | Length | Prec | Scale | Description |
|---|---|---|---|---|---|
invoice_number | char | 25 | 25 | ||
gl_code | char | 25 | 25 | ||
gl_description | char | 80 | 80 | ||
invoice_date | datetime | 8 | 23 | 3 | |
due_date | datetime | 8 | 23 | 3 | |
discount_amount | money | 8 | 19 | 4 | |
store_id | int | 4 | 10 | 0 | |
b_freight | tinyint | 1 | 3 | 0 | |
currency_code | char | 3 | 3 | USD or CAD | |
exch_rate | decimal | 9 | 10 | 8 | |
tm_stamp | timestamp | 8 | 8 | SQL timestamp |
ASCII Formats
Not defined at this time, call R&D if needed.
XML Definition
Not defined at this time, call R&D if needed.
PRISM Format for AP Check Export
Not defined at this time, call R&D if needed.