Advance Shipping Note |
| |||||
|
|
||||||
|
Table Name asn_asndet_asn_detail |
|
|||||
|
|
||||||
|
Table Comment This is the Detail table which stores the Ref Doc information which is associated with the Asn Document. |
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
asndet_ouinstance |
numeric(10) |
NOT NULL |
This field holds the OU information in which the Asn Document is Created. |
Yes |
Yes |
|
|
asndet_asn_no |
varchar(40) |
NOT NULL |
This field holds the Asn Document Number. |
Yes |
Yes |
|
|
asndet_ref_doc |
varchar(5) |
NOT NULL |
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 |
No |
|
|
asndet_ref_doc_no |
varchar(40) |
NOT NULL |
This Field holds the Ref Document Number which is associated with the Asn Number. |
Yes |
No |
|
|
asndet_part_no |
varchar(40) |
NOT NULL |
This field holds the Part No mapped to the Ref Doc no of the Asn Document. |
Yes |
No |
|
|
asndet_qty_in_transit |
numeric(28,8) |
NULL |
This field holds the no of quantity of the Part in transit. |
No |
No |
|
|
asndet_uom |
varchar(10) |
NULL |
This field holds the Unit of measurement for the quantity of the Part which is mapped to the Ref Doc number. |
No |
No |
|
|
asndet_palete_rack_cont |
varchar(40) |
NULL |
This holds the Palette/Rack/Container Number of the Part which is associated with the Ref Doc Number. |
No |
No |
|
|
asndet_comment |
varchar(255) |
NULL |
This field holds the comments about the Part which is mapped to the Ref Doc number. |
No |
No |
|
|
|
||||||
|
Table Name asn_asnhdr_asn_header |
|
|||||
|
|
||||||
|
Table Comment This is the Header table which stores the Advance Shipping Note Information. |
|
|||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
asnhdr_ouinstance |
numeric(10) |
NOT NULL |
This field holds the OU information in which the Asn Document is Created. |
Yes |
No |
|
|
asnhdr_asn_no |
varchar(40) |
NOT NULL |
This field holds the Asn Number. |
Yes |
No |
|
|
asnhdr_num_type_no |
varchar(5) |
NULL |
This Field Holds the Numbering Type of the Asn Number. |
No |
No |
|
|
asnhdr_asn_date |
datetime |
NULL |
This field holds the Asn Date. |
No |
No |
|
|
asnhdr_asn_status |
varchar(5) |
NULL |
This Field holds the Asn Status. "F" - "Fresh. |
No |
No |
|
|
asnhdr_supplier |
varchar(45) |
NULL |
This Field Holds the Supplier Number which is Associated with the Asn Number. |
No |
No |
|
|
asnhdr_supp_asn_no |
varchar(40) |
NULL |
Specifies the Supplier Asn Number. |
No |
No |
|
|
asnhdr_suppasn_date |
datetime |
NULL |
Holds the Supplier Asn date. |
No |
No |
|
|
asnhdr_way_bill_no |
varchar(40) |
NULL |
Holds the Way bill number of the Advance Shipping Note. |
No |
No |
|
|
asnhdr_asn_sent_by |
varchar(5) |
NULL |
Holds the information by which the Asn is Sent as "C " - "Carrier", "S" - "Supplier", "B" - "Blank" |
No |
No |
|
|
asnhdr_exp_date_of_del |
datetime |
NULL |
Holds the Expected Date of Delivery for the Asn Number. |
No |
No |
|
|
asnhdr_carrier_agency |
varchar(20) |
NULL |
Specifies the Carrier or Agency Number for the Asn Number. |
No |
No |
|
|
asnhdr_shipped_by |
varchar(25) |
NULL |
Specifies the Shipping Method Associated with Asn Number. |
No |
No |
|
|
asnhdr_inco_term |
varchar(150) |
NULL |
Holds the Inco Term which will be Associated with the Asn Number. |
No |
No |
|
|
asnhdr_origin |
varchar(256) |
NULL |
Holds the Origin information associated with a Asn Document. |
No |
No |
|
|
asnhdr_destination |
varchar(256) |
NULL |
Holds the Destination information associated with a Asn Document. |
No |
No |
|
|
asnhdr_insurance_terms |
varchar(150) |
NULL |
Holds the Insurance Terms Associated with the Asn Number. |
No |
No |
|
|
asnhdr_insurance_liability |
varchar(5) |
NULL |
Holds the Insurance Liability Associated with the Asn Number. "B" - "Blank", "SUP" - "Supplier", "SLF" - "Self", "OTH" - "Others". |
No |
No |
|
|
asnhdr_trans_shipment |
varchar(5) |
NULL |
Holds the Trans Shipment value as "Y" - "Yes" and "N"- No for a Asn Number, "B" - "Blank". |
No |
No |
|
|
asnhdr_supp_invoice_no |
varchar(40) |
NULL |
Holds the Supplier Invoice Number associated with ASN Number. |
No |
No |
|
|
asnhdr_invoice_amount |
numeric(28,8) |
NULL |
Holds the Invoice Amount of the ASN Number. |
No |
No |
|
|
asnhdr_invoice_currency |
varchar(20) |
NULL |
Holds the Invoice Currency associated with the Invoice Amount of the Asn Number. |
No |
No |
|
|
asnhdr_freight_amount |
numeric(28,8) |
NULL |
Holds the Freight Amount Associated with the Asn Number. |
No |
No |
|
|
asnhdr_freight_currency |
varchar(20) |
NULL |
Holds the Freight Currency Associated with the Asn Number. |
No |
No |
|
|
asnhdr_created_by |
varchar(30) |
NULL |
Holds the Asn created User name. |
No |
No |
|
|
asnhdr_createddate |
datetime |
NULL |
Holds the Asn created Date. |
No |
No |
|
|
asnhdr_modified_by |
varchar(30) |
NULL |
Holds the Asn Modified User name. |
No |
No |
|
|
asnhdr_modifieddate |
datetime |
NULL |
Holds the modified Date of the Asn number. |
No |
No |
|
|
asnhdr_timestamp |
numeric(10) |
NULL |
Holds the timestamp value for the Asn Number. |
No |
No |
|
|
|
||||||
|
Table Name asn_asnrot_asn_route_plan |
|
|||||
|
|
||||||
|
Table Comment This Table stores the Route information for a Asn Document. |
|
|||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
asnrot_ouinstance |
numeric(10) |
NOT NULL |
To specify the OU instance at which the Asn was created. |
Yes |
Yes |
|
|
asnrot_asn_no |
varchar(40) |
NOT NULL |
This field holds the Asn Document Number. |
Yes |
Yes |
|
|
asnrot_location |
varchar(256) |
NOT NULL |
This field holds the Location information of the Route. |
Yes |
No |
|
|
ASNROT_SEQNO |
numeric(10) |
NULL |
Holds the Sequence Number of the Route created for the Asn Number. |
No |
No |
|
|
asnrot_shipment_status |
varchar(25) |
NULL |
This field holds the Shipment Status in a Route for the Asn Number. "YTR" - "Yet To Receive", "YTS" - "Yet To Ship", "SHI" - "Shipped". |
No |
No |
|
|
asnrot_sch_arrival_date |
datetime |
NULL |
This field holds the Schedule Arrival date of a particular route. |
No |
No |
|
|
asnrot_specified_ship_date |
datetime |
NULL |
This field holds the Ship date of a particular route. |
No |
No |
|
|
asnrot_carrier_agency |
varchar(20) |
NULL |
This field holds the Carrier or Agency Number of a particular route. |
No |
No |
|
|
asnrot_route_doc_no |
varchar(40) |
NULL |
This field holds the Route Document Number of a particular route. |
No |
No |
|
|
asnrot_instructions |
varchar(255) |
NULL |
This field holds the Instruction of a particular route. |
No |
No |
|
|
|
||||||
|
Table Name asn_parameter_details |
|
|||||
|
|
||||||
|
Table Comment This is the Parameter Table for the ASN Component. |
|
|||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
asn_componentname |
varchar(40) |
NOT NULL |
This stores the Component Name |
Yes |
No |
|
|
asn_paramcategory |
varchar(40) |
NOT NULL |
Stores the Parameter’s category |
Yes |
No |
|
|
asn_paramtype |
varchar(40) |
NOT NULL |
Stores the Parameter’s Type |
Yes |
No |
|
|
asn_paramcode |
varchar(5) |
NOT NULL |
Stores the Parameter’s code |
Yes |
No |
|
|
asn_langid |
numeric(10) |
NOT NULL |
Stores the Parameter’s Language Id |
Yes |
No |
|
|
asn_paramdesc |
varchar(40) |
NULL |
Stores the Parameter’s Desc. |
No |
No |
|
|
asn_creationdate |
datetime |
NULL |
Stores the Parameter’s Creation date. |
No |
No |
|
|
asn_sortby |
numeric(10) |
NULL |
Stores the Parameter’s Sorting order |
No |
No |
|
|
|
|
|
|
|
|
|