1.72 Accounting Export Upload Format

This topic provides detailed information on the Accounting Export Upload Format for segment identification numbers.

Accounting Export file will be exported in the back-end server only.

Table 1-209 Accounting Export Upload Format

Field Name	Description	Data Type	Length	Table Name
SEGMENTID	Segment ID	VARCHAR2	20	BULK_AETB_TXN_MASTER
SOURCECODE	Source Code	VARCHAR2	64	BULK_AETB_TXN_MASTER
SOURCEREF	Source reference number	VARCHAR2	140	BULK_AETB_TXN_MASTER
SOURCESEQNO	Source sequence number	VARCHAR2	64	BULK_AETB_TXN_MASTER
BRANCHCODE	Branch code	VARCHAR2	12	BULK_AETB_TXN_MASTER
FUNCTION_ID	Function ID	VARCHAR2	32	BULK_AETB_TXN_MASTER
ACTION_CODE	Action Code	VARCHAR2	64	BULK_AETB_TXN_MASTER
UPLOAD_ID	Upload ID	VARCHAR2	64	BULK_AETB_TXN_MASTER
MODULE	Module	VARCHAR2	8	BULK_AETB_TXN_MASTER
UNIQUEREFNUM	Unique reference number	VARCHAR2	64	BULK_AETB_TXN_MASTER
EXTERNALREFNO	External reference number	VARCHAR2	120	BULK_AETB_TXN_MASTER
STATUS	Status	VARCHAR2	4	BULK_AETB_TXN_MASTER
SEGMENTID	Segment ID	VARCHAR2	20	BULK_DETB_JRNL_TXN_UPL_DETAIL
SOURCE_CODE	Source code	VARCHAR2	64	BULK_DETB_JRNL_TXN_UPL_DETAIL
SOURCE_REF	Source reference number	VARCHAR2	140	BULK_DETB_JRNL_TXN_UPL_DETAIL
SOURCE_SEQ_NO	Source sequence number	VARCHAR2	64	BULK_DETB_JRNL_TXN_UPL_DETAIL
BRANCH_CODE	Branch code	VARCHAR2	12	BULK_DETB_JRNL_TXN_UPL_DETAIL
UNIQUEREFNO	Unique reference number	VARCHAR2	64	BULK_DETB_JRNL_TXN_UPL_DETAIL
EXTERNALREFNO	External reference number	VARCHAR2	120	BULK_DETB_JRNL_TXN_UPL_DETAIL
MODULE	Module	VARCHAR2	8	BULK_DETB_JRNL_TXN_UPL_DETAIL
EVENTSRNO	Event serial number	NUMBER	22	BULK_DETB_JRNL_TXN_UPL_DETAIL
EVENT	Event	VARCHAR2	16	BULK_DETB_JRNL_TXN_UPL_DETAIL
AMTBLOCKNO	Amount block number	VARCHAR2	140	BULK_DETB_JRNL_TXN_UPL_DETAIL
ACBRANCH	Branch	VARCHAR2	12	BULK_DETB_JRNL_TXN_UPL_DETAIL
ACNO	Account number	VARCHAR2	34	BULK_DETB_JRNL_TXN_UPL_DETAIL
ACCCY	Account currency	VARCHAR2	12	BULK_DETB_JRNL_TXN_UPL_DETAIL
FORCEPOST	Force post	VARCHAR2	40	BULK_DETB_JRNL_TXN_UPL_DETAIL
DRCRIND	Debit Credit indicator	CHAR	4	BULK_DETB_JRNL_TXN_UPL_DETAIL
TRNCODE	Transaction code	VARCHAR2	12	BULK_DETB_JRNL_TXN_UPL_DETAIL
AMOUNTTAG	Amount tag	VARCHAR2	140	BULK_DETB_JRNL_TXN_UPL_DETAIL
FCYAMOUNT	Foreign currency amount	NUMBER	22	BULK_DETB_JRNL_TXN_UPL_DETAIL
EXCHRATE	Exchange rate	NUMBER	22	BULK_DETB_JRNL_TXN_UPL_DETAIL
LCYAMOUNT	Local currency amount	NUMBER	22	BULK_DETB_JRNL_TXN_UPL_DETAIL
RELATEDCUSTOMER	Related customer	VARCHAR2	36	BULK_DETB_JRNL_TXN_UPL_DETAIL
RELATEDACCOUNT	Related account	VARCHAR2	80	BULK_DETB_JRNL_TXN_UPL_DETAIL
RELATEDREFERENCE	Related reference	VARCHAR2	64	BULK_DETB_JRNL_TXN_UPL_DETAIL
TRNDT	Transaction details	DATE	7	BULK_DETB_JRNL_TXN_UPL_DETAIL
VALUEDT	Value details	DATE	7	BULK_DETB_JRNL_TXN_UPL_DETAIL
INSTRUMENTCODE	-	VARCHAR2	64	BULK_DETB_JRNL_TXN_UPL_DETAIL
MISHEAD	Instrument code	VARCHAR2	36	BULK_DETB_JRNL_TXN_UPL_DETAIL
PRODUCT	Product	VARCHAR2	16	BULK_DETB_JRNL_TXN_UPL_DETAIL
REMARKS	Remarks	VARCHAR2	140	BULK_DETB_JRNL_TXN_UPL_DETAIL
STATUS	Status	VARCHAR2	4	BULK_DETB_JRNL_TXN_UPL_DETAIL