储藏室

应收开票产生的会计科目：借：应收账款贷：应交税金贷：产品销售收入收款录入产生的会计科目：借：银行存款借：财务费用 银行手续费贷：预收货款收款核销产生的会计科目：借：预收货款 贷：应收账款

--收款 AR_RECEIPT_API_PUB--发票AR_INVOICE_API_PUB--下面是收款取消核销和收款冲销的程序包--收款冲销PROCEDURE MEW_AR_RECEIPT_REVERSE(P_RETCODE         OUT NUMBER                                  ,P_ERRBUF          O

CREATE OR REPLACE PACKAGE MEW_AR_RECEIPT_IMPORT2 IS  PROCEDURE INTERFACE_IMPORT(P_METHOD                 VARCHAR2                            ,P_BANK_NUM               VARCHAR2

CREATE OR REPLACE PACKAGE APPS.MEW_AR_INVOICE_TRC_PKG IS  /* =============================================================  *   Copyright (C) Panasonic Co., Ltd All rights reserved  * ==========

SELECT RCA.BILL_TO_CUSTOMER_ID      ,RCA.BILL_TO_SITE_USE_ID      ,RCA.BILL_TO_ADDRESS_ID      ,RCA.*  FROM RA_CUSTOMER_TRX_ALL       RCA      ,RA_CUSTOMER_TRX_LINES_ALL RCLA WHERE RCA.CUS

--应收发票主表SELECT *  FROM RA_CUSTOMER_TRX_ALL A WHERE A.TRX_NUMBER = '156640'   AND A.ORG_ID = 236;--应收发票行表SELECT B.EXTENDED_AMOUNT --不含税原币金额      ,B.EXTENDED_ACCTD_AMOUNT --不含税本币金额

SELECT ORDER_NUMBER      ,ORDER_TYPE      ,LINE_ID      ,CUSTOMER_TRX_ID      ,TRX_NUMBER      ,INVOICE_AMOUNT      ,BATCH_SOURCE      ,TRX_DATE  FROM OE_RA_CUSTOMER_TRX_V WHERE (ORD

--收款分类SELECT ROWID      ,ATTRIBUTE1      ,ATTRIBUTE10      ,ATTRIBUTE11      ,ATTRIBUTE12      ,ATTRIBUTE13      ,ATTRIBUTE14      ,ATTRIBUTE15      ,ATTRIBUTE2      ,ATTRIBUTE3