...
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
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
...
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.