Powered by InfoCaptor


Previous Page   Next Page

Inbound Shipments
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.POFG_INBOUND_SHIPMENTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Asn Type Inbound Shipments.Asn TypeASN_TYPEASN_TYPE275894
Bill Of Lading Number Inbound Shipments.Bill Of Lading NumberBILL_OF_LADING_NUMBERBILL_OF_LADING_NUMBER119836
Carrier Inbound Shipments.CarrierCARRIERCARRIER121566
Carrier Description Inbound Shipments.Carrier DescriptionCARRIER_DESCRIPTIONCARRIER_DESCRIPTION121579
CommentsFree form text/comments.Inbound Shipments.CommentsCOMMENTSCOMMENTS122593
Container QuantityNumber of containersInbound Shipments.Container QuantityCONTAINER_QUANTITYCONTAINER_QUANTITY123258
Created By Inbound Shipments.Created ByCREATED_BYCREATED_BY125220
Created Date Inbound Shipments.Created DateCREATED_DATECREATED_DATE125395
Created Date - Day Inbound Shipments.Created Date CREATED_DATE_DAY171213
Created Date - Month Inbound Shipments.Created Date CREATED_DATE_MONTH171367
Created Date - Quarter Inbound Shipments.Created Date CREATED_DATE_QUARTER171521
Created Date - Year Inbound Shipments.Created Date CREATED_DATE_YEAR171675
CurrencyThe currency for an account balance.Inbound Shipments.CurrencyCURRENCYCURRENCY126949
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Inbound Shipments.Currency CodeCURRENCY_CODECURRENCY_CODE127050
Currency Conversion RateThe currency exchange rate.Inbound Shipments.Currency Conversion RateCURRENCY_CONVERSION_RATECURRENCY_CONVERSION_RATE127114
Currency Conversion Rate DateForeign currency exchange rate date specified in an Advance Shipment and Billing Notice (ASBN)Inbound Shipments.Currency Conversion Rate DateCURRENCY_CONVERSION_RATE_DATECURRENCY_CONVERSION_RATE_DATE127135
Currency Conversion Rate Date - Day Inbound Shipments.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_DAY174014
Currency Conversion Rate Date - Month Inbound Shipments.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_MONTH174054
Currency Conversion Rate Date - Quarter Inbound Shipments.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_QUARTER174094
Currency Conversion Rate Date - Year Inbound Shipments.Currency Conversion Rate Date CURRENCY_CONVERSION_RATE_DATE_YEAR174134
Currency Conversion Rate Type Inbound Shipments.Currency Conversion Rate TypeCURRENCY_CONVERSION_RATE_TYPECURRENCY_CONVERSION_RATE_TYPE127155
Electronic Data Interchange Transaction Control NumberElectronic Data Interchange (EDI) transaction control numberInbound Shipments.Electronic Data Interchange Transaction Control NumberEDI_TXN_CONTROL_NUMBEREDI_TXN_CONTROL_NUMBER130738
Electronic Data Interchange Transaction Creation DateElectronic Data Interchange (EDI) transaction creation dateInbound Shipments.Electronic Data Interchange Transaction Creation DateEDI_TXN_CREATION_DATEEDI_TXN_CREATION_DATE130739
Electronic Data Interchange Transaction Creation Date - Day Inbound Shipments.Electronic Data Interchange Transaction Creation Date EDI_TXN_CREATION_DATE_DAY176461
Electronic Data Interchange Transaction Creation Date - Month Inbound Shipments.Electronic Data Interchange Transaction Creation Date EDI_TXN_CREATION_DATE_MONTH176463
Electronic Data Interchange Transaction Creation Date - Quarter Inbound Shipments.Electronic Data Interchange Transaction Creation Date EDI_TXN_CREATION_DATE_QUARTER176465
Electronic Data Interchange Transaction Creation Date - Year Inbound Shipments.Electronic Data Interchange Transaction Creation Date EDI_TXN_CREATION_DATE_YEAR176467
Expected Receipt Date Inbound Shipments.Expected Receipt DateEXPECTED_RECEIPT_DATEEXPECTED_RECEIPT_DATE133970
Expected Receipt Date - Day Inbound Shipments.Expected Receipt Date EXPECTED_RECEIPT_DATE_DAY179193
Expected Receipt Date - Month Inbound Shipments.Expected Receipt Date EXPECTED_RECEIPT_DATE_MONTH179195
Expected Receipt Date - Quarter Inbound Shipments.Expected Receipt Date EXPECTED_RECEIPT_DATE_QUARTER179197
Expected Receipt Date - Year Inbound Shipments.Expected Receipt Date EXPECTED_RECEIPT_DATE_YEAR179199
Freight AmountElectronic Data Interchange (EDI) transaction 857 freight amountInbound Shipments.Freight AmountFREIGHT_AMOUNTFREIGHT_AMOUNT134650
Gross Weight Unit Of Measure Inbound Shipments.Gross Weight Unit Of MeasureGROSS_WEIGHT_UNIT_OF_MEASUREGROSS_WEIGHT_UNIT_OF_MEASURE135507
Gross Weight Uom ClassGross Weight Unit of measure ClassInbound Shipments.Gross Weight Uom ClassGROSS_WEIGHT_UOM_CLASSGROSS_WEIGHT_UOM_CLASS135508
Gross Weight Uom DescriptionGross Weight Unit of measure DescriptionInbound Shipments.Gross Weight Uom DescriptionGROSS_WEIGHT_UOM_DESCRIPTIONGROSS_WEIGHT_UOM_DESCRIPTION135509
Invoice AmountElectronic Data Interchange (EDI) transaction 857 invoice amountInbound Shipments.Invoice AmountINVOICE_AMOUNTINVOICE_AMOUNT137375
Invoice DateElectronic Data Interchange (EDI) transaction 857 invoice dateInbound Shipments.Invoice DateINVOICE_DATEINVOICE_DATE137421
Invoice Date - Day Inbound Shipments.Invoice Date INVOICE_DATE_DAY181646
Invoice Date - Month Inbound Shipments.Invoice Date INVOICE_DATE_MONTH181656
Invoice Date - Quarter Inbound Shipments.Invoice Date INVOICE_DATE_QUARTER181666
Invoice Date - Year Inbound Shipments.Invoice Date INVOICE_DATE_YEAR181684
Invoice NumberInvoice number that may be used for identifying the matchingtransaction.Inbound Shipments.Invoice NumberINVOICE_NUMBERINVOICE_NUMBER137470
Invoice Status Inbound Shipments.Invoice StatusINVOICE_STATUSINVOICE_STATUS137484
Last Updated By Inbound Shipments.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139800
Last Updated Date Inbound Shipments.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139974
Last Updated Date - Day Inbound Shipments.Last Updated Date LAST_UPDATED_DATE_DAY182896
Last Updated Date - Month Inbound Shipments.Last Updated Date LAST_UPDATED_DATE_MONTH183058
Last Updated Date - Quarter Inbound Shipments.Last Updated Date LAST_UPDATED_DATE_QUARTER183220
Last Updated Date - Year Inbound Shipments.Last Updated Date LAST_UPDATED_DATE_YEAR183382
Net Weight Unit Of Measure Inbound Shipments.Net Weight Unit Of MeasureNET_WEIGHT_UNIT_OF_MEASURENET_WEIGHT_UNIT_OF_MEASURE148024
Net Weight Uom ClassNet Weight Unit of measure ClassInbound Shipments.Net Weight Uom ClassNET_WEIGHT_UOM_CLASSNET_WEIGHT_UOM_CLASS148025
Net Weight Uom DescriptionNet Weight Unit of measure DescriptionInbound Shipments.Net Weight Uom DescriptionNET_WEIGHT_UOM_DESCRIPTIONNET_WEIGHT_UOM_DESCRIPTION148026
Packing Slip Number Inbound Shipments.Packing Slip NumberPACKING_SLIP_NUMBERPACKING_SLIP_NUMBER151794
Payment Terms IDUnique identifier for Payment TermsInbound Shipments.Payment Terms IDPAYMENT_TERMS_IDPAYMENT_TERMS_ID152264
Payment Terms Name Inbound Shipments.Payment Terms NamePAYMENT_TERMS_NAMEPAYMENT_TERMS_NAME152280
Rate Type Description Inbound Shipments.Rate Type DescriptionRATE_TYPE_DESCRIPTIONRATE_TYPE_DESCRIPTION157640
Rate Type Name Inbound Shipments.Rate Type NameRATE_TYPE_NAMERATE_TYPE_NAME157655
Receipt Number Inbound Shipments.Receipt NumberRECEIPT_NUMBERRECEIPT_NUMBER158020
Receiver Employee Number Inbound Shipments.Receiver Employee NumberRECEIVER_EMPLOYEE_NUMBERRECEIVER_EMPLOYEE_NUMBER158051
Receiver IDUnique identifier for ReceiverInbound Shipments.Receiver IDRECEIVER_IDRECEIVER_ID158053
Receiver Name Inbound Shipments.Receiver NameRECEIVER_NAMERECEIVER_NAME158055
Ship To Location Inbound Shipments.Ship To LocationSHIP_TO_LOCATIONSHIP_TO_LOCATION161918
Ship To Location IDUnique identifier for Ship To LocationInbound Shipments.Ship To Location IDSHIP_TO_LOCATION_IDSHIP_TO_LOCATION_ID161945
Shipment Gross Weight Inbound Shipments.Shipment Gross WeightSHIPMENT_GROSS_WEIGHTSHIPMENT_GROSS_WEIGHT161659
Shipment IDUnique identifier for ShipmentInbound Shipments.Shipment IDSHIPMENT_IDSHIPMENT_ID161661
Shipment Net Weight Inbound Shipments.Shipment Net WeightSHIPMENT_NET_WEIGHTSHIPMENT_NET_WEIGHT161675
Shipment Number Inbound Shipments.Shipment NumberSHIPMENT_NUMBERSHIPMENT_NUMBER161682
Shipment Source Inbound Shipments.Shipment SourceSHIPMENT_SOURCESHIPMENT_SOURCE275893
Shipping Date Inbound Shipments.Shipping DateSHIPPING_DATESHIPPING_DATE161748
Shipping Date - Day Inbound Shipments.Shipping Date SHIPPING_DATE_DAY190442
Shipping Date - Month Inbound Shipments.Shipping Date SHIPPING_DATE_MONTH190444
Shipping Date - Quarter Inbound Shipments.Shipping Date SHIPPING_DATE_QUARTER190446
Shipping Date - Year Inbound Shipments.Shipping Date SHIPPING_DATE_YEAR190448
Source Organization Code Inbound Shipments.Source Organization CodeSOURCE_ORGANIZATION_CODESOURCE_ORGANIZATION_CODE162480
Source Organization IDUnique identifier for Source OrganizationInbound Shipments.Source Organization IDSOURCE_ORGANIZATION_IDSOURCE_ORGANIZATION_ID162499
Source Organization Name Inbound Shipments.Source Organization NameSOURCE_ORGANIZATION_NAMESOURCE_ORGANIZATION_NAME162516
Supplier IDUnique identifier for SupplierInbound Shipments.Supplier IDSUPPLIER_IDSUPPLIER_ID164210
Supplier Name Inbound Shipments.Supplier NameSUPPLIER_NAMESUPPLIER_NAME164254
Tax AmountElectronic Data Interchange (EDI) transaction 857 tax amountInbound Shipments.Tax AmountTAX_AMOUNTTAX_AMOUNT164698
Tax Name Inbound Shipments.Tax NameTAX_NAMETAX_NAME164778
US Standard GL Transaction CodeTransaction code for creating US standard General Ledger journal entries (Oracle Public Sector Payables).Inbound Shipments.US Standard GL Transaction CodeUSSGL_TRANSACTION_CODEUSSGL_TRANSACTION_CODE167053
Waybill Airbill Number Inbound Shipments.Waybill Airbill NumberWAYBILL_AIRBILL_NUMBERWAYBILL_AIRBILL_NUMBER167719
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto