[Home] [Help]
View: AX_IT_AR_CMAPPTRX_V
Product: | AX - Global Accounting Engine |
Description: | Use for Italian rules creation |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT RA.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CT.DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, CT.DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, CT.TRX_DATE TRX_DATE
, CT.TRX_NUMBER TRX_NUMBER
, RA.APPLIED_CUSTOMER_TRX_ID
FROM RA_CUSTOMER_TRX_ALL CT
, AR_RECEIVABLE_APPLICATIONS_ALL RA
WHERE CT.CUSTOMER_TRX_ID = RA.APPLIED_CUSTOMER_TRX_ID
AND RA.CUSTOMER_TRX_ID IS NOT NULL
Columns
Name |
CM_CUSTOMER_TRX_ID |
DOC_SEQUENCE_ID |
DOC_SEQUENCE_VALUE |
TRX_DATE |
TRX_NUMBER |
INVOICE_CUST_TRX_ID |