Data Dictionary -- Advance Shipping Note

Srl. No.	Table Name	Comment
1	ASN_ASNDET_ASN_DETAIL	This is the Detail table which stores the Ref Doc information which is associated with the Asn Document.
2	ASN_ASNHDR_ASN_HEADER	This is the Header table which stores the Advance Shipping Note Information.
3	ASN_ASNROT_ASN_ROUTE_PLAN	This Table stores the Route information for a Asn Document.
4	ASN_PARAMETER_DETAILS	This is the Parameter Table for the ASN Component.

Table Name :	ASN_ASNDET_ASN_DETAIL
Comment :	This is the Detail table which stores the Ref Doc information which is associated with the Asn Document.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ASNDET_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the OU information in which the Asn Document is Created.	Yes
ASNDET_ASN_NO	_varchar_40	varchar(40)	No	This field holds the Asn Document Number.	Yes
ASNDET_REF_DOC	_varchar_5	varchar(5)	No	This field holds the type of the Ref Document which is associated with the Asn, PO - Purchase Order, RS - Release Slip, RO - Repair Order, LO - Loan Order, SCO - Subcontract Order	Yes
ASNDET_REF_DOC_NO	_varchar_40	varchar(40)	No	This Field holds the Ref Document Number which is associated with the Asn Number.	Yes
ASNDET_PART_NO	_varchar_40	varchar(40)	No	This field holds the Part No mapped to the Ref Doc no of the Asn Document.	Yes
ASNDET_QTY_IN_TRANSIT	_decimal_28_8	decimal(28)	Yes	This field holds the no of quantity of the Part in transit.	No
ASNDET_UOM	_varchar_10	varchar(10)	Yes	This field holds the Unit of measurement for the quantity of the Part which is mapped to the Ref Doc number.	No
ASNDET_PALETE_RACK_CONT	_varchar_40	varchar(40)	Yes	This holds the Palette/Rack/Container Number of the Part which is associated with the Ref Doc Number.	No
ASNDET_COMMENT	_varchar_255	varchar(255)	Yes	This field holds the comments about the Part which is mapped to the Ref Doc number.	No

Table Name :	ASN_ASNHDR_ASN_HEADER
Comment :	This is the Header table which stores the Advance Shipping Note Information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ASNHDR_OUINSTANCE	_decimal_10_0	decimal(10)	No	This field holds the OU information in which the Asn Document is Created.	Yes
ASNHDR_ASN_NO	_varchar_40	varchar(40)	No	This field holds the Asn Number.	Yes
ASNHDR_NUM_TYPE_NO	_varchar_5	varchar(5)	Yes	This Field Holds the Numbering Type of the Asn Number.	No
ASNHDR_ASN_DATE	_datetime_8	datetime(8)	Yes	This field holds the Asn Date.	No
ASNHDR_ASN_STATUS	_varchar_5	varchar(5)	Yes	This Field holds the Asn Status. "F" - "Fresh.	No
ASNHDR_SUPPLIER	_varchar_45	varchar(45)	Yes	This Field Holds the Supplier Number which is Associated with the Asn Number.	No
ASNHDR_SUPP_ASN_NO	_varchar_40	varchar(40)	Yes	Specifies the Supplier Asn Number.	No
ASNHDR_SUPPASN_DATE	_datetime_8	datetime(8)	Yes	Holds the Supplier Asn date.	No
ASNHDR_WAY_BILL_NO	_varchar_40	varchar(40)	Yes	Holds the Way bill number of the Advance Shipping Note.	No
ASNHDR_ASN_SENT_BY	_varchar_5	varchar(5)	Yes	Holds the information by which the Asn is Sent as "C " - "Carrier", "S" - "Supplier", "B" - "Blank"	No
ASNHDR_EXP_DATE_OF_DEL	_datetime_8	datetime(8)	Yes	Holds the Expected Date of Delivery for the Asn Number.	No
ASNHDR_CARRIER_AGENCY	_varchar_20	varchar(20)	Yes	Specifies the Carrier or Agency Number for the Asn Number.	No
ASNHDR_SHIPPED_BY	_varchar_25	Varchar(25)	Yes	Specifies the Shipping Method Associated with Asn Number.	No
ASNHDR_INCO_TERM	_varchar_150	varchar(150)	Yes	Holds the Inco Term which will be Associated with the Asn Number.	No
ASNHDR_ORIGIN	_varchar_256	varchar(256)	Yes	Holds the Origin information associated with a Asn Document.	No
ASNHDR_DESTINATION	_varchar_256	varchar(256)	Yes	Holds the Destination information associated with a Asn Document.	No
ASNHDR_INSURANCE_TERMS	_varchar_150	varchar(150)	Yes	Holds the Insurance Terms Associated with the Asn Number.	No
ASNHDR_INSURANCE_LIABILITY	_varchar_5	varchar(5)	Yes	Holds the Insurance Liability Associated with the Asn Number. "B" - "Blank", "SUP" - "Supplier", "SLF" - "Self", "OTH" - "Others".	No
ASNHDR_TRANS_SHIPMENT	_varchar_5	varchar(5)	Yes	Holds the Trans Shipment value as "Y" - "Yes" and "N"- No for a Asn Number, "B" - "Blank".	No
ASNHDR_SUPP_INVOICE_NO	_varchar_40	varchar(40)	Yes	Holds the Supplier Invoice Number associated with ASN Number.	No
ASNHDR_INVOICE_AMOUNT	_decimal_28_8	decimal(28)	Yes	Holds the Invoice Amount of the ASN Number.	No
ASNHDR_INVOICE_CURRENCY	_varchar_20	varchar(20)	Yes	Holds the Invoice Currency associated with the Invoice Amount of the Asn Number.	No
ASNHDR_FREIGHT_AMOUNT	_decimal_28_8	decimal(28)	Yes	Holds the Freight Amount Associated with the Asn Number.	No
ASNHDR_FREIGHT_CURRENCY	_varchar_20	varchar(20)	Yes	Holds the Freight Currency Associated with the Asn Number.	No
ASNHDR_CREATED_BY	_varchar_30	varchar(30)	Yes	Holds the Asn created User name.	No
ASNHDR_CREATEDDATE	_datetime_8	datetime(8)	Yes	Holds the Asn created Date.	No
ASNHDR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Holds the Asn Modified User name.	No
ASNHDR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Holds the modified Date of the Asn number.	No
ASNHDR_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Holds the timestamp value for the Asn Number.	No
asnhdr_waybill_date	udd_datetime1	datetime(8)	Yes	Holds the Way bill date of the Advance Shipping Note.	No

Table Name :	ASN_ASNROT_ASN_ROUTE_PLAN
Comment :	This Table stores the Route information for a Asn Document.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ASNROT_OUINSTANCE	_decimal_10_0	decimal(10)	No	To specify the OU instance at which the Asn was created.	Yes
ASNROT_ASN_NO	_varchar_40	varchar(40)	No	This field holds the Asn Document Number.	Yes
ASNROT_LOCATION	_varchar_256	varchar(256)	No	This field holds the Location information of the Route.	Yes
ASNROT_SEQNO	_decimal_10_0	decimal(10)	Yes	Holds the Sequence Number of the Route created for the Asn Number.	No
ASNROT_SHIPMENT_STATUS	_varchar_25	Varchar(25)	Yes	This field holds the Shipment Status in a Route for the Asn Number. "YTR" - "Yet To Receive", "YTS" - "Yet To Ship", "SHI" - "Shipped".	No
ASNROT_SCH_ARRIVAL_DATE	_datetime_8	datetime(8)	Yes	This field holds the Schedule Arrival date of a particular route.	No
ASNROT_SPECIFIED_SHIP_DATE	_datetime_8	datetime(8)	Yes	This field holds the Ship date of a particular route.	No
ASNROT_CARRIER_AGENCY	_varchar_20	varchar(20)	Yes	This field holds the Carrier or Agency Number of a particular route.	No
ASNROT_ROUTE_DOC_NO	_varchar_40	varchar(40)	Yes	This field holds the Route Document Number of a particular route.	No
ASNROT_INSTRUCTIONS	_varchar_255	varchar(255)	Yes	This field holds the Instruction of a particular route.	No

Table Name :	ASN_PARAMETER_DETAILS
Comment :	This is the Parameter Table for the ASN Component.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ASN_COMPONENTNAME	_varchar_40	varchar(40)	No	This stores the Component Name	Yes
ASN_PARAMCATEGORY	_varchar_40	varchar(40)	No	Stores the Parameter s category	Yes
ASN_PARAMTYPE	_varchar_40	varchar(40)	No	Stores the Parameter s Type	Yes
ASN_PARAMCODE	_varchar_5	varchar(5)	No	Stores the Parameter s code	Yes
ASN_PARAMDESC	_varchar_40	varchar(40)	Yes	Stores the Parameter s Desc	No
ASN_LANGID	_decimal_10_0	decimal(10)	No	Stores the Parameter s LanguageId	Yes
ASN_CREATIONDATE	_datetime_8	datetime(8)	Yes	Stores the Parameter s Creation date.	No
ASN_SORTBY	_decimal_10_0	decimal(10)	Yes	Stores the Parameter s Sorting order	No