...
(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 |
...
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_ |
...
tm_stamp timestamp 8 8 SQL timestamp
...
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 |
...
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_ |
...
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
...