金蝶EAS常用表

select * from T_SCM_BillType where FName_L2 like ‘%委外%’ --单据类型表，查业务单据对应的表 102–销售出库单 330–应收单

select * from T_AR_VerificationBill --结算记录表

select * from T_AR_VerificationBillentry --FBillSubType 101–预收款 103–退预收款 2–销售发票 102–销售回款

select * from T_GL_Voucher --凭证表

select * from T_GL_VoucherEntry

select * from T_GL_VoucherAssistRecord --凭证辅助账

select * from T_CAS_ReceivingBill --收款单

select * from T_CAS_ReceivingBillEntry

select * from T_CAS_ReceivingBillType --收款单类型

select * from T_BD_AccountView --科目表

select * from T_CL_WriteOffGroup --销售发票核销记录主表

select * from T_CL_WriteOffRecord --销售发票核销记录明细

select * from T_IM_SaleIssueBill --销售出库

select * from T_IM_SaleIssueEntry --FBizTypeID(关联T_SCM_BizType) 210–普通销售 211–普通销售退货

fbasestatus --1 保存；2 提交； 4 审核 ；7 关闭